初练Mybatis | phper `blog

java学习知识积累-初练Mybatis

By admin 2015年9月15日 java

2299

Mybatis在xml文件处理简单的增删改查操作。、对应的数据库表结构是这样的： xml代码如下：

<insert id="insertUser" parameterType="User" useGeneratedKeys="true" keyColumn="id">  
       insert into t_user(name, age) values(#{name}, #{age})  
    </insert>  
     
    <update id="updateUser" parameterType="User">  
       update t_user set name=#{name}, age=#{age} where id=#{id}  
    </update>  
     
    <select id="findById" parameterType="int" resultType="User">  
       select * from t_user where id=#{id}  
    </select>  
     
    <delete id="deleteUser" parameterType="int">  
       delete from t_user where id=#{id}  
    </delete>

insert into t_user(name, age) values(#{name}, #{age})

</insert>

update t_user set name=#{name}, age=#{age} where id=#{id}

</update>

select * from t_user where id=#{id}

</select>

delete from t_user where id=#{id}

</delete>

UserMappe…