java 数据库操作工具类

来源：互联网发布：反馈网络的作用编辑：程序博客网时间：2024/05/22 01:46

数据库连接工具类：

package com.common.database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
* 功能描述：连接数据库-mysql/oracle
*
* @author :FangHewei
* @Date :Jul 18, 2008
* @Time :3:28:59 PM
* @version :1.0
*/
public class ConnectDB {

private static final String MYSQL = "jdbc:mysql://";

private static final String ORACLE = "jdbc:oracle:thin:@";

private static final String SQLSERVER = "jdbc:microsoft:sqlserver://";
private ConnectDB() {
}

public static Connection getConnection(String DBType, String url,
   String user, String password) throws SQLException {
  if ("mysql".equalsIgnoreCase(DBType))
   return getMySqlConn(url, user, password);
  if ("oracle".equalsIgnoreCase(DBType))
   return getOracleConn(url, user, password);
  if ("sqlserver".equals(DBType)){
   return getSqlServerConn(url, user, password);
  }
  return null;
}

public static void closeConn(Connection conn) {
  if (conn != null) {
   try {
    conn.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
}

private static Connection getMySqlConn(String url, String user,
   String password) throws SQLException {
  Connection conn = null;
  try {
   Class.forName("com.mysql.jdbc.Driver");// 加载驱动
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  }
  conn = DriverManager.getConnection(MYSQL + url, "root", "root");

return conn;
}

private static Connection getOracleConn(String url, String user,
   String password) throws SQLException {
  Connection conn = null;
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");// 加载驱动
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  }
  conn = DriverManager.getConnection(ORACLE + url, "scott", "tiger");

  return conn;
}

private static Connection getSqlServerConn(String url, String user,
   String password) throws SQLException {
  Connection conn = null;
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");// 加载驱动
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  }
  conn = DriverManager.getConnection(SQLSERVER + url, "root", "root");

  return conn;
}
public static void main(String[] args) {
  try {
   Connection conn = getConnection("MySQL", "127.0.0.1", "root",
     "root");
   if (conn == null) {
    System.out.println("Connection the database is failled !");
   } else {
    System.out.println(conn.toString());
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }

}

1. Mysql

2. Oracle

3. Sqlserver

0 0