数据库连接池（sqlserver,mysql,or…

最新推荐文章于 2025-05-06 16:59:51 发布

pigs2018

最新推荐文章于 2025-05-06 16:59:51 发布

阅读量556

点赞数

CC 4.0 BY-SA版权

分类专栏： Java

本文链接：https://blog.youkuaiyun.com/ZHANGHUI3239619/article/details/78746890

Java 专栏收录该内容

66 篇文章

订阅专栏

本文提供了一个Java程序示例，展示了如何通过JDBC建立与MySQL数据库的连接，并包括了获取连接、执行查询及更新操作的基本方法。此外，还介绍了连接关闭的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public class DBConnection {

private static String driverName = "";

private static String url = "";

private static String userName = "";

private static String userPass = "";

private DBConnection() {

}

public static Connection getConnection(String _userName, String _userPass)
   throws ClassNotFoundException, SQLException {
  // mysql
  driverName = "com.mysql.jdbc.Driver";
  url = "jdbc:mysql://127.0.0.1:3306/db_user?characterEncoding=gbk";

  // sql server 2005
  // driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  // url = "jdbc:sqlserver://127.0.0.1:1433;database=mytest";

  // oracle
  // driverName = "oracle.jdbc.driver.OracleDriver";
  // url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";

userName = _userName;
userPass = _userPass;

  Connection conn = null;
  Class.forName(driverName);
  conn = DriverManager.getConnection(url, userName, userPass);

  return conn;
}

public static Connection getConnection() throws ClassNotFoundException,
   SQLException {
  return getConnection("root","19880629");
}

public static void closeConnection(Connection conn) {
  if (conn != null) {
   try {
    conn.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
}

public static List executeQuery(String sql) {
  List list = new ArrayList();
  // jdbc...
  return list;
}

public static int executeUpdate(String sql) {
  int result = -1;
  // jdbc...
  return result;
}

public static void main(String[] args) {
  Connection conn = null;
  try {
   conn = getConnection("root", "19880629");
   System.out.println(conn);
  } catch (Exception e) {
   e.printStackTrace();
  }
  closeConnection(conn);
}

}