📄 daoru.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();
sqlString1="delete from kaoti where kt_bh in('1','01','001','0001')";
%>
<%
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 + -