2.sql语句和接口实现跳转
(1)UserMapper.xml 编写增删改查的sql语句
标签的namespace要绑定接口的全限定类名才行
cn.kgc.mybatis.mapper.UserMapper
(2).UserMapper接口
package cn.kgc.mybatis.mapper;
import cn.kgc.mybatis.entity.User;
import java.util.List;
public interface UserMapper {
// 查询所有
List selectAll();
// 根据id查询一个
User selectOne(Integer id);
// 修改教师信息
Integer updateOne(User user);
// 添加教师信息
Integer addOne(User user);
// 根据id删除教师信息
Integer deleteOne(Integer id);
}
3、实体类
User
package cn.kgc.mybatis.entity;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
@AllArgsConstructor
@NoArgsConstructor
@Data
@Builder
public class User {
private Integer id;
private String name;
private Integer age;
}
4、测试类代码
package cn.kgc.test;
import cn.kgc.mybatis.entity.User;
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.Before;
import org.junit.Test;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class UserTest {
private SqlSessionFactory factory;
@Before
public void init() {
try {
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();
// 查询数据列表
List users = sqlSession.selectList("cn.kgc.mybatis.mapper.UserMapper.selectAll");
// 遍历集合
users.forEach(user -> System.out.println("user = " + user));
}
// 根据id查询一个用户信息
@Test
public void selectOne(){
SqlSession sqlSession = factory.openSession();
// String , Object
User user = sqlSession.selectOne("user.selectOne", 1);
System.out.println("user = " + user);
}
// 添加一个用户信息
@Test
public void addOne(){
SqlSession sqlSession = factory.openSession();
// 创建一个教室对象
User user = new User(8, "赵亮", 22);
int insert = sqlSession.insert("user.addOne", user);
// 增删改 jdbc默认不会提交事务
sqlSession.commit();
System.out.println(insert > 0 ? "true" : "false");
}
// 删除一个用户
@Test
public void deleteOne(){
SqlSession sqlSession = factory.openSession();
int delete = sqlSession.delete("user.deleteOne", 1);
sqlSession.commit();
System.out.println(delete > 0 ? "true" : "false");
}
// 修改一个记录
@Test
public void updateOne(){
SqlSession sqlSession = factory.openSession();
int update = sqlSession.update("user.updateOne", 2);
sqlSession.commit();
System.out.println(update > 0 ? "true" : "false");
}
}
以上是mybatis初学者第一天的内容



