daoru.jsp

来自「这是一个在线考试系统」· JSP 代码 · 共 47 行

JSP

47 行

<%@ 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 + =

减小字号Ctrl + -

显示快捷键?

daoru.jsp

daoru.jsp - 源码说明

⌨️ 快捷键说明