java连接mysql/sqlserver/oracle

最新推荐文章于 2023-06-21 19:15:14 发布

西_北

最新推荐文章于 2023-06-21 19:15:14 发布

阅读量857

点赞数

本文链接：https://blog.csdn.net/xuan_xinya/article/details/8932272

版权

连接mysql
import java.sql.*;

public class aa{
public static void main(String[] args) {
Connection con = null;

  try {

   Class.forName("oracle.jdbc.OracleDriver");
   System.out.println("sssssssss");
   try {
    con = DriverManager.getConnection(
       "jdbc:oracle:thin:@127.0.0.1:1521:orcl",
      "scott", "oracle");
    System.out.println("aaaaaaaaaaaaaa");
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    System.out.println("wwww");
   }
   } catch (ClassNotFoundException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    System.out.println("rrrrrrrrrrr");
   }
}
}

连接sqlserver

package MOdel;

import java.sql.*;

public class connDb {
Connection con = null;
public Connection getcon(){
  try {
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
   System.out.println("sssssssss");
   try {
    con = DriverManager.getConnection(
      "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=xiaoyouwang",
      "sa", "123");
    System.out.println("aaaaaaaaaaaaaa");
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   } catch (ClassNotFoundException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  return con;
}
}