[学习记录-SSM]Spring整合Mybatis 以及遇到的坑

最新推荐文章于 2022-08-15 02:46:36 发布

眸笑丶

最新推荐文章于 2022-08-15 02:46:36 发布

阅读量343

点赞数

分类专栏：学习记录 spring

本文链接：https://blog.csdn.net/baozi141990/article/details/102947963

版权

学习记录同时被 2 个专栏收录

22 篇文章 0 订阅

订阅专栏

spring

4 篇文章 0 订阅

订阅专栏

Spring和Mybatis整合实例

导入jar包

在这里插入图片描述
主要jar包mybatis-spring-1.3.1.jar，没有可取官网下载
其他jar包下载地址
spring mvc的jar包下载：http://repo.springsource.org/libs-release-local/org/springframework/spring/
commons-fileupload-1.3.3.jar：http://commons.apache.org/proper/commons-fileupload/
commons-io-2.6：http://commons.apache.org/proper/commons-io/
Apache log4j 2：http://logging.apache.org/log4j/2.x/download.html
mybatis：http://www.mybatis.org/mybatis-3/
mysql-connector-java.jar：http://mvnrepository.com/artifact/mysql/mysql-connector-java
jstl-1.2.jar：http://mvnrepository.com/artifact/javax.servlet/jstl
aspectjweaver-1.8.10.jar：http://mvnrepository.com/artifact/org.aspectj/aspectjweaver

jackson相关包
jackson-annotations-2.8.0.jar：http://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-annotations
jackson-core-2.8.1.jar：http://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-core
jackson-databind-2.8.5.jar：http://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind

数据库配置文件jdbc.properties

database.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull
database.username=root
database.password=root
database.driverClassName=com.mysql.jdbc.Driver

Mybatis的配置

创建实体类User

package com.org.entity;

public class User {
	private Integer id;
	private String name;
	private String password;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", password=" + password + "]";
	}
}

映射文件User.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="user">
	<select id="findUser" resultType="User">
		select * from user
	</select>
	<insert id="insertUser" parameterType="User">
		insert into user
		(name,password) values (#{name},#{password})
	</insert>
	<update id="updateUser" parameterType="User">
		update user set name = #{name} ,password = #{password} where id = #{id}
	</update>
	
	<delete id="deleteUser" parameterType="_int">
			delete  from user where id = #{id}
	</delete>
	
</mapper>

Mybatis配置文件Mybatis-config.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>
	  <!-- settings -->
    <settings>
        <!-- 打开延迟加载的开关 -->
        <setting name="lazyLoadingEnabled" value="true"/>
        <!-- 将积极加载改为消极加载（即按需加载） -->
        <setting name="aggressiveLazyLoading" value="false"/>
        <!-- 打开全局缓存开关（二级缓存）默认值就是 true -->
        <setting name="cacheEnabled" value="true"/>
    </settings>
	
	<typeAliases>
		<package name="com.org.entity" />
	</typeAliases>
	
	<mappers>
		<mapper resource="com/org/entity/User.xml" />
		 <!-- 批量加载mapper,如果没有代理可以不用写 -->
        <package name="com.org,Mapper"/>
	</mappers>
	
</configuration>

创建Dao以及DaoImpl

TestDao.java

package com.org.dao;

import java.util.List;
import com.org.entity.User;

public interface TestDao {
	List<User> findUser() ;
	void updateUser(User user) ;
	void insertUser(User user);
	void deleteUserById(Integer id);
}

TestDaoImpl.java

package com.org.dao.impl;

import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.mybatis.spring.support.SqlSessionDaoSupport;

import com.org.dao.TestDao;
import com.org.entity.User;
import com.org.utils.MyBasisUtils;

public class TestDaoImpl extends SqlSessionDaoSupport implements TestDao {
//	@Test

	@Override
	public void insertUser(User user) {
		SqlSession session = this.getSqlSession();
		session.insert("user.insertUser", user);
		session.commit();
		session.close();

	}

	@Override
	public void updateUser(User user) {
		SqlSession session = this.getSqlSession();
		session.delete("user.updateUser", user);
		session.commit();
		session.close();
	}

	@Override
	public List<User> findUser() {
//		SqlSession session = MyBasisUtils.openSession();
		SqlSession session = this.getSqlSession();
		List<User> userList = session.selectList("user.findUser");
		return userList;
	}

	@Override
	public void deleteUserById(Integer id) {
		// TODO Auto-generated method stub
		SqlSession session = this.getSqlSession();
		session.delete("user.deleteUser", id);
		session.commit();
		session.close();
	}
}

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:property-placeholder
		location="classpath:jdbc.properties" />

	<!-- 配置数据源 -->
	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName"
			value="${database.driverClassName}" />
		<property name="url" value="${database.url}" />
		<property name="username" value="${database.username}" />
		<property name="password" value="${database.password}" />
	</bean>

	<!-- sqlSessionFactory -->
	<bean id="sqlSessionFactory"
		class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 加载 MyBatis 的配置文件 -->
		<property name="configLocation" value="mybatis-config.xml" />
		<!-- 数据源 -->
		<property name="dataSource" ref="dataSource" />
	</bean>
	<bean id="testDao" class="com.org.dao.impl.TestDaoImpl">
		<property name="sqlSessionFactory" ref="sqlSessionFactory" />
	</bean>
</beans>

测试类Test

package com.org.test;

import java.util.List;

import org.junit.Before;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.org.dao.TestDao;
import com.org.dao.impl.TestDaoImpl;
import com.org.entity.User;

public class Test01 {

	private ApplicationContext applicationContext;

	// 在执行测试方法之前首先获取 Spring 配置文件对象
	// 注解@Before在执行本类所有测试方法之前先调用这个方法
	@Before
	public void setup() throws Exception {
		applicationContext = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
	}

	@Test
	public void testFindUserById() throws Exception {
		// 通过配置资源对象获取 userDAO 对象
		TestDao testDao = (TestDao) applicationContext.getBean("testDao");
		// 调用 UserDAO 的方法
		List<User> findUser = testDao.findUser();
		// 输出用户信息
		for (User user : findUser) {
			System.out.println(user);
		}
	}

}

遇到的问题

报错

java.lang.AbstractMethodError: org.mybatis.spring.transaction.SpringManagedTransaction.getTimeout()Ljava/lang/Integer;
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:135)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)
	at com.sun.proxy.$Proxy5.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:197)
	at com.org.dao.impl.TestDaoImpl.findUser(TestDaoImpl.java:36)
	at com.org.test.Test01.testFindUserById(Test01.java:39)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:541)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:763)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:463)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:209)

原因：mybat-spring jar包版本不兼容，使用更高版本即可