mybatis入门和配置

mybatis可以简化jdbc的操作，实现数据的持久化

mybatis.zip下载链接：https://github.com/mybatis/mybatis-3/releases

然后将mybatisjar包和mysqljar包导入

接下来在数据库中创建一张表

然后创建一个people实体类

public class People {
private int id;
private String name;
private int age;
public People(int id, String name, int age) {
	
	this.id = id;
	this.name = name;
	this.age = age;
}
public People() {
	
	
}
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;
}
public int getAge() {
	return age;
}
public void setAge(int age) {
	this.age = age;
}
@Override
public String toString() {
	return "People [id=" + id + ", name=" + name + ", age=" + age + "]";
}

}

接下来创建一个xml文件将表和对象映射起来(名字：peopleMapper.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.zhongxia.entity.peopleMapper">
 <select id="peopleid" resultType="com.zhongxia.entity.People" parameterType="int">
 select * from People where id = #{id}
 </select>
</mapper>

namespace中存放的是创建的peopleMapper xml的路径，resultType是返回值类型，id区分查那一个值，parameterType代表输入类型（id为int）

接下来在src中新建一个配置文件（mysql8.0版本配置，名字：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.cj.jdbc.Driver"/>
 <property name="url" value="jdbc:mysql://localhost:3306/suzy?useUnicode=true&amp;characterEncoding=utf-8&amp;serverTimezone=GMT&amp;useSSL=false"/>
 <property name="username" value="root"/>
 <property name="password" value="10086"/>
 </dataSource>
 </environment>
 </environments>
 <mappers>
 <mapper resource="com\zhongxia\entity\peopleMapper.xml"/>
 </mappers>
</configuration>

resource中存放的是映射xml的路径，注意mysql8.0 mybatis配置中URL和jdbc并不一样

最后新建一个测试类

import java.io.IOException;
import java.io.Reader;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class Test {

	public static void main(String[] args) throws IOException {
		//加载mybatis配置文件（为了访问数据库）
		Reader reader = Resources.getResourceAsReader("config.xml");
		SqlSessionFactory sessionFactory=new SqlSessionFactoryBuilder().build(reader);
		SqlSession session = sessionFactory.openSession();
		String statement="com.zhongxia.entity.peopleMapper.peopleid";
		People people=session.selectOne(statement,621);
		System.out.println(people);
		session.close();
	}

}

statement中存放的是映射xml（peopleMapper)的路径.它的id(peopleid)

向表中插入一条数据

然后在控制台看根据id的查询结果