JSP-Servlet+Mybatis技能测试题代码怎么写一丶案例题目描述: 二丶 评分要求:1 启动mysql数据库创建两张表 电影表、电影分类表10分2 在mysql中手工录入分类表中的数据10分3 创建WEB项目导入必要jar包10分4 完成列表模块功能按照名称模糊查询10分5 完成添加模块功能10分6 使用ajax验证电影名称的唯一性10分7 完成修改模块功能10分8 完成删除模块功能10
下面是一个简单的JSP-Servlet+Mybatis的技能测试题的参考代码:
- 创建电影表和电影分类表
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)
);
-
在分类表中手动插入数据
-
创建WEB项目,并导入必要的jar包
-
完成列表模块功能,按照名称模糊查询
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>
- 完成添加模块功能
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");
}
}
- 使用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");
}
}
}
- 完成修改模块功能
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");
}
}
- 完成删除模块功能
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");
}
}
- 在添加与修改页面中,下拉框显示所属分类,其中数据从分类表中获取
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();
}
- 代码规范及注释
请根据实际情况进行代码规范和注释的添加
原文地址: https://www.cveoy.top/t/topic/in0f 著作权归作者所有。请勿转载和采集!