SpringMVC+SpringJDBC搭建的项目Demo

最新推荐文章于 2024-08-18 11:24:10 发布

figerZpeng

最新推荐文章于 2024-08-18 11:24:10 发布

阅读量4.6k

点赞数

分类专栏： JavaWeb 文章标签： springmvc springjdbc maven demo

本文链接：https://blog.csdn.net/u014305991/article/details/44986097

版权

JavaWeb 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

概要：
一、项目目录
二、配置详情
三、测试代码
四、测试结果

内容：
一、项目目录
这里写图片描述

二、配置详情
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" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
  <display-name></display-name>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>

  <!-- Spring监听 -->
  <listener>
    <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
  </listener>

  <!-- ApplicationContext 的Listener配置方式  start-->
  <listener>
       <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
  </context-param>
  <!-- ApplicationContext 的Listener配置方式  end-->

  <!-- springmvc -->
  <servlet>
    <servlet-name>spring</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <!-- 自定义spring mvc的配置文件名称和路径 -->
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:spring-servlet.xml</param-value>
    </init-param>
    <!-- 自定义启动顺序，让这个Servlet随Servlet容器一起启动 -->
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>spring</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping> 

  <!-- 编码过虑 --> 
  <filter>
    <filter-name>setcharacter</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>
  </filter>
  <filter-mapping>
    <filter-name>setcharacter</filter-name>
    <url-pattern>/</url-pattern>
  </filter-mapping>

  <!-- 解决HTTP PUT请求Spring无法获取请求参数的问题 -->  
  <filter>  
      <filter-name>HiddenHttpMethodFilter</filter-name>  
      <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>  
  </filter>  
  <filter-mapping>  
      <filter-name>HiddenHttpMethodFilter</filter-name>  
      <servlet-name>springMVC3</servlet-name>  
  </filter-mapping>  
</web-app>

