SSM框架實現分頁查詢例子

char_long發表於2018-06-27

專案結構

部落格轉載於https://blog.csdn.net/peng_hong_fu/article/details/53645924

1.配置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.test</groupId>
	<artifactId>TestMaven4</artifactId>
	<packaging>war</packaging>
	<version>0.0.1-SNAPSHOT</version>
	<name>TestMaven4 Maven Webapp</name>
	<url>http://maven.apache.org</url>
	<properties>
		<!-- spring版本號 -->
		<spring.version>4.3.3.RELEASE</spring.version>
		<!-- mybatis版本號 -->
		<mybatis.version>3.4.0</mybatis.version>
		<!-- log4j日誌檔案管理包版本 -->
		<slf4j.version>1.7.7</slf4j.version>
		<log4j.version>1.2.17</log4j.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.12</version>
			<!-- 表示開發的時候引入，釋出的時候不會載入此包 -->
			<scope>test</scope>
		</dependency>
		<!-- spring核心包 -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</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-oxm</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-tx</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-webmvc</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aop</artifactId>
			<version>${spring.version}</version>
		</dependency>

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

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<!-- mybatis核心包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>${mybatis.version}</version>
		</dependency>

		<!--mybatis spring 外掛 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.3.0</version>
		</dependency>
		<!-- 匯入java ee jar 包 -->
		<dependency>
			<groupId>javax</groupId>
			<artifactId>javaee-api</artifactId>
			<version>7.0</version>
		</dependency>
		<!-- 匯入Mysql資料庫連結jar包 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.25</version>
		</dependency>
		<!-- 匯入dbcp的jar包，用來在applicationContext.xml中配置資料庫 -->
		<dependency>
			<groupId>commons-dbcp</groupId>
			<artifactId>commons-dbcp</artifactId>
			<version>1.2.2</version>
		</dependency>
		<!-- JSTL標籤類 -->
		<dependency>
			<groupId>jstl</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
		<!-- 日誌檔案管理包 -->
		<!-- log start -->
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>${log4j.version}</version>
		</dependency>


		<!-- 格式化物件，方便輸出日誌 -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>fastjson</artifactId>
			<version>1.1.41</version>
		</dependency>


		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
			<version>${slf4j.version}</version>
		</dependency>

		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>${slf4j.version}</version>
		</dependency>
		<!-- log end -->
		<!-- 引入JSON -->
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-databind</artifactId>
			<version>2.7.5</version>
		</dependency>
		<!-- 上傳元件包 -->
		<dependency>
			<groupId>commons-fileupload</groupId>
			<artifactId>commons-fileupload</artifactId>
			<version>1.3.1</version>
		</dependency>
		<dependency>
			<groupId>commons-io</groupId>
			<artifactId>commons-io</artifactId>
			<version>2.4</version>
		</dependency>
		<dependency>
			<groupId>commons-codec</groupId>
			<artifactId>commons-codec</artifactId>
			<version>1.9</version>
		</dependency>
		<!--aspectj -->
		<dependency>
			<groupId>aspectj</groupId>
			<artifactId>aspectjweaver</artifactId>
			<version>1.5.4</version>
		</dependency>
	</dependencies>
	<build>
		<finalName>SSM-Project</finalName>
		<plugins>
			<!-- define the project compile level -->
			<plugin>
				<groupId>org.apache.maven.plugins</groupId>
				<artifactId>maven-compiler-plugin</artifactId>
				<configuration>
					<source>1.8</source>
					<target>1.8</target>
				</configuration>
			</plugin>
		</plugins>
	</build>
</project>

2.web.xml配置檔案

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns="http://java.sun.com/xml/ns/javaee"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
	id="WebApp_ID" version="3.0">
	<!-- 編碼過濾器 -->
	<filter>
		<filter-name>encodingFilter</filter-name>
		<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
		<async-supported>true</async-supported>
		<init-param>
			<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>
	<!-- Spring配置檔案 -->
	<!-- needed for ContextLoaderListener -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:applicationContext.xml</param-value>
	</context-param>
	<!-- Bootstraps the root web application context before servlet initialization -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>


	<!-- SpringMVC DispatcherServlet -->
	<!-- The front controller of this Spring Web application, responsible for 
		handling all application requests -->
	<servlet>
		<servlet-name>springDispatcherServlet</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:springmvc.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>

	<!-- Map all requests to the DispatcherServlet for handling -->
	<servlet-mapping>
		<servlet-name>springDispatcherServlet</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>
