基于servlet及jsp的登陆注册mvc框架

一共建了5个包，分别是

com.etc.dao;

com.etc.dao.impl;

com.etc.model;

com.etc.service;

com.etc.servlet

package com.etc.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBConnectionFactory {

    
    public static Connection getConnection()
    {
        Connection conn = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            try {
                conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/kaijie", "root", "123");
                
                
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return conn;
    }
}

package com.etc.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.etc.dao.DBConnectionFactory;
import com.etc.model.User;

public class UserDaoImpl {

    Connection conn = DBConnectionFactory.getConnection();
    
    public User getUserByUname(String uname)
    {
        User u = null;
        String sql = "select * from users where username=?";
        try {
            PreparedStatement pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, uname);
            ResultSet rs = pstmt.executeQuery();
            while(rs.next())
            {
                u = new User(rs.getString(1), rs.getString(2), rs.getString(3), rs.getInt(4), rs.getString(5), rs.getString(6));
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return u;
    }
    
    public void insert(User user) 
    {
        String sql = "insert into users values(?,?,?,?,?,?)";
        try {
            PreparedStatement pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, user.getUsername());
            pstmt.setString(2, user.getPassword());
            pstmt.setString(3, user.getSex());
            pstmt.setInt(4, user.getAge());
            pstmt.setString(5, user.getAddress());
            pstmt.setString(6, user.getPhone());
            pstmt.executeUpdate();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    
    public User getUserByUnamePwd(String uname, String upwd)
    {
        User u = null;
        String sql = "select * from users where username=? and password = ?";
        try {
            PreparedStatement pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, uname);
            pstmt.setString(2, upwd);
            ResultSet rs = pstmt.executeQuery();
            while(rs.next())
            {
                u = new User(rs.getString(1), rs.getString(2), rs.getString(3), rs.getInt(4), rs.getString(5), rs.getString(6));
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return u;
    }
}

package com.etc.model;

public class User {

    private String username;
    private String password;
    private String sex;
    private int age;
    private String address;
    private String phone;
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
    public String getPhone() {
        return phone;
    }
    public void setPhone(String phone) {
        this.phone = phone;
    }
    public User(String username, String password, String sex, int age,
            String address, String phone) {
        super();
        this.username = username;
        this.password = password;
        this.sex = sex;
        this.age = age;
        this.address = address;
        this.phone = phone;
    }
    public User() {
        super();
    }
    public User(String username, String password) {
        super();
        this.username = username;
        this.password = password;
    }
    
    
}

package com.etc.service;

import com.etc.dao.impl.UserDaoImpl;
import com.etc.model.User;

public class UserService {

    UserDaoImpl udi = new UserDaoImpl();
    public boolean register(User u)
    {
        User user = udi.getUserByUname(u.getUsername());
        if (user == null) {
            udi.insert(u);
            return true;
        } else {
            return false;
        }
    }
    
    public boolean login(User u)
    {
        User u1 = udi.getUserByUname(u.getUsername());
        User u2 = udi.getUserByUnamePwd(u.getUsername(), u.getPassword());
        if(u1 == null)
        {
            return false;//该用户名不存在
        }
        else
        {
            if(u2 == null)
            {
                return false;//密码错误
            }
            else
            {
                return true;
            }
        }
    }
}

package com.etc.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.etc.model.User;
import com.etc.service.UserService;

public class LoginServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        // TODO Auto-generated method stub
        doPost(req, resp);
    }
    
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        // TODO Auto-generated method stub
        resp.setContentType("text/html,charset=UTF-8");
        req.setCharacterEncoding("UTF-8");
        
        String uname = req.getParameter("username");
        String upwd = req.getParameter("password");
        User u = new User(uname, upwd);
        UserService us = new UserService();
        boolean flag = us.login(u);
        if(flag)
        {
            req.getRequestDispatcher("welcome.jsp").forward(req, resp);
        }
        else
        {
            req.setAttribute("error", "密码错误");
            //resp.sendRedirect("login.jsp");
            req.getRequestDispatcher("login.jsp").forward(req, resp);
            
        }
    }
}

package com.etc.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.etc.model.User;
import com.etc.service.UserService;

public class RegisterServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        // TODO Auto-generated method stub
        doPost(req, resp);
    }
    
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        // TODO Auto-generated method stub
        resp.setContentType("text/html,charset=UTF-8");
        req.setCharacterEncoding("UTF-8");
        
        String uname = req.getParameter("username");
        String upwd = req.getParameter("password");
        String usex = req.getParameter("sex");
