如何输入 SQL 查询条件?
如何从页面中输入SQL语句的查询条件(就是下面的 01001,01002...等):
select * from tblTest where id in(01001,01002,01003,01004)
代码如下:
<%@ page contentType="text/html;charset=GBK" language="java" errorPage="./error.jsp" %>
<%@ page import="java.sql.*,java.util.*,java.io.*,com.zwqk.*" %>
<html>
<head>
</head>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=zwqk";
String user = "sa";
String password = "";
Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from tblTest where id in(01001,01002,01003,01004)";
ResultSet rst = stmt.executeQuery(sql);
while(rst.next())
{
%>
......
......
......
<%
}
rst.close();
stmt.close();
conn.close();
%>
</div>
</body>
</html>