public int allQuantity(String cou_name){
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String sql = "";
		int result = 0;
		try{
			conn = getConnection();
			sql = "select cou_name,count(*) as quantity from coupon where cou_name=?";
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, cou_name);
			rs =pstmt.executeQuery();
			if(rs.next()){
				result = rs.getInt("quantity");
			}
		}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 result;
	}