影像租赁管理系统（JAVAEE课程设计）

package Servlets; import java.io.IOException; import java.io.PrintWriter; import java.net.URLEncoder; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Date; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import Dao.RentInfoDao; import JDBC.DBUtil; import bean.RentInfo; /** * Servlet implementation class RentVideo */ @WebServlet("/rentVideo") public class rentVideo extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public rentVideo() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub //response.getWriter().append("Served at: ").append(request.getContextPath()); PrintWriter out=response.getWriter(); response.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); request.setCharacterEncoding("utf-8"); int videoId=Integer.parseInt(request.getParameter("videoId")); //String username=request.getParameter("name"); String username=(String) request.getSession().getAttribute("name"); System.out.println(videoId); System.out.println(username); Connection conn = null; Statement stmt = null; ResultSet rs = null; int result=0; int user_id = 0; String title = ""; int price = 0; String expected_return_date =""; try { conn = DBUtil.getConn(); stmt = conn.createStatement(); String sqlstr = "select * from video where id='" + videoId + "'and state='可租赁'"; rs = stmt.executeQuery(sqlstr); rs.next(); if (rs.getRow() != 0) { rs.last();//对rs的操作应马上操作,操作完后再从数据库得到rs,再对rs操作 // 查询影像名称，价格 String sql = "select title,price from video where id='" + videoId + "'"; rs = stmt.executeQuery(sql); while (rs.next()) { title = rs.getString(1); // price:租金，点击租赁，租金即为影像的价格 price = rs.getInt(2); } // 查询用户编号 rs.last();//对rs的操作应马上操作,操作完后再从数据库得到rst,再对rst操作 sql = "select id from user where name='" + username + "'"; rs = stmt.executeQuery(sql); while (rs.next()) { user_id = rs.getInt(1); } // 获取当前系统时间--租赁时间 Date currentTime = new Date(); SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd"); String rent_date = formatter.format(currentTime); System.out.println("租赁时间："); System.out.println(rent_date); // 设置最晚归还时间，设置租借期限为10天 Calendar cal = Calendar.getInstance(); cal.setTime(currentTime); cal.add(Calendar.DAY_OF_MONTH, 10); Date excepted_return_time = cal.getTime(); expected_return_date = formatter.format(excepted_return_time); System.out.println("应归还时间："); System.out.println(expected_return_date); // 更新影像信息表中状态为“已租赁” sql = "update video set state='已租赁' where id=" + videoId; stmt.executeUpdate(sql); // 将各个参数插入到租赁信息表中 sql = "insert into rentinfo (title,user_id, video_id,rent_date,expected_return_date,return_date,state,rental)values ('" + title + "', '" + user_id + "', '" + videoId + "','" + rent_date + "','" + expected_return_date+ "',' ','未归还','" + price + "')"; result=stmt.executeUpdate(sql); if (result>0) { System.out.println("租赁影像成功!"); //out.print("<script>alert('租赁影像成功！');</script>"); //response.sendRedirect("/RentSystem/U_rentVideo.jsp"); String a = URLEncoder.encode("租赁影像成功！", "UTF-8"); out.print("<script language='javascript'>alert(decodeURIComponent('"+a+"'));window.location.href='U_rentVideo.jsp'</script>"); } else { System.out.println("租赁失败！"); //out.print("<script>alert('租赁影像失败！');</script>"); //response.sendRedirect("/RentSystem/U_rentVideo.jsp"); String a = URLEncoder.encode("租赁影像失败，请重新选择！", "UTF-8"); out.print("<script language='javascript'>alert(decodeURIComponent('"+a+"'));window.location.href='U_rentVideo.jsp'</script>"); } } else { //out.print("<script>alert('该影像已租赁！');window.location.href='U_rentInformation.jsp'"); System.out.println("该影像已租赁！"); String a = URLEncoder.encode("该影像已被租赁，请选择未租赁的影像！", "UTF-8"); out.print("<script language='javascript'>alert(decodeURIComponent('"+a+"'));window.location.href='U_rentVideo.jsp'</script>"); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } try { rs.close(); stmt.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }