java简单的连接mysql数据库方法

最新推荐文章于 2023-04-05 12:43:44 发布

小梁同学丶

最新推荐文章于 2023-04-05 12:43:44 发布

阅读量175

点赞数 1

分类专栏：小案例文章标签： mysql

本文链接：https://blog.csdn.net/Young_liang/article/details/96624506

版权

小案例专栏收录该内容

2 篇文章 0 订阅

订阅专栏

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JDUtil {
 public static Connection getConnect() {
  Connection conn = null;
  try {
   Class.forName("com.mysql.cj.jdbc.Driver").newInstance();
  } catch (InstantiationException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
     } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  String url = "jdbc:mysql://127.0.0.1:3306/java0520?serverTimezone=UTC&useSSL=false";
  String user = "root";
  String password = "1234";
  try {
   conn = DriverManager.getConnection(url, user, password);
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return conn;
  }
 public static Statement getStatement() {
  Connection conn = getConnect();
  Statement stmt = null;
  try {
   stmt = conn.createStatement();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return stmt;
 }
}