Packagecom.lxf.bean.db;ImportJava.sql.Connection;ImportJava.sql.DriverManager;ImportJava.sql.ResultSet;ImportJava.sql.SQLException;ImportJava.sql.Statement;/** * Database Connection class * * @author Liu Xiangfeng * */ Public class DbConnection { //oracle Connection Notation Private StaticString diver ="Oracle.jdbc.driver.OracleDriver";Private StaticString URL ="Jdbc:oracle:thin: @localhost: 1521:orcl";Private StaticString username ="LXF";Private StaticString Password ="LXF";Static{Try{//Load driverClass.forName (diver); }Catch(ClassNotFoundException e) {//TODO auto-generated catch blockE.printstacktrace (); } }/** * Get connection * * @return Connection */ Public StaticConnectionGetconn() {Connection conn =NULL;Try{conn = drivermanager.getconnection (URL, username, password); }Catch(Exception e) {//TODO auto-generated catch blockE.printstacktrace (); }returnConn }/** * Close Resources * * @param connection * @param statement * @param ResultSet */ Public Static void Close(Connection Connection, Statement Statement, ResultSet ResultSet) {Try{if(Connection! =NULL) {connection.close (); Connection =NULL; }if(Statement! =NULL) {statement.close (); statement =NULL; }if(ResultSet! =NULL) {resultset.close (); ResultSet =NULL; } }Catch(SQLException e) {//TODO auto-generated catch blockE.printstacktrace (); } }}
JDBC Encapsulation Tool Class