JAR package: class12.jar
package com.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnection {
private String drivername;
private String dburl;
private String username;
private String password;
public Connection getConnection() {
try {
Class.forName(drivername);
return DriverManager.getConnection(dburl, username, password);
} catch (ClassNotFoundException e) {
System.out.println(e.getMessage());
e.printStackTrace();
} catch (SQLException e) {
System.out.println(e.getMessage());
e.printStackTrace();
}
return null;
}
public String getDrivername() {
return drivername;
}
public void setDrivername(String drivername) {
this.drivername = drivername;
}
public String getDburl() {
return dburl;
}
public void setDburl(String dburl) {
this.dburl = dburl;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
package com.util;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBDemon {
/**
* @param args
*/
public static void main(String[] args) {
DBConnection dbdemon = new DBConnection();
dbdemon.setDrivername("oracle.jdbc.driver.OracleDriver");
dbdemon.setDburl("jdbc:oracle:thin:@host:port:sid");
dbdemon.setUsername("username");
dbdemon.setPassword("password");
Connection conn = dbdemon.getConnection();
ResultSet rs = null;
try {
Statement stmt = conn.createStatement();
String sql = "select * from sc_processing_queue";
rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getInt(1));
System.out.println(rs.getInt(2));
System.out.println(rs.getString(3));
System.out.println(rs.getString(4));
System.out.println(rs.getString(5));
System.out.println(rs.getDate(6));
System.out.println(rs.getDate(7));
}
} catch (SQLException e) {
System.out.println(e.getMessage());
} finally {
try {
rs.close();
conn.close();
} catch (SQLException e) {
System.out.println(e.getMessage());
}
}
}
}