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> <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://localhost:3306/mydb?useSSL=true&userUnicode=true&characterEncoding=UTF-8"/> <property name="username" value="mydb"/> <property name="password" value="123456"/> </dataSource> </environment> </environments> <mappers> <mapper resource="com/xiaoxiangzi/dao/UserMapper.xml"/> </mappers> </configuration>
UserMapper.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="com.xiaoxiangzi.dao.UserDao"> <select id="getUserList" resultType="com.xiaoxiangzi.pojo.User"> select * from mydb.user </select> </mapper>
UserDao.java
import com.xiaoxiangzi.pojo.User; import java.util.List; /** * @Author: ZhaoLiang * @CreateDate: 2021/3/4 11:11 */ public interface UserDao { List<User> getUserList(); }
User实体类
public class User { private int id; private String name; public User() { } public User(int id, String name) { this.id = id; this.name = name; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } }
工具类
package com.xiaoxiangzi.utils; 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.IOException; import java.io.InputStream; public class MyUtils { 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(); } }
Test
package com.xiaoxiangzi.dao; import com.xiaoxiangzi.pojo.User; import com.xiaoxiangzi.utils.MyUtils; import org.apache.ibatis.session.SqlSession; import org.junit.Test; import java.util.List; public class UserDaoTest { @Test public void test(){ SqlSession sqlsession = MyUtils.getSqlsession(); UserDao mapper = sqlsession.getMapper(UserDao.class); List<User> userList = mapper.getUserList(); for (User user:userList){ System.out.println(user.getName()); } sqlsession.close(); } }