MyBatis简易教程_mybatis简易教程
MyBatis简易教程由刀豆文库小编整理，希望给你工作、学习、生活带来方便，猜你可能喜欢“mybatis简易教程”。
MyBatis简易教程
MyBatis+MySQL的，记录如下：
①数据库
在MySQL中，test数据库下，简历user表，一共两个字段id和name，建表语句略。
②需导入的包
只有两个：
mybatis-3.0.3.jar
mysql-connector-java-5.1.9-bin.jar（JDBC包）
③目录结构
采用最简单的结构，domain包下有且仅有四个文件
configuration.xml
User.xml
User.java
Test.java
④实体类javabean，总共两个变量
view plaincopy to clipboardprint?
package domain;public cla User {private int id;private String name = null;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;}@Overridepublic String toString(){return “User [id=” + id + “, name=” + name + “]”;}}
⑤MyBatis总配置文件configuration.xml
view plaincopy to clipboardprint?
“http://mybatis.org/dtd/mybatis-3-config.dtd”>
⑥User类的配置文件User.xml
view plaincopy to clipboardprint?
“-//mybatis.org//DTD Mapper 3.0//EN”
“http://mybatis.org/dtd/mybatis-3-mapper.dtd”>
select * from user where id = #{id}
]]-->
⑦测试用例
package domain;
import java.io.IOException;
import java.io.Reader;
import org.apache.ibatis.io.Resources; import org.apache.ibatis.seion.SqlSeion; import org.apache.ibatis.seion.SqlSeionFactory; import org.apache.ibatis.seion.SqlSeionFactoryBuilder; import domain.User;
public cla Test {
public static void main(String[] args)throws IOException {
String resource = “domain/configuration.xml”;Reader reader = Resources.getResourceAsReader(resource);SqlSeionFactory f = new SqlSeionFactoryBuilder().build(reader);SqlSeion seion = f.openSeion();try {
User user =(User)seion.selectOne(“selectUser”, “1”);System.out.println(user);} catch(Exception e){e.printStackTrace();} finally {
seion.close();
}
}
}
