Mybatis 环境搭建及测试(新手)
1. 环境搭建
- 数据库建表,填充内容(insert into user() values();)
USE mybatis
CREATE TABLE USER(
id INT(100) PRIMARY KEY,
NAME VARCHAR(100),
pwd VARCHAR(100)
)ENGINE=INNODB;
2. 导入Mybatis
- maven引入依赖(mybatis、mysql、junit)
<dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.3</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.22</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency>
- 基本配置(见Mybatis官方文档mybatis – MyBatis 3 | 入门)
- resource目录下 db.properties 存放连接数据库得信息,mybatis-config.xml 是mybatis核心配置文件
db.properties (url中设置时区、安全连接、编码)
driver=com.mysql.cj.jdbc.Driver url=jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useSSL=true&useUnicode=true&characterEncoding=UTF-8 username=name password=******
- mybatis-config.xml 中配置信息:注意 Mapper 注册( 每一个mapper文件都要在配置文件中绑定)!!!
class 绑定 Mapper.class,可以同时绑定 xml 文件和 java 接口文件
resource 绑定 Mapper.java文件,路径使用 / 隔开。
<?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> <!-- 数据库配置文件--> <properties resource="db.properties"/> <!-- 日志选择--> <settings> <!-- <setting name="logImpl" value="STDOUT_LOGGING"/>--> <setting name="logImpl" value="STDOUT_LOGGING"/> </settings> <!-- 别名--> <typeAliases> <package name="com.song.pojo"/> </typeAliases> <!-- 环境--> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/> </dataSource> </environment> </environments> <!-- class 绑定 Mapper.class,可以同时绑定 xml 文件和 java 接口文件 resource 绑定 Mapper.java文件,路径使用 / 隔开。 --> <mappers> <!-- <mapper resource="com/song/dao/XXXMapper.java"/>--> <mapper class="com.song.dao.TeacherMapper"/> <mapper class="com.song.dao.StudentMapper"/> </mappers> </configuration>
3. 编写代码(工具类、实体类、Mapper)
- 工具类
public class MybatisUtil { 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(); } }
- 加载资源文件
- 通过 SqlSessionFactoryBuilder.build() 方法生成 sqlSessionFactory
- sqlSessionFactory.openSession() 得到 sqlSession(openSession() 可以传参数 true 设置为自动提交事务,但不推荐)
-
实体类
1.接口与Mapper在同一个包下
2.Mapper在resource目录下,但包名要保持一致,保证其目录可展开
- Mapper
- query: <select ... select * from TABLE where ...
- insert: <insert ... insert into TABLE(K,K,K) values(V,V,V)
- delete: <delete ... delete from TABLE where ...
- update: <update ... update TABLE set k=v, k=v k=v where ...
- 多对一:resultMap + association
- 一对多:resultMap + collection
<?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="com.song.dao.TeacherMapper"> <insert id="insert" parameterType="Teacher"> insert into teacher() values(#{id}, #{name}) </insert> <!-- @Param("tid")--> <select id="query" resultType="Teacher"> select * from teacher where id=#{tid} </select> <select id="getTeacherInfo" resultMap="TeacherStudent"> select t.id tid, t.name tname, s.name sname, s.id sid from teacher t, student s where t.id=s.tid and t.id=#{tid} </select> <resultMap id="TeacherStudent" type="Teacher"> <result property="id" column="tid"/> <result property="name" column="tname"/> <collection property="students" ofType="Student"> <result property="name" column="sname"/> <result property="id" column="sid"/> </collection> </resultMap> </mapper>
4. 测试
- 测试类编写
@Test public void testTeacher(){ SqlSession sqlSession = MybatisUtil.getSqlSession(); TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class); Teacher teacherInfo = mapper.getTeacherInfo(1); System.out.println(teacherInfo); sqlSession.close(); }