<%@ page language="java" import="java.util.*,java.io.*,java.sql.*" pageEncoding="utf-8"%>
<html>
<body>
<%
try{
String tablename =(String)session.getValue("tablename");
String choose[] = request.getParameterValues("box");
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=newtable";
String user = "sa";
String password = "123";
Connection conn = DriverManager.getConnection(url,user,password);
String sql = "delete from " + tablename + "where choose=?";
PreparedStatement ps = conn.prepareStatement(sql);
out.print("哈哈1");
for (int i=0; i <choose.length; i++) {
out.print("哈哈2");
ps.setString(1,choose[i]);
out.print("哈哈3");
ps.executeUpdate();
}
ResultSet rs = ps.executeQuery();
out.print("哈哈4");
response.sendRedirect("newtable.jsp");
} catch (Exception e) {
e.printStackTrace();
}
%>
</body>
</html>
其中的out.print("哈哈*");是为了测试,看哪一步错了,后来执行完了,打出:
哈哈1哈哈2哈哈3 也就是说ps.executeUpdate();没执行呀,且后面说的错误是:“'choose' 附近有语法错误。”要么就是超出索引。
求救~~~~~~~~~~~~~~~~
<html>
<body>
<%
try{
String tablename =(String)session.getValue("tablename");
String choose[] = request.getParameterValues("box");
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=newtable";
String user = "sa";
String password = "123";
Connection conn = DriverManager.getConnection(url,user,password);
String sql = "delete from " + tablename + "where choose=?";
PreparedStatement ps = conn.prepareStatement(sql);
out.print("哈哈1");
for (int i=0; i <choose.length; i++) {
out.print("哈哈2");
ps.setString(1,choose[i]);
out.print("哈哈3");
ps.executeUpdate();
}
ResultSet rs = ps.executeQuery();
out.print("哈哈4");
response.sendRedirect("newtable.jsp");
} catch (Exception e) {
e.printStackTrace();
}
%>
</body>
</html>
其中的out.print("哈哈*");是为了测试,看哪一步错了,后来执行完了,打出:
哈哈1哈哈2哈哈3 也就是说ps.executeUpdate();没执行呀,且后面说的错误是:“'choose' 附近有语法错误。”要么就是超出索引。
求救~~~~~~~~~~~~~~~~
out.print("哈哈2");
ps.setString(1,choose[i]);
out.print("哈哈3");
ps.executeUpdate(); ---- > 这句???!!!!
}