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.helpers.DefaultHandler;

import javax.xml.parsers.SAXParserFactory;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.parsers.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.println("Usage: cmd filename");
System.exit(1);
}
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:virtual ");
Statement st=con.createStatement();
}
catch(Exception e)
{
System.out.println(e);
}
rr=1;
sql="create table ";


DefaultHandler handler = new xmltodb();

SAXParserFactory factory = SAXParserFactory.newInstance();
try {

out = new OutputStreamWriter(System.out, "UTF8");


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

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

static private Writer out;





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

public void endDocument()
throws SAXException
{
try {
sql=sql+")";
System.out.println("\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(String namespaceURI,
String lName,
String qName,
Attributes attrs)
throws SAXException
{
String eName = lName;
if ("".equals(eName)) eName = qName;
if(rr==1)
{
tab=eName;
sql=sql+tab+" (";
newt=true;
fff=0;
beg=true;
}
else
{
if (attrs != null) {
if(attrs.getLength()==0 && newt)
{
rec=eName;
}
for (int i = 0; i < attrs.getLength(); i++) {
String aName = attrs.getLocalName(i);
if ("".equals(aName)) aName = attrs.getQName(i);
if(newt && beg)
{
if(aName.equals("type"))
{
String val=attrs.getValue(i);
if(val.equals("Text")) val="VARCHAR";
if(fff!=0) sql=sql+", ";
sql=sql+eName+" "+val;
fff++;
}
}
else
{
newt=false;
}
}
}
}
rr++;
}

public void endElement(String namespaceURI,
String sName,
String qName
)
throws SAXException
{
if("".equals(sName)) 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.getProperty("line.separator");
try {
out.write(lineEnd);
} 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.helpers.DefaultHandler;

import javax.xml.parsers.SAXParserFactory;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.parsers.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.println("Usage: cmd filename");
System.exit(1);
}
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:virtual ");
Statement st=con.createStatement();
}
catch(Exception e)
{
System.out.println(e);
}
rr=1;
sql="create table ";


DefaultHandler handler = new xmltodb();

SAXParserFactory factory = SAXParserFactory.newInstance();
try {

out = new OutputStreamWriter(System.out, "UTF8");


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

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

static private Writer out;





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

public void endDocument()
throws SAXException
{
try {
sql=sql+")";
System.out.println("\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(String namespaceURI,
String lName,
String qName,
Attributes attrs)
throws SAXException
{
String eName = lName;
if ("".equals(eName)) eName = qName;
if(rr==1)
{
tab=eName;
sql=sql+tab+" (";
newt=true;
fff=0;
beg=true;
}
else
{
if (attrs != null) {
if(attrs.getLength()==0 && newt)
{
rec=eName;
}
for (int i = 0; i < attrs.getLength(); i++) {
String aName = attrs.getLocalName(i);
if ("".equals(aName)) aName = attrs.getQName(i);
if(newt && beg)
{
if(aName.equals("type"))
{
String val=attrs.getValue(i);
if(val.equals("Text")) val="VARCHAR";
if(fff!=0) sql=sql+", ";
sql=sql+eName+" "+val;
fff++;
}
}
else
{
newt=false;
}
}
}
}
rr++;
}

public void endElement(String namespaceURI,
String sName,
String qName
)
throws SAXException
{
if("".equals(sName)) 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.getProperty("line.separator");
try {
out.write(lineEnd);
} 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