ssm分页增删改查

怼烎@ 2022-02-19 07:27 386阅读 0赞

ssm分页增删改查，博主技术有限，暂时就这样啦….

如果觉得文章不错，对你有帮助，请作者喝杯咖啡，谢谢！如果对您有帮助 ，请多多支持.多少都是您的心意与支持，一分也是爱，再次感谢！！！打开支付宝首页搜“556723462”领红包，领到大红包的小伙伴赶紧使用哦！感谢大家的支持！您的支持，我会继续分享更多的文章，欢迎关注！

70

先看效果图如下：里面的人物都是博主一 个一个手敲的。三国迷一个…哈哈

原码下载地址：https://download.csdn.net/download/qq_30764991/11117980

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMwNzY0OTkx_size_16_color_FFFFFF_t_70watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMwNzY0OTkx_size_16_color_FFFFFF_t_70 1

项目结构图：

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMwNzY0OTkx_size_16_color_FFFFFF_t_70 2

数据库表与数据：

  1. CREATE TABLE `tb_user` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `userName` varchar(40) DEFAULT NULL,
  4.   `password` varchar(100) DEFAULT NULL,
  5.   `email` varchar(40) DEFAULT NULL,
  6.   `phone` varchar(40) DEFAULT NULL,
  7.   `roleName` varchar(40) DEFAULT NULL,
  8.   PRIMARY KEY (`id`)
  9. ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
  11. INSERT INTO `tb_user` VALUES ('7', '张飞', '123456', '123456@qq.com', '10086', '将军');
  12. INSERT INTO `tb_user` VALUES ('14', '赵云', '123456', '10086@qq.com', '2154', '将军');
  13. INSERT INTO `tb_user` VALUES ('15', '刘备', '123456', '215454@qq.com', '213234554', '主公');
  14. INSERT INTO `tb_user` VALUES ('16', '曹操', '123456', '21245454@qq.com', '2154587', '主公');
  15. INSERT INTO `tb_user` VALUES ('17', '曹仁', '123456', '54578787@qq.com', '2145784', '大将');
  16. INSERT INTO `tb_user` VALUES ('18', '许褚', '123456', '545484@qq.com', '54584@qq.com', '大将');
  17. INSERT INTO `tb_user` VALUES ('19', '孙权', '123456', '2154545@qq.com', '2148454', '主公');
  18. INSERT INTO `tb_user` VALUES ('20', '陆逊', '123456', '21547787@qq.com', '2124554', '主帅');
  19. INSERT INTO `tb_user` VALUES ('21', '黄忠', '123456', '21454877878@qq.com', '12124548787', '将军');
  20. INSERT INTO `tb_user` VALUES ('22', '周瑜', '123456', '1245787@qq.com', '2115457877', '主帅');
  21. INSERT INTO `tb_user` VALUES ('23', '诸葛亮', '123456', '5454545@qq.com', '10086', '军师');
  22. INSERT INTO `tb_user` VALUES ('25', '魏延', '123456', '15454545@qq.com', '145755454', '大将');
  23. INSERT INTO `tb_user` VALUES ('26', '夏侯惇', '123456', '54578787@qq.com', '121454575', '将军');
  24. INSERT INTO `tb_user` VALUES ('27', '张苞', '123456', '123456@qq.com', '25454', '大将');
  25. INSERT INTO `tb_user` VALUES ('28', '关欣', '123456', '1215545@qq.com', '124545545', '大将');
  26. INSERT INTO `tb_user` VALUES ('29', '曹植', '123456', '245454@qq.com', '545451', '主公');
  27. INSERT INTO `tb_user` VALUES ('30', '曹丕', '123456', '21545454@qq.com', '2465446', '主公');
  28. INSERT INTO `tb_user` VALUES ('31', '孙尚香', '123456', '545451@qq.com', '545452121', '主公');
  29. INSERT INTO `tb_user` VALUES ('32', '刘婵', '123456', '454547454@qq.com', '11244541221', '主公');
  30. INSERT INTO `tb_user` VALUES ('33', '张辽', '123456', '2144545@qq.com', '12154548', '大将');
  31. INSERT INTO `tb_user` VALUES ('34', '马岱', '123456', '1211245454@qq.com', '12124548787', '大将');

ssm配置如下：

