Java数据库连接实用工具类-优快云博客

本文链接：https://blog.youkuaiyun.com/OJZFY/article/details/52489749

本文介绍了一个用于简化Java应用程序中数据库操作的实用工具类。该工具类通过加载配置文件来初始化数据库连接参数，并提供了获取数据库连接、创建Statement及PreparedStatement的方法。

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

package com.zfy.s05;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class DButils {
public static String driver;
public static String url;
public static String user;
public static String pwd;
static{
try {
Properties find = new Properties();
find.load(Thread.currentThread().getContextClassLoader().getResourceAsStream(“find.properties”));
driver = find.getProperty(“mysqlDriver”);
url = find.getProperty(“mysqlUrl”);
user = find.getProperty(“mysqlUser”);
pwd = find.getProperty(“mysqlPwd”);
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection connection = null;
try {
connection = DriverManager.getConnection(url,user,pwd);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return connection;
}
public static Statement getStatement(Connection connection){
Statement statement=null;
try {
statement = connection.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return statement;
}
public static PreparedStatement getPreparedStatement(Connection connection,String sql){
PreparedStatement prepareStatement = null;
try {
prepareStatement = connection.prepareStatement(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return prepareStatement;
}