applicationContext.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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:util="http://www.springframework.org/schema/util"
    xsi:schemaLocation="http://www.springframework.org/schema/beans 
       http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
       http://www.springframework.org/schema/context 
       http://www.springframework.org/schema/context/spring-context-4.0.xsd
       http://www.springframework.org/schema/tx 
       http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
       http://www.springframework.org/schema/aop
       http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
       http://www.springframework.org/schema/mvc
       http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
       http://www.springframework.org/schema/util 
       http://www.springframework.org/schema/util/spring-util-4.1.xsd">

    <!-- 加载JDBC配置文件 -->
    <context:property-placeholder location="classpath:jdbc.properties" />

    <!-- 扫描类包，将标注Spring注解的类自动转化Bean，同时完成Bean的注入 -->
    <context:component-scan base-package="com.service" />
    <context:component-scan base-package="com.dao" />

    <!-- 配置数据源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
        destroy-method="close">
        <property name="driverClass">
            <value>${jdbc.driverClassName}</value>
        </property>
        <property name="jdbcUrl">
            <value>${jdbc.url}</value>
        </property>
        <property name="user">
            <value>${jdbc.username}</value>
        </property>
        <property name="password">
            <value>${jdbc.password}</value>
        </property>
        <!--连接池中保留的最小连接数。 -->
        <property name="minPoolSize">
            <value>5</value>
        </property>
        <!--连接池中保留的最大连接数。Default: 15 -->
        <property name="maxPoolSize">
            <value>30</value>
        </property>
        <!--初始化时获取的连接数，取值应在minPoolSize与maxPoolSize之间。Default: 3 -->
        <property name="initialPoolSize">
            <value>10</value>
        </property>
        <!--最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->
        <property name="maxIdleTime">
            <value>60</value>
        </property>
        <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->
        <property name="acquireIncrement">
            <value>5</value>
        </property>
        <!--JDBC的标准参数，用以控制数据源内加载的PreparedStatements数量。但由于预缓存的statements 属于单个connection而不是整个连接池。所以设置这个参数需要考虑到多方面的因素。 
                                    如果maxStatements与maxStatementsPerConnection均为0，则缓存被关闭。Default: 0 -->
        <property name="maxStatements">
            <value>0</value>
        </property>
        <!--每60秒检查所有连接池中的空闲连接。Default: 0 -->
        <property name="idleConnectionTestPeriod">
            <value>60</value>
        </property>
        <!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->
        <property name="acquireRetryAttempts">
            <value>30</value>
        </property>
        <!--获取连接失败将会引起所有等待连接池来获取连接的线程抛出异常。但是数据源仍有效 保留，并在下次调用getConnection()的时候继续尝试获取连接。如果设为true，那么在尝试 
                                    获取连接失败后该数据源将申明已断开并永久关闭。Default: false -->
        <property name="breakAfterAcquireFailure">
            <value>true</value>
        </property>
        <!--因性能消耗大请只在需要的时候使用它。如果设为true那么在每个connection提交的 时候都将校验其有效性。建议使用idleConnectionTestPeriod或automaticTestTable 
                                    等方法来提升连接测试的性能。Default: false -->
        <property name="testConnectionOnCheckout">
            <value>false</value>
        </property>
    </bean>

    <!-- 配置Jdbc模板 -->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!-- 提供对lob字段的支持 -->
    <bean id="nativeJdbcExtractor"
        class="org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor"
        lazy-init="true" />

    <!--如果底层数据库是 DB2、SQL Server、MySQL 等非 Oracle 的其它数据库，则只要简单配置一个 DefaultLobHandler-->
    <bean id="lobHandler"
        class="org.springframework.jdbc.support.lob.DefaultLobHandler"
        lazy-init="true" />

    <!-- 配置事务管理器 -->
    <bean id="transactionManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
        p:dataSource-ref="dataSource" />

    <!-- 通过AOP配置提供事务增强，让service包下所有Bean的所有方法拥有事务 -->
   <!--  <aop:config proxy-target-class="true"> 
        <aop:pointcut id="serviceMethod"
            expression=" execution(* com.service..*(..))" />
        <aop:advisor pointcut-ref="serviceMethod" advice-ref="txAdvice" />
    </aop:config>
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="*" />
        </tx:attributes>
    </tx:advice> -->

</beans>

spring-servlet.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:jee="http://www.springframework.org/schema/jee"
    xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
    xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:util="http://www.springframework.org/schema/util"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context-4.0.xsd
       http://www.springframework.org/schema/jee
       http://www.springframework.org/schema/jee/spring-jee-4.1.xsd
       http://www.springframework.org/schema/mvc
       http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd
       http://www.springframework.org/schema/util 
       http://www.springframework.org/schema/util/spring-util-4.1.xsd">

    <context:annotation-config />
    <context:component-scan base-package="com.controller" />
    <context:component-scan base-package="com.service" />
    <context:component-scan base-package="com.dao" />

     <!-- 注解驱动 -->
    <mvc:annotation-driven />
    <mvc:resources mapping="/resources/**" location="/resources/" />

    <!-- 视图解析 --> 
    <bean
        class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/views/" />
        <property name="suffix" value=".jsp" />
    </bean>

    <!-- Invokes Spring MVC @Controller methods -->  
    <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">  
        <property name="webBindingInitializer">  
            <!-- Configures Spring MVC DataBinder instances -->  
            <bean class="org.springframework.web.bind.support.ConfigurableWebBindingInitializer">  
                <property name="validator" ref="validator" />  
            </bean>  
        </property>  

        <!-- <property name="messageConverters">  
            <util:list id="beanList">  
                <ref bean="mappingJacksonHttpMessageConverter"/>  
            </util:list>  
        </property>   -->
    </bean> 

    <!-- 输出对象转JSON支持 -->  
    <bean id="jsonConverter"  
        class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"></bean>  
    <bean  
        class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">  
        <property name="messageConverters">  
            <list>  
                <ref bean="jsonConverter" />  
            </list>  
        </property>  
    </bean>  

    <!-- <bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">  
        <property name="supportedMediaTypes">  
            <list>  
                <value>text/html;charset=UTF-8</value>  
            </list>  
        </property>  
    </bean>   -->

    <!-- Creates the JSR-303 Validator -->  
    <bean id="validator" class="org.springframework.validation.beanvalidation.LocalValidatorFactoryBean" />

    <!-- 配置一个MultipartResolver，在这里我们使用支持Commons FileUpload的CommonsMultipartResolver:  -->
    <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver" p:defaultEncoding="utf-8" p:maxUploadSize="5000000"/>



     <!-- 全局异常配置 start -->     
   <bean id="exceptionResolver" class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">     
         <property name="exceptionMappings">     
             <props>     
                 <prop key="com.exception.UserException">errors/error</prop> 
                 <prop key="java.lang.Exception">errors/error</prop>     
                 <prop key="java.lang.Throwable">errors/err</prop>     
             </props>     
         </property>     
         <property name="statusCodes">     
             <props>     
                 <prop key="errors/error">500</prop>     
                 <prop key="errors/404">404</prop>     
             </props>     
         </property>     
         <!-- 设置日志输出级别，不定义则默认不输出警告等错误日志信息      -->
         <property name="warnLogCategory" value="WARN"></property>     
         <!-- 默认错误页面，当找不到上面mappings中指定的异常对应视图时，使用本默认配置 -->     
         <property name="defaultErrorView" value="errors/error"></property>     
         <!-- 默认HTTP状态码    -->  
         <property name="defaultStatusCode" value="500"></property>   
     </bean>      
     <!-- 全局异常配置 end -->   


      <!-- 加载JDBC配置文件 -->
    <context:property-placeholder location="classpath:jdbc.properties" />

    <!-- 扫描类包，将标注Spring注解的类自动转化Bean，同时完成Bean的注入 -->
    <context:component-scan base-package="com.service" />
    <context:component-scan base-package="com.dao" />

    <!-- 配置数据源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
        destroy-method="close">
        <property name="driverClass">
            <value>${jdbc.driverClassName}</value>
        </property>
        <property name="jdbcUrl">
            <value>${jdbc.url}</value>
        </property>
        <property name="user">
            <value>${jdbc.username}</value>
        </property>
        <property name="password">
            <value>${jdbc.password}</value>
        </property>
        <!--连接池中保留的最小连接数。 -->
        <property name="minPoolSize">
            <value>5</value>
        </property>
        <!--连接池中保留的最大连接数。Default: 15 -->
        <property name="maxPoolSize">
            <value>30</value>
        </property>
        <!--初始化时获取的连接数，取值应在minPoolSize与maxPoolSize之间。Default: 3 -->
        <property name="initialPoolSize">
            <value>10</value>
        </property>
        <!--最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->
        <property name="maxIdleTime">
            <value>60</value>
        </property>
        <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->
        <property name="acquireIncrement">
            <value>5</value>
        </property>
        <!--JDBC的标准参数，用以控制数据源内加载的PreparedStatements数量。但由于预缓存的statements 属于单个connection而不是整个连接池。所以设置这个参数需要考虑到多方面的因素。 
                                    如果maxStatements与maxStatementsPerConnection均为0，则缓存被关闭。Default: 0 -->
        <property name="maxStatements">
            <value>0</value>
        </property>
        <!--每60秒检查所有连接池中的空闲连接。Default: 0 -->
        <property name="idleConnectionTestPeriod">
            <value>60</value>
        </property>
        <!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->
        <property name="acquireRetryAttempts">
            <value>30</value>
        </property>
        <!--获取连接失败将会引起所有等待连接池来获取连接的线程抛出异常。但是数据源仍有效 保留，并在下次调用getConnection()的时候继续尝试获取连接。如果设为true，那么在尝试 
                                    获取连接失败后该数据源将申明已断开并永久关闭。Default: false -->
        <property name="breakAfterAcquireFailure">
            <value>true</value>
        </property>
        <!--因性能消耗大请只在需要的时候使用它。如果设为true那么在每个connection提交的 时候都将校验其有效性。建议使用idleConnectionTestPeriod或automaticTestTable 
                                    等方法来提升连接测试的性能。Default: false -->
        <property name="testConnectionOnCheckout">
            <value>false</value>
        </property>
    </bean>

    <!-- 配置Jdbc模板 -->
    <!-- <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean> -->
