1编写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/mysql?useSSL=true&useUnicode=true&characterEncoding=UTF-8"/> <property name="username" value="root"/> <property name="password" value="193792"/> </dataSource> </environment> </environments> </configuration>
Mybaits链接代码:
package utlis; 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 MybaitsTool { private static SqlSessionFactory sqlSessionFactory; static { // 获取SqlSessionFactory对象 try { String resource = "org/mybatis/example/mybatis-config.xml"; InputStream inputStream = null; SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); inputStream = Resources.getResourceAsStream(resource); } catch (IOException e) { e.printStackTrace(); } } public static SqlSession getSqlSession() { return sqlSessionFactory.openSession(); } }
实体类:
package pojo; public class Teacher { int id; String name; public Teacher() { } public Teacher(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; } }
Dao接口:
package Dao; import pojo.Teacher; import java.util.List; public interface TeacherDao { List<Teacher> getTeacherList(); }
接口实现类:
<?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="main.java.Dao.TeacherDao"> <select id="getTeacherList" resultType="main.java.pojo.Teacher"> select * from mysql.teacher </select> </mapper>
测试:
junit测试: