jsp向mysql添加数据类型

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "root";
    String password = "password";
    
    Connection conn = null;
    PreparedStatement pstmt = null;
    
    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection(url, username, password);
        
        String sql = "INSERT INTO users (username, age, email) VALUES (?, ?, ?)";
        pstmt = conn.prepareStatement(sql);
        
        // 假设从表单获取的数据
        String usernameParam = request.getParameter("username");
        int ageParam = Integer.parseInt(request.getParameter("age"));
        String emailParam = request.getParameter("email");
        
        pstmt.setString(1, usernameParam);
        pstmt.setInt(2, ageParam);
        pstmt.setString(3, emailParam);
        
        pstmt.executeUpdate();
    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
    } finally {
        if (pstmt != null) {
            try {
                pstmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
%>