实体entity
package com.lucun.student.db.entity;
public class User {
/**
* id
*/
private Long id;
/**
* 账号
*/
private String username;
/**
* 密码
*/
private String password;
/**
* 权限
*/
private String role;
/**
*
*状态码
*/
private Integer status;
public Integer getStatus() {
return status;
}
public void setStatus(Integer status) {
this.status = status;
}
public Long getId() {
return id;
}
public void setId(Long 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;
}
public String getRole() {
return role;
}
public void setRole(String role) {
this.role = role;
}
}
权限的限制
package com.lucun.student.db.entity;
public class UserRole {
public final static String ADMIN = "1";
public final static String USER = "0,1";
}
UserMapper
package com.lucun.student.db.mapper;
import com.lucun.student.db.entity.User;
import java.util.List;
public interface UserMapper {
int login(User user);
User login1(User user);
List<User> selectAll();
}
UserMapper.xml
<?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.lucun.student.db.mapper.UserMapper">
<resultMap id="BaseResultMap" type="com.lucun.student.db.entity.User">
<id column="id" jdbcType="BIGINT" property="id" />
<result column="username" jdbcType="VARCHAR" property="username" />
<result column="password" jdbcType="VARCHAR" property="password" />
<result column="role" jdbcType="VARCHAR" property="role" />
<result column="status" jdbcType="INTEGER" property="status" />
</resultMap>
<select id="selectAll" resultMap="BaseResultMap">
select * from user
</select>
<select id="login" resultType="int">
select count(*) from user where username=#{username} and password = #{password}
</select>
<select id="login1" resultMap="BaseResultMap">
select * from user where username=#{username} and password = #{password}
</select>
</mapper>
Service
package com.lucun.student.service;
import com.lucun.student.db.entit