JDBC Query In Java Example
Chapter:
JDBC
Last Updated:
18-06-2016 09:22:51 UTC
Program:
/* ............... START ............... */
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JavaJDBCQueryExample {
public static void main(String a[]) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@<hostname>:"
+ "<port num>:<DB name>", "user","password");
Statement statement = con.createStatement();
System.out.println("Created DB Connection....");
ResultSet resultSet = statement.executeQuery("SELECT ID,Name FROM Employee ");
while (resultSet.next()) {
System.out.println(resultSet.getString("ID"));
System.out.println(resultSet.getInt("Name"));
}
resultSet.close();
con.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/* ............... END ............... */
Tags
JDBC Query, Java