java连接mysql

@Test
    @Override
    public void getPersonInfo() {

        final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
        final String DB_URL = "jdbc:mysql://localhost:3306/test";
        String username = "root";
        String password = "123";
        Connection connection = null;
        Statement statement = null;

        try {
            Class.forName(JDBC_DRIVER);
            connection  = DriverManager.getConnection(DB_URL, username, password);
            statement = connection.createStatement();
            String sql = "";
            sql = "select * from dept";
            ResultSet resultSet = statement.executeQuery(sql);
            while(resultSet.next()){
                int deptno = resultSet.getInt("DEPTNO");
                String dname = resultSet.getString("DNAME");
                String loc = resultSet.getString("LOC");
                System.out.println(deptno + dname + loc);
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        
        System.out.println("连接完成");

    }