📄 register.jsp
字号:
<!------filename:register.jsp-------学生成绩查询系统注册处理页-------->
<%/*<!-------该网页需要接收三个参数：zhanghao，mima1，mima2-------->
*/%><!---------------zhg工作室--------2007.6------------>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>欢迎使用----成绩查询系统</title>
</head>
<body>
<%
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String Host = "localhost";
String Port = "1433";
String DBName = "marks_query"; //要操作的数据库
String MssqlURL = "jdbc:microsoft:sqlserver://" + Host + ":" + Port +
";DatabaseName=" + DBName + ";SelectMethod=cursor";
String UserName = "sa"; //数据库服务器登录账号
String PassWord = ""; //登录密码
String zhanghao=null,mima1=null,mima2=null;
ResultSet rs=null;
%>
<%
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(MssqlURL, UserName,PassWord);
Statement stmt = conn.createStatement();
// Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );
//Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
//下面分别为从表单接受到的学号及密码
zhanghao = new String(request.getParameter("zhanghao").getBytes("ISO8859_1"));
mima1 = new String(request.getParameter("mima1").getBytes("ISO8859_1"));
mima2 = new String(request.getParameter("mima2").getBytes("ISO8859_1"));
if(zhanghao==null||zhanghao.trim().length()==0||mima1.length()==0)
{
out.println("用户名与密码都不能为空，请重新输入！");
%><input type="button" name="button" value="返回" onclick="javascript:history.go(-1)" ><%
}
else if(! mima1.equals(mima2))
{
out.println("请确保两次输入的密码一致！");
%><input type="button" name="button" value="返回" onclick="javascript:history.go(-1)" ><%
}
else
{
String sql = "select * from Student where sno='"+zhanghao+"'";//sql查询语句
rs = stmt.executeQuery(sql);
if(rs.next())//因为数据库Student表中账号为主键，所以无需使用while遍历结果集
{
out.println("账号（"+zhanghao+"）已存在，轻重新选一个账号！");
%><input type="button" name="button" value="返回" onclick="javascript:history.go(-1)" ><%
}
else //未找到已注册的同名账号，则可以为该用户注册
{
sql = "insert into Student values ('"+zhanghao+"','"+mima1+"')";//sql查询语句
stmt.executeUpdate(sql);
out.println("账号 "+zhanghao+" 已成功注册，请记住您的账号和密码！");
%><input type="button" name="button" value="准备登录" onclick="javascript:window.location.href=('login.html')" ><%
}
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e) {/*
out.println("<hr>出现错误!!!请检查各相关软件的设置!!!<p>下面的出错提示可供参考:<br><font color='red'>" + e+"</font></p><br><br>----ZHG工作室------2007.6 <hr>");
*/ }
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -