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