下面时接口和接口配置文件的代码,其他的在我的第一个mybatis程序中,增删改查在在最后要进行事务提交,别忘了!
package com.yyf.dao;
import com.yyf.pojo.User;
import java.util.List;
import java.util.Map;
public interface UserMapper {
//查询所有用户
List<User> getUserList();
//模糊查询name
List<User> getUserLike(String name);
//根据ID查询用户
User getUserById(int id);
//插入数据
int addUser(Map<String,Object> map);
int insertUser(User user);
//更新数据
int updateUser(User user);
//删除用户
int deleteUser(int id);
}
接口配置文件:
<?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="com.yyf.dao.userMapper">
<select id="getUserList" resultType="user">
select * from mybatis.user
</select>
<select id="getUserById" resultType="user" parameterType="int">
select * from mybatis.user where id=#{id}
</select>
<select id="getUserLike" parameterType="String" resultType="user">
select * from mybatis.user where name like #{a};
</select>
<insert id="insertUser" parameterType="user">
insert into mybatis.user (id,name,pwd)values (#{id},#{name},#{pwd})
</insert>
<insert id="addUser" parameterType="map">
insert into mybatis.user (id,name,pwd)values (#{userID},#{userName},#{passWord})
</insert>
<update id="updateUser" parameterType="user">
update mybatis.user
set name = #{name},pwd=#{pwd}
where id=#{id};
</update>
<delete id="deleteUser" parameterType="int">
delete from mybatis.user where id=#{id}
</delete>
</mapper>