public class User {
private Integer id;
private String username;
private String password;
public User() {
}
public User(Integer id, String username, String password) {
this.id = id;
this.username = username;
this.password = password;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
4.在mapper文件夹中创建UserMapper类
import com.hqyj.lls.entity.User;
import org.apache.ibatis.annotations.*;
import java.util.List;
public interface UserMapper {
//查所有
@Select("select * from user")
List<User> select();
//根据id 查所有
@Select("select * from user where id = #{id}")
List<User> selectOne(Integer id);
//删除
@Delete("delete from user where id = #{userid}")
Integer delete(int id);
//添加
@Insert("insert into user values (#{id},#{username},#{password})")
Integer insert(User user);
//修改
@Update("update user set username = #{name},password = #{pwd} where id = #{id}")
Integer update(@Param("id") Integer id,@Param("name") String name,@Param("pwd") String pwd);
}