📄 delconfirm.jsp

📁 毕业设计代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="BeanLink.DBBean"%>
<jsp:useBean id="db" class="BeanLink.DBBean" scope="page"/>
<%
    Connection con=null;
    Statement stmt=null;
    ResultSet rs=null;
    String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序
    String url="jdbc:odbc:airline";    //数据源的url
    String user1="";  //连接数据库的用户名
    String pass1="";  //连接数据库的口令
    String strSQL2;  //要执行的sql语句
	String strSQL3;  //要执行的sql语句

	String id=request.getParameter("id");
	String userName=null;
	String userPass=null;
	String userSex=null;
	int userAge=0;
	String userEmail=null;
	String userTruename=null;
	int userZhengjian=0;
	String userZhengjianhao=null;
	String userTel=null;
	String fuyan=null;
	String option=null;

    if(!db.initialization(driver,url,user1,pass1))  //进行初始化
	{
		out.println(db.getHint());
	}
	else try{
		 strSQL3="select * from airline_user with(READCOMMITTED)  where id='"+id+"'";//判断是否有用户存在
		 rs=db.executeQuery(strSQL3);
		 rs.next();
		 if(rs!=null)
		{
			 userName=rs.getString(2);
			 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(Exception e2){
         out.println("数据库异常！");
         out.println(e2.toString());
    }
    finally{
		try{
			if(rs!=null) rs.close();
            if(stmt!=null) stmt.close();
            if(con!=null) con.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="registerconfirmD.jsp">
<input type="hidden" value="<%=id%>" name="id">
<input type="hidden" value="<%=userName%>" name="userName">
    <TABLE WIDTH="780" BORDER="0" ALIGN="CENTER" CELLPADDING="0" CELLSPACING="2">
        <TR>
            <TD COLSPAN="4" CLASS="TITLE2">修改会员信息</TD>
        </TR>
        <TR>
            <TD COLSPAN="4">&nbsp;</TD>
        </TR>
        <TR>
            <TD WIDTH="152" CLASS="RIGHT">用户名：</TD>
            <TD WIDTH="221" CLASS="TEXT"><%=userName%></TD>
            <TD WIDTH="108" CLASS="RIGHT"></TD>
            <TD WIDTH="289"></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT">密码：</TD>
            <TD COLSPAN="3"><%=userPass%></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"><%=userAge%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT"> E-Mail：</TD>
            <TD COLSPAN="3"><%=userEmail%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT"> 真实姓名：</TD>
            <TD COLSPAN="3"><%=userTruename%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT">证件类型 ： </TD>
            <TD COLSPAN="3"><SELECT NAME="select3">
				<%=option%>
            </SELECT></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT">证件号码：</TD>
            <TD COLSPAN="3"><%=userZhengjianhao%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT">联系电话：</TD>
            <TD COLSPAN="3"><%=userTel%></TD>
        </TR>
        <TR>
            <TD HEIGHT="72" CLASS="RIGHT"> 附言：</TD>
            <TD COLSPAN="3"><TEXTAREA NAME="fuyan" COLS="50" disabled><%=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="删除">
				&nbsp;&nbsp;
                <INPUT NAME="Reset" TYPE="RESET" ID="Reset" VALUE="重写">
            </CENTER></TD>
        </TR>
    </TABLE>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -