<?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="user">
<resultMap id="userResultMap" type="user">
<id property="id" column="id"/>
<result property="userName" column="name"/>
<result property="password" column="pass"/>
</resultMap>
<!--resultType 表示com.jefry.User这样一个实体对象 -->
<select id="selectUser" parameterType="int" resultMap="userResultMap" >
select * from t_user where id = #{id}
</select>
<!--增加操作-->
<insert id="addUser" parameterType="user"
useGeneratedKeys="true" keyProperty="id">
insert into t_user(name,pass) values(#{userName},#{password})
</insert>
<!--更新操作-->
<update id="modifyUser" parameterType="user">
update t_user set name=#{userName}, pass=#{password} where id=#{id}
</update>
<delete id="deleteUser" parameterType="int">
delete from t_user where id=#{id}
</delete>
</mapper>
mybatis基本操作
最新推荐文章于 2024-08-24 20:53:22 发布