searchservlet.java

java+oracle实现学生管理系统 学生信息的增删改查

package list.servlet;

import java.sql.*;

import java.io.*;

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

import data.DBUtil;
import bean.listbean;

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 addrestlist where name like '%'||?||'%'";
       Connection conn = null;
       PreparedStatement stmt = null;
       ResultSet rs = null;

       String address = "unknownlist.jsp";
       //创建JavaBean对象
       listbean book = new listbean();
       try
       {
            //获取数据库连接
            conn = DBUtil.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 = "SearchShow.jsp";
           }
        }
        catch(SQLException e)
        {
        }
       //清理 
       DBUtil.closeResultSet(rs);
       DBUtil.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);
    	     }
}