Project

General

Profile

« Previous | Next » 

Revision 6595

View differences:

MaxmumDBConnection.java
140 140
    DBConnection conn = null;
141 141
    PreparedStatement pStmt = null;
142 142
    ResultSet rs = null;
143
    String sql = "select docid from xml_documents where docid like'%jing%'";
143
    String sql = "select docid from xml_documents where docid like ?";
144 144
    
145 145
    try
146 146
    {
......
148 148
      serialNumber = conn.getCheckOutSerialNumber();
149 149
      System.out.println("serialNumber: "+serialNumber);
150 150
      pStmt = conn.prepareStatement(sql);
151
      pStmt.setString(1, "%jing%");
151 152
      pStmt.execute();
152 153
      rs = pStmt.getResultSet();
153 154
      if (rs.next())

Also available in: Unified diff