📄 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>修改数据</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变量, 并设定记录指标类型为可前後移
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("提示：修改时间已过,您不能对课题信息进行修改!!!");
}else
{out.println("qqqqqqq"+scbz);}*/
String Submit =request.getParameter("submit1"); //取得指令按钮传出的数据
//判断是否可取得表单中指令按钮的传出值
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("提示：修改时间已过,您不能对课题信息进行修改!!!");
}else
{out.println("qqqqqqq"+scbz);
%>
<CENTER>
<TABLE bgcolor=DodgerBlue>
<TR bgcolor=SkyBlue>
<TD><B>编 号</B></TD>
<TD><B>课题名称</B></TD>
<TD><B>学年度</B></TD>
<TD><B>学期</B></TD>
<TD><B>年级</B></TD>
<TD><B>适用专业代码</B></TD>
<TD><B>开题系所代码</B></TD>
<TD><B>实际选中人数</B></TD>
<TD><B>限定人数</B></TD></TR>
<%
//利用while循环配合next方法将数据表中的记录列出
/**while(rs.next())
{ String scbz=rs.getString("scbz");
out.println("ddddddddddddddd"+scbz);
if(scbz.equals("0"))
{
out.println("提示：修改时间已过,您不能对课题信息进行修改!!!");
}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>请输入课题编号，以及后来的数据
</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>
限定人数:<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();
//建立查询书籍数据的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>的数据<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(); //执行SQL语句取得修改后的书籍数据
rs.next(); //移至第一笔记录
%>
<CENTER>
<H3><P><FONT SIZE = 5 COLOR = red>
<%= bhid1%>
</FONT>
修改后的详细数据如下:</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>学年度</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("xnd") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>学期</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>适用专业码</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>实际选中人数</B></TD>
<TD bgcolor=LightGoldenrodYellow><B>
<%= rs.getString("sjxzhrs") %></B></TD></TR>
<TR bgcolor=SkyBlue><TD><B>限定人数</B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("xzrs") %></B></TD></TR>
</TABLE>
<%
}
%>
<%
out.println("aaaaaaaaaaaaaaa");
%>
<P><A HREF = Updatekt.jsp>还要进行修改</A></P></CENTER>
<%
con.close();
stmt.close();
rs.close();
}
}catch(SQLException e){}
%>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -