public class User { private int id; private String name; private String pwd; @Override public String toString() { return "User{" + "id=" + id + ", name='" + name + ''' + ", pwd='" + pwd + ''' + '}'; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPwd() { return pwd; } public void setPwd(String pwd) { this.pwd = pwd; } public User() { } public User(int id, String name, String pwd) { this.id = id; this.name = name; this.pwd = pwd; }
7、创建接口
package dao; import pojo.User; import java.util.List; import java.util.Map; public interface UserMapper { //获取全部用户 List getUserList(); //根据id查询用户 User getUserById(int id); //添加用户 public int AddUser(User user); //修改用户 int updateUser(User user); //删除用户 int deleteUser(int id); }
8、创建对应接口UserMapper.xml配置文件
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
insert into user (id,name ,pwd) values (#{id},#{name},#{pwd})
update user set name=#{name },pwd=#{pwd} where id=#{id}