复习，连接数据库

来源：互联网发布：mac 文件夹丢失编辑：程序博客网时间：2024/05/23 14:11

MySQL

public static Connection getConn(){
  //1.加载驱动
  try {
   Class.forName("com.mysql.jdbc.Driver");
  } catch (ClassNotFoundException e) {
   System.out.println("驱动没发现");
  }
  //2.获取连接
  Connection conn = null;
  String url = "jdbc:mysql://localhost:3306/news";
  try {
   conn = (Connection) DriverManager.getConnection(url,"root","root");
  } catch (SQLException e) {
   System.out.println("连接不上");
  }
  return conn;
}

Oracle

public static Connection getConn(){
  // 加载驱动oracle.jdbc.driver.OracleDriver
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
  } catch (ClassNotFoundException e) {
   System.out.println("Oracle p驱动没找到");
  }
  //获取连接
  String url = "jdbc:oracle:thin:@localhost:1521:jackies";
  Connection conn = null;
  try {
   conn = DriverManager.getConnection(url,"tt","tt123");
  } catch (SQLException e) {
   System.out.println("获取连接异常");
   e.printStackTrace();
  }
  return conn;
}