📄 xiugai4_deal.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");
}
%>
<%
request.setCharacterEncoding("gb2312");
String rsadd__MMColParam3 = "楼";
if (request.getParameter("tfKeywords3") !="") {
rsadd__MMColParam3 = (String)request.getParameter("tfKeywords3");
}
%>
<%
request.setCharacterEncoding("gb2312");
String rsadd__MMColParam4 = "楼";
if (request.getParameter("tfKeywords4") !="") {
rsadd__MMColParam4 = (String)request.getParameter("tfKeywords4");
}
%>
<%
request.setCharacterEncoding("gb2312");
String rsadd__MMColParam5 = "楼";
if (request.getParameter("tfKeywords5") !="") {
rsadd__MMColParam5 = (String)request.getParameter("tfKeywords5");
}
%>
<%
request.setCharacterEncoding("gb2312");
String rsadd__MMColParam6 = "￥";
if (request.getParameter("tfKeywords1") !="") {
rsadd__MMColParam6 = (String)request.getParameter("tfKeywords6");
}
%>
<%
request.setCharacterEncoding("gb2312");
String rsadd__MMColParam7 = "楼";
if (request.getParameter("tfKeywords2") !="") {
rsadd__MMColParam7 = (String)request.getParameter("tfKeywords7");
}
%>
<%
request.setCharacterEncoding("gb2312");
String rsadd__MMColParam8 = "楼";
if (request.getParameter("tfKeywords3") !="") {
rsadd__MMColParam8 = (String)request.getParameter("tfKeywords8");
}
%>
<%
request.setCharacterEncoding("gb2312");
String rsadd__MMColParam9 = "楼";
if (request.getParameter("tfKeywords9") !="") {
rsadd__MMColParam9 = (String)request.getParameter("tfKeywords9");
}
%>
<%
String sql="UPDATE dbo.TItable set Tnum='"+ rsadd__MMColParam1 +"',Name='"+ rsadd__MMColParam2 +"',Subject='"+ rsadd__MMColParam3 +"',Stime='"+ rsadd__MMColParam4 +"',Classroom='"+ rsadd__MMColParam5 +"',Class='"+ rsadd__MMColParam6 +"',Other='"+ rsadd__MMColParam7 +"' where(Tnum='"+ rsadd__MMColParam8 +"' and Name='"+ rsadd__MMColParam9 +"')";
%>
<%
Driver Driverrsadd = (Driver)Class.forName(MM_connection_DRIVER).newInstance();
Connection Connrsadd = DriverManager.getConnection(MM_connection_STRING,MM_connection_USERNAME,MM_connection_PASSWORD);
Statement Statementrsadd = Connrsadd.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
Statementrsadd.executeUpdate(sql);
%>
<html>
<!-- DW6 -->
<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}
.STYLE15 {color: #993300}
-->
</style>
</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>
<table align="center" vwidth="776" height="313" border="1">
<tr valign="top">
<td width="450" height="307"> <img src="../../images/main1.JPG"></td>
<td width="299"><p> </p>
<p> </p>
<p align="center" class="subHeader STYLE14">恭喜您，修改成功！</p>
</form>
<p align="right"> </p>
<p align="right"> </p>
<p align="right" class="subHeader"><span class="STYLE15"><span class="STYLE13"><a href="../xiugai.html" class="STYLE9 STYLE13">继续修改</a></span></span></p>
<p align="right"> <span class="subHeader STYLE13 STYLE15"><a href="../../main.jsp" class="STYLE9 STYLE13"> 返回主页面</a> </span></p>
</tr>
</table>
</body>
</html>
<%
Connrsadd.close();
Statementrsadd.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -