java web图书管理注册debug

问题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");