基于jsp的航空票务系统论文(8)

合肥师范学院2015届本科生毕业论文（设计）

public List> selectUser(String sql, Object[] parames) throws SQLException { List> list = new ArrayList>(); dao.doSql(sql, parames); ResultSet rs = dao.getRs(); rs.last(); int i = rs.getRow(); if(i>0){ rs.beforeFirst(); while(rs.next()){ String id = rs.getString(\ String name = rs.getString(2); String password = rs.getString(\ String sex = rs.getString(4); String tel = rs.getString(5); String idcard = rs.getString(6); String level = rs.getString(\ Map map = new HashMap(); map.put(\ map.put(\ map.put(\ map.put(\ map.put(\ map.put(\ map.put(\ list.add(map); } }else{ list=null; } return list; }

/**

* 查询订单

* @throws SQLException */

public List> selectMyTicket(String sql, Object[] parames) throws SQLException { List> list = new ArrayList>(); dao.doSql(sql, parames); ResultSet rs = dao.getRs(); rs.last(); int i = rs.getRow();

32

合肥师范学院2015届本科生毕业论文（设计）

System.out.println(\结果集中有\条记录\ if(i>0){ rs.beforeFirst(); while(rs.next()){ String id = rs.getString(\ String start = rs.getString(2); String end = rs.getString(3); String leaveTime = rs.getString(4); String arriveTime = rs.getString(5); String time = rs.getString(6); String seatLevel = rs.getString(7); String fare = rs.getString(8); String name = rs.getString(9); String idcard = rs.getString(10); String flight_id = rs.getString(11); Map map = new HashMap(); map.put(\ map.put(\ map.put(\ map.put(\ map.put(\ map.put(\ map.put(\ map.put(\ map.put(\ map.put(\ map.put(\ list.add(map); } }else{ list=null; } return list; } /**

* 分页 */

public int getJiPiao(HttpServletRequest request, HttpServletResponse response) throws SQLException { int allRecord= 0;//总记录数 int allPage;//总页数 int startRecord;//每页第一条记录 int nowPage = 1;

33

合肥师范学院2015届本科生毕业论文（设计）

//获得总记录数 String sql = \ Object parames[] = new Object[]{}; dao.doSql(sql, parames); ResultSet rs = dao.getRs(); rs.last(); allRecord = rs.getRow(); //i是所有记录数 //获得总显示页数 if(allRecord%5==0){ allPage = allRecord/5; }else{ allPage = allRecord/5+1; } //获得当前页 String newPage = request.getParameter(\ //获得要跳转到的页数 String bb = request.getParameter(\ if(bb!=null&&bb!=\

if(bb!=null&&bb!=\ newPage = bb; } if(bb!=null&&bb!=\ newPage = String.valueOf(allPage); } } //获得当前记录数 if(newPage==null || newPage==\ startRecord = 0; }else{ nowPage = Integer.parseInt(newPage); startRecord = (nowPage-1)*5; } //计算分页显示页码的开始页和结束页 int start = 0; int end = 0; if(allPage<5){ start = 1; end = allPage; }else{ start = nowPage-2; end = nowPage+2; if(start<1){ start = 1;

34

合肥师范学院2015届本科生毕业论文（设计）

}

}

end = 5; } if(end>allPage){ start = allPage-4; end = allPage; } }

request.setAttribute(\request.setAttribute(\request.setAttribute(\request.setAttribute(\return startRecord;

3、机票预订生成订单： /**

* 订票------生产订单 */

public void dingPiao(HttpServletRequest request, HttpServletResponse response) throws SQLException, IOException { String id = request.getParameter(\ Object parames[] = new Object[]{id}; String sql = \ List> list = fun.selectTicket(sql, parames); Map map = list.get(0); int ticketNum = Integer.parseInt(map.get(\ Object parames1[] = new Object[]{ticketNum-1,id}; String sql1 = \ int i = fun.update(sql1, parames1); if(i!=-1){ //1.随机产生订单号---id long id1 = (long)(Math.random()*100000000); //2,获得票的信息 String start1 = map.get(\ String end1 = map.get(\ String leaveTime1 = map.get(\ String arriveTime1 = map.get(\ String time1 = map.get(\ String seatLevel1 = map.get(\ String fare1 = map.get(\ String flight_id1 = map.get(\

35

合肥师范学院2015届本科生毕业论文（设计）

//2,获得订票人的名字和身份证 HttpSession session = request.getSession(); String name1 = (String) session.getAttribute(\ String sql2 = \ Object parames2[] = new Object[]{name1}; List> list2 = fun.selectUser(sql2, parames2); Map map2 = (Map) list2.get(0); String idcard1 = map2.get(\ //3,生成订单 String sql3 = \ Object parames3[] = new Object[]{id1,start1,end1,leaveTime1,arriveTime1, time1,seatLevel1,fare1,name1,idcard1,flight_id1}; fun.insert(sql3, parames3); response.sendRedirect(\ }else{ System.out.println(\订票失败~~~\ response.sendRedirect(\ } }

3、我的订单管理用户退票： /** * 退票 */

public void tuiPiao(HttpServletRequest request, HttpServletResponse response)

throws SQLException, ServletException, IOException { //获得要退票的订单号 String id = request.getParameter(\ Object parames[] = new Object[]{id}; //1,根据订单号找到（起飞时间，到达时间，起飞地，目的地，日期，航班号） String sql1 = \ List> list = fun.selectMyTicket(sql1, parames); Map map = list.get(0); String start = map.get(\ String end = map.get(\ String leaveTime = map.get(\ String arriveTime = map.get(\ String time = map.get(\ String flight_id = map.get(\ //2，根据订单号从我的订单中删除机票记录 String sql = \ fun.delete(sql, parames);

36