期末javaweb的一个项目

package edu.njpi.info.soft; import java.io.IOException; import java.io.PrintWriter; import java.sql.*; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; /** * Servlet implementation class InfoServlet */ @WebServlet("/InfoServlet") public class InfoServlet extends HttpServlet { private String username; private String password; private String sex; private String email; private String phone; private String classes; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setHeader("Content-type", "text/html;charset=UTF-8"); response.setCharacterEncoding("UTF-8"); //获取数据 String username=request.getParameter("username"); String password=request.getParameter("password"); String password2=request.getParameter("password2"); String email=request.getParameter("email"); String code=request.getParameter("code"); String sex=request.getParameter("sex"); String classes=request.getParameter("classes"); String phone=request.getParameter("phone"); RegisterFormBean formBean=new RegisterFormBean(); formBean.setUsername(username); formBean.setPassword(password); formBean.setPassword2(password2); formBean.setEmail(email); formBean.setCode(code); formBean.setSex(sex); formBean.setClasses(classes); formBean.setPhone(phone); if(!formBean.validate()){ request.setAttribute("formBean", formBean); request.getRequestDispatcher("/register.jsp").forward(request, response); return; } User user=new User(); user.setUsername(username); user.setPassword(password); user.setEmail(email); user.setPhone(phone); user.setClasses(classes); user.setSex(sex); // if(new User().save(user)){ // request.setAttribute("DBMes", "你注册的用户已存在!"); // request.setAttribute("formBean", formBean); // request.getRequestDispatcher("/register.jsp").forward(request, response); // return; // } response.getWriter().print("恭喜你已成功注册，3秒钟自动跳转"); request.getSession().setAttribute("user", user); response.setHeader("refresh", "3;url=LoginSuccess.jsp"); //request.setCharacterEncoding("utf-8"); String JDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";//SQL数据库引擎 String connectDB="jdbc:sqlserver://localhost:1433;DatabaseName=test4";//数据源 try { Class.forName(JDriver);//加载数据库引擎，返回给定字符串名的类 }catch(ClassNotFoundException e) { //e.printStackTrace(); System.out.println("加载数据库引擎失败"); System.exit(0); } System.out.println("数据库驱动成功"); try{ String users; String pwd; Connection con=DriverManager.getConnection(connectDB,"sa","123456");//连接数据库对象 System.out.println("连接数据库成功"); Statement stmt=con.createStatement();//创建SQL命令对象 //创建表 //输入数据 System.out.println("开始插入数据"); //插入数据SQL语句 String s1="INSERT INTO tbl_user(username,password,email,sex,phone,classes) VALUES('"+username+"','"+password+"','"+email+"','"+sex+"','"+phone+"','"+classes+"')"; stmt.executeUpdate(s1);//执行SQL命令对象 System.out.println("插入数据成功"); //读取数据 System.out.println("开始读取数据"); ResultSet rs=stmt.executeQuery("SELECT * FROM tbl_user");//返回SQL语句查询结果集(集合) //循环输出每一条记录 while(rs.next()) { //输出每个字段 password=rs.getString("password"); username = rs.getString("username"); classes = rs.getString("classes"); sex=rs.getString("sex"); email=rs.getString("email"); phone=rs.getString("phone"); System.out.println("\tpassword:" + password + "\tuserame:" + username + "\tclasses:" +classes+"\tsex:"+sex +"\temail:"+email+"\tphone:"+phone); } System.out.println("读取完毕"); //关闭连接 stmt.close();//关闭命令对象连接 con.close();//关闭数据库连接 } catch(SQLException e) { e.printStackTrace(); //System.out.println("数据库连接错误"); System.exit(0); } } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); // // //定义输出流 // PrintWriter out = response.getWriter(); // //获取前端页面输入数据 // String username = request.getParameter("username"); // //测试打印，测试接收前台数据是否成功 // System.out.println(username); // //进行比较并作出响应。 // if(username==null || username.equals("")) { // out.println("请输入用户名 "); // } else if("sa".equals(username)) { // out.println("该用户名已经存在"); // } else { // out.println("可以注册"); // } } }