📄 m_modify.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page contentType="text/html; charset=GB2312"%>
<jsp:directive.page import="java.sql.ResultSet"/>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'M_add.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<jsp:useBean id="db" scope="session" class="news.sql_data"/>
<link rel="stylesheet" href="m_style.css" type="text/css">
<body>
<%
request.setCharacterEncoding("gb2312");
//时间格式
java.text.SimpleDateFormat formatter=new java.text.SimpleDateFormat("yyyy-MM-dd");
String dataid=request.getParameter("dataid");
String mysql = "select * from news_table where dataid="+dataid;
ResultSet rs1= db.executeQuery(mysql);
rs1.next();
%>
<form id="form1" name="form1" method="post" action="manager/M_modify2.jsp">
<table width="100%" border="0">
<tr><td colspan="8" align="center"><h3>修改用户信息</h3></td></tr>
<tr>
<td>数据id</td>
<td><input name="dataid" type="text" id="dataid" size="10" maxlength="10" value="<%=rs1.getString("dataid") %>" /></td>
<td>序号:</td>
<td><label>
<input name="id" type="text" id="id" size="10" maxlength="10" value="<%=rs1.getString("id") %>" />
</label></td>
<td>中文姓名:</td>
<td><input name="cnname" type="text" id="cnname" size="10" maxlength="50" value="<%=rs1.getString("cnname") %>"/></td>
<td>用户密码:</td>
<td><input name="password" type="text" id="password" size="10" maxlength="20" value="<%=rs1.getString("password") %>"/></td>
</tr>
<tr>
<td>曾用外文名:</td>
<td><input name="oldenname" type="text" id="oldenname" size="10" maxlength="50" value="<%=rs1.getString("oldenname") %>"/></td>
<td>性别:</td>
<td><input name="sex" type="text" id="sex" size="10" maxlength="10" value="<%=rs1.getString("sex") %>"/></td>
<td>出生年月:</td>
<td><input name="birthday" type="text" id="birthday" size="10" maxlength="10" value="<%=rs1.getString("birthday") %>"/></td>
<td>籍贯:</td>
<td><input name="nativeplace" type="text" id="nativeplace" size="10" maxlength="50" value="<%=rs1.getString("nativeplace") %>" /></td>
</tr>
<tr>
<td>学历:</td>
<td><input name="edu" type="text" id="edu" size="10" maxlength="50" value="<%=rs1.getString("edu") %>" /></td>
<td>民族:</td>
<td><input name="nation" type="text" id="nation" size="10" maxlength="50" value="<%=rs1.getString("nation") %>"/></td>
<td>办公电话</td>
<td><input name="officetel" type="text" id="officetel" size="10" maxlength="50" value="<%=rs1.getString("officetel") %>"/></td>
<td>移动电话</td>
<td><input name="mobile" type="text" id="mobile" size="10" maxlength="50" value="<%=rs1.getString("mobile") %>" /></td>
</tr>
<tr>
<td>住宅电话</td>
<td><input name="hometel" type="text" id="hometel" size="10" maxlength="50" value="<%=rs1.getString("hometel") %>" /></td>
<td>证件种类</td>
<td><input name="certificatetype" type="text" id="certificatetype" size="10" maxlength="50" value="<%=rs1.getString("certificatetype") %>"/></td>
<td>证件号码</td>
<td><input name="certificateno" type="text" id="certificateno" size="10" maxlength="50" value="<%=rs1.getString("certificateno") %>"/></td>
<td>电子邮箱</td>
<td><input name="email" type="text" id="email" size="10" maxlength="100" value="<%=rs1.getString("email") %>"/></td>
</tr>
<tr>
<td>政治面貌</td>
<td><input name="politicalstatus" type="text" id="politicalstatus" size="10" maxlength="50" value="<%=rs1.getString("politicalstatus") %>"/></td>
<td height="20">出境时间</td>
<td><input name="aboardtime" type="text" id="aboardtime" size="10" maxlength="50" value="<%=rs1.getString("aboardtime") %>" /></td>
<td>签证号码</td>
<td><input name="visano" type="text" id="visano" size="10" maxlength="50" value="<%=rs1.getString("visano") %>"/></td>
<td>所学专业</td>
<td><input name="speciality" type="text" id="speciality" size="10" maxlength="50" value="<%=rs1.getString("speciality") %>"/></td>
</tr>
<tr>
<td>留学国家</td>
<td><input name="studyabroad_country" type="text" id="studyabroad_country" size="10" maxlength="50" value="<%=rs1.getString("studyabroad_country") %>" /></td>
<td height="15"> 所在单位</td>
<td><input name="company" type="text" id="company" size="10" maxlength="100" value="<%=rs1.getString("company") %>" /></td>
<td>留学类别</td>
<td><input name="studyabroad_type" type="text" id="studyabroad_type" size="10" maxlength="50"
value="<%=rs1.getString("studyabroad_type") %>" /></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" value="<%=rs1.getString("company_addr") %>" /></td>
<td height="15">毕业学校</td>
<td><input name="finishschool" type="text" id="finishschool" size="10" maxlength="100" value="<%=rs1.getString("finishschool") %>" /></td>
<td>备注</td>
<td><input name="remark" type="text" id="remark" size="10" maxlength="200" value="<%=rs1.getString("remark") %>" /></td>
<td>照片</td>
<td><input name="photo" type="text" id="photo" size="10" maxlength="200" value="<%=rs1.getString("photo") %>" /></td>
</tr>
<tr>
<td>录入时间</td>
<td></td>
<td>录入人员代码</td>
<td><%=rs1.getString("inputmancode") %> </td>
<td height="15">录入人</td>
<td><%=rs1.getString("impman") %></td>
<td>增加时间</td>
<td><%=formatter.format(rs1.getDate("addtime")) %></td>
</tr>
<tr>
<% Date curDate=new Date(new java.util.Date().getTime());
String time=curDate.toLocaleString();
%>
<td>修改时间</td>
<td><input name="edittime" type="text" id="edittime" size="10" value="<%=time %>" /></td>
<td>出生年月</td>
<td><input name="preserve1" type="text" id="preserve1" size="10" value="<%=rs1.getString("preserve1") %>" /></td>
<td height="15">留学国家(原)</td>
<td><input name="preserve2" type="text" id="preserve2" size="10" value="<%=rs1.getString("preserve2") %>"/></td>
<td>预留3</td>
<td><input name="preserve3" type="text" id="preserve3" size="10" value="<%=rs1.getString("preserve3") %>"/></td>
</tr>
<tr>
<td>预留4</td>
<td><input name="preserve4" type="text" id="preserve4" size="10" value="<%=rs1.getString("preserve4") %>"/></td>
<td>预留5</td>
<td><input name="preserve5" type="text" id="preserve5" size="10" value="<%=rs1.getString("preserve5") %>" /></td>
<td height="15">注释</td>
<td><input name="comments" type="text" id="comments" size="10" value="<%=rs1.getString("comments") %>"/></td>
<td>数据来源</td>
<td><input name="datasrc" type="text" id="datasrc" size="10" value="<%=rs1.getString("datasrc") %>"/></td>
</tr>
<tr>
<td>中文姓名_拼音</td>
<td><input name="cnname_pinyin" type="text" id="cnname_pinyin" size="10" value="<%=rs1.getString("cnname_pinyin") %>"/></td>
<td>曾用外文名_拼音</td>
<td><input name="oldenname_pinyin" type="text" id="oldenname_pinyin" size="10" value="<%=rs1.getString("oldenname_pinyin") %>"/></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<table align="center">
<tr>
<td colspan="2">
<input type="submit" name="submit" value="提交" >
<input type="reset" name="reset" value="重置" >
<input type="button" name="ret" value="返回" onclick="history.go(-1)">
</td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -