📄 _0002fmydetails_0002ejspmydetails_jsp_0.java
字号:
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(25,2);to=(35,0)]
out.write("\r\n<html>\r\n<head>\r\n<title>修改个人资料</title>\r\n<meta http-equiv=\"pragma\" content=\"no-cache\"/>\r\n<meta http-equiv=\"expires\" content=\"0\"/>\r\n<meta http-equiv=\"cache-control\" content=\"no-cache\"/>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n<body bgcolor=\"#CDCEDC\" text=\"#000000\" link=\"#000080\" vlink=\"#000080\" alink=\"#000080\">\r\n"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(35,0);to=(35,45)]
{
String _jspx_qStr = "";
pageContext.include("Header.jsp" + _jspx_qStr);
}
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(35,45);to=(36,0)]
out.write("\r\n"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(36,0);to=(36,64)]
jspreg.dbBean dBBean = null;
boolean _jspx_specialdBBean = false;
synchronized (request) {
dBBean= (jspreg.dbBean)
pageContext.getAttribute("dBBean",PageContext.REQUEST_SCOPE);
if ( dBBean == null ) {
_jspx_specialdBBean = true;
try {
dBBean = (jspreg.dbBean) Beans.instantiate(this.getClass().getClassLoader(), "jspreg.dbBean");
} catch (Exception exc) {
throw new ServletException (" Cannot create bean of class "+"jspreg.dbBean");
}
pageContext.setAttribute("dBBean", dBBean, PageContext.REQUEST_SCOPE);
}
}
if(_jspx_specialdBBean == true) {
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(35,45);to=(36,0)]
out.write("\r\n"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(36,0);to=(36,64)]
}
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(37,14);to=(38,0)]
out.write("\r\n"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(38,2);to=(131,0)]
dBBean.connect();
String method=request.getMethod().trim();
if(method.toLowerCase().equals("post")){
flduser_login = getParam(request, "user_login");
flduser_password = getParam(request, "user_password");
flduser_password2 = getParam(request, "user_password2");
fldname = getParam(request, "name");
fldname=new String((fldname.getBytes("iso8859-1"))) ;
fldemail = getParam(request, "email");
fldaddress = getParam(request, "address");
fldaddress=new String((fldaddress.getBytes("iso8859-1"))) ;
fldcity = getParam(request, "city");
fldcity=new String((fldcity.getBytes("iso8859-1"))) ;
fldstate_id = getParam(request, "state_id");
fldzip = getParam(request, "zip");
fldage = getParam(request, "age");
fldgender = getParam(request, "gender");
fldeducation = getParam(request, "education");
fldincome = getParam(request, "income");
fldnotes = getParam(request, "notes");
fldnotes=new String((fldnotes.getBytes("iso8859-1"))) ;
if ( isEmpty(flduser_login) ) {
sMyDetailsErr += "请填写用户名*<br>";
}
if ( isEmpty(flduser_password) ) {
sMyDetailsErr += "请填写用户口令*<br>";
}
if ( !flduser_password.equals(flduser_password2)) {
sMyDetailsErr += "填写的口令不相符<br>";
}
if ( ! isEmpty(flduser_login)) {
if(!flduser_login.equals(currentUser)){
java.sql.ResultSet rs=dBBean.openRs("select * from users where user_login='"+flduser_login+"'");
if(rs.next())
sMyDetailsErr += "你填写的用户名已经被人使用*<br>";
}
}
if(sMyDetailsErr.trim().equals("")){
String sSQL = "update users set " +
"user_login=" + toSQL(flduser_login, adText) +
",user_password=" + toSQL(flduser_password, adText) +
",name=" + toSQL(fldname, adText) +
",email=" + toSQL(fldemail, adText) +
",address=" + toSQL(fldaddress, adText) +
",city=" + toSQL(fldcity, adText) +
",state_id=" + toSQL(fldstate_id, adText) +
",zip=" + toSQL(fldzip, adText) +
",age=" + toSQL(fldage, adNumber) +
",gender=" + toSQL(fldgender, adNumber) +
",education=" + toSQL(fldeducation, adNumber) +
",income=" + toSQL(fldincome, adNumber) +
",notes=" + toSQL(fldnotes, adText);
sSQL = sSQL + " where user_login='" + currentUser+"'";
dBBean.executeSql(sSQL);
currentUser=flduser_login;
sMyDetailsErr="您的资料已经更新成功";
session.setAttribute("USERID",flduser_login);
session.setAttribute("PASSWORD",flduser_password);
}
}else{
try{
java.sql.ResultSet rs=dBBean.openRs("select * from users where user_login='"+currentUser+"'");
rs.next();
flduser_login = (String) rs.getString("user_login");
flduser_password = (String) rs.getString("user_password");
flduser_password2=flduser_password;
fldname = (String) rs.getString("name");
if(fldname==null) fldname="";
fldemail = (String) rs.getString("email");
if(fldemail==null) fldemail="";
fldaddress = (String) rs.getString("address");
if( fldaddress==null) fldaddress="";
fldcity = (String) rs.getString("city");
if( fldcity==null) fldcity="";
fldstate_id = (String) rs.getString("state_id");
if(fldstate_id==null) fldstate_id="";
fldzip = (String) rs.getString("zip");
if( fldzip==null) fldzip="";
fldage = (String) rs.getString("age");
if(fldage==null) fldage="";
fldgender = (String) rs.getString("gender");
if(fldgender==null) fldgender="";
fldeducation = (String) rs.getString("education");
if(fldeducation==null) fldeducation="";
fldincome = (String) rs.getString("income");
if( fldincome==null) fldincome="";
fldnotes = (String) rs.getString("notes");
if(fldnotes==null) fldnotes="";
}catch (Exception e){
}
}
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(131,2);to=(135,6)]
out.write("\r\n <table>\r\n <tr>\r\n <td valign=\"top\">\r\n "); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(135,8);to=(135,38)]
if(!"".equals(sMyDetailsErr)){
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(135,40);to=(137,142)]
out.write("\r\n <tr>\r\n <td bgcolor=\"#DDDDBD\" colspan=\"2\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(137,145);to=(137,158)]
out.print(sMyDetailsErr);
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(137,160);to=(139,8)]
out.write("</font></td>\r\n </tr>\r\n "); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(139,10);to=(139,11)]
}
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(139,13);to=(143,95)]
out.write("\r\n <form method=\"post\" action=\"MyDetails.jsp\" name=\"Mydetails\">\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">用户名*</font></td>\r\n <td bgcolor=\"#DDDDBD\"><input type=\"text\" name=\"user_login\" maxlength=\"15\" value=\""); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(143,98);to=(143,111)]
out.print(flduser_login);
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(143,113);to=(147,102)]
out.write("\" size=\"15\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">口令*</font></td>\r\n <td bgcolor=\"#DDDDBD\"><input type=\"password\" name=\"user_password\" maxlength=\"15\" value=\""); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(147,105);to=(147,121)]
out.print(flduser_password);
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(147,123);to=(151,103)]
out.write("\" size=\"15\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">确认口令*</font></td>\r\n <td bgcolor=\"#DDDDBD\"><input type=\"password\" name=\"user_password2\" maxlength=\"15\" value=\""); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(151,106);to=(151,123)]
out.print(flduser_password2);
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(151,125);to=(155,89)]
out.write("\" size=\"15\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">姓名</font></td>\r\n <td bgcolor=\"#DDDDBD\"><input type=\"text\" name=\"name\" maxlength=\"20\" value=\""); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(155,92);to=(155,99)]
out.print(fldname);
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(155,101);to=(159,90)]
out.write("\" size=\"20\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">Email</font></td>\r\n <td bgcolor=\"#DDDDBD\"><input type=\"text\" name=\"email\" maxlength=\"30\" value=\""); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(159,93);to=(159,101)]
out.print(fldemail);
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(159,103);to=(163,92)]
out.write("\" size=\"30\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">详细住址</font></td>\r\n <td bgcolor=\"#DDDDBD\"><input type=\"text\" name=\"address\" maxlength=\"50\" value=\""); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(163,95);to=(163,105)]
out.print(fldaddress);
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(163,107);to=(167,89)]
out.write("\" size=\"50\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">所在城市</font></td>\r\n <td bgcolor=\"#DDDDBD\"><input type=\"text\" name=\"city\" maxlength=\"50\" value=\""); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(167,92);to=(167,99)]
out.print(fldcity);
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(167,101);to=(171,59)]
out.write("\" size=\"50\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">省份</font></td>\r\n <td bgcolor=\"#DDDDBD\"><select name=\"state_id\">"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(171,62);to=(171,142)]
out.print(getOptions(dBBean.openRs("select * from lookup_states"),false,false,fldstate_id));
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(171,144);to=(175,87)]
out.write("</select></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">邮编</font></td>\r\n <td bgcolor=\"#DDDDBD\"><input type=\"text\" name=\"zip\" maxlength=\"10\" value=\""); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(175,90);to=(175,96)]
out.print(fldzip);
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(175,98);to=(179,54)]
out.write("\" size=\"10\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">年龄</font></td>\r\n <td bgcolor=\"#DDDDBD\"><select name=\"age\" >"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(179,57);to=(179,130)]
out.print(getOptions(dBBean.openRs("select * from lookup_ages"),false,false,fldage));
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(179,132);to=(183,57)]
out.write("</select></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">性别</font></td>\r\n <td bgcolor=\"#DDDDBD\"><select name=\"gender\" >"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(183,60);to=(183,139)]
out.print(getOptions(dBBean.openRs("select * from lookup_genders"),false,false,fldgender));
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(183,141);to=(187,58)]
out.write("</select></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">受教育程度</font></td>\r\n <td bgcolor=\"#DDDDBD\"><select name=\"education\">"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(187,61);to=(187,146)]
out.print(getOptions(dBBean.openRs("select * from lookup_educations"),false,false,fldeducation));
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(187,148);to=(191,56)]
out.write("</select></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">收入</font></td>\r\n <td bgcolor=\"#DDDDBD\"><select name=\"income\">"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(191,59);to=(191,138)]
out.print(getOptions(dBBean.openRs("select * from lookup_incomes"),false,false,fldincome));
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(191,140);to=(195,75)]
out.write("</select></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#BCBC7A\"><font style=\"font-size: 10pt; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">自己的简单介绍</font></td>\r\n <td bgcolor=\"#DDDDBD\"><textarea name=\"notes\" cols=\"50\" rows=\"5\">"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(195,78);to=(195,94)]
out.print(toHTML(fldnotes));
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(195,96);to=(205,0)]
out.write("</textarea></td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"2\" align=\"right\"><input type=\"submit\" value=\"更新\" ><input type=\"reset\" value=\"重写\" ></td>\r\n </tr>\r\n </form>\r\n <font face=arial size=2><b>* - 表示必须填写的信息</b></font>\r\n </td>\r\n </tr>\r\n </table>\r\n"); // end
// begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(205,2);to=(205,17)]
dBBean.close();
// end
// HTML // begin [file="D:\\JbuilderProgram\\JspReg\\RegApp\\MyDetails.jsp";from=(205,19);to=(209,0)]
out.write("\r\n<center><font face=\"Arial\"><small>这是一个使用JSP开发的网上用户注册的应用程序</small></font></center>\r\n</body>\r\n</html>\r\n"); // end
} catch (Exception ex) {
if (out.getBufferSize() != 0)
out.clearBuffer();
pageContext.handlePageException(ex);
} finally {
out.flush();
_jspxFactory.releasePageContext(pageContext);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -