jsp更新mysql数据库数据类型

ALTER TABLE user_info MODIFY COLUMN age INT;

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "root";
    String password = "password";

    try {
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection conn = DriverManager.getConnection(url, username, password);

        // 更新数据类型
        String sql = "ALTER TABLE user_info MODIFY COLUMN age INT";
        Statement stmt = conn.createStatement();
        stmt.executeUpdate(sql);

        out.println("数据类型更新成功！");
    } catch (ClassNotFoundException | SQLException e) {
        out.println("更新数据类型时出错：" + e.getMessage());
    } finally {
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
%>