手机点菜系统源码

package com.lixa.servlet.order; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.lixa.bean.Order; import com.lixa.dao.OrderDao; import com.lixa.dao.impl.OrderDaoImpl; import com.lixa.util.DBUtil; public class ClientUpdateOrderServlet extends HttpServlet{ private static final long serialVersionUID = -4701632877664998115L; private OrderDao dao = new OrderDaoImpl(); /** * 客户端返回数据统计 * error 为服务器错误 * 返回相应请求的数据 * new update delete error */ @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); // id-version,id-version String data = request.getParameter("data").trim(); // new update delete error String type = request.getParameter("type").trim(); // System.out.println("data: " + data); // System.out.println("type: " + type); Connection conn = DBUtil.getConnForMySql(); PreparedStatement pstmt = null; ResultSet rs = null; StringBuilder result = new StringBuilder(); String sql = ""; /** * new 当data为 "" ，则返回当前服务器菜单表中没有删除的信息，如果data不为空，把新增返回数据 * * update 比对客户端的ID和版本，如果服务器没有删除，而且版本大约客户端版本，返回更新的菜单信息 * * delete 比对客户端的ID，如果服务器删除，则返回响应的ID * * error 比对客户端ID，如果不存在，则返回ID，在客户端进行删除 【传输过程错误等情况可出现此类数据】 * */ if("new".equals(type)){ if("".equals(data)){ // 客户端无数据 try { sql = "select * from orders where is_delete=0"; conn = DBUtil.getConnForMySql(); pstmt = DBUtil.getPreparedStatemnt(conn, sql); rs = pstmt.executeQuery(); while(rs.next()){ result.append(rs.getString("id")).append("@"); result.append(rs.getString("name")).append("@"); result.append(rs.getString("description")).append("@"); result.append(rs.getString("type")).append("@"); result.append(rs.getString("order_version")).append("@"); result.append(rs.getString("image_path")).append("@"); result.append(rs.getString("price")).append("#"); } if(result.length()>0) out.print(result.substring(0, result.length()-1)); else out.print(""); return; } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.CloseResources(conn, pstmt, rs); } }else{// 客户端有数据 String datas[] = data.split(","); StringBuilder ids = new StringBuilder(); for(int i = 0; i < datas.length; i ++){ ids.append("'").append(datas[i].split("-")[0]).append("'").append(","); } try { sql = "select * from orders where is_delete=0 and id not in(" + ids.substring(0, ids.length()-1) + ")"; System.out.println(sql); conn = DBUtil.getConnForMySql(); pstmt = DBUtil.getPreparedStatemnt(conn, sql); rs = pstmt.executeQuery(); while(rs.next()){ result.append(rs.getString("id")).append("@"); result.append(rs.getString("name")).append("@"); result.append(rs.getString("description")).append("@"); result.append(rs.getString("type")).append(","); result.append(rs.getString("order_version")).append("@"); result.append(rs.getString("image_path")).append("@"); result.append(rs.getString("price")).append("#"); } if(result.length()>0) out.print(result.substring(0, result.length()-1)); else out.print(""); return; } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.CloseResources(conn, pstmt, rs); } } } else if ("update".equals(type)){ String datas[] = data.split(","); String id = ""; String version = ""; for(int i = 0; i < datas.length; i ++){ id = datas[i].split("-")[0]; version = datas[i].split("-")[1]; Order o = dao.getOrderById(id); if(!o.getVersion().equals(version)&&"0".equals(o.getIs_delete())){ result.append(o.getId()).append("@"); result.append(o.getName()).append("@"); result.append(o.getDescription()).append("@"); result.append(o.getType()).append("@"); result.append(o.getVersion()).append("@"); result.append(o.getImgage_path()).append("@"); result.append(o.getPrice()).append("#"); } } if(result.length()>0) out.print(result.substring(0, result.length()-1)); else out.print(""); return; } else if ("delete".equals(type)){ String datas[] = data.split(","); String id = ""; for(int i = 0; i < datas.length; i ++){ id = datas[i].split("-")[0]; Order o = dao.getOrderById(id); if("1".equals(o.getIs_delete())){ result.append(o.getId()).append(","); } } if(result.length()>0) out.print(result.substring(0, result.length()-1)); else out.print(""); } else if("error".equals(type)){ String datas[] = data.split(","); String id = ""; for(int i = 0; i < datas.length; i ++){ id = datas[i].split("-")[0]; Order o = dao.getOrderById(id); if(null == o) result.append(id).append(","); } if(result.length()>0) out.print(result.substring(0, result.length()-1)); else out.print(""); } else { result.append("error"); } } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } @Override public void destroy() { super.destroy(); } @Override public void init() throws ServletException { super.init(); } }