📄 edit.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="BeanLink.DBBean"%>
<jsp:useBean id="db" class="BeanLink.DBBean" scope="page"/>
<%
ResultSet rs=null;
String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序
String url="jdbc:odbc:airline"; //数据源的url
String user1="tangbohu"; //连接数据库的用户名
String pass1=""; //连接数据库的口令
String strSQL1; //要执行的sql语句
String strSQL2; //要执行的sql语句
String userName=(String)session.getAttribute("userName");
String userPass=null;
String userSex=null;
int userAge=0;
String userEmail=null;
String userTruename=null;
int userZhengjian;
String userZhengjianhao=null;
String userTel=null;
String fuyan=null;
String option=null;
// String userName=request.getParameter("userName");
// String userPass=request.getParameter("userPass");
// userName=new String(userName.getBytes("8859_1"));
if(!db.initialization(driver,url,user1,pass1)) //进行初始化
{
out.println(db.getHint());
}
else try{
strSQL1="select * from airline_user with(READCOMMITTED) where userName='"+userName+"'";//判断是否有用户存在
rs=db.executeQuery(strSQL1);
rs.next();
userPass=rs.getString(3);
userSex=rs.getString(4);
userAge=rs.getInt(5);
userEmail=rs.getString(6);
userTruename=rs.getString(7);
userZhengjian=rs.getInt(8);
userZhengjianhao=rs.getString(9);
userTel=rs.getString(10);
fuyan=rs.getString(11);
switch(userZhengjian)
{
case 0:
option="<option value='0' checked>身份证</option>";
option=option+"<option value='1'>军官证</option>";
option=option+"<option value='2'>其他</option>";
break;
case 1:
option="<option value='1' checked>军官证</option>";
option=option+"<option value='0'>身份证</option>";
option=option+"<option value='2'>其他</option>";
break;
case 2:
option="<option value='2' checked>其他</option>";
option=option+"<option value='1'>军官证</option>";
option=option+"<option value='0'>身份证</option>";
break;
}
}
catch(SQLException e2){
out.println("数据库异常！");
out.println(e2.toString());
}
finally{
try{
if(rs!=null) rs.close();
}
catch(Exception e){}
}
%>
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<TITLE>VIP会员</TITLE>
<LINK HREF="../../../css/style.css" REL="stylesheet" TYPE="text/css">
</HEAD>
<BODY>
<FORM NAME="form1" METHOD="post" ACTION="registerconfirm.jsp">
<TABLE WIDTH="620" BORDER="0" CELLSPACING="2" CELLPADDING="0">
<TR>
<TD COLSPAN="4" CLASS="TITLE2">修改个人信息</TD>
</TR>
<TR>
<TD COLSPAN="4"> </TD>
</TR>
<TR>
<TD WIDTH="131" HEIGHT="17" CLASS="RIGHT">用户名：</TD>
<TD COLSPAN="3" CLASS="TEXT"><input type="hidden" value="<%=userName%>" name="userName"><%=userName%></TD>
</TR>
<TR>
<TD CLASS="RIGHT">密码：</TD>
<TD COLSPAN="3"><INPUT NAME="userPass" TYPE="password" SIZE="30" value="<%=userName%>"></TD>
</TR>
<% if(userSex!=null){
if(userSex.equals("男")){
%>
<TR>
<TD CLASS="RIGHT">性别：</TD>
<TD COLSPAN="3">
<SELECT NAME="userSex">
<OPTION VALUE="男" SELECTED>男</OPTION>
<OPTION VALUE="女">女</OPTION>
</SELECT>
</TD>
</TR>
<%
}
else{
%>
<TR>
<TD CLASS="RIGHT">性别：</TD>
<TD COLSPAN="3">
<SELECT NAME="userSex">
<OPTION VALUE="男">男</OPTION>
<OPTION VALUE="女" SELECTED>女</OPTION>
</SELECT>
</TD>
</TR>
<%
}
}
%>
<TR>
<TD CLASS="RIGHT"> 年龄：</TD>
<TD COLSPAN="3"><INPUT NAME="userAge" TYPE="text" SIZE="5" value="<%=userAge%>"></TD>
</TR>
<TR>
<TD CLASS="RIGHT"> E-Mail：</TD>
<TD COLSPAN="3"><INPUT NAME="userEmail" TYPE="text" SIZE="30" value="<%=userEmail%>"></TD>
</TR>
<TR>
<TD CLASS="RIGHT"> 真实姓名：</TD>
<TD COLSPAN="3"><INPUT NAME="userTruename" TYPE="text" SIZE="10" value="<%=userTruename%>"></TD>
</TR>
<TR>
<TD CLASS="RIGHT">证件类型：</TD>
<TD COLSPAN="3">
<SELECT NAME="userZhengjian">
<%=option%>
</SELECT>
</TD>
</TR>
<TR>
<TD CLASS="RIGHT">证件号码：</TD>
<TD COLSPAN="3"><INPUT NAME="userZhengjianhao" TYPE="text" SIZE="30" value="<%=userZhengjianhao%>"></TD>
</TR>
<TR>
<TD CLASS="RIGHT">联系电话：</TD>
<TD COLSPAN="3"><INPUT NAME="userTel" TYPE="text" SIZE="30" value="<%=userTel%>"></TD>
</TR>
<TR>
<TD HEIGHT="72" CLASS="RIGHT"> 附言：</TD>
<TD COLSPAN="3"><TEXTAREA NAME="fuyan" COLS="50"><%=fuyan%></TEXTAREA></TD>
</TR>
<TR>
<TD COLSPAN="4"><HR COLOR="#999999" SIZE="1"></TD>
</TR>
<TR>
<TD COLSPAN="4" ALIGN="RIGHT"><CENTER>
<INPUT TYPE="submit" NAME="Submit" VALUE="提交">
<INPUT TYPE="reset" NAME="Submit2" VALUE="重填">
</CENTER></TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -