package com.Repository;
import com.LoginController.LoginAccount;
import org.springframework.stereotype.Repository;
import org.springframework.jdbc.core.JdbcTemplate;
import javax.annotation.Resource;
import java.io.Serializable;
@Repository
public class CheckAccount implements Serializable{//如果起名不当导致重写的花会找不到方法...
@Resource
private JdbcTemplate jdbcTemplate;
public String check(String username,String password){
System.out.println("here");
System.out.println(username);
String sqlaccount="select *"+
"from account where AccountName=?";
Object[] params={
username
};
AccountRowMapper row=new AccountRowMapper();
System.out.println("row here");
LoginAccount la=jdbcTemplate.queryForObject(sqlaccount,params,row);
if(username.equals(la.getAccountName())&&password.equals(la.getAccountPassword())) {
if("administor".equals(la.getUser()))
{
System.out.println("administor");
return "HOME";
}
System.out.println("studentview");
return "studentview";
}
System.out.println("error");
return "error";
}
}
row here都打出来了就是jdbcTemplate.queryForObject不执行,弹出的是空白的页面不是HOMEstudentvie...刚刚查到结果为NULL...
Spring在服务类调用工具类的时候工具类的注入不会生效而要写到服务类中,刚刚查到的