"SELECT * FROM wang.linchangfenbu WHERE ????????" where后面的判定条件不会写了. 想将下面程序中comments作为判定条件.试试挺多方法都得到无效的运算符的结果.应该不难,只是我太笨了.呵呵,那么前辈帮写出来吧.谢谢啦.
<%@ page contentType="text/html; charset=GB2312" language="java" import="java.io.*, java.sql.*, javax.sql.*"%>
<%@ page import="oracle.jdbc.*, oracle.sql.* "%> <html>
<body>
<%
request.setCharacterEncoding("GBK");
String comments=request.getParameter("comments");
// Connect to the database
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:myoracle";
String user="wang";
String password="yan0625";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement ();
ResultSet rs =
stmt.executeQuery("SELECT * FROM shen01.linchangfenbu WHERE ????????" );
out.println("<table border='1' align='center' >");
out.println("<tr align='center'>");
out.println("<th>ttt1</th><th>ttt2</th><th>ttt3</th>");
out.println("</tr>");
while(rs.next()) {
out.println("<tr align='center'>");
out.println ("<td>"+rs.getString("ttt1")+"</td>");
out.println("<td>"+rs.getString("ttt2")+"</td>");
out.println("<td>"+rs.getString("ttt3")+"</td>");
out.println("</tr>");
}
out.println("</table>");
// Close input and output streams
rs.close();
conn.close();
%></body></html>
<%@ page contentType="text/html; charset=GB2312" language="java" import="java.io.*, java.sql.*, javax.sql.*"%>
<%@ page import="oracle.jdbc.*, oracle.sql.* "%> <html>
<body>
<%
request.setCharacterEncoding("GBK");
String comments=request.getParameter("comments");
// Connect to the database
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:myoracle";
String user="wang";
String password="yan0625";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement ();
ResultSet rs =
stmt.executeQuery("SELECT * FROM shen01.linchangfenbu WHERE ????????" );
out.println("<table border='1' align='center' >");
out.println("<tr align='center'>");
out.println("<th>ttt1</th><th>ttt2</th><th>ttt3</th>");
out.println("</tr>");
while(rs.next()) {
out.println("<tr align='center'>");
out.println ("<td>"+rs.getString("ttt1")+"</td>");
out.println("<td>"+rs.getString("ttt2")+"</td>");
out.println("<td>"+rs.getString("ttt3")+"</td>");
out.println("</tr>");
}
out.println("</table>");
// Close input and output streams
rs.close();
conn.close();
%></body></html>
你的comments在哪里?你想在where里面做什么判断,不知啊
request.setCharacterEncoding("GBK");
String comments=request.getParameter("comments");
....
...
%>
有一个html文件通过<form>指向到了这个jsp文件.comments是在那个html文件中textarea的名字.也就是说,这个where判定条件,是前面html文件中的文本框中所输入的文本内容.
谢谢大家了.
<html>
<form id="form1" action="list.jsp" method="post">
<textarea cols="50" rows="10" name="comments"></textarea>
</form>
</html>
String sql = "SELECT * FROM shen01.linchangfenbu WHERE" + comments;
ResultSet rs =
stmt.executeQuery(sql );
用动态的方式生成SQL就可以了
String comments=request.getParameter("comments");
String sql = "SELECT * FROM shen01.linchangfenbu WHERE" + comments;
Statement stmt = conn.createStatement ();
ResultSet rs =stmt.executeQuery(sql );