下面是一个简单的JSP-Servlet+Mybatis的技能测试题的参考代码:

  1. 创建电影表和电影分类表
CREATE TABLE movie (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100),
    category_id INT,
    release_date DATE,
    duration INT
);

CREATE TABLE category (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100)
);
  1. 在分类表中手动插入数据

  2. 创建WEB项目,并导入必要的jar包

  3. 完成列表模块功能,按照名称模糊查询

Movie.java

public class Movie {
    private int id;
    private String name;
    private int categoryId;
    private Date releaseDate;
    private int duration;

    // getters and setters
}

MovieMapper.xml

<mapper namespace="com.example.mapper.MovieMapper">
    <select id="getMoviesByName" resultType="com.example.model.Movie">
        SELECT * FROM movie WHERE name LIKE CONCAT('%', #{name}, '%')
    </select>
</mapper>

MovieMapper.java

public interface MovieMapper {
    List<Movie> getMoviesByName(String name);
}

MovieServlet.java

@WebServlet("/movies")
public class MovieServlet extends HttpServlet {
    private MovieMapper movieMapper;

    public void init() {
        SqlSessionFactory sqlSessionFactory = MyBatisUtil.getSqlSessionFactory();
        try (SqlSession session = sqlSessionFactory.openSession()) {
            movieMapper = session.getMapper(MovieMapper.class);
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String name = request.getParameter("name");
        List<Movie> movies = movieMapper.getMoviesByName(name);

        request.setAttribute("movies", movies);
        request.getRequestDispatcher("movies.jsp").forward(request, response);
    }
}

movies.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>Movies</title>
</head>
<body>
    <h1>Movie List</h1>
    <form action="movies" method="GET">
        <label for="name">Name:</label>
        <input type="text" id="name" name="name">
        <input type="submit" value="Search">
    </form>
    <table>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Category</th>
            <th>Release Date</th>
            <th>Duration</th>
        </tr>
        <c:forEach var="movie" items="${movies}">
            <tr>
                <td>${movie.id}</td>
                <td>${movie.name}</td>
                <td>${movie.categoryId}</td>
                <td>${movie.releaseDate}</td>
                <td>${movie.duration}</td>
            </tr>
        </c:forEach>
    </table>
</body>
</html>
  1. 完成添加模块功能

add_movie.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>Add Movie</title>
</head>
<body>
    <h1>Add Movie</h1>
    <form action="addMovie" method="POST">
        <label for="name">Name:</label>
        <input type="text" id="name" name="name"><br>
        <label for="category">Category:</label>
        <select id="category" name="categoryId">
            <c:forEach var="category" items="${categories}">
                <option value="${category.id}">${category.name}</option>
            </c:forEach>
        </select><br>
        <label for="releaseDate">Release Date:</label>
        <input type="date" id="releaseDate" name="releaseDate"><br>
        <label for="duration">Duration:</label>
        <input type="number" id="duration" name="duration"><br>
        <input type="submit" value="Add">
    </form>
</body>
</html>

AddMovieServlet.java

@WebServlet("/addMovie")
public class AddMovieServlet extends HttpServlet {
    private MovieMapper movieMapper;
    private CategoryMapper categoryMapper;

    public void init() {
        SqlSessionFactory sqlSessionFactory = MyBatisUtil.getSqlSessionFactory();
        try (SqlSession session = sqlSessionFactory.openSession()) {
            movieMapper = session.getMapper(MovieMapper.class);
            categoryMapper = session.getMapper(CategoryMapper.class);
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        List<Category> categories = categoryMapper.getAllCategories();
        request.setAttribute("categories", categories);
        request.getRequestDispatcher("add_movie.jsp").forward(request, response);
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String name = request.getParameter("name");
        int categoryId = Integer.parseInt(request.getParameter("categoryId"));
        Date releaseDate = Date.valueOf(request.getParameter("releaseDate"));
        int duration = Integer.parseInt(request.getParameter("duration"));

        Movie movie = new Movie();
        movie.setName(name);
        movie.setCategoryId(categoryId);
        movie.setReleaseDate(releaseDate);
        movie.setDuration(duration);

        movieMapper.addMovie(movie);

        response.sendRedirect("movies");
    }
}
  1. 使用Ajax验证电影名称的唯一性

AddMovieServlet.java

@WebServlet("/addMovie")
public class AddMovieServlet extends HttpServlet {
    private MovieMapper movieMapper;
    private CategoryMapper categoryMapper;

    public void init() {
        SqlSessionFactory sqlSessionFactory = MyBatisUtil.getSqlSessionFactory();
        try (SqlSession session = sqlSessionFactory.openSession()) {
            movieMapper = session.getMapper(MovieMapper.class);
            categoryMapper = session.getMapper(CategoryMapper.class);
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        List<Category> categories = categoryMapper.getAllCategories();
        request.setAttribute("categories", categories);
        request.getRequestDispatcher("add_movie.jsp").forward(request, response);
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String name = request.getParameter("name");
        int categoryId = Integer.parseInt(request.getParameter("categoryId"));
        Date releaseDate = Date.valueOf(request.getParameter("releaseDate"));
        int duration = Integer.parseInt(request.getParameter("duration"));

        Movie movie = new Movie();
        movie.setName(name);
        movie.setCategoryId(categoryId);
        movie.setReleaseDate(releaseDate);
        movie.setDuration(duration);

        // Check if movie name already exists
        if (movieMapper.getMovieByName(name) != null) {
            response.getWriter().write("Movie name already exists");
            return;
        }

        movieMapper.addMovie(movie);

        response.sendRedirect("movies");
    }
}

add_movie.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>Add Movie</title>
    <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
    <script>
        $(document).ready(function() {
            $('#name').blur(function() {
                var name = $(this).val();
                $.ajax({
                    url: 'checkMovieName',
                    type: 'POST',
                    data: {name: name},
                    success: function(response) {
                        if (response === 'exists') {
                            $('#nameMessage').text('Movie name already exists');
                        } else {
                            $('#nameMessage').text('');
                        }
                    }
                });
            });
        });
    </script>
</head>
<body>
    <h1>Add Movie</h1>
    <form action="addMovie" method="POST">
        <label for="name">Name:</label>
        <input type="text" id="name" name="name">
        <span id="nameMessage"></span><br>
        <label for="category">Category:</label>
        <select id="category" name="categoryId">
            <c:forEach var="category" items="${categories}">
                <option value="${category.id}">${category.name}</option>
            </c:forEach>
        </select><br>
        <label for="releaseDate">Release Date:</label>
        <input type="date" id="releaseDate" name="releaseDate"><br>
        <label for="duration">Duration:</label>
        <input type="number" id="duration" name="duration"><br>
        <input type="submit" value="Add">
    </form>
</body>
</html>

CheckMovieNameServlet.java

@WebServlet("/checkMovieName")
public class CheckMovieNameServlet extends HttpServlet {
    private MovieMapper movieMapper;

    public void init() {
        SqlSessionFactory sqlSessionFactory = MyBatisUtil.getSqlSessionFactory();
        try (SqlSession session = sqlSessionFactory.openSession()) {
            movieMapper = session.getMapper(MovieMapper.class);
        }
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String name = request.getParameter("name");

        if (movieMapper.getMovieByName(name) != null) {
            response.getWriter().write("exists");
        } else {
            response.getWriter().write("not exists");
        }
    }
}
  1. 完成修改模块功能

edit_movie.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>Edit Movie</title>
</head>
<body>
    <h1>Edit Movie</h1>
    <form action="editMovie" method="POST">
        <input type="hidden" name="id" value="${movie.id}">
        <label for="name">Name:</label>
        <input type="text" id="name" name="name" value="${movie.name}"><br>
        <label for="category">Category:</label>
        <select id="category" name="categoryId">
            <c:forEach var="category" items="${categories}">
                <option value="${category.id}" <c:if test="${category.id == movie.categoryId}">selected</c:if>>${category.name}</option>
            </c:forEach>
        </select><br>
        <label for="releaseDate">Release Date:</label>
        <input type="date" id="releaseDate" name="releaseDate" value="${movie.releaseDate}"><br>
        <label for="duration">Duration:</label>
        <input type="number" id="duration" name="duration" value="${movie.duration}"><br>
        <input type="submit" value="Save">
    </form>
</body>
</html>

EditMovieServlet.java

@WebServlet("/editMovie")
public class EditMovieServlet extends HttpServlet {
    private MovieMapper movieMapper;
    private CategoryMapper categoryMapper;

    public void init() {
        SqlSessionFactory sqlSessionFactory = MyBatisUtil.getSqlSessionFactory();
        try (SqlSession session = sqlSessionFactory.openSession()) {
            movieMapper = session.getMapper(MovieMapper.class);
            categoryMapper = session.getMapper(CategoryMapper.class);
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        int id = Integer.parseInt(request.getParameter("id"));
        Movie movie = movieMapper.getMovieById(id);
        List<Category> categories = categoryMapper.getAllCategories();

        request.setAttribute("movie", movie);
        request.setAttribute("categories", categories);
        request.getRequestDispatcher("edit_movie.jsp").forward(request, response);
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        int id = Integer.parseInt(request.getParameter("id"));
        String name = request.getParameter("name");
        int categoryId = Integer.parseInt(request.getParameter("categoryId"));
        Date releaseDate = Date.valueOf(request.getParameter("releaseDate"));
        int duration = Integer.parseInt(request.getParameter("duration"));

        Movie movie = new Movie();
        movie.setId(id);
        movie.setName(name);
        movie.setCategoryId(categoryId);
        movie.setReleaseDate(releaseDate);
        movie.setDuration(duration);

        movieMapper.updateMovie(movie);

        response.sendRedirect("movies");
    }
}
  1. 完成删除模块功能

DeleteMovieServlet.java

@WebServlet("/deleteMovie")
public class DeleteMovieServlet extends HttpServlet {
    private MovieMapper movieMapper;

    public void init() {
        SqlSessionFactory sqlSessionFactory = MyBatisUtil.getSqlSessionFactory();
        try (SqlSession session = sqlSessionFactory.openSession()) {
            movieMapper = session.getMapper(MovieMapper.class);
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        int id = Integer.parseInt(request.getParameter("id"));
        movieMapper.deleteMovie(id);
        response.sendRedirect("movies");
    }
}
  1. 在添加与修改页面中,下拉框显示所属分类,其中数据从分类表中获取

CategoryMapper.xml

<mapper namespace="com.example.mapper.CategoryMapper">
    <select id="getAllCategories" resultType="com.example.model.Category">
        SELECT * FROM category
    </select>
</mapper>

CategoryMapper.java

public interface CategoryMapper {
    List<Category> getAllCategories();
}
  1. 代码规范及注释

请根据实际情况进行代码规范和注释的添加

JSP-Servlet+Mybatis技能测试题代码怎么写一丶案例题目描述: 二丶 评分要求:1	启动mysql数据库创建两张表 电影表、电影分类表10分2	在mysql中手工录入分类表中的数据10分3	创建WEB项目导入必要jar包10分4	完成列表模块功能按照名称模糊查询10分5	完成添加模块功能10分6	使用ajax验证电影名称的唯一性10分7	完成修改模块功能10分8	完成删除模块功能10

原文地址: https://www.cveoy.top/t/topic/in0f 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录