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

Similar Programs Chapter Last Updated
Java Execute Multiple SQL Statements JDBC 10-09-2016
Java JDBC Savepoint And Rollback JDBC 10-09-2016
Java JDBC Commit Statement Example JDBC 10-09-2016
Java JDBC Sort Table Contents JDBC 10-09-2016
Java JDBC Update Table JDBC 10-09-2016
Java Retrieve Table Contents JDBC 10-09-2016
Java JDBC Table Edit Example JDBC 10-09-2016
Java Connect To Database Example JDBC 10-09-2016
JDBC SQL Cursors Using CallableStatement JDBC 26-06-2016
JDBC Batch Execution In Java Using CallableStatement JDBC 26-06-2016
JDBC Stored Procedure Returns OUT Parameters In Java JDBC 23-06-2016
JDBC Stored Procedure Execution In Java JDBC 23-06-2016
JDBC Prepared Statement With ResultSet In Java Example JDBC 18-06-2016
JDBC Prepared Statement In Java Example JDBC 18-06-2016
JDBC Update Query In Java Example JDBC 18-06-2016
JDBC Query Execution In Java Example JDBC 18-06-2016
JDBC Query In Java Example JDBC 18-06-2016
Java JDBC Connection Example JDBC 18-06-2016

1