import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class user extends HttpServlet{
public void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html");
resp.setCharacterEncoding("GB2312");
PrintWriter out=resp.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>学生信息表</title>");
out.println("</head>");
out.println("<body>");
out.println("<br>");
out.println("<table border=1 align=center bgcolor=#ffdddd >");
out.println("<caption>成绩表</caption>");
out.println("<tr align=center valign=middle>");
out.println("<th>id</th>");
out.println("<th>name</th>");
out.println("<th>writer</th>");
out.println("<th>lab</th>");
out.println("</tr>");
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://Localhost:1433;DatabaseName=student";
String user="sa";
String password="sa";
java.sql.Connection con=DriverManager.getConnection(url,user,password);
String sql="select * from SCORE";
PreparedStatement ps=con.prepareStatement(sql);
ResultSet rs=ps.executeQuery();
while(rs.next()){
String id=rs.getString("NameID");
String name=rs.getString("name");
float writtenExam=rs.getFloat("WrittenExam");
float labExam=rs.getFloat("LabExam");
out.println("<tr align=center valign=middle>");
out.println("<td>"+id+"</td>");
out.println("<td>"+name+"</td>");
out.println("<td>"+writtenExam+"</td>");
out.println("<td>"+labExam+"</td>");
out.println("</tr>");
}
rs.close();
ps.close();
con.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
out.println("</table>");
out.println("</body>");
out.println("</html>");
}
}
##
注:如果运行不成功,请检察tomcat下的classpath路径,把JDBC的3个驱动包复制到相应的lib目录下。