SpringMVC+Spring+Mybatis框架集成详解编程语言

/* 
Navicat MySQL Data Transfer 
 
Source Server         : local 
Source Server Version : 50617 
Source Host           : localhost:3306 
Source Database       : demodb 
 
Target Server Type    : MYSQL 
Target Server Version : 50617 
File Encoding         : 65001 
 
Date: 2017-01-31 18:39:18 
*/ 
 
SET FOREIGN_KEY_CHECKS=0; 
 
-- ---------------------------- 
-- Table structure for `tb_dict` 
-- ---------------------------- 
DROP TABLE IF EXISTS `tb_dict`; 
CREATE TABLE `tb_dict` ( 
  `dictid` int(11) NOT NULL AUTO_INCREMENT COMMENT '字典id', 
  `field` varchar(15) DEFAULT NULL COMMENT '对照字段', 
  `fieldname` varchar(20) DEFAULT NULL COMMENT '对照字段名称', 
  `code` varchar(10) DEFAULT NULL COMMENT '代码', 
  `codedesc` varchar(100) DEFAULT NULL COMMENT '代码描述', 
  `enabled` varchar(2) DEFAULT '1' COMMENT '启用状态(0:禁用;1:启用)', 
  `sortno` int(4) DEFAULT NULL COMMENT '排序号', 
  PRIMARY KEY (`dictid`) 
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Records of tb_dict 
-- ---------------------------- 
INSERT INTO `tb_dict` VALUES ('1', 'SEX', '性别', '1', '男', '1', '1'); 
INSERT INTO `tb_dict` VALUES ('2', 'SEX', '性别', '2', '女', '1', '2'); 
INSERT INTO `tb_dict` VALUES ('3', 'EDU', '学历', '1', '高中', '1', '1'); 
INSERT INTO `tb_dict` VALUES ('4', 'EDU', '学历', '3', '本科', '1', '3'); 
INSERT INTO `tb_dict` VALUES ('5', 'EDU', '学历', '4', '研究生', '1', '4'); 
INSERT INTO `tb_dict` VALUES ('6', 'EDU', '学历', '5', '博士', '1', '5'); 
INSERT INTO `tb_dict` VALUES ('7', 'EDU', '学历', '2', '专科', '1', '2'); 
 
-- ---------------------------- 
-- Table structure for `tb_user` 
-- ---------------------------- 
DROP TABLE IF EXISTS `tb_user`; 
CREATE TABLE `tb_user` ( 
  `user_id` int(11) NOT NULL AUTO_INCREMENT, 
  `user_name` varchar(20) DEFAULT NULL COMMENT '姓名', 
  `user_sex` varchar(2) DEFAULT NULL COMMENT '性别', 
  `user_birthday` date DEFAULT NULL COMMENT '出生日期', 
  `user_email` varchar(50) DEFAULT NULL COMMENT '邮箱', 
  `user_edu` varchar(2) DEFAULT NULL COMMENT '学历', 
  `user_telephone` varchar(30) DEFAULT NULL COMMENT '联系方式', 
  `user_address` varchar(100) DEFAULT NULL COMMENT '住址', 
  `create_time` datetime DEFAULT NULL COMMENT '创建时间', 
  PRIMARY KEY (`user_id`) 
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; 
 
-- ---------------------------- 
-- Records of tb_user 
-- ---------------------------- 
INSERT INTO `tb_user` VALUES ('1', '李磊', '1', '1985-01-12', '[email protected]', '3', '13211335451', '北京市东城区XXXX', '2017-01-31 18:24:41'); 
INSERT INTO `tb_user` VALUES ('2', '张华', '2', '1988-11-15', '[email protected]', '3', '13811362254', '北京市西城区XXXX', '2017-01-31 18:29:08'); 
INSERT INTO `tb_user` VALUES ('3', '王媛媛', '2', '1990-04-06', '[email protected]', '3', '13511784568', '北京市西城区XXXX', '2017-01-18 10:30:48'); 
INSERT INTO `tb_user` VALUES ('4', '陈迪', '1', '1990-06-16', '[email protected]', '3', '13511697892', '北京市东城区XXXX', '2017-01-10 09:20:50'); 
INSERT INTO `tb_user` VALUES ('5', '王海东', '1', '1989-05-23', '[email protected]', '4', '13811981290', '北京市石景山区苹果园XXXXX', '2017-01-12 18:33:31'); 
INSERT INTO `tb_user` VALUES ('6', '李雪梅', '2', '1985-05-12', '[email protected]', '2', '13911378945', '北京市朝阳区XXX', '2017-01-27 18:34:42'); 
INSERT INTO `tb_user` VALUES ('7', '张扬', '1', '1988-04-12', '[email protected]', '3', '13611651245', '北京市石景山区XXXX', '2017-01-24 18:35:46'); 
INSERT INTO `tb_user` VALUES ('8', '赵庆', '1', '1986-05-06', '[email protected]', '2', '13599632147', '北京市朝阳区XXX', '2017-01-31 18:38:57');

<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.demo</groupId> 
  <artifactId>SSMProDemo</artifactId> 
  <packaging>war</packaging> 
  <version>0.0.1-SNAPSHOT</version> 
  <name>SSMProDemo Maven Webapp</name> 
  <url>http://maven.apache.org</url> 
   
  <properties> 
      <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> 
      <spring.version>4.3.0.RELEASE</spring.version> 
  </properties> 
     
  <dependencies> 
      <!--Spring框架核心库 --> 
      <dependency> 
          <groupId>org.springframework</groupId> 
          <artifactId>spring-context</artifactId> 
          <version>${spring.version}</version> 
      </dependency> 
      <!-- Spring MVC --> 
      <dependency> 
          <groupId>org.springframework</groupId> 
          <artifactId>spring-webmvc</artifactId> 
          <version>${spring.version}</version> 
      </dependency> 
      <dependency> 
          <groupId>org.springframework</groupId> 
          <artifactId>spring-context-support</artifactId> 
          <version>${spring.version}</version> 
      </dependency> 
      <!-- aspectJ AOP 织入器 --> 
      <dependency> 
          <groupId>org.aspectj</groupId> 
          <artifactId>aspectjweaver</artifactId> 
          <version>1.8.9</version> 
      </dependency> 
      <!--mybatis-spring适配器 --> 
      <dependency> 
          <groupId>org.mybatis</groupId> 
          <artifactId>mybatis-spring</artifactId> 
          <version>1.3.0</version> 
      </dependency> 
      <!--Spring java数据库访问包，在本例中主要用于提供数据源 --> 
      <dependency> 
          <groupId>org.springframework</groupId> 
          <artifactId>spring-jdbc</artifactId> 
          <version>${spring.version}</version> 
      </dependency> 
      <!--mysql数据库驱动 --> 
      <dependency> 
          <groupId>mysql</groupId> 
          <artifactId>mysql-connector-java</artifactId> 
          <version>5.1.38</version> 
      </dependency> 
      <!--log4j日志包 --> 
      <dependency> 
          <groupId>org.apache.logging.log4j</groupId> 
          <artifactId>log4j-core</artifactId> 
          <version>2.6.1</version> 
      </dependency> 
      <!-- mybatis ORM框架 --> 
      <dependency> 
          <groupId>org.mybatis</groupId> 
          <artifactId>mybatis</artifactId> 
          <version>3.4.1</version> 
      </dependency> 
      <!-- JUnit单元测试工具 --> 
      <dependency> 
          <groupId>junit</groupId> 
          <artifactId>junit</artifactId> 
          <version>4.10</version> 
      </dependency> 
      <!--c3p0 连接池 --> 
      <dependency> 
          <groupId>c3p0</groupId> 
          <artifactId>c3p0</artifactId> 
          <version>0.9.1.2</version> 
      </dependency> 
      <!-- JSTL --> 
      <dependency> 
          <groupId>javax.servlet</groupId> 
          <artifactId>jstl</artifactId> 
          <version>1.2</version> 
      </dependency> 
      <!-- Servlet核心包 --> 
      <dependency> 
          <groupId>javax.servlet</groupId> 
          <artifactId>javax.servlet-api</artifactId> 
          <version>3.0.1</version> 
          <scope>provided</scope> 
      </dependency> 
      <!--JSP --> 
      <dependency> 
          <groupId>javax.servlet.jsp</groupId> 
          <artifactId>jsp-api</artifactId> 
          <version>2.1</version> 
          <scope>provided</scope> 
      </dependency> 
      <!-- jackson --> 
      <dependency> 
          <groupId>com.fasterxml.jackson.core</groupId> 
          <artifactId>jackson-core</artifactId> 
          <version>2.5.2</version> 
      </dependency> 
      <dependency> 
          <groupId>com.fasterxml.jackson.core</groupId> 
          <artifactId>jackson-databind</artifactId> 
          <version>2.5.2</version> 
      </dependency> 
      <!--JSR303 --> 
      <dependency> 
          <groupId>org.hibernate</groupId> 
          <artifactId>hibernate-validator</artifactId> 
          <version>5.2.2.Final</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.3.1</version> 
      </dependency> 
  </dependencies> 
  <build> 
    <finalName>SSMProDemo</finalName> 
  </build> 
</project>

mysql.driver=com.mysql.jdbc.Driver 
mysql.url=jdbc:mysql://localhost:3306/ssmdb?useUnicode=true&characterEncoding=utf-8 
mysql.user=root 
mysql.password=root 
mysql.acquireIncrement=5 
mysql.initialPoolSize=10 
mysql.minPoolSize=5 
mysql.maxPoolSize=20

<?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" 
    xsi:schemaLocation="http://www.springframework.org/schema/beans 
    http://www.springframework.org/schema/beans/spring-beans-4.3.xsd 
    http://www.springframework.org/schema/context 
    http://www.springframework.org/schema/context/spring-context-4.3.xsd 
    http://www.springframework.org/schema/aop 
    http://www.springframework.org/schema/aop/spring-aop-4.3.xsd 
    http://www.springframework.org/schema/tx 
    http://www.springframework.org/schema/tx/spring-tx-4.3.xsd"> 
     
    <!-- 1.引入属性文件 --> 
    <context:property-placeholder location="classpath:config.properties" /> 
     
    <!-- 2.自动扫描service包(自动注入) --> 
    <context:component-scan base-package="com.demo.service" /> 
     
    <!-- ========================================配置数据源========================================= --> 
    <!-- 3.配置C3P0数据源 -->   
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"   
        destroy-method="close"> 
        <!--驱动类名 --> 
        <property name="driverClass" value="${mysql.driver}" /> 
        <!-- url --> 
        <property name="jdbcUrl" value="${mysql.url}" /> 
        <!-- 用户名 --> 
        <property name="user" value="${mysql.user}" /> 
        <!-- 密码 --> 
        <property name="password" value="${mysql.password}" /> 
        <!-- 当连接池中的连接耗尽的时候c3p0一次同时获取的连接数 --> 
        <property name="acquireIncrement" value="${mysql.acquireIncrement}"></property> 
        <!-- 初始连接池大小 --> 
        <property name="initialPoolSize" value="${mysql.initialPoolSize}"></property> 
        <!-- 连接池中连接最小个数 --> 
        <property name="minPoolSize" value="${mysql.minPoolSize}"></property> 
        <!-- 连接池中连接最大个数 --> 
        <property name="maxPoolSize" value="${mysql.maxPoolSize}"></property> 
        
    </bean>   
     
    <!-- ========================================针对myBatis的配置项============================== --> 
    <!-- 4.配置sqlSessionFactory --> 
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 
        <!-- 实例化sqlSessionFactory时需要使用上述配置好的数据源以及SQL映射文件 --> 
        <!-- 数据源 --> 
        <property name="dataSource" ref="dataSource" /> 
        <!-- sql映射文件路径 --> 
        <!-- 自动扫描com/demo/mapping/目录下的所有SQL映射的xml文件, 省掉Configuration.xml里的手工配置 
        value="classpath:com/demo/mapping/*.xml"指的是classpath(类路径)下com.demo.mapping包中的所有xml文件 --> 
        <property name="mapperLocations" value="classpath:com/demo/mapping/*.xml" /> 
    </bean> 
     
    <!-- 5.配置扫描器  --> 
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> 
        <!-- 扫描com.demo.dao这个包以及它的子包下的所有映射接口类 --> 
        <property name="basePackage" value="com.demo.dao" /> 
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /> 
    </bean> 
     
    <!-- ========================================配置事务============================== --> 
    <!-- 6.声明式事务管理 --> 
    <!--定义事物管理器，由spring管理事务 --> 
    <bean name="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 
        <!-- 配置数据源 --> 
        <property name="dataSource" ref="dataSource" /> 
    </bean> 
 
    <!-- 通知 --> 
    <tx:advice id="transactionAdvice" transaction-manager="transactionManager"> 
        <tx:attributes> 
             <!-- 传播行为 --> 
            <tx:method name="add*" propagation="REQUIRED" /> 
            <tx:method name="append*" propagation="REQUIRED" /> 
            <tx:method name="save*" propagation="REQUIRED" /> 
            <tx:method name="update*" propagation="REQUIRED" /> 
            <tx:method name="modify*" propagation="REQUIRED" /> 
            <tx:method name="edit*" propagation="REQUIRED" /> 
            <tx:method name="insert*" propagation="REQUIRED" /> 
            <tx:method name="delete*" propagation="REQUIRED" /> 
            <tx:method name="remove*" propagation="REQUIRED" /> 
            <tx:method name="repair" propagation="REQUIRED" /> 
 
            <tx:method name="get*" propagation="REQUIRED"  /> 
            <tx:method name="find*" propagation="REQUIRED" read-only="true" /> 
            <tx:method name="load*" propagation="REQUIRED" read-only="true" /> 
            <tx:method name="search*" propagation="REQUIRED" read-only="true" /> 
            <tx:method name="datagrid*" propagation="REQUIRED" read-only="true" /> 
 
            <tx:method name="*" propagation="REQUIRED"  /> 
        </tx:attributes> 
    </tx:advice> 
     
    <!-- 配置aop  --> 
    <aop:config> 
        <aop:pointcut id="transactionPointcut" expression="execution(* com.demo.service..*Impl.*(..))" /> 
        <aop:advisor pointcut-ref="transactionPointcut" advice-ref="transactionAdvice" /> 
    </aop:config> 
     
</beans>

<?xml version="1.0" encoding="UTF-8"?> 
<beans xmlns="http://www.springframework.org/schema/beans" 
    xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" 
    xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xsi:schemaLocation="http://www.springframework.org/schema/aop    
        http://www.springframework.org/schema/aop/spring-aop-4.3.xsd    
        http://www.springframework.org/schema/beans    
        http://www.springframework.org/schema/beans/spring-beans-4.3.xsd    
        http://www.springframework.org/schema/context    
        http://www.springframework.org/schema/context/spring-context-4.3.xsd    
        http://www.springframework.org/schema/mvc    
        http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd    
        http://www.springframework.org/schema/tx    
        http://www.springframework.org/schema/tx/spring-tx-4.3.xsd" > 
     
    <!-- 1.自动扫描包，实现支持注解的IOC  --> 
    <!-- 自动扫描该包，[email protected] --> 
    <context:component-scan base-package="com.demo.controller" />  
     
    <!-- 2.配置注解的处理器映射器和处理器适配器 --> 
    <!-- <mvc:annotation-driven /> 是一种简写形式，完全可以手动配置替代这种简写形式，简写形式可以让初学者 
        快速应用默认配置方案。<mvc:annotation-driven /> 会自动注册DefaultAnnotationHandlerMapping与 
        AnnotationMethodHandlerAdapter 两个bean,是spring [email protected] --> 
    <mvc:annotation-driven /> 
     
    <!-- 3.Spring MVC不处理静态资源  --> 
    <mvc:default-servlet-handler/> 
     
    <!-- 4.配置内部视图解析器 --> 
      <!-- 对模型视图名称的解析,即在模型视图名称添加前后缀 --> 
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> 
        <property name="prefix" value="/WEB-INF/views/" /> 
        <property name="suffix" value=".jsp" /> 
    </bean> 
     
    <!--5.配置文件上传解析器 --> 
    <!--Spring MVC默认不能识别multipart格式的文件内容 --> 
    <bean id="multipartResolver" 
        class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> 
    </bean> 
     
</beans>

<?xml version="1.0" encoding="UTF-8"?> 
<web-app id="WebApp_ID" version="3.0"  
    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"> 
     
    <!--  加载spring和mybatis的配置文件 -->  
    <context-param> 
        <param-name>contextConfigLocation</param-name> 
        <param-value>classpath:spring-mybatis.xml</param-value> 
    </context-param> 
       
    <!-- 使用ContextLoaderListener初始化Spring容器 --> 
    <!--若没有指定其他参数，默认查找的配置文件位置是：/WEB-INF/applicationContext.xml  --> 
    <listener> 
        <description>Spring容器加载监听器</description> 
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> 
    </listener> 
     
    <!-- 配置springmvc核心控制器 --> 
    <!-- spring MVC servlet --> 
    <servlet> 
        <servlet-name>SpringMVC</servlet-name> 
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> 
        <init-param> 
            <description>spring MVC 配置文件路径</description> 
            <param-name>contextConfigLocation</param-name> 
            <param-value>classpath:spring-mvc.xml</param-value> 
        </init-param> 
         <!-- 启动动优先级，越小越早加载 --> 
        <load-on-startup>1</load-on-startup> 
    </servlet> 
    <!-- Servlet访问的路径映射，所有的访问都必须经过调度用的前置控制器 --> 
    <servlet-mapping> 
        <servlet-name>SpringMVC</servlet-name> 
        <url-pattern>/</url-pattern> 
    </servlet-mapping> 
     
    <!--编码过滤器 --> 
    <filter> 
        <description>字符集过滤器</description> 
        <filter-name>encodingFilter</filter-name> 
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> 
        <init-param> 
            <description>字符集编码</description> 
            <param-name>encoding</param-name> 
            <param-value>UTF-8</param-value> 
        </init-param> 
    </filter> 
    <!-- 路径映射 --> 
    <filter-mapping> 
        <filter-name>encodingFilter</filter-name> 
        <url-pattern>/*</url-pattern> 
    </filter-mapping> 
     
      <welcome-file-list> 
        <welcome-file>index.jsp</welcome-file> 
      </welcome-file-list> 
</web-app>

package com.demo.model; 
 
import org.hibernate.validator.constraints.Email; 
import org.hibernate.validator.constraints.NotEmpty; 
 
public class User { 
     
    //用户id 
    private int user_id; 
    //姓名 
    @NotEmpty(message="{user_name.notEmpty}") 
    private String user_name; 
    //性别 
    @NotEmpty(message="{user_sex.notEmpty}") 
    private String user_sex; 
    //出生日期 
    @NotEmpty(message="{user_birthday.notEmpty}") 
    private String user_birthday; 
    //邮箱 
    @NotEmpty(message="{user_email.notEmpty}") 
    @Email(message="{user_email.wrong}") 
    private String user_email; 
    //学历 
    @NotEmpty(message="{user_edu.notEmpty}") 
    private String user_edu; 
    //联系方式 
    @NotEmpty(message="{user_telephone.notEmpty}") 
    private String user_telephone; 
    //住址 
    private String user_address; 
     
    public int getUser_id() { 
        return user_id; 
    } 
    public void setUser_id(int user_id) { 
        this.user_id = user_id; 
    } 
    public String getUser_name() { 
        return user_name; 
    } 
    public void setUser_name(String user_name) { 
        this.user_name = user_name; 
    } 
    public String getUser_sex() { 
        return user_sex; 
    } 
    public void setUser_sex(String user_sex) { 
        this.user_sex = user_sex; 
    } 
    public String getUser_birthday() { 
        return user_birthday; 
    } 
    public void setUser_birthday(String user_birthday) { 
        this.user_birthday = user_birthday; 
    } 
    public String getUser_email() { 
        return user_email; 
    } 
    public void setUser_email(String user_email) { 
        this.user_email = user_email; 
    } 
    public String getUser_edu() { 
        return user_edu; 
    } 
    public void setUser_edu(String user_edu) { 
        this.user_edu = user_edu; 
    } 
    public String getUser_telephone() { 
        return user_telephone; 
    } 
    public void setUser_telephone(String user_telephone) { 
        this.user_telephone = user_telephone; 
    } 
    public String getUser_address() { 
        return user_address; 
    } 
    public void setUser_address(String user_address) { 
        this.user_address = user_address; 
    } 
     
}

package com.demo.model; 
 
public class Dict { 
     
    //字典id 
    private int dictid; 
    //对照字段 
    private String field; 
    //对照字段名称 
    private String fieldname; 
    //代码 
    private String code; 
    //代码描述 
    private String codedesc; 
     
    public int getDictid() { 
        return dictid; 
    } 
    public void setDictid(int dictid) { 
        this.dictid = dictid; 
    } 
    public String getField() { 
        return field; 
    } 
    public void setField(String field) { 
        this.field = field; 
    } 
    public String getFieldname() { 
        return fieldname; 
    } 
    public void setFieldname(String fieldname) { 
        this.fieldname = fieldname; 
    } 
    public String getCode() { 
        return code; 
    } 
    public void setCode(String code) { 
        this.code = code; 
    } 
    public String getCodedesc() { 
        return codedesc; 
    } 
    public void setCodedesc(String codedesc) { 
        this.codedesc = codedesc; 
    } 
}

package com.demo.model; 
 
/** 
 * 用户的扩展类 
 * @author lixiaoxi 
 * 
 */ 
public class UserExtend extends User{ 
     
    // 性别描述（对应字典表里的代码描述） 
    private String user_sex_desc; 
     
    // 学历描述（对应字典表里的代码描述） 
    private String user_edu_desc; 
     
    public String getUser_sex_desc() { 
        return user_sex_desc; 
    } 
 
    public void setUser_sex_desc(String user_sex_desc) { 
        this.user_sex_desc = user_sex_desc; 
    } 
 
    public String getUser_edu_desc() { 
        return user_edu_desc; 
    } 
 
    public void setUser_edu_desc(String user_edu_desc) { 
        this.user_edu_desc = user_edu_desc; 
    } 
}

package com.demo.dao; 
 
import java.util.List; 
import org.apache.ibatis.annotations.Param; 
 
import com.demo.model.User; 
import com.demo.model.UserExtend; 
 
public interface IUserDao { 
     
    /** 
     * 查询用户信息并分页 
     * @param skip 
     * @param size 
     * @return 
     */ 
    public List<UserExtend> queryUserPager(@Param("skip") int skip,@Param("size") int size); 
     
    /** 
     * 查询用户总数 
     * @return 
     */ 
    public int queryUserCount(); 
     
    /** 
     * 根据用户id查询用户 
     * @param userid 
     * @return 
     */ 
    public User queryUserById(int userid); 
     
    /** 
     * 新增用户 
     * @param user 
     * @return 
     */ 
    public int insertUser(User user); 
     
    /** 
     * 修改用户 
     * @param user 
     * @return 
     */ 
    public int updateUser(User user); 
     
    /** 
     * 根据用户id删除用户 
     * @param user_id 
     * @return 
     */ 
    public int deleteUserById(int user_id); 
     
    /** 
     * 删除多个用户 
     * @param userIds 
     * @return 
     */ 
    public int deleteUsers(int[] userIds); 
}

package com.demo.dao; 
 
import java.util.List; 
 
import com.demo.model.Dict; 
 
public interface IDictDao { 
     
    /** 
     * 根据字段获取字典 
     * @param field 
     * @return 
     */ 
    public List<Dict> getDictByField(String field); 
}

<?xml version="1.0" encoding="UTF-8"?> 
<!DOCTYPE mapper  
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"  
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 
<!--命名空间应该是对应接口的包名+接口名 --> 
<mapper namespace="com.demo.dao.IUserDao"> 
    <!--查询用户信息并分页 --> 
    <select id="queryUserPager" resultType="com.demo.model.UserExtend"> 
        select t.user_id,t.user_name,t.user_sex,date_format(t.user_birthday,'%Y-%m-%d')user_birthday, 
        t.user_email,t.user_edu,t.user_telephone,t.user_address,p.codedesc as user_sex_desc, 
        p1.codedesc as user_edu_desc 
        from tb_user t inner join tb_dict p on t.user_sex=p.code and p.field='SEX'  
        inner join tb_dict p1 on t.user_edu = p1.code and p1.field = 'EDU' 
        order by t.create_time desc 
        limit #{skip},#{size} 
    </select> 
       
      <!--查询用户总数 --> 
    <select id="queryUserCount" resultType="int"> 
        select count(*) from tb_user 
    </select> 
     
    <!--根据用户id查询用户 --> 
    <select id="queryUserById" parameterType="int" resultType="com.demo.model.User"> 
        select user_id,user_name,user_sex,date_format(user_birthday,'%Y-%m-%d')user_birthday, 
        user_email,user_edu,user_telephone,user_address from tb_user where user_id=#{user_id} 
    </select> 
     
    <!--新增用户 --> 
    <insert id="insertUser" parameterType="com.demo.model.User"> 
        insert into tb_user(user_name,user_sex,user_birthday,user_email,user_edu,user_telephone,user_address, 
            create_time)  
        values(#{user_name},#{user_sex},str_to_date(#{user_birthday},'%Y-%m-%d'),#{user_email},#{user_edu}, 
            #{user_telephone},#{user_address},now()); 
    </insert> 
     
    <!--编辑用户 --> 
    <update id="updateUser" parameterType="com.demo.model.User"> 
        update tb_user  
        set user_name=#{user_name},user_sex=#{user_sex},user_birthday=str_to_date(#{user_birthday},'%Y-%m-%d'), 
        user_email=#{user_email},user_edu=#{user_edu},user_telephone=#{user_telephone},user_address=#{user_address}  
        where user_id=#{user_id} 
    </update> 
     
    <!--根据用户id删除用户 --> 
    <delete id="deleteUserById" parameterType="int"> 
       delete from tb_user where user_id=#{user_id} 
    </delete> 
     
    <!--删除多个用户 --> 
    <delete id="deleteUsers" parameterType="java.util.List"> 
       delete from tb_user where user_id in 
       <!-- <foreach>标签有循环的功能，可以用来生成有规律的SQL语句，主要属性有： 
        item：表示集合每一个元素进行迭代时的别名 
        index：表示在迭代过程中，每次迭代到的位置 
        open：表示该语句以什么开始 
        separator：表示每次迭代之间以什么符号作为分隔 
        close：表示该语句以什么结束 
        collection：要循环的集合 --> 
       <foreach item="item" index="index" collection="array" open="(" separator="," close=")"> 
           #{item} 
         </foreach> 
    </delete> 
</mapper>

<?xml version="1.0" encoding="UTF-8"?> 
<!DOCTYPE mapper  
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"  
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 
<!--命名空间应该是对应接口的包名+接口名 --> 
<mapper namespace="com.demo.dao.IDictDao"> 
    <!--根据字段获取字典 --> 
    <select id="getDictByField" parameterType="java.lang.String" resultType="com.demo.model.Dict"> 
       select code,codedesc from tb_dict  
       where field=#{value} and enabled='1'  
       order by sortno 
    </select> 
 
</mapper>

package com.demo.service; 
 
import java.util.List; 
 
import com.demo.model.User; 
import com.demo.model.UserExtend; 
 
/** 
 * 用户业务接口 
 * @author lixiaoxi 
 * 
 */ 
public interface IUserService { 
     
    /** 
     * 分页 
     * @param pageNO 
     * @param size 
     * @return 
     */ 
    public List<UserExtend> queryUserPager(int pageNO, int size); 
     
    /** 
     * 查询用户总数 
     * @return 
     */ 
    public int queryUserCount(); 
     
    /** 
     * 根据用户id查询用户 
     * @param userid 
     * @return 
     */ 
    public User queryUserById(int userid); 
     
    /** 
     * 新增用户 
     * @param user 
     * @return 
     */ 
    public int insertUser(User user); 
     
    /** 
     * 修改用户 
     * @param user 
     * @return 
     */ 
    public int updateUser(User user); 
     
    /** 
     * 根据用户id删除用户 
     * @param user_id 
     * @return 
     */ 
    public int deleteUserById(int user_id); 
     
    /** 
     * 删除多个用户 
     * @param userIds 
     * @return 
     */ 
    public int deleteUsers(int[] userIds); 
}

package com.demo.service; 
 
import java.util.List; 
 
import com.demo.model.Dict; 
 
/** 
 * 字典业务接口 
 * @author lixiaoxi 
 * 
 */ 
public interface IDictService { 
     
    /** 
     * 根据字段获取字典 
     * @param field 
     * @return 
     */ 
    public List<Dict> getDictByField(String field); 
}

package com.demo.service.impl; 
 
import java.util.List; 
 
import javax.annotation.Resource; 
import org.springframework.stereotype.Service; 
 
import com.demo.dao.IUserDao; 
import com.demo.model.User; 
import com.demo.model.UserExtend; 
import com.demo.service.IUserService; 
 
@Service 
public class UserServiceImpl implements IUserService{ 
     
    //自动装配 
    @Resource 
    private IUserDao userDao; 
     
    /** 
     * 分页 
     */ 
    public List<UserExtend> queryUserPager(int pageNO, int size) { 
        int skip=(pageNO-1)*size; 
        return userDao.queryUserPager(skip, size); 
    } 
     
    /** 
     * 查询用户总数 
     */ 
    public int queryUserCount() { 
        return userDao.queryUserCount(); 
    } 
     
    /** 
     * 根据用户id查询用户 
     */ 
    public User queryUserById(int userid){ 
        return userDao.queryUserById(userid); 
    } 
     
    /** 
     * 新增用户 
     */ 
    public int insertUser(User user){ 
        return userDao.insertUser(user); 
    } 
     
    /** 
     * 修改用户 
     */ 
    public int updateUser(User user){ 
        return userDao.updateUser(user); 
    } 
     
    /** 
     * 根据用户id删除用户 
     */ 
    public int deleteUserById(int user_id){ 
        return userDao.deleteUserById(user_id); 
    } 
     
    /** 
     * 删除多个用户 
     */ 
    public int deleteUsers(int[] userIds){ 
        return userDao.deleteUsers(userIds); 
    } 
}

package com.demo.service.impl; 
 
import java.util.List; 
 
import org.springframework.beans.factory.annotation.Autowired; 
import org.springframework.stereotype.Service; 
 
import com.demo.dao.IDictDao; 
import com.demo.model.Dict; 
import com.demo.service.IDictService; 
 
@Service 
public class DictServiceImpl implements IDictService{ 
     
    /** 
     * 自动装配 
     */ 
    @Autowired 
    private IDictDao dictDao; 
    /** 
     * 根据字段获取字典 
     * @param field 
     * @return 
     */ 
    public List<Dict> getDictByField(String field){ 
        return dictDao.getDictByField(field); 
    } 
 
}

package com.demo.controller; 
 
import javax.annotation.Resource; 
import javax.validation.Valid; 
 
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.web.bind.annotation.ModelAttribute; 
import org.springframework.web.bind.annotation.PathVariable; 
import org.springframework.web.bind.annotation.RequestMapping; 
import org.springframework.web.bind.annotation.RequestParam; 
import org.springframework.web.servlet.mvc.support.RedirectAttributes; 
 
import com.demo.model.User; 
import com.demo.service.IDictService; 
import com.demo.service.IUserService; 
 
@Controller 
@RequestMapping("/user") 
public class UserController { 
      
    @Resource 
    private IUserService userService; 
    @Autowired 
    private IDictService dictService; 
      
    /* 
     * 用户列表与分页Action 
     */ 
    @RequestMapping("/list") 
    public String list(Model model,@RequestParam(required=false,defaultValue="1") int pageNO){ 
        int size=5; 
        model.addAttribute("size",size); 
        model.addAttribute("pageNO",pageNO); 
        model.addAttribute("count",userService.queryUserCount()); 
        model.addAttribute("userList", userService.queryUserPager(pageNO, size)); 
        return "user/list"; 
    } 
}

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> 
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> 
<!DOCTYPE html> 
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 
<link href="<c:url value="/styles/main.css"/>"  type="text/css" rel="stylesheet" /> 
<title>用户管理</title> 
</head> 
<body> 
    <div class="main"> 
        <h2 class="title"><span>用户管理</span></h2> 
        <form action="deleteUsers" method="post"> 
        <table border="1" width="100%" class="tab"> 
            <tr> 
                <th><input type="checkbox" id="chkAll"></th> 
                <th>姓名</th> 
                <th>性别</th> 
                <th>出生日期</th> 
                <th>邮箱</th> 
                <th>学历</th> 
                <th>联系方式</th> 
                <th>家庭住址</th> 
                <th>操作</th> 
            </tr> 
            <c:forEach var="entity" items="${userList}"> 
                <tr> 
                    <th><input type="checkbox" name="user_id" value="${entity.user_id}"></th> 
                    <td>${entity.user_name}</td> 
                    <td>${entity.user_sex_desc}</td> 
                    <td>${entity.user_birthday}</td> 
                    <td>${entity.user_email}</td> 
                    <td>${entity.user_edu_desc}</td> 
                    <td>${entity.user_telephone}</td> 
                    <td>${entity.user_address}</td> 
                    <td> 
                    <a href="edit/${entity.user_id}" class="abtn">编辑</a> 
                    <a href="deleteUserById/${entity.user_id}" class="abtn">删除</a> 
                    </td> 
                </tr> 
            </c:forEach> 
        </table> 
        <div id="pager"></div> 
        <p> 
            <a href="add" class="abtn out">添加</a> 
            <input type="submit"  value="批量删除" class="btn out" onclick="return submitForm();"/> 
        </p> 
        <p style="color: red">${message}</p> 
        <!--分页 --> 
        <script type="text/javascript" src="<c:url value="/scripts/jQuery1.11.3/jquery-1.11.3.min.js"/>" ></script> 
        <link href="<c:url value="/scripts/pagination22/pagination.css"/>"  type="text/css" rel="stylesheet" /> 
        <script type="text/javascript" src="<c:url value="/scripts/pagination22/jquery.pagination2.2.js"/>" ></script> 
        <script type="text/javascript"> 
             
            $(document).ready(function(){ 
                //全选/取消全选 
                $("#chkAll").click(function(){ 
                    var checked=$("#chkAll").prop("checked"); 
                    $("input[name='user_id']").prop("checked",checked); 
                }) 
            }) 
         
           //初始化分页组件 
           var count=${count}; 
           var size=${size}; 
           var pageNO=${pageNO}; 
           $("#pager").pagination(count, { 
              items_per_page:size, 
               current_page:pageNO-1, 
               next_text:"下一页", 
               prev_text:"上一页", 
               num_edge_entries:2, 
               load_first_page:false, 
              callback:handlePaginationClick 
            }); 
            
           //回调方法 
           function handlePaginationClick(new_page_index, pagination_container){ 
               location.href="list?pageNO="+(new_page_index+1); 
           } 
            
           function submitForm(){ 
               if($("input[name='user_id']:checked").length==0){ 
                   alert("请选择要删除的记录！"); 
                   return false; 
               } 
               return true; 
           } 
        </script> 
    </form> 
    </div> 
</body> 
</html>

官网 
https://github.com/gbirke/jquery_pagination 
 
jQuery Pagination插件 
参考资料：https://github.com/gbirke/jquery_pagination 
 
jquery paginate插件可以达到我们的要求，使用如下 
 
使用： 
 
1.首先定义一个页码容器 
 
<div id="Pagination"></div> 
 
2.设置属性 
 
$("#Pagination").pagination(122, { 
items_per_page:20, 
callback:handlePaginationClick 
}); 
 
3.定义一个相应的回调函数 
 
function handlePaginationClick(new_page_index, pagination_container) {        //new_page_index:页码，从0开始，  
 
pagination_container：容器对象    return false;}这样就定制了一个简单的分页控件，如需更多功能，请参照如下属性： 
 
callback：回调函数，就是点击页码除法的js事件，如上面定义的handlePaginationClick函数，可以通过ajax读取数据，或者控制数据的显隐 
 
current_page：当前页码 
 
items_per_page：每页的条数，用于计算总页数 
 
link_to：当callback回调函数return true时页码会转到此处定义的链接，其中我们可以用__id__传入页码值 
 
num_display_entries：展示页码的总数，默认为11，如果设置为0则简单的只显示“前一页，后一页” 
 
next_text：下一页文本 
 
next_show_always：是否总显示下一页 
 
prev_text：前一页 
 
prev_show_always：是否总显示前一页 
 
num_edge_entries：显示最前几条，最后几条 
 
load_first_page：初始化插件时是否调用回调函数 
 
 
#我们还可以通过代码调用分页功能： 
$("#News-Pagination").trigger('setPage', [4]); 
// Go to the next page 
$("#News-Pagination").trigger('nextPage'); 
// Go to the previous page 
$("#News-Pagination").trigger('prevPage');

View Code

/** 
 * 添加用户 
 * @param model 
 * @return 
 */ 
@RequestMapping("/add") 
public String add(Model model){ 
    // 与form绑定的模型 
    model.addAttribute("user",new User()); 
    // 用于生成“性别”下拉列表 
    model.addAttribute("sexList",dictService.getDictByField("SEX")); 
    // 用于生成“学历”下拉列表 
    model.addAttribute("eduList",dictService.getDictByField("EDU")); 
     
    return "user/add"; 
} 
 
 /** 
  * 添加用户保存 
  * @param model 
  * @param entity 
  * @param bindingResult 
  * @return 
  */ 
 @RequestMapping("/addSave") 
 public String addSave(Model model,@ModelAttribute("user") @Valid User user,BindingResult bindingResult){ 
    //如果模型中存在错误 
    if(!bindingResult.hasErrors()){ 
        if(userService.insertUser(user)>0){ 
            return "redirect:/user/list"; 
        } 
    } 
    model.addAttribute("user", user); 
    // 用于生成“性别”下拉列表 
    model.addAttribute("sexList",dictService.getDictByField("SEX")); 
    // 用于生成“学历”下拉列表 
    model.addAttribute("eduList",dictService.getDictByField("EDU")); 
    return "user/add"; 
 }

//姓名 
@NotEmpty(message="{user_name.notEmpty}") 
private String user_name; 
//性别 
@NotEmpty(message="{user_sex.notEmpty}") 
private String user_sex; 
//出生日期 
@NotEmpty(message="{user_birthday.notEmpty}") 
private String user_birthday; 
//邮箱 
@NotEmpty(message="{user_email.notEmpty}") 
@Email(message="{user_email.wrong}") 
private String user_email; 
//学历 
@NotEmpty(message="{user_edu.notEmpty}") 
private String user_edu; 
//联系方式 
@NotEmpty(message="{user_telephone.notEmpty}") 
private String user_telephone;

user_name.notEmpty=姓名不允许为空 
user_sex.notEmpty=性别不允许为空 
user_birthday.notEmpty=出生日期不允许为空 
user_email.notEmpty=邮箱不允许为空 
user_email.wrong=邮箱格式不正确 
user_edu.notEmpty=学历不允许为空 
user_telephone.notEmpty=联系方式不允许为空

user_name.notEmpty=/u59D3/u540D/u4E0D/u5141/u8BB8/u4E3A/u7A7A 
user_sex.notEmpty=/u6027/u522B/u4E0D/u5141/u8BB8/u4E3A/u7A7A 
user_birthday.notEmpty=/u51FA/u751F/u65E5/u671F/u4E0D/u5141/u8BB8/u4E3A/u7A7A 
user_email.notEmpty=/u90AE/u7BB1/u4E0D/u5141/u8BB8/u4E3A/u7A7A 
user_email.wrong=/u90AE/u7BB1/u683C/u5F0F/u4E0D/u6B63/u786E 
user_edu.notEmpty=/u5B66/u5386/u4E0D/u5141/u8BB8/u4E3A/u7A7A 
user_telephone.notEmpty=/u8054/u7CFB/u65B9/u5F0F/u4E0D/u5141/u8BB8/u4E3A/u7A7A

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> 
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> 
<%@taglib prefix="form" uri="http://www.springframework.org/tags/form" %> 
<!DOCTYPE html> 
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8"> 
<link href="<c:url value="/styles/main.css" />" type="text/css" rel="stylesheet" /> 
<script language="javascript" type="text/javascript"  
    src="<c:url value="/scripts/My97DatePicker/WdatePicker.js" />"></script> 
<title>新增用户</title> 
</head> 
<body> 
    <div class="main"> 
        <h2 class="title"><span>新增用户</span></h2> 
        <form:form action="addSave" method="post" modelAttribute="user"> 
        <fieldset> 
            <legend>用户</legend> 
            <table cellpadding="5" cellspacing="8">  
                <tr> 
                    <td><label for="user_name">姓名：</label></td> 
                    <td><form:input path="user_name" size="40"/></td> 
                    <td><form:errors path="user_name" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_sex">性别：</label></td> 
                    <td> 
                        <form:select path="user_sex" style="width:100%"> 
                             <form:option value="">--请选择--</form:option> 
                             <form:options items="${sexList}"  itemLabel="codedesc" itemValue="code"/> 
                        </form:select> 
                    </td> 
                    <td><form:errors path="user_sex" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_birthday">出生日期：</label></td> 
                    <td><form:input path="user_birthday" size="40" class="Wdate" onClick="WdatePicker()"/></td> 
                    <td><form:errors path="user_birthday" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_email">邮箱：</label></td> 
                    <td><form:input path="user_email" size="40"/></td> 
                    <td><form:errors path="user_email" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_edu">学历：</label></td> 
                    <td> 
                         <form:select path="user_edu" style="width:100%"> 
                             <form:option value="">--请选择--</form:option> 
                             <form:options items="${eduList}"  itemLabel="codedesc" itemValue="code"/> 
                        </form:select> 
                    </td> 
                    <td><form:errors path="user_edu" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_telephone">联系方式：</label></td> 
                    <td><form:input path="user_telephone" size="40"/></td> 
                    <td><form:errors path="user_telephone" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_address">家庭住址：</label></td> 
                    <td><form:input path="user_address" size="40"/></td> 
                    <td><form:errors path="user_address" cssClass="error"></form:errors></td> 
                </tr> 
            </table> 
            <p> 
              <input type="submit" value="保存" class="btn out"> 
            </p> 
        </fieldset> 
        <!--<form:errors path="*"></form:errors> --> 
        </form:form> 
        <p style="color: red">${message}</p> 
        <p> 
            <a href="<c:url value="/user/list" />"  class="abtn out">返回列表</a> 
        </p> 
    </div> 
</body> 
</html>

 /** 
  * 编辑用户 
  * @param model 
  * @param user_id 
  * @return 
  */ 
 @RequestMapping("/edit/{user_id}") 
 public String edit(Model model,@PathVariable int user_id){ 
  
    model.addAttribute("user", userService.queryUserById(user_id)); 
    // 用于生成“性别”下拉列表 
    model.addAttribute("sexList",dictService.getDictByField("SEX")); 
    // 用于生成“学历”下拉列表 
    model.addAttribute("eduList",dictService.getDictByField("EDU")); 
    return "user/edit"; 
} 
 
/** 
 * 修改用户并保存 
 * @param model 
 * @param user 
 * @param bindingResult 
 * @return 
 */ 
@RequestMapping("/editSave") 
public String editSave(Model model,@ModelAttribute("user") @Valid User user,BindingResult bindingResult){ 
    //如果模型中存在错误 
    if(!bindingResult.hasErrors()){ 
        if(userService.updateUser(user)>0) 
        { 
            return "redirect:list";     
        } 
    } 
    model.addAttribute("user", user); 
    model.addAttribute("sexList",dictService.getDictByField("SEX")); 
    model.addAttribute("eduList",dictService.getDictByField("EDU")); 
    return "/user/edit"; 
}

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> 
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> 
<%@taglib prefix="form" uri="http://www.springframework.org/tags/form" %> 
<% 
    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"> 
<link href="<c:url value="/styles/main.css" />" type="text/css" rel="stylesheet" /> 
<script language="javascript" type="text/javascript"  
    src="<c:url value="/scripts/My97DatePicker/WdatePicker.js" />"></script> 
<title>编辑用户</title> 
<base href="<%=basePath %>" /> 
</head> 
<body> 
    <div class="main"> 
        <h2 class="title"><span>编辑用户</span></h2> 
        <form:form action="user/editSave" method="post" modelAttribute="user"> 
        <fieldset> 
            <legend>用户</legend> 
            <table cellpadding="5" cellspacing="8">  
                <tr> 
                    <td><label for="user_name">姓名：</label></td> 
                    <td><form:input path="user_name" size="40"/></td> 
                    <td><form:errors path="user_name" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_sex">性别：</label></td> 
                    <td> 
                        <form:select path="user_sex" style="width:100%"> 
                             <form:option value="">--请选择--</form:option> 
                             <form:options items="${sexList}"  itemLabel="codedesc" itemValue="code"/> 
                        </form:select> 
                    </td> 
                    <td><form:errors path="user_sex" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_birthday">出生日期：</label></td> 
                    <td><form:input path="user_birthday" size="40" class="Wdate" onClick="WdatePicker()"/></td> 
                    <td><form:errors path="user_birthday" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_email">邮箱：</label></td> 
                    <td><form:input path="user_email" size="40"/></td> 
                    <td><form:errors path="user_email" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_edu">学历：</label></td> 
                    <td> 
                         <form:select path="user_edu" style="width:100%"> 
                             <form:option value="">--请选择--</form:option> 
                             <form:options items="${eduList}"  itemLabel="codedesc" itemValue="code"/> 
                        </form:select> 
                    </td> 
                    <td><form:errors path="user_edu" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_telephone">联系方式：</label></td> 
                    <td><form:input path="user_telephone" size="40"/></td> 
                    <td><form:errors path="user_telephone" cssClass="error"></form:errors></td> 
                </tr> 
                <tr> 
                    <td><label for="user_address">家庭住址：</label></td> 
                    <td><form:input path="user_address" size="40"/></td> 
                    <td><form:errors path="user_address" cssClass="error"></form:errors></td> 
                </tr> 
            </table> 
            <p> 
                <form:hidden path="user_id" /> 
                <input type="submit" value="保存" class="btn out"> 
            </p> 
        </fieldset> 
        <!--<form:errors path="*"></form:errors> --> 
        </form:form> 
        <p style="color: red">${message}</p> 
        <p> 
            <a href="<c:url value="/user/list" />"  class="abtn out">返回列表</a> 
        </p> 
    </div> 
</body> 
</html>

/** 
 * 根据用户id删除用户 
 * @param model 
 * @param user_id 
 * @param pageNO 
 * @param redirectAttributes 
 * @return 
 */ 
@RequestMapping("/deleteUserById/{user_id}") 
public String deleteUserById(Model model,@PathVariable int user_id,@RequestParam(required=false,defaultValue="1") int pageNO, 
        RedirectAttributes redirectAttributes){ 
 
    if(userService.deleteUserById(user_id)>0){ 
        redirectAttributes.addFlashAttribute("message", "删除成功！"); 
    }else{ 
        redirectAttributes.addFlashAttribute("message", "删除失败！"); 
    } 
    return "redirect:/user/list?pageNO="+pageNO; 
} 
 
/** 
 * 删除多个用户 
 * @param model 
 * @param userIds 
 * @param pageNO 
 * @param redirectAttributes 
 * @return 
 */ 
@RequestMapping("/deleteUsers") 
public String deleteUsers(Model model,@RequestParam int[] user_id,@RequestParam(required=false,defaultValue="1") int pageNO, 
        RedirectAttributes redirectAttributes){ 
 
    if(userService.deleteUsers(user_id)>0){ 
        redirectAttributes.addFlashAttribute("message", "删除成功！"); 
    }else{ 
        redirectAttributes.addFlashAttribute("message", "删除失败！"); 
    } 
    return "redirect:/user/list?pageNO="+pageNO; 
}

package com.demo.controller; 
 
import javax.annotation.Resource; 
import javax.validation.Valid; 
 
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.web.bind.annotation.ModelAttribute; 
import org.springframework.web.bind.annotation.PathVariable; 
import org.springframework.web.bind.annotation.RequestMapping; 
import org.springframework.web.bind.annotation.RequestParam; 
import org.springframework.web.servlet.mvc.support.RedirectAttributes; 
 
import com.demo.model.User; 
import com.demo.service.IDictService; 
import com.demo.service.IUserService; 
 
@Controller 
@RequestMapping("/user") 
public class UserController { 
      
    @Resource 
    private IUserService userService; 
    @Autowired 
    private IDictService dictService; 
      
    /* 
     * 用户列表与分页Action 
     */ 
    @RequestMapping("/list") 
    public String list(Model model,@RequestParam(required=false,defaultValue="1") int pageNO){ 
        int size=5; 
        model.addAttribute("size",size); 
        model.addAttribute("pageNO",pageNO); 
        model.addAttribute("count",userService.queryUserCount()); 
        model.addAttribute("userList", userService.queryUserPager(pageNO, size)); 
        return "user/list"; 
    } 
     
    /** 
     * 添加用户 
     * @param model 
     * @return 
     */ 
    @RequestMapping("/add") 
    public String add(Model model){ 
        // 与form绑定的模型 
        model.addAttribute("user",new User()); 
        // 用于生成“性别”下拉列表 
        model.addAttribute("sexList",dictService.getDictByField("SEX")); 
        // 用于生成“学历”下拉列表 
        model.addAttribute("eduList",dictService.getDictByField("EDU")); 
         
        return "user/add"; 
    } 
     
     /** 
      * 添加用户保存 
      * @param model 
      * @param entity 
      * @param bindingResult 
      * @return 
      */ 
     @RequestMapping("/addSave") 
     public String addSave(Model model,@ModelAttribute("user") @Valid User user,BindingResult bindingResult){ 
        //如果模型中存在错误 
        if(!bindingResult.hasErrors()){ 
            if(userService.insertUser(user)>0){ 
                return "redirect:/user/list"; 
            } 
        } 
        model.addAttribute("user", user); 
        // 用于生成“性别”下拉列表 
        model.addAttribute("sexList",dictService.getDictByField("SEX")); 
        // 用于生成“学历”下拉列表 
        model.addAttribute("eduList",dictService.getDictByField("EDU")); 
        return "user/add"; 
     } 
      
     /** 
      * 编辑用户 
      * @param model 
      * @param user_id 
      * @return 
      */ 
     @RequestMapping("/edit/{user_id}") 
     public String edit(Model model,@PathVariable int user_id){ 
      
        model.addAttribute("user", userService.queryUserById(user_id)); 
        // 用于生成“性别”下拉列表 
        model.addAttribute("sexList",dictService.getDictByField("SEX")); 
        // 用于生成“学历”下拉列表 
        model.addAttribute("eduList",dictService.getDictByField("EDU")); 
        return "user/edit"; 
    } 
     
    /** 
     * 修改用户并保存 
     * @param model 
     * @param user 
     * @param bindingResult 
     * @return 
     */ 
    @RequestMapping("/editSave") 
    public String editSave(Model model,@ModelAttribute("user") @Valid User user,BindingResult bindingResult){ 
        //如果模型中存在错误 
        if(!bindingResult.hasErrors()){ 
            if(userService.updateUser(user)>0) 
            { 
                return "redirect:list";     
            } 
        } 
        model.addAttribute("user", user); 
        model.addAttribute("sexList",dictService.getDictByField("SEX")); 
        model.addAttribute("eduList",dictService.getDictByField("EDU")); 
        return "/user/edit"; 
    } 
     
    /** 
     * 根据用户id删除用户 
     * @param model 
     * @param user_id 
     * @param pageNO 
     * @param redirectAttributes 
     * @return 
     */ 
    @RequestMapping("/deleteUserById/{user_id}") 
    public String deleteUserById(Model model,@PathVariable int user_id,@RequestParam(required=false,defaultValue="1") int pageNO, 
            RedirectAttributes redirectAttributes){ 
 
        if(userService.deleteUserById(user_id)>0){ 
            redirectAttributes.addFlashAttribute("message", "删除成功！"); 
        }else{ 
            redirectAttributes.addFlashAttribute("message", "删除失败！"); 
        } 
        return "redirect:/user/list?pageNO="+pageNO; 
    } 
     
    /** 
     * 删除多个用户 
     * @param model 
     * @param userIds 
     * @param pageNO 
     * @param redirectAttributes 
     * @return 
     */ 
    @RequestMapping("/deleteUsers") 
    public String deleteUsers(Model model,@RequestParam int[] user_id,@RequestParam(required=false,defaultValue="1") int pageNO, 
            RedirectAttributes redirectAttributes){ 
 
        if(userService.deleteUsers(user_id)>0){ 
            redirectAttributes.addFlashAttribute("message", "删除成功！"); 
        }else{ 
            redirectAttributes.addFlashAttribute("message", "删除失败！"); 
        } 
        return "redirect:/user/list?pageNO="+pageNO; 
    } 
}