spring-dao.xml

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
  4.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  5.     http://www.springframework.org/schema/beans/spring-beans.xsd
  6.     http://www.springframework.org/schema/context
  7.     http://www.springframework.org/schema/context/spring-context.xsd">
  8.     <!-- 配置整合mybatis过程 -->
  9.     <!-- 1.配置数据库相关参数properties的属性：${url} -->
  10.     <context:property-placeholder location="classpath:jdbc.properties" />
  12.     <!-- 2.数据库连接池 -->
  13.     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
  14.         <!-- 配置连接池属性 -->
  15.         <property name="driverClass" value="${jdbc.driver}" />
  16.         <property name="jdbcUrl" value="${jdbc.url}" />
  17.         <property name="user" value="${jdbc.username}" />
  18.         <property name="password" value="${jdbc.password}" />
  20.         <!-- c3p0连接池的私有属性 -->
  21.         <property name="maxPoolSize" value="30" />
  22.         <property name="minPoolSize" value="10" />
  23.         <!-- 关闭连接后不自动commit -->
  24.         <property name="autoCommitOnClose" value="false" />
  25.         <!-- 获取连接超时时间 -->
  26.         <property name="checkoutTimeout" value="10000" />
  27.         <!-- 当获取连接失败重试次数 -->
  28.         <property name="acquireRetryAttempts" value="2" />
  29.     </bean>
  31.     <!-- 3.配置SqlSessionFactory对象 -->
  32.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  33.         <!-- 注入数据库连接池 -->
  34.         <property name="dataSource" ref="dataSource" />
  35.         <!-- 配置MyBaties全局配置文件:mybatis-config.xml -->
  36.         <property name="configLocation" value="classpath:mybatis-config.xml" />
  37.         <!-- 扫描entity包 使用别名 -->
  38.         <property name="typeAliasesPackage" value="cn.com.entity" />
  39.         <!-- 扫描sql配置文件:mapper需要的xml文件 -->
  40.         <property name="mapperLocations" value="classpath:mapper/*.xml" />
  41.     </bean>
  43.     <!-- 4.配置扫描Dao接口包，动态实现Dao接口，注入到spring容器中 -->
  44.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  45.         <!-- 注入sqlSessionFactory -->
  46.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
  47.         <!-- 给出需要扫描Dao接口包 -->
  48.         <property name="basePackage" value="cn.com.dao" />
  49.     </bean>
  50. </beans>

spring-service.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        xmlns:tx="http://www.springframework.org/schema/tx"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  7.     http://www.springframework.org/schema/beans/spring-beans.xsd
  8.     http://www.springframework.org/schema/context
  9.     http://www.springframework.org/schema/context/spring-context.xsd
  10.     http://www.springframework.org/schema/tx
  11.     http://www.springframework.org/schema/tx/spring-tx.xsd">
  12.     <!-- 扫描service包下所有使用注解的类型 -->
  13.     <context:component-scan base-package="cn.com.service" />
  15.     <!-- 配置事务管理器 -->
  16.     <bean id="transactionManager"
  17.           class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  18.         <!-- 注入数据库连接池 -->
  19.         <property name="dataSource" ref="dataSource" />
  20.     </bean>
  21.     <!-- 配置基于注解的声明式事务 -->
  22.     <tx:annotation-driven transaction-manager="transactionManager" />
  23. </beans>

spring-web.xml

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        xmlns:mvc="http://www.springframework.org/schema/mvc"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  7.     http://www.springframework.org/schema/beans/spring-beans.xsd
  8.     http://www.springframework.org/schema/context
  9.     http://www.springframework.org/schema/context/spring-context.xsd
  10.     http://www.springframework.org/schema/mvc
  11.     http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
  12.     <!-- 配置SpringMVC -->
  13.     <!-- 1.开启SpringMVC注解模式 -->
  14.     <!-- 简化配置：
  15.         (1)自动注册DefaultAnootationHandlerMapping,AnotationMethodHandlerAdapter
  16.         (2)提供一些列：数据绑定，数字和日期的format @NumberFormat, @DateTimeFormat, xml,json默认读写支持
  17.     -->
  18.     <mvc:annotation-driven />
  20.     <!-- 2.静态资源默认servlet配置
  21.         (1)加入对静态资源的处理：js,gif,png
  22.         (2)允许使用"/"做整体映射
  23.      -->
  24.     <mvc:default-servlet-handler/>
  26.     <!-- 3.配置jsp 显示ViewResolver -->
  27.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  28.         <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
  29.         <property name="prefix" value="/WEB-INF/views/" />
  30.         <property name="suffix" value=".jsp" />
  31.     </bean>
  33.     <!-- 4.扫描web相关的bean -->
  34.     <context:component-scan base-package="cn.com.controller" />
  35. </beans>

jdbc.properties

  1. jdbc.driver=com.mysql.jdbc.Driver
  2. jdbc.url=jdbc:mysql://127.0.0.1:3306/ssmdemo
  3. jdbc.username=root
  4. jdbc.password=123456

