1、准备工作
mybatis(初学)_XC_2502476612的博客-CSDN博客
2、在接口中写入增删改查
package com.xiao.dao; import com.xiao.pojo.User; import java.util.List; public interface UserMapper { //查询全部用户 List<User> getUserList(); //根据Id查询用户 User getUserById(int id); //insert用户 int addUser(User user); //修改用户 int updateUser(User user); //删除用户 int deleteUser(int id); }
3、在mapper.xml文件中写入SQL语句
<?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"> <!-- namespace绑定一个对应的Dao接口--> <mapper namespace="com.xiao.dao.UserMapper"> <!-- select查询语句--> <select id="getUserList" resultType="com.xiao.pojo.User"> select * from user </select> <!-- 根据ID查询用户--> <select id="getUserById" parameterType="int" resultType="com.xiao.pojo.User"> select * from user where id=#{id} </select> <!-- insert用户--> <insert id="addUser" parameterType="com.xiao.pojo.User" > insert into user(id,name,pwd) values (#{id},#{name},#{pwd}); </insert> <!-- update用户--> <update id="updateUser" parameterType="com.xiao.pojo.User"> update user set name=#{name},pwd=#{pwd} where id=#{id}; </update> <!-- delete用户--> <delete id="deleteUser" parameterType="int"> delete from user where id=#{id}; </delete> </mapper>
4、进行测试
package com.xiao.dao; import com.xiao.pojo.User; import com.xiao.utils.MybatisUtils; import org.apache.ibatis.session.SqlSession; import org.junit.Test; import java.util.List; public class UserDaoTest { @Test public void test(){ //1、获取SqlsessionFactory对象 SqlSession sqlSession = MybatisUtils.getSqlSession(); //2、执行SQL UserMapper mapper = sqlSession.getMapper(UserMapper.class); List<User> userList = mapper.getUserList(); for (User user : userList) { System.out.println(user); } //3、关闭sqlSession sqlSession.close(); } @Test public void getUserById(){ //1、 SqlSession sqlSession = MybatisUtils.getSqlSession(); //2、 UserMapper mapper = sqlSession.getMapper(UserMapper.class); User userById = mapper.getUserById(1); System.out.println(userById); //3、 sqlSession.close(); } //增删改需要提交事务 @Test public void addUser(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); int res = mapper.addUser(new User(4, "赵六", "1234")); if(res>0){ System.out.println("插入成功"); } //提交事务 sqlSession.commit(); sqlSession.close(); } @Test public void updateUser(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); mapper.updateUser(new User(2,"李四1","12345")); sqlSession.commit(); sqlSession.close(); } @Test public void deleteUser(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); mapper.deleteUser(4); sqlSession.commit(); sqlSession.close(); } }