整合Mybatis

时间：2023-08-12

第一步：导包

mysql mysql-connector-java 8.0.26 junit junit 4.13.2 test org.mybatis mybatis 3.5.7 org.projectlombok lombok 1.18.22

第二步：编写Mybatis工具类、实体类、接口

Mybatis工具类,获取SqlSession数据库操作对象

public class MybatisUtils { private static SqlSessionFactory sqlSessionFactory; static { try { //核心配置文件 String resource="mybatis-config.xml"; //读取 InputStream in = Resources.getResourceAsStream(resource); //创建工厂实例 sqlSessionFactory =new SqlSessionFactoryBuilder().build(in); } catch (IOException e) { e.printStackTrace(); } } //获取sqlsession对象 public static SqlSession getSqlSession(){ return sqlSessionFactory.openSession(true);//true设置自动提交事务 }}

实体类

@Data@NoArgsConstructor@AllArgsConstructor@ToStringpublic class User { private Integer id; private String uName; private Integer uAge; private String uGender; private String uPwd;}

接口

public interface UserMapper { //获取所有的用户对象 public List getListUser(); //通过id查询一个用户对象 public User getUser(int id); //增加一个用户 public int addUser(User user); //删除一个用户 public int delUser(int id); //修改一个用户 public int upDateUser(User user); //分页查询 public List getUserByLimit(Map map);}

第三步：配置*Mapper.xml文件（相当于接口实现类）

<?xml version="1.0" encoding="UTF-8" ?> select id , username , userage , gender , userPwd from mybatis.user where id=#{id} insert into mybatis.user values (#{id},#{uName},#{uAge},#{uGender},#{uPwd}) delete from mybatis.user where id=#{id} update mybatis.user set username=#{uName}, userage=#{uAge}, gender=#{uGender}, userPwd=#{uPwd} where id=#{id}