</web-app>

3.建立MySQL資料表

DROP TABLE IF EXISTS tb_user;
CREATE TABLE tb_user (
    id INT NOT NULL AUTO_INCREMENT,
    userName VARCHAR(40),
    password VARCHAR(100),
    email VARCHAR(40),
    phone VARCHAR(40),
    roleName VARCHAR(40),
    PRIMARY KEY(id)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

4.資料庫配置檔案

jdbc.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/test
username=root
password=root
initialSize=0 

maxActive=20 
 
maxIdle=20

minIdle=1

maxWait=60000

5.日誌輸出格式配置

log4j.properties

 log4j.rootLogger=INFO,Console,File  
#\u5B9A\u4E49\u65E5\u5FD7\u8F93\u51FA\u76EE\u7684\u5730\u4E3A\u63A7\u5236\u53F0  
log4j.appender.Console=org.apache.log4j.ConsoleAppender  
log4j.appender.Console.Target=System.out  
#\u53EF\u4EE5\u7075\u6D3B\u5730\u6307\u5B9A\u65E5\u5FD7\u8F93\u51FA\u683C\u5F0F\uFF0C\u4E0B\u9762\u4E00\u884C\u662F\u6307\u5B9A\u5177\u4F53\u7684\u683C\u5F0F  
log4j.appender.Console.layout = org.apache.log4j.PatternLayout  
log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n  
  
#\u6587\u4EF6\u5927\u5C0F\u5230\u8FBE\u6307\u5B9A\u5C3A\u5BF8\u7684\u65F6\u5019\u4EA7\u751F\u4E00\u4E2A\u65B0\u7684\u6587\u4EF6  
log4j.appender.File = org.apache.log4j.RollingFileAppender  
#\u6307\u5B9A\u8F93\u51FA\u76EE\u5F55  
log4j.appender.File.File = logs/ssm.log  
#\u5B9A\u4E49\u6587\u4EF6\u6700\u5927\u5927\u5C0F  
log4j.appender.File.MaxFileSize = 10MB  
# \u8F93\u51FA\u6240\u4EE5\u65E5\u5FD7\uFF0C\u5982\u679C\u6362\u6210DEBUG\u8868\u793A\u8F93\u51FADEBUG\u4EE5\u4E0A\u7EA7\u522B\u65E5\u5FD7  
log4j.appender.File.Threshold = ALL  
log4j.appender.File.layout = org.apache.log4j.PatternLayout  
log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n

6.Spring 配置檔案

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: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"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.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/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">

	<context:component-scan base-package="com.ssmtest">
		<!--不掃描 @Controller註解的類  -->
		<context:exclude-filter type="annotation"
		 expression="org.springframework.stereotype.Controller"/>
	</context:component-scan>
	
	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<!-- <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/> -->
		<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
		<property name="url" value="jdbc:mysql://127.0.0.1:3306/test"/>
		<property name="username" value="root"/>
		<property name="password" value="root"/>
	</bean>
	
	<!-- 配置MyBatis的sqlSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>		
		<property name="mapperLocations" value="classpath:com/ssmtest/mappers/*.xml"></property>
	</bean>
	
	<!-- Mapper介面所在包名，Spring會自動查詢其下的Mapper  -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.ssmtest.dao"></property>
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
	</bean>
	
	<!-- 配置transactionManager事務管理器 -->
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"></property>
	</bean>
	
	<!-- 配置事物通知屬性 -->
	<tx:advice id="txAdvice" transaction-manager="transactionManager">
		<!-- 定義事物傳播特性 -->
		<tx:attributes>
			<tx:method name="insert*" propagation="REQUIRED"/>
			<tx:method name="update*" propagation="REQUIRED" />  
			<tx:method name="edit*" propagation="REQUIRED" />  
			<tx:method name="save*" propagation="REQUIRED" />  
			<tx:method name="add*" propagation="REQUIRED" />  
			<tx:method name="new*" propagation="REQUIRED" />  
			<tx:method name="set*" propagation="REQUIRED" />  
			<tx:method name="remove*" propagation="REQUIRED" />  
			<tx:method name="delete*" propagation="REQUIRED" />  
			<tx:method name="change*" propagation="REQUIRED" />  
			<tx:method name="check*" propagation="REQUIRED" />  
			<tx:method name="get*" propagation="REQUIRED" read-only="true" />  
			<tx:method name="find*" propagation="REQUIRED" read-only="true" />  
			<tx:method name="load*" propagation="REQUIRED" read-only="true" />  
			<tx:method name="*" propagation="REQUIRED" read-only="true" />  
		</tx:attributes>
	</tx:advice>
	<!-- 配置事物切面 -->
	<aop:config>
		<aop:pointcut id="serviceOperation" expression="execution(* com.ssmtest.service.*.*(..))" />
		<aop:advisor advice-ref="txAdvice" pointcut-ref="serviceOperation"/>
	</aop:config>
</beans>

7.SpringMVC 配置檔案

springmvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.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">
	
	<!-- 自動掃描包 -->
	<context:component-scan base-package="com.ssmtest.controller"></context:component-scan>
	
	<!-- 檢視解析器 -->
	<bean id="viewResolver"
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="WEB-INF/views/"></property>
		<property name="suffix" value=".jsp"></property>
	</bean>
	<mvc:default-servlet-handler/>
	<mvc:annotation-driven></mvc:annotation-driven>
</beans>

7.Java 檔案

7.1實體類`User`和`PageBean`

user.java

package com.ssmtest.entity;
/**
 * 使用者實體類
 * 對應資料表tb_user
 * @author Peng
 * @Date2016年12月13日上午9:36:23
 */
public class User {
    private Integer id;

    private String username;

    private String password;

    private String email;

    private String phone;

    private String rolename;
    //角色名稱 系統管理員、銷售主管、客戶經理、高管

    
    public Integer getId() {
        return id;
    }

    public User() {
		super();
	}

	public User(String username, String password, String email, String phone, String rolename) {
		super();
		this.username = username;
		this.password = password;
		this.email = email;
		this.phone = phone;
		this.rolename = rolename;
	}

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username == null ? null : username.trim();
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password == null ? null : password.trim();
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email == null ? null : email.trim();
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone == null ? null : phone.trim();
    }

    public String getRolename() {
        return rolename;
    }

    public void setRolename(String rolename) {
        this.rolename = rolename == null ? null : rolename.trim();
    }

	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", password=" + password + ", email=" + email + ", phone="
				+ phone + ", rolename=" + rolename + "]";
	}
    
}

PageBean.java

package com.ssmtest.entity;

import java.util.List;
/**
 * 分頁實體類
 * @author Peng
 * @Date2016年12月13日 上午9:40:10
 */
public class PageBean<T> {

	private int currPage;//當前頁數
    private int pageSize;//每頁顯示的記錄數
    private int totalCount;//總記錄數
    private int totalPage;//總頁數
    private List<T> lists;//每頁的顯示的資料
	
	public PageBean() {
		super();
	}

	public int getCurrPage() {
		return currPage;
	}

	public void setCurrPage(int currPage) {
		this.currPage = currPage;
	}

	public int getPageSize() {
		return pageSize;
	}

	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}

	public int getTotalCount() {
		return totalCount;
	}

	public void setTotalCount(int totalCount) {
		this.totalCount = totalCount;
	}

	public int getTotalPage() {
		return totalPage;
	}

	public void setTotalPage(int totalPage) {
		this.totalPage = totalPage;
	}

	public List<T> getLists() {
		return lists;
	}

	public void setLists(List<T> lists) {
		this.lists = lists;
	}
	
}

7.2 User實體類對映檔案

UserMapper.xml

<?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.ssmtest.dao.UserDao">
	<!-- 先定義一個Interface，UserMapper，然後Mapper檔案的namespace指向的就是這個Interface， UserInterface裡定義的方法和UserMapper.xml檔案中的一樣, 
		然後程式碼裡直接使用介面 -->
	<resultMap id="BaseResultMap" type="com.ssmtest.entity.User">
		<id column="id" property="id" jdbcType="INTEGER" />
		<result column="userName" property="username" jdbcType="VARCHAR" />
		<result column="password" property="password" jdbcType="VARCHAR" />
		<result column="email" property="email" jdbcType="VARCHAR" />
		<result column="phone" property="phone" jdbcType="VARCHAR" />
		<result column="roleName" property="rolename" jdbcType="VARCHAR" />
	</resultMap>

	<sql id="Base_Column_List">
		id, userName, password, email, phone, roleName
	</sql>

	<!--根據主鍵查詢一條使用者資料 -->
	<select id="selectByPrimaryKey" resultMap="BaseResultMap"
		parameterType="java.lang.Integer">
		select
		<include refid="Base_Column_List" />
		from tb_user
		where id = #{id,jdbcType=INTEGER}
	</select>

	<!--使用者登入 -->
	<select id="loginByUserNameAndPassword"  resultMap="BaseResultMap" parameterType="com.ssmtest.entity.User">
		select 
		<include refid="Base_Column_List" />
		 from tb_user 
		 where 
		 userName = #{username} 
		 and password = #{password} 
	</select>
	
	<!-- 根據分頁資料start 和size查詢資料 -->
	<select id="findByPage" parameterType="Map" resultMap="BaseResultMap">
		select
		<include refid="Base_Column_List" />
		from tb_user
		<if test="start!=null and size!=null">
			limit #{start},#{size}
		</if>
	</select>

	<!--查詢所有使用者資料 -->
	<select id="selectUserList" resultType="com.ssmtest.entity.User">
		select
		<include refid="Base_Column_List" />
		from tb_user
	</select>

	<!-- 查詢使用者記錄總數 -->
	<select id="selectCount" resultType="int">
		select count(*) from tb_user
	</select>

	<!--根據主鍵刪除一條使用者資料 -->
	<delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
		delete from tb_user
		where id = #{id,jdbcType=INTEGER}
	</delete>

	<!--插入一條完整使用者資料 -->
	<insert id="insert" parameterType="com.ssmtest.entity.User">
		insert into tb_user (id, userName, password,
		email, phone, roleName
		)
		values (#{id,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR},
		#{password,jdbcType=VARCHAR},
		#{email,jdbcType=VARCHAR}, #{phone,jdbcType=VARCHAR}, #{rolename,jdbcType=VARCHAR}
		)
	</insert>

	<!--插入一條使用者資料 ，可以不完整 -->
	<insert id="insertSelective" parameterType="com.ssmtest.entity.User">
		insert into tb_user
		<trim prefix="(" suffix=")" suffixOverrides=",">
			<if test="id != null">
				id,
			</if>
			<if test="username != null">
				userName,
			</if>
			<if test="password != null">
				password,
			</if>
			<if test="email != null">
				email,
			</if>
			<if test="phone != null">
				phone,
			</if>
			<if test="rolename != null">
				roleName,
			</if>
		</trim>
		<trim prefix="values (" suffix=")" suffixOverrides=",">
			<if test="id != null">
				#{id,jdbcType=INTEGER},
			</if>
			<if test="username != null">
				#{username,jdbcType=VARCHAR},
			</if>
			<if test="password != null">
				#{password,jdbcType=VARCHAR},
			</if>
			<if test="email != null">
				#{email,jdbcType=VARCHAR},
			</if>
			<if test="phone != null">
				#{phone,jdbcType=VARCHAR},
			</if>
			<if test="rolename != null">
				#{rolename,jdbcType=VARCHAR},
			</if>
		</trim>
	</insert>

	<!--根據主鍵更新一條使用者資料，可以不完整 -->
	<update id="updateByPrimaryKeySelective" parameterType="com.ssmtest.entity.User">
		update tb_user
		<set>
			<if test="username != null">
				userName = #{username,jdbcType=VARCHAR},
			</if>
			<if test="password != null">
				password = #{password,jdbcType=VARCHAR},
			</if>
			<if test="email != null">
				email = #{email,jdbcType=VARCHAR},
			</if>
			<if test="phone != null">
				phone = #{phone,jdbcType=VARCHAR},
			</if>
			<if test="rolename != null">
				roleName = #{rolename,jdbcType=VARCHAR},
			</if>
		</set>
		where id = #{id,jdbcType=INTEGER}
	</update>

	<!--根據主鍵更新一條使用者資料 -->
	<update id="updateByPrimaryKey" parameterType="com.ssmtest.entity.User">
		update tb_user
		set userName = #{username,jdbcType=VARCHAR},
		password = #{password,jdbcType=VARCHAR},
		email = #{email,jdbcType=VARCHAR},
		phone = #{phone,jdbcType=VARCHAR},
		roleName = #{rolename,jdbcType=VARCHAR}
		where id = #{id,jdbcType=INTEGER}
	</update>
