jsp+servlet实现最基本的注册登陆功能-阿里云开发者社区

源码和数据库下载地址：http://download.csdn.net/detail/biexiansheng/9759722

1：首先需要设计好数据库和数据表，这里简单截图说明我创建的字段和类型。

2：进入正题，开始开发前台和后台代码。首先创建一个动态web工程，然后先创建一个实体类。

 1 package com.bie.po;
 2 /** 
 3 * @author BieHongLi 
 4 * @version 创建时间：2017年2月21日 上午9:59:03 
 5 * 用户的实体类
 6 */
 7 public class User {
 8 
 9     private Integer id;
10     private String name;
11     private String password;
12     private String email;
13     private String phone;
14     public Integer getId() {
15         return id;
16     }
17     public void setId(Integer id) {
18         this.id = id;
19     }
20     public String getName() {
21         return name;
22     }
23     public void setName(String name) {
24         this.name = name;
25     }
26     public String getPassword() {
27         return password;
28     }
29     public void setPassword(String password) {
30         this.password = password;
31     }
32     public String getEmail() {
33         return email;
34     }
35     public void setEmail(String email) {
36         this.email = email;
37     }
38     public String getPhone() {
39         return phone;
40     }
41     public void setPhone(String phone) {
42         this.phone = phone;
43     }
44     
45     //重写toString 方法
46     @Override
47     public String toString() {
48         return "User [id=" + id + ", name=" + name + ", password=" + password + ", email=" + email + ", phone=" + phone
49                 + "]";
50     }
51     
52     
53 }

3：然后创建login.jsp登陆页面

 1 <%@ page language="java" contentType="text/html; charset=UTF-8"
 2     pageEncoding="UTF-8"%>
 3 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 4 <html>
 5 <head>
 6 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 7 <title>用户登陆页面</title>
 8 <style type="text/css">
 9 h1{text-align:left;}
10 h4{text-align:left;color:red;}
11 body{background:url(images/1.png)}
12 a{text-decoration:none;font-size:20px;color:black;}
13 a:hover{text-decoration:underline;font-size:24px;color:red;}
14 </style>
15 
16 </head>
17 <body>
18 <form action="user/userlogin" method="post">
19     <h1>用户登陆页面</h1>
20     <h4>装饰中......</h4>    
21     <hr/>
22     <table align="left">
23         <tr>
24             <td>账号：</td>
25             <td><input type="text" name="name" id="name"></td>
26         </tr>
27         <tr>
28             <td>密码：</td>
29             <td><input type="password" name="password" id="password"></td>
30         </tr>
31         <tr>
32             <td colspan="1">
33             </td>
34             <td>
35                 <input type="submit" value="登陆"/>
36                 <input type="reset" value="重置"/>
37                 <a href="register.jsp" target="_blank">注册</a>
38             </td>
39         </tr>
40     </table>
41 </form>
42 </body>
43 </html>

4：再创建注册页面register.jsp

 1 <%@ page language="java" contentType="text/html; charset=UTF-8"
 2     pageEncoding="UTF-8"%>
 3 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 4 <html>
 5 <head>
 6 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 7 <title>注册的页面</title>
 8 <style type="text/css">
 9 h1{text-align:center;}
10 h4{text-align:right;color:red;}
11 body{background:url(images/2.png)}
12 </style>
13 
14 <script type="text/javascript" src="js/jquery.min.js"></script>
15 <script type="text/javascript">
16     $(document).ready(function(){
17         //alert("测试jQuery是否能用");
18         $("#form1").submit(function(){
19             var name=$("#name").val();//获取提交的值
20             if(name.length==0){//进行判断，如果获取的值为0那么提示账号不能为空
21                 //alert("aa");//测试使用
22                 $("#nameError").html("账号不能为空");
23                 return false;
24             }
25             
26             //密码进行验证不能为空
27             var password=$("#password").val();//获取提交的密码的值
28             if(password.length==0){
29                 $("#passwordError").html("密码不能为空");
30                 return false;
31             }
32             
33             //确认密码进行验证
34             var relpassword=$("#relpassword").val();//获取提交的确认密码的值
35             if(relpassword.length==0){
36                 $("#relpasswordError").html("确认密码不能为空哦");
37                 return false;
38             }
39             
40             if(password!=relpassword){
41                 $("#relpasswordError").html("确认密码输入不正确，请重新输入");
42                 return false;
43             }
44         });
45     
46     });
47 </script>
48 </head>
49 <body>
50 <form action="user/userregister" method="post" id="form1">
51     <h1>用户注册页面</h1>
52     <h4>装饰中......</h4>    
53     <hr/>
54     <table align="center">
55         <tr>
56             <td>账&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;号：</td>
57             <td>
58                 <input type="text" name="name" id="name"/>
59                 <div id="nameError" style="display:inline;color:red;"></div>
60             </td>
61         </tr>
62         <tr>
63             <td>密&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;码：</td>
64             <td>
65                 <input type="password" name="password" id="password">
66                 <div id="passwordError" style="display:inline;color:red;"></div>
67             </td>
68         </tr>
69         <tr>
70             <td>确认密码：</td>
71             <td>
72                 <input type="password" name="relpassword" id="relpassword">
73                 <div id="relpasswordError" style="display:inline;color:red;"></div>
74             </td>
75         </tr>
76         <tr>
77             <td>电话号码：</td>
78             <td><input type="text" name="phone" id="phone"></td>
79         </tr>
80         <tr>
81             <td>电子邮件：</td>
82             <td><input type="text" name="email" id="email"></td>
83         </tr>
84         <tr>
85             <td colspan="1">
86             </td>
87             <td>
88                 <input type="submit" value="注册"/>
89                 <input type="reset" value="重置"/>
90                 <a href="login.jsp" target="_blank">登陆</a>
91             </td>
92         </tr>
93     </table>
94 </form>
95 </body>
96 </html>

5:再创建utils层，公共的工具层BaseDao.java;

  1 package com.bie.utils;
  2 
  3 import java.sql.Connection;
  4 import java.sql.DriverManager;
  5 import java.sql.PreparedStatement;
  6 import java.sql.ResultSet;
  7 import java.sql.SQLException;
  8 import java.util.ResourceBundle;
  9 
 10 
 11 /** 
 12 * @author BieHongLi 
 13 * @version 创建时间：2017年2月21日 上午10:01:14 
 14 * 数据交互层dao层
 15 */
 16 public class BaseDao {
 17 
 18     private static String driver;//数据库驱动
 19     private static String url;//数据库路径，找到对应的数据库
 20     private static String user;//数据库账号
 21     private static String password;//数据库密码
 22     
 23     static{
 24         driver=ResourceBundle.getBundle("db").getString("driver");
 25         url=ResourceBundle.getBundle("db").getString("url");
 26         user=ResourceBundle.getBundle("db").getString("user");
 27         password=ResourceBundle.getBundle("db").getString("password");
 28     }
 29     /*private static String driver="com.mysql.jdbc.Driver";
 30     private static String url="jdbc:mysql:///test";
 31     private static String user="root";
 32     private static String password="123456";*/
 33     
 34     /***
 35      * 连接数据库的方法
 36      * @return
 37      * @throws ClassNotFoundException
 38      * @throws SQLException
 39      */
 40     public static Connection getCon() throws ClassNotFoundException, SQLException{
 41         Class.forName(driver);//加载数据库驱动
 42         System.out.println("测试加载数据库成功");
 43         Connection con=DriverManager.getConnection(url, user, password);
 44         System.out.println("测试数据库链接成功");
 45         return con;
 46     }
 47     
 48     /***
 49      * 关闭数据库的方法
 50      * @param con
 51      * @param ps
 52      * @param rs
 53      */
 54     public static void close(Connection con,PreparedStatement ps,ResultSet rs){
 55         if(rs!=null){//关闭资源，避免出现异常
 56             try {
 57                 rs.close();
 58             } catch (SQLException e) {
 59                 // TODO Auto-generated catch block
 60                 e.printStackTrace();
 61             }
 62         }
 63         if(ps!=null){
 64             try {
 65                 ps.close();
 66             } catch (SQLException e) {
 67                 // TODO Auto-generated catch block
 68                 e.printStackTrace();
 69             }
 70         }
 71         if(con!=null){
 72             try {
 73                 con.close();
 74             } catch (SQLException e) {
 75                 // TODO Auto-generated catch block
 76                 e.printStackTrace();
 77             }
 78         }
 79     }
 80     
 81     /***
 82      * 同意增删改的方法
 83      * @param sql
 84      * @param arr
 85      * @return
 86      */
 87     public static boolean addUpdateDelete(String sql,Object[] arr){
 88         Connection con=null;
 89         PreparedStatement ps=null;
 90         try {
 91             con=BaseDao.getCon();//第一步 ：连接数据库的操作
 92             ps=con.prepareStatement(sql);//第二步：预编译
 93             //第三步：设置值
 94             if(arr!=null && arr.length!=0){
 95                 for(int i=0;i<arr.length;i++){
 96                     ps.setObject(i+1, arr[i]);
 97                 }
 98             }
 99             int count=ps.executeUpdate();//第四步：执行sql语句
100             if(count>0){
101                 return true;
102             }else{
103                 return false;
104             }
105         } catch (ClassNotFoundException e) {
106             // TODO Auto-generated catch block
107             e.printStackTrace();
108         } catch (SQLException e) {
109             // TODO Auto-generated catch block
110             e.printStackTrace();
111         }
112         return false;
113     }
114     
115     /*public static void main(String[] args) {
116         try {
117             BaseDao.getCon();
118             System.out.println("测试数据库链接成功");
119         } catch (ClassNotFoundException e) {
120             // TODO Auto-generated catch block
121             e.printStackTrace();
122         } catch (SQLException e) {
123             // TODO Auto-generated catch block
124             e.printStackTrace();
125         }
126     }*/
127     
128     
129 }

6:然后创建dao层数据交互层的接口和实现类

 1 package com.bie.dao;
 2 
 3 import com.bie.po.User;
 4 
 5 /** 
 6 * @author BieHongLi 
 7 * @version 创建时间：2017年2月21日 上午10:38:40 
 8 * 创建一个接口用于声明用户登陆注册的方法
 9 */
10 public interface UserDao {
11 
12     /***
13      * 用户登陆的方法声明
14      * @param user
15      * @return
16      */
17     public User login(User user);
18     
19     /***
20      * 用户注册的方法声明
21      * @param user
22      * @return
23      */
24     public boolean register(User user);
25 }

 1 package com.bie.dao.impl;
 2 
 3 import java.sql.Connection;
 4 import java.sql.PreparedStatement;
 5 import java.sql.ResultSet;
 6 import java.sql.SQLException;
 7 import java.util.ArrayList;
 8 import java.util.List;
 9 
10 import com.bie.dao.UserDao;
11 import com.bie.po.User;
12 import com.bie.utils.BaseDao;
13 
14 /** 
15 * @author BieHongLi 
16 * @version 创建时间：2017年2月21日 上午10:38:56 
17 * 
18 */
19 public class UserDaoImpl implements UserDao{
20 
21     @Override
22     public User login(User user) {
23         Connection con=null;
24         PreparedStatement ps=null;
25         ResultSet rs=null;
26         try {
27             con=BaseDao.getCon();//1:获取数据库的连接
28             //2:书写sql语句
29             String sql="select * from user where name=? and password=? ";
30             ps=con.prepareStatement(sql);//3：预编译
31             //4：设置值
32             ps.setString(1, user.getName());
33             ps.setString(2, user.getPassword());
34             rs=ps.executeQuery();//5:执行sql语句
35             User users=null;
36             if(rs.next()){
37                 users=new User();
38                 //从数据库中获取值设置到实体类的setter方法中
39                 users.setId(rs.getInt("id"));
40                 users.setName(rs.getString("name"));
41                 users.setPassword(rs.getString("password"));
42                 users.setEmail(rs.getString("email"));
43                 users.setPhone(rs.getString("phone"));
44                 
45                 return user;
46             }else{
47                 return null;
48             }
49             
50         } catch (ClassNotFoundException e) {
51             // TODO Auto-generated catch block
52             e.printStackTrace();
53         } catch (SQLException e) {
54             // TODO Auto-generated catch block
55             e.printStackTrace();
56         }
57         return null;
58     }
59 
60     /***
61      * 插入的方法，即注册
62      */
63     @Override
64     public boolean register(User user) {
65         String sql="insert into user values(0,?,?,?,?) ";
66         List<Object> list=new ArrayList<Object>();
67         list.add(user.getName());
68         list.add(user.getPassword());
69         list.add(user.getEmail());
70         list.add(user.getPhone());
71         
72         boolean flag=BaseDao.addUpdateDelete(sql,list.toArray());
73         if(flag){
74             return true;
75         }else{
76             return false;
77         }
78     }
79 
80     
81 }

7：再创建servlet层进行登陆的业务逻辑处理（由于省去了service层，所以在servlet层进行业务逻辑处理了）

 1 package com.bie.servlet;
 2 
 3 import java.io.IOException;
 4 
 5 import javax.servlet.ServletException;
 6 import javax.servlet.annotation.WebServlet;
 7 import javax.servlet.http.HttpServlet;
 8 import javax.servlet.http.HttpServletRequest;
 9 import javax.servlet.http.HttpServletResponse;
10 
11 import com.bie.dao.UserDao;
12 import com.bie.dao.impl.UserDaoImpl;
13 import com.bie.po.User;
14 
15 
16 /** 
17 * @author BieHongLi 
18 * @version 创建时间：2017年2月21日 上午10:49:44 
19 * 
20 */
21 @WebServlet("/user/userlogin")
22 public class UserLoginServlet extends HttpServlet{
23     
24     private static final long serialVersionUID = 1L;
25 
26     @Override
27     protected void doGet(HttpServletRequest request, HttpServletResponse response) 
28             throws ServletException, IOException {
29         this.doPost(request, response);
30     }
31 
32     @Override
33     protected void doPost(HttpServletRequest request, HttpServletResponse response) 
34             throws ServletException, IOException {
35         User user=new User();
36         //获取login.jsp页面提交的账号和密码
37         String name=request.getParameter("name");
38         String password=request.getParameter("password");
39         //测试数据
40         System.out.println(name+" "+password);
41         //获取login.jsp页面提交的账号和密码设置到实体类User中
42         user.setName(name);
43         user.setPassword(password);
44         
45         //引入数据交互层
46         UserDao dao=new UserDaoImpl();
47         User us=dao.login(user);
48         //测试返回的值
49         System.out.println(us);
50         if(us!=null){
51             request.setAttribute("info", "登陆成功");
52         }else{
53             request.setAttribute("info", "登录失败");
54         }
55         
56         request.getRequestDispatcher("/index/info.jsp").forward(request, response);
57     }
58     
59     
60     
61 }

8：再创建servlet层进行注册的业务逻辑处理（由于省去了service层，所以在servlet层进行业务逻辑处理了）

 1 package com.bie.servlet;
 2 
 3 import java.io.IOException;
 4 
 5 import javax.servlet.ServletException;
 6 import javax.servlet.annotation.WebServlet;
 7 import javax.servlet.http.HttpServlet;
 8 import javax.servlet.http.HttpServletRequest;
 9 import javax.servlet.http.HttpServletResponse;
10 
11 import com.bie.dao.UserDao;
12 import com.bie.dao.impl.UserDaoImpl;
13 import com.bie.po.User;
14 
15 /** 
16 * @author BieHongLi 
17 * @version 创建时间：2017年2月21日 下午1:34:17 
18 * 注册的servlet
19 */
20 @WebServlet("/user/userregister")
21 public class UserRegisterServlet extends HttpServlet{
22     
23     private static final long serialVersionUID = 1L;
24 
25     @Override
26     protected void doGet(HttpServletRequest request, HttpServletResponse response) 
27             throws ServletException, IOException {
28         this.doPost(request, response);
29     }
30 
31     @Override
32     protected void doPost(HttpServletRequest request, HttpServletResponse response) 
33             throws ServletException, IOException {
34         User user=new User();
35         //获取login.jsp页面提交的账号和密码
36         String name=request.getParameter("name");
37         String password=request.getParameter("password");
38         String email=request.getParameter("email");
39         String phone=request.getParameter("phone");
40         
41         //获取register.jsp页面提交的账号和密码设置到实体类User中
42         user.setName(name);
43         user.setPassword(password);
44         user.setEmail(email);
45         user.setPhone(phone);
46         
47         //引入数据交互层
48         UserDao dao=new UserDaoImpl();
49         boolean flag=dao.register(user);
50         if(flag){
51             request.setAttribute("info", "注册成功");
52         }else{
53             request.setAttribute("info", "注册失败");
54         }
55         
56         request.getRequestDispatcher("/index/info.jsp").forward(request, response);
57     }
58     
59 }

9：为了避免乱码，使用过滤器进行过滤。

 1 package com.bie.utils;
 2 
 3 import java.io.IOException;
 4 
 5 import javax.servlet.Filter;
 6 import javax.servlet.FilterChain;
 7 import javax.servlet.FilterConfig;
 8 import javax.servlet.ServletException;
 9 import javax.servlet.ServletRequest;
10 import javax.servlet.ServletResponse;
11 import javax.servlet.annotation.WebFilter;
12 import javax.servlet.http.HttpServletRequest;
13 
14 /** 
15 * @author BieHongLi 
16 * @version 创建时间：2017年2月21日 上午11:08:49 
17 * 
18 */
19 @WebFilter("/*")
20 public class UTFFilter implements Filter{
21 
22     @Override
23     public void destroy() {
24         // TODO Auto-generated method stub
25         
26     }
27 
28     @Override
29     public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, 
30             FilterChain filterChain)throws IOException, ServletException {
31         //将servletRequest转发为HttpServletRequest
32         HttpServletRequest request=(HttpServletRequest)servletRequest;
33         request.setCharacterEncoding("utf-8");
34         filterChain.doFilter(servletRequest, servletResponse);
35     }
36 
37     @Override
38     public void init(FilterConfig arg0) throws ServletException {
39         // TODO Auto-generated method stub
40         
41     }
42     
43 
44 }

效果如下所示：

jsp+servlet实现最基本的注册登陆功能

热门文章

最新文章

相关课程

相关电子书