快速搭建SSM框架（分页查询）

小灰灰 2024-04-18 21:11 84阅读 0赞

**本次项目使用的IDE是Eclipse、JDK1.8、Maven、MySQL、Tomacat7、Bootstrap-3.3.7、jquery-3.4.1、STS3.9.4、分页插件（PageHelper）**

**1.创建Maven工程，并在pom.xml文件中引入框架所需的jar包**

<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/xsd/maven-4.0.0.xsd">
    	<modelVersion>4.0.0</modelVersion>
    	<groupId>com.atguigu</groupId>
    	<artifactId>SSM-CRUD</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<packaging>war</packaging>
    	
    	<dependencies>
    		
    		
    		<dependency>
    		    <groupId>org.springframework</groupId>
    		    <artifactId>spring-webmvc</artifactId>
    		    <version>4.3.7.RELEASE</version>
    		</dependency>
    		
    		
    		
    		<dependency>
    		    <groupId>org.springframework</groupId>
    		    <artifactId>spring-jdbc</artifactId>
    		    <version>4.3.7.RELEASE</version>
    		</dependency>
    		
    		
    		
    		<dependency>
    		    <groupId>org.springframework</groupId>
    		    <artifactId>spring-aspects</artifactId>
    		    <version>4.3.7.RELEASE</version>
    		</dependency>
    		
    		
    		
    		<dependency>
    		    <groupId>org.mybatis</groupId>
    		    <artifactId>mybatis</artifactId>
    		    <version>3.4.2</version>
    		</dependency>
    		
    		
    		
    		<dependency>
    		    <groupId>org.mybatis</groupId>
    		    <artifactId>mybatis-spring</artifactId>
    		    <version>1.3.1</version>
    		</dependency>
    		
    		
    		
    		<dependency>
    		    <groupId>c3p0</groupId>
    		    <artifactId>c3p0</artifactId>
    		    <version>0.9.1.2</version>
    		</dependency>
    		
    		
    		<dependency>
    		    <groupId>mysql</groupId>
    		    <artifactId>mysql-connector-java</artifactId>
    		    <version>5.1.41</version>
    		</dependency>
    		
    		
    		
    		<dependency>
    		    <groupId>jstl</groupId>
    		    <artifactId>jstl</artifactId>
    		    <version>1.2</version>
    		</dependency>
    		
    		
    		<dependency>
    		    <groupId>javax.servlet</groupId>
    		    <artifactId>javax.servlet-api</artifactId>
    		    <version>3.0.1</version>
    		    <scope>provided</scope>
    		</dependency>
    			
    		
    		<dependency>
    		    <groupId>junit</groupId>
    		    <artifactId>junit</artifactId>
    		    <version>4.12</version>
    
    		</dependency>
    		
    		
    		
    		<dependency>
    		    <groupId>org.mybatis.generator</groupId>
    		    <artifactId>mybatis-generator-core</artifactId>
    		    <version>1.3.5</version>
    		</dependency>
    		
    		
    		
    		<dependency>
    		    <groupId>org.springframework</groupId>
    		    <artifactId>spring-test</artifactId>
    		    <version>4.3.7.RELEASE</version>
    		</dependency>
    		
    		
    		<dependency>
        		<groupId>com.github.pagehelper</groupId>
        		<artifactId>pagehelper</artifactId>
        		<version>5.1.10</version>
    		</dependency>
    	</dependencies>
    </project>

2.在MySQL中创建对应的数据表，创建了emp表与dept表  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW4xMzMzMzMzNjY3Nw_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW4xMzMzMzMzNjY3Nw_size_16_color_FFFFFF_t_70 1]  
**3.创建基本的配置文件以及各种包（SSM基本的框架体系）**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW4xMzMzMzMzNjY3Nw_size_16_color_FFFFFF_t_70 2]  
**4.配置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_2_5.xsd" id="WebApp_ID" version="2.5" >
    	
    	<welcome-file-list>
    		<welcome-file>index.html</welcome-file>
    		<welcome-file>index.htm</welcome-file>
    		<welcome-file>index.jsp</welcome-file>
    		<welcome-file>default.html</welcome-file>
    		<welcome-file>default.htm</welcome-file>
    		<welcome-file>default.jsp</welcome-file>
    	</welcome-file-list>
    	
    	
    	
    	<context-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath:applicationContext.xml</param-value>
    	</context-param>
    
    	
    	<listener>
    		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    	</listener>
    	
    	
    	
    	<servlet>
    		<servlet-name>dispatcherServlet</servlet-name>
    		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    		<load-on-startup>1</load-on-startup>
    	</servlet>
    
    	
    	<servlet-mapping>
    		<servlet-name>dispatcherServlet</servlet-name>
    		<url-pattern>/</url-pattern>
    	</servlet-mapping>
    	
    	
    	<filter>
    		<filter-name>CharacterEncodingFilter</filter-name>
    		<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    		<init-param>
    			<param-name>encoding</param-name>
    			<param-value>UTF-8</param-value>
    		</init-param>
    		<init-param>
    			<param-name>forceRequestEncoding</param-name>
    			<param-value>true</param-value>
    		</init-param>
    		<init-param>
    			<param-name>forceResponseEncoding</param-name>
    			<param-value>true</param-value>
    		</init-param>
    	</filter>
    	<filter-mapping>
    		<filter-name>CharacterEncodingFilter</filter-name>
    		<url-pattern>/*</url-pattern>
    	</filter-mapping>
    	
    	
    	<filter> 
    		<filter-name>HiddenHttpMethodFilter</filter-name> 
    		<filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class> 
    	</filter>
    	<filter-mapping> 
    		<filter-name>HiddenHttpMethodFilter</filter-name> 
    		<url-pattern>/*</url-pattern>
    	</filter-mapping>
    </web-app>

**5.配置SpringMvc文件（dispatcherServlet-servlet.xml，也可以直接整合到Spring配置文件中）**

**6.配置Mybatis文件（mybatis-config.xml，也可以直接整合到Spring配置文件中）**

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    	<settings>
    		<setting name="mapUnderscoreToCamelCase" value="true"/>
    	</settings>
    	
    	<typeAliases>
    		<package name="com.atguigu.crud.bean"/>
    	</typeAliases>
    	
    	<plugins>
    		<plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
    	</plugins>
    </configuration>

**7.配置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:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" 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/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.atguigu">
    		<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    	</context:component-scan>
    	
    	
    	<context:property-placeholder location="classpath:jdbc.properties"/>
    	<bean id="pooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    		<property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
    		<property name="driverClass" value="${jdbc.driverClass}"></property>
    		<property name="user" value="${jdbc.user}"></property>
    		<property name="password" value="${jdbc.password}"></property>
    	</bean>
    	
    	
    	<bean id="SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
    		<property name="dataSource" ref="pooledDataSource"></property>
    		
    		<property name="mapperLocations" value="classpath:mapper/*.xml"></property>
    	</bean>
    	
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		
    		<property name="basePackage" value="com.atguigu.crud.dao"></property>
    	</bean>
    	
    	
    	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
    		<constructor-arg name="sqlSessionFactory" ref="SqlSessionFactory"></constructor-arg>
    		<constructor-arg name="executorType" value="BATCH"></constructor-arg>
    	</bean>
    	
    	
    	
    	
    	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		
    		<property name="dataSource" ref="pooledDataSource"></property>
    	</bean>
    	
    	
    	<aop:config>
    		
    		<aop:pointcut expression="execution(* com.atguigu.crud.service..*(..))" id="txPoint"/>
    		
    		<aop:advisor advice-ref="txAdvice" pointcut-ref="txPoint"/>
    	</aop:config>
    	
    	
    	<tx:advice id="txAdvice" transaction-manager="transactionManager">
    		<tx:attributes>
    			
    			<tx:method name="*"/>
    			
    			<tx:method name="get*" read-only="true"/>
    		</tx:attributes>
    	</tx:advice>
    	
    	
    </beans>

**8.配置JDBC基本属性（jdbc.properties）**

jdbc.user=root
    jdbc.password=xxxxxx
    jdbc.jdbcUrl=jdbc:mysql://localhost:3306/ssm_crud?useUnicode=true&characterEncoding=UTF-8
    jdbc.driverClass=com.mysql.jdbc.Driver

**9.使用Mybatis逆向工程自动创建对象与数据表所必备的一些文件（mbg.xml，MBGTest.java）**

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
    	<context id="DB2Tables" targetRuntime="MyBatis3">
    		<commentGenerator>
      			<property name="suppressAllComments" value="true" />
    		</commentGenerator>
    		
    		<jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/ssm_crud" userId="root" password="chenqi">
    		</jdbcConnection>
    
    		<javaTypeResolver>
    			<property name="forceBigDecimals" value="false" />
    		</javaTypeResolver>
    
    		
    		<javaModelGenerator targetPackage="com.atguigu.crud.bean" targetProject=".\src\main\java">
    			<property name="enableSubPackages" value="true" />
    			<property name="trimStrings" value="true" />
    		</javaModelGenerator>
    
    		
    		<sqlMapGenerator targetPackage="mapper" targetProject=".\src\main\resources">
    			<property name="enableSubPackages" value="true" />
    		</sqlMapGenerator>
    
    		
    		<javaClientGenerator type="XMLMAPPER" targetPackage="com.atguigu.crud.dao" targetProject=".\src\main\java">
    			<property name="enableSubPackages" value="true" />
    		</javaClientGenerator>
    
    		
    		<table tableName="tal_emp" domainObjectName="Employee"></table>
    		<table tableName="tal_dept" domainObjectName="Department"></table>
    
    	</context>
    </generatorConfiguration>

package com.atguigu.crud.test;
    
    import java.io.File;
    import java.io.IOException;
    import java.util.ArrayList;
    import java.util.List;
    
    import org.mybatis.generator.api.MyBatisGenerator;
    import org.mybatis.generator.config.Configuration;
    import org.mybatis.generator.config.xml.ConfigurationParser;
    import org.mybatis.generator.internal.DefaultShellCallback;
    
    public class MBGTest { 
    	public static void main(String[] args) throws Exception { 
    		List<String> warnings = new ArrayList<String>();
    		boolean overwrite = true;
    		File configFile = new File("mbg.xml");
    		ConfigurationParser cp = new ConfigurationParser(warnings);
    		Configuration config = cp.parseConfiguration(configFile);
    		DefaultShellCallback callback = new DefaultShellCallback(overwrite);
    		MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
    		myBatisGenerator.generate(null);
    	}
    }

**10.测试数据库与Java是否映射成功（MapperTest.java，向dept表内插入两条数据，批量向emp表中添加1001条数据，需要在Spring配置文件中配置Session才可以）**

package com.atguigu.crud.test;
    
    import java.util.List;
    import java.util.UUID;
    
    import org.apache.ibatis.session.SqlSession;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    import org.springframework.test.context.ContextConfiguration;
    import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    
    import com.atguigu.crud.bean.Department;
    import com.atguigu.crud.bean.Employee;
    import com.atguigu.crud.dao.DepartmentMapper;
    import com.atguigu.crud.dao.EmployeeMapper;
    
    /** * 测试dao层的工作 * @author Administrator * 测试DepartmentMapper * 推荐Spring的项目使用Spring的单元测试,可以自动注入我们需要的组件 * 1.导入SpringTest模块 * 2.@ContextConfiguration指定Spring配置文件的位置 * 3.直接autowired要使用的组件即可 */
    
    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration(locations= { "classpath:applicationContext.xml"})
    public class MapperTest { 
    	
    	@Autowired
    	DepartmentMapper departmentMapper;
    	
    	@Autowired
    	EmployeeMapper employeeMapper;
    	
    	@Autowired
    	SqlSession sqlSession;
    	
    	@Test
    	public void testCRUD() { 
    		/* //1.创建SpringIOC容器 ApplicationContext ioc = new ClassPathXmlApplicationContext("applicationContext.xml"); //2.从容器中获取Mapper DepartmentMapper departmentMapper = ioc.getBean(DepartmentMapper.class); */
    		
    // System.out.println(departmentMapper);
    		
    		//1.插入几个部门
    // departmentMapper.insertSelective(new Department(null, "开发部"));
    // departmentMapper.insertSelective(new Department(null, "测试部"));
    		
    		//2.生成员工
    // employeeMapper.insertSelective(new Employee(null, "Jerry", "M", "Jerry@atguigu.com", 1));
    		EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
    		for(int i=0;i<1000;i++) { 
    			String uid = UUID.randomUUID().toString().substring(0, 5)+i;
    			mapper.insertSelective(new Employee(null, uid, "M", uid+"@atguigu.com", 1));
    		}
    // System.out.println("批量完成");
    // Employee employee = mapper.selectByPrimaryKeyWithDept(1);
    // System.out.println(employee.getEmail());
    // List<Employee> list = mapper.selectByExampleWithDept(null);
    // System.out.println(list);
    	}
    }

**11.编写业务逻辑层（EmployeeService.java）**

package com.atguigu.crud.service;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import com.atguigu.crud.bean.Employee;
    import com.atguigu.crud.dao.EmployeeMapper;
    
    @Service
    public class EmployeeService { 
    
    	@Autowired
    	EmployeeMapper employeeMapper;
    	
    	/** * 查询所有员工 * @return */
    	public List<Employee> getAll() { 
    		return employeeMapper.selectByExampleWithDept(null);
    	}
    
    }

**12.使用分页插件将从Service层获取的数据进行分页，然后传递至前端的域中（EmployeeController.java）**

package com.atguigu.crud.controller;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    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 com.atguigu.crud.bean.Employee;
    import com.atguigu.crud.service.EmployeeService;
    import com.github.pagehelper.PageHelper;
    import com.github.pagehelper.PageInfo;
    
    /** * 处理员工的CRUD * @author Administrator * */
    
    @Controller
    public class EmployeeController { 
    	
    	@Autowired
    	EmployeeService employeeService;
    	
    	/** * 查询员工数据(分页查询) * @return */
    	@RequestMapping("/emps")
    	public String getEmps(@RequestParam(value="pn",defaultValue="1") Integer pn, Model model) { 
    		//这不是一个分页查询
    		//引入PageHelper分页插件
    		//在查询之前只需要调用PageHelper.startPage(pageNum, pageSize),传入页码,以及每页的大小
    		PageHelper.startPage(pn, 5);
    		//startPage后面紧跟的这个查询就是分页查询
    		List<Employee> emps = employeeService.getAll();
    		//使用PageInfo包装查询后的结果,只需要将PageInfo交给页面就行了
    		//封装了详细的分页信息,包括有我们查询出来的结果,传入连续显示的页数
    		PageInfo page = new PageInfo(emps,5);
    		model.addAttribute("pageInfo", page);
    		return "list";
    	}
    }

