1.maven工程引入依赖:
org.mybatis mybatisx.x.x
2.新建一个mybatis-config.xml文件,内容如下:
//通过“development”选择需要连接的数据库 //映射文件配置//id->区分不同的数据库 //数据库连接池 //驱动 //数据库的账号密码
3.新建一个TeacherMapper.xml文件,在该文件内书写SQL语句
4.新建实体类Teacher.class
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class Teacher {
private String teaName;
private Integer id;
private String profession;
}
5.创建接口文件TeacherMapper.java
public interface TeacherMapper {
List selectAll();
Teacher selectOne(Integer id);
Integer updateOne(Teacher teacher);
Integer addOne(Teacher teacher);
Integer deleteOne(Integer id);
}
6.创建TestTeacherMapper.java文件
public class TestTeacherMapper {
private SqlSessionFactory factory;
@Before
public void init(){
try {
//加载mybatis的配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("config/mybatis-config.xml");
factory = new SqlSessionFactoryBuilder().build(resourceAsStream);
} catch (IOException e) {
e.printStackTrace();
}
}
@Test
public void selectAll(){
//sql会话对象 执行数据的crud操作
SqlSession sqlSession = factory.openSession();
//通过sqlSession获取teacherMapper的代理对象 类似之前使用的接口类实现对象 org.apache.ibatis.binding.MapperProxy@1c3a4799
TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
List teachers = mapper.selectAll();
for (Teacher teacher:teachers){
System.out.println("teacher = " + teacher);
}
}
@Test
public void selectOne(){
SqlSession sqlSession = factory.openSession();
TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
Teacher teacher = mapper.selectOne(1);
System.out.println("teacher = " + teacher);
}
@Test
public void addOne(){
SqlSession sqlSession = factory.openSession();
TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
Teacher teacher = new Teacher("jack", 20, "sdsdsdsdds");
Integer integer = mapper.addOne(teacher);
sqlSession.commit();
System.out.println(integer>0?"true":"false");
}
@Test
public void updateOne(){
SqlSession sqlSession = factory.openSession();
TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
Teacher teacher = new Teacher("jason", 20, "sdsdsdsdds");
Integer integer = mapper.updateOne(teacher);
sqlSession.commit();
System.out.println(integer>0?"true":"false");
}
}



