桂电信科J2EE程序设计 实验三　Jsp+JavaBean+Servlet登陆模块实现

package com.test.register; import java.io.IOException; import java.sql.*; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.test.DB.DBAccess; import com.test.login.*; public class register extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException { response.setContentType("text/html"); response.setCharacterEncoding("GBK"); String id=request.getParameter("id"); String name=request.getParameter("name"); String password=request.getParameter("pass"); String age=request.getParameter("age"); String address=request.getParameter("address"); user u=new user(); u.setaddress(address); u.setage(age); u.setid(id); u.setname(name); u.setpassword(password); Statement stm=null; int res=0; DBAccess db=new DBAccess(); Connection conn=db.getConn(); try { String sql="insert into user (id,name,password,age,address) values ('"+u.getid()+"','"+u.getname()+"','"+u.getpassword()+"','"+u.getage()+"','"+u.getaddress()+"')"; stm=conn.createStatement(); res=stm.executeUpdate(sql); } catch (SQLException e) { // TODO: handle exception e.printStackTrace(); } RequestDispatcher rd=request.getRequestDispatcher("/login.jsp"); rd.forward(request, response); } }