JDBC Link Database

 Packagecom.maya.hanqi.jdbctest;Importjava.sql.Connection;ImportJava.sql.DriverManager;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importjava.sql.Statement; Public classJdbcconnectutil {//Tool Class    Private Static FinalString USERNAME = "Test"; Private Static FinalString PASSWORD = "Test"; Private Static FinalString URL = "Jdbc:oracle:thin: @localhost: 1521:xe"; Private Static FinalString driverclassname = "Oracle.jdbc.OracleDriver";  Public StaticConnection getconnection () {Connection conn=NULL; Try{class.forname (driverclassname); Conn=drivermanager.getconnection (Url,username,password); } Catch(ClassNotFoundException e) {e.printstacktrace (); } Catch(SQLException e) {e.printstacktrace (); }                returnConn; }     Public Static voidDestroy (Connection conn,statement sm,resultset rs) {if(conn!=NULL) {            Try{conn.close (); } Catch(SQLException e) {e.printstacktrace (); } Conn=NULL; }        if(sm!=NULL) {            Try{sm.close (); } Catch(SQLException e) {e.printstacktrace (); } Conn=NULL; }        if(rs!=NULL) {            Try{rs.close (); } Catch(SQLException e) {e.printstacktrace (); } Conn=NULL; }    }     Public Static voidMain (string[] args) {System.out.println (getconnection ()); }}

JDBC Link Database