- 博客(1)
- 资源 (2)
- 收藏
- 关注
原创 mysql 统计场景语句
下面为一个商品购买记录表buys,字段id为主键,字段buy_time为购买时间(每次购买1件),字段uid为客户id,字段sid为商品id (只有3种商品)请使用sql语句,按日期统计3种商品购买数(如下图)解决方案select da,sum(cnt1)as sid1,sum(cnt2)as sid2,sum(cnt3)as sid3 from (sele
2014-03-05 11:19:32 621
zipme包---j2me的zip
Package net.sf.zipme
Interface Summary
Checksum Interface to compute a data checksum used by checked input/output streams.
Class Summary
Adler32 Computes Adler32 checksum for a stream of data.
CheckedInputStream InputStream that computes a checksum of the data being read using a supplied Checksum object.
CheckedOutputStream OutputStream that computes a checksum of data being written using a supplied Checksum object.
CRC32 Computes CRC32 data checksum of a data stream.
Deflater This is the Deflater class.
DeflaterOutputStream This is a special OutputStream deflating the bytes that are written through it.
GZIPInputStream This filter stream is used to decompress a "GZIP" format stream.
GZIPOutputStream This filter stream is used to compress a stream into a "GZIP" stream.
Inflater Inflater is used to decompress data that has been compressed according to the "deflate" standard described in rfc1950.
InflaterInputStream This filter stream is used to decompress data compressed in the "deflate" format.
ZipArchive This class represents a Zip archive.
ZipEntry This class represents a member of a zip archive.
ZipInputStream This is a FilterInputStream that reads the files in an zip archive one after another.
ZipOutputStream This is a FilterOutputStream that writes the files into a zip archive one after another.
2009-11-13
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人