maven+springMVC+jdbc实现用户注册功能

直接上代码，喜欢的请点赞！

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.dong</groupId>
  <artifactId>helloMaven</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>helloMaven Maven Webapp</name>
  <url>http://maven.apache.org</url>
 
  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>4.3.5.RELEASE</version>
    </dependency>
    <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>4.3.5.RELEASE</version>
</dependency>
    
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>4.3.5.RELEASE</version>
    </dependency>
    
    <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>3.1.1</version>
      </dependency>
      <!-- mybatis spring 插件 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.1.1</version>
    </dependency>
    <dependency>
    <groupId>javax.transaction</groupId>
    <artifactId>jta</artifactId>
    <version>1.1</version>
    </dependency>
    
    <!-- mysql连接 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.34</version>
    </dependency>
    <!-- servlet -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>3.0-alpha-1</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
    
    <dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>jstl</artifactId>
    <version>1.2</version>
    </dependency>
    
    <!-- log4j -->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.17</version>
    </dependency>
    
    <!-- 文件上传 -->
   <dependency>
      <groupId>commons-io</groupId>
      <artifactId>commons-io</artifactId>
      <version>2.4</version>
    </dependency>

    <dependency>
      <groupId>commons-fileupload</groupId>
      <artifactId>commons-fileupload</artifactId>
      <version>1.2.2</version>
    </dependency>
    
    <!-- 数据源 -->
      <dependency>
    <groupId>com.mchange</groupId>
    <artifactId>c3p0</artifactId>
    <version>0.9.5.2</version>
</dependency>
<dependency>
    <groupId>commons-dbcp</groupId>
    <artifactId>commons-dbcp</artifactId>
    <version>20030825.184428</version>
</dependency>
    <dependency>
    <groupId>commons-pool</groupId>
    <artifactId>commons-pool</artifactId>
    <version>20030825.183949</version>
</dependency>
     <dependency>
    <groupId>commons-collections</groupId>
    <artifactId>commons-collections</artifactId>
    <version>20040616</version>
</dependency>
    
     
  </dependencies>
 
  <build>
    <finalName>helloMaven</finalName>
  </build>
 
</project>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
 
  <!-- 数据库配置 -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:/dataSource.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <!-- springMvc编码拦截器 -->
    <filter>
        <filter-name>encodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
        <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    
  <!-- 配置DispatcherServlet -->
  <servlet>
    <servlet-name>springDispatcherServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <!-- 配置 spring mvc 下的配置文件的名称和位置 -->
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:springmvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>
 
  <servlet-mapping>
    <servlet-name>springDispatcherServlet</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
 
  <servlet-mapping>
        <servlet-name>default</servlet-name>
        <url-pattern>*.png</url-pattern>
        <url-pattern>*.PNG</url-pattern>
        <url-pattern>*.bmp</url-pattern>
        <url-pattern>*.gif</url-pattern>
        <url-pattern>*.jpg</url-pattern>
        <url-pattern>*.css</url-pattern>
        <url-pattern>*.js</url-pattern>
        <url-pattern>*.mp3</url-pattern>
        <url-pattern>*.html</url-pattern>
    </servlet-mapping>
 
  <welcome-file-list>
     <welcome-file>index.jsp</welcome-file>
     <welcome-file>jsp/login.jsp</welcome-file>
  </welcome-file-list>
</web-app>

jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/DB
jdbc.username=
jdbc.password=
jdbc.maxActive=20
jdbc.maxIdle=20
jdbc.maxWait=9000

dataSource.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"     
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"     
    xmlns:context="http://www.springframework.org/schema/context"     
    xmlns:mvc="http://www.springframework.org/schema/mvc"     
    xsi:schemaLocation="      
           http://www.springframework.org/schema/beans      
           http://www.springframework.org/schema/beans/spring-beans-3.0.xsd      
           http://www.springframework.org/schema/context      
           http://www.springframework.org/schema/context/spring-context-3.0.xsd     
           http://www.springframework.org/schema/mvc      
           http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
           
   <bean id="config" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
     <property name="location" value="classpath:jdbc.properties"></property>
   </bean>
   
   <!-- 配置数据源,包含connector的驱动名称，地址，用户名以及密码 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">       
        <property name="driverClassName" value="${jdbc.driverClassName}" />      
        <property name="url" value="${jdbc.url}" />      
        <property name="username" value="${jdbc.username}" />      
        <property name="password" value="${jdbc.password}" />
        <property name="maxActive" value="${jdbc.maxActive}"></property>
        <property name="maxIdle" value="${jdbc.maxIdle}"></property>
        <property name="maxWait" value="${jdbc.maxWait}"></property>
        <property name="testOnBorrow" value="true"/>
        <property name="validationQuery" value="select 1 from dual"/>
        <property name="defaultAutoCommit" value="true"></property>      
   </bean>  
   
   <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"  >  
        <property name="dataSource">  
            <ref bean="dataSource" />  
        </property>  
   </bean>
   
   <!-- 自动扫描组件，需要把controller去掉，否则影响事务管理 -->  
    <context:component-scan base-package="com.springmvc">
        <context:exclude-filter type="regex" expression="com.dong.*" />
    </context:component-scan>     
           
</beans>

springmvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.0.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
    
    <!-- 配置自动扫描的包 -->
    <context:component-scan base-package="com.dong" />
    <!--注册驱动  -->
     <mvc:annotation-driven/>
     <mvc:default-servlet-handler/>
    
    <!-- 配置视图解析器 如何把handler 方法返回值解析为实际的物理视图 , 这个要配合controller类来解析-->
    
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/jsp" />
        <property name="suffix" value=".jsp" />
    </bean>  
    
</beans>

User.java

package com.dong.pojo;

import java.util.Date;

public class User {
    
    private String username;
    private String password;
    
    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 User() {  
    }
    public User(String username, String password) {
        super();
        this.username = username;
        this.password = password;
    }
    public void setId(String string) {
        // TODO Auto-generated method stub      
    }
    public void setRegtime(Date date) {
        // TODO Auto-generated method stub     
    }   
}

UserDao.java

package com.dong.dao;

import com.dong.pojo.User;

public interface UserDao {
    
    public void addUser(User user);
    
    public boolean getUser(User user);
    
    public boolean getUsername(User user);
    
}

UserDaoImpl

package com.dong.dao;


import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.EmptyResultDataAccessException;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import com.dong.pojo.User;

@Repository
public class UserDaoImpl implements UserDao{
    @Autowired
    public JdbcTemplate jdbcTemplate;

    @Override
    public void addUser(User user) {
        String sql="insert into user(username,password) values(?,?)";
        jdbcTemplate.update(sql,new Object[]{user.getUsername(),user.getPassword()});        
    }

    @Override
    public boolean getUser(User user) {
        boolean  flag=false;
        String sql="select 1 from user where username=? and password=?";
        String str=jdbcTemplate.queryForObject(sql, new Object[]{user.getUsername(),user.getPassword()},java.lang.String.class);
        if(str.equals("1")){
            flag=true;
        }
        return flag;
    }

    @Override
    public boolean getUsername(User user) {
        boolean  flag=false;
        String sql="select '1' from user where username='"+user.getUsername()+"'";
        try{
            List<String> str=jdbcTemplate.queryForList(sql,java.lang.String.class);
            for (String str2 : str) {                
                if(str2.equals("1")){
                    flag=true;            
                }                
            }            
        }catch(EmptyResultDataAccessException e){
            return flag;
        }
        return flag;
    }
}

UserService.java

package com.dong.service;

import com.dong.pojo.User;

public interface UserService{
    
    public void addUser(User user);
    public boolean getUser(User user);
    public boolean getUsername(User user);
}

UserServiceImpl.java

package com.dong.service;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.dong.dao.UserDaoImpl;
import com.dong.pojo.User;

@Service
public class UserServiceImpl implements UserService{
    @Autowired
    public UserDaoImpl dao;
    
    @Override
    public void addUser(User user) {
        
        dao.addUser(user);
    }

    @Override
    public boolean getUser(User user) {
        return dao.getUser(user);
    }

    @Override
    public boolean getUsername(User user) {
        // TODO Auto-generated method stub
        return dao.getUsername(user);
    }   
}

RegisterController.java

package com.dong.controller;

import java.io.PrintWriter;

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

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.dong.pojo.User;
import com.dong.service.UserService;

@Controller
public class RegisterController {

        @Autowired  
        private UserService userService;   
        //注册用户
        @RequestMapping("/register")          
        public String userReg(HttpServletRequest req){              
            User user =new User();
            String username=(String) req.getParameter("username");
            String password=(String) req.getParameter("password");
            user.setUsername(username);
            user.setPassword(password);            
            userService.addUser(user);
            req.setAttribute("username", user.getUsername());  
            req.setAttribute("password", user.getPassword());  
            return "/login";  
        }
      //处理用户名唯一性的判断                                                                       
        @RequestMapping("/usernameJudge")  
        public void usernameJudge(HttpServletRequest req,HttpServletResponse res) {  
            res.setContentType("application/json");
            PrintWriter out=null;
            try {
                out=res.getWriter();
                
                User user=new User();
                user.setUsername(req.getParameter("username"));
                     boolean falg=userService.getUsername(user);
                     
                 String json="{\"result\":\""+falg+"\"}";
                 out.write(json);
                 
            } catch (Exception e) {
                e.printStackTrace();
                out.flush();
                out.close();
            }
              
        }
}

register.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>  
 
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>注册</title>
<script type="text/javascript" src="<%=basePath %>js/jquery-1.9.1.js"></script>

<script>
//用户名合法性的判断  
$(function(){  
      $("#uname").blur(function(){
              var ulen = $("#uname").val().length;
              var usname=$("#uname").val();
              if(ulen==0 || usname==null){            
                  $("#usernameError").html("用户名不能为空！");
                  $("#regForm").attr("onsubmit","return false");
              } if(ulen!=0 && usname!=null){
                  $("#usernameError").html("");
                  $.post('<%=basePath%>usernameJudge?username='+usname,null,function(data){  
                    /*  console.log(data); */
                      if(data.result=='true'){
                          alert("用户名已注册，青重新输入！！");
                          $("#usernameError").html("对不起，用户名已存在！");  
                          $("#regForm").attr("onsubmit","return false");
                      }
                      else{  
                          $("#usernameError").html("恭喜您，用户名可用！");  
                          $("#regForm").attr("onsubmit","return true");  
                      }  
                  })
              }
      });  
});   
 
//密码合法性的判断  
$(function(){  
    $("#pwd").blur(function(){  
        var len = $("#pwd").val().length;  
        if(len==0){  
            $("#pwdError").html("密码不能为空！");  
            $("#regForm").attr("onsubmit","return false");  
            }  
        if(len>0&&len<6){  
            $("#pwdError").html("密码位数最少为6位！");  
            $("#regForm").attr("onsubmit","return false");  
            }  
        if(len>=6){  
            $("#pwdError").html("密码格式正确！");  
            $("#regForm").attr("onsubmit","return true");  
            }  
        })  
    })  
//确认密码  
$(function(){  
    $("#conpwd").blur(function(){  
        var oldpwd = $("#pwd").val();  
        var conpwd = $("#conpwd").val();  
        var number = $("#conpwd").val().length;  
        if(number == 0){  
            $("#conpwdError").html("密码不能为空！");  
            $("#regForm").attr("onsubmit","return false");  
        }  
        else if(oldpwd!=conpwd){  
                $("#conpwdError").html("两次密码不一致！");  
                $("#regForm").attr("onsubmit","return false");  
            }else{  
                $("#conpwdError").html("密码符合！");  
                $("#regForm").attr("onsubmit","return true");  
            }  
    })  
})  


function check(){    
     fr=document.form;    
    if(fr.username.value==""){    
       fr.username.focus();    
       return false;    
    }    
    if(fr.password.value==""){    
            fr.password.focus();    
            return false;    
    }  
    if(fr.conpassword.value==""){    
        fr.conpassword.focus();    
        return false;    
    }
    if(fr.conpassword.value != fr.password.value){    
        fr.conpassword.focus();    
        return false;    
    }
      fr.submit();  
    }    
    
</script>
</head>
<body>
    
      <h1>用户注册</h1>
      
      <form id="regForm" action="<%=basePath %>register" name="form" method="post" οnsubmit="">  
        用&nbsp;户&nbsp;名：<input type="text" id="uname" name="username" /> <span style="color: red;" id="usernameError"></span><br/>  <br/>
        密&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;码：<input type="password" id="pwd" name="password" /> <span style="color: red;" id="pwdError"></span><br/>  <br/>
        确认密码：<input type="password" id="conpwd" name="conpassword" /><span style="color: red;" id="conpwdError"></span><br/> <br/>  
        
        <button type="submit"  οnclick="return check()">注册</button>
              
    </form>
</body>
</html>

login.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录</title>
</head>
<body>
    
    <form action="<%=basePath%>login" method="post" >
        用户名：<input type="text" name = "username" ><br/>
        密码：<input type="password" name = "password" ><br/>
        <input type="submit" value="登录">
    </form>
    
</body>
</html>