package service;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import dao.SqlUtil;
import model.User;
public class LoginCheck {
public User LoginCheck(User user) {
Connection con = SqlUtil.getConnection();
User resuser = new User();
try {
PreparedStatement ps = con
.prepareStatement("select * from student where loginname = '"
+ user.getLoginname()
+ "'and password = '"
+ user.getPassword() + "'");
ResultSet result = (ResultSet) ps.executeQuery();
if (result.next()) {
resuser.setUsername(result.getString("name"));
resuser.setDeptid(result.getString("deptid"));
resuser.setId(result.getString("id"));
resuser.setLoginname(result.getString("loginname"));
resuser.setPassword(result.getString("password"));
resuser.setRoleid(result.getString("roleid"));
} else {
}
} catch (SQLException e) {
e.printStackTrace();
}
return resuser;
}
}
为什么不管我输入什么,依然是停留在login.jsp,无法跳转到contens.jsp页面?来大神解惑,谢谢啦