Copyright © tutorialspoint.com
How to Search contents of a table?
Following method uses where & like sql Commands to search through the database.
import java.sql.*; public class jdbcConn { public static void main(String[] args) throws Exception{ Class.forName("org.apache.derby.jdbc.ClientDriver"); Connection con = DriverManager.getConnection ("jdbc:derby://localhost:1527/testDb","username", "password"); Statement stmt = con.createStatement(); String query[] ={"SELECT * FROM emp where id=1", "select name from emp where name like 'ravi_'", "select name from emp where name like 'ravi%'"}; for(String q : query){ ResultSet rs = stmt.executeQuery(q); System.out.println("Names for query "+q+" are"); while (rs.next()) { String name = rs.getString("name"); System.out.print(name+" "); } System.out.println(); } } } |
The above code sample will produce the following result.The result may vary.
Names for query SELECT * FROM emp where id=1 are ravi Names for query select name from emp where name like 'ravi_' are ravi2 ravi3 Names for query select name from emp where name like 'ravi%' are ravi ravi2 ravi3 ravi123 ravi222 |
Copyright © tutorialspoint.com