logback.xml日志

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <configuration debug="true">
  3.     <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
  4.         <encoder>
  5.             <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
  6.         </encoder>
  7.     </appender>
  8.     <!--开启debug日志模式，在控制台打印日志-->
  9.     <root level="debug">
  10.         <appender-ref ref="STDOUT" />
  11.     </root>
  12. </configuration>

mybatis-config.xml

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6.     <!-- 配置全局属性 -->
  7.     <settings>
  8.         <!-- 使用jdbc的getGeneratedKeys获取数据库自增主键值 -->
  9.         <setting name="useGeneratedKeys" value="true" />
  10.         <!-- 使用列别名替换列名 默认:true -->
  11.         <setting name="useColumnLabel" value="true" />
  12.         <!-- 开启驼峰命名转换:Table{create_time} -> Entity{createTime} -->
  13.         <setting name="mapUnderscoreToCamelCase" value="true" />
  14.     </settings>
  15. </configuration>

web.xml配置如下：

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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_2_5.xsd" version="2.5">
  3.   <display-name>ssm-demo</display-name>
  4.   <!-- 配置DispatcherServlet -->
  5.     <servlet>
  6.         <servlet-name>myspringmvc-dispatcher</servlet-name>
  7.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  8.         <!-- 配置springMVC需要加载的配置文件
  9.             spring-dao.xml,spring-service.xml,spring-web.xml
  10.             Mybatis - > spring -> springmvc
  11.          -->
  12.         <init-param>
  13.             <param-name>contextConfigLocation</param-name>
  14.             <param-value>classpath:Spring/spring-*.xml</param-value>
  15.         </init-param>
  16.     </servlet>
  17.     <servlet-mapping>
  18.         <servlet-name>myspringmvc-dispatcher</servlet-name>
  19.         <!-- 默认匹配所有的请求 -->
  20.         <url-pattern>/</url-pattern>
  21.     </servlet-mapping>
  22.     <!-- 编码过滤器 -->
  23.     <filter>
  24.         <filter-name>encodingFilter</filter-name>
  25.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  26.         <init-param>
  27.             <param-name>encoding</param-name>
  28.             <param-value>UTF-8</param-value>
  29.         </init-param>
  30.     </filter>
  31.     <filter-mapping>
  32.         <filter-name>encodingFilter</filter-name>
  33.         <url-pattern>/*</url-pattern>
  34.     </filter-mapping>
  35. </web-app>

Ok,至此，以上ssm框架就搭建好了，这边博主就不测试了，肯定是Ok的。

接下来就是写相应的代码：代码开发流程：entity—>dao—(对应的mapper映射sql语句)>service>serviceimpl—>controller。

entity实体类：

  1. package cn.com.entity;
  2. /**
  3.  * 用户实体类
  4.  */
  5. public class User {
  6.     private Integer id;
  8.     private String username;
  10.     private String password;
  12.     private String email;
  14.     private String phone;
  16.     private String rolename;
  18.     public Integer getId() {
  19.         return id;
  20.     }
  22.     public User() {
  23.         super();
  24.     }
  26.     public User(String username, String password, String email, String phone, String rolename) {
  27.         super();
  28.         this.username = username;
  29.         this.password = password;
  30.         this.email = email;
  31.         this.phone = phone;
  32.         this.rolename = rolename;
  33.     }
  35.     public void setId(Integer id) {
  36.         this.id = id;
  37.     }
  39.     public String getUsername() {
  40.         return username;
  41.     }
  43.     public void setUsername(String username) {
  44.         this.username = username == null ? null : username.trim();
  45.     }
  47.     public String getPassword() {
  48.         return password;
  49.     }
  51.     public void setPassword(String password) {
  52.         this.password = password == null ? null : password.trim();
  53.     }
  55.     public String getEmail() {
  56.         return email;
  57.     }
  59.     public void setEmail(String email) {
  60.         this.email = email == null ? null : email.trim();
  61.     }
  63.     public String getPhone() {
  64.         return phone;
  65.     }
  67.     public void setPhone(String phone) {
  68.         this.phone = phone == null ? null : phone.trim();
  69.     }
  71.     public String getRolename() {
  72.         return rolename;
  73.     }
  75.     public void setRolename(String rolename) {
  76.         this.rolename = rolename == null ? null : rolename.trim();
  77.     }
  79.     @Override
  80.     public String toString() {
  81.         return "User [id=" + id + ", username=" + username + ", password=" + password + ", email=" + email + ", phone="
  82.                 + phone + ", rolename=" + rolename + "]";
  83.     }
  85. }

PageBean分页实体类：

  1. package cn.com.entity;
  3. import java.util.List;
  4. /**
  5.  * 分页实体类
  6.  */
  7. public class PageBean<T> {
  9.     private int currPage;//当前页数
  10.     private int pageSize;//每页显示的记录数
  11.     private int totalCount;//总记录数
  12.     private int totalPage;//总页数
  13.     private List<T> lists;//每页的显示的数据
  15.     public PageBean() {
  16.         super();
  17.     }
  19.     public int getCurrPage() {
  20.         return currPage;
  21.     }
  23.     public void setCurrPage(int currPage) {
  24.         this.currPage = currPage;
  25.     }
  27.     public int getPageSize() {
  28.         return pageSize;
  29.     }
  31.     public void setPageSize(int pageSize) {
  32.         this.pageSize = pageSize;
  33.     }
  35.     public int getTotalCount() {
  36.         return totalCount;
  37.     }
  39.     public void setTotalCount(int totalCount) {
  40.         this.totalCount = totalCount;
  41.     }
  43.     public int getTotalPage() {
  44.         return totalPage;
  45.     }
  47.     public void setTotalPage(int totalPage) {
  48.         this.totalPage = totalPage;
  49.     }
  51.     public List<T> getLists() {
  52.         return lists;
  53.     }
  55.     public void setLists(List<T> lists) {
  56.         this.lists = lists;
  57.     }
  59. }

userDao

  1. package cn.com.dao;
  3. import java.util.HashMap;
  4. import java.util.List;
  6. import cn.com.entity.User;
  9. public interface UserDao {
  10.     /**
  11.      * 根据主键删除一条用户数据
  12.      * @param id
  13.      * @return
  14.      */
  15.     int deleteByPrimaryKey(Integer id);
  16.     /**
  17.      * 插入一条用户数据 ，可以不完整
  18.      * @param record
  19.      * @return
  20.      */
  21.     int insertSelective(User record);
  22.     /**
  23.      * 根据主键查询一条用户数据
  24.      * @param id
  25.      * @return
  26.      */
  27.     User selectByPrimaryKey(Integer id);
  28.     /**
  29.      * 用户登录
  30.      * @param record
  31.      * @return
  32.      */
  33.     User loginByUserNameAndPassword(User record);
  34.     /**
  35.      * 根据主键更新一条用户数据，可以不完整 -
  36.      * @param record
  37.      * @return
  38.      */
  39.     int updateByPrimaryKeySelective(User record);
  41.     /**
  42.      * 查询所有用户数据
  43.      * @return
  44.      */
  45.     List<User> selectUserList();
  46.     /**
  47.      * 查询用户记录总数
  48.      * @return
  49.      */
  50.     int selectCount();
  51.     /**
  52.      * 分页操作，调用findByPage limit分页方法
  53.      * @param map
  54.      * @return
  55.      */
  56.     List<User> findByPage(HashMap<String,Object> map);
  57. }

