Mybatis中的常用代码
MybatisUtils工具类
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 (IOException e){
e.printStackTrace();
}
}
public static SqlSession getSqlSession(){
return sqlSessionFactory.openSession();
}
}
在应用中直接MybatisUtils.getSqlSession()来获取sqlSession对象
在idea中新建一个mybatis-config.xml模板
<?xml version="1.0" encoding="UTF8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--configuration核心配置文件-->
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&serverTimezone=UTC&characterEncoding=utf-8"/>
<property name="username" value="root"/>
<property name="password" value="071729"/>
</dataSource>
</environment>
</environments>
<!--每一个mapper.xml都需要在Mybatis核心配置文件中注册-->
<mappers>
<mapper resource="com/zhizhi/dao/UserMapper.xml"/>
</mappers>
</configuration>
可以把mapper标签内用name标签直接引入包名。在包内的所有mapper文件全部一次性获取
在pom.xml文件中添加resource
<build>
<resources>
<resource>
<!--将项目的src/main/resources目录下的所有文件都作为项目的资源文件
项目打包的时候也会打包进去
-->
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
<resource>
<!--将src/main/java目录下的所有xml文件都作为项目的资源文件,
项目打包的时候也会打包进去
-->
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>
</build>