Revision 6595
Added by ben leinfelder over 12 years ago
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
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5527