package com.chinaztt.mes.basic.util;
|
|
import java.sql.*;
|
|
/**
|
* @Author 张宾
|
* @Date 2023/10/26
|
*/
|
public class JDBCUtil {
|
private static String url;
|
private static String user;
|
private static String password;
|
private static String driver;
|
|
static {
|
try {
|
url = "jdbc:postgresql://127.0.0.1:5432/postgres";
|
user = "postgres";
|
password = "root2022";
|
driver = "org.postgresql.Driver";
|
} catch (Exception e) {
|
e.getMessage();
|
}
|
|
}
|
|
public static Connection getConn() throws Exception {
|
Connection connection = DriverManager.getConnection(url, user, password);
|
|
return connection;
|
}
|
|
public static void close(PreparedStatement preparedStatement,
|
Connection connection) {
|
|
try {
|
if (preparedStatement != null) {
|
preparedStatement.close();
|
}
|
if (connection != null) {
|
connection.close();
|
}
|
} catch (SQLException e) {
|
throw new RuntimeException();
|
}
|
}
|
|
}
|
