import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class TestServlet extends HttpServlet{
Connection dbConnection;
ServletContext context;
public void init() {
context = getServletContext();
dbConnection = (Connection)context.getAttribute("connection");
}
public void service(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, java.io.IOException
{
response.setContentType("text/html;charset=gbk");
PrintWriter out = response.getWriter();
out.println("");
out.println("");
out.println("");
out.println("");
out.println("
查询结果如下
");
out.println("
");
try{
String sql="select * from books";
Statement stmt = dbConnection.createStatement();
ResultSet rst = stmt.executeQuery(sql);
while(rst.next()){
out.println(""+rst.getString(1)+" | ");
out.println(""+rst.getString(2)+" | ");
out.println(""+rst.getString(4)+" | ");
out.println(""+rst.getFloat(5)+" | ");
out.println(""+rst.getInt(6)+" |
");
}
}catch(SQLException e){
out.println();
}
out.println("
");
out.println("");
out.println("");
}
public void destroy(){
}
}