</beans>

jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test
jdbc.username=root
jdbc.password=root

log4j.properties

log4j.rootLogger=DEBUG,A1
# \u8f93\u51fa\u5230\u63a7\u5236\u53f0 
log4j.appender.A1=org.apache.log4j.ConsoleAppender 
log4j.appender.A1.layout=org.apache.log4j.PatternLayout 
log4j.appender.A1.layout.ConversionPattern=%d{yyyy-MM-dd HH\:mm\:ss} [\u65E5\u5FD7\u4FE1\u606F] %m%n

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.typ.spring</groupId>
  <artifactId>maven-springmvc-springjdbc</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>maven-springmvc-springjdbc Maven Webapp</name>
  <url>http://maven.apache.org</url>

  <properties>
       <spring.version>4.1.4.RELEASE</spring.version>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>${spring.version}</version>
        <scope>test</scope>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>1.8.5</version>
    </dependency>

     <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.35</version>
    </dependency>

    <dependency>
        <groupId>com.mchange</groupId>
        <artifactId>c3p0</artifactId>
        <version>0.9.5</version>
    </dependency>

    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>

   <dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-validator</artifactId>
    <version>5.1.2.Final</version>
   </dependency>

    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.1</version>
    </dependency>


    <!-- json -->
    <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>2.5.2</version>
    </dependency>
    <dependency>
      <groupId>org.codehaus.jackson</groupId>
      <artifactId>jackson-core-asl</artifactId>
      <version>1.9.13</version>
    </dependency>

    <dependency>
      <groupId>org.codehaus.jackson</groupId>
      <artifactId>jackson-mapper-asl</artifactId>
      <version>1.9.13</version>
    </dependency>
    <!-- json -->

    <dependency>
        <groupId>com.thoughtworks.xstream</groupId>
        <artifactId>xstream</artifactId>
        <version>1.4.7</version>
    </dependency>

  </dependencies>
  <build>
    <finalName>maven-springmvc-springjdbc</finalName>

    <plugins>
        <plugin>
          <groupId>org.apache.maven.plugins</groupId>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>2.3.2</version>
          <configuration>
          <source>1.7</source>
          <target>1.7</target>
          </configuration>
      </plugin>
    </plugins>
  </build>
</project>

三、测试代码
1.controller:

UserController.java

package com.controller;

import java.io.File;
import java.io.IOException;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.apache.commons.io.FileUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.ExceptionHandler;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;

import com.exception.UserException;
import com.model.User;
import com.service.UserService;

@Controller
@RequestMapping(value="/user")
public class UserController {


    @Autowired
    private UserService userService;

    public UserController() {
    }

    @RequestMapping(value="users", method=RequestMethod.GET)
    public String list(Model model){
        Map<String, User> users = new HashMap<String, User>();
        for (User user : userService.getAllUsers()) {
            users.put(user.getUsername(), user);
        }

        model.addAttribute("users", users);
        return "user/list";
    }

    @RequestMapping(value="add", method=RequestMethod.GET)
    public String add(@ModelAttribute("user") User user){
        return "user/add";
    }

