1.MyBatis
曾用名:ibatis开始由apache开发
2010年,apache转给google colde,改名为MyBatis
2.作用
MyBatis可以简化JDBC操作,实现数据的持久化
3.ORM
ORM是一个概念:Object Relational Mapping,进行一个对象和表的映射
MyBatis是ORM的一个实现/Hibernate也是ORM的一个实现
person对象与person表映射
ORM可以是开发人员像操作对象一样操作数据库表
4.开发MyBatis程序步骤
配置MyBatis
conf.xml:配置数据库信息和需要加载的映射文件
映射文件xxxMapper.xml:增删改查标签(表——类)
测试类:session.selectOne(“需要查询的SQL的namespace.id”,“SQL的参数值”);
(1)conf.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="oracle.jdbc.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:ORCL" />
<property name="username" value="scott" />
<property name="password" value="tiger" />
</dataSource>
</environment>
</environments>
<mappers>
<!--加载映射文件-->
<mapper resource="nuc/hzb/entity/personMapper.xml" />
</mappers>
</configuration>
(2)Person.java
package nuc.hzb.entity;
public class Person {
private int id;
private String name;
private int age;
public Person() {}
public Person(int id, String name, int age) {
this.id = id;
this.name = name;
this.age = age;
}
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;
}
public String toString(){
return this.id + "," +this.name + "," + this.age;
}
}
(3)personMapper.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="nuc.hzb.entity.personMapper">
<select id="queryPersonById" resultType="nuc.hzb.entity.Person" parameterType="int">
select * from person where id = #{id}
</select>
</mapper>
(4)TestMyBatis.java
package nuc.hzb.test;
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;
import nuc.hzb.entity.Person;
public class TestMyBatis {
public static void main(String[] args) throws IOException {
// 加载MyBatis配置文件(为了访问数据库)
Reader reader = Resources.getResourceAsReader("conf.xml");
// SqlSessionFactory
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
// openSession()相当于之前的connection
SqlSession session = sessionFactory.openSession();
String statement = "nuc.hzb.entity.personMapper.queryPersonById";
Person person = session.selectOne(statement, 1);
System.out.println(person);
session.close();
}
}