基于协同过滤算法实现海洋馆预约服务平台的设计与开发

package com.lvyou.controller;
import java.io.IOException;
import java.nio.charset.Charset;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.lang.StringUtils;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
import com.lvyou.dao.MyBatiesPublic;
import com.sxl.util.DBHelper;
import com.sxl.util.JacksonJsonUtil;
public class MyController{
  @Autowired
  public MyBatiesPublic db2;
  @Autowired
  public DBHelper db;
  public Map getAdmin(HttpServletRequest request){
    Map customerBean = (Map)request.getSession().getAttribute("adminBean");
    return customerBean;
  }
  public Map getCustomer(HttpServletRequest request){
    Map customerBean = (Map)request.getSession().getAttribute("customerBean");
    return customerBean;
  }
  public Map getUser(HttpServletRequest request){
    Map customerBean = (Map)request.getSession().getAttribute("userBean");
    return customerBean;
  }
  public ResponseEntity<String> renderMsg(Boolean status, String msg) {
    if (StringUtils.isEmpty(msg)) {
      msg = "";
    }
    StringBuffer sb = new StringBuffer();
    sb.append("{");
    sb.append("\"status\":\"" + status + "\",\"msg\":\"" + msg + "\"");
    sb.append("}");
    ResponseEntity<String> responseEntity = new ResponseEntity<String>(
        sb.toString(), initHttpHeaders(), HttpStatus.OK);
    return responseEntity;
  }
  public void writeToExcel(HSSFWorkbook wb, String fileName,HttpServletResponse response)
      throws IOException {
    fileName = (fileName == null || fileName.equals("")) ? "result"
        : fileName;
    fileName = java.net.URLEncoder.encode(fileName, "UTF-8").replace('+',
        ' ');
    response.reset();
    response.setContentType("application/vnd.ms-excel");
    response.setHeader("Content-Disposition", "attachment;filename="
        + fileName + ".xls");
    wb.write(response.getOutputStream());
    response.getOutputStream().flush();
    response.getOutputStream().close();
  }
  public ResponseEntity<String> renderData(Boolean status, String msg,
      Object obj) {
    if (StringUtils.isEmpty(msg)) {
      msg = "";
    }
    StringBuffer sb = new StringBuffer();
    sb.append("{");
    sb.append("\"status\":\"" + status + "\",\"msg\":\"" + msg + "\",");
    sb.append("\"data\":" + JacksonJsonUtil.toJson(obj) + "");
    sb.append("}");
    ResponseEntity<String> responseEntity = new ResponseEntity<String>(
        sb.toString(), initHttpHeaders(), HttpStatus.OK);
    return responseEntity;
  }
  public ResponseEntity<String> renderComboBoxAjax(Object obj) {
    ResponseEntity<String> responseEntity = new ResponseEntity<String>(
        JacksonJsonUtil.toJson(obj), initHttpHeaders(), HttpStatus.OK);
    return responseEntity;
  }
  /**
   * 返回服务器地址 like http://192.168.1.1:8441/UUBean/
   */
  public String getHostUrl(HttpServletRequest request) {
    String hostName = request.getServerName();
    Integer hostPort = request.getServerPort();
    String path = request.getContextPath();
    if (hostPort == 80) {
      return "http://" + hostName + path + "/";
    } else {
      return "http://" + hostName + ":" + hostPort + path + "/";
    }
  }
  /***
   * 获取当前的website路径 String
   */
  public static String getWebSite(HttpServletRequest request) {
    String returnUrl = request.getScheme() + "://"
        + request.getServerName();
    if (request.getServerPort() != 80) {
      returnUrl += ":" + request.getServerPort();
    }
    returnUrl += request.getContextPath();
    return returnUrl;
  }
  /**
   * 初始化HTTP头.
   * 
   * @return HttpHeaders
   */
  public HttpHeaders initHttpHeaders() {
    HttpHeaders headers = new HttpHeaders();
    MediaType mediaType = new MediaType("text", "html",
        Charset.forName("utf-8"));
    headers.setContentType(mediaType);
    return headers;
  }
  /***
   * 获取IP（如果是多级代理，则得到的是一串IP值）
   */
  public static String getIpAddr(HttpServletRequest request) {
    String ip = request.getHeader("x-forwarded-for");
    if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
      ip = request.getHeader("Proxy-Client-IP");
    }
    if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
      ip = request.getHeader("WL-Proxy-Client-IP");
    }
    if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
      ip = request.getRemoteAddr();
    }
    if (ip != null && ip.length() > 0) {
      String[] ips = ip.split(",");
      for (int i = 0; i < ips.length; i++) {
        if (!"unknown".equalsIgnoreCase(ips[i])) {
          ip = ips[i];
          break;
        }
      }
    }
    return ip;
  }
}

package com.lvyou.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.lvyou.controller.MyController;
@Controller("adminCustomerController")
@RequestMapping(value = "/admin/customer")
public class AdminCustomerController extends MyController {
  @RequestMapping(value = "/frame")
  public String frame(Model model, HttpServletRequest request)throws Exception {
    return "/admin/customer/frame";
  }
  @RequestMapping(value = "/list")
  public String list(Model model, HttpServletRequest request,String username,String customerName)throws Exception {
    String sql="select a.* from t_customer a where 1=1";
  if(username!=null&&!"".equals(username)){
      sql+=" and username like '%"+username+"%'";
    }
  if(customerName!=null&&!"".equals(customerName)){
      sql+=" and customerName like '%"+customerName+"%'";
    }
    sql+=" order by id desc";
    List list = db.queryForList(sql);
    request.setAttribute("list", list);
    return "/admin/customer/list";
  }
  @RequestMapping(value = "/editSave")
  public ResponseEntity<String> editSave(Model model,HttpServletRequest request,Long id
    ,String username,String password,String customerName,String sex,String address,String phone,Integer account,Integer jf,String status) throws Exception{
    int result = 0;
    if(id!=null){
      String sql="update t_customer set username=?,password=?,customerName=?,sex=?,address=?,phone=?,account=?,jf=?,status=? where id=?";
      result = db.update(sql, new Object[]{username,password,customerName,sex,address,phone,account,jf,status,id});
    }else{
      String sql="insert into t_customer(username,password,customerName,sex,address,phone,account,jf,status) values(?,?,?,?,?,?,?,?,?)";
      result = db.update(sql, new Object[]{username,password,customerName,sex,address,phone,account,jf,status});
    }
    if(result==1){
      return renderData(true,"操作成功",null);
    }else{
      return renderData(false,"操作失败",null);
    }
  }
  @RequestMapping(value = "/editDelete")
  public ResponseEntity<String> editDelete(Model model,HttpServletRequest request,Long id) throws Exception {
    String sql="delete from t_customer where id=?";
    int result = db.update(sql, new Object[]{id});
    if(result==1){
      return renderData(true,"操作成功",null);
    }else{
      return renderData(false,"操作失败",null);
    }
  }
  @RequestMapping(value = "/updateColumnsex")
  public ResponseEntity<String> updateColumnsex(Model model,HttpServletRequest request,Long id,String sex) throws Exception {
    String sql="update t_customer set sex=?   where id=?";
    int result = db.update(sql, new Object[]{sex,id});
    if(result==1){
      return renderData(true,"操作成功",null);
    }else{
      return renderData(false,"操作失败",null);
    }
  }
  @RequestMapping(value = "/edit")
  public String edit(Model model, HttpServletRequest request,Long id)throws Exception {
    if(id!=null){
      //修改
      String sql="select * from t_customer where id=?";
      Map map = db.queryForMap(sql,new Object[]{id});
      model.addAttribute("map", map);
    }String sql="";
    return "/admin/customer/edit";
  }
}