📄 zc2_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
public final class zc2_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
int i=2;
private static java.util.Vector _jspx_dependants;
public java.util.List getDependants() {
return _jspx_dependants;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=gb2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write('\n');
request.setCharacterEncoding("gb2312");
out.write("\n<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\" />\n<link href=\"2.css\" rel=\"stylesheet\" type=\"text/css\" />\n<title>教材中心-会员注册－第二步</title>");
out.write("\n<SCRIPT LANGUAGE=\"JavaScript\">\n<!--\nfunction checks()\n{\n if(checkspace(document.userinfo.username.value)) {\n\tdocument.userinfo.username.focus();\n alert(\"请填写会员帐号，谢谢！\")\n\treturn false;\n }\n if(checkspace(document.userinfo.userzhenshiname.value)) {\n\tdocument.userinfo.userzhenshiname.focus();\n alert(\"请填写联系人真实姓名，谢谢！\");\n\treturn false;\n }\n if(checkspace(document.userinfo.memberpassword.value) || document.userinfo.memberpassword.value.length < 6) {\n\tdocument.userinfo.memberpassword.focus();\n alert(\"密码长度不能小于6，请重新输入！\");\n\treturn false;\n }\n if(document.userinfo.memberpassword.value != document.userinfo.memberpassword2.value) {\n\tdocument.userinfo.memberpassword.focus();\n\tdocument.userinfo.memberpassword.value = '';\n\tdocument.userinfo.memberpassword2.value = '';\n alert(\"两次输入的密码不同，请重新输入！\");\n\treturn false;\n }\n if(checkspace(document.userinfo.yidongtel.value)) {\n\tdocument.userinfo.yidongtel.focus();\n alert(\"请输入您的住宅电话以便联系！\");\n\treturn false;\n }\n\n\n}\n\n\nfunction checkspace(checkstr) {\n var str = '';\n");
out.write(" for(i = 0; i < checkstr.length; i++) {\n str = str + ' ';\n }\n return (str == checkstr);\n}\n\n\tfunction regInput(obj, reg, inputStr)\n\t{\n\t\tvar docSel\t= document.selection.createRange()\n\t\tif (docSel.parentElement().tagName != \"INPUT\")\treturn false\n\t\toSel = docSel.duplicate()\n\t\toSel.text = \"\"\n\t\tvar srcRange\t= obj.createTextRange()\n\t\toSel.setEndPoint(\"StartToStart\", srcRange)\n\t\tvar str = oSel.text + inputStr + srcRange.text.substr(oSel.text.length)\n\t\treturn reg.test(str)\n\t}\n\n//-->\n</script>\n\n");
String getpassword= request.getParameter("memberpassword"); String getname = request.getParameter("username"); String getquestion = request.getParameter("question"); String getanswer = request.getParameter("answer"); String gettel = request.getParameter("tel"); String getsmail = request.getParameter("useremail"); String getzhenshiname = request.getParameter("userzhenshiname"); session.setAttribute("user_name",getname); session.setAttribute("pass_word",getpassword); session.setAttribute("zhenshi_name",getzhenshiname); session.setAttribute("t_el",gettel); session.setAttribute("ques_tion",getquestion); session.setAttribute("ans_wer",getanswer);
out.write("\n</head>\n<center>\n<body>\n<html>\n <div id=\"Header\"></div>\n<TABLE cellSpacing=0 cellPadding=0 width=750 align=center border=0>\n <TBODY>\n <TR>\n <TD width=210 rowSpan=2><IMG height=65\n alt=教材系统 src=\"123.jpg\" width=194 border=0></TD>\n <TD align=center width=16 rowSpan=2><IMG height=36\n src=\"shuxian.gif\" width=1></TD>\n <TD height=38 align=\"center\" vAlign=bottom><table width=\"90%\" height=\"19\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n <tr>\n <td width=\"5\" height=\"15\" ></td>\n <td height=\"19\" align=\"center\" valign=\"bottom\" bgcolor=\"#F2F2F2\"> </td>\n <td width=\"5\"></td>\n </tr>\n </table></TD>\n </TR>\n <TR>\n <TD align=center height=37>会员注册</TD>\n </TR>\n </TBODY>\n</TABLE>\n<TABLE cellSpacing=0 cellPadding=0 width=750 align=center border=0>\n <FORM name=userinfo onSubmit=\"checks()\" action=zc2.jsp\nmethod=post><TBODY>\n <TR>\n <TD vAlign=top align=center width=187>\n <TABLE cellSpacing=0 cellPadding=0 width=187 border=0>\n");
out.write(" <TBODY>\n <TR>\n <TD><IMG height=65\n src=\"left1.gif\" width=187 alt=\"教材购销管理\"></TD></TR>\n <TR>\n <TD><IMG height=103\n src=\"left_t1.gif\"\nwidth=187 alt=\"教材购销管理\"></TD></TR>\n <TR>\n <TD><IMG height=107\n src=\"left_t2_s.gif\"\n width=187 alt=\"教材购销管理\"></TD></TR>\n <TR>\n <TD><IMG height=107\n src=\"left_t3.gif\"\nwidth=187 alt=\"教材购销管理\"></TD></TR>\n </TBODY></TABLE><SPAN ><BR>请您注册会员享受更多的服务</SPAN></TD>\n <TD vAlign=top align=right>\n <TABLE cellSpacing=0 cellPadding=0 width=558 border=0>\n <TBODY>\n <TR>\n <TD><IMG height=52 src=\"2_1.gif\"\n width=50 alt=\"教材购销管理\"></TD>\n <TD><IMG height=52 src=\"2_2.gif\"\n width=152 alt=\"教材购销管理\"></TD>\n <TD><IMG height=52 src=\"2_3.gif\"\n width=356 alt=\"教材购销管理\"></TD></TR></TBODY></TABLE>\n <TABLE cellSpacing=0 cellPadding=0 width=558 border=0>\n <TBODY>\n <TR>\n <TD width=1 bgColor=#c9c9c9></TD>\n");
out.write(" <TD vAlign=top width=556 bgColor=#ececec>\n <TABLE cellSpacing=0 cellPadding=0 width=556 border=0>\n <TBODY>\n <TR>\n <TD height=35 align=\"left\"> ・以下属于<B\n style=\"COLOR: #ff0000\">必填</B>内容，请您认真填写</TD>\n </TR></TBODY></TABLE>\n <TABLE cellSpacing=0 cellPadding=0 width=536 align=center\n border=0><TBODY>\n <TR>\n <TD width=1 bgColor=#c6d6e3></TD>\n <TD align=center bgColor=#ffffff>\n <TABLE cellSpacing=0 cellPadding=0 width=534 bgColor=#ffffff\n border=0>\n <TBODY>\n <TR>\n <TD align=right width=\"17%\" height=30>会员帐号：</TD>\n <TD width=\"37%\" align=\"left\">\n<input name=username id=username size=\"30\" maxlength=\"30\" >\n<a href=zccheck.jsp onClick=\"javascript:window.open('zccheck.jsp','','width=300,height=100,toolbar=no, status=no, menubar=no, resizable=yes,\nscrollbars=yes');return false;\"><img src=reg1.jpg width=168 height=22 /></a></TD>\n");
out.write(" <TD width=\"46%\" align=\"left\">\n 作为与您的重要联系渠道，您将来使用此用户名登录本站。\n </TD></TR>\n <TR align=\"left\">\n <TD height=8 colSpan=3></TD>\n </TR>\n <TR align=\"left\">\n <TD height=1 colSpan=3 bgColor=#bfcedc></TD>\n </TR>\n <TR align=\"left\">\n <TD height=8 colSpan=3></TD>\n </TR>\n <TR>\n <TD align=right height=30>联 系 人：</TD>\n <TD align=\"left\"><label>\n <input name=\"userzhenshiname\" id=\"userzhenshiname\" maxlength=\"10\" />\n </label></TD>\n <TD align=\"left\">请留下您的真实姓名，方便我们与您联系。</TD></TR>\n <TR>\n <TD align=right width=\"17%\" height=30>密码：</TD>\n <TD width=\"37%\" align=\"left\">\n<INPUT type=password maxLength=15 size=25\n name=memberpassword></TD>\n");
out.write(" <TD width=\"46%\" align=\"left\">\n 长度为6―15个字母、数字、下划线。 </TD></TR>\n <TR>\n <TD align=right width=\"17%\" height=30>重复密码：</TD>\n <TD width=\"37%\" align=\"left\">\n <INPUT type=password maxLength=15 size=25 name=memberpassword2></TD>\n <TD width=\"46%\" align=\"left\">\n 请再输一次密码。 </TD></TR>\n <TR align=\"left\">\n <TD height=8 colSpan=3></TD>\n </TR>\n <TR align=\"left\">\n <TD height=1 colSpan=3 bgColor=#bfcedc></TD>\n </TR>\n <TR align=\"left\">\n <TD height=8 colSpan=3></TD>\n </TR>\n <TR>\n <TD align=right width=\"17%\" height=30>密码提示问题：</TD>\n <TD width=\"37%\" align=\"left\"><INPUT name=question size=25\n maxLength=25></TD>\n");
out.write(" <TD width=\"46%\" align=\"left\">\n 如果您忘记密码，系统会提出此问题。</TD></TR>\n <TR>\n <TD align=right width=\"17%\" height=30>密码提示答案：</TD>\n <TD width=\"37%\" align=\"left\">\n<INPUT maxLength=25 size=25 name=answer></TD>\n <TD width=\"46%\" align=\"left\">\n 当忘记密码时，系统会根据您在这里设定的提示问题和答案帮助您重新设置密码。</TD></TR>\n <TR align=\"left\">\n <TD height=8 colSpan=3></TD>\n </TR>\n <TR align=\"left\">\n <TD height=1 colSpan=3 bgColor=#bfcedc></TD>\n </TR>\n <TR align=\"left\">\n <TD height=8 colSpan=3></TD>\n </TR>\n <TR bgColor=#ffffff>\n <TD align=right height=30>常用电话：</TD>\n <TD align=\"left\"><INPUT id=text5 maxLength=30 name=tel></TD>\n <TD align=\"left\">\n 请填写能随时联系到您的电话，最好是手机。</TD></TR>\n");
out.write(" <TR align=\"left\">\n <TD height=8 colSpan=3></TD>\n </TR>\n <TR align=\"left\">\n <TD height=1 colSpan=3 bgColor=#bfcedc></TD>\n </TR>\n <TR align=\"left\">\n <TD height=8 colSpan=3></TD>\n </TR>\n <TR align=\"left\" bgColor=#ffffff>\n <TD width=\"17%\" align=right>E_mail： </TD>\n <TD colSpan=2><input name=\"useremail\" type=\"text\" id=\"useremail\"></TD></TR>\n <TR align=\"left\">\n <TD height=8 colSpan=3></TD>\n </TR>\n <TR align=\"left\">\n <TD height=1 colSpan=3 bgColor=#bfcedc></TD>\n </TR>\n <TR align=\"left\">\n <TD height=12 colSpan=3></TD>\n </TR></TBODY></TABLE>\n<INPUT id=tijiao type=submit value=填写完毕 name=tijiao onClick=\"return checks();\">\n");
out.write(" <INPUT id=button2 type=reset value=写错了，重填 name=reset>\n </TD>\n <TD width=1 bgColor=#c6d6e3></TD></TR></TBODY></TABLE>\n\n </TD></TR></TBODY></FORM></TABLE>\n <a href=\"zc3.jsp\">下一步</a>\n");
Statement stmt=null; PreparedStatement pstmt=null; String sql = "select * from adm where name='"+getname+"';"; //加载JDBC-ODBC桥驱动 try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //定义JDBC URL }catch (Exception e) { out.println(e.getMessage()); } try{ String url = "jdbc:odbc:s"; //得到与数据库的连接 Connection con = DriverManager.getConnection(url); //显示UPL和连接信息 System.out.print("URL:" + url); System.out.print("Connection:" + con); //得到一个Statement对象 stmt = con.createStatement(); //执行SQL语句 System.out.print("SQL:" + sql); ResultSet p = stmt.executeQuery(sql); ResultSetMetaData meta = p.getMetaData(); if(p.next()) { response.sendRedirect("jsp9.jsp");//out.print("<script>type='text/JavaScript'>alert('对不起，该帐号已注册！');</script>");} else { if(getname!=null) { sql="insert into adm(permit,password,name,userzhenshiname,tel,question,answer) VALUES("+i+"," +getpassword+ ",'" +getname + "'," +getzhenshiname+ ",'" +gettel + "','" +getquestion + "','" +getanswer + "');"; ResultSet g = stmt.executeQuery(sql); System.out.print("SQL:" + sql); }} } catch (Exception e) {}
out.write("\n\n</body>\n</html>\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -