public List<Unit> findAllUnit() {
   String sql = "select * from Unit";
   OracleCachedRowSet ocrs = DbOperation.executeQuery(sql, null);
   List<Unit> list = new ArrayList<Unit>();
   try {
     while (ocrs.next()) {
       Unit unit = new Unit(ocrs.getString(1), ocrs.getDouble(2));
       list.add(unit);
     }
     if (!list.isEmpty()) {
       return list;
     } else {
       return null;
     }
   } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   } finally {
     try {
       ocrs.close();
     } catch (SQLException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
     }
   }
   return null;
 }
 public Unit findByUnit(String unitId) {
   String sql = "select * from Unit where unit = ?";
   Object[] objects = new Object[] {unitId};
   OracleCachedRowSet ocrs = DbOperation.executeQuery(sql, objects);
   Unit unit = null;
   try {
     if (ocrs.next()) {
       unit = new Unit(ocrs.getString(1), ocrs.getDouble(2));
     }
     return unit;
   } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   } finally {
     try {
       ocrs.close();
     } catch (SQLException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
     }
   }
   return null;
 }
 public List<Goods> findAllGoods() {
   String sql = "select * from Goods";
   OracleCachedRowSet ocrs = DbOperation.executeQuery(sql, null);
   List<Goods> list = new ArrayList<Goods>();
   try {
     while (ocrs.next()) {
       Goods goods =
           new Goods(
               ocrs.getString(1), ocrs.getString(2),
               ocrs.getString(3), ocrs.getString(4),
               ocrs.getString(5), ocrs.getString(6),
               ocrs.getString(7), ocrs.getString(8),
               ocrs.getString(9), ocrs.getString(10),
               ocrs.getString(11), ocrs.getDouble(12),
               ocrs.getDouble(13), ocrs.getDouble(14));
       list.add(goods);
     }
     if (!list.isEmpty()) {
       return list;
     } else {
       return null;
     }
   } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   } finally {
     try {
       ocrs.close();
     } catch (SQLException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
     }
   }
   return null;
 }
 public Goods findById(String goodsId) {
   String sql = "select * from Goods where goodsId = ?";
   Object[] objects = new Object[] {goodsId};
   OracleCachedRowSet ocrs = DbOperation.executeQuery(sql, objects);
   Goods goods = null;
   try {
     if (ocrs.next()) {
       goods =
           new Goods(
               ocrs.getString(1), ocrs.getString(2),
               ocrs.getString(3), ocrs.getString(4),
               ocrs.getString(5), ocrs.getString(6),
               ocrs.getString(7), ocrs.getString(8),
               ocrs.getString(9), ocrs.getString(10),
               ocrs.getString(11), ocrs.getDouble(12),
               ocrs.getDouble(13), ocrs.getDouble(14));
     }
     return goods;
   } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   } finally {
     try {
       ocrs.close();
     } catch (SQLException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
     }
   }
   return null;
 }
 public List<Goods> findByPage(PageBean pageBean) {
   String sql =
       "select * from (select gods.* ,rownum rn from (select * from Goods order by goodsId asc )gods where rownum <=?) where rn>=?";
   List<Goods> list = new ArrayList<Goods>();
   Object[] objects =
       new Object[] {
         PageBean.pageSize * pageBean.getCurrentPage(),
         PageBean.pageSize * (pageBean.getCurrentPage() - 1) + 1
       };
   OracleCachedRowSet ocrs = DbOperation.executeQuery(sql, objects);
   try {
     while (ocrs.next()) {
       Goods goods =
           new Goods(
               ocrs.getString(1), ocrs.getString(2),
               ocrs.getString(3), ocrs.getString(4),
               ocrs.getString(5), ocrs.getString(6),
               ocrs.getString(7), ocrs.getString(8),
               ocrs.getString(9), ocrs.getString(10),
               ocrs.getString(11), ocrs.getDouble(12),
               ocrs.getDouble(13), ocrs.getDouble(14));
       list.add(goods);
     }
     if (!list.isEmpty()) {
       return list;
     } else {
       return null;
     }
   } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   } finally {
     try {
       ocrs.close();
     } catch (SQLException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
     }
   }
   return null;
 }