1、创建一个实体类UserCheck
代码如下:
public class UserCheck {
private boolean result;
private int aut;
public boolean isResult() {
return result;
}
public void setResult(boolean result) {
this.result = result;
}
public int getAut() {
return aut;
}
public void setAut(int aut) {
this.aut = aut;
}
}
2、在mapper接口中的代码,public User findUser(String username,String password);
xml文件中的代码如下:
<!-- 登录验证 -->
<select id="findUser" resultType="cn.bgi.pojo.User">
select * from t_user where
username = #{arg0} and password = #{arg1}
</select>
注意:当从前端接收多个参数时,应该按照上述写,不然的话会报错
错误写法:
<select id="findUser" resultType="cn.bgi.pojo.User">
select * from t_user where
username = #{username} and password = #{password}
</select>
3、再然后在service层中进行逻辑调用
4、控制层中的代码如下:
@RequestMapping(value="/login",method=RequestMethod.POST)
public DataResult<UserCheck> checklogin(String username,String password) {
UserCheck uc = new UserCheck();
User user = userService.findUser(username,password);
if(user!=null) {
uc.setResult(true);
uc.setAut(user.getAuthority()); //判断超管和普通管理员
}
List<UserCheck> list = new ArrayList<UserCheck>();
list.add(uc);
return new DataResult<UserCheck>(list.size(),list);
}
5、前端代码如下:
function t_submit(){
var name =$("#username").val();
var pwd =$("#password").val();
if(name==""){
$.messager.alert('提示','用户名不能为空!');
return false;
}
else if(pwd==" "){
$.messager.alert('提示','密码不能为空!');
return false;
}
else
{
$.ajax({
type:'post',
url:'/ssm/user/login.do',
dataType:"json",
data:{username:name,password:pwd},
success:function(data){
//console.log(data);
if(data.rows[0].result){
alert("登录成功")
//console.log(data.rows[0].aut);
if(!data.rows[0].aut){
window.location.href ="main.html";
}
}
else{
$.messager.alert('错误', "用户名或者密码错误!");
}
}
});
}
}