Maven工程
1、新建一个maven工程
group id:项目的组织目录
Artifact Id:项目名
Packaging:项目类型 war:web项目
2、目录结构
src/main/java:java代码都放在下边
src/main/resource:配置文件都放在这下面
src/main/webapp:所有的网页文件都放在这下面
在webapp下面创建 WEB-INFO步骤:
① 属性
② Project Facets
③ 把Dynamic Web Module的钩去掉 应用
Further configuration available... 绿色感叹号
Content directory : 填 src/main/webapp
勾选 Generate web.xml deployment ddescriptor
⑤ 再把钩勾上 ⑥ 应用
3、引入项目依赖的jar包
① maven配置:
属性 ----》 Maven -----》 User Settings ----》Global Settings (改成maven程序的根目录下的conf\settings.xml)
② 增加settings.xml的配置
<mirrors>
这下面增加一段代码:镜像 中央仓库使用阿里云的镜像仓库 (好处:下载jar包速度比较快)
<mirror>
<id>nexus-aliyun</id>
<mirrorOf>*</mirrorOf>
<name>Nexus aliyun</name>
<url>http://maven.aliyun.com/nexus/content/groups/public</url>
</mirror>
</mirrors>
<profiles>
这下面增加这段代码:用于配置web项目的默认java版本
<profile>
<id>JDK-1.8</id>
<activation>
<activeByDefault>true</activeByDefault>
<jdk>1.8</jdk>
</activation>
<properties>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
<maven.compiler.compilerVersion>1.8</maven.compiler.compilerVersion>
</properties>
</profile>
</profiles>
③ 配置完毕后引入jar包(POM.xml)
Spring
Spring MVC
Mybatis
数据库连接池、驱动包
其他(插件等)
java仓库:mvnrepository.com
<!-- ******************************************************** -->
插件:
pageHelper
mybatis-generator-core
spring:
spring-webmvc
spring-jdbc
spring-test
spring aspects
mybatis:
mybatis
mybatis-spring
支持:
jackson-databind
c3p0
mysql-connector-java
jstl
hibernate-validator
javax.servlet-api
Hibernate Validator Engine Relocation Artifact
<!-- ******************************************************** -->
<!--引入项目依赖的jar包 -->
<!-- SpringMVC、Spring -->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependencies>
<!--引入pageHelper分页插件 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.0.0</version>
</dependency>
<!-- MBG -->
<!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.5</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.0.1</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- 返回json字符串的支持 -->
<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.8.8</version>
</dependency>
<!--JSR303数据校验支持;tomcat7及以上的服务器,
tomcat7以下的服务器:el表达式。额外给服务器的lib包中替换新的标准的el
-->
<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-validator -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-validator</artifactId>
<version>5.4.1.Final</version>
</dependency>
<!-- Spring-Jdbc -->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!--Spring-test -->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-test -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- Spring面向切面编程 -->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-aspects -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!--MyBatis -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.2</version>
</dependency>
<!-- MyBatis整合Spring的适配包 -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency>
<!-- 数据库连接池、驱动 -->
<!-- https://mvnrepository.com/artifact/c3p0/c3p0 -->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.41</version>
</dependency>
<!-- (jstl,servlet-api,junit) -->
<!-- https://mvnrepository.com/artifact/jstl/jstl -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
</dependencies>
4、引入前端js、css、html等文件
5、创建ssm整合的关键配置文件
web.xml,spring,springmvc,mybatis
①、web.xml配置
<!--1、启动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>
<!--2、springmvc的前端控制器,拦截所有请求 -->
<!-- The front controller of this Spring Web application, responsible for handling all application requests -->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<!-- Map all requests to the DispatcherServlet for handling -->
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 3、字符编码过滤器,一定要放在所有过滤器之前 -->
<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>
<!-- 4、使用Rest风格的URI,将页面普通的post请求转为指定的delete或者put请求 -->
<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>
<filter>
<filter-name>HttpPutFormContentFilter</filter-name>
<filter-class>org.springframework.web.filter.HttpPutFormContentFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>HttpPutFormContentFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
②、在resource下创建Spring的配置文件applicationContext.xml文件
③、在web.xml的同级目录下创建 spring-mvc的配置文件 dispatcherServlet-servlet.xml文件
6、编写springmvc配置文件(dispatcherServlet-servlet.xml)
***Springmvc配置文件,主要包含网站跳转逻辑,配置***
<!-- use-default-filters="false" 禁用掉默认行为 -->
<context:component-scan base-package="com.lz" use-default-filters="false">
<!-- 只扫描控制器 -->
<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!-- 配置视图解析器,方便页面返回 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/views/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!-- 两个标准配置 -->
<!-- 将springmvc不能处理的请求交给tomcat -->
<mvc:default-servlet-handler/>
<!-- 能支持springmvc更高级一些的功能,比如jsr303校验,快捷ajax... -->
<mvc:annotation-driven/>
7、编写spring配置文件(applicationContext.xml)
<!-- Spring配置文件的核心点:数据源、与mybatis整合、事务控制 -->
<!-- Spring的配置文件,这里主要配置和业务逻辑有关的 -->
<!-- 数据源、事务控制,等都在里面 -->
<context:component-scan base-package="com.lz">
<context:exclude-filter type="annotation"
expression="org.springframework.stereotype.Controller" />
</context:component-scan>
<!-- 引入properties文件 -->
<!--
jdbc.jdbcUrl=jdbc:mysql://localhost:3306/ssm_crud
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.user=root
jdbc.password=1122
-->
<context:property-placeholder location="classpath:dbconfig.properties" />
<!-- 配置c3p0数据源 -->
<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>
<!-- 配置和mybatis的整合 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 指定mybatis全局配置文件的位置 -->
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
<property name="dataSource" ref="pooledDataSource"></property>
<!-- 指定mybatis,mapper文件的位置 -->
<property name="mapperLocations" value="classpath:mapper/*.xml"></property>
</bean>
<!-- 配置扫描器 ,将mybatis接口的实现加入到ioc容器中-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 扫描所有的dao接口的实现,加入到ioc容器中 -->
<property name="basePackage" value="com.lz.crud.dao"></property>
</bean>
<!-- *********************事务控制的配置********************** -->
<!-- 事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<!-- 控制数据源 -->
<property name="dataSource" ref="pooledDataSource"></property>
</bean>
<!-- 开启基于注解的事务,使用xml配置形式的事务(必要主要的都是使用配置式) -->
<aop:config>
<!-- 切入点表达式 -->
<!-- execution(星号代表所有 ..代表即使service下还有子包,依然有效) *(..):*()代表所有方法,..代表参数任意多 -->
<aop:pointcut expression="execution(* com.lz.crud.service..*(..))" id="txPoint"/>
<!-- 配置事务增强 -->
<!-- pointcut-ref:指向切入点表达式 -->
<aop:advisor advice-ref="txAdvice" pointcut-ref="txPoint"/>
</aop:config>
<!-- 配置事务增强,事务如何切入 -->
<!-- id:给advice起个名
transaction-manager:事务管理器名
-->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<!-- *:代表所有方法都是事务方法 -->
<tx:method name="*"/>
<!-- get*:代表以get开头的方法都是事务方法 -->
<!-- read-only:true代表只读的,以get开头的方法一般都是查询,这个标签可以优化 -->
<tx:method name="get*" read-only="true"/>
</tx:attributes>
</tx:advice>
<!-- *********************事务控制的配置********************** -->
****事务控制****
切入点表达式的意思是哪些方法可能要切入事务<aop:pointcut>
当切入事务之后该干的事情访问事务增强 <tx:advice>
8、Mybatis配置文件 mybatis-config.xml
<settings>
<!-- 启用从经典数据库列名称A_COLUMN到骆驼案例经典Java属性名称aColumn的自动映射。 -->
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
<typeAliases>
<package name="com.lz.crud.bean"/>
</typeAliases>
9、配置逆向工程
Mybatis Generator http://www.mybatis.org/generator/
一、在根目录创建xml文件mbg.xml
二、导入Generator的jar包
三、配置mbg.xml
<!--
targetRuntime="MyBatis3Simple":生成简单版的CRUD
MyBatis3:豪华版
-->
<context id="DB2Tables" targetRuntime="MyBatis3">
<!-- jdbcConnection:指定如何连接到目标数据库 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/ssm_crud?allowMultiQueries=true"
userId="root"
password="1122">
</jdbcConnection>
<javaTypeResolver >
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- javaModelGenerator:指定javaBean的生成策略
targetPackage="test.model":目标包名
targetProject="\MBGTestProject\src":目标工程
-->
<javaModelGenerator targetPackage="com.lz.crud.bean"
targetProject=".\src\main\java">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- sqlMapGenerator:sql映射生成策略: -->
<sqlMapGenerator targetPackage="mapper"
targetProject=".\src\main\resource">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- javaClientGenerator:指定dao\mapper接口所在的位置-->
<javaClientGenerator type="XMLMAPPER"
targetPackage="com.lz.crud.dao"
targetProject=".\src\main\java">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!-- 指定要逆向分析哪些表:根据表要创建javaBean 指定每个表的生成策略-->
<table tableName="tbl_emp" domainObjectName="Employee"></table>
<table tableName="tbl_dept" domainObjectName="Department"></table>
</context>
10、使用逆向工程生成的Mapper中的内容
http://www.mybatis.org/generator/running/runningWithJava.html
selectByExample:带条件的查询
用法:
EmployeeExample employeeExample = new EmployeeExample();
//创建一个Criteria,这个Criteria就是拼装查询条件
Criteria criteria = employeeExample.createCriteria();
criteria.andEmpNameLike("%李%");
Criteria criteria2 = employeeExample.createCriteria();
criteria2.andEmailLike("s");
employeeExample.or(criteria2);
List<Employee> selectByExample = mapper.selectByExample(employeeExample);
for (Employee employee : selectByExample) {
System.out.println(employee);
}
selectByPrimaryKey:根据主键查询
deleteByPrimaryKey:根据主键删除
deleteByExample:根据条件删除
insert:插入
insertSelective:带if判断的插入,会根据带的值插入
countByExample:按照条件统计
updateByExampleSelective:按照条件,带选择的更新 带了什么属性,更新什么属性。
updateByExample:按照条件更新,更新全字段
updateByPrimaryKeySelective:按照主键进行更新,有选择的
updateByPrimaryKey:按照主键更新全字段的。
11、测试方法(非必须)
<!-- 可以执行批量的SQLSession -->
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>
<constructor-arg name="executorType" ref="DATCH"></constructor-arg>
</bean>
********************************完整代码************************************
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:applicationContext.xml"})
public class MapperTest {
@Autowired
DepartmentMapper departmentMapper;
@Autowired
EmployeeMapper employeeMapper;
/*
* 批量的 SqlSession
*/
@Autowired
SqlSession sqlSession;
/**
* 测试DepartmentMapper
*/
@Test
public void testCRUD() {
System.out.println(departmentMapper);
DepartmentExample departmentExample = new DepartmentExample();
departmentMapper.insertSelective(new Department(null,"农业部"));
Criteria createCriteria = departmentExample.createCriteria();
createCriteria.andDeptNameEqualTo("商务部");
List<Department> selectByExample = departmentMapper.selectByExample(departmentExample);
for (Department department : selectByExample) {
System.out.println(department);
}
}
}
********************************完整代码************************************
分页插件:pagehelper(https://github.com/pagehelper/Mybatis-PageHelper/blob/master/wikis/en/HowToUse.md)
一、在POM.xml引入pageHelper分页插件
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.0.0</version>
</dependency>
二、在mybatis-config.xml文件加入
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<property name="param1" value="value1"/>
</plugin>
</plugins>
三、在Controller中引用
①、调用PageHelper方法
Page<Object> startPage = PageHelper.startPage(pn,5);
②、参数中传入页码以及分页大小
(@RequestParam(value="pn",defaultValue="1")Integer pn)
③、紧跟在startPage方法之后的查询就是分页查询
List<Employee> emps = employeeService.getEmpAll();
④、使用pageInfo包装结果
PageInfo page = new PageInfo(emps);
pageInfo详解:
page.getPageNum():当前页码
page.getPageSize()
page.getStartRow()
page.getEndRow()
page.getTotal():总记录数据
page.getPages():总页码
page.getFirstPage()
page.getLastPage()
page.isFirstPage()
page.isLastPage()
page.isHasPreviousPage()
page.isHasNextPage()
需要连续显示的页码:int[] nums = pi.getNavigatepageNums();
四、Spring自带的测试方法
需要Servlet3.0的支持
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.0.1</version>
<scope>provided</scope>
</dependency>
关键接口 MockMvc:虚拟请求
********************************完整代码************************************
package com.lz.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.github.pagehelper.PageInfo;
import com.lz.crud.bean.Employee;
/**
* 使用Spring测试模块提供的测试请求功能,测试curd请求的正确性
* Spring4测试的时候,需要servlet3.0的支持
* @author lfy
*
*/
@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 mockMvc;
@Before
public void initMokcMvc() {
mockMvc = MockMvcBuilders.webAppContextSetup(context).build();
}
@Test
public void testPage() throws Exception {
//模拟请求拿到返回值
MvcResult result = mockMvc.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.print(" "+i);
}
//获取员工数据
List<Employee> list = pi.getList();
for (Employee employee : list) {
System.out.println("ID:"+employee.getEwmpId()+"==>Name:"+employee.getEmpName());
}
}
}
********************************完整代码************************************
1、新建一个maven工程
group id:项目的组织目录
Artifact Id:项目名
Packaging:项目类型 war:web项目
2、目录结构
src/main/java:java代码都放在下边
src/main/resource:配置文件都放在这下面
src/main/webapp:所有的网页文件都放在这下面
在webapp下面创建 WEB-INFO步骤:
① 属性
② Project Facets
③ 把Dynamic Web Module的钩去掉 应用
Further configuration available... 绿色感叹号
Content directory : 填 src/main/webapp
勾选 Generate web.xml deployment ddescriptor
⑤ 再把钩勾上 ⑥ 应用
3、引入项目依赖的jar包
① maven配置:
属性 ----》 Maven -----》 User Settings ----》Global Settings (改成maven程序的根目录下的conf\settings.xml)
② 增加settings.xml的配置
<mirrors>
这下面增加一段代码:镜像 中央仓库使用阿里云的镜像仓库 (好处:下载jar包速度比较快)
<mirror>
<id>nexus-aliyun</id>
<mirrorOf>*</mirrorOf>
<name>Nexus aliyun</name>
<url>http://maven.aliyun.com/nexus/content/groups/public</url>
</mirror>
</mirrors>
<profiles>
这下面增加这段代码:用于配置web项目的默认java版本
<profile>
<id>JDK-1.8</id>
<activation>
<activeByDefault>true</activeByDefault>
<jdk>1.8</jdk>
</activation>
<properties>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
<maven.compiler.compilerVersion>1.8</maven.compiler.compilerVersion>
</properties>
</profile>
</profiles>
③ 配置完毕后引入jar包(POM.xml)
Spring
Spring MVC
Mybatis
数据库连接池、驱动包
其他(插件等)
java仓库:mvnrepository.com
<!-- ******************************************************** -->
插件:
pageHelper
mybatis-generator-core
spring:
spring-webmvc
spring-jdbc
spring-test
spring aspects
mybatis:
mybatis
mybatis-spring
支持:
jackson-databind
c3p0
mysql-connector-java
jstl
hibernate-validator
javax.servlet-api
Hibernate Validator Engine Relocation Artifact
<!-- ******************************************************** -->
<!--引入项目依赖的jar包 -->
<!-- SpringMVC、Spring -->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependencies>
<!--引入pageHelper分页插件 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.0.0</version>
</dependency>
<!-- MBG -->
<!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.5</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.0.1</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- 返回json字符串的支持 -->
<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.8.8</version>
</dependency>
<!--JSR303数据校验支持;tomcat7及以上的服务器,
tomcat7以下的服务器:el表达式。额外给服务器的lib包中替换新的标准的el
-->
<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-validator -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-validator</artifactId>
<version>5.4.1.Final</version>
</dependency>
<!-- Spring-Jdbc -->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!--Spring-test -->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-test -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- Spring面向切面编程 -->
<!-- https://mvnrepository.com/artifact/org.springframework/spring-aspects -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!--MyBatis -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.2</version>
</dependency>
<!-- MyBatis整合Spring的适配包 -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency>
<!-- 数据库连接池、驱动 -->
<!-- https://mvnrepository.com/artifact/c3p0/c3p0 -->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.41</version>
</dependency>
<!-- (jstl,servlet-api,junit) -->
<!-- https://mvnrepository.com/artifact/jstl/jstl -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
</dependencies>
4、引入前端js、css、html等文件
5、创建ssm整合的关键配置文件
web.xml,spring,springmvc,mybatis
①、web.xml配置
<!--1、启动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>
<!--2、springmvc的前端控制器,拦截所有请求 -->
<!-- The front controller of this Spring Web application, responsible for handling all application requests -->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<!-- Map all requests to the DispatcherServlet for handling -->
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 3、字符编码过滤器,一定要放在所有过滤器之前 -->
<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>
<!-- 4、使用Rest风格的URI,将页面普通的post请求转为指定的delete或者put请求 -->
<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>
<filter>
<filter-name>HttpPutFormContentFilter</filter-name>
<filter-class>org.springframework.web.filter.HttpPutFormContentFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>HttpPutFormContentFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
②、在resource下创建Spring的配置文件applicationContext.xml文件
③、在web.xml的同级目录下创建 spring-mvc的配置文件 dispatcherServlet-servlet.xml文件
6、编写springmvc配置文件(dispatcherServlet-servlet.xml)
***Springmvc配置文件,主要包含网站跳转逻辑,配置***
<!-- use-default-filters="false" 禁用掉默认行为 -->
<context:component-scan base-package="com.lz" use-default-filters="false">
<!-- 只扫描控制器 -->
<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!-- 配置视图解析器,方便页面返回 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/views/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!-- 两个标准配置 -->
<!-- 将springmvc不能处理的请求交给tomcat -->
<mvc:default-servlet-handler/>
<!-- 能支持springmvc更高级一些的功能,比如jsr303校验,快捷ajax... -->
<mvc:annotation-driven/>
7、编写spring配置文件(applicationContext.xml)
<!-- Spring配置文件的核心点:数据源、与mybatis整合、事务控制 -->
<!-- Spring的配置文件,这里主要配置和业务逻辑有关的 -->
<!-- 数据源、事务控制,等都在里面 -->
<context:component-scan base-package="com.lz">
<context:exclude-filter type="annotation"
expression="org.springframework.stereotype.Controller" />
</context:component-scan>
<!-- 引入properties文件 -->
<!--
jdbc.jdbcUrl=jdbc:mysql://localhost:3306/ssm_crud
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.user=root
jdbc.password=1122
-->
<context:property-placeholder location="classpath:dbconfig.properties" />
<!-- 配置c3p0数据源 -->
<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>
<!-- 配置和mybatis的整合 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 指定mybatis全局配置文件的位置 -->
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
<property name="dataSource" ref="pooledDataSource"></property>
<!-- 指定mybatis,mapper文件的位置 -->
<property name="mapperLocations" value="classpath:mapper/*.xml"></property>
</bean>
<!-- 配置扫描器 ,将mybatis接口的实现加入到ioc容器中-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 扫描所有的dao接口的实现,加入到ioc容器中 -->
<property name="basePackage" value="com.lz.crud.dao"></property>
</bean>
<!-- *********************事务控制的配置********************** -->
<!-- 事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<!-- 控制数据源 -->
<property name="dataSource" ref="pooledDataSource"></property>
</bean>
<!-- 开启基于注解的事务,使用xml配置形式的事务(必要主要的都是使用配置式) -->
<aop:config>
<!-- 切入点表达式 -->
<!-- execution(星号代表所有 ..代表即使service下还有子包,依然有效) *(..):*()代表所有方法,..代表参数任意多 -->
<aop:pointcut expression="execution(* com.lz.crud.service..*(..))" id="txPoint"/>
<!-- 配置事务增强 -->
<!-- pointcut-ref:指向切入点表达式 -->
<aop:advisor advice-ref="txAdvice" pointcut-ref="txPoint"/>
</aop:config>
<!-- 配置事务增强,事务如何切入 -->
<!-- id:给advice起个名
transaction-manager:事务管理器名
-->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<!-- *:代表所有方法都是事务方法 -->
<tx:method name="*"/>
<!-- get*:代表以get开头的方法都是事务方法 -->
<!-- read-only:true代表只读的,以get开头的方法一般都是查询,这个标签可以优化 -->
<tx:method name="get*" read-only="true"/>
</tx:attributes>
</tx:advice>
<!-- *********************事务控制的配置********************** -->
****事务控制****
切入点表达式的意思是哪些方法可能要切入事务<aop:pointcut>
当切入事务之后该干的事情访问事务增强 <tx:advice>
8、Mybatis配置文件 mybatis-config.xml
<settings>
<!-- 启用从经典数据库列名称A_COLUMN到骆驼案例经典Java属性名称aColumn的自动映射。 -->
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
<typeAliases>
<package name="com.lz.crud.bean"/>
</typeAliases>
9、配置逆向工程
Mybatis Generator http://www.mybatis.org/generator/
一、在根目录创建xml文件mbg.xml
二、导入Generator的jar包
三、配置mbg.xml
<!--
targetRuntime="MyBatis3Simple":生成简单版的CRUD
MyBatis3:豪华版
-->
<context id="DB2Tables" targetRuntime="MyBatis3">
<!-- jdbcConnection:指定如何连接到目标数据库 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/ssm_crud?allowMultiQueries=true"
userId="root"
password="1122">
</jdbcConnection>
<javaTypeResolver >
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- javaModelGenerator:指定javaBean的生成策略
targetPackage="test.model":目标包名
targetProject="\MBGTestProject\src":目标工程
-->
<javaModelGenerator targetPackage="com.lz.crud.bean"
targetProject=".\src\main\java">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- sqlMapGenerator:sql映射生成策略: -->
<sqlMapGenerator targetPackage="mapper"
targetProject=".\src\main\resource">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- javaClientGenerator:指定dao\mapper接口所在的位置-->
<javaClientGenerator type="XMLMAPPER"
targetPackage="com.lz.crud.dao"
targetProject=".\src\main\java">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!-- 指定要逆向分析哪些表:根据表要创建javaBean 指定每个表的生成策略-->
<table tableName="tbl_emp" domainObjectName="Employee"></table>
<table tableName="tbl_dept" domainObjectName="Department"></table>
</context>
10、使用逆向工程生成的Mapper中的内容
http://www.mybatis.org/generator/running/runningWithJava.html
selectByExample:带条件的查询
用法:
EmployeeExample employeeExample = new EmployeeExample();
//创建一个Criteria,这个Criteria就是拼装查询条件
Criteria criteria = employeeExample.createCriteria();
criteria.andEmpNameLike("%李%");
Criteria criteria2 = employeeExample.createCriteria();
criteria2.andEmailLike("s");
employeeExample.or(criteria2);
List<Employee> selectByExample = mapper.selectByExample(employeeExample);
for (Employee employee : selectByExample) {
System.out.println(employee);
}
selectByPrimaryKey:根据主键查询
deleteByPrimaryKey:根据主键删除
deleteByExample:根据条件删除
insert:插入
insertSelective:带if判断的插入,会根据带的值插入
countByExample:按照条件统计
updateByExampleSelective:按照条件,带选择的更新 带了什么属性,更新什么属性。
updateByExample:按照条件更新,更新全字段
updateByPrimaryKeySelective:按照主键进行更新,有选择的
updateByPrimaryKey:按照主键更新全字段的。
11、测试方法(非必须)
<!-- 可以执行批量的SQLSession -->
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>
<constructor-arg name="executorType" ref="DATCH"></constructor-arg>
</bean>
********************************完整代码************************************
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:applicationContext.xml"})
public class MapperTest {
@Autowired
DepartmentMapper departmentMapper;
@Autowired
EmployeeMapper employeeMapper;
/*
* 批量的 SqlSession
*/
@Autowired
SqlSession sqlSession;
/**
* 测试DepartmentMapper
*/
@Test
public void testCRUD() {
System.out.println(departmentMapper);
DepartmentExample departmentExample = new DepartmentExample();
departmentMapper.insertSelective(new Department(null,"农业部"));
Criteria createCriteria = departmentExample.createCriteria();
createCriteria.andDeptNameEqualTo("商务部");
List<Department> selectByExample = departmentMapper.selectByExample(departmentExample);
for (Department department : selectByExample) {
System.out.println(department);
}
}
}
********************************完整代码************************************
分页插件:pagehelper(https://github.com/pagehelper/Mybatis-PageHelper/blob/master/wikis/en/HowToUse.md)
一、在POM.xml引入pageHelper分页插件
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.0.0</version>
</dependency>
二、在mybatis-config.xml文件加入
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<property name="param1" value="value1"/>
</plugin>
</plugins>
三、在Controller中引用
①、调用PageHelper方法
Page<Object> startPage = PageHelper.startPage(pn,5);
②、参数中传入页码以及分页大小
(@RequestParam(value="pn",defaultValue="1")Integer pn)
③、紧跟在startPage方法之后的查询就是分页查询
List<Employee> emps = employeeService.getEmpAll();
④、使用pageInfo包装结果
PageInfo page = new PageInfo(emps);
pageInfo详解:
page.getPageNum():当前页码
page.getPageSize()
page.getStartRow()
page.getEndRow()
page.getTotal():总记录数据
page.getPages():总页码
page.getFirstPage()
page.getLastPage()
page.isFirstPage()
page.isLastPage()
page.isHasPreviousPage()
page.isHasNextPage()
需要连续显示的页码:int[] nums = pi.getNavigatepageNums();
四、Spring自带的测试方法
需要Servlet3.0的支持
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.0.1</version>
<scope>provided</scope>
</dependency>
关键接口 MockMvc:虚拟请求
********************************完整代码************************************
package com.lz.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.github.pagehelper.PageInfo;
import com.lz.crud.bean.Employee;
/**
* 使用Spring测试模块提供的测试请求功能,测试curd请求的正确性
* Spring4测试的时候,需要servlet3.0的支持
* @author lfy
*
*/
@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 mockMvc;
@Before
public void initMokcMvc() {
mockMvc = MockMvcBuilders.webAppContextSetup(context).build();
}
@Test
public void testPage() throws Exception {
//模拟请求拿到返回值
MvcResult result = mockMvc.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.print(" "+i);
}
//获取员工数据
List<Employee> list = pi.getList();
for (Employee employee : list) {
System.out.println("ID:"+employee.getEwmpId()+"==>Name:"+employee.getEmpName());
}
}
}
********************************完整代码************************************
纯手打 只希望对大家有用
方便的话:请关注一下我的淘宝店呗 不买也行 主要是涨涨人气