    @RequestMapping(value="add", method=RequestMethod.POST)
    public String add(@Validated User user, BindingResult br, @RequestParam(value="attach") MultipartFile[] attachs, HttpServletRequest req) throws IOException{
        if (br.hasErrors()) {
            return "user/add";
        }

        String realPath = req.getSession().getServletContext().getRealPath("/resources/upload");

        for (int i = 0; i < attachs.length; i++) {
            MultipartFile attach = attachs[i];
            if (attach.isEmpty()) {
                continue;
            }

            File attachFile = new File(realPath + "/" + attach.getOriginalFilename());
            FileUtils.copyInputStreamToFile(attach.getInputStream(), attachFile);
            System.out.println(realPath + "/" + attach.getOriginalFilename());

            System.out.println(attach.getName());
            System.out.println(attach.getOriginalFilename());
            System.out.println(attach.getContentType());
        }

        userService.register(user);
        return "redirect:/user/users";
    }

    @RequestMapping(value="/{username}/show", method=RequestMethod.GET)
    public String show(@PathVariable String username, Model model){
        model.addAttribute(userService.getUserByUsername(username));
        return "user/show";
    }

    @RequestMapping(value="/{username}/show", method=RequestMethod.GET, params="json")
    @ResponseBody
    public User show(@PathVariable String username){
        return userService.getUserByUsername(username);
    }

    @RequestMapping(value="/{username}/update", method=RequestMethod.GET)
    public String update(@PathVariable String username, Model model){
        model.addAttribute(userService.getUserByUsername(username));
        return "user/update";
    }

    @RequestMapping(value="/{username}/update", method=RequestMethod.POST)
    public String update(@PathVariable String username, @Validated User user, BindingResult br){
        if(br.hasErrors()){
            return "user/update";
        }

        userService.update(user);
        return "redirect:/user/users";
    }

    @RequestMapping(value="/{username}/delete", method=RequestMethod.GET)
    public String delete(@PathVariable String username){
        userService.removeUser(username);
        return "redirect:/user/users";
    }

    @RequestMapping(value="/login", method=RequestMethod.POST)
    public String login(String username, String password, HttpSession session){
        if (null == username || "".equals(username.trim())) {
            throw new UserException("用户名不能为空");
        }

        User user = userService.getUserByUsername(username);
        if (null == user) {
            throw new UserException("用户名不存在");
        }

        if (!user.getPassword().equals(password)) {
            throw new UserException("密码不正确");
        }

        session.setAttribute("loginUser", user);
        return "redirect:/user/users";
    }

    @RequestMapping(value="/logout", method=RequestMethod.GET)
    public String logout(HttpSession session){
        session.removeAttribute("loginUser");
        return "forward:/user/users";
    }

    @ExceptionHandler(value={UserException.class})
    public String handleLocalException(UserException e, HttpServletRequest req){
        req.setAttribute("error", e);
        return "user/error";
    }

//  @RequestMapping(value="{id}/update", method=RequestMethod.GET)
//  public String update(@PathVariable({id}) ){}



    /*
    @Autowired
    private UserService userService;

    @RequestMapping({"/user/welcomeView","/user/welcome"})
    public String loginView(String username,Model model){
        System.out.println(username);
        model.addAttribute("username", username);
        //model.addAttribute(new User());
        return "welcome";
    }

    @RequestMapping({"/user/registerView"})
    public String registerView(){
        return "register";
    }

    @RequestMapping("/welcome")
    public ModelAndView welcome(){
        ModelAndView mav = new ModelAndView();
        mav.addObject("welcome", "welcome you!");
        mav.setViewName("welcome");
        return mav;
    }

    @RequestMapping("/user/login")
    public ModelAndView login(User user){
        ModelAndView mav = new ModelAndView();
        User u = userService.loginCheck(user);
        if(null == u){
            mav.setViewName("login");
            mav.addObject("errorMsg","用户名或密码有误！");
            return mav;
        }
        else{
            mav.setViewName("success");
            mav.addObject("user", u);
            return mav;
        }
    }

    @RequestMapping("/user/register")
    public ModelAndView register(User user){
        ModelAndView mav = new ModelAndView();
        if(userService.register(user)){
            mav.setViewName("register_succ");
            return mav;
        }
        else{
            mav.setViewName("register");
            mav.addObject("errorMsg","用户名已被占用，请更换！！");
            return mav;
        }
    }*/
}

WelcomeController.java

package com.controller;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

@Controller
public class WelcomeController {
    public WelcomeController() {
    }

    @RequestMapping(value="login", method=RequestMethod.GET)
    public String welcome(){
        return "welcome";
    }
}

2.dao
UserDao.java

package com.dao;

import java.util.List;

import com.model.User;

public interface UserDao {
    public void register(User user);
    public User findUserByUserName(final String userName);
    public List<User> findAllUser();
    public boolean deleteByUsername(String username);
    public boolean update(User user);
}

UserDaoImpl.java

package com.dao.implement;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

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

import com.dao.UserDao;
import com.model.User;

@Repository("userDao")
public class UserDaoImpl implements UserDao {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    public UserDaoImpl(){
    }

    public void register(User user) {
        String sqlStr = "insert into user(userName,password) values(?,?)";
        Object[] params = new Object[]{user.getUsername(),user.getPassword()};
        jdbcTemplate.update(sqlStr, params);
    }

    public User findUserByUserName(String userName) {
        String sqlStr = "select * from user where userName = ?" ;
        List<User> users = jdbcTemplate.query(sqlStr,new Object[]{userName} , new UserRowMapper());

       /* jdbcTemplate.query(sqlStr, new Object[]{userName}, new RowCallbackHandler() {
            public void processRow(ResultSet rs) throws SQLException {
                user.setId(rs.getInt("id"));
                user.setUsername(rs.getString("userName"));
                user.setPassword(rs.getString("password"));
            }
        });*/
        if (null != users && !users.isEmpty()) {
            return users.get(0);
        }
        return null;
    }

    @Override
    public boolean deleteByUsername(String username){
        int updateNum = jdbcTemplate.update("delete from user where username = '" + username + "'");

        if (updateNum != 1) {
            return false;
        }

        return true;
    }

    @Override
    public List<User> findAllUser() {
        return jdbcTemplate.query("select * from user", new UserRowMapper());
    }

    private static class UserRowMapper implements RowMapper <User> {

        public User mapRow(ResultSet rs, int rowNum) throws SQLException {
            int i = 1;
            User user = new User();
            user.setId(rs.getInt(i++));
            user.setUsername(rs.getString(i++));
            user.setPassword(rs.getString(i++));
            return user;
        }

    }

    @Override
    public boolean update(User user) {
        return jdbcTemplate.update("update user set password = " + user.getPassword() + " where username = '" + user.getUsername() + "'") == 1 ? true : false;
    }

}

3.exception
UserException.java

package com.exception;

public class UserException extends RuntimeException {

    public UserException(String string) {
        super(string);
    }

}

4.model
User.java

package com.model;

import java.io.Serializable;






import javax.validation.constraints.Max;
import javax.validation.constraints.Min;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;

import org.hibernate.validator.constraints.NotEmpty;

@SuppressWarnings("serial")
public class User implements Serializable {
    private Integer id;
    private String username;
    private String password;

    public User(){}

    public User(Integer id, String username, String password) {
        super();
        this.id = id;
        this.username = username;
        this.password = password;
    }

    @NotEmpty(message="username shouln't null!")
    @Size(min=3,max=10,message="username must between 3 and 10!")
    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    @NotEmpty(message="username shouldn't null!")
    @Size(min=3,max=10,message="password must between 3 and 10!")
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }

    @NotNull(message="id shouldn't empty!")
    @Min(value=3,message="username must > 3")
    @Max(value=100000,message="username must < 10")
    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }


}

5.service
UserService.java

package com.service;

import java.util.List;

import com.model.User;

public interface UserService {
    public boolean register(User user);
    public User loginCheck(User user);
    public List<User> getAllUsers();
    public boolean removeUser(String username);
    public User getUserByUsername(String username);
    public boolean update(User user);
}

UserServiceImpl.java

package com.service.implement;

import java.util.List;

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




import com.dao.UserDao;
import com.model.User;
import com.service.UserService;

