Posted by:ABI
Posted on:2002-12-28 02:04
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class servletcon extends HttpServlet
{
public void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException
{
resp.setContentType("text/html");
PrintWriter out = new PrintWriter(resp.getOutputStream());
try
{
out.println("");
out.println("
aaa");out.println("
");Class.forName("allaire.jrun.jdbc.JRunDriver");
Connection conn =DriverManager.getConnection("jdbc:jrun:sqlserver://127.0.0.1:1433;databaseName=test","sa", "");
Statement stmt=conn.createStatement();
String strSQL="Begin use fancy SELECT goodstype FROM goods end";
ResultSet rs=stmt.executeQuery(strSQL);
out.println ("
while(rs.next())
{
String str=rs.getString("goodstype");
byte[] str1 =str.getBytes("gb2312");
str=new String(str1);
out.println("类别:"+str+"
");
}
out.println("
");}
catch (Exception fe)
{
out.println(fe.getMessage());
}
out.println("");
out.println("");
out.close();
}
}