layui如何连接MYSQL数据库

<link rel="stylesheet" href="https://cdn.staticfile.org/layui/2.6.8/css/layui.css">
<script src="https://cdn.staticfile.org/jquery/3.6.0/jquery.min.js"></script>
<script src="https://cdn.staticfile.org/layui/2.6.8/layui.js"></script>

<table class="layui-table" lay-data="{url:'your_data_url', page:true, limit:10, cols: [[
  {field:'id', title:'ID'},
  {field:'name', title:'姓名'},
  {field:'age', title:'年龄'}
]]}">
</table>

import java.sql.*;
import com.alibaba.fastjson.JSON;

public class DatabaseController {
    public static void main(String[] args) {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://your_mysql_host:3306/your_database", "username", "password");
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM your_table");

            while (rs.next()) {
                int id = rs.getInt("id");
                String name = rs.getString("name");
                int age = rs.getInt("age");
                
                // 将数据转换为JSON格式并输出
                System.out.println(JSON.toJSONString(new User(id, name, age)));
            }

            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    static class User {
        private int id;
        private String name;
        private int age;

        public User(int id, String name, int age) {
            this.id = id;
            this.name = name;
            this.age = age;
        }
    }
}