</mapper>

7.3 Dao層介面

UserDao.java

package com.ssmtest.dao;

import java.util.HashMap;
import java.util.List;

import com.ssmtest.entity.User;

public interface UserDao {
	/**
	 * 根據主鍵刪除一條使用者資料
	 * @param id
	 * @return
	 */
    int deleteByPrimaryKey(Integer id);
    /**
     * 插入一條使用者資料 ，可以不完整
     * @param record
     * @return
     */
    int insertSelective(User record);
    /**
     * 根據主鍵查詢一條使用者資料
     * @param id
     * @return
     */
    User selectByPrimaryKey(Integer id);
    /**
     * 使用者登入
     * @param record
     * @return
     */
    User loginByUserNameAndPassword(User record);
    /**
     * 根據主鍵更新一條使用者資料，可以不完整 -
     * @param record
     * @return
     */
    int updateByPrimaryKeySelective(User record);

    /**
     * 查詢所有使用者資料
     * @return
     */
    List<User> selectUserList();
    /**
     * 查詢使用者記錄總數
     * @return
     */
    int selectCount();
    /**
     * 分頁操作，呼叫findByPage limit分頁方法
     * @param map
     * @return
     */
    List<User> findByPage(HashMap<String,Object> map);
}

7.4 Service層

userService.java

