Mybatis实现增删改查

实现向数据库增加数据

UserMapper

 //增加用户
    int addUser(User user);

UserMapper.xml

<insert id="addUser" parameterType="com.wx.pojo.User">
        insert into mybatis.user (id,name,pwd) value (#{id},#{name},#{pwd});
    </insert>

注：这里的两个id，name，pwd字段都要对应数据库的字段
UserMapperTest

 		@Test
        public void addUser(){
            SqlSession sqlsession = MybatisUtils.getSqlSession();
            UserMapper mapper = sqlsession.getMapper(UserMapper.class);
            int rs = mapper.addUser(new User(4,"哈","1234567"));
            sqlsession.commit();//提交事务
            sqlsession.close();

        }

注：在增加完之后要 sqlsession.commit();提交事务，数据库中才会有增加的内容

实现向数据库删除数据

UserMapper

    //删除用户
    int deleteUser(int id);

UserMapper.mxl

    <delete id="deleteUser" parameterType="int">
        delete from mybatis.user where id = #{id}
    </delete>

注：这里的两个字段也要对应数据库中的字段
UserMapperTest

		@Test
        public void deleteUser(){
            SqlSession sqlsession = MybatisUtils.getSqlSession();
            UserMapper mapper = sqlsession.getMapper(UserMapper.class);
            mapper.deleteUser(4);
            sqlsession.commit();
            sqlsession.close();
        }

注：同样的在删除完之后要 sqlsession.commit();提交事务，数据库中才会删除改数据

实现向数据库修改数据

UserMapper

    //修改用户
    int updateUser(User user);

UserMapper.mxl

<update id="updateUser" parameterType="com.wx.pojo.User">
        update mybatis.user set name = #{name},pwd = #{pwd} where id = #{id}
    </update>

注：这里的字段也要对应数据库中的字段
UserMapperTest

        @Test
        public void updateUser(){
            SqlSession sqlsession = MybatisUtils.getSqlSession();
            UserMapper mapper = sqlsession.getMapper(UserMapper.class);
            mapper.updateUser(new User(4,"呵","121212"));
            sqlsession.commit();
            sqlsession.close();
        }

注：同样的在更新完之后要 sqlsession.commit();提交事务，数据库中才会更新数据

实现向数据库查询数据

UserMapper

	//根据ID查询用户
    User getUserById(int id);

UserMapper.xml

    <select id="getUserById" parameterType="int" resultType="com.wx.pojo.User">
        select * from mybatis.user where id = #{id}
    </select>

注：这里的字段也要对应数据库中的字段
UserMapperTest

        @Test
        public void getUserById(){
            SqlSession sqlsession = MybatisUtils.getSqlSession();
            UserMapper mapper = sqlsession.getMapper(UserMapper.class);
            User user = mapper.getUserById(1);
            System.out.println(user);
            sqlsession.close();
        }

结果

模糊查询
UserMapper

    //模糊查询
    List<User> getUserLike(String value);

UserMapper.xml

   <select id="getUserLike" resultType="com.wx.pojo.User">
        select * from mybatis.user where name like #{value}
    </select>
    ```

UserMapperTest

        @Test
        public void getUserLike(){
            SqlSession sqlsession = MybatisUtils.getSqlSession();
            UserMapper mapper = sqlsession.getMapper(UserMapper.class);
            List<User> userList = mapper.getUserLike("%李%");
            for (User user: userList){
                System.out.println(user);
            }
            sqlsession.close();
        }

这里也可以修改UserMapper.xml中的#{%value%}，实现模糊查询的操作，但要注意sql注入的问题

万能的Map

当数据库了字段较多的时候，我们可以使用Map来传递参数
UserMapper

    int updateUserByMap(Map<String,Object> map);

UserMapper.xml

    <update id="updateUserByMap" parameterType="map">
        update user set name = #{username},pwd = #{password} where id= #{id}
    </update>

测试

        @Test
        public void updateUserByMap(){
            SqlSession sqlsession = MybatisUtils.getSqlSession();
            UserMapper mapper = sqlsession.getMapper(UserMapper.class);
            Map<String,Object> map = new HashMap<String,Object>();
            map.put("id",2);
            map.put("username","wx");
            map.put("password","258963");
            int i = mapper.updateUserByMap(map);
            sqlsession.commit();
            sqlsession.close();
        }

使用Map传递参数是，直接在sql中取出key即可
使用对象传递参数，直接在sql中取出对象的属性即可！
只有一个基本类型参数的情况下，可以直接在sql中取到