Connecting an Oracle database with a single instance

1  PackageDAO;2 3 Importjava.sql.Connection;4 ImportJava.sql.DriverManager;5 Importjava.sql.SQLException;6 7  Public classDbUser {8     PrivateString driver= "Oracle.jdbc.driver.OracleDriver";9     PrivateString user= "Scott";Ten     PrivateString url= "JDBC:ORACLE:THIN:@127.0.0.1:1521:ORCL"; One     PrivateString password= "Ztoracle"; A     Private StaticDbUser DbUser; -     PrivateConnection Conn; -     PrivateDbUser () { the         Try { - Class.forName (driver); -}Catch(ClassNotFoundException e) { -             //TODO auto-generated Catch block + e.printstacktrace (); -         } +     } A      Public StaticDbUser Getdbuser () { at         if(dbuser==NULL){ -DbUser dbuser=NewDbUser (); -         } -         returnDbuser; -     } -      PublicConnection getconnection () { in          -             Try { toconn=drivermanager.getconnection (URL, user, password); +}Catch(SQLException e) { -                 //TODO auto-generated Catch block the e.printstacktrace (); *             } $         Panax Notoginseng         returnConn; -          the     } +}

Connecting an Oracle database with a single instance