//System.out.println(usex);
        int uage = Integer.parseInt(req.getParameter("age"));
        String uaddr = req.getParameter("address");
        String uphone = req.getParameter("phone");
        
        User u = new User(uname, upwd, usex, uage, uaddr, uphone);
        
        UserService us = new UserService();
        boolean flag = us.register(u);
        if(flag)
        {
            resp.sendRedirect("login.jsp");
        }
        else
        {
//System.out.println("该用户名已存在，请重新注册！");
            req.setAttribute("error", "用户名已存在");
            req.getRequestDispatcher("register.jsp").forward(req, resp);
        }
    }
}

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>登录页面</title>
    
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">    
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->

  </head>
  
  <body>
  <% String info = (String) request.getAttribute("error");  
if(info!=null){
out.println("<span style='font-size:20px;color:red'>"+info+"</span>");
}%>
  <h3 align="center">登录</h3>
    <hr>
    <form action="login" method="post">
    <table align="center"  border="1">
        <tr>
            <td>用户名：</td>
            <td><input type="text" name = "username"/></td>
        </tr>
         <tr>
            <td>密码：</td>
            <td><input type="password" name = "password"/></td>
        </tr>
        <tr>
            <td colspan="2">
                <input type="submit" name="submit" value="登录"/>
                <input type="reset" name="reset" value="重置"/>
                <a href = "register.jsp" name="register">注册</a>
            </td>
        </tr>
    </table>
    </form>
  </body>
</html>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>注册页面</title>
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">    
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
  </head>
  
  <body>
    <% String info = (String) request.getAttribute("error");  
if(info!=null){
out.println("<span style='font-size:20px;color:red'>"+info+"</span>");
}%>
    
    <h3 align="center">注册</h3>
    <hr>
    <form action="register" method="post">
    <table align="center"  border="1">
        <tr>
            <td>用户名：</td>
            <td><input type="text" name = "username"/></td>
        </tr>
         <tr>
            <td>密码：</td>
            <td><input type="password" name = "password"/></td>
        </tr>
        <tr>
            <td>性别：</td>
            <td>
                <input type="radio" name = "sex" checked="checked" value="男"/>男
                <input type="radio" name = "sex" value="女"/>女
            </td>
        </tr>
        <tr>
            <td>年龄：</td>
            <td><input type="text" name = "age"/></td>
        </tr>
        <tr>
            <td>家庭住址：</td>
            <td><input type="text" name = "address"/></td>
        </tr>
        <tr>
            <td>联系电话：</td>
            <td><input type="text" name = "phone"/></td>
        </tr>
        <tr>
            <td colspan="2" align="center">
                <input type="submit" name="submit" value="注册"/>
                <input type="reset" name="reset" value="重置"/>         
            </td>
        </tr>
    </table>
    </form>
 </body>
</html>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>欢迎页面</title>
    
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">    
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->

  </head>
  
  <body>
    欢迎您！<%=request.getParameter("username") %><br>
  </body>
</html>

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" 
    xmlns="http://java.sun.com/xml/ns/javaee" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
    http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
    
    <servlet>
        <servlet-name>RegisterServlet</servlet-name>
        <servlet-class>com.etc.servlet.RegisterServlet</servlet-class>
    </servlet>
    
    <servlet-mapping>
        <servlet-name>RegisterServlet</servlet-name>
        <url-pattern>/register</url-pattern>
    </servlet-mapping>
    
    <servlet>
        <servlet-name>LoginServlet</servlet-name>
        <servlet-class>com.etc.servlet.LoginServlet</servlet-class>
    </servlet>
    
    <servlet-mapping>
        <servlet-name>LoginServlet</servlet-name>
        <url-pattern>/login</url-pattern>
    </servlet-mapping>
</web-app>