如何使用数据库中的select语句转换/填充List<JsTreeModel>？

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class DatabaseExample {
    public static void main(String[] args) {
        // 数据库连接信息
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";

        // SQL查询语句
        String sql = "SELECT * FROM mytable";

        // 创建List<JsTreeModel>对象
        List<JsTreeModel> resultList = new ArrayList<>();

        // 执行查询并转换结果
        try (Connection conn = DriverManager.getConnection(url, username, password);
             Statement stmt = conn.createStatement();
             ResultSet rs = stmt.executeQuery(sql)) {

            while (rs.next()) {
                // 创建JsTreeModel对象
                JsTreeModel model = new JsTreeModel();

                // 根据查询结果的字段和JsTreeModel的属性对应关系，逐个赋值
                model.setId(rs.getInt("id"));
                model.setText(rs.getString("text"));
                model.setParentId(rs.getInt("parent_id"));

                // 将JsTreeModel对象添加到List中
                resultList.add(model);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        // 输出结果
        for (JsTreeModel model : resultList) {
            System.out.println(model);
        }
    }
}