package com.ssmtest.service;

import java.util.List;

import com.ssmtest.entity.PageBean;
import com.ssmtest.entity.User;
/**
 * User類業務層介面
 * @author Peng
 * @Date2016年12月13日上午9:54:40
 */
public interface UserService {
	
	int deleteByPrimaryKey(Integer id);

    int insertSelective(User record);

    User selectByPrimaryKey(Integer id);
    
    User loginByUserNameAndPassword(User record);
    
    List<User> selectUserList();
    
    int selectCount();
    
    int updateByPrimaryKeySelective(User record);

    PageBean<User> findByPage(int currentPage);
}

UserServiceImpl.java

package com.ssmtest.service.impl;

import java.util.HashMap;
import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.ssmtest.dao.UserDao;
import com.ssmtest.entity.PageBean;
import com.ssmtest.entity.User;
import com.ssmtest.service.UserService;
/**
 * User類業務層實現類
 * @author Peng
 * @Date2016年12月13日上午9:54:56
 */
@Service("userService")
public class UserServiceImpl implements UserService {

	@Resource
	private UserDao userDao;
	@Override
	public int deleteByPrimaryKey(Integer id) {
		return userDao.deleteByPrimaryKey(id);
	}

	@Override
	public int insertSelective(User record) {
		
		return userDao.insertSelective(record);
	}

	@Override
	public User selectByPrimaryKey(Integer id) {
	
		return userDao.selectByPrimaryKey(id);
	}

	@Override
	public int updateByPrimaryKeySelective(User record) {
		return userDao.updateByPrimaryKeySelective(record);
	}

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

	@Override
	public int selectCount() {
		return userDao.selectCount();
	}

	@Override
	public User loginByUserNameAndPassword(User record) {
		
		return userDao.loginByUserNameAndPassword(record);
	}

	@Override
	public PageBean<User> findByPage(int currentPage) {
		HashMap<String,Object> map = new HashMap<String,Object>();
		PageBean<User> pageBean = new PageBean<User>();
		
	    //封裝當前頁數
        pageBean.setCurrPage(currentPage);
        
		//每頁顯示的資料
		int pageSize=5;
		pageBean.setPageSize(pageSize);
		
		//封裝總記錄數
		int totalCount = userDao.selectCount();
		pageBean.setTotalCount(totalCount);
		
		//封裝總頁數
		double tc = totalCount;
        Double num =Math.ceil(tc/pageSize);//向上取整
        pageBean.setTotalPage(num.intValue());
      
		map.put("start",(currentPage-1)*pageSize);
		map.put("size", pageBean.getPageSize());
		//封裝每頁顯示的資料
		List<User> lists = userDao.findByPage(map);
		pageBean.setLists(lists);
		
		return pageBean;
	}
}

7.5 controller

package com.ssmtest.controller;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.SessionAttributes;

import com.ssmtest.entity.User;
import com.ssmtest.service.UserService;

@SessionAttributes("currentUser")
@Controller
public class UserController {

