旅游网站~springmvc加mysql实现的旅游类网站功能齐全

package com.sxl.controller.admin; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import org.springframework.http.ResponseEntity; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import com.sxl.controller.MyController; import com.sxl.util.StringHelper; @Controller("frontController") @RequestMapping(value = "/front") public class FrontController extends MyController { @RequestMapping(value = "/index") public String frame(Model model, HttpServletRequest request) throws Exception { String sql = "select a.*,(select name from t_user b where b.id=a.userId) name from t_product a where 1=1 order by id desc limit 4"; List list = db.queryForList(sql); System.out.println(list); request.setAttribute("list", list); //随机推荐4个 sql = "select a.*,(select name from t_user b where b.id=a.userId) name from t_product a where 1=1 ORDER BY RAND() LIMIT 4"; List list2 = db.queryForList(sql); request.setAttribute("list2", list2); sql = "select * from t_lbt"; List list3 = db.queryForList(sql); request.setAttribute("list3", list3); sql="select a.* from t_zx a where 1=1 and types='景区' "; sql+=" ORDER BY RAND() LIMIT 4"; List jqList = db.queryForList(sql); request.setAttribute("jqList", jqList); sql="select a.* from t_zx a where 1=1 and types='线路' "; sql+=" ORDER BY RAND() LIMIT 4"; List xlList = db.queryForList(sql); request.setAttribute("xlList", xlList); return "/front/index"; } @RequestMapping(value = "/login") public String login(Model model, HttpServletRequest request) throws Exception { return "/front/login"; } @RequestMapping(value = "/all") public String all(Model model, HttpServletRequest request,Long typesId,String productName) throws Exception { String sql="select a.* from t_types a where 1=1"; sql+=" order by id desc"; List typesList = db.queryForList(sql); request.setAttribute("typesList", typesList); sql="select a.*,(select typesName from t_types b where a.typesId=b.id) typesName,(select name from t_user b where b.id=a.userId) name from t_product a where 1=1"; if(typesId!=null&&!"".equals(typesId)){ sql+=" and a.typesId="+typesId; } if(productName!=null&&!"".equals(productName)){ sql+=" and a.productName like '%"+productName+"%' "; } sql+=" order by id desc"; List list = db.queryForList(sql); request.setAttribute("list", list); return "/front/all"; } @RequestMapping(value = "/jfdh") public String jfdh(Model model, HttpServletRequest request) throws Exception { String sql="select a.* from t_jfdh a where 1=1"; sql+=" order by id desc"; List list = db.queryForList(sql); request.setAttribute("list", list); return "/front/jfdh"; } @RequestMapping(value = "/dhjfSave") public ResponseEntity<String> dhjfSave(Model model, HttpServletRequest request,Long id) throws Exception { Map map = db.queryForMap("select * from t_jfdh where id="+id); String jf = map.get("jfCost").toString(); String jfName = map.get("jfName").toString(); //订单 String sql = "insert into t_order(orderNum,customerId,productDetail,allPrice,status,insertDate) values(?,?,?,?,?,now())"; int result = db.update(sql, new Object[] { System.currentTimeMillis()+"", getCustomer(request).get("id").toString(), jfName+"积分兑换["+jf+"]", 0+"", "兑换完成" }); sql="update t_customer set jf = jf-"+jf+" where id="+getCustomer(request).get("id"); db.update(sql); //积分减少 return renderData(true, "操作成功", null); } @RequestMapping(value = "/register") public String register(Model model, HttpServletRequest request) throws Exception { System.out.println("112312312"); return "/front/register"; } @RequestMapping(value = "/detail") public String detail(Model model, HttpServletRequest request, Long id) throws Exception { String sql = "select a.*,(select typesName from t_types b where a.typesId=b.id) typesName," + "(select name from t_user b where b.id=a.userId) name from t_product a where id=" + id; Map map = db.queryForMap(sql); request.setAttribute("map", map); String sql2="select a.*,(select max(customerName) from t_customer b where a.customerId=b.id) customerName from t_pinglun_product a where productId=? order by id desc"; List<Map> list = db.queryForList(sql2,new Object[]{id}); model.addAttribute("list", list); return "/front/detail"; } @RequestMapping(value = "/myOrder") public String myOrder(Model model, HttpServletRequest request) throws Exception { String sql = "select a.*,(select max(customerName) from t_customer b where a.customerId=b.id) customerName from t_order a where 1=1 "; if (1 == 1) { sql += "and customerId=" + getCustomer(request).get("id") + " "; } sql += " order by id desc"; List list = db.queryForList(sql); request.setAttribute("orderList", list); return "/front/myOrder"; } @RequestMapping(value = "/deleteOneOrder") public ResponseEntity<String> deleteOneOrder(Model model, HttpServletRequest request,Long id) throws Exception { String sql="delete from t_order where id="+id; db.update(sql); return renderData(true, "操作成功", null); } @RequestMapping(value = "/addShopcar") public ResponseEntity<String> addShopcar(Model model, HttpServletRequest request, Long id, Integer num) throws Exception { int result = 0; // 判断该用户是否 String sql = "select * from t_shopcar where productId=? and customerId=?"; Map map = db.queryForMap(sql, new Object[] { id.toString(), getCustomer(request).get("id").toString() }); if (map != null && map.size() > 0) { sql = "update t_shopcar set productId=?,num=num+" + num + " where id=?"; result = db.update(sql, new Object[] { id, map.get("id") }); } else { sql = "insert into t_shopcar(productId,num,customerId) values(?,?,?)"; result = db.update(sql, new Object[] { id, num, getCustomer(request).get("id").toString() }); } if (result == 1) { return renderData(true, "操作成功", null); } else { return renderData(false, "操作失败", null); } } @RequestMapping(value = "/checkIsLogin") public ResponseEntity<String> checkIsLogin(Model model, HttpServletRequest request) throws Exception { Map customer = getCustomer(request); if (customer != null && customer.size() > 0) { return renderData(true, "操作成功", null); } else { return renderData(false, "操作失败", null); } } @RequestMapping(value = "/pay") public ResponseEntity<String> pay(Model model, HttpServletRequest request) throws Exception { String sql = "select a.*,(select productName from t_product b where a.productId=b.id) productName," + "(select price from t_product b where a.productId=b.id) price,(select jf from t_product b where a.productId=b.id) jf from t_shopcar a where customerId=" + getCustomer(request).get("id"); sql += " order by id desc"; List<Map> list = db.queryForList(sql); int total = 0; int jf = 0; String productDetail = ""; for (int i = 0; i < list.size(); i++) { productDetail += "," + list.get(i).get("productName") + "[" + list.get(i).get("num") + "]"; total += Integer.parseInt(list.get(i).get("price").toString()) * Integer.parseInt(list.get(i).get("num").toString()); // jf+=Integer.parseInt(list.get(i).get("jf").toString()) // * Integer.parseInt(list.get(i).get("num").toString()); String sql2="update t_product set nums=nums-"+list.get(i).get("num").toString()+" where id="+list.get(i).get("productId").toString(); db.update(sql2); } total+=20; sql = "insert in