?? registstudent.jsp
字號:
<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/>
<HTML>
<HEAD>
<TITLE>入學登記表</TITLE>
</HEAD>
<BODY>
<%!
// 定義變量
ResultSet rs = null;
String username ; // 用戶名
String personalcode ; // 身份證號
String pwd ; // 密碼
String gender ; // 性別
String birthdate ; // 出生日期
String phone ; // 聯系電話
String email ; // Email
/*
String jiguan ; // 籍貫
String hukou ; // 戶口
String postaddress ; // 通信地址
String postalcode ; // 郵政編碼
String university ; // 畢業院校
String major ; // 專業
String g_time ; // 畢業時間
String degree ; // 最高學歷
String english ; // 英語水平
String work_year ; // 工作年限
String shixi ; // 是否需要實習
String tjgz ; // 是否需要推薦工作
String goal ; // 培訓目標
String source ; // 信息來源
*/
String sql = "";
%>
<%
// 下面獲取用戶提交過來的數據
request.setCharacterEncoding("GBK");
username = request.getParameter("Name"); // 用戶名
personalcode = request.getParameter("PersonalCode"); // 身份證號
pwd = request.getParameter("pwd"); // 密碼
gender = request.getParameter("Sex"); // 性別
birthdate = request.getParameter("BirthDate"); // 出生日期
phone = request.getParameter("HomeTel"); // 聯系電話
email = request.getParameter("Email"); // Email
/*
jiguan = request.getParameter("Jiguan"); // 籍貫
hukou = request.getParameter("Hukou"); // 戶口
postaddress = request.getParameter("Post"); // 通信地址
postalcode = request.getParameter("PostalCode"); // 郵政編碼
university = request.getParameter("Uni"); // 畢業院校
major = request.getParameter("Spec"); // 專業
g_time = request.getParameter("GradTime"); // 畢業時間
degree = request.getParameter("Edu"); // 最高學歷
english = request.getParameter("EngLevel"); // 英語水平
work_year = request.getParameter("workyear"); // 工作年限
shixi = request.getParameter("ToPra"); // 是否需要實習
tjgz = request.getParameter("RecWork"); // 是否需要推薦工作
goal = request.getParameter("EduTgt"); // 培訓目標
source = request.getParameter("InfoSrc"); // 信息來源
*/
sql = "select studentid,name from test_studentinfo where ";
sql+= "certid = '" + personalcode + "'";
rs = conn.executeQuery( sql );
if(rs.next()) {
out.println("<center>");
out.println("身份證號碼為: " + personalcode + "的用戶已經注冊！<br><br>");
out.println("注冊的用戶ID為: " + rs.getInt("studentid") + "<br><br>");
out.println("注冊的用戶姓名為: " + rs.getString("name") + "<br><br>");
out.println("如果您忘記了登錄密碼，請向管理員咨詢。<br><br>");
out.println("<a href=javascript:history.back()>單擊這里返回注冊頁面</a>");
out.println("</center>");
return;
}
/*
sql = "insert into test_studentinfo (";
sql += "name,certid,password,gender,birth,phone,email,hometown,hukou";
sql += ",txdz,yzbm,school,major,g_time,degree,english,work_year";
sql += ",shixi,tjgz,goal,source,regtime) values (";
sql += "";
*/
sql = "insert into test_studentinfo (name,certid,password,gender,birth,phone,email) values (";
if(username != null && !username.equals("")) {
sql += "'" + username + "',";
}else {
out.println("<h1>用戶名輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(personalcode != null && !personalcode.equals("") && personalcode.length()>=15) {
sql += "'" + personalcode + "',";
}else {
out.println("<h1>用戶身份證輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(pwd != null && !pwd.equals("")) {
sql += "'" + pwd + "',";
}else {
out.println("<h1>密碼輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(gender != null && !gender.equals("")) {
sql += "'" + gender + "',";
}else {
out.println("<h1>性別輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(birthdate != null && !birthdate.equals("")) {
// sql += "to_date('" + birthdate + "','YYYY/MM/DD'),";
sql += "'" + birthdate + "',";
}else {
out.println("<h1>出生日期輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(phone != null && !phone.equals("")) {
sql += "'" + phone + "',";
}else {
out.println("<h1>聯系電話輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(email != null && !email.equals("")) {
sql += "'" + email + "')"; //注意：此處少了個，多了一個）
}else {
out.println("<h1>email輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
/*
if(jiguan != null && !jiguan.equals("")) {
sql += "'" + jiguan + "',";
}else {
out.println("<h1>籍貫輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(hukou != null && !hukou.equals("")) {
sql += "'" + hukou + "',";
}else {
out.println("<h1>戶口輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(postaddress != null && !postaddress.equals("")) {
sql += "'" + postaddress + "',";
}else {
out.println("<h1>通信地址輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(postalcode != null && !postalcode.equals("")) {
sql += "'" + postalcode + "',";
}else {
out.println("<h1>郵政編碼輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(university != null && !university.equals("")) {
sql += "'" + university + "',";
}else {
out.println("<h1>畢業學校輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(major != null && !major.equals("")) {
sql += "'" + major + "',";
}else {
out.println("<h1>專業輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(g_time != null && !g_time.equals("")) {
sql += "'" + g_time + "'";
}else {
out.println("<h1>畢業時間輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(degree != null && !degree.equals("")) {
sql += "'" + degree + "',";
}else {
out.println("<h1>學歷輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(english != null && !english.equals("")) {
sql += "'" + english + "',";
}else {
out.println("<h1>英語水平輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(work_year != null && !work_year.equals("")) {
sql += "'" + work_year + "',";
}else {
out.println("<h1>工作年限輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(shixi != null && !shixi.equals("")) {
sql += "'" + shixi + "',";
}else {
out.println("<h1>是否需要推薦實習輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(tjgz != null && !tjgz.equals("")) {
sql += "'" + tjgz + "',";
}else {
out.println("<h1>是否需要推薦工作輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(goal != null && !goal.equals("")) {
sql += "'" + goal + "',";
}else {
out.println("<h1>培訓目標輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
if(source != null && !source.equals("")) {
sql += "'" + source + "',";
}else {
out.println("<h1>信息來源輸入非法！請返回重新輸入！</h1>");
out.println("<a href=javascript:history.back()>返回</a>");
return;
}
sql += "getdate())";//結尾處記得有 )
*/
// 執行插入操作
int result = 0;
try {
result = conn.executeUpdate( sql );
}catch(Exception ee) {
response.sendRedirect("/test/public/dberror.jsp?errmsg=" + ee.toString());
}
if(result !=1 ) {
response.sendRedirect("/test/public/dberror.jsp?errmsg=" + sql);
return;
}
sql = "select studentid,password from test_studentinfo where ";
sql+= "certid = '" + personalcode + "'";
rs = conn.executeQuery( sql );
String userid = "";;
String password = "";
if(rs.next()) {
userid = rs.getInt("studentid") + "";
password = rs.getString("password");
}
out.println("<center>");
out.println("您的信息已經正確保存！請記住您的用戶ID和密碼<br><br>");
out.println("用戶ID：" + userid + "<br><br>");
out.println("用戶密碼：" + password + "<br><br>");
out.println("<a href=/test>單擊這里返回登錄頁面</a>");
out.println("</center>");
%>
</BODY>
</HTML>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -