1 启动mysql数据库创建两张表 电影表、电影分类表10分2 在mysql中手工录入分类表中的数据10分3 创建WEB项目导入必要jar包10分4 完成列表模块功能按照名称模糊查询10分5 完成添加模块功能10分6 使用ajax验证电影名称的唯一性10分7 完成修改模块功能10分8 完成删除模块功能10分9 在添加与修改页面中下拉框显示所属分类其中数据从分类表中获取10分10 代码规范及注释10

To start the MySQL database, we need to follow these steps: a. Install MySQL server on the local machine. b. Start the MySQL server service. c. Connect to the MySQL server using a MySQL client tool like MySQL Workbench or the command line. d. Create the movie table using the following SQL statement: CREATE TABLE movie ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100), category_id INT, release_date DATE, duration INT ); e. Create the movie_category table using the following SQL statement: CREATE TABLE movie_category ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) );

To manually enter data into the category table, we can use SQL INSERT statements. For example, to insert two categories "Action" and "Comedy", we can execute the following SQL statements: INSERT INTO movie_category (name) VALUES ('Action'); INSERT INTO movie_category (name) VALUES ('Comedy');

To create a web project, we need to follow these steps: a. Set up a web development environment like Eclipse or IntelliJ. b. Create a new web project. c. Import the necessary JAR files for web development, such as servlet-api.jar, jsp-api.jar, and mysql-connector-java.jar.

To implement the list module functionality, we need to create a servlet or controller that handles the search request. The servlet/controller should retrieve the search keyword from the request parameters and execute a SQL SELECT statement to fetch the movies matching the keyword. The retrieved movies can be displayed in a JSP page or returned as JSON data.

To implement the add module functionality, we need to create a form in a JSP page that collects the movie details (name, category, release date, duration). The form should submit a request to a servlet/controller that handles the form submission. The servlet/controller should retrieve the form data from the request parameters and execute a SQL INSERT statement to insert the new movie into the database.

To use AJAX to validate the uniqueness of a movie name, we can create a JavaScript function that sends an AJAX request to a servlet/controller. The servlet/controller should retrieve the movie name from the request parameters and execute a SQL SELECT statement to check if the movie name already exists in the database. The result of the AJAX request can be used to display an error message or enable/disable the submit button on the form.

To implement the update module functionality, we need to create a form in a JSP page that displays the current details of a movie and allows the user to modify them. The form should submit a request to a servlet/controller that handles the form submission. The servlet/controller should retrieve the form data from the request parameters and execute a SQL UPDATE statement to update the corresponding movie in the database.

To implement the delete module functionality, we need to create a link or button in the list or update page that triggers a request to a servlet/controller. The servlet/controller should retrieve the movie ID from the request parameters and execute a SQL DELETE statement to delete the corresponding movie from the database.

To display the categories in a dropdown list on the add and update pages, we need to fetch the category data from the movie_category table using a SQL SELECT statement. The retrieved categories can be used to populate the options of the dropdown list in the JSP page.

To ensure code quality and maintainability, we should follow coding conventions and best practices. This includes using meaningful variable and method names, organizing code into logical sections, providing comments to explain complex logic or important details, and adhering to coding style guidelines