连接数据库

最新推荐文章于 2022-07-05 12:41:57 发布

唐增辉

最新推荐文章于 2022-07-05 12:41:57 发布

阅读量380

点赞数

分类专栏： SQL 文章标签： exception jdbc sqlserver microsoft access database

本文链接：https://blog.csdn.net/tangjie200566/article/details/5305953

版权

SQL 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

//连接Access

public static Connection getConnection()
{

Connection con=null;
  try {
   //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

   //con=(Connection) DriverManager.getConnection("jdbc:odbc:bookshop","","");

   //con=(Connection) DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=H://know//learn_self//DB//access//bookshop.mdb","","");

   Class.forName("com.hxtt.sql.access.AccessDriver").newInstance();
   con=(Connection) DriverManager.getConnection("jdbc:access:///H://know//learn_self//DB//access//bookshop.mdb ","test","test");
  } catch (Exception e) {
   e.printStackTrace();
  }
  return con;
}

//连接 Oracle
public static Connection getConnection2()
{
  Connection con=null;//oracle.jdbc.driver.OracleDriver
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");//.newInstance();
   con=(Connection) DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:test","system","test");

  } catch (Exception e) {
   e.printStackTrace();
  }
  return con;
}

//连接MySql
public static Connection getConnection1()
{
  Connection con=null;
  try {
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//.newInstance();
   con=(Connection) DriverManager.getConnection("jdbc:sqlserver://localhost:1433;database=test","sa","");

  } catch (Exception e) {
   e.printStackTrace();
  }
  return con;
}