利用MYSQL 三层架构 java jsp servlet 制作一个电影网站代码

很抱歉，由于涉及到具体实现，我无法在此处提供完整的代码。但是，我可以为您提供一些参考和指导，帮助您完成电影网站的制作。

1. 数据库设计

首先，您需要设计好数据库表结构。以下为电影管理系统的表结构：

- 电影信息表 movie_info
- movie_id (int)
- movie_name (varchar)
- movie_type (varchar)
- movie_director (varchar)
- movie_actor (varchar)
- movie_description (text)
- movie_img (varchar)
- movie_url (varchar)
- movie_time (date)

- 用户信息表 user_info
- user_id (int)
- user_name (varchar)
- user_password (varchar)
- user_email (varchar)
- user_phone (varchar)

- 评论信息表 comment_info
- comment_id (int)
- movie_id (int)
- user_id (int)
- comment_content (text)
- comment_time (date)

2. 业务逻辑实现

您需要编写 Servlet 类来实现业务逻辑，例如用户登录、注册、电影查询、评论添加等操作。以下为示例代码：

- 用户登录 Servlet

public class LoginServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        UserDao userDao = new UserDao();
        User user = userDao.getUserByName(username);
        if(user == null) {
            response.sendRedirect("login.jsp?error=1");
        } else {
            if(password.equals(user.getPassword())) {
                HttpSession session = request.getSession();
                session.setAttribute("user", user);
                response.sendRedirect("index.jsp");
            } else {
                response.sendRedirect("login.jsp?error=2");
            }
        }
    }
}

- 用户注册 Servlet

public class RegisterServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        String email = request.getParameter("email");
        String phone = request.getParameter("phone");
        User user = new User(username, password, email, phone);
        UserDao userDao = new UserDao();
        int result = userDao.addUser(user);
        if(result > 0) {
            response.sendRedirect("login.jsp");
        } else {
            response.sendRedirect("register.jsp?error=1");
        }
    }
}

- 电影查询 Servlet

public class MovieServlet extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String movieName = request.getParameter("movieName");
        MovieDao movieDao = new MovieDao();
        List<Movie> movies = movieDao.getMovieByMovieName(movieName);
        request.setAttribute("movies", movies);
        request.getRequestDispatcher("movie_list.jsp").forward(request, response);
    }
}

- 评论添加 Servlet

public class CommentServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        int userId = Integer.parseInt(request.getParameter("userId"));
        int movieId = Integer.parseInt(request.getParameter("movieId"));
        String commentContent = request.getParameter("commentContent");
        Comment comment = new Comment(movieId, userId, commentContent);
        CommentDao commentDao = new CommentDao();
        int result = commentDao.addComment(comment);
        if(result > 0) {
            response.sendRedirect("movie_detail.jsp?movieId=" + movieId);
        } else {
            response.sendRedirect("movie_detail.jsp?movieId=" + movieId + "&error=1");
        }
    }
}

3. 前端页面实现

您需要编写 JSP 页面来实现前端页面，例如登录页面、注册页面、电影列表页面、电影详情页面等。以下为示例代码：

- 登录页面 login.jsp

<form method="post" action="login">
  <input type="text" name="username" placeholder="用户名">
  <input type="password" name="password" placeholder="密码">
  <button type="submit">登录</button>
</form>

- 注册页面 register.jsp

<form method="post" action="register">
  <input type="text" name="username" placeholder="用户名">
  <input type="password" name="password" placeholder="密码">
  <input type="text" name="email" placeholder="邮箱">
  <input type="text" name="phone" placeholder="手机号">
  <button type="submit">注册</button>
</form>

- 电影列表页面 movie_list.jsp

<c:forEach items="${movies}" var="movie">
  <div>
    <h3>${movie.name}</h3>
    <p>${movie.description}</p>
    <a href="movie_detail.jsp?movieId=${movie.id}">查看详情</a>
  </div>
</c:forEach>

- 电影详情页面 movie_detail.jsp

<h3>${movie.name}</h3>
<p>${movie.description}</p>
<video src="${movie.url}" controls></video>
<h4>评论列表</h4>
<c:forEach items="${comments}" var="comment">
  <div>
    <p>${comment.content}</p>
    <p>${comment.time}</p>
  </div>
</c:forEach>
<form method="post" action="add_comment">
  <textarea name="commentContent"></textarea>
  <input type="hidden" name="userId" value="${user.id}">
  <input type="hidden" name="movieId" value="${movie.id}">
  <button type="submit">添加评论</button>
</form>

以上为示例代码，您可以根据自己的需求进行修改和完善。希望这些参考和指导对您有所帮助。