毕业设计-基于ssm+jsp+mysql的医院门诊管理系.zip

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) userName,(select typesName from t_types b where b.id=a.typesId) typesName 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,(select typesName from t_types b where b.id=a.typesId) typesName 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); return "/front/index"; } @RequestMapping(value = "/login") public String login(Model model, HttpServletRequest request) throws Exception { return "/front/login"; } @RequestMapping(value = "/zf") public String zf(Model model, HttpServletRequest request,Long id) throws Exception { String sql="select * from t_yy where id=?"; Map map = db.queryForMap(sql,new Object[]{id}); model.addAttribute("map", map); return "/front/zf"; } @RequestMapping(value = "/zfSave") public ResponseEntity<String> zfSave(Model model, HttpServletRequest request,Long id) throws Exception { String sql="update t_yy set status=? where id=?"; int result = db.update(sql, new Object[]{"问诊完成",id}); return renderData(true, "操作成功", null); } @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 exists(select 1 from t_user b where a.userId=b.id and b.name like '%"+productName+"%') "; } sql+=" order by id desc"; System.out.println(sql); 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 ,(select max(name) from t_user b where a.userId=b.id) name from t_yy 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,String flag ,Integer customerId,String yyDate,String zd,Integer zdfee,String ypqd,Integer ypqdfee,String status,Integer userId) throws Exception { int result = 0; // 判断该用户是否 String sql="insert into t_yy(customerId,yyDate,zd,zdfee,ypqd,ypqdfee,status,userId) values(?,?,?,?,?,?,?,?)"; result = db.update(sql, new Object[]{getCustomer(request).get("id"),yyDate,zd,zdfee,ypqd,ypqdfee,"排队中",userId}); return renderData(true, "操作成功", 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="upda