jsp+servlet+jdbc注册登录入门项目

package com.jsict.demo; import java.io.IOException; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.Connection; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.jsict.entity.User; /** * Servlet implementation class login */ @WebServlet("/login") public class login extends HttpServlet { private static final long serialVersionUID = 1L; User user = new User(); /** * @see HttpServlet#HttpServlet() */ public login() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub response.getWriter().append("Served at: ").append(request.getContextPath()); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); request.setCharacterEncoding("UTF-8"); String name = request.getParameter("userName"); String psw = request.getParameter("pwd"); boolean is=false; try { is = isExist(name, psw); } catch (Exception e) { // TODO: handle exception } if (is) { System.out.println(name+"成功"); request.getSession().setAttribute("username", name); request.getSession().setAttribute("pass", psw); request.getSession().setAttribute("email",user.getEmail() ); request.getSession().setAttribute("tel", user.getTel()); request.getSession().setAttribute("address", user.getAddress()); request.getSession().setAttribute("age", user.getAge()); request.getSession().setAttribute("sex", user.getSex()); } else { System.out.println(name+"失败"); request.getSession().setAttribute("username", "未登录"); } response.sendRedirect("content.jsp"); } private boolean isExist(String name,String pwd) throws Exception{ Connection connection = null; PreparedStatement statement = null; ResultSet rs = null; //1.加载JDBC驱动 Class.forName("com.mysql.jdbc.Driver"); //2.与数据库建立连接 connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8", "root", "root"); //3.创建Statement或PreparedStatement对象 statement = connection.prepareStatement("select * from user where username=? and password=?"); statement.setString(1, name); statement.setString(2, pwd); rs = statement.executeQuery(); String namex = ""; if(rs.next()) { user.setId(rs.getString(1)); user.setUsername(rs.getString(2)); user.setPassword(rs.getString(3)); user.setEmail(rs.getString(4)); user.setTel(rs.getString(5)); user.setAddress(rs.getString(6)); user.setAge(rs.getString(7)); user.setSex(rs.getString(8)); System.out.println("id:"+user.getId()); System.out.println("username:"+user.getUsername()); System.out.println("password:"+user.getPassword()); System.out.println("email:"+user.getEmail()); System.out.println("tel:"+user.getTel()); System.out.println("address:"+user.getAddress()); System.out.println("age:"+user.getAge()); System.out.println("sex:"+user.getSex()); } if(name.equals(user.getUsername())) return true; return false; } }