UserMapper.xml

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
  3. <mapper namespace="cn.com.dao.UserDao">
  4.     <!-- 先定义一个Interface，UserMapper，然后Mapper文件的namespace指向的就是这个Interface， UserInterface里定义的方法和UserMapper.xml文件中的一样, 
  5.         然后代码里直接使用接口 -->
  6.     <resultMap id="BaseResultMap" type="cn.com.entity.User">
  7.         <id column="id" property="id" jdbcType="INTEGER" />
  8.         <result column="userName" property="username" jdbcType="VARCHAR" />
  9.         <result column="password" property="password" jdbcType="VARCHAR" />
  10.         <result column="email" property="email" jdbcType="VARCHAR" />
  11.         <result column="phone" property="phone" jdbcType="VARCHAR" />
  12.         <result column="roleName" property="rolename" jdbcType="VARCHAR" />
  13.     </resultMap>
  15.     <sql id="Base_Column_List">
  16.         id, userName, password, email, phone, roleName
  17.     </sql>
  19.     <!--根据主键查询一条用户数据 -->
  20.     <select id="selectByPrimaryKey" resultMap="BaseResultMap"
  21.         parameterType="java.lang.Integer">
  22.         select
  23.         <include refid="Base_Column_List" />
  24.         from tb_user
  25.         where id = #{id,jdbcType=INTEGER}
  26.     </select>
  28.     <!--用户登录 -->
  29.     <select id="loginByUserNameAndPassword"  resultMap="BaseResultMap" parameterType="cn.com.entity.User">
  30.         select 
  31.         <include refid="Base_Column_List" />
  32.          from tb_user 
  33.          where 
  34.          userName = #{username} 
  35.          and password = #{password} 
  36.     </select>
  38.     <!-- 根据分页数据start 和size查询数据 -->
  39.     <select id="findByPage" parameterType="Map" resultMap="BaseResultMap">
  40.         select
  41.         <include refid="Base_Column_List" />
  42.         from tb_user
  43.         <if test="start!=null and size!=null">
  44.             limit #{start},#{size}
  45.         </if>
  46.     </select>
  48.     <!--查询所有用户数据 -->
  49.     <select id="selectUserList" resultType="cn.com.entity.User">
  50.         select
  51.         <include refid="Base_Column_List" />
  52.         from tb_user
  53.     </select>
  55.     <!-- 查询用户记录总数 -->
  56.     <select id="selectCount" resultType="int">
  57.         select count(*) from tb_user
  58.     </select>
  60.     <!--根据主键删除一条用户数据 -->
  61.     <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
  62.         delete from tb_user
  63.         where id = #{id,jdbcType=INTEGER}
  64.     </delete>
  66.     <!--插入一条完整用户数据 -->
  67.     <insert id="insert" parameterType="cn.com.entity.User">
  68.         insert into tb_user (id, userName, password,
  69.         email, phone, roleName
  70.         )
  71.         values (#{id,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR},
  72.         #{password,jdbcType=VARCHAR},
  73.         #{email,jdbcType=VARCHAR}, #{phone,jdbcType=VARCHAR}, #{rolename,jdbcType=VARCHAR}
  74.         )
  75.     </insert>
  77.     <!--插入一条用户数据 ，可以不完整 -->
  78.     <insert id="insertSelective" parameterType="cn.com.entity.User">
  79.         insert into tb_user
  80.         <trim prefix="(" suffix=")" suffixOverrides=",">
  81.             <if test="id != null">
  82.                 id,
  83.             </if>
  84.             <if test="username != null">
  85.                 userName,
  86.             </if>
  87.             <if test="password != null">
  88.                 password,
  89.             </if>
  90.             <if test="email != null">
  91.                 email,
  92.             </if>
  93.             <if test="phone != null">
  94.                 phone,
  95.             </if>
  96.             <if test="rolename != null">
  97.                 roleName,
  98.             </if>
  99.         </trim>
  100.         <trim prefix="values (" suffix=")" suffixOverrides=",">
  101.             <if test="id != null">
  102.                 #{id,jdbcType=INTEGER},
  103.             </if>
  104.             <if test="username != null">
  105.                 #{username,jdbcType=VARCHAR},
  106.             </if>
  107.             <if test="password != null">
  108.                 #{password,jdbcType=VARCHAR},
  109.             </if>
  110.             <if test="email != null">
  111.                 #{email,jdbcType=VARCHAR},
  112.             </if>
  113.             <if test="phone != null">
  114.                 #{phone,jdbcType=VARCHAR},
  115.             </if>
  116.             <if test="rolename != null">
  117.                 #{rolename,jdbcType=VARCHAR},
  118.             </if>
  119.         </trim>
  120.     </insert>
  122.     <!--根据主键更新一条用户数据，可以不完整 -->
  123.     <update id="updateByPrimaryKeySelective" parameterType="cn.com.entity.User">
  124.         update tb_user
  125.         <set>
  126.             <if test="username != null">
  127.                 userName = #{username,jdbcType=VARCHAR},
  128.             </if>
  129.             <if test="password != null">
  130.                 password = #{password,jdbcType=VARCHAR},
  131.             </if>
  132.             <if test="email != null">
  133.                 email = #{email,jdbcType=VARCHAR},
  134.             </if>
  135.             <if test="phone != null">
  136.                 phone = #{phone,jdbcType=VARCHAR},
  137.             </if>
  138.             <if test="rolename != null">
  139.                 roleName = #{rolename,jdbcType=VARCHAR},
  140.             </if>
  141.         </set>
  142.         where id = #{id,jdbcType=INTEGER}
  143.     </update>
  145.     <!--根据主键更新一条用户数据 -->
  146.     <update id="updateByPrimaryKey" parameterType="cn.com.entity.User">
  147.         update tb_user
  148.         set userName = #{username,jdbcType=VARCHAR},
  149.         password = #{password,jdbcType=VARCHAR},
  150.         email = #{email,jdbcType=VARCHAR},
  151.         phone = #{phone,jdbcType=VARCHAR},
  152.         roleName = #{rolename,jdbcType=VARCHAR}
  153.         where id = #{id,jdbcType=INTEGER}
  154.     </update>
  155. </mapper>

userSerevice

  1. package cn.com.service;
  3. import java.util.List;
  5. import cn.com.entity.PageBean;
  6. import cn.com.entity.User;
  8. /**
  9.  * User类业务层接口
  10.  */
  11. public interface UserService {
  13.     int deleteByPrimaryKey(Integer id);
  15.     int insertSelective(User record);
  17.     User selectByPrimaryKey(Integer id);
  19.     User loginByUserNameAndPassword(User record);
  21.     List<User> selectUserList();
  23.     int selectCount();
  25.     int updateByPrimaryKeySelective(User record);
  27.     PageBean<User> findByPage(int currentPage);
  28. }

