Chinaunix首页 | 论坛 | 博客

Leungffy XUExueliangfei.blog.chinaunix.net

首页　| 　博文目录　| 　关于我

xueliangfei

  • 博客访问： 2298301
  • 博文数量： 252
  • 博客积分： 5472
  • 博客等级： 大校
  • 技术积分： 3107
  • 用 户 组： 普通用户
  • 注册时间： 2011-09-17 18:39
文章分类

全部博文（252）

文章存档

2012年（96）

2011年（156）

我的朋友
最近访客
推荐博文
相关博文
JSP JavaBean Servlet实现用户登录和注册

分类： 系统运维

2011-12-06 21:25:09

1 数据库：
  1. create database student;
  2. use student;
  3. create table user(
  4. id int primary key auto_increment,
  5. user varchar(50) not null,
  6. pwd varchar(50) not null,
  7. name varchar(50) not null,
  8. *** varchar(50) not null,
  9. age int(50) not null
  10. );

 

2 index.jsp

 

  1. <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
  2. <%
  3. String path = request.getContextPath();
  4. String basePath = request.getScheme() "://" request.getServerName() ":" request.getServerPort() path "/";
  5. %>

  7. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  8. <html>
  9. <head>
  10.     <base href="<%=basePath%>">
  11.     
  12.     <title>欢迎来到学生管理系统</title>
  13. <meta http-equiv="pragma" content="no-cache">
  14. <meta http-equiv="cache-control" content="no-cache">
  15. <meta http-equiv="expires" content="0">
  16. <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  17. <meta http-equiv="description" content="This is my page">

  19. </head>

  21. <body>
  22.     <div align="center"> <font size=" 2" color="#FF6633">用户登录</font>
  23. </div>
  24. <form id="form1" name="form1" method="post" action="loginServlet">
  25. <table width="357" border="0" align="center">
  26.     <tr>
  27.       <td width="128">用户名：</td>
  28.       <td width="219"><label>
  29.         <input name="user" type="text" id="user" />
  30.       </label></td>
  31.     </tr>
  32.     <tr>
  33.       <td>密　码：</td>
  34.       <td><label>
  35.         <input name="pwd" type="password" id="pwd" />
  36.       </label></td>
  37.     </tr>
  38.     <tr>
  39.       <td><label>
  40.         <input type="submit" name="Submit" value="登录" />
  41.       </label></td>
  42.       <td><label><a href="addUser.jsp">用户注册</a></label></td>
  43.     </tr>
  44. </table>
  45. <p>&nbsp;</p>
  46. </form>
  47. </body>
  48. </html>

3 addUser.jsp

 

  1. <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
  2. <%
  3. String path = request.getContextPath();
  4. String basePath = request.getScheme() "://" request.getServerName() ":" request.getServerPort() path "/";
  5. %>

  7. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  8. <html>
  9. <head>
  10.     <base href="<%=basePath%>">
  11.     
  12.     <title>用户注册</title>
  13.     
  14. <meta http-equiv="pragma" content="no-cache">
  15. <meta http-equiv="cache-control" content="no-cache">
  16. <meta http-equiv="expires" content="0">
  17. <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  18. <meta http-equiv="description" content="This is my page">


  21. </head>

  23. <body>
  24.     <p align="center"><font size=" 3" color="#FF3300">用户注册</font></p>
  25. <form id="form1" name="form1" method="post" action="addUserServlet">
  26. <table width="340" border="0" align="center">
  27.     <tr>
  28.       <td width="141">用户名：</td>
  29.       <td width="189"><label>
  30.         <input name="user" type="text" id="user" />
  31.       </label></td>
  32.     </tr>
  33.     <tr>
  34.       <td>密码：</td>
  35.       <td><label>
  36.         <input name="pwd" type="password" id="pwd" />
  37.       </label></td>
  38.     </tr>
  39.     <tr>
  40.       <td>重输密码：</td>
  41.       <td><label>
  42.         <input name="pwd1" type="password" id="pwd1" />
  43.       </label></td>
  44.     </tr>
  45.     <tr>
  46.       <td>姓名：</td>
  47.       <td><label>
  48.         <input name="name" type="text" id="name" />
  49.       </label></td>
  50.     </tr>
  51.     <tr>
  52.       <td>性别：</td>
  53.       <td><label>
  54.         <input name="***" type="radio" value="男" checked="checked" />
  55.       男
  56.       <input type="radio" name="***" value="女" />
  57.       女</label></td>
  58.     </tr>
  59.     <tr>
  60.       <td>年龄：</td>
  61.       <td><label>
  62.         <input name="age" type="text" id="age" />
  63.       </label></td>
  64.     </tr>
  65.     <tr>
  66.       <td><label>
  67.         <input type="submit" name="Submit" value="提交" />
  68.       </label></td>
  69.       <td><label>
  70.         <input type="reset" name="Submit2" value="重置" />
  71.       </label></td>
  72.     </tr>
  73. </table>
  74. </form>
  75. </body>
  76. </html>

 