	@Resource
	private UserService userService;
	/**
	 * 使用者登入
	 * @param user
	 * @param request
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/login")
	public String login(@RequestParam("userName")String userName,
			@RequestParam("password")String password,Model model) throws Exception{
		User user = new User();
		user.setUsername(userName);
		user.setPassword(password);
		User userresult = userService.loginByUserNameAndPassword(user);
		if(userresult!=null){
			//登入成功
			List<User> lists = userService.selectUserList();
			model.addAttribute("userLists", lists);//回顯使用者資訊
			model.addAttribute("currentUser", userresult.getUsername());	
			return "redirect:main";
		}
		return "error";
	}
	@RequestMapping("/main")
	public String  main(@RequestParam(value="currentPage",defaultValue="1",required=false)int currentPage,Model model){
		model.addAttribute("pagemsg", userService.findByPage(currentPage));//回顯分頁資料
		return "main";
	}
	/**
	 * 跳到編輯頁面
	 * @param currentPage
	 * @param model
	 * @return
	 */
	@RequestMapping("/edit")
	public String editpage(@RequestParam("id") int id,Model model){
		User user =userService.selectByPrimaryKey(id);
		model.addAttribute("returnUser", user);
		return "edit";
	}
	/**
	 * 儲存使用者資料
	 * @return
	 */
	@RequestMapping("/save")
	public String save(User user){
		System.out.println(user.toString());
		if(user.getId()==null){
			//id為null是儲存
			userService.insertSelective(user);
		}else{
			//有id值為修改
			userService.updateByPrimaryKeySelective(user);
		}	
		return "redirect:main";
	}
	/**
	 * 刪除使用者資料
	 * @param id
	 * @return
	 */
	@RequestMapping("/delete")
	public String delete(@RequestParam("id") int id){
		userService.deleteByPrimaryKey(id);
		return "redirect:main";
	}
	/**
	 * 新增一個使用者資料
	 * @return
	 */
	@RequestMapping("/add")
	public String add(Model model){
		model.addAttribute("returnUser", new User());
		return "edit";
	}
}

8.JSP頁面

index.jsp

<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!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>Index.jsp</title>
<body>

<h2>歡迎登陸</h2>
	
	<form action="login" method="post">
		使用者名稱:<input type="text" name="userName"/><br>
		密  碼:<input type="password" name="password"/><br>
		<input type="submit" value="登入"/>
	</form>

</body>
</html>

main.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!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>主頁</title>
<style type="text/css">
	td{text-align: center;}
	.td2{text-align: right;}
 	.table1{
            border:1px solid #ddd;
            width:900px;            
        }
        thead{
            background-color:lightblue;
        }
</style>
</head>
<body>
	歡迎你：${currentUser}
	<br>
 	<%-- 當前使用者：${pageScope.currentUser}<!-- (只能在同一個頁面中使用) --> <br>
	當前使用者：${requestScope.currentUser}-${roleName} 有重定向資料就訪問不到<br>
	當前使用者：${sessionScope.currentUser}-${roleName} 可以使用<br> --%> 
	<hr>
	<a href="add"> 新增使用者</a><br>
	<c:if test="${empty requestScope.pagemsg}">
		沒有任何使用者資訊！
	</c:if>
	<c:if test="${!empty requestScope.pagemsg}">
		<table border="1" cellpadding="10" cellspacing="0" class="table1">
		<thead>
			<tr>
				<td>編號</td>
				<td>使用者名稱</td>
				<td>密碼</td>
				<td>郵件</td>
				<td>聯絡電話</td>
				<td>職位</td>
				<td>Edit</td>
				<td>Delete</td>
			</tr>
			</thead>
			<c:forEach items="${requestScope.pagemsg.lists}" var="u">
				<tr>
					<th>${u.id }</th>
					<th>${u.username }</th>
					<th>${u.password }</th>
					<th>${u.email }</th>
					<th>${u.phone }</th>
					<th>${u.rolename }</th>
					<th><a href="edit?id=${u.id}">Edit</a></th>
					<th><a href="delete?id=${u.id}" οnclick="return confirm('確定要刪除嗎')">Delete</a></th>
				</tr>
			</c:forEach>		
		</table>	
	</c:if>
	
<table  border="0" cellspacing="0" cellpadding="0"  width="900px">
<tr>

