文件結(jié)構(gòu)
Paste_Image.png
2.1基于XML的增孟辑、刪、改告希、查
2.1.1定義sql映射文件
<?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="com.config.userMapper">
<!-- 根據(jù)id得到一個user對象 -->
<!-- 參數(shù)類型:parameterType resultType:結(jié)果集類型(全類名)-->
<select id="getUser" parameterType="int"
resultType="com.entity.User">
select * from user where id=#{id}
</select>
<!-- 插入操作 -->
<insert id="addUser" parameterType="com.entity.User">
insert into user(name,age) values(#{name},#{age})
</insert>
<!-- 刪除操作 -->
<delete id="deleteUser" parameterType="int">
delete from user where id=#{id}
</delete>
<!-- 更新操作 -->
<update id="updateUser" parameterType="com.entity.User">
update user set name=#{name},age=#{age} where id=#{id}
</update>
<!-- 查詢所有 -->
<select id="getAllUsers" resultType="com.entity.User">
select * from user
</select>
</mapper>
2.1.2在config.xml文件中注冊這個映射文件
<mappers>
<mapper resource="com/config/userMapper.xml"/>
</mappers>
2.1.3定義一個MybatisUtil類扑浸,主要用于獲取SqlSession
package com.util;
import java.io.IOException;
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;
public class MybatisUtil {
public static SqlSession getSession() throws IOException
{
String resource = "config.xml";
//加載 mybatis 的配置文件(它也加載關(guān)聯(lián)的映射文件)
Reader reader = Resources.getResourceAsReader(resource);
//構(gòu)建 sqlSession 的工廠
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
//openSession的參數(shù)設(shè)置為true表示自動提交
SqlSession session=sessionFactory.openSession(true);
return session;
}
}
2.1.4定義相應(yīng)的測試方法
package com.test;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
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.Test;
import com.entity.User;
import com.util.MybatisUtil;
public class Test1 {
@Test
public void getUser() throws IOException
{
String resource = "config.xml";
//加載 mybatis 的配置文件(它也加載關(guān)聯(lián)的映射文件)
Reader reader = Resources.getResourceAsReader(resource);
//構(gòu)建 sqlSession 的工廠
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
//創(chuàng)建能執(zhí)行映射文件中 sql 的 sqlSession
SqlSession session = sessionFactory.openSession();
//映射 sql 的標(biāo)識字符串
String statement = "com.config.userMapper.getUser";
//執(zhí)行查詢返回一個唯一 user 對象的 sql
User user = session.selectOne(statement, 15);
session.close();
System.out.println(user);
}
//測試插入
@Test
public void addUser() throws IOException
{
SqlSession session=MybatisUtil.getSession();
String statement="com.config.userMapper.addUser";
//insert表示有幾天記錄發(fā)生了變化
int insert=session.insert(statement, new User(-1,"王五",29));
session.close();
System.out.println(insert);
}
//測試刪除
@Test
public void deleteUser() throws IOException
{
SqlSession session=MybatisUtil.getSession();
String statement="com.config.userMapper.deleteUser";
int delete=session.delete(statement, 15);
session.close();
System.out.println(delete);
}
//測試更新
@Test
public void updateUser() throws IOException
{
SqlSession session=MybatisUtil.getSession();
String statement="com.config.userMapper.updateUser";
int update=session.update(statement, new User(16,"馬六",34));
session.close();
System.out.println(update);
}
//測試獲得整個表
@Test
public void getAllUsers() throws IOException
{
SqlSession session=MybatisUtil.getSession();
String statement="com.config.userMapper.getAllUsers";
List<User> list=session.selectList(statement);
for(User user:list)
{
System.out.println(user);
}
session.close();
}
}
2.2基于注解的增、刪燕偶、改喝噪、查
2.2.1定義sql映射接口
package com.inter;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import com.entity.User;
public interface UserMapper {
@Insert("insert into user(name,age) values(#{name},#{age})")
public int add(User user);
@Delete("delete from user where id=#{id}")
public int deleteById(int id);
@Update("update user set name=#{name},age=#{age} where id=#{id}")
public int update(User user);
@Select("select * from user where id=#{id}")
public User getById(int id);
@Select("select * from user")
public List<User> getAll();
}
2.2.2在config.xml中注冊這個映射接口
<mappers>
<mapper class="com.inter.UserMapper"/>
</mappers>
2.2.3編寫測試方法
package com.test;
import java.io.IOException;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.Test;
import com.entity.User;
import com.inter.UserMapper;
import com.util.MybatisUtil;
public class Test2 {
//測試添加
@Test
public void testAdd() throws IOException
{
SqlSession session=MybatisUtil.getSession();
UserMapper mapper=session.getMapper(UserMapper.class);
int add=mapper.add(new User(-1,"王五",12));
session.close();
System.out.println(add);
}
//測試刪除
@Test
public void testDelete() throws IOException
{
SqlSession session=MybatisUtil.getSession();
UserMapper mapper=session.getMapper(UserMapper.class);
int delete=mapper.deleteById(17);
session.close();
System.out.println(delete);
}
//測試更新
@Test
public void testUpdate() throws IOException
{
SqlSession session=MybatisUtil.getSession();
UserMapper mapper=session.getMapper(UserMapper.class);
int update=mapper.update(new User(16,"王五",17));
session.close();
System.out.println(update);
}
//測試查詢
@Test
public void testGetUsers() throws IOException
{
SqlSession session=MybatisUtil.getSession();
UserMapper mapper=session.getMapper(UserMapper.class);
List<User> list=mapper.getAll();
for(User user:list)
{
System.out.println(user);
}
session.close();
}
}