📄 shanchucf.jsp
字号:
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<%!public String codeToString(String str) {//处理中文字符串的函数
String s = str;
try {
byte tempB[] = s.getBytes("ISO-8859-1");
s = new String(tempB);
return s;
} catch (Exception e) {
return s;
}
}%>
<HTML>
<BODY>
<%
String sqlString1 = null;//SQL语句
sqlString1 = new String();
String sqlString2 = null;//SQL语句
sqlString2 = new String();
//sqlString1="delete from kaotiji where kt_bh in('1','01','001','0001')";
sqlString2="delete from kaotiji a where (a.tk_id,a.kt_bh) in (select tk_id,kt_bh from kaotiji group by tk_id,kt_bh having count(*)>1) and kt_id not in (select min(kt_id) from kaotiji group by tk_id,kt_bh having count(*)>1)";
//sqlString1=" select * from kaotiji a,(select tk_id,kt_bh from kaotiji group by tk_id,kt_bh having count(*) > 1) b where a.tk_id = b.tk_id and a.kt_bh = b.kt_bh and kt_id not in( select min(kt_id) from kaotiji group by tk_id,kt_bh having count(*) > 1)";
sqlString1="delete from kaoti where tk_id in (select tk_id from kaoti group by tk_id having count(tk_id) > 1) and kt_id not in (select min(kt_id) from kaoti group by tk_id having count(tk_id) > 1)";
%>
<%
Connection con;
Statement sql;
ResultSet rs;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (ClassNotFoundException e) {
out.print("类找不到！");
}
try {
con = DriverManager
.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=kaoshi",
"sa", "");
sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
Statement stmt = con.createStatement();
stmt.executeUpdate(sqlString1);
out.print("<script>alert('清除成功！');document.location='kaotiji.jsp';</script>");
con.close();
} catch (SQLException e1) {
out.print("SQL异常！");
}
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -