자바
My-SQL JDBC 커넥션 유틸 클래스 기본코드
by 가오가이거
2020. 12. 12.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBUtil {
static String URL = "jdbc:mysql://localhost:3306/testdb?serverTimezone=UTC";
static String USER = "root";
static String PASSWORD = "1234";
static String DRIVER_NAME = "com.mysql.cj.jdbc.Driver"; //My-SQL 8.0버전용 라이브러리
//접속
public static Connection getConnection() throws Exception{
Connection conn = null;
Class.forName(DRIVER_NAME);
conn = DriverManager.getConnection(URL, USER, PASSWORD);
return conn;
}
//접속 종료
public static void close(Connection conn) {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void close(Connection conn,PreparedStatement ps) {
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
close(conn);
}
public static void close(Connection conn, PreparedStatement ps, ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
close(conn,ps);
}
public static void main(String[] args) throws Exception {
System.out.println(getConnection());
}
}