?? 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 + -