@Service("userService")
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDao userDao;

    public UserServiceImpl() {
    }

    @Override
    public List<User> getAllUsers() {
        return userDao.findAllUser();
    }

    @Override
    public boolean register(User user) {
        User u =  userDao.findUserByUserName(user.getUsername());

        if(u == null || u.getId() == null || u.getId() == 0){
            userDao.register(user);
            return true;
        }else{
            System.out.println("id="+u.getId()+",  userName="+u.getUsername()+", password="+u.getPassword());
            return false;
        }
    }

    @Override
    public User loginCheck(User user) {
        User u  = userDao.findUserByUserName(user.getUsername());
        System.out.println("id="+u.getId()+",  userName="+u.getUsername()+", password="+u.getPassword());
        if(user.getPassword().equals(u.getPassword())){
            return u;
        }
        else{
            return null;
        }
    }

    @Override
    public boolean removeUser(String username){
        if (userDao.deleteByUsername(username)) {
            return true;
        }


        return false;
    }

    @Override
    public User getUserByUsername(String username) {
        return userDao.findUserByUserName(username);
    }

    @Override
    public boolean update(User user) {
        return userDao.update(user);
    }

}

6.views
add.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="sf" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>
    add
</title>
</head>
<body>
<sf:form method="post" modelAttribute="user" enctype="multipart/form-data">
    id<sf:input path="id" /><sf:errors path="id"></sf:errors><br>
    username<sf:input path="username"/><sf:errors path="username"></sf:errors><br>
    password<sf:input path="password"/><sf:errors path="password"></sf:errors><br>
    upload<input type="file" name="attach"><br>
    <input type="file" name="attach"><br>
    <input type="file" name="attach"><br>
    <input type="file" name="attach"><br>
    <input type="submit" value="添加用户">
</sf:form>

</body>
</html>

error.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="sf" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>
    error page (local)
</title>
</head>
<body>
    <h1>${error.message}</h1>
</body>
</html>

list.jsp

<%@page import="com.model.User"%>
<%@page import="org.eclipse.jdt.internal.compiler.batch.Main"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
User user = (User)session.getAttribute("loginUser");
boolean isLogin = null == user ? false : true;
%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>
    list
</title>
<link rel="stylesheet" href="<%=request.getContextPath()%>/resources/styles/main.css" type="text/css">
</head>
<body>
<a href="add" >add</a>
<h1>————————>${loginUser.username} ---
<c:if test="<%=isLogin %>">
<a href="logout">logout</a>
</c:if>
</h1>
<br>
<c:forEach items="${users}" var="uentry">
    =============${uentry.value.id}
    =============<a href="${uentry.value.username}/show"> ${uentry.value.username}</a>
    =============${uentry.value.password}
    <a href="${uentry.value.username}/update">update</a>
    <a href="${uentry.value.username}/delete">delete</a><br>
</c:forEach>

</body>
</html>

list.jsp

<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="sf" %>
<%
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>
    show
</title>
</head>
<body>
    id: ${user.id}<br>
    username: ${user.username}<br>
    password: ${user.password}<br>
    <a href="user/users">return main page</a>
</body>
</html>

update.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="sf" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>
    update
</title>
</head>
<body>
<sf:form method="post" modelAttribute="user">
    id<sf:input path="id" /><sf:errors path="id"></sf:errors><br>
    username<sf:input path="username"/><sf:errors path="username"></sf:errors><br>
    password<sf:input path="password"/><sf:errors path="password"></sf:errors><br>
    <input type="submit" value="修改用户">
</sf:form>

</body>
</html>

welcome.jsp

<%@ page language="java" contentType="text/html; utf-8" pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>sprint hello</title>
</head>

<body>  
    hello please login!<br>

    <form action="user/login" method="post">
        username:<input name="username" type="text"><br>
        password:<input name="password" type="text"><br>
        <input type="submit" value="login">
    </form>


</body>

</html>

user.sql

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(30) DEFAULT NULL,
  `password` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;