JDBC DBUtil 通用包

java课的内容、记录一下

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

public class DBUtil {
    public static final int CONNECTION_MYSQL=2;不同数据库以数字代替
    public static final int CONNECTION_SQL=1;
    public static final int CONNECTION_ODBC=0;
    public DBUtil() {	}
    
    public static Connection getConnection(int connection_type)throws Exception
    {
        switch (connection_type)
        {
            case CONNECTION_ODBC:
                return getConnectionODBC();
            case CONNECTION_SQL:
                return getConnectionSQL();
            case CONNECTION_MYSQL:
                return getConnectionMYSQL();
        }
        return null;
    }
    
    
    public static Connection getConnection()throws Exception///复用函数，默认mysql
    {
        return getConnectionMYSQL();
    }
    
    
    public static Connection getConnection(String DBname) throws Exception//获得不同数据库连接，默认mysql
    {
        String connectionUrl = "jdbc:mysql://localhost:3306/"+DBname;
        String username = "root";
        String password = "mysql";
        Connection conn=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");//JVM去"com.mysql.jdbc"这个路径下找Driver类，将其加载到内存中
            conn=DriverManager.getConnection(connectionUrl, username,password);
        }
        catch(Exception e) {
            e.printStackTrace();
            throw e;
        }
        return conn;
    }
    
        public static void close(Connection conn) throws Exception
    {
        if(conn!=null) {
            try {
                conn.close();
            }
            catch(SQLException e) {
                e.printStackTrace();
                throw e;
            }
        }
    }
}

MYSQL

  private static Connection getConnectionMYSQL() throws Exception
    {
        String connectionUrl = "jdbc:mysql://localhost:3306/bookstore";/这里改成自己数据库
        String username = "username";
        String password = "password";
        Connection conn=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");

            conn=DriverManager.getConnection(connectionUrl, username,password);

        }
        catch(Exception e) {
            e.printStackTrace();
            throw e;
        }
        return conn;
    }

SQLServer

 private static Connection getConnectionSQL() throws Exception
    {
        Connection conn=null;
        String connectionUrl = "jdbc:sqlserver://localhost:1433;databaseName=bookstore;";///改成自己数据库
        try
        {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

            conn=DriverManager.getConnection(connectionUrl,"sa","sqlserver");//改成自己数据库，用户名和密码

        }
        catch(Exception e)
        {
            e.printStackTrace();
            throw e;
        }
        return conn;
    }

Oracle

 private static Connection getConnectionODBC()throws Exception
    {
        Connection conn=null;
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            System.out.println("abc");
            conn=DriverManager.getConnection("jdbc:odbc:mybook","sa","sqlserver");
//改成自己数据库，用户名，密码
        }
        catch(Exception e)
        {
            e.printStackTrace();
            throw e;
        }
        return conn;
    }