TaskProject/handlers/studentService.cfc

component {


      // index method to handle requests to the root URL or specified route
      function index(event, rc, prc) {
        // Your logic to process the request goes here
        
        // Example: Set a variable to pass data to the view
        prc.message = "Welcome to the index page!";
        
        // Example: Render a view
        event.setView("studentService/createStudent");
    }
    // Function to create a new student
    public void function createStudent(sname, major, level, byear) {
        // Initialize error variable
        var errorMessage = "";
        
        // Check if any form field is empty
        if (!len(arguments.sname) or !len(arguments.major) or !len(arguments.level) or !len(arguments.byear)) {
            errorMessage = "All fields are required.";
        } else {
            // Try inserting the student record into the database
            try {
                // Insert the student
                var insertQuery = new query();
                insertQuery.setDatasource("task");
                var sql = "INSERT INTO Student (sname, major, level, byear) VALUES (?, ?, ?, ?)";
                insertQuery.setSQL(sql);
                insertQuery.addParam(name="sname", value=arguments.sname, cfsqltype="CF_SQL_VARCHAR");
                insertQuery.addParam(name="major", value=arguments.major, cfsqltype="CF_SQL_VARCHAR");
                insertQuery.addParam(name="level", value=arguments.level, cfsqltype="CF_SQL_VARCHAR");
                insertQuery.addParam(name="byear", value=arguments.byear, cfsqltype="CF_SQL_VARCHAR");
                insertQuery.execute();
            } catch (any e) {
                // Catch any exceptions and set error message
                errorMessage = "Error creating student: " & e.message;
            } finally {
                // Close the query
                if (isQuery(insertQuery)) {
                    insertQuery.close();
                }
            }
        }

        // Output error message, if any
        if (len(errorMessage)) {
            writeOutput(errorMessage);
        } else {
            writeOutput("Student created successfully!");
        }
    }
}