Java Connect To Database Example

Chapter: JDBC Last Updated: 10-09-2016 06:45:34 UTC

Program:

            /* ............... START ............... */
                
public class JavaConnectDatabase {

	public static void main(String[] args) {
		try {
			Class.forName("org.apache.derby.jdbc.ClientDriver");
		} catch (ClassNotFoundException e) {
			System.out.println("Class not found " + e);
		}
		System.out.println("JDBC Class found");
		int no_of_rows = 0;
		try {
			Connection con = DriverManager.getConnection("jdbc:derby://localhost:1527/testDb", "username", "password");
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery("SELECT * FROM employee");
			while (rs.next()) {
				no_of_rows++;
			}
			System.out.println("There are " + no_of_rows + " record in the table");
		} catch (SQLException e) {
			System.out.println("SQL exception occured" + e);
		}
	}
}
                /* ............... END ............... */
        

Output

JDBC Class found
There are 2 record in the table

Tags

Connect To Database Example, 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 Search 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
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