jdbc之mysql/oracle数据库的连接

不管您是想连接那种数据库，请先确认引入数据库需要的驱动，也就是架包，之后add to path

1、jdbc连接没有mysql数据库

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

public class Test {
    Connection conn = null;

    public Connection getConnection() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("数据库加载驱动成功");
            
            // 使用时候如果出现【message from server: "Host 'ZJY-20180808BHG' is not allowed to connect to this MySQL server"】这种情况不要慌，使用下面的命令赋予权限
            // mysql>
            // mysql>use mysql;
            // mysql>select 'host' from user where user='root';
            // mysql>update user set host = '%' where user = 'root';
            // mysql>FLUSH PRIVILEGES
            //好啦，上一个问题就解决啦
            
            // user代表你建立的mysql数据库名称，如果没有使用create database user；进行创建
            
            String url = "jdbc:mysql://localhost:3306/user?useSSL=false";
            String user = "root";
            String password = "123456";
            conn = DriverManager.getConnection(url, user, password);
            System.out.println("已成功的与MySQL数据库建立连接！！");
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        return conn;
    }

    public static void main(String[] args) {
        Test mysql = new Test();
        mysql.getConnection();
    }
}

2、jdbc连接没有oracle数据库

public static Connection getConnection() {
		Connection conn = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:port:orcl", "icsshr", "icsshr");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}