public List<ShopDataBean> getarticleList() throws Exception{
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String sql = "";
		List<ShopDataBean> articleList = null;
		ShopDataBean shopBean = null;
		try{
			conn = getConnection();
			sql = "select cou_name,count(*) from coupon";
			pstmt = conn.prepareStatement(sql);
			rs =pstmt.executeQuery();
			if(rs.next()){
				articleList = new ArrayList<ShopDataBean>();
				do{
					shopBean = new ShopDataBean();
					shopBean.setCou_name(rs.getString("cou_name"));
					shopBean.setCou_quantity(rs.getInt(2));
					articleList.add(shopBean);
				}
				while(rs.next());
			}
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{
			if(rs!=null)try{rs.close();}catch(SQLException ex){}
			if(pstmt!=null)try{pstmt.close();}catch(SQLException ex){}
			if(conn!=null)try{conn.close();}catch(SQLException ex){}
		}
		return articleList;
	}