java连接数据库工具类--DBConnection(java源码)

java连接数据库工具类--DBConnection(java源码)
packagecom.hexiang.utils.dao;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.Properties;importjavax.naming.Context;importjavax.naming.InitialContext;importjavax.naming.NamingException;importjavax.sql.DataSource;importorg.apache.log4j.Logger;publicclassDBConnection{ /** *获得与数据库的连接 * *@parampath *@returnConnection */ publicstaticConnectiongetConn(StringclassDriver,Stringurl, Stringuser,Stringpwd){ try{ Class.forName(classDriver); returnDriverManager.getConnection(url,user,pwd); }catch(ClassNotFoundExceptionex){ ex.printStackTrace(); }catch(SQLExceptionex){ ex.printStackTrace(); } returnnull; } publicstaticConnectiongetConn(DataSourcedataSource){ try{ returndataSource.getConnection(); }catch(SQLExceptionex){ ex.printStackTrace(); } returnnull; } publicstaticConnectiongetConn(StringjndiName){ try{ Contextctx; ctx=newInitialContext(); DataSourcedataSource=(DataSource)ctx.lookup("java:comp/env/" +jndiName); returndataSource.getConnection(); }catch(NamingExceptionex){ ex.printStackTrace(); }catch(SQLExceptionex){ ex.printStackTrace(); } returnnull; } publicstaticConnectiongetConn(Propertiesproperties){ try{ Stringdriver=properties.getProperty("jdbc.driverClassName"); Stringurl=properties.getProperty("jdbc.url"); Stringuser=properties.getProperty("jdbc.username"); Stringpassword=properties.getProperty("jdbc.password"); Class.forName(driver); returnDriverManager.getConnection(url,user,password); }catch(ClassNotFoundExceptionex){ ex.printStackTrace(); }catch(SQLExceptionex){ ex.printStackTrace(); } returnnull; } /** *oracle连接 * *@parampath *@returnConnection */ publicstaticConnectiongetOracleConn(String 本软件ID:1994750