4 DAO.java  实现与数据库的连接用户名验证与用户名新建添加

 

  1. package dao;

  3. import getConnection.GetConnection;

  5. import java.sql.Connection;
  6. import java.sql.PreparedStatement;
  7. import java.sql.SQLException;

  9. import com.mysql.jdbc.ResultSet;

  11. import bean.User;

  13. public class Dao {
  14. private Connection conn;
  15. private PreparedStatement pstat;
  16. String sql="";
  17. /**
  18. *
  19. * 用户登录
  20. */
  21. public boolean logoin(User user) throws SQLException{
  22.    conn = GetConnection.getConnection();
  23.    boolean i = false;
  24.    sql = "select * from user where user=? and pwd=?";
  25.   
  26.    pstat = conn.prepareStatement(sql);
  27.   
  28.    pstat.setString(1, user.getUser());
  29.    pstat.setString(2, user.getPwd());
  30.   
  31.    ResultSet rs1 = (ResultSet) pstat.executeQuery();
  32.    if (rs1.next())
  33.    {
  34.     i = true;
  35.     rs1.close();
  36.     pstat.close();
  37.    }
  38.    else
  39.    {
  40.     i = false ;
  41.     rs1.close();
  42.     pstat.close();
  43.    }
  44.    conn.close();
  45.    return i;
  46. }
  47. /**
  48. * 用户注册
  49. */
  50. public void addUser(User user){
  51.    conn = GetConnection.getConnection();
  52.    sql = "insert into user values(?,?,?,?,?)";
  53.    try{
  54.     pstat = conn.prepareStatement(sql);
  55.     pstat.setString(1,user.getUser());
  56.     pstat.setString(2,user.getPwd());
  57.     pstat.setString(3,user.getName());
  58.     pstat.setString(4,user.get***());
  59.     pstat.setInt(5,user.getAge());
  60.     pstat.executeUpdate();
  61.     pstat.close();
  62.     conn.close();
  63.    
  64.    }catch(SQLException e){
  65.     e.printStackTrace();
  66.    }
  67.   
  68. }
  69. }

5 User.java

 

  1. package bean;

  3. public class User {
  4. private String user;
  5. private String pwd;
  6. private String name;
  7. private String ***;
  8. private int age;
  9. public String getUser() {
  10.    return user;
  11. }
  12. public void setUser(String user) {
  13.    this.user = user;
  14. }
  15. public String getPwd() {
  16.    return pwd;
  17. }
  18. public void setPwd(String pwd) {
  19.    this.pwd = pwd;
  20. }
  21. public String getName() {
  22.    return name;
  23. }
  24. public void setName(String name) {
  25.    this.name = name;
  26. }
  27. public String get***() {
  28.    return ***;
  29. }
  30. public void set***(String ***) {
  31.    this.*** = ***;
  32. }
  33. public int getAge() {
  34.    return age;
  35. }
  36. public void setAge(int age) {
  37.    this.age = age;
  38. }
  39. }

 

6 GetConnection.java  实现与数据库之间的连接

 

  1. package getConnection;

  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.SQLException;

  7. /**
  8. *
  9. * 用JDBC的方法获得数据库的连接
  10. *
  11. */
  12. public class GetConnection {
  13. //通过静态方法注册驱动，获得连接

  15. public static Connection getConnection(){
  16.    String driver = "com.mysql.jdbc.Driver";
  17.    String url = "jdbc:mysql://localhost/student";
  18.    Connection con = null;
  19.    try {
  20.     Class.forName(driver);
  21.     try {
  22.      con = DriverManager.getConnection(url,"root","");
  23.     } catch (SQLException e) {
  24.      e.printStackTrace();
  25.     }
  26.    } catch (ClassNotFoundException e) {
  27.     e.printStackTrace();
  28.    }
  29.    System.out.println("已获得数据库的连接");
  30.    return con;
  31. }
  32. /*public static void main(String args[]){
  33.    getConnection();
  34. }*/
  35. }

