JDBC Query Execution In Java Example
Chapter:
JDBC
Last Updated:
18-06-2016 09:24:26 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 JavaJDBCQueryExecution {
public static void main(String a[]){
Connection connection = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
connection = DriverManager.
getConnection("jdbc:oracle:thin:@<hostname>:<port num>:<DB name>"
,"user","password");
Statement statement = connection.createStatement();
//The query can be update query or can be select query
String query = " SELECT * FROM Employee ";
boolean status = statement.execute(query);
if(status){
//query is a select query.
ResultSet rs = statement.getResultSet();
while(rs.next()){
System.out.println(rs.getString(1));
}
rs.close();
} else {
int count = statement.getUpdateCount();
System.out.println("Total records updated: "+count);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally{
try{
if(connection != null) connection.close();
} catch (Exception ex){}
}
}
}
/* ............... END ............... */
Tags
JDBC Query Execution, Java