<td class="td2">


   <span>第${requestScope.pagemsg.currPage }/ ${requestScope.pagemsg.totalPage}頁</span>  
   <span>總記錄數：${requestScope.pagemsg.totalCount }  每頁顯示:${requestScope.pagemsg.pageSize}</span>  
   <span>
       <c:if test="${requestScope.pagemsg.currPage != 1}">
           <a href="${pageContext.request.contextPath }/main?currentPage=1">[首頁]</a>  
           <a href="${pageContext.request.contextPath }/main?currentPage=${requestScope.pagemsg.currPage-1}">[上一頁]</a>  
       </c:if>
       
       <c:if test="${requestScope.pagemsg.currPage != requestScope.pagemsg.totalPage}">
           <a href="${pageContext.request.contextPath }/main?currentPage=${requestScope.pagemsg.currPage+1}">[下一頁]</a>  
           <a href="${pageContext.request.contextPath }/main?currentPage=${requestScope.pagemsg.totalPage}">[尾頁]</a>  
       </c:if>
   </span>
</td>
</tr>
</table>
</body>
</html>

error.jsp

<%@ page language="java" contentType="text/html; charset=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>Insert title here</title>
</head>
<body>
	<a href="${pageContext.request.contextPath }/index.jsp">登入發生錯誤，請重新登入</a>
</body>
</html>

edit.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<!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>編輯頁面</title>
</head>
<body>
	歡迎你：${currentUser}
	<hr>
	<form:form action="save" method="post" modelAttribute="returnUser">
		<form:hidden path="id"/>
		使用者名稱:<form:input path="username" /><br>
		密碼:<form:input path="password" /><br>
		郵件:<form:input path="email" /><br>
		聯絡電話:<form:input path="phone" /><br>
		職位:<form:select path="rolename">
				<form:option value="">請選擇職位</form:option>
				<form:option value="客戶經理">客戶經理</form:option>
				<form:option value="高管">高管</form:option>
				<form:option value="銷售主管">銷售主管</form:option>
				<form:option value="系統管理員">系統管理員</form:option>
			</form:select><br>
			<input type="submit" value="提交"/>
	</form:form>
</body>
</html>

碼程式碼下載https://download.csdn.net/download/sinat_37001576/10502521

indexdb實現分頁查詢
2022-01-16
Index
ThinkPhp框架：分頁查詢
2020-04-05
PHP框架
c# winform 實現分頁查詢
2020-12-11
C#ORM
MYSQL SQLServer分頁查詢的實現
2016-09-12
MySqlServer
SSH框架下的分頁查詢
2018-12-12
框架
ssh框架中的分頁查詢
2017-12-10
框架
如何優雅地實現分頁查詢
2018-08-26
Hibernate實現分頁查詢的原理
2003-09-10
java-用SSH框架實現將查詢的資訊分頁顯示
2016-11-16
Java框架
如果走框架在同一頁面裡實現多個列表的分頁查詢
2008-01-06
框架
SSH整合實現分頁查詢(兩種方式)
2018-11-16
老聲常談，分頁查詢的實現就是不分頁
2005-11-11
golang通過mysql語句實現分頁查詢
2022-04-16
GolangMySql
golang透過mysql語句實現分頁查詢
2022-04-16
GolangMySql
在SSH框架下按條件分頁查詢
2013-07-19
框架
SSM 框架快速整合例項--學生查詢
2018-05-10
SSM框架
SpringMVC+Spring Data JPA +Bootstrap 分頁實現和模糊查詢分頁
2018-03-17
SpringMVCboot
Elasticsearch 分頁查詢
2021-04-05
Elasticsearch
ssh 分頁查詢
2018-01-30
oracle分頁查詢
2007-04-04
Oracle
Tp框架實現好看分頁效果
2017-09-18
框架
MySQL的分頁查詢
2020-01-15
MySql
分頁查詢優化
2020-04-05
優化
NET 集合分頁查詢
2018-09-09
MySQL 多表查詢分頁
2016-11-29
MySql
分頁查詢重構
2015-02-17
Oracle的分頁查詢
2011-06-16
Oracle
Oracle分頁查詢格式
2010-07-03
Oracle
Lucene的分頁查詢
2013-02-26
PHP 實現二分查詢
2019-04-03
PHP
elasticsearch查詢之大資料集分頁查詢
2022-02-08
Elasticsearch大資料
MaxCompute如何對SQL查詢結果實現分頁獲取
2019-04-16
SQL
JSP怎樣將查詢的資料實現分頁操作
2020-12-03
JS
實現分頁顯示資料[並按關鍵字查詢]
2012-08-01
WebView實現頁內文字查詢功能
2018-01-26
WebView
分庫分表後的分頁查詢
2021-04-25
AntDesignBlazor示例——分頁查詢
2023-12-16
Blazor
MySQL分頁查詢優化
2020-10-13
MySql優化