📄 news.jsp
字号:
<%}
else
{%><table>
<tr>
<td>
用户名：<%=session.getAttribute("name")%>
<input type="button" value="重新登录" onclick="login()">
</td>
</tr>
</table>
<%}
%>
<table border="1" align="center" >
<tr><td align="center" colspan="8">用户信息</td></tr>
<tr bgcolor="d1d1ff">
<th>数据id</th><th>序号</th><th>中文姓名</th><th>用户密码</th><th>曾用外文名</th><th>性别</th><th>出生日期</th><th>显示全部信息</th>
</tr>
<%
// String a[]=null;
String str=null;
while(rs.next()){
// str =rs.getString("id")+","+rs.getString("cnname")+","+rs.getString("oldname")+","+rs.getString("sex")+","
// +rs.getString("birthday")+","+rs.getString("nativeplace")+","+rs.getString("edu")+","+rs.getString("nation")+","
// +rs.getString("officetel")+","+rs.getString("mobile")+","+rs.getString("hometel")+","+rs.getString("certificatetype")+","
// +rs.getString("certificateno")+","+rs.getString("email")+","+rs.getString("politicalstatus")+","+rs.getString("aboardtime")+","
// +rs.getString("visano")+","+rs.getString("speciality")+","+rs.getString("studyabrod_country")+","+rs.getString("company")+","
// +rs.getString("studyabroad_type")+","+rs.getString("address")+","+rs.getString("company_addr")+","+rs.getString("finishschool")+","
// +rs.getString("remark")+","+rs.getString("photo")+","+rs.getString("inputtime")+","+rs.getString("inputmancode")+","
// +rs.getString("inpman")+","+rs.getString("addtime")+","+rs.getString("preserve1")+","+rs.getString("preserve2")+","
// +rs.getString("id")+","+rs.getString("id")+","+rs.getString("id")+","+rs.getString("id")+","
// +rs.getString("id")+","+rs.getString("id")+","+rs.getString("id")+","+rs.getString("id")+","
// +rs.getString("id")+","+rs.getString("id")+","+rs.getString("id")+","+rs.getString("id");
// rs.beforeFirst();
// a[0]=rs.getString("dataid");
//a[1]=rs.getString("id");a[2]=rs.getString("cnname");a[3]=rs.getString("password");a[4]=rs.getString("oldenname");
// a[5]=rs.getString("sex");a[6]=rs.getString("birthday");a[7]=rs.getString("nativeplace");a[8]=rs.getString("edu");
// a[9]=rs.getString("nation");a[10]=rs.getString("officetel");a[11]=rs.getString("mobile");a[12]=rs.getString("hometel");
// a[13]=rs.getString("certificatetype");a[14]=rs.getString("certificateno");a[15]=rs.getString("email");a[16]=rs.getString("politicalstatus");
// a[17]=rs.getString("aboardtime");a[18]=rs.getString("visano");a[19]=rs.getString("speciality");a[20]=rs.getString("studyabroad_country");
// a[21]=rs.getString("company");a[22]=rs.getString("studyabroad_type");a[23]=rs.getString("address");a[24]=rs.getString("company_addr");
// a[25]=rs.getString("finishschool");a[26]=rs.getString("remark");a[27]=rs.getString("photo");a[28]=rs.getString("inputtime");
// a[29]=rs.getString("inputmancode");a[30]=rs.getString("impman");a[31]=rs.getString("addtime");a[32]=rs.getString("edittime");
// a[33]=rs.getString("preserve1"); a[34]=rs.getString("preserve2"); a[35]=rs.getString("preserve3");a[36]=rs.getString("preserve4");
// a[37]=rs.getString("preserve5"); a[38]=rs.getString("comments");a[39]=rs.getString("datasrc"); a[40]=rs.getString("cnname_pinyin");
// a[41]=rs.getString("oldenname_pinyin");
String a0=rs.getString("dataid");
String a1=rs.getString("id");String a2=rs.getString("cnname");String a3=rs.getString("password");String a4=rs.getString("oldenname");
String a5=rs.getString("sex");String a6=rs.getString("birthday");String a7=rs.getString("nativeplace");String a8=rs.getString("edu");
String a9=rs.getString("nation");String a10 =rs.getString("officetel");String a11=rs.getString("mobile");String a12=rs.getString("hometel");
String a13=rs.getString("certificatetype");String a14=rs.getString("certificateno");String a15=rs.getString("email");String a16=rs.getString("politicalstatus");
String a17=rs.getString("aboardtime");String a18=rs.getString("visano");String a19=rs.getString("speciality");String a20=rs.getString("studyabroad_country");
String a21=rs.getString("company");String a22=rs.getString("studyabroad_type");String a23=rs.getString("address");String a24=rs.getString("company_addr");
String a25=rs.getString("finishschool");String a26=rs.getString("remark");String a27=rs.getString("photo");String a28=rs.getString("inputtime");
String a29=rs.getString("inputmancode");String a30=rs.getString("impman");String a31=rs.getString("addtime");String a32=rs.getString("edittime");
String a33=rs.getString("preserve1"); String a34=rs.getString("preserve2");String a35=rs.getString("preserve3");String a36=rs.getString("preserve4");
String a37=rs.getString("preserve5"); String a38=rs.getString("comments");String a39=rs.getString("datasrc"); String a40=rs.getString("cnname_pinyin");
String a41=rs.getString("oldenname_pinyin");
str=a0+","+a1+","+a2+","+a3+","+a4+","+a5+","+a6+","+a7+","+a8+","+a9+","+a10+","
+a11+","+a12+","+a13+","+a14+","+a15+","+a16+","+a17+","+a18+","+a19+","+a20+","
+a21+","+a22+","+a23+","+a24+","+a25+","+a26+","+a27+","+a28+","+a29+","+a30+","
+a31+","+a32+","+a33+","+a34+","+a35+","+a36+","+a37+","+a38+","+a39+","+a40+","+a41;
%>
<tr>
<td><%=a0%></td>
<td><%=a1%></td>
<td><%=a2%></td>
<td><%=a3%></td>
<td><%=a4%></td>
<td><%=a5%></td>
<td><%=a6%></td>
<td><input type="radio" id="radio" name="radio" onclick="radio()" value="<%=str%>"></td>
</tr>
<%}
rs.close();
db.closeStmt();
db.closeConn();
}catch(Exception exc1){
System.out.println("在执行数据库访问时发生了错误！");
exc1.printStackTrace();
}
%>
</table>
<form id="form1" name="form1" method="post" action="news.jsp">
<table width="100%" border="0">
<tr>
<td>数据id</td>
<td><input name="dataid" type="text" id="dataid" size="10" maxlength="10" /></td>
<td>序号:</td>
<td><label>
<input name="id" type="text" id="id" size="10" maxlength="10" />
</label></td>
<td>中文姓名:</td>
<td><input name="cnname" type="text" id="cnname" size="10" maxlength="50" /></td>
<td>用户密码:</td>
<td><input name="password" type="text" id="password" size="10" maxlength="20" /></td>
</tr>
<tr>
<td>曾用外文名:</td>
<td><input name="oldenname" type="text" id="oldenname" size="10" maxlength="50" /></td>
<td>性别:</td>
<td><input name="sex" type="text" id="sex" size="10" maxlength="10" /></td>
<td>出生年月:</td>
<td><input name="birthday" type="text" id="birthday" size="10" maxlength="10" /></td>
<td>籍贯:</td>
<td><input name="nativeplace" type="text" id="nativeplace" size="10" maxlength="50" /></td>
</tr>
<tr>
<td>学历:</td>
<td><input name="edu" type="text" id="edu" size="10" maxlength="50" /></td>
<td>民族:</td>
<td><input name="nation" type="text" id="nation" size="10" maxlength="50" /></td>
<td>办公电话</td>
<td><input name="officetel" type="text" id="officetel" size="10" maxlength="50" /></td>
<td>移动电话</td>
<td><input name="mobile" type="text" id="mobile" size="10" maxlength="50" /></td>
</tr>
<tr>
<td>住宅电话</td>
<td><input name="hometel" type="text" id="hometel" size="10" maxlength="50" /></td>
<td>证件种类</td>
<td><input name="certificatetype" type="text" id="certificatetype" size="10" maxlength="50" /></td>
<td>证件号码</td>
<td><input name="certificateno" type="text" id="certificateno" size="10" maxlength="50" /></td>
<td>电子邮箱</td>
<td><input name="email" type="text" id="email" size="10" maxlength="100" /></td>
</tr>
<tr>
<td>政治面貌</td>
<td><input name="politicalstatus" type="text" id="politicalstatus" size="10" maxlength="50" /></td>
<td height="20">出境时间</td>
<td><input name="aboardtime" type="text" id="aboardtime" size="10" maxlength="50" /></td>
<td>签证号码</td>
<td><input name="visano" type="text" id="visano" size="10" maxlength="50" /></td>
<td>所学专业</td>
<td><input name="speciality" type="text" id="speciality" size="10" maxlength="50" /></td>
</tr>
<tr>
<td>留学国家</td>
<td><input name="studyabroad_country" type="text" id="studyabroad_country" size="10" maxlength="50" /></td>
<td height="15"> 所在单位</td>
<td><input name="company" type="text" id="company" size="10" maxlength="100" /></td>
<td>留学类别</td>
<td><input name="studyabroad_type" type="text" id="studyabroad_type" size="10" maxlength="50" /></td>
<td>家庭地址</td>
<td><input name="address" type="text" id="address" value="" size="10" /></td>
</tr>
<tr>
<td>单位地址</td>
<td><input name="company_addr" type="text" id="company_addr" size="10" maxlength="100" /></td>
<td height="15">毕业学校</td>
<td><input name="finishschool" type="text" id="finishschool" size="10" maxlength="100" /></td>
<td>备注</td>
<td><input name="remark" type="text" id="remark" size="10" maxlength="200" /></td>
<td>照片</td>
<td><input name="photo" type="text" id="photo" size="10" maxlength="200" /></td>
</tr>
<tr>
<td>录入时间</td>
<td><input name="inputtime" type="text" id="inputtime" size="10" maxlength="50" /></td>
<td>录入人员代码</td>
<td><input name="inputmancode" type="text" id="inputmancode" size="10" maxlength="50" /></td>
<td height="15">录入人</td>
<td><input name="impman" type="text" id="impman" size="10" /></td>
<td>增加时间</td>
<td><input name="addtime" type="text" id="addtime" size="10" /></td>
</tr>
<tr>
<td>修改时间</td>
<td><input name="edittime" type="text" id="edittime" size="10" /></td>
<td>出生年月</td>
<td><input name="preserve1" type="text" id="preserve1" size="10" /></td>
<td height="15">留学国家(原)</td>
<td><input name="preserve2" type="text" id="preserve2" size="10" /></td>
<td>预留3</td>
<td><input name="preserve3" type="text" id="preserve3" size="10" /></td>
</tr>
<tr>
<td>预留4</td>
<td><input name="preserve4" type="text" id="preserve4" size="10" /></td>
<td>预留5</td>
<td><input name="preserve5" type="text" id="preserve5" size="10" /></td>
<td height="15">注释</td>
<td><input name="comments" type="text" id="comments" size="10" /></td>
<td>数据来源</td>
<td><input name="datasrc" type="text" id="datasrc" size="10" /></td>
</tr>
<tr>
<td>中文姓名_拼音</td>
<td><input name="cnname_pinyin" type="text" id="cnname_pinyin" size="10" /></td>
<td>曾用外文名_拼音</td>
<td><input name="oldenname_pinyin" type="text" id="oldenname_pinyin" size="10" /></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<table align="center">
<tr>
<td colspan="2"> <input type="hidden" name="c" id="c">
<input type="hidden" id="dataid" name="dataid">
<input type="text" id="in" name="in" value="">
<input type="submit" name="edt" value="修改个人信息" onclick="btnClick('edt')">
<input type="button" name="ret" value="返回" onclick="history.go(-1)">
<input type="button" onClick="window.opener = '';window.close();" value="关闭" >
</td>
</tr>
</table>
</form>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -