mysql db 연동 테스트

package stairsNoise;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
import org.junit.Test;
 
 
 
public class MySqlTest {
 
 
    Connection conn = null;
    Statement stmt = null;
    private final String DRIVER = "com.mysql.jdbc.Driver";
    private final String URL = "jdbc:mysql://localhost:3307/jianDB?useSSL=false&serverTimezone=UTC";
    private final String USER ="root";
    private final String PW = "U3cnc@12345";
 
 
    @Test
    public void test() {
 
        String sql;
 
        try {
            Class.forName(DRIVER);
 
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
 
        try {
            conn = DriverManager.getConnection(URL, USER, PW);
            System.out.println(">> 연결 성공");
 
            stmt = conn.createStatement();
 
            sql = "SELECT SNO, ID, PW, TITLE, CONTENTS, REG_DATE FROM JIANBOARD";
            ResultSet rs = stmt.executeQuery(sql);
 
            while(rs.next()){
                String title = rs.getString("title");
                System.out.println(" title >> " + title);
            }
            rs.close();
            stmt.close();
            conn.close();
 
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try{
                if(stmt!=null)
                    stmt.close();
            }catch(SQLException se2){
            }
            try{
                if(conn!=null)
                    conn.close();
            }catch(SQLException se){
                se.printStackTrace();
            }
        }
 
    }
 
 
}