userServiceImpl

  1. package cn.com.service.impl;
  3. import java.util.HashMap;
  4. import java.util.List;
  6. import javax.annotation.Resource;
  8. import org.springframework.stereotype.Service;
  10. import cn.com.dao.UserDao;
  11. import cn.com.entity.PageBean;
  12. import cn.com.entity.User;
  13. import cn.com.service.UserService;
  15. /**
  16.  * User类业务层实现类
  17.  */
  18. @Service("userService")
  19. public class UserServiceImpl implements UserService {
  21.     @Resource
  22.     private UserDao userDao;
  23.     @Override
  24.     public int deleteByPrimaryKey(Integer id) {
  25.         return userDao.deleteByPrimaryKey(id);
  26.     }
  28.     @Override
  29.     public int insertSelective(User record) {
  31.         return userDao.insertSelective(record);
  32.     }
  34.     @Override
  35.     public User selectByPrimaryKey(Integer id) {
  37.         return userDao.selectByPrimaryKey(id);
  38.     }
  40.     @Override
  41.     public int updateByPrimaryKeySelective(User record) {
  42.         return userDao.updateByPrimaryKeySelective(record);
  43.     }
  45.     @Override
  46.     public List<User> selectUserList() {
  48.         return userDao.selectUserList();
  49.     }
  51.     @Override
  52.     public int selectCount() {
  53.         return userDao.selectCount();
  54.     }
  56.     @Override
  57.     public User loginByUserNameAndPassword(User record) {
  59.         return userDao.loginByUserNameAndPassword(record);
  60.     }
  62.     @Override
  63.     public PageBean<User> findByPage(int currentPage) {//currPage当前页数
  64.         //创建HashMap对象封装
  65.         HashMap<String,Object> map = new HashMap<String,Object>();
  66.         //创建一个分页对象
  67.         PageBean<User> pageBean = new PageBean<User>();
  68.         //封装当前页数
  69.         pageBean.setCurrPage(currentPage);
  70.         //每页显示的数据
  71.         int pageSize=10;
  72.         pageBean.setPageSize(pageSize);
  73.         //封装总记录数
  74.         int totalCount = userDao.selectCount();
  75.         pageBean.setTotalCount(totalCount);
  76.         //封装总页数
  77.         double tc = totalCount;
  78.         Double num =Math.ceil(tc/pageSize);//向上取整，总记录数除以当前每页显示数
  79.         pageBean.setTotalPage(num.intValue());
  80.         map.put("start",(currentPage-1)*pageSize);//（当前页数-1）*每页显示数
  81.         map.put("size", pageBean.getPageSize());//每页显示的记录数
  82.         //封装每页显示的数据
  83.         List<User> lists = userDao.findByPage(map);
  84.         pageBean.setLists(lists);
  85.         return pageBean;
  86.     }
  87. }

