storedao.java

来自「一个完整的网络订餐系统」· Java 代码 · 共 611 行 · 第 1/2 页

         model.setStoreID(rs.getString("storeID"));
         model.setAdminname(rs.getString("adminname"));
         model.setAdminpassword(rs.getString("adminpassword"));
         model.setStoreName(rs.getString("storeName"));
         model.setProvince(rs.getString("province"));
         model.setArea(rs.getString("area"));
         model.setRelationer(rs.getString("relationer"));
         model.setPhone(rs.getString("phone"));
         model.setFax(rs.getString("fax"));
         model.setEmail(rs.getString("email"));
         model.setAddress(rs.getString("address"));
         model.setPostcode(rs.getString("postcode"));
         model.setNetadderss(rs.getString("netadderss"));
         model.setLocation(rs.getString("location"));
         model.setMemo(rs.getString("memo"));
         model.setPointer(rs.getInt("pointer"));
         model.setStarNum(rs.getInt("starNum"));
         model.setCreatedate(rs.getString("createdate"));
         model.setModifydate(rs.getString("modifydate"));
         storeList.add(model);
         if (rs.next()) {
           hasnext = true;
         }
         else {
           hasnext = false;
         }
       }
     }
   }
   catch (Exception exception) {
     exception.printStackTrace();
   }
   finally {
     try {
       if (rs != null)
         rs.close();
       if (stmt != null)
         stmt.close();
       if (conn != null)
         dbc.closeDBConnection(conn);
     }
     catch (SQLException e) {}
   }

   bsrt.setStoreList(storeList);
   bsrt.setTotalRecNum(totalRecNum);
   return bsrt;
 }


 //获得一个快餐店的详细信息
 public Store getOneStoreByID(String storeID)
 {
   DBConnection dbc = null;
   Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   Store model = null;
   String strSQL = " SELECT * FROM store  where storeID='"+storeID+"'";
   try
   {
     dbc = new DBConnection();
     conn = dbc.getDBConnection();
     stmt = conn.createStatement();
     rs = stmt.executeQuery(strSQL);
     if (rs.next())
     {
       model = new Store();
       model.setStoreID(rs.getString("storeID"));
       model.setAdminname(rs.getString("adminname"));
       model.setAdminpassword(rs.getString("adminpassword"));
       model.setStoreName(rs.getString("storeName"));
       model.setProvince(rs.getString("province"));
       model.setArea(rs.getString("area"));
       model.setRelationer(rs.getString("relationer"));
       model.setPhone(rs.getString("phone"));
       model.setFax(rs.getString("fax"));
       model.setEmail(rs.getString("email"));
       model.setAddress(rs.getString("address"));
       model.setPostcode(rs.getString("postcode"));
       model.setNetadderss(rs.getString("netadderss"));
       model.setLocation(rs.getString("location"));
       model.setMemo(rs.getString("memo"));
       model.setPointer(rs.getInt("pointer"));
       model.setStarNum(rs.getInt("starNum"));
       model.setCreatedate(rs.getString("createdate"));
       model.setModifydate(rs.getString("modifydate"));
     }
    }
   catch (Exception exception) {
     exception.printStackTrace();
   }
   finally {
     try {
       if (rs != null)
         rs.close();
       if (stmt != null)
         stmt.close();
       if (conn != null)
         dbc.closeDBConnection(conn);
     }
     catch (SQLException e) {}
   }
   return model;
 }

 public boolean checkStoreAccount(String adminname)
 {
   DBConnection dbc = null;
   Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   boolean isStore = false;
   String strSQL = " SELECT * FROM store  where adminname='" + adminname + "'";
   try {
     dbc = new DBConnection();
     conn = dbc.getDBConnection();
     stmt = conn.createStatement();
     rs = stmt.executeQuery(strSQL);
     if (rs.next()) {
       isStore = true;
     }
   }
   catch (Exception exception) {
     exception.printStackTrace();
   }
   finally {
     try {
       if (rs != null)
         rs.close();
       if (stmt != null)
         stmt.close();
       if (conn != null)
         dbc.closeDBConnection(conn);
     }
     catch (SQLException e) {}
   }
   return isStore;
 }

 public SessionContext logonEsnack(String adminname,String adminpass)
 {
   SessionContext sc = null;
   DBConnection dbc = null;
   Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   String storeName = null;
   String storeID = null;
   String strSQL = " SELECT * FROM store  where adminname='" + adminname + "' and adminpassword='"+adminpass+"'";

   try {
     dbc = new DBConnection();
     conn = dbc.getDBConnection();
     stmt = conn.createStatement();
     rs = stmt.executeQuery(strSQL);
     if (rs.next()) {
       storeID = rs.getString("storeID");
       storeName = rs.getString("storeName");
       sc = new SessionContext(storeID,storeName);
     }
   }
   catch (Exception exception) {
     exception.printStackTrace();
   }
   finally {
     try {
       if (rs != null)
         rs.close();
       if (stmt != null)
         stmt.close();
       if (conn != null)
         dbc.closeDBConnection(conn);
     }
     catch (SQLException e) {}
   }
   return sc;
 }


 public Store getStoreInfo(String storeID)
 {
   Store store = null;

     DBConnection dbc = null;
     Connection conn = null;
     Statement stmt = null;
     ResultSet rs = null;
     String strSQL = null;

     try
     {
       dbc = new DBConnection();
       conn = dbc.getDBConnection();
       stmt = conn.createStatement();

       strSQL =  " SELECT storeName,province,area,relationer,phone,fax,email,address,postcode,netadderss,";
       strSQL += " location,memo,pointer,starNum,createdate,streetName ";
       strSQL += " FROM store a,street b WHERE  a.streetID=b.streetID AND storeID='"+storeID+"'";

       rs = stmt.executeQuery(strSQL);
       while(rs.next())
       {
         store  = new Store();
         store.setAddress(rs.getString("address"));
         store.setArea(rs.getString("area"));
         store.setCreatedate(rs.getString("createdate"));
         store.setEmail(rs.getString("email"));
         store.setFax(rs.getString("fax"));
         store.setLocation(rs.getString("location"));
         store.setMemo(rs.getString("memo"));
         store.setNetadderss(rs.getString("netadderss"));
         store.setPhone(rs.getString("phone"));
         store.setPointer(rs.getInt("pointer"));
         store.setPostcode(rs.getString("postcode"));
         store.setProvince(rs.getString("province"));
         store.setRelationer(rs.getString("relationer"));
         store.setStarNum(rs.getInt("starNum"));
         store.setStoreName(rs.getString("storeName"));
         store.setStreetID(rs.getString("streetName"));
       }
     }
     catch (Exception e)
     {
       e.printStackTrace();
       System.out.println("\n" + e.toString() + "获得饭店信息" + strSQL); /////错误处理！
     }
     finally
     {
       try
       {
         if (stmt != null)  stmt.close();
         if (rs != null)  rs.close();
         if (conn != null)  dbc.closeDBConnection(conn);
       }
       catch (Exception ex) {}
     }

   return store;
 }

 //查最新的店
 public List getNewStoreList(String areaID)
 {
   List storeList = new ArrayList();

   DBConnection dbc = null;
   Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;

   String strSQL = null;

   strSQL = "SELECT top 5 * FROM store  WHERE streetID LIKE '%"+areaID+"%'  order by  modifyDate  desc";

   try {
     dbc = new DBConnection();
     conn = dbc.getDBConnection();
     stmt = conn.createStatement();
     rs = stmt.executeQuery(strSQL);
     while(rs.next())
     {
         Store model = new Store();
         model.setStoreID(rs.getString("storeID"));
         model.setAdminname(rs.getString("adminname"));
         model.setAdminpassword(rs.getString("adminpassword"));
         model.setStoreName(rs.getString("storeName"));
         model.setProvince(rs.getString("province"));
         model.setArea(rs.getString("area"));
         model.setRelationer(rs.getString("relationer"));
         model.setPhone(rs.getString("phone"));
         model.setFax(rs.getString("fax"));
         model.setEmail(rs.getString("email"));
         model.setAddress(rs.getString("address"));
         model.setPostcode(rs.getString("postcode"));
         model.setNetadderss(rs.getString("netadderss"));
         model.setLocation(rs.getString("location"));
         model.setMemo(rs.getString("memo"));
         model.setPointer(rs.getInt("pointer"));
         model.setStarNum(rs.getInt("starNum"));
         model.setCreatedate(rs.getString("createdate"));
         model.setModifydate(rs.getString("modifydate"));
         storeList.add(model);

     }
   }
   catch (Exception exception) {
     exception.printStackTrace();
   }
   finally {
     try {
       if (rs != null)
         rs.close();
       if (stmt != null)
         stmt.close();
       if (conn != null)
         dbc.closeDBConnection(conn);
     }
     catch (SQLException e) {}
   }
   return storeList;
 }
}