问题1:regist.html提交数据报空指针错误
解决方法:
String s = request.getParameter("urole");
if(s!=null)
{
user.setRole(Integer.parseInt(s));
}
问题2:no operation allowed after connection close(连接关闭后在访问)
解决方法:
public User findByName_pwd(String username, String userpass) {
// TODO Auto-generated method stub
User user = null;
ResultSet rs = null;
try {
JdbcUtil.getConnection();
String reSql = " and username=? and userpass=?";
String[] param = new String[] { username, userpass };
rs = JdbcUtil.executeQuery(selectSql+reSql, param);
if (rs.next()) {
user = new User(
rs.getString(1),
rs.getString(2),
rs.getInt(3),
rs.getString(4),
rs.getInt(5)
);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return user;
}
在regist.jsp-> Userdaoimpl中的 regist-> findByName_pwd(连接关闭)---报错
regist.jsp(连接关闭)-> Userdaoimpl中的 regist-> findByName_pwd(不关闭)---成功
问题3:日期问题
日期转换格式错:
Date date = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd:hh-mm-ss");
String sdate = sdf.format(date);
解决方法:
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd:HH-mm-ss");