rset = stmt.executeQuery("SELECT id, name FROM hehe where id > 499999 and name =''''我爱中国500001''''"); if (rset.next()){ System.out.println(rset.getInt("id")); System.out.println(rset.getString("name")); } if (rset!=null){ rset.close(); rset = null; }
System.out.println(new java.util.Date());
System.out.println("建索引:"); System.out.println(new java.util.Date()); stmt.executeUpdate("CREATE INDEX hehe_idx on hehe(id)"); stmt.executeUpdate("CREATE INDEX hehe_idx2 on hehe(name)"); conn.commit(); System.out.println(new java.util.Date());
System.out.println("建索引后的查询:"); System.out.println(new java.util.Date()); rset = stmt.executeQuery("SELECT id, name FROM hehe where id > 499999 and name = ''''我爱中国500001''''"); if (rset.next()){ System.out.println(rset.getInt("id")); System.out.println(rset.getString("name")); } System.out.println(new java.util.Date()); stmt.executeUpdate("drop table hehe"); System.out.println("删除表hehe成功!"); conn.commit();