注意:所有配置文件放在resources下边
1、 Spring配置
1.1 导入依赖
<!-- spring的核心包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.19.RELEASE</version>
</dependency>
<!-- 日志包-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.12</version>
</dependency>
<!-- 单元测试-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
</dependency>
1.2 编写实体类
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Users {
private Integer id;
private String uname;
private String pwd;
private String sex;
}
1.3 编写UserService接口和实现类
public interface UsersService {
// 查询所有
String findAll();
}
@Service
public class UsersServiceImpl implements UsersService {
@Override
public String findAll() {
return usersMapper.findAll();
}
}
1.4 编写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"
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.xsd">
<!-- 开启组件扫描-->
<context:component-scan base-package="com.jl.service"/>
</beans>
1.5 编写测试类
public class TestSpring {
public static void main(String[] args) {
// 获取容器对象
ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
// 获取service
UsersService service = ctx.getBean(UsersService.class);
// 调用方法
String all = service.findAll();
System.out.println(all);
}
}
1.6 测试结果
2、SpringMVC配置
1.1 添加web框架支持
1.2 导入依赖
<!--springmvc的包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.19.RELEASE</version>
</dependency>
1.3 编写springmvc核心配置文件spring-mvc.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"
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.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!-- 组件扫描-->
<context:component-scan base-package="com.jl.controller"/>
<!-- 配置视图解析器-->
<bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/views/"/>
<property name="suffix" value=".jsp"/>
</bean>
<!-- 配置mvc注解驱动 -->
<mvc:annotation-driven>
<!-- 配置消息转换器 -->
<mvc:message-converters>
<bean class="org.springframework.http.converter.StringHttpMessageConverter">
<constructor-arg value="UTF-8"/>
<property name="writeAcceptCharset" value="false"/>
</bean>
</mvc:message-converters>
</mvc:annotation-driven>
<!-- 配置静态资源的设置-->
<mvc:default-servlet-handler/>
</beans>
1.4 配置前端控制器(web.xml)
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<!-- 配置前端控制器-->
<servlet>
<servlet-name>DispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- x配置初始化参数 -->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mvc.xml</param-value>
</init-param>
<!-- 服务器就创建该servlet对象 -->
<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>
</filter>
<filter-mapping>
<filter-name>CharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
1.5 编写controller
@Controller
@RequestMapping("/user")
public class UserController {
@GetMapping("/list")
public String toList(){
return "list";
}
@GetMapping("/all")
@ResponseBody
public String findAll(){
return "查询所有用户";
}
}
1.6 在WEB-INF下边创建views目录,新建list.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<a href="${pageContext.request.contextPath}/user/all">查询所有的用户</a>
</body>
</html>
1.7 启动服务器测试
点击超链接,执行结果
3、Spring整合SpringMVC
1.1 配置监听器
其实Spring和SpringMVC是一家人,不用刻意整合,可以将二个配置信息写在一个文件中。如果真的需要将两个配置文件同时读取的话,需要在web.xml中配置监听器
由于userService的扫描是放在spring的配置文件applicationContext中的,所以需要读取2个配置文件。
<!-- 配置context监听器-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- context参数,加载applicatioContext-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
1.2 controller中注入service
@Controller
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@GetMapping("/list")
public String toList(){
return "list";
}
@GetMapping("/all")
@ResponseBody
public String findAll(){
return userService.findAll();
}
}
1.3 启动服务器,最终也可以正常执行
1.4 其它方式整合
其实spring和springmvc的配置文件是相同的,我们的目的也是读取所有的spring配置文件,只需在读取一个配置文件时,引入其它的配置文件,这样多个配置文件就可以一并读取了。比如,我们可以在spring-mvc.xml中引入applicationContext.xml文件:
<import resource="applicationContext.xml"/>
这样可以达到相同的效果,而且配置上更简洁
4、 Mybatis配置
1.1 导入依赖
<!--mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.45</version>
</dependency>
<!-- mybatis的包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
1.2 编写mybatis核心配置文件mybatis.xml
<?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>
<!-- 读取jdbc配置文件-->
<properties resource="db.properties"/>
<!-- 配置别名扫描-->
<typeAliases>
<typeAlias type="com.jl.domain"/>
</typeAliases>
<!-- 配置数据库环境-->
<environments default="dev">
<environment id="dev">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</dataSource>
</environment>
</environments>
<!-- 读取映射文件-->
<mappers>
<mapper resource="mappers/UsersMapper.xml"/>
</mappers>
</configuration>
1.3 编写UsersMapper接口
List<User> findAll();
1.4 编写sql映射 ----UsersMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jl.mapper.UsersMapper">
<select id="findAll" resultType="users">
select * from users;
</select>
</mapper>
1.5 测试
package comjl.test;
import com.jl.domain.Users;
import com.jl.mapper.UsersMapper;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class TestMybatis {
private static SqlSessionFactory sqlSessionFactory;
static {
InputStream is = null;
try {
is = Resources.getResourceAsStream("mybatis.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
} catch (IOException e) {
e.printStackTrace();
}finally {
if (is != null){
try {
is.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
@Test
public void test(){
// 获取session对象
SqlSession sqlSession = sqlSessionFactory.openSession();
UsersMapper mapper = sqlSession.getMapper(UsersMapper.class);
List<Users> all = mapper.findAll();
for (Users users : all) {
System.out.println(users);
}
sqlSession.close();
}
}
5、Spring整合Mybatis
1.1在UserMapper接口加注解@Repository
它用于将数据访问层 (DAO 层 ) 的类标识为 Spring Bean
@Repository
public interface UsersMapper {
List<Users> findAll();
}
1.2 UserService注入UserMapper
@Service
public class UsersServiceImpl implements UsersService {
@Autowired
private UsersMapper usersMapper;
@Override
public List<Users> findAll() {
return usersMapper.findAll();
}
}
1.3 导入依赖(事务,数据库池)
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.5</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency>
<!-- 事务操作-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>4.3.19.RELEASE</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.6.8</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.3.19.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.19.RELEASE</version>
</dependency>
1.4 Spring接管Mybatis配置(修改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:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
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.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
<!-- 开启组件扫描-->
<context:component-scan base-package="com.jl.service"/>
<context:component-scan base-package="com.jl.mapper"/>
<!-- spring整合mybatis,接管mybatis的核心配置文件的功能,sql映射spring做不到,还是由mybatis
实现,但是其它,配置文件的读取,各种bean管理,datasource和事务的管理都交给spring-->
<!-- 读取datasource的配置文件-->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 配置数据源-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<!-- 配置sqlSessionFactory,这里可以完全取代mybatis.xml -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 数据源 -->
<property name="dataSource" ref="dataSource"/>
<!-- 加载mybatis配置文件 -->
<property name="configLocation" value="classpath:mybatis.xml"/>
</bean>
<!-- 配置mapper接口扫描 -->
<bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.jl.mapper"/>
</bean>
<!-- 事务管理器-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="find*" read-only="true"/>
<tx:method name="save*" read-only="false" rollback-for="Throwable"/>
<tx:method name="update*" read-only="false" rollback-for="Throwable"/>
<tx:method name="delete*" read-only="false" rollback-for="Throwable"/>
</tx:attributes>
</tx:advice>
<!-- 配置aop织入事务-->
<aop:config>
<aop:pointcut id="service" expression="execution(* com.jl.service..*.*(..))"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="service"/>
</aop:config>
</beans>
1.5 修改mybatis.xml
将Spring接管的部分,从mybatis.xml中删除
<?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核心配置文件-->
<configuration>
<!-- 配置别名-->
<typeAliases>
<package name="com.jl.domain"/>
</typeAliases>
<!-- 读取映射文件-->
<mappers>
<mapper resource="mappers/UsersMapper.xml"/>
</mappers>
</configuration>
1.6 运行测试
6、 事务的注解开发
1.1 修改applicationContext.xml
这里是以xml的形式配置事务管理,也可以开启事务的注解驱动
<!-- 配置事务管理器-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- 开启事务的注解驱动-->
<tx:annotation-driven transaction-manager="transactionManager"/>
1.2 service中添加事务控制
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Transactional(readOnly = true)
public List<User> findAll() {
return userMapper.findAll();
}
}
7、SqlSessionFactoryBean配置
SqlSessionFactoryBean的配置可以用来接管mybatis的核心配置文件中的部分配置,需要注入datasource。其它的配置可以继续由maybatis的核心配置文件负责,需要在sqlSessionFactoryBean中注入配置文件的路径即可。如下
<!-- 配置sqlsessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 注入dataSource-->
<property name="dataSource" ref="dataSource"/>
<property name="configLocation" value="classpath:mybatis.xml"/>
</bean>
也可以由sqlSessionFactory接管mybatis中的配置
<!-- 配置sqlsessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 注入dataSource-->
<property name="dataSource" ref="dataSource"/>
<!-- 配置别名扫描-->
<property name="typeAliasesPackage" value="com.icss.domain"/>
<!-- 加载mapper映射文件-->
<property name="mapperLocations" value="classpath:mappers/UserMapper.xml"/>
<!-- 如果mybatis核心配置文件中没有可用配置,可以加载,也可以不加载,不影响执行-->
<!-- <property name="configLocation" value="classpath:mybatis.xml"/>-->
</bean>