📄 xiugai3.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.*"%>
<%@ 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.YItable WHERE Tnum='" + rsadd__MMColParam1 + "'";
}else
{sql = "SELECT * FROM dbo.YItable 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 align="center"width="766" height="158" border="0">
<form name="form1" action="xiugai3_deal.jsp" method="post">
<tr>
<td height="35" class="subHeader"> </td>
<td class="subHeader"> </td>
<td class="subHeader"> </td>
<td class="subHeader"> </td>
<td class="subHeader"> </td>
<td class="subHeader" align="right"><input type="submit" name="Submit" value="修改">
<input name="Submit2" type="reset" value="重置"></td>
</tr>
<tr>
<td width="79" height="27" class="subHeader">教师编号：</td>
<td width="168" class="subHeader"><input type="text" name="tfKeywords1" value="<%=rs.getObject("Tnum")%>"></td>
<td width="80" class="subHeader">教师姓名：</td>
<td width="168" class="subHeader"><input type="text" name="tfKeywords2" value="<%=rs.getObject("Name")%>"></td>
<td width="77" class="subHeader">获奖年度： </td>
<td width="168" class="subHeader"><input type="text" name="tfKeywords3" value="<%=rs.getObject("Hyear")%>"></td>
</tr>
<tr>
<td height="35" class="subHeader">奖励种类：</td>
<td class="subHeader"><input type="text" name="tfKeywords4" value="<%=rs.getObject("Jlei")%>"></td>
<td class="subHeader">项目名称：</td>
<td class="subHeader"><input type="text" name="tfKeywords5" value="<%=rs.getObject("Hname")%>"></td>
<td class="subHeader">等次：</td>
<td class="subHeader"><input type="text" name="tfKeywords6" value="<%=rs.getObject("Dci")%>"></td>
</tr>
<tr>
<td height="35" class="subHeader">排名：</td>
<td height="35" class="subHeader"><input type="text" name="tfKeywords7" value="<%=rs.getObject("Pming")%>"></td>
</tr>
<tr>
<td height="35" class="subHeader">搜索条件：</td>
<td class="subHeader"><input type="text" name="tfKeywords8" value="<%=rsadd__MMColParam1%>"></td>
<td class="subHeader"> </td>
<td class="subHeader"><input type="text" name="tfKeywords9" value="<%=rsadd__MMColParam2%>"></td>
<td class="subHeader"> </td>
<td class="subHeader"> </td>
</tr>
</form>
</table>
<table width="761" border="0" align="center">
<tr>
<td height="72"> </td>
</tr>
</table>
</body>
</html>
<%
Connrsselect.close();
Statementrsselete.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -