求助：如何显示数据库的记录

Question

<%   
  Class.forName( "oracle.jdbc.driver.OracleDriver" );    
  String url ="jdbc:oracle:thin:@localhost:1521:MyOrcal";
  Connection con = DriverManager.getConnection( url,"scott", "tiger" );
  
  Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);   
  ResultSet rs;   
  String condition="select * from SCOTT.YHGL_TABLE where USER_NAME ";   
  rs=smt.executeQuery(condition);   
  java.util.List list=new java.util.ArrayList();   
  while(rs.next()){   
  String[] temp= {rs.getString("USER_NAME"),rs.getString("USER_PSW")};   
  list.add(temp);   
  }   
  %>        
  <table>   
  <tr>   
  <th>用户</th>   
  <th>密码</th>   
  </tr>   
  <%   
  for(int i=0;i<list.size();i++){   
  String[] data=(String[])list.get(i);   
  %>   
  <tr>   
  <%for(int j=0;j<data.length;j++)   
    {%>   
  <td><%=data[j]%></td></tr>   
  <%}%>   
  <%   
                          }   
  %>                                  
  </table>   
  <%rs.close();   
      smt.close();   
    con.close();   
   %>   调试结果：
javax.servlet.ServletException: ORA-00920: 无效的关系运算符 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.XM.list_jsp._jspService(list_jsp.java:102)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.sql.SQLException: ORA-00920: 无效的关系运算符 oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:7030)
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:578)
org.apache.jsp.XM.list_jsp._jspService(list_jsp.java:53)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

Answer 1

select * from SCOTT.YHGL_TABLE where USER_NAME 条件写错了
select * from SCOTT.YHGL_TABLE where USER_NAME ='你要查找的值'

Answer 2

String condition="select * from SCOTT.YHGL_TABLE where USER_NAME "; 
USER_NAME后面就没有东西了吗?
比如说USER_NAME='Tom'

Answer 3

条件后面没传入参数啊。。
String condition="select * from SCOTT.YHGL_TABLE where USER_NAME =‘“+参数+”’ ";