Mybatis

1:pom.xml中导入坐标

  mysql
  mysql-connector-java
  8.0.25


  org.mybatis
  mybatis
  3.3.0



2：创建UsersMapper.xml映射文件

<?xml version="1.0" encoding="UTF-8"?>




    
        select * from users
    

    
        insert into users values(#{id},#{name},#{password},#{email},#{birthday})
    

    
        update  users set  password=#{password} where id = #{id}
    

    
        delete from users where id = #{id}
    


3：创建sqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8"?>



    
        
        
            
            
            
            
                
                
                
                
                
            
        
    

    
    
        
        
    



4查询所有

//获取核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
//获取session工厂对象
SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获取session会话对象
SqlSession sqlSession = build.openSession();
//执行操作，参数，namespace+id
List usersList = sqlSession.selectList("UsersMapper.findAll");
//打印数据
System.out.println(usersList);
//释放资源
sqlSession.close();

5修改

//2:插入操作
//模拟Users对象
Users users = new Users();
users.setId(7);
users.setPassword("55555");
//获取核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
//获取session工厂对象
SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获取session会话对象
SqlSession sqlSession = build.openSession();
sqlSession.insert("UsersMapper.update",users);
//提交事务
sqlSession.commit();
//释放资源
sqlSession.close();

6：添加

//2:插入操作
//模拟Users对象
Users users = new Users();
users.setName("tom");
users.setPassword("6666222");
users.setEmail("Tom@qq.com");
users.setBirthday("1907-7-9");
//获取核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
//获取session工厂对象
SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获取session会话对象
SqlSession sqlSession = build.openSession();
sqlSession.insert("UsersMapper.save",users);
//提交事务
sqlSession.commit();
//释放资源
sqlSession.close();

7：删除

//获取核心配置文件
InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
//获取session工厂对象
SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream);
//获取session会话对象
SqlSession sqlSession = build.openSession();
sqlSession.delete("UsersMapper.delete",7);
//提交事务
sqlSession.commit();
//释放资源
sqlSession.close();