MyBatis入门

官网入门教程网址(可翻译为中文奥):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.测试结果:



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值