【Java - 访问第三方数据库，获取数据，格式化数据】

   String url = "jdbc:mysql://db.kangruicloud.com:23306/village";
   String account = "root";
   String passeword ="123456"
   String tableName= "user"
  JSONArray userArray= getDeviceData(url, account, passeword ,tableName);
  List<UserModel> userModel= 
  JSON.parseArray(JSON.toJSONString(fw), UserModel.class);
  

 private JSONArray getDeviceData(String url, String username ,  String password , String tableName) throws ClassNotFoundException, SQLException {

        Class.forName("com.mysql.cj.jdbc.Driver");
        // 创建数据库连接
        Connection conn = DriverManager.getConnection(url, username, password );
        // 创建Statement对象
        Statement stmt = conn.createStatement();
        // 执行查询语句
        String sql = "SELECT * FROM "+ tableName;
        ResultSet rs = stmt.executeQuery(sql);

        JSONArray jsonArray = new JSONArray();
        ResultSetMetaData metaData = rs.getMetaData();
        int colCnt = metaData.getColumnCount();
        // 处理结果集
        while (rs.next()) {
            JSONObject jsonObject = new JSONObject();
            for(int i=1;i<=colCnt;i++){
                jsonObject.put(metaData.getColumnName(i),rs.getObject(i));
            }
            jsonArray.add(jsonObject);
//            System.out.println( jsonArray );
        }
        // 关闭连接
        rs.close();
        stmt.close();
        conn.close();

      return jsonArray;

    }