Test time spent connecting to an Oracle database

Maven Project

Main program: Connoracle.java

1  Packageorg.guangsoft.oracle;2 3 Importjava.sql.Connection;4 ImportJava.sql.DriverManager;5 Importjava.sql.SQLException;6 7 ImportOrg.guangsoft.util.PropUtil;8 9  Public classconnoracle {Ten     Private Static FinalString Driverclass = Proputil.getprops (). GetProperty ("Driverclass");  One     Private Static FinalString URL = proputil.getprops (). GetProperty ("url");  A     Private Static FinalString USERNAME = Proputil.getprops (). GetProperty ("USERNAME");  -     Private Static FinalString PASSWORD = Proputil.getprops (). GetProperty ("PASSWORD");  -     Private StaticConnection conn =NULL;  the    -      Public Static voidMain (string[] args) { -System.out.println ("# # #DRIVERCLASS is" +driverclass); -System.out.println ("# # #URL is" +URL); +System.out.println ("# # #USERNAME is" +USERNAME); -System.out.println ("# # #PASSWORD is" +PASSWORD); +         Try {   A Class.forName (Driverclass);  at}Catch(ClassNotFoundException e) { -System.out.println ("# # # #Class. forname failed!"); - E.printstacktrace ();  -         }   -    -         Try {   in             LongStartTime =System.currenttimemillis (); -conn =drivermanager.getconnection (URL, USERNAME, PASSWORD);  to             LongEndTime =System.currenttimemillis (); +             if(conn = =NULL) {   -SYSTEM.OUT.PRINTLN ("Conn is null to get link failed! ");  the}Else {   *SYSTEM.OUT.PRINTLN ("conn--" +conn);  $ System.out.println (Conn.hashcode ());Panax NotoginsengSYSTEM.OUT.PRINTLN ("Get Connection Time:" + (Endtime-starttime) + "MS"); -             }   the    +}Catch(SQLException e) { ASystem.out.println ("# # # #DriverManager. getconnection failed!"); the E.printstacktrace ();  +}finally {   -             Try {   $ Conn.close ();  $}Catch(Exception e) { - E.printstacktrace ();  -             }   the         }   -     }  Wuyi}

Proputil.java

 PackageOrg.guangsoft.util;ImportJava.io.InputStream;Importjava.util.Properties; Public classProputil {Private StaticProperties props =NULL; Static{readproperties ("Db.properties"); }        Private Static voidreadproperties (String fileName) {Try{Props=NewProperties (); InputStream InputStream=Thread.CurrentThread (). Getcontextclassloader (). getResourceAsStream (FileName);            Props.load (InputStream);        Inputstream.close (); } Catch(Exception e) {e.printstacktrace (); }        }          Public StaticProperties GetProps () {returnprops; }    }

Db.properties

driverclass=oracle.jdbc.driver.OracleDriver

URL=jdbc:oracle:thin: @localhost: 1521: ORCL

USERNAME=Test

PASSWORD=test

Pom.xml

1 <Projectxmlns= "http://maven.apache.org/POM/4.0.0"Xmlns:xsi= "Http://www.w3.org/2001/XMLSchema-instance"2 xsi:schemalocation= "http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">3     <modelversion>4.0.0</modelversion>4     <groupId>Org.guangsoft</groupId>5     <Artifactid>Oracle</Artifactid>6     <version>1.0</version>7     <Packaging>Jar</Packaging>8     <Dependencies>9         <Dependency>Ten             <groupId>Com.oracle</groupId> One             <Artifactid>Ojdbc5</Artifactid> A             <version>11.2</version> -         </Dependency> -     </Dependencies> the     <Build> -         <sourcedirectory>Src</sourcedirectory> -         <Resources> -             <Resource> +                 <Directory>Src</Directory> -                 <excludes> +                     <Exclude>**/*.java</Exclude> A                 </excludes> at             </Resource> -         </Resources> -         <Plugins> -             <plugin> -                 <Artifactid>Maven-compiler-plugin</Artifactid> -                 <version>2.3.2</version> in                 <Configuration> -                     <Source>1.5</Source> to                     <Target>1.5</Target> +                 </Configuration> -             </plugin> the         </Plugins> *     </Build> $ </Project>

Test time spent connecting to an Oracle database