📄 lbxx.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title> 教师基本信息修改</title>
</head>
<body>
<center>教师基本信息</center>
<hr>
<center>教师基本信息修改</center><br>
<hr>
<div align="center">
<center>
<form action="genggai.jsp" method="post">
<%
String d=(String)session.getAttribute("nana");
Connection con=null;
Statement statement=null;
ResultSet rset=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:a");
statement=con.createStatement();
rset=statement.executeQuery("select * from jbxx2 WHERE name= '"+d+"'");
%>
<table border="1" width="85%">
<tr>
<td>用 户 名</td>
<td>姓 名</td>
<td>性 别</td>
<td>身份证号</td>
<td>出生日期</td>
<td>婚姻状况</td>
<td>毕业学校</td>
<td>所学专业</td>
<td>最后学历</td>
<td>已获最高学位</td>
<td>获最高学位时间</td>
<td>工作时间</td>
<td>工作单位</td>
<td>职 务</td>
<td>职 称</td>
<td>从事专业</td>
<td>通信地址</td>
<td>邮 编</td>
<td>电子邮箱</td>
</tr>
<%
while(rset.next())
{
%>
<tr>
<td><%= rset.getString("name") %> <p> <INPUT type="text" name="id" size="15"><font color="red"></td>
<td><%= rset.getString("yourname") %> <p> <INPUT type="text" name="fullname" size="8"><font color="red"></td>
<td><%= rset.getString("yourSex") %> <p> <INPUT type="text" name="sex" size="4"><font color="red"></td>
<td><%= rset.getString("yourcardnumber") %> <p> <INPUT type="text" name="idc" size="20"><font color="red"></td>
<td><%= rset.getString("yourbirthday") %> <p> <INPUT type="text" name="ct" size="15"><font color="red"></td>
<td><%= rset.getString("maritalstatus") %> <p> <INPUT type="text" name="marry" size="4"><font color="red"></td>
<td><%= rset.getString("graduateschool") %> <p> <INPUT type="text" name="school" size="18"><font color="red"></td>
<td><%= rset.getString("professionlearn") %> <p> <INPUT type="text" name="zy" size="20"><font color="red"></td>
<td><%= rset.getString("finallyeducationbackground") %> <p> <INPUT type="text" name="xl" size="20"><font color="red"></td>
<td><%= rset.getString("tallestdegree") %> <p> <INPUT type="text" name="xw" size="20"><font color="red"> </td>
<td><%= rset.getString("tallestdegreetime") %> <p> <INPUT type="text" name="time" size="14"><font color="red"></td>
<td><%= rset.getString("worktime") %> <p> <INPUT type="text" name="wtime" size="14"><font color="red"></td>
<td><%= rset.getString("workunit") %> <p> <INPUT type="text" name="work" size="16"><font color="red"></td>
<td><%= rset.getString("job") %> <p> <INPUT type="text" name="zw" size="12"><font color="red"> </td>
<td><%= rset.getString("title") %> <p> <INPUT type="text" name="zc" size="12"><font color="red"> </td
><td><%= rset.getString("profession") %> <p> <INPUT type="text" name="sy" size="16"><font color="red"> </td>
<td><%= rset.getString("letteraddress") %> <p> <INPUT type="text" name="tx" size="24"><font color="red"> </td>
<td><%= rset.getString("weave") %> <p> <INPUT type="text" name="yb" size="10"><font color="red"></td>
<td><%= rset.getString("youremal") %> <p> <INPUT type="text" name="Email" size="26"><font color="red"></td>
</tr>
<%
}
%>
</table>
<%
rset.close();
statement.close();
con.close();
%>
<p>
<p>
<p>
<p>
<p>
<div align="center">
<input type="submit" value="提交">
</div>
<hr>
<center>谢谢光临</center><br>
<% con.close(); %>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -