Convert This Java Code To Jsp Code

[mjahabarsadiq]

HELLO FRIENDS

I HAVE ONE JAVA CODE WHICH PARSES AN XML FILE AND PRODUCE A QUERY TO CREATE TABEL IN A DATABASE.

BUT I NEED THE CODE TO BE USED IN A JSP PAGE.

HOW TO USE THIS PAGE WITH JSP.

I AM USING TOMCAT 4.1 WEBSERVER FOR COMPILING JSP PAGES.

WHETHER IT SUPPORT JAVA BEANS WITH JSP OR NOT..



THE CODE IS AS FOLLOWS


import java.io.*;

import org.xml.sax.*;
import org.xml.sax.hel pers.DefaultHan dler;

import javax.xml.parse rs.SAXParserFac tory;
import javax.xml.parse rs.ParserConfig urationExceptio n;
import javax.xml.parse rs.SAXParser;
import java.sql.*;

public class xmltodb extends DefaultHandler
{
static int rr;
static String sql,tab,rec;
static Connection con;
static Statement st;
static ResultSet rs;
static boolean newt, beg;
static int fff;
public static void main(String argv[])
{
if (argv.length != 1) {
System.err.prin tln("Usage: cmd filename");
System.exit(1);
}
try
{
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
Connection con=DriverManag er.getConnectio n("jdbc:odbc:vi rtual");
Statement st=con.createSt atement();
}
catch(Exception e)
{
System.out.prin tln(e);
}
rr=1;
sql="create table ";


DefaultHandler handler = new xmltodb();

SAXParserFactor y factory = SAXParserFactor y.newInstance() ;
try {

out = new OutputStreamWri ter(System.out, "UTF8");


SAXParser saxParser = factory.newSAXP arser();
saxParser.parse ( new File(argv[0]), handler);

} catch (Throwable t) {
t.printStackTra ce();
}
System.exit(0);
}

static private Writer out;





public void startDocument()
throws SAXException
{
nl();
}

public void endDocument()
throws SAXException
{
try {
sql=sql+")";
System.out.prin tln("\n SQL="+sql);
nl();
out.flush();
} catch (IOException e) {
throw new SAXException("I/O error", e);
}
catch(Exception ee){System.out. println(ee);}
}

public void startElement(St ring namespaceURI,
String lName,
String qName,
Attributes attrs)
throws SAXException
{
String eName = lName;
if ("".equals(eNam e)) eName = qName;
if(rr==1)
{
tab=eName;
sql=sql+tab+" (";
newt=true;
fff=0;
beg=true;
}
else
{
if (attrs != null) {
if(attrs.getLen gth()==0 && newt)
{
rec=eName;
}
for (int i = 0; i < attrs.getLength (); i++) {
String aName = attrs.getLocalN ame(i);
if ("".equals(aNam e)) aName = attrs.getQName( i);
if(newt && beg)
{
if(aName.equals ("type"))
{
String val=attrs.getVa lue(i);
if(val.equals(" Text")) val="VARCHAR";
if(fff!=0) sql=sql+", ";
sql=sql+eName+" "+val;
fff++;
}
}
else
{
newt=false;
}
}
}
}
rr++;
}

public void endElement(Stri ng namespaceURI,
String sName,
String qName
)
throws SAXException
{
if("".equals(sN ame)) sName=qName;
if(sName.equals (tab)) newt=false;
if(sName.equals (rec)) beg=false;
}

public void characters(char buf[], int offset, int len)
throws SAXException
{
String s = new String(buf, offset, len);
}

private void emit(String s)
throws SAXException
{
try {
out.write(s);
out.flush();
} catch (IOException e) {
throw new SAXException("I/O error", e);
}
}


private void nl()
throws SAXException
{
String lineEnd = System.getPrope rty("line.separ ator");
try {
out.write(lineE nd);
} catch (IOException e) {
throw new SAXException("I/O error", e);
}
}
}



THANKS IN ADVANCE

BY

SADIQ

[r035198x]

HELLO FRIENDS

I HAVE ONE JAVA CODE WHICH PARSES AN XML FILE AND PRODUCE A QUERY TO CREATE TABEL IN A DATABASE.

BUT I NEED THE CODE TO BE USED IN A JSP PAGE.

HOW TO USE THIS PAGE WITH JSP.

I AM USING TOMCAT 4.1 WEBSERVER FOR COMPILING JSP PAGES.

WHETHER IT SUPPORT JAVA BEANS WITH JSP OR NOT..



THE CODE IS AS FOLLOWS


import java.io.*;

import org.xml.sax.*;
import org.xml.sax.hel pers.DefaultHan dler;

import javax.xml.parse rs.SAXParserFac tory;
import javax.xml.parse rs.ParserConfig urationExceptio n;
import javax.xml.parse rs.SAXParser;
import java.sql.*;

public class xmltodb extends DefaultHandler
{
static int rr;
static String sql,tab,rec;
static Connection con;
static Statement st;
static ResultSet rs;
static boolean newt, beg;
static int fff;
public static void main(String argv[])
{
if (argv.length != 1) {
System.err.prin tln("Usage: cmd filename");
System.exit(1);
}
try
{
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
Connection con=DriverManag er.getConnectio n("jdbc:odbc:vi rtual");
Statement st=con.createSt atement();
}
catch(Exception e)
{
System.out.prin tln(e);
}
rr=1;
sql="create table ";


DefaultHandler handler = new xmltodb();

SAXParserFactor y factory = SAXParserFactor y.newInstance() ;
try {

out = new OutputStreamWri ter(System.out, "UTF8");


SAXParser saxParser = factory.newSAXP arser();
saxParser.parse ( new File(argv[0]), handler);

} catch (Throwable t) {
t.printStackTra ce();
}
System.exit(0);
}

static private Writer out;





public void startDocument()
throws SAXException
{
nl();
}

public void endDocument()
throws SAXException
{
try {
sql=sql+")";
System.out.prin tln("\n SQL="+sql);
nl();
out.flush();
} catch (IOException e) {
throw new SAXException("I/O error", e);
}
catch(Exception ee){System.out. println(ee);}
}

public void startElement(St ring namespaceURI,
String lName,
String qName,
Attributes attrs)
throws SAXException
{
String eName = lName;
if ("".equals(eNam e)) eName = qName;
if(rr==1)
{
tab=eName;
sql=sql+tab+" (";
newt=true;
fff=0;
beg=true;
}
else
{
if (attrs != null) {
if(attrs.getLen gth()==0 && newt)
{
rec=eName;
}
for (int i = 0; i < attrs.getLength (); i++) {
String aName = attrs.getLocalN ame(i);
if ("".equals(aNam e)) aName = attrs.getQName( i);
if(newt && beg)
{
if(aName.equals ("type"))
{
String val=attrs.getVa lue(i);
if(val.equals(" Text")) val="VARCHAR";
if(fff!=0) sql=sql+", ";
sql=sql+eName+" "+val;
fff++;
}
}
else
{
newt=false;
}
}
}
}
rr++;
}

public void endElement(Stri ng namespaceURI,
String sName,
String qName
)
throws SAXException
{
if("".equals(sN ame)) sName=qName;
if(sName.equals (tab)) newt=false;
if(sName.equals (rec)) beg=false;
}

public void characters(char buf[], int offset, int len)
throws SAXException
{
String s = new String(buf, offset, len);
}

private void emit(String s)
throws SAXException
{
try {
out.write(s);
out.flush();
} catch (IOException e) {
throw new SAXException("I/O error", e);
}
}


private void nl()
throws SAXException
{
String lineEnd = System.getPrope rty("line.separ ator");
try {
out.write(lineE nd);
} catch (IOException e) {
throw new SAXException("I/O error", e);
}
}
}



THANKS IN ADVANCE

BY

SADIQ

JSPs are used for displaying. Do you want to display the data being printed to the console on a JSP page?
Do you have the J2EE compiler installed together with the server?

[mjahabarsadiq]

I would like to have the output of the java program to be used in the jsp page.

I am having Apache Tom Cat 4.1 Webserver. It compiles the jsp page as well as run it.

By
Sadiq

[anupkossambe]

Quit programming and look for a real job man

[r035198x]

Quit programming and look for a real job man

What's that for? Becareful what you post in the technical forums. This kind of tone is not allowed here.


@OP You can print on a JSP by using

<%=stringVariable%>

or by using the implicitly defined variable out.

Just say

out.println(stringVariable); 

and that out put is sent to the JSP page