searchservlet.java

它统一管理各个应用系统用户的身份验证

package servlet;

import java.sql.*;

import java.io.*;

import javax.servlet.*;
import javax.servlet.http.*;

import bean.DBConnBean;
import bean.StudentBean;

public class SearchServlet extends HttpServlet
{
    public void doGet(HttpServletRequest request,HttpServletResponse response)
                    throws ServletException,IOException
    {  
    	request.setCharacterEncoding("GBK");
        response.setContentType("text/html;charset=GBK");
        final String SQL = "select * from studentinfo where name like ?";
        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;

        String address = "unknownlist.jsp";
        //创建JavaBean对象
        StudentBean book = new StudentBean();
        try
        {
        	//获取数据库连接
        	conn = DBConnBean.getConnection();
        	stmt = conn.prepareStatement(SQL);
        	//指定参数
        	stmt.setString(1,request.getParameter("name"));
        	//执行查询
        	rs = stmt.executeQuery();

        	while(rs.next())
        	{        

        		//改变JavaBean中的属性
        		book.setId(rs.getInt("id"));
        		book.setName(rs.getString("name"));
        		book.setPhone(rs.getString("phone"));
        		book.setMobile(rs.getString("mobile"));
        		book.setAddress(rs.getString("address"));
        		book.setEmail(rs.getString("email"));
        		book.setQq(rs.getString("qq"));
        		address = "searchResult.jsp";
        	}
        }
        catch(SQLException e)
        {
        }
        //清理 
        DBConnBean.closeResultSet(rs);
        DBConnBean.closeConnection(conn);
        //将JavaBean放到request作用域中
        request.setAttribute("listbean",book);
        //跳转到JSP页面
        RequestDispatcher dis = request.getRequestDispatcher(address);
        dis.forward(request,response);
    } 
    public void doPost(HttpServletRequest request,HttpServletResponse response)
    	     throws ServletException,IOException
    	     {
    			doGet(request,response);
    	     }
}