maven+springMVC+jdbc实现用户登录

本人刚开始接触springMVC,为了做一个登录功能，找了很多的资料，浪费了不少时间，终于实现了登录功能，不废话了，直接把代码粘贴出来，供大家参考！！！

其中目录中的一些代码与本登录无关，请忽略！！！用到的代码全部在下面。

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>   
  </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>

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>

jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/myDB
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>

User.java

package com.dong.pojo;

public class User {
    private int id;
    private String username;
    private String password;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    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;
    }
}

UserDao.java

package com.dong.dao;

import com.dong.pojo.User;

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

UserDaoImpl.java

package com.dong.dao;


import org.springframework.beans.factory.annotation.Autowired;
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 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;
    }
    
    
}

UserService.java

package com.dong.service;

import com.dong.pojo.User;

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

UserServiceImpl.java

package com.dong.service;

import javax.annotation.Resource;

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 boolean getUser(User user) {
        return dao.getUser(user);
    }    
    
}

LocalController.java

package com.dong.controller;

import javax.servlet.http.HttpServletRequest;

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 LoginController{
    
    @Autowired  
    private UserService userService;   
    @RequestMapping("/login")  
    //jsp页面通过userReg.action找到这个方法  
    public String userReg(HttpServletRequest req){  
        
        try {
            User user=new User();
            user.setUsername(req.getParameter("username"));
                 user.setPassword(req.getParameter("password"));
                 boolean falg=userService.getUser(user);
                 if (falg==true) {
                 return "/loginSuccess";  
                 }else{
               return "/loginError";
                 }
             
        } catch (Exception e) {
            return "/loginError";
        }  
    } 
}

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>
<script type="text/javascript" src="<%=basePath %>js/jquery-1.9.1.js"></script>

<script>
/* 用户名合法性的判断  */
$(function(){  
    $("#uname").blur(function(){  
        var u = $("#uname").val();  
        var len = $("#uname").val().length;  
        if(len==0||u==null){  
             $("#usernameError").html("用户名不能为空！");  
             $("#loginForm").attr("onsubmit","return false");  
        }
        if(len!=0 && u!=null){  
               $("#usernameError").html("");  
            $("#loginForm").attr("onsubmit","return true");  
        }   
     });  
});

/* 密码合法性的判断   */
$(function(){  
    $("#psd").blur(function(){  
        var len = $("#psd").val().length;  
        if(len==0){  
            $("#passwordError").html("密码不能为空！");  
            $("#loginForm").attr("onsubmit","return false");  
        }
        if(len!=0){  
            $("#passwordError").html("");
            $("#loginForm").attr("onsubmit","return true");  
        }  
    })  
})

/* 验证码的判断 */
$(function(){  
    $("#authCode").blur(function(){  
        var strCode = $.ajax({
            
            url:'com/dong/controller/LocalController/getAuthCode',
            type:'post', //数据发送方式
            dataType:'json', //接受数据格式 (这里有很多,常用的有html,xml,js,json)
            data:$("#strCode").val(),  //要传递的数据
            error: function(){         //失败
            alert('Error loading document');
            },
            success: function(msg){ //成功
            alert( "Data Saved: " + msg );
            }
            });
        var inpCode = $("#authCode").val();   
        var len = $("#authCode").val().length;  
        if(len==0){  
            $("#authCodeError").html("验证码不能为空！");  
            $("#loginForm").attr("onsubmit","return false");  
        }
       
        if(inpCode != strCode){
            $("#authCodeError").html("验证码不正确！");
            $("#loginForm").attr("onsubmit","return false");  
        }
        if(inpCode == strCode){  
            $("#authCodeError").html("");  
            $("#loginForm").attr("onsubmit","return turn");  
        }

    })  
})



function chageCode(){
    $('#codeImage').attr('src','<%=basePath%>authCode?abc='+Math.random());    //链接后添加Math.random，确保每次产生新的验证码，避免缓存问题
}

/* 然后添加自定义的验证码验证方法 */
 /*    $.validator.addMethod("checkCode", function(value, element) {       
                var strCode = ${strCode};     //这里用的freemarke取到后台保存在session中的验证码字符。
                var inpCode = $('#authCode').val();
                if(strCode==""||strCode == null){
                    chageCode();
                    //用后台的字符与页面输入的验证码进行比较
                }else if(inpCode == strCode){
                    return true;
                }else{
                    return false;
                }
         }, "验证码不正确");  */
         
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.authCode.value==""){    
                 fr.authCode.focus();    
                 return false;    
             }  
               fr.submit();  
             }     

</script>
</head>
<body>
    
    <h1>登录</h1>
    <form action="<%=basePath%>login" id="loginForm" name="form" method="post" οnsubmit="">
        用户名：<input type="text" id="uname" name="username"/>      <span style="color: red;" id="usernameError"></span><br> <br> <br>
        密&nbsp;&nbsp;&nbsp;码：<input type="password" id = "psd" name="password"/>  <span style="color: red;" id="passwordError"></span><br> <br>
        
        验证码：<input type="text" id="authCode" name="authCode"  /> <span style="color: red;" id="authCodeError"></span>
        <!--这里img标签的src属性的值为后台实现图片验证码方法的请求地址-->
        <img  src="<%=basePath%>authCode" id="codeImage" οnclick="chageCode()" title="图片看不清？点击重新得到验证码" style="cursor:pointer;"/>
        <a οnclick="chageCode()">换一张</a><br> <br>
        
        <button type="submit"  οnclick="return check()">登录</button>
       
        <input type="button" value="注册" οnclick="window.location.href='register.jsp';"/>
              
    </form>
    
</body>
</html>

loginSuccess.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 PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<base href="<%=basePath%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
    <center><h3>登录成功</h3></center>
</body>
</html>

loginError.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 PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<base href="<%=basePath%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
        <center><h3>帐号或密码错误，请重新输入！</h3></center>
</body>
</html>