userController

  1. package cn.com.controller;
  3. import java.util.List;
  5. import javax.annotation.Resource;
  7. import org.springframework.stereotype.Controller;
  8. import org.springframework.ui.Model;
  9. import org.springframework.web.bind.annotation.RequestMapping;
  10. import org.springframework.web.bind.annotation.RequestParam;
  11. import org.springframework.web.bind.annotation.SessionAttributes;
  13. import cn.com.entity.User;
  14. import cn.com.service.UserService;
  17. @SessionAttributes("currentUser")
  18. @Controller
  19. public class UserController {
  21.     @Resource
  22.     private UserService userService;
  23.     /**
  24.      * 用户登录
  25.      * @param user
  26.      * @param request
  27.      * @return
  28.      * @throws Exception
  29.      */
  30.     @RequestMapping("/login")
  31.     public String login(@RequestParam("userName")String userName,
  32.             @RequestParam("password")String password,Model model) throws Exception{
  33.         //创建一个用户对象,封装对象
  34.         User user = new User();
  35.         user.setUsername(userName);
  36.         user.setPassword(password);
  37.         //调用根据姓名与密码查询
  38.         User userresult = userService.loginByUserNameAndPassword(user);
  39.         //对结果进行判断，如果用户名与密码不为空，登录成功
  40.         if(userresult!=null){
  41.             //登录成功，查询所有
  42.             List<User> lists = userService.selectUserList();
  43.             //把查询到的所有结果回显给前端main.jsp
  44.             model.addAttribute("userLists", lists);//回显用户信息
  45.             //把获取的用户名传回给currentUser
  46.             model.addAttribute("currentUser", userresult.getUsername());
  47.             //重定向到main.jsp页面
  48.             return "redirect:main";
  49.         }
  50.         return "error";
  51.     }
  52.     /**
  53.      * @param currentPage
  54.      * @param model
  55.      * @return
  56.      */
  57.     @RequestMapping("/main")
  58.     public String  main(@RequestParam(value="currentPage",defaultValue="1",required=false)int currentPage,Model model){
  59.         //分页查询
  60.         model.addAttribute("pagemsg", userService.findByPage(currentPage));//回显分页数据
  61.         //返回到主页
  62.         return "main";
  63.     }
  64.     /**
  65.      * 跳到编辑页面
  66.      * @param currentPage
  67.      * @param model
  68.      * @return
  69.      */
  70.     @RequestMapping("/edit")
  71.     public String editpage(@RequestParam("id") int id,
  72.             Model model){
  73.         User user =userService.selectByPrimaryKey(id);
  74.         model.addAttribute("returnUser", user);
  75.         return "edit";
  76.     }
  77.     /**
  78.      * 保存用户数据
  79.      * @return
  80.      */
  81.     @RequestMapping("/save")
  82.     public String save(User user){
  83.         System.out.println(user.toString());
  84.         //如果获取的用户id为空
  85.         if(user.getId()==null){
  86.             //id为null是保存，调用增加方法
  87.             userService.insertSelective(user);
  88.         }else{
  89.             //有id值为修改，否则调用修改的方法
  90.             userService.updateByPrimaryKeySelective(user);
  91.         }    
  92.         //重定向到主页
  93.         return "redirect:main";
  94.     }
  95.     /**
  96.      * 删除用户数据
  97.      * @param id
  98.      * @return
  99.      */
  100.     @RequestMapping("/delete")
  101.     public String delete(@RequestParam("id") int id){
  102.         userService.deleteByPrimaryKey(id);
  103.         return "redirect:main";
  104.     }
  105.     /**
  106.      * 添加一个用户数据
  107.      * @return
  108.      */
  109.     @RequestMapping("/add")
  110.     public String add(Model model){
  111.         model.addAttribute("returnUser", new User());
  112.         return "edit";
  113.     }
  114. }

好了，最后是前端页面：

index.jsp 简单的登录页面：

  1. <%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8"
  2.     pageEncoding="UTF-8"%>
  3. <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
  4. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  5. <html>
  6. <head>
  7. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  9. <title>Index.jsp</title>
  10. <body>
  12. <h2>欢迎登陆</h2>
  14.     <form action="login" method="post">
  15.         用户名:<input type="text" name="userName"/><br>
  16.         密  码:<input type="password" name="password"/><br>
  17.         <input type="submit" value="登录"/>
  18.     </form>
  20. </body>
  21. </html>

main.jsp 主页展示页：

  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2.     pageEncoding="UTF-8"%>
  3. <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
  4. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  5. <html>
  6. <head>
  7. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  8. <title>ssm分页的主页</title>
  9. <style type="text/css">
  10.     td{text-align: center;}
  11.     .td2{text-align: right;}
  12.      .table1{
  13.             border:1px solid #ddd;
  14.             width:900px;            
  15.         }
  16.         thead{
  17.             background-color:lightblue;
  18.         }
  19. </style>
  20. </head>
  21. <body>
  22.     欢迎你：${currentUser}
  23.     <br>
  24.      <%-- 当前用户：${pageScope.currentUser}<!-- (只能在同一个页面中使用) --> <br>
  25.     当前用户：${requestScope.currentUser}-${roleName} 有重定向数据就访问不到<br>
  26.     当前用户：${sessionScope.currentUser}-${roleName} 可以使用<br> --%> 
  27.     <hr>
  28.     <a href="add"> 添加用户</a><br>
  29.     <c:if test="${empty requestScope.pagemsg}">
  30.         没有任何用户信息！
  31.     </c:if>
  32.     <c:if test="${!empty requestScope.pagemsg}">
  33.         <table border="1" cellpadding="10" cellspacing="0" class="table1">
  34.         <thead>
  35.             <tr>
  36.                 <td>编号</td>
  37.                 <td>用户名</td>
  38.                 <td>密码</td>
  39.                 <td>邮件</td>
  40.                 <td>联系电话</td>
  41.                 <td>职位</td>
  42.                 <td>修改</td>
  43.                 <td>删除</td>
  44.             </tr>
  45.             </thead>
  46.             <!--lists是后端传回的所有的结果  -->
  47.             <c:forEach items="${requestScope.pagemsg.lists}" var="u">
  48.                 <tr>
  49.                     <th>${u.id }</th>
  50.                     <th>${u.username }</th>
  51.                     <th>${u.password }</th>
  52.                     <th>${u.email }</th>
  53.                     <th>${u.phone }</th>
  54.                     <th>${u.rolename }</th>
  55.                     <th><a href="edit?id=${u.id}">修改</a></th>
  56.                     <th><a href="delete?id=${u.id}" onclick="return confirm('确定要删除吗')">删除</a></th>
  57.                 </tr>
  58.             </c:forEach>        
  59.         </table>    
  60.     </c:if>
  62. <table  border="0" cellspacing="0" cellpadding="0"  width="900px">
  63. <tr>
  64. <td class="td2">
  65.    <span>第${requestScope.pagemsg.currPage }/ ${requestScope.pagemsg.totalPage}页</span>  
  66.    <span>总记录数：${requestScope.pagemsg.totalCount }  每页显示:${requestScope.pagemsg.pageSize}</span>  
  67.    <span>
  68.        <c:if test="${requestScope.pagemsg.currPage != 5}">
  69.            <a href="${pageContext.request.contextPath }/main?currentPage=1">[首页]</a>  
  70.            <a href="${pageContext.request.contextPath }/main?currentPage=${requestScope.pagemsg.currPage-1}">[上一页]</a>  
  71.        </c:if>
  73.        <c:if test="${requestScope.pagemsg.currPage != requestScope.pagemsg.totalPage}">
  74.            <a href="${pageContext.request.contextPath }/main?currentPage=${requestScope.pagemsg.currPage+1}">[下一页]</a>  
  75.            <a href="${pageContext.request.contextPath }/main?currentPage=${requestScope.pagemsg.totalPage}">[尾页]</a>  
  76.        </c:if>
  77.    </span>
  78. </td>
  79. </tr>
  80. </table>
  81. </body>
  82. </html>

edit.jsp编辑页：

  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2.     pageEncoding="UTF-8"%>
  3. <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
  4. <%@ taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
  5. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  6. <html>
  7. <head>
  8. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  9. <title>编辑页面</title>
  10. </head>
  11. <body>
  12.     欢迎你：${currentUser}
  13.     <hr>
  14.     <form:form action="save" method="post" modelAttribute="returnUser">
  15.         <form:hidden path="id"/>
  16.         用户名:<form:input path="username" /><br>
  17.         密码:<form:input path="password" /><br>
  18.         邮件:<form:input path="email" /><br>
  19.         联系电话:<form:input path="phone" /><br>
  20.         职位:<form:select path="rolename">
  21.                 <form:option value="">请选择职位</form:option>
  22.                 <form:option value="主公">主公</form:option>
  23.                 <form:option value="主帅">主帅</form:option>
  24.                 <form:option value="军师">军师</form:option>
  25.                 <form:option value="将军">将军</form:option>
  26.                 <form:option value="大将">大将</form:option>
  27.             </form:select><br>
  28.             <input type="submit" value="提交"/>
  29.     </form:form>
  30. </body>
  31. </html>

error.jsp 错误友好提示页面：

  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2.     pageEncoding="UTF-8"%>
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  4. <html>
  5. <head>
  6. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  7. <title>Insert title here</title>
  8. </head>
  9. <body>
  10.     <a href="${pageContext.request.contextPath }/index.jsp">登录发生错误，请重新登录</a>
  11. </body>
  12. </html>

Ok，至此整个完整的ssm分页增删改查就全部写好了，亲测可用。如果自己写的还是不行的话，那么博主把自己代码上传至csdn提供大家参考！

发表评论

表情：
评论列表 （有 0 条评论，386人围观）

还没有评论，来说两句吧...

相关阅读

    相关 ssm整合增删改查

    总体的ssm整合增删改查的思想： > 1、一般我们做增删改查的项目的时候，我们可以先从数据层开始写，在数据层把增删改查的功能方法写好，然后再写业务逻辑层的逻辑，业务逻辑层接口

    桃扇骨桃扇骨/ 0 赞/ 124 阅读

    相关 ssm登录注册增删改查

    >     此项目原本是两个不同的项目，博主从网上找的，都是基于ide开发的项目，然当我导入ide与eclipse却运行不了，没办法只能博主自己重新构建项目,参考这两个不同的项

    小咪咪小咪咪/ 0 赞/ 351 阅读

    相关 ssm分页增删改查

    ssm分页增删改查，博主技术有限，暂时就这样啦.... > 如果觉得文章不错，对你有帮助，请作者喝杯咖啡，谢谢！如果对您有帮助 ，请多多支持.多少都是您的心意与支持，一分也

    怼烎@怼烎@/ 0 赞/ 387 阅读