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------------"); } }