如何在mysql中使用jsp代码将日期格式从yyyy/dd/mm转换为mm/dd/yyyy？

<%@ page import="java.sql.*" %>
<%@ page import="java.text.SimpleDateFormat" %>

<%
  // 连接到MySQL数据库
  String url = "jdbc:mysql://localhost:3306/your_database";
  String username = "your_username";
  String password = "your_password";
  Connection conn = DriverManager.getConnection(url, username, password);
  
  // 执行查询语句获取日期数据
  String query = "SELECT date_column FROM your_table";
  Statement stmt = conn.createStatement();
  ResultSet rs = stmt.executeQuery(query);
  
  // 遍历结果集并进行日期格式转换
  SimpleDateFormat inputFormat = new SimpleDateFormat("yyyy/dd/mm");
  SimpleDateFormat outputFormat = new SimpleDateFormat("mm/dd/yyyy");
  
  while (rs.next()) {
    Date date = rs.getDate("date_column");
    String formattedDate = outputFormat.format(inputFormat.parse(date.toString()));
    out.println(formattedDate);
  }
  
  // 关闭数据库连接
  rs.close();
  stmt.close();
  conn.close();
%>