📄 newdatabase.jsp
字号:
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*" %>
<html>
<HEAD><TITLE>添加后的数据</TITLE></HEAD>
<body bgcolor=pink>
<font size=4>
<%
Connection con;
ResultSet rs;
try{Class.forName("com.sybase.jdbc2.jdbc.SybDriver");}
catch(ClassNotFoundException event){
%>
dgafhajadddddddddddddddddddddddddddddddd
<%}
try{
con=DriverManager.getConnection("jdbc:sybase:Tds:192.168.103.184:5000/jwgl","sa","");
//建立Statement变量, 并设定记录指标类型为可前後移
PreparedStatement stmt = null;
out.println("提示:");
String strSQL;
String bh = request.getParameter("tempbh");
String xnd = request.getParameter("tempxnd");
String xq = request.getParameter("tempxq");
String xsdm = request.getParameter("tempxsdm");
String zydm = request.getParameter("tempzydm");
String nj = request.getParameter("tempnj");
String s = request.getParameter("tempsx");
String x = request.getParameter("tempxx");
int sx = (Integer.valueOf(request.getParameter("tempsx"))).intValue();
int xx = (Integer.valueOf(request.getParameter("tempxx"))).intValue();
//建立新增数据至数据库的SQL叙述
strSQL="INSERT INTO jw_xk_xfxx(bh, xnd, xq, xsdm, zydm, nj,sx, xx) Values (?,?,?,?,?,?,?,?)";
stmt = con.prepareStatement(strSQL);
stmt.setString(1,bh);
stmt.setString(2,xnd);
stmt.setString(3,xq);
stmt.setString(4,xsdm);
stmt.setString(5,zydm);
stmt.setString(6,nj);
stmt.setInt(7,sx);
stmt.setInt(8,xx);
stmt.executeUpdate(); //利用SQL叙述将数据新增至数据库
out.println("the second stmt is:");
%>
<P>已将数据新增至jw_xk_xfxx数据表, 该数据表的内容如下:</P>
<% stmt.close();
strSQL = "SELECT * FROM jw_xk_xfxx";
stmt = con.prepareStatement(strSQL);
rs = stmt.executeQuery(); //执行SQL叙述, 从数据库中取得jw_xk_xfxx数据表中的数据
%>
<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>
</TR>
<%
//利用while循环配合next方法将数据表中的记录列出
while(rs.next())
{
%>
<TR>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("bh") %></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("xsdm") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("zydm") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getString("nj") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getInt("sx") %></B></TD>
<TD bgcolor = LightGoldenrodYellow><B>
<%= rs.getInt("xx") %></B></TD>
</TR>
<%
}
%>
</TABLE>
</CENTER>
<BR>
<%
con.close();
stmt.close();
rs.close();
}
catch(SQLException event){
}
%>
<CENTER><P><A HREF = testtianjia.jsp>还要进行添加</A></P></CENTER>
<%
%>
</font>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -