Mybatis开发

一、环境搭建

  1、从官网下载jar包https://github.com/mybatis/

  2、新建java工程，导入jar包

  

二、操作步骤

  1、建立实体

public class Users {
	
	private String username;
	private String pwd;
	private int id;
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
	public Users(String username, String pwd) {
		super();
		this.username = username;
		this.pwd = pwd;
	}
	public Users() {
		super();
		// TODO Auto-generated constructor stub
	}
	public Users(String username, String pwd, int id) {
		super();
		this.username = username;
		this.pwd = pwd;
		this.id = id;
	}
	
	

}

2、建立接口

package org.lanqiao.exam.mapper;

import org.lanqiao.exam.pojo.Users;

public interface UserMapper {
	int insert(Users u);
	void delete(String username);
}

3、建立映射文件

<?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.lanqiao.exam.mapper.UserMapper">

<insert id="insert" parameterType="Users">
  INSERT INTO users(username,pwd)VALUES(#{username},#{pwd})
</insert>

<delete id="delete" parameterType="string">
   DELETE FROM users WHERE username=#{username}
</delete>

</mapper>

4、建立配置文件

<?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>
  <typeAliases>
    <typeAlias type="org.lanqiao.exam.pojo.Users" alias="Users"/>   //实体别名
  </typeAliases>

  <environments default="abc">
     <environment id="abc">
       <transactionManager type="JDBC"/>
       <dataSource type="POOLED">
         <property name="driver" value="com.mysql.jdbc.Driver"/>
         <property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
         <property name="username" value="root"/>
         <property name="password" value="admin"/>
       </dataSource> 
     </environment>
  </environments>


  <mappers>
    <mapper resource="org/lanqiao/exam/pojo/UserMapper.xml"/>  //映射文件
  </mappers>
  
</configuration>

5、JUnit测试

package org.lanqiao.exam;

import static org.junit.Assert.*;

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 org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.lanqiao.exam.mapper.UserMapper;
import org.lanqiao.exam.pojo.Users;

public class CTest {
	SqlSessionFactory factory=null;
	Users u=null;

	@Before
	public void setUp() throws Exception {//初始化
		Reader reader=Resources.getResourceAsReader("org/lanqiao/exam/config/mybatis-config.xml");
		factory=new SqlSessionFactoryBuilder().build(reader); 
		
		u=new Users("祝枝山","345");
	}

	@After
	public void tearDown() throws Exception {//释放资源
		factory=null;
	}

	@Test
	public void insert() {
		SqlSession session = factory.openSession();
		//得到映射器
		UserMapper mapper=session.getMapper(UserMapper.class);//??????????
		try{
			int row=mapper.insert(u);
			session.commit();
			
			assertTrue("插入成功", 1==row);
		}finally{
			session.close();
		}
	}
	
	@Test
	public void delete() {
		System.out.println("-------------1------------");
	}
	
}