1.Mybatis是一个持久层框架。
2.Mybatis的前身是ibatis。
3.Mybatis可以基于xml或者注解。
一个最简单的Mybatis的例子:
1.导入jar包(Mybatis和Mysql的包)
2.准备好mysql数据库(我的是hibernate数据库的students表)
3.在src文件下添加配置文件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>
<!-- 对事务的管理和连接池的配置 -->
<!-- development :开发模式 -->
<!-- work:工作模式 -->
<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/hibernate" />
<property name="username" value="root" />
<property name="password" value="" />
</dataSource>
</environment>
</environments>
<!-- mapping 文件路径配置 -->
<!-- <mappers>
<mapper resource="com/yu/res/UserMapper.xml" />
</mappers> -->
</configuration>
4.建一个实体类Students
package com.zw.mybatis;
public class Students {
private int GENDER;
private String SNAME;
private int SID;
public int getGENDER() {
return GENDER;
}
public void setGENDER(int gENDER) {
GENDER = gENDER;
}
public String getSNAME() {
return SNAME;
}
public void setSNAME(String sNAME) {
SNAME = sNAME;
}
public int getSID() {
return SID;
}
public void setSID(int sID) {
SID = sID;
}
}
5.建一个映射文件studentsMapper.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.zw.mybatis.studentsMapper">
<select id="getUser" parameterType="int" resultType="com.zw.mybatis.Students">
select * from students where SID=#{SID}
</select>
</mapper>
6.在conf中注册Mapper
<mappers>
<mapper resource="com/zw/mybatis/studentsMapper.xml" />
</mappers>
7.写一个test类
package com.zw.mybatis;
import java.io.InputStream;
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) {
String resourse = "conf.xml";
InputStream is = Test.class.getClassLoader().getResourceAsStream(resourse);
SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(is);
SqlSession session=factory.openSession();
String Statement="com.zw.mybatis.studentsMapper.getUser";
Students students=session.selectOne(Statement, 1);
System.out.println(students.getSNAME());
}
}