?? upddata.jsp
字號:
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.lang.*" %>
<%@ page language="java" %>
<!--<%@ include file="Conn.jsp" %>-->
<HTML>
<HEAD>
<TITLE>修改課題</TITLE>
</HEAD>
<BODY bgcolor=pink>
<CENTER>
<FONT SIZE = 5 COLOR = blue>修改數(shù)據(jù)</FONT>
</CENTER>
<BR>
<HR>
<BR>
<%
Connection con;
ResultSet rs;
try{
Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
con=DriverManager.getConnection("jdbc:sybase:Tds:192.168.103.73:5000/jwgl","sa","jw123456");
//建立Statement變量, 并設(shè)定記錄指標(biāo)類型為可前後移
PreparedStatement stmt = null;
String aa =request.getParameter("tmpbm");
String sql1="SELECT scbz FROM jw_xs_lwkt where bm='"+aa+"'";
stmt = con.prepareStatement(sql1);
rs=stmt.executeQuery();
/**while(rs.next()){
String scbz=rs.getString("scbz");
out.println("aaaaaaaaaa"+scbz);
if(scbz.equals("1"))
{
out.println("提示：修改時(shí)間已過,您不能對課題信息進(jìn)行修改!!!");
}else
{out.println("qqqqqqq"+scbz);}*/
String Submit =request.getParameter("submit1"); //取得指令按鈕傳出的數(shù)據(jù)
//判斷是否可取得表單中指令按鈕的傳出值
if(Submit == null)
{
stmt.close();
String sql="SELECT * FROM jw_xs_lwkt where bm='"+aa+"'";
stmt = con.prepareStatement(sql);
rs=stmt.executeQuery();
while(rs.next())
{ String scbz=rs.getString("scbz");
out.println("ddddddddddddddd"+scbz);
if(scbz.equals("1"))
{
out.println("提示：修改時(shí)間已過,您不能對課題信息進(jìn)行修改!!!");
}else
{out.println("qqqqqqq"+scbz);
%>
<CENTER>
<TABLE bgcolor=DodgerBlue>
<TR bgcolor=SkyBlue>
<TD><B>編 號</B></TD>
<TD><B>課題名稱</B></TD>
<TD><B>學(xué)年度</B></TD>
<TD><B>學(xué)期</B></TD>
<TD><B>年級</B></TD>
<TD><B>適用專業(yè)代碼</B></TD>
<TD><B>開題系所代碼</B></TD>
<TD><B>實(shí)際選中人數(shù)</B></TD>
<TD><B>限定人數(shù)</B></TD></TR>
<%
//利用while循環(huán)配合next方法將數(shù)據(jù)表中的記錄列出
/**while(rs.next())
{ String scbz=rs.getString("scbz");
out.println("ddddddddddddddd"+scbz);
if(scbz.equals("0"))
{
out.println("提示：修改時(shí)間已過,您不能對課題信息進(jìn)行修改!!!");
}else
{out.println("qqqqqqq"+scbz);*/
%>
<TR>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("bm") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("ktmc") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("xnd") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("xq") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("nj") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("zym") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("kxsm") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("sjxzhrs") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("xzrs") %></B></TD>
</TR>
<%
%>
</TABLE>
</CENTER>
<BR>
<CENTER>
<P><FONT SIZE = 4 COLOR = red>請輸入課題編號，以及后來的數(shù)據(jù)
</FONT></P>
<FORM action="UpdData.jsp" method=POST id=form2 name=form2>
編號: <INPUT type="text" name=tmpbhID><BR>
課題中文名稱:<INPUT type="text" name=tmpktmc><BR>
開題系所碼:<INPUT type="text" name=tmpkxsm><BR>
限定人數(shù):<INPUT type="text" name=tmpxzrs><BR><br>
<INPUT type="submit" value="修改" name=submit1>
<INPUT type="reset" value="重置" name=submit2>
</FORM></CENTER>
<%
} }
}else
{
String bhid1 = request.getParameter("tmpbhID");
String newkxsm = request.getParameter("tmpkxsm");
String newktmc = request.getParameter("tmpktmc");
int newxzrs =(Integer.valueOf(request.getParameter("tmpxzrs"))).intValue();
stmt.close();
//建立查詢書籍?dāng)?shù)據(jù)的SQL字串
String strSQL="SELECT * FROM jw_xs_lwkt WHERE bm='"+bhid1+"'";
stmt = con.prepareStatement(strSQL);
rs = stmt.executeQuery();
//建立ResultSet對象
if(!rs.next())
{
%>
<CENTER>
<P>找不到編號為
<FONT SIZE = 4 COLOR = red>
<%= bhid1 %>
</FONT>的數(shù)據(jù)<P>
<%
}
else
{ stmt.close();
String strUpd="UPDATE jw_xs_lwkt SET xzrs = ?,kxsm=?,ktmc=? WHERE bm =?";
stmt = con.prepareStatement(strUpd);
stmt.setInt(1,newxzrs);
stmt.setString(2,newkxsm);
stmt.setString(3,newktmc);
stmt.setString(4,bhid1);
stmt.executeUpdate();
stmt.close();
String ssss="SELECT * FROM jw_xs_lwkt WHERE bm=?";
stmt = con.prepareStatement(ssss);
stmt.setString(1,bhid1);
rs = stmt.executeQuery(); //執(zhí)行SQL語句取得修改后的書籍?dāng)?shù)據(jù)
rs.next(); //移至第一筆記錄
%>
<CENTER>
<H3><P><FONT SIZE = 5 COLOR = red>
<%= bhid1%>
</FONT>
修改后的詳細(xì)數(shù)據(jù)如下:</P></H3>
<TABLE bgcolor=DodgerBlue>
<TR bgcolor=SkyBlue><TD><B>編號</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("bm") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>課題名稱</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("ktmc") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>學(xué)年度</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("xnd") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>學(xué)期</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("xq") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>年級</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("nj") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>適用專業(yè)碼</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("zym") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>開題系所碼</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("kxsm") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>實(shí)際選中人數(shù)</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("sjxzhrs") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>限定人數(shù)</B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("xzrs") %></B></TD></TR>
</TABLE>
<%
}
%>
<%
out.println("aaaaaaaaaaaaaaa");
%>
<P><A HREF = Updatekt.jsp>還要進(jìn)行修改</A></P></CENTER>
<%
con.close();
stmt.close();
rs.close();
}
}catch(SQLException e){}
%>
</BODY>
</HTML>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -