Java JDBC Search Table Contents
Chapter:
JDBC
Last Updated:
10-09-2016 07:15:15 UTC
Program:
/* ............... START ............... */
import java.sql.*;
public class JavaJDBCSearchTable {
public static void main(String[] args) throws Exception {
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection connection = DriverManager.getConnection("jdbc:derby://localhost:1527/testDb", "username",
"password");
Statement stmt = connection.createStatement();
String query[] = { "SELECT * FROM emp where id=1", "select name from emp where name like 'Jack_'",
"select name from emp where name like 'Jack%'" };
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();
}
}
}
/* ............... END ............... */
Tags
JDBC Search Table Contents, Java, JDBC