Java reads the db.properties under SRC

This is also the JDBC connection between the database and Java

This is to put the db.properties data stream into memory            inputstream ins =  thread.currentthread (). Getcontextclassloader (). getResourceAsStream ("Db.properties");            Pro.load (INS);            Driver=pro.getproperty ("Driver");            Url=pro.getproperty ("url");            Username=pro.getproperty ("username");            Password=pro.getproperty ("password"); Ins.close ();    

Db.properties

#MySql #driver=com.mysql.jdbc.driver#url=jdbc:mysql://localhost:3306/test? Useunicode=true&characterencoding=utf-8#username =Root#password=root#oracledriver= oracle.jdbc.driver.OracleDriverurl=jdbc:oracle:thin:@127.0.0.1:1521: orclusername=  Scottpassword=tiger

Dbutil.java

 PackageCom.edusk.util;Importjava.io.IOException;ImportJava.io.InputStream;Importjava.sql.Connection;ImportJava.sql.DriverManager;Importjava.sql.PreparedStatement;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importjava.util.Properties; Public classDbutil {Private StaticString Driver = ""; Private StaticString url = ""; Private StaticString username = ""; Private StaticString Password = ""; PrivateConnection conn =NULL; /** Static code block*/    Static{Properties Pro=NewProperties (); Try {
This is to put the db.properties data stream into memory InputStream ins= Thread.CurrentThread (). Getcontextclassloader (). getResourceAsStream ("Db.properties");            Pro.load (INS); Driver=pro.getproperty ("Driver"); URL=pro.getproperty ("url"); Username=pro.getproperty ("username"); Password=pro.getproperty ("Password");        Ins.close (); } Catch(IOException e) {e.printstacktrace (); }    }         PublicConnection getconnection () {Try{class.forname (driver); Conn=drivermanager.getconnection (URL, username, password); } Catch(ClassNotFoundException |SQLException e)        {E.printstacktrace (); }        returnConn; }        /*** Close Link *@paramCon *@paramPS *@paramRS*/     Public Static voidClose (Connection conn,preparedstatement Ps,resultset rs) {if(conn!=NULL){            Try{conn.close (); } Catch(SQLException e) {e.printstacktrace (); }        }        if(ps!=NULL){            Try{ps.close (); } Catch(SQLException e) {e.printstacktrace (); }        }        if(rs!=NULL){            Try{rs.close (); } Catch(SQLException e) {e.printstacktrace (); }        }    }}

Test file

Testconnection.java

 Packagecom.edusk.test;Importjava.sql.Connection;Importjava.sql.PreparedStatement;ImportJava.sql.ResultSet;Importjava.sql.SQLException;ImportCom.edusk.util.DBUtil; Public classtestconnection { Public Static voidMain (string[] args) {Connection conn=Newdbutil (). getconnection (); Try{PreparedStatement PS= Conn.preparestatement ("Select Empno, ename from EMP"); ResultSet RS=Ps.executequery ();  while(Rs.next ()) {System.out.println (Rs.getint (1) + "" +rs.getstring (2)); }        } Catch(SQLException e) {e.printstacktrace (); }    }}

Java reads the db.properties under SRC