📄 xiugai1.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ page import="java.text.*"%>
<%@ include file="../../Connections/connection.jsp" %>
<%
request.setCharacterEncoding("gb2312");
String rsadd__MMColParam1 = "楼";
if (request.getParameter("tfKeywords1") !="") {
rsadd__MMColParam1 = (String)request.getParameter("tfKeywords1");
}
%>
<%
request.setCharacterEncoding("gb2312");
String rsadd__MMColParam2 = "楼";
if (request.getParameter("tfKeywords2") !="") {
rsadd__MMColParam2 = (String)request.getParameter("tfKeywords2");
}
%>
<%
String sql;
if(rsadd__MMColParam1!=""){
sql = "SELECT * FROM dbo.BItable WHERE Tnum='" + rsadd__MMColParam1 + "'";
}else
{sql = "SELECT * FROM dbo.BItable WHERE Name='" + rsadd__MMColParam2 + "'";}
%>
<%
ResultSet rs;
Connection Connrsselect;
Statement Statementrsselete;
Driver Driverrsadd = (Driver)Class.forName(MM_connection_DRIVER).newInstance();
Connrsselect = DriverManager.getConnection(MM_connection_STRING,MM_connection_USERNAME,MM_connection_PASSWORD);
Statementrsselete = Connrsselect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=Statementrsselete.executeQuery(sql);
rs.last();
%>
<head>
<!-- Copyright 2005 Macromedia, Inc. All rights reserved. -->
<title>教师基本信息修改</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../../images/mm_health_nutr.css" type="text/css">
<style type="text/css">
<!--
.STYLE4 {
font-family: "华文新魏";
font-weight: bold;
color: #666600;
font-size: large;
}
.STYLE9 {
color: #660000;
font-weight: bold;
font-size: x-small;
}
.STYLE13 {font-size: 12px}
.STYLE14 {font-size: 18px}
-->
</style>
</head>
</head>
<body bgcolor="#F4FFE4">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#D5EDB3">
<td colspan="3" rowspan="2"><img src="../../images/shenghuoyp_236s.jpg" alt="Header image" width="455" height="92" border="0"></td>
<td height="50" colspan="3" id="logo" valign="bottom" align="center" nowrap><span class="STYLE4">教师档案管理系统</span></td>
<td width="7"> </td>
</tr>
<tr bgcolor="#D5EDB3">
<td height="51" colspan="3" id="tagline" valign="top" align="center"><span class="STYLE9 STYLE13">The Management System Of Teachers File </span></td>
</tr>
<tr>
<td colspan="7" bgcolor="#5C743D"><img src="../../images/mm_spacer.gif" alt="" width="1" height="2" border="0"></td>
</tr>
<tr>
<td colspan="7" bgcolor="#99CC66" background="../../images/mm_dashed_line.gif"><img src="../../images/mm_dashed_line.gif" alt="line decor" width="4" height="3" border="0"></td>
</tr>
<tr bgcolor="#99CC66">
<td colspan="7" id="dateformat" height="20"> </td>
</tr>
<tr>
<td colspan="7" bgcolor="#99CC66" background="../../images/mm_dashed_line.gif"><img src="../../images/mm_dashed_line.gif" alt="line decor" width="4" height="3" border="0"></td>
</tr>
<tr>
<td colspan="7" bgcolor="#5C743D"><img src="../../images/mm_spacer.gif" alt="" width="1" height="2" border="0"></td>
</tr>
</table>
<p align="center" class="STYLE9 STYLE14">修改教师基本信息</p>
<table width="761" border="0" align="center">
<form name="form1" action="xiugai1_deal.jsp" method="post">
<tr>
<td align="right"height="79"><label>
<input type="submit" name="Submit" value="修改" onClick="">
</label>
<label>
<input type="reset" name="Submit2" value="重置">
<br>
</label>
<table width="764" height="253" border="0" align="center">
<tr>
<td width="74" height="27" class="subHeader">教师编号：</td>
<td width="168" class="subHeader">
<input type="text" name="tfKeywords1" value="<%=rs.getInt("Tnum")%>"></td>
<td width="84" class="subHeader">教师姓名：</td>
<td width="170" class="subHeader"><label>
<input type="text" name="tfKeywords2" value="<%=rs.getObject("Name")%>">
</label></td>
<td width="74" class="subHeader">性别：</td>
<td width="168" class="subHeader"><input type="text" name="tfKeywords3" value="<%=rs.getObject("Sex")%>"></td>
</tr>
<tr>
<td height="35" class="subHeader">出生日期：</td>
<td class="subHeader"><input name="tfKeywords4" type="text" value="<%=rs.getObject("Birthday")%>"></td>
<td class="subHeader">民族：</td>
<td class="subHeader"><input name="tfKeywords5" type="text" value="<%=rs.getObject("Mzu")%>"></td>
<td class="subHeader">籍贯：</td>
<td class="subHeader"><input type="text" name="tfKeywords6" value="<%=rs.getObject("Home")%>"></td>
</tr>
<tr>
<td height="33" class="subHeader">职务：</td>
<td class="subHeader"><input type="text" name="tfKeywords7" value="<%=rs.getObject("Zwu")%>"></td>
<td class="subHeader">职称
：</td>
<td class="subHeader"><input type="text" name="tfKeywords8" value="<%=rs.getObject("Zcheng")%>"></td>
<td class="subHeader">最高学历：</td>
<td class="subHeader"><input type="text" name="tfKeywords9" value="<%=rs.getObject("Highests")%>"></td>
</tr>
<tr>
<td height="34" class="subHeader">健康状况：</td>
<td class="subHeader"><input type="text" name="tfKeywords10" value="<%=rs.getObject("Health")%>"></td>
<td class="subHeader">身高：</td>
<td class="subHeader"><input type="text" name="tfKeywords11" value="<%=rs.getObject("Height")%>"></td>
<td class="subHeader">体重：</td>
<td class="subHeader"><input type="text" name="tfKeywords12" value="<%=rs.getObject("Weight")%>"></td>
</tr>
<tr>
<td height="35" class="subHeader">血型：</td>
<td class="subHeader"><input type="text" name="tfKeywords13" value="<%=rs.getObject("Blood")%>"></td>
<td class="subHeader">身份证号：</td>
<td class="subHeader"><input type="text" name="tfKeywords14" value="<%=rs.getObject("ID")%>"></td>
<td class="subHeader">居住地址：</td>
<td class="subHeader"><input type="text" name="tfKeywords15" value="<%=rs.getObject("Address")%>"></td>
</tr>
<tr>
<td height="35" class="subHeader">联系电话：</td>
<td class="subHeader"><input type="text" name="tfKeywords16" value="<%=rs.getObject("Telephone")%>"></td>
<td class="subHeader">通信地址：</td>
<td class="subHeader"><input type="text" name="tfKeywords17" value="<%=rs.getObject("Postaddress")%>"></td>
<td class="subHeader">E-mail：</td>
<td class="subHeader"><input type="text" name="tfKeywords18" value="<%=rs.getObject("Email")%>"></td>
</tr>
<tr>
<td height="38" class="subHeader">所教学科：</td>
<td height="38" class="subHeader"><input type="text" name="tfKeywords19" value="<%=rs.getObject("Subjects")%>"></td>
</tr>
<tr>
<td height="35" class="subHeader">搜索条件：</td>
<td class="subHeader"><input type="text" name="tfKeywords20" value="<%=rsadd__MMColParam1%>"></td>
<td class="subHeader"> </td>
<td class="subHeader"><input type="text" name="tfKeywords21" value="<%=rsadd__MMColParam2%>"></td>
<td class="subHeader"> </td>
<td class="subHeader"> </td>
</tr>
</table></td>
</tr>
</form>
</table>
</body>
</html>
<%
Connrsselect.close();
Statementrsselete.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -