官网入门教程网址(可翻译为中文奥):http://www.mybatis.org/mybatis-3/getting-started.html
下面通过一个例子来展示:
目录结构
1.下载及安装MyBatis
2.创建如下数据库user
3.编写mybatis配置文件:
mybatis-config.xml
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<!-- xml核心配置 -->
<configuration>
<!-- 日志的具体实现 -->
<settings>
<setting name="logImpl" value="LOG4J"/>
</settings>
<!-- 环境配置 -->
<environments default="mysql">
<environment id="mysql">
<!-- 指定事务回滚 -->
<transactionManager type="JDBC"></transactionManager>
<!-- 指数据源配置 -->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/user"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<!-- 告诉mybatis去哪里找映射文件 -->
<mappers>
<mapper resource="org/mapper/UserMapper.xml"/>
</mappers>
</configuration>
4.编写User类:
package org.domain;
public class User {
private String id;
private String name;
private String sex;
private int age;
public User( String name, String sex, int age) {
super();
this.name = name;
this.sex = sex;
this.age = age;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
}
5.编写UserMapper.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="org.mapper.UserMapper">
<insert id="save" parameterType="org.domain.User" useGeneratedKeys="true">
insert into user(name,sex,age) values(#{name},#{sex},#{age})
</insert>
</mapper>
6.编写主方法测试:
import java.io.IOException;
import java.io.InputStream;
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 org.domain.User;
/*
*/
public class MyBatisTest {
public static void main(String[] args) throws IOException {
//建立流,读取mybatis配置文件
InputStream inputStream=Resources.getResourceAsStream("mybatis-config.xml");
//初始化Mybatis,创建SqlSessionfactory
SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(inputStream);
//创建Session实例
SqlSession session=factory.openSession();
//创建User对象
User user=new User("chaokaidi","男",23);
//插入数据
session.insert("org.mapper.UserMapper.save", user);
//提交事务
session.commit();
//关闭Session
session.close();
}
}
7.测试结果: