文档链接:http://mybatis.org/spring/zh/index.html
环境准备:
导入依赖:
junit junit 4.13.2 mysql mysql-connector-java 8.0.28 org.mybatis mybatis 3.5.2 org.springframework spring-webmvc 5.3.15 org.springframework spring-jdbc 5.3.15 org.aspectj aspectjweaver 1.9.5 org.mybatis mybatis-spring 2.0.2 org.projectlombok lombok 1.18.22
注意点:
mybtis去创建sqlSessionFactory代码:
package com.mybatis.study.util;
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 java.io.InputStream;
public class MybatisUtils {
private static SqlSessionFactory sqlSessionFactory;
static {
try {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
} catch (Exception e) {
e.printStackTrace();
}
}
public static SqlSession getSqlSession(){
return sqlSessionFactory.openSession(true);
}
}
mybatis-spring创建sqlSessionFactory代码:
实现类
package com.spring.study.dao;
import com.spring.study.bean.User;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import java.util.List;
public class UserMapperImpl extends SqlSessionDaoSupport implements UserMapper {
//我们的所有操作都使用sqlSession来执行,在原来,现在都使用sqlSessionTemplate;
public List selectUser() {
User user = new User(11, "校长", "111111", "11111");
UserMapper mapper = getSqlSession().getMapper(UserMapper.class);
mapper.addUser(user);
mapper.deleteUser(11);
return mapper.selectUser();
}
public int addUser(User user) {
return getSqlSession().getMapper(UserMapper.class).addUser(user);
}
public int deleteUser(int id) {
return getSqlSession().getMapper(UserMapper.class).deleteUser(id);
}
}



