mybaties实现增删改查

说一下有关mybatis操作数据库实现增删盖查的步骤：

*编写接口

*编写对应映射文件中mapper

*编写测试类
　1.select语句：选择，查询数据
　　1.1 查询User表中所有信息
　　代码如下：

package dao;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import pojo.User;
import utils.MybatisUtils;

import java.util.List;

public class UserText {
    @Test
    public void test(){
      SqlSession sqlSession= MybatisUtils.getSqlSession();
      UserDao mapper=sqlSession.getMapper(UserDao.class);
      List<User> userList=mapper.getUserList();
      for(User user:userList)
      {
          System.out.println(user);
      }
      sqlSession.close();
    }
}
1.2 查询User表满足条件的数据


package dao;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import pojo.User;
import utils.MybatisUtils;

public class UserFind {
    @Test
    public void getUserById(){
   SqlSession sqlSession = MybatisUtils.getSqlSession();
    UserDao mapper = sqlSession.getMapper(UserDao.class);
    User user = mapper.getUserById(1);
    System.out.println(user);
    sqlSession.close();
}
}
2.insert语句：插入数据
package dao;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import pojo.User;
import utils.MybatisUtils;

public class UserInsert {
    @Test
public void addUser(){
 SqlSession sqlSession = MybatisUtils.getSqlSession();
UserDao mapper = sqlSession.getMapper(UserDao.class);
 int res = mapper.addUser(new User(6,"普普"));
   System.out.println("res:"+res);
sqlSession.commit();
 sqlSession.close();
}
}
3.update语句：更新数据
package dao;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import pojo.User;
import utils.MybatisUtils;

public class UserUpdate {
    @Test
    public void updateUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
  UserDao mapper = sqlSession.getMapper(UserDao.class);
    int res = mapper.updateUser(new User(6, "微微"));
   System.out.println(res);
    sqlSession.commit();
    sqlSession.close();
    }
}
4.delete语句：删除数据
package dao;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import utils.MybatisUtils;

public class Userdelete {
    @Test
    public void deleteUser()
    {
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    UserDao mapper = sqlSession.getMapper(UserDao.class);
    int res = mapper.deleteUser(6);
    System.out.println(res);
    sqlSession.commit();
    sqlSession.close();
    }
}
对应映射文件中mapper
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="dao.UserDao" >
  <select id="getUserList" resultType="pojo.User">
      select * from login
      </select>
    <select id="getUserById" parameterType="int" resultType="pojo.User">
        select login from Login WHERE id = #{id}
    </select>
    <insert id="addUser" parameterType="pojo.User" >
       INSERT INTO login(id, name) VALUES (#{id},#{name})
           </insert>
    <delete id="deleteUser" parameterType="int" >
        DELETE from Login WHERE id = #{id}
    </delete>
    <update id="updateUser" parameterType="pojo.User">
        UPDATE login SET name=#{name} WHERE id = #{id}
    </update>


</mapper>

接口类：
package dao;

import pojo.User;

import java.util.List;

public interface UserDao {
    List<User> getUserList();

    User getUserById(int id);
    int addUser(User user);
    int deleteUser(int id);
   int updateUser(User user);
    }

以上就是本文的全部内容，希望对大家的学习有所帮助，本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明