📄 fxdelete.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<form name=form1 action="" method=post>
<script langauge=javascript>
for(i=1;i<=20;i++)
{
document.writeln("<input type=checkbox name=ktid value=\""+ i +"\"><label for=ktid" + i + ">选择"+ i +"</label><br>");
}
</script>
<HTML>
<BODY>
<%
Connection con;
Statement sql;
ResultSet rs;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (ClassNotFoundException e) {
out.print("类找不到！");
}
con = DriverManager
.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=kaoshi",
"sa", "");
sql = con.createStatement();
//序号
String sqlString1 = null;
sqlString1 = new String(" declare @i int Set @i = 0 update kaotiji Set @i = @i + 1,kt_bh = @i");
Statement stmt1 = con.createStatement();
stmt1.executeUpdate(sqlString1);
//序号
//复选框...........................
String sqlString = null;
String ktid[]=request.getParameterValues("ktid");
//后的
if (ktid != null) {
int size=ktid.length;
out.println("您选中了" + size + "项，分别为：<br>");
for (int i = 0; i < size; i++)
{
out.println(ktid[i] + "<br>");
sqlString = new String("delete from kaotiji where kt_bh='"+ ktid[i].trim() + "' ");
Statement stmt = con.createStatement();
stmt.executeUpdate(sqlString);
}
out.print("<script>alert('删除成功！');document.location='fxdelete.jsp';</script>");
}
//复选框...........................
rs = sql.executeQuery("select * from kaotiji"); //取数据库................
// rs.last();
// int rowNumber=rs.getRow();
out.println("<table width='770' border='3' align='center'>");
out.print("<TR><td>查询条件:</td>");
out.print("<td colspan=7>");
out.print("<input type=submit value=提交 name=submit>");
out.print("</td></tr></form>");
// out.print("<TR><td colspan=8 align=center>用户数据(共"+rowNumber+"条记录)</td></tr>");
out.println("<tr>");
out.println("<table width='770' border='3' align='center'>");
out.println("<tr>");
out.println("<td width='100'><b>123操作:</b></td>");
out.println("<td width='100'><b>考题ID号:</b></td>");
out.println("<td width='100'><b>题目ID号:</b></td>");
out.println("<td width='100'><b>题目类型:</b></td>");
out.println("<td width='100'><b>题目分值:</b></td>");
out.println("<td width='100'><b>题目编号:</b></td>");
out.println("<td width='100'><b>题目其他:</b></td>");
%>
<%
int hao = 1;
// rs.beforeFirst();
while (rs.next()) {
out.println("<tr>");
String stri = new String();
stri = rs.getString(1);
out.print("<td><a href='zujuan1.jsp?tk_id=" + stri
+ "'>12入库</a></td>");
//out.print("<td><input type=checkbox name=id value=stri</td>");
//out.println("<td>" +stri+ "</td>");
%>
<td><%=hao%></td>
<%
out.println("<td>" + rs.getString(2) + "</td>");
out.println("<td>" + rs.getString(3) + "</td>");
out.println("<td>" + rs.getString(4) + "</td>");
out.println("<td>" + rs.getString(11) + "</td>");
%>
<td><input type="checkbox" name="checkbox" value="1"></td>
<%
hao++;
}
%>
<%
con.close();
%>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -