1、导入jar包
2、目录结构
3.主配置文件 sqlMapConfig.xml
4.映射文件 PersonMapper.xml
5.工具 SqlSessionFactoryUtil.java
6.测试类
package com.hrxb.test;
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.junit.Test;
import com.hrxb.entity.Person;
import com.hrxb.utils.SqlSessionFactoryUtil;
public class PersonTest {
@Test
public void testUpdate(){
SqlSession sqlSession = SqlSessionFactoryUtil.getSqlSessionFactory().openSession();
//先查询出要修改的对象
Person person = sqlSession.selectOne("person.selectById", 1);
person.setAddress("大森林");
sqlSession.update("person.updateById", person);
sqlSession.commit();
sqlSession.close();
}
@Test
public void testDelete(){
SqlSession sqlSession = SqlSessionFactoryUtil.getSqlSessionFactory().openSession();
sqlSession.delete("person.deleteById", 3);
sqlSession.commit();
sqlSession.close();
}
@Test
public void testInsert(){
SqlSession sqlSession = SqlSessionFactoryUtil.getSqlSessionFactory().openSession();
Person p = new Person();
p.setUsername("光头强");
p.setSex("男");
p.setAge(21);
p.setAddress("大森林");
sqlSession.insert("person.insert", p);
sqlSession.commit();
sqlSession.close();
}
@Test
public void testSelect2(){
SqlSession sqlSession = SqlSessionFactoryUtil.getSqlSessionFactory().openSession();
Person person = sqlSession.selectOne("person.selectById", "2");
System.out.println(person);
sqlSession.close();
}
@Test
public void testSelect() throws IOException{
String resource ="sqlMapConfig.xml";
try {
//读取配置文件
InputStream inputStream = Resources.getResourceAsStream(resource);
//构建sqlSessionFactory
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
//从工厂中获取sqlSession
SqlSession session = sqlSessionFactory.openSession();
Person person = session.selectOne("person.selectById", 1);
System.out.println(person);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
注意:
传统的开发模式: