JDBC连接mysql数据库两种方式

本文主要是介绍JDBC连接mysql数据库两种方式，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

JDBC连接数据库的两种方式
package jess.day15;

import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
/**
* @author Jess
* @date 2021/10/19
*/
public class Conn {
public static void main(String[] args) throws SQLException, IOException, ClassNotFoundException {
conn2();
}

/**
* 直接读取字符串
*/
public static void conn1() {
String url = "jdbc:mysql://127.0.0.1:3306/jzy1?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8";
String name = "root";
String password = "123456";
String driver = "com.mysql.cj.jdbc.Driver";
try {
Class.forName(driver);
Connection connection = DriverManager.getConnection(url, name, password);
System.out.println(connection);
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}

/**
* 通过配置文件读取
*/
public static void conn2() throws IOException, ClassNotFoundException, SQLException {
Properties properties =new Properties();
// 读取配置文件
properties.load(new FileInputStream("jdbc.properties"));
// 解析配置文件
String url = properties.getProperty("url");
String name = properties.getProperty("name");
String password = properties.getProperty("password");
String driver = properties.getProperty("driver");
System.out.println(url);
// 加载驱动
Class.forName(driver);
// 获取连接
Connection connection = DriverManager.getConnection(url, name, password);
System.out.println(connection);
}

}

properties配置文件
url =jdbc:mysql://127.0.0.1/jzy2?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
name =root
password =123456
driver =com.mysql.cj.jdbc.Driver

连接数据库的工具类
package cn.jess.day02;

import cn.jess.day01.JdbcTest;
import java.io.IOException;
import java.sql.*;
import java.util.Properties;

/**
* 连接数据库
* @author Jess
*/

public class JdbcConnectionTool {
/**
* 获取连接
* @return 连接对象
*/
public static Connection getConnection() {
Properties properties = new Properties();
Connection con = null;
try {
//加载配置文件
properties.load(JdbcTest.class.getClassLoader().getResourceAsStream("jdbc.properties"));
// 读取配置文件
String url = properties.getProperty("mysql.url");
String user = properties.getProperty("mysql.username");
String password = properties.getProperty("mysql.password");
//获取连接
con = DriverManager.getConnection(url, user, password);
} catch (IOException | SQLException e) {
e.printStackTrace();
}
return con;
}

/**
* 关闭资源
* @param statement
* @param connection
* @param resultSet
*/
public static void connClose(Statement statement,Connection connection,ResultSet resultSet){
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (statement != null) {
try {
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (resultSet!=null){
try {
resultSet.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}

了解更多大数据培训技术相关问题欢迎关注小编！

这篇关于JDBC连接mysql数据库两种方式的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！