Mybatis学习笔记（二）：实现对数据库的增删改查

Mybatis实现对数据库的增删改查

一、编写接口

package org.westos.dao;

import org.westos.pojo.User;

import javax.jws.soap.SOAPBinding;
import java.util.List;

public interface UserMapper {
   
    //添加一个用户
    int addUser(User user);

    //根据id查找用户
    User selectUser(int id);

    //根据id删除一个用户
    int deleteUser(int id);

    //修改用户信息
    int update(User user);
}

二、编写接口对应的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对应Mapper接口的类-->
<mapper namespace="org.westos.dao.UserMapper">
    <!--select标签的id对应映射接口的方法名字  resultType:返回结果的类型  中间就编写sql语句-->

    <!--添加一个用户-->
    <insert id="addUser" parameterType="org.westos.pojo.User">
        insert into user (id,name,pwd) values (#{id},#{name},#{pwd})
    </insert>

    <!--根据id查找用户-->
    <select id="selectUser" resultType="org.westos.pojo.User">
        select * from user where id=#{id}
    </select>

    <!--删除一个用户-->
    <delete id="deleteUser">
        delete from user where id = #{id}
    </delete>

    <!--更新用户信息-->
    <update id="update" parameterType="org.westos.pojo.User">
        update user set name = #{name},pwd = #{pwd} where id=#{id}
    </update>

</mapper>

三、测试类

package org.westos.dao;

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

import java.sql.ParameterMetaData