7 addUserServlet.java

 

  1. package servlet;

  3. import java.io.IOException;

  5. import javax.servlet.ServletException;
  6. import javax.servlet.http.HttpServlet;
  7. import javax.servlet.http.HttpServletRequest;
  8. import javax.servlet.http.HttpServletResponse;

  10. import dao.Dao;

  12. import bean.User;

  14. public class addUserServlet extends HttpServlet {

  16. /**
  17. * Destruction of the servlet.

  18. */
  19. public void destroy() {
  20.    super.destroy(); // Just puts "destroy" string in log

  22.    // Put your code here

  24. }

  26. public void doGet(HttpServletRequest request, HttpServletResponse response)
  27.     throws ServletException, IOException {

  29.    response.setContentType("text/html");
  30. doPost(request,response);
  31. }

  33. public void doPost(HttpServletRequest request, HttpServletResponse response)
  34.     throws ServletException, IOException {

  36.    response.setContentType("text/html");
  37.    response.setCharacterEncoding("utf-8");
  38.    String user1 = request.getParameter("user");
  39.    String pwd = request.getParameter("pwd");
  40.    String name = new String(request.getParameter("name").getBytes("ISO8859_1"),"utf-8");
  41.    String *** = new String(request.getParameter("***").getBytes("ISO8859_1"),"utf-8");
  42.    String age1 = request.getParameter("age");
  43.    User user = new User();
  44.    user.setUser(user1);
  45.    user.setPwd(pwd);
  46.    user.setName(name);
  47.    user.set***(***);
  48.    int age;
  49.    if(age1!=null)
  50.    {
  51.     age = Integer.parseInt(age1);
  52.     user.setAge(age);
  53.    }
  54.    Dao dao = new Dao();
  55.    dao.addUser(user);
  56. /* request.setAttribute("info",new String("

    添加成功！恭喜！！" +

  57.    "
    "));
  58.    request.setAttribute("id", new String("a"));
  59.    request.setAttribute("denglu",new String("

    登陆

    "));*/
  60.   
  61.   
  62.    request.getRequestDispatcher("info.jsp").forward(request,response);
  63. }

  65. public void init() throws ServletException {
  66.    // Put your code here

  68. }

  70. }

 

 

8  loginServlet.java

 

  1. package servlet;

  3. import java.io.IOException;
  4. import java.io.PrintWriter;
  5. import java.sql.SQLException;

  7. import javax.servlet.ServletException;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;

  12. import bean.User;
  13. import dao.Dao;

  15. public class loginServlet extends HttpServlet {
  16. public void destroy() {
  17.    super.destroy(); // Just puts "destroy" string in log

  19.    // Put your code here

  21. }
  22. public void doPost(HttpServletRequest request, HttpServletResponse response)
  23.     throws ServletException, IOException {
  24.    request.setCharacterEncoding("utf-8");
  25.    response.setContentType("text/html");
  26.    PrintWriter out = response.getWriter();
  27.    String name = new String (request.getParameter("user").getBytes("ISO8859_1"), "GBK");
  28.    String pwd = new String (request.getParameter("pwd").getBytes("ISO8859_1"),"UTF-8");
  29.    User user = new User();
  30.    user.setUser(name);
  31.    user.setPwd(pwd);
  32.    Dao dao = new Dao();
  33.    boolean isLogin;
  34.    try
  35.    {
  36.     isLogin = dao.logoin(user);
  37.    
  38.     if(isLogin)
  39.     {
  40.      response.sendRedirect("MyJsp.jsp");
  41.     }else{
  42.      response.sendRedirect("index.jsp");
  43.     }
  44.    
  45.    } catch (SQLException e)
  46.    {
  47.     e.printStackTrace();
  48.    }
  49. }
  50. public void doGet(HttpServletRequest request, HttpServletResponse response)
  51. throws ServletException, IOException {
  52. doPost(request,response);
  53. }
  54. public void init() throws ServletException {
  55. }

  57. }

 

 

 

 

阅读(37896) | 评论(0) | 转发(1) |
2

上一篇：JSP JavaBean 标准注册页面 带有选择模式 下拉选择

下一篇：getInitParameter()

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6