mysql jdbc 연동

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

 

import com.mysql.jdbc.Statement;

 

//jdbc 연동

public class jdbcUtil {

public static Connection getConnection() {

 

Connection conn;

try {

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost:3306/study";

String user = "root";

String password = "1234";

 

return DriverManager.getConnection(url, user, password);

 

} catch (ClassNotFoundException e) {

e.printStackTrace();

System.out.println("드라이버 검색 실패");

 

} catch (SQLException e) {

System.out.println("커넥션 실패!");

e.printStackTrace();

}

return null;

}

 

public static void close(Connection conn) {

if (conn != null) {

try {

conn.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}

 

 

public static void close(ResultSet rs) {

if (rs != null) {

try {

rs.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}

 

public static void close(Statement stmt) {

if (stmt != null) {

try {

stmt.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}

}