do_register.jsp

java + sqlserver2000编写的一个网上购书系统,实现了一些基本的功能,但对于初学者来说这个系统已经足以起到帮助作用

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.Date"%>
<jsp:useBean id="databean" scope="session" class="ConnBean.conn" />
<jsp:useBean id="md5" scope="page" class="MD5.MD5" />
<%
	ResultSet rset = null;
	String userName = request.getParameter("userName");
	String password = request.getParameter("password");
	String password2 = request.getParameter("password2");
	Date date = new Date();
	int year = date.getYear() + 1900;
	int month = date.getMonth() + 1;
	int dat = date.getDate();
	int hour = date.getHours();
	int min = date.getMinutes();
	int second = date.getSeconds();
	String yea = String.valueOf(year);
	String mon = String.valueOf(month);
	String da = String.valueOf(dat);
	String hou = String.valueOf(hour);
	String mi = String.valueOf(min);
	String sec = String.valueOf(second);
	String regtime = yea + "-" + mon + "-" + da + " " + hou + ":" + mi
					+ ":" + sec;

	if (password == "") {
		out
				.print("<script language=\"JavaScript\">alert(\"密码不能为空，重新注册！\");location.href=\"register.jsp\"</script>");
	} else {
		if (password.equals(password2)) {
			try 
			{
			   password=md5.getMD5ofStr(password);
				//password=md5.getMD5ofStr(password);
				String sql = "select * from userinfo where userName='"
						+ userName + "'";
				String sql1 = "insert into userinfo(UserName,UserPass,RegTime) values('"
						+ userName
						+ "','"
						+ password
						+ "','"
						+ regtime
						+ "')";
				rset = databean.executeQuery(sql);
				if (rset.next()) {
					out
							.print("<script language=\"JavaScript\">alert(\"用户名已存在，重新选择用户名！\");location.href=\"register.jsp\"</script>");

				} else {
					rset = databean.executeQuery(sql1);
					rset.close();
					out
							.print("<script language=\"JavaScript\">alert(\"恭喜你，注册成功！\");location.href=\"../index.jsp\"</script>");
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		} else {
			out
					.print("<script language=\"JavaScript\">alert(\"确认密码错误，请重新注册！\");location.href=\"register.jsp\"</script>");
		}
	}
%>