**13.测试前端是否获取到后端分页后的数据（MvcTest.java，使用SpringJunit4测试，并使用MockMvc 模拟前端发送请求，结果如下图所示）**

package com.atguigu.crud.test;
    
    import java.util.List;
    
    import org.junit.Before;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.mock.web.MockHttpServletRequest;
    import org.springframework.test.context.ContextConfiguration;
    import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    import org.springframework.test.context.web.WebAppConfiguration;
    import org.springframework.test.web.servlet.MockMvc;
    import org.springframework.test.web.servlet.MvcResult;
    import org.springframework.test.web.servlet.request.MockMvcRequestBuilders;
    import org.springframework.test.web.servlet.setup.MockMvcBuilders;
    import org.springframework.web.context.WebApplicationContext;
    
    import com.atguigu.crud.bean.Employee;
    import com.github.pagehelper.PageInfo;
    
    /** * 使用Spring测试模块提供的测试请求功能,测试crud请求的正确性 * Spring4测试的时候,需要servlet3.0以上的支持 * @author Administrator * */
    
    @RunWith(SpringJUnit4ClassRunner.class)
    @WebAppConfiguration
    @ContextConfiguration(locations={ "classpath:applicationContext.xml","file:src/main/webapp/WEB-INF/dispatcherServlet-servlet.xml"})
    public class MvcTest { 
    	
    	//传入SpringMvc的IOC
    	@Autowired
    	WebApplicationContext context;
    	
    	//虚拟mvc请求,获取到处理结果
    	MockMvc mocMvc;
    	
    	@Before
    	public void initMockMvc() { 
    		mocMvc=MockMvcBuilders.webAppContextSetup(context).build();
    	}
    	
    	@Test
    	public void testPage() throws Exception { 
    		//模拟请求拿到返回值
    		MvcResult result = mocMvc.perform(MockMvcRequestBuilders.get("/emps").param("pn", "5")).andReturn();
    		
    		//请求成功以后,请求域中会有pageInfo;我们可以取出pageInfo进行验证
    		MockHttpServletRequest request = result.getRequest();
    		PageInfo pi = (PageInfo) request.getAttribute("pageInfo");
    		System.out.println("当前页码"+pi.getPageNum());
    		System.out.println("总页码"+pi.getPages());
    		System.out.println("总记录数"+pi.getTotal());
    		System.out.println("在页面需要连续显示的页码");
    		int[] nums = pi.getNavigatepageNums();
    		for(int i:nums) { 
    			System.out.println(" "+i);
    		}
    		
    		//获取员工数据
    		List<Employee> list = pi.getList();
    		for(Employee employee:list) { 
    			System.out.println("ID:"+employee.getEmpId()+"==>Name:"+employee.getEmpName());
    		}
    	}
    }

![在这里插入图片描述][20190911211935892.png]  
**14.使用BootStrap搭建前端框架，将后端获取的值显示即可！**  
**15.至此SSM配置完成！**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW4xMzMzMzMzNjY3Nw_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/5ce9716b9c3d48f3a28d85c25bb248d1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW4xMzMzMzMzNjY3Nw_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/a10f33136490435abd21c4a2b3003e39.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW4xMzMzMzMzNjY3Nw_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/2962e1ae38024010a4cae8be81547c8d.png
[20190911211935892.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/46bee88391394118b2c5d47efa61cbfd.png