mybatis-Spring 官网: http://www.mybatis.org/spring/zh/index.html
目录结构
1.配置meaven项目pom.xml
<dependencies>
<!--Spring依赖 https://mvnrepository.com/artifact/org.springframework/spring-context -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<!--AOP依赖 https://mvnrepository.com/artifact/org.springframework/spring-aop -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<!-- aspectjweaver:aop依赖的jar -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.9</version>
</dependency>
<!--JDBC依赖 https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- log4j:日志文件 -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!--Spring Web MVC https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.18.RELEASE</version>
</dependency>
<!--JSTL: https://mvnrepository.com/artifact/javax.servlet/jstl -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.2.8</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!--延时加载: https://mvnrepository.com/artifact/cglib/cglib -->
<dependency>
<groupId>cglib</groupId>
<artifactId>cglib</artifactId>
<version>2.2.2</version>
</dependency>
<!--mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
</dependencies>
配置mybatis配置文件
按顺序写入settings(延迟加载),typeAliases(别名),environments (数据库链接),mappers(映射器)
<?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">
<!-- dtd是约束xml文件 -->
<configuration>
<!-- 延迟加载 -->
<settings>
<setting name="lazyLoadingEnabled" value="true"/>
<setting name="aggressiveLazyLoading" value="false"/>
</settings>
<!-- 别名 -->
<typeAliases>
<typeAlias type="com.pb.entity.Student" alias="Student"/>
<typeAlias type="com.pb.entity.Classes" alias="Classes"/>
</typeAliases>
<!-- 数据库连接池 -->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql:///springjdbc"/>
<property name="username" value="root"/>
<property name="password" value="111"/>
</dataSource>
</environment>
</environments>
<!-- mapper映射器 使用mapper resource可设置多个文件记得是/不是打点. -->
<mappers>
<package name="com.pb.mapper"/>
</mappers>
<!-- mapper映射器写法2 自动根据mapper包内映射所有,免去了挨个挨个的血
<mappers>
<package name="com.pb.mapper"/>
</mappers>
-->
</configuration>
配置mapper文件
我们将声明2个mapper文件位列
StudentMapper.xml(xml配置文件) StudentMapper.java(接口文件)
ClassesMapper.xml(xml配置文件) ClassesMapper.java(接口文件)
<?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">
<!-- namespace:传入接口文件 -->
<mapper namespace="com.pb.mapper.StudentMapper">
<resultMap type="Student" id="StudentResultMapper">
<id column="id" property="id"/>
<result column="stuname" property="name"/>
<result column="age" property="age"/>
<result column="brithday" property="bd"/>
</resultMap>
<select id="selectAll" resultMap="StudentResultMapper">
select * from Student
</select>
<insert id="insertStudent" parameterType="student" >
insert into Student(stuname,age,brithday)values(#{name},#{age},now())
</insert>
</mapper>
ClassesMapper接口文件就不展示了,太华丽和StudentMapper接口一样的美丽,并且还没这个多(微笑)
public interface StudentMapper {
List<Student> selectAll();
void insertStudent(Student student);
}
<?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">
<!-- namespace:传入接口文件 -->
<mapper namespace="com.pb.mapper.ClassesMapper">
<resultMap type="Classes" id="ClassesResultMapper">
<id column="class_id" property="id"/>
<result column="class_name" property="name"/>
</resultMap>
<select id="selectAll" resultMap="ClassesResultMapper">
select * from class
</select>
</mapper>
将mybatis整合到spring中
创建Spring配置文件applicationContext.xml
applicationContext勾选context,aop,bean,tx
1.创建数据库连接池
2配置sqlSessionfactory 将数据库连接池和mybatis配置文件整合导入
3.配置类映射器的接口
5配置service(spring测试类getBean获取)
6配置事务管理器
<?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: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/aop http://www.springframework.org/schema/aop/spring-aop.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">
<!--1数据库连接池 负责链接数据库 -->
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName"
value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql:///springjdbc" />
<property name="username" value="root" />
<property name="password" value="111" />
</bean>
<!--2配置sqlSessionfactory 需要往对象引入dataSource(数据库连接池) -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
</bean>
<!--3配置Student类映射器的接口
property1:映射器对应的接口 (只修改value路径)
property2:sqlSessionfactory
<bean id="studentMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="com.pb.mapper.StudentMapper" />
<property name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
-->
<!--配置多个接口类映射器MapperScannerConfigure
只需填写所有映射器的包即可
name="basePackage"(不要动) value="com.pb.mapper"(映射的mapper的路径,多个可以用,分割)
-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.pb.mapper" />
</bean>
<!--5配置service
id开头一定要小写,一定要小写,一定要小写,一定要小写,一定要小写,一定要小写
ref="对应XXMapper.java接口类" 首字母一定要小写,一定要小写,一定要小写
这样使用MapperScannerConfigurer是因为将映射的mapper文件首字母小写进行识别
ref内一定是XXMapper同样的名字
-->
<bean id="studentService" class="com.pb.service.StudentServicelmpl">
<property name="studentMapper" ref="studentMapper" />
</bean>
<bean id="classesService" class="com.pb.service.ClassesServicelmpl">
<property name="classesMapper" ref="classesMapper" />
</bean>
<!-- 6配置事务管理器 -->
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<tx:advice id="txAdvice" transaction-manager="txManager">
<tx:attributes>
<tx:method name="insert*" propagation="REQUIRED"/>
<tx:method name="update*" propagation="REQUIRED"/>
<tx:method name="delete*" propagation="REQUIRED"/>
<!-- 其他命名方式不执行 -->
<tx:method name="*" propagation="SUPPORTS" read-only="true"/>
</tx:attributes>
</tx:advice>
<!-- 需要确定在什么操作下事务管理器起作用 expression="execution(* dao.*.*(..))"
针对dao方法执行事务
-->
<aop:config>
<aop:pointcut id="productServiceMethods" expression="execution(* com.pb.service.*.*(..))"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="productServiceMethods"/>
</aop:config>
</beans>
service+controller代码
说明一下调用的顺序:
StudentMapper(相当于dao层)<StudentService(Service内调用mapper层)<StudentController(servler内调用Service层)
public class StudentServicelmpl implements StudentService {
StudentMapper studentMapper;
public void setStudentMapper(StudentMapper studentMapper) {
this.studentMapper = studentMapper;
}
@Override
public List<Student> selectAll(){
return studentMapper.selectAll();
}
public void insertStudent(Student student) {
studentMapper.insertStudent(student);
}
}
public interface StudentService {
List<Student> selectAll();
void insertStudent(Student student);
}
public class ClassesServicelmpl implements ClassesService {
ClassesMapper classesMapper;
public void setClassesMapper(ClassesMapper classesMapper) {
this.classesMapper = classesMapper;
}
@Override
public List<Classes> selectAll() {
return classesMapper.selectAll();
}
}
public interface StudentService {
List<Student> selectAll();
void insertStudent(Student student);
}
controller代码
@Controller //在usermvc-servlet.xml内定义controller注解
public class StudentController {
StudentService studentService;
@Resource(name="studentService") //声明是哪个bean
public void setStudentService(StudentService studentService) {
this.studentService = studentService;
}
// @RequestMapping(value="index.do",method=RequestMethod.GET) 也可以进入 不区分get post
@RequestMapping("/index")
public String index(Model model) {
List<Student> students=studentService.selectAll();
model.addAttribute("students", students);
return "index";
}
@RequestMapping("/insert")
public String insert(Student stu,Model model) {
studentService.insertStudent(stu);
return "redirect:index.do";
}
}
@Controller
public class ClassesController {
ClassesService classesService;
@Resource(name="classesService")
public void setStudentService(ClassesService classesService) {
this.classesService = classesService;
}
@RequestMapping("/index2")
public String index2(Model model) {
List<Classes> classes=classesService.selectAll();
model.addAttribute("classesService",classes);
return "index";
}
}
配置usermvc-servlet.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/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
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">
<!-- 定义使用注解实现在StudentController中@Controller的位置 -->
<context:component-scan base-package="com.pb.controller"></context:component-scan>
<!-- 定义视图解析器
需要配置prefix前缀 suffix后缀
-->
<bean class="org.springframework.web.servlet.view.UrlBasedViewResolver" id="viewResolver">
<property value="org.springframework.web.servlet.view.JstlView" name="viewClass"/>
<property value="/" name="prefix"/>
<property value=".jsp" name="suffix"/>
</bean>
<!-- 7配置属性转换器 可在set内设置多个 -->
<bean id="conversionService"
class="org.springframework.context.support.ConversionServiceFactoryBean">
<property name="converters">
<set>
<bean class="com.pb.common.String2Date"></bean>
</set>
</property>
</bean>
<mvc:annotation-driven conversion-service="conversionService" />
</beans>
配置 web.xml
<!-- 配置xml -->
<servlet>
<servlet-name>usermvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<!-- 进入servlet的方式 -->
<servlet-mapping>
<servlet-name>usermvc</servlet-name>
<!-- 进入service方式 以.do结尾
还需在WEB-INFO下写一个XXX(servlet-name)-servlet.xml
是一个spring xml文件 需要勾选bean和context
-->
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<!-- 配置监听器整合Spring,SpringMVC
listener设置监听器
context-param监听位置 根目录使用ClassPath
-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
主要是在配置文件上小新同学比较容易范一些小错误,命名不规范,大小写不统一的问题
--------------注解实现service层+事务管理
1.serivce层替换
首先我们修改applicationContext.xml 声明context
<!--声明使用注解实现service的位置
<bean id="studentService" class="com.pb.service.StudentServicelmpl">
<property name="studentMapper" ref="studentMapper" />
</bean>
<bean id="classesService" class="com.pb.service.ClassesServicelmpl">
<property name="classesMapper" ref="classesMapper" />
</bean>
-->
<context:component-scan base-package="com.pb.service"></context:component-scan>
2 事务管理
修改applicationContext.xml 事务声明我们只需要这些
<!-- 6配置事务管理器
声明的事务管理对象是不能使用注解的
-->
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 把注解引入到这里或是说允许使用注解 并告诉他事务管理器是谁 -->
<tx:annotation-driven transaction-manager="txManager"/>
3.service层
@Service("studentService")//声明相当于id="studentService"
//@Controller servlet层
//@Component 其他层 (监听器\过滤器)
//@Repository dao层
@Transactional(propagation=Propagation.REQUIRED)//确定了切入点(默认所有事务开启),查询不需要单独声明关闭
public class StudentServicelmpl implements StudentService {
StudentMapper studentMapper;
@Resource(name="studentMapper")//相当于配置service的<property name="studentMapper" ref="studentMapper" />
public void setStudentMapper(StudentMapper studentMapper) {
this.studentMapper = studentMapper;
}
@Transactional(propagation=Propagation.SUPPORTS,readOnly=true)//关闭事务
public List<Student> selectAll(){
return studentMapper.selectAll();
}
public void insertStudent(Student student) {
studentMapper.insertStudent(student);
}
}