spring ) jdbc

 

public class DB_test {
    String dbDriver ="com.mysql.cj.jdbc.Driver";
    String dbUrl    = "jdbc:mysql://[____]:3306/[____]?characterEncoding=UTF-8 & serverTimezone=UTC";
    String dbId     = "[_____]";
    String dbPw     = "[_____]";
    Connection con = null;
    Statement stmt = null;

    DB_test(){
        try{
            Class.forName( dbDriver );
            con = DriverManager.getConnection( dbUrl, dbId, dbPw );
            stmt = con.createStatement();
            System.out.print("mysql jdbc test: connect ok!!");
        }catch(Exception e) {
            System.out.println(e);
        }
    }
}