Java - Servlet入门教程 

32

成绩查询

输入姓名:

根据分数查询名单:
英语分数在

数学分数在

图7.18 使用servlet查询数据库

负责查询的servlet源文件： Inquire.java:

33

import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*;

public class Inquire extends HttpServlet

{ public void init(ServletConfig config) throws ServletException {super.init(config); }

//通过Post方法按名字查询记录：

public void doPost(HttpServletRequest request,HttpServletResponse response)

throws ServletException,IOException { PrintWriter out=response.getWriter();

response.setContentType(\MIME类型。

out.println(\ out.println(\ //获取提交的姓名：

String name=request.getParameter(\ String number,xingming; Connection con=null; Statement sql=null; ResultSet rs=null; int math,english,physics;

try{Class.forName(\ }

catch(ClassNotFoundException e){} try

{ con=DriverManager.getConnection(\ sql=con.createStatement();

String condition=\\

rs=sql.executeQuery(condition); out.print(\ out.print(\

out.print(\ out.print(\ out.print(\

34

out.print(\ out.print(\ out.print(\ while(rs.next())

{ out.print(\ number=rs.getString(1);

out.print(\ xingming=rs.getString(2);

out.print(\ math=rs.getInt(\ out.print(\ english=rs.getInt(\ out.print(\ physics=rs.getInt(\ out.print(\ out.print(\ }

out.print(\ con.close(); }

catch(SQLException e) { }

out.println(\ out.println(\ }

//通过Get方法按成绩查询记录：

public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException { PrintWriter out=response.getWriter();

response.setContentType(\MIME类型。

out.println(\ out.println(\

//获取提交的分数的最大值和最小值：

String englishmax=request.getParameter(\ String englishmin=request.getParameter(\ String mathmax=request.getParameter(\

35