import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class jdbcserv extends HttpServlet {
PrintWriter f;
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException,IOException {
res.setContentType("text/text");
ServletOutputStream out = res.getOutputStream();
try
{
f=new PrintWriter(new FileWriter("XMLfile.xml"));
}catch(Exception fn){}
out.println("");
out.println("XML DOCUMENTS");
out.println("");
f.println("");
f.println("");
f.println("");
f.println("");
f.println("");
f.println("");
f.println("");
f.println("");
f.println("]>");
// f.println("");
String sql="Select * from jdbctest";
String url = "jdbc:odbc:XXX";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(url,"MyLoginName","MyPassword");
Statement stmt =con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int col = rsmd.getColumnCount();
f.println("");
f.println("");
f.println("XML Servlet");
f.println("");
f.println("");
while (rs.next())
{
f.println("");
for(int j = 1;j<=col; j++)
{
String colName = rsmd.getColumnName(j);
String s = rs.getString(j);
f.println("<"+ colName +">");
f.println(s + " ");
f.println("");
}
f.println("");
}
f.println("");
f.println("");
f.close();
out.println("");
out.println("");
stmt.close();
con.close();
} catch(Exception ioe){ }
} public String getServletInfo()
{ return "Here is the Servlet!"; }
}