package database; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; /** * * @author Rajan Prasad Upadhyay */ public class OracleConnection { /* parameters */ private String username=null; private String password=null; private String host=null; private String port=null; private String sid=null; private Connection con = null; /* Query execution */ public void executeUpdate (String query) throws SQLException{ if(con != null){ PreparedStatement ps = con.prepareStatement(query); ps.executeUpdate(); } } public ResultSet executeQuery (String query){ ResultSet rs = null; if(con != null){ try{ PreparedStatement ps = con.prepareStatement(query); rs = ps.executeQuery(); }catch(Exception e){ } } return rs; } /* parameters part */ public void setConnection (String conString){ try { Class.forName("oracle.jdbc.driver.OracleDriver"); con = DriverManager.getConnection(conString, username, password); } catch (Exception ex) { //return null; System.out.println("Connection could not be established"); ex.printStackTrace(); } } public Connection getConnection() { return con; } public void setDefaultParameters(){ username = "USER1"; password = "oracle"; host = "localhost"; port = "1521"; sid = "XE"; } public String getConnectionString(){ return "jdbc:oracle:thin:@"+host+":"+port+":"+sid; } /* main method for unit testing */ public static void main(String [] args) throws SQLException{ OracleConnection con = new OracleConnection(); //con.setDefaultParameters(); con.setHost("localhost"); con.setPort("1521"); con.setSid("XE"); con.setUsername("USER1"); con.setPassword("oracle"); //System.out.println(con.getConnectionString()); return ; con.setConnection(con.getConnectionString()); ResultSet rs = con.executeQuery("select sysdate from dual"); if(rs != null){ while(rs.next()){ System.out.println("The date is " + rs.getString(1)); } } } /* Getters and Setters */ 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; } public String getHost() { return host; } public void setHost(String host) { this.host = host; } public String getPort() { return port; } public void setPort(String port) { this.port = port; } public String getSid() { return sid; } public void setSid(String sid) { this.sid = sid; } }
Blogging makes person busy, and a busy mind is creative | Just trying to be creative.
Best Database connector code for java and oracle.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
If you like to say anything (good/bad), Please do not hesitate...