listservlet.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 ListServlet 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 ";
       Connection conn = null;
       PreparedStatement stmt = null;
       ResultSet rs = null;
       String address = "unknownlist.jsp";
       //创建JavaBean对象
       listbean list = new listbean();
       try
       {
            //获取数据库连接
            conn = DBUtil.getConnection();
            stmt = conn.prepareStatement(SQL);
          //指定参数
            stmt.setString(2,request.getParameter("name"));
            
            //执行查询
            rs = stmt.executeQuery();
            
           while(rs.next())
           {        
               
                //改变JavaBean中的属性
                list.setId(rs.getInt("id"));
                list.setName(rs.getString("name"));
                list.setPhone(rs.getString("phone"));
                list.setMobile(rs.getString("mobile"));
                list.setAddress(rs.getString("address"));
                list.setEmail(rs.getString("mail"));
                list.setQq(rs.getString("qq"));
                address = "login_success.jsp";
           }
        }
        catch(SQLException e)
        {
        }
        
        
     
    	
       //清理 
       DBUtil.closeResultSet(rs);
       DBUtil.closeConnection(conn);
       //将JavaBean放到request作用域中
       request.setAttribute("listbean",list);
       //跳转到JSP页面
       RequestDispatcher dis = request.getRequestDispatcher(address);
       dis.forward(request,response);
    } 
    public void doPost(HttpServletRequest request,
            HttpServletResponse response)
            throws ServletException,IOException
            {
    	         doGet(request,response);
            }
}