java mysql 操作类_java 数据库操作类

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Properties;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.naming.NamingException;

import javax.sql.DataSource;

import org.apache.log4j.Logger;

public class DBConnection {

/**

* @param path

* @return Connection

* wgy

*/

public static Connection getConn(String classDriver, String url,

String user, String pwd) {

try {

Class.forName(classDriver);

return DriverManager.getConnection(url, user, pwd);

} catch (ClassNotFoundException ex) {

ex.printStackTrace();

} catch (SQLException ex) {

ex.printStackTrace();

}

return null;

}

public static Connection getConn(DataSource dataSource) {

try {

return dataSource.getConnection();

} catch (SQLException ex) {

ex.printStackTrace();

}

return null;

}

public static Connection getConn(String jndiName) {

try {

Context ctx;

ctx = new InitialContext();

DataSource dataSource = (DataSource) ctx.lookup("java:comp/env/"

+ jndiName);

return dataSource.getConnection();

} catch (NamingException ex) {

ex.printStackTrace();

} catch (SQLException ex) {

ex.printStackTrace();

}

return null;

}

public static Connection getConn(Properties properties) {

try {

String driver = properties.getProperty("jdbc.driverClassName");

String url = properties.getProperty("jdbc.url");

String user = properties.getProperty("jdbc.username");

String password = properties.getProperty("jdbc.password");

Class.forName(driver);

return DriverManager.getConnection(url, user, password);

} catch (ClassNotFoundException ex) {

ex.printStackTrace();

} catch (SQLException ex) {

ex.printStackTrace();

}

return null;

}

/**

* oracle

*

* @param path

* @return Connection

*/

public static Connection getOracleConn(String url, String user, String pwd) {

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

return DriverManager.getConnection(url, user, pwd);

} catch (ClassNotFoundException ex) {

ex.printStackTrace();

} catch (SQLException ex) {

ex.printStackTrace();

}

return null;

}

/**

* mysql

*

* @param path

* @return Connection

*/

public static Connection getMysqlConn(String url, String user, String pwd) {

try {

Class.forName("com.mysql.jdbc.Driver");

return DriverManager.getConnection(url, user, pwd);

} catch (ClassNotFoundException ex) {

ex.printStackTrace();

} catch (SQLException ex) {

ex.printStackTrace();

}

return null;

}

/**

* Access����

*

* @param path

* @return Connection

*/

public static Connection getAccessConn(String path) {

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String url = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="

+ path;

return DriverManager.getConnection(url, "", "");

} catch (ClassNotFoundException ex) {

ex.printStackTrace();

} catch (SQLException ex) {

ex.printStackTrace();

}

return null;

}

public static void close(Object... objects) {

try {

for (Object object : objects) {

if (object != null) {

if (object instanceof ResultSet) {

ResultSet rs = (ResultSet) object;

rs.close();

log.info("ResultSet close");

} else if (object instanceof Statement) {

Statement stmt = (Statement) object;

stmt.close();

log.info("Statement close");

} else if (object instanceof Connection) {

Connection conn = (Connection) object;

conn.close();

log.info("Connection close");

}

}

}

} catch (SQLException e) {

e.printStackTrace();

}

}

private static Logger log = Logger.getRootLogger();

}