??xml version="1.0" encoding="utf-8" standalone="yes"?>久久久国产亚洲精品,99久久99这里只有免费的精品,国产亚洲精品久久久久秋霞http://www.shnenglu.com/abilitytao/枯叶北风寒,忽然q以D,念往昔,语默心酸。二十光阴无一物,韶光贱,寐难安; 不畏形媄单,道途阻且慢Q哪曲折Q如渡飞湍。斩劈波酬壮志Q同把酒Q共aƢ! -如梦?/description>zh-cnWed, 07 May 2025 03:15:11 GMTWed, 07 May 2025 03:15:11 GMT60人生的高度不在于你学会了什么技术,会做什么事Q而取决于价D(value)与远?vision)http://www.shnenglu.com/abilitytao/archive/2016/12/31/214568.htmlabilitytaoabilitytaoSat, 31 Dec 2016 14:01:00 GMThttp://www.shnenglu.com/abilitytao/archive/2016/12/31/214568.htmlhttp://www.shnenglu.com/abilitytao/comments/214568.htmlhttp://www.shnenglu.com/abilitytao/archive/2016/12/31/214568.html#Feedback0http://www.shnenglu.com/abilitytao/comments/commentRss/214568.htmlhttp://www.shnenglu.com/abilitytao/services/trackbacks/214568.html

abilitytao 2016-12-31 22:01 发表评论
]]>
什么是市盈率或U本益比(P/E Ratio)Q?/title><link>http://www.shnenglu.com/abilitytao/archive/2015/01/05/209399.html</link><dc:creator>abilitytao</dc:creator><author>abilitytao</author><pubDate>Mon, 05 Jan 2015 09:20:00 GMT</pubDate><guid>http://www.shnenglu.com/abilitytao/archive/2015/01/05/209399.html</guid><wfw:comment>http://www.shnenglu.com/abilitytao/comments/209399.html</wfw:comment><comments>http://www.shnenglu.com/abilitytao/archive/2015/01/05/209399.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.shnenglu.com/abilitytao/comments/commentRss/209399.html</wfw:commentRss><trackback:ping>http://www.shnenglu.com/abilitytao/services/trackbacks/209399.html</trackback:ping><description><![CDATA[<pre id="best-content-1507341528" accuse="aContent" mb-10"="" style="margin-top: 0px; margin-bottom: 10px; padding: 0px; font-family: arial, 'courier new', courier, 宋体, monospace; white-space: pre-wrap; word-wrap: break-word; color: #333333; line-height: 24px; background-color: #f1fedd;"><div>本益比是选股的重要指标之一Q说h益比q个词,怿很多人都有听q,大部分投资者也自认明白和了解本益比的含义,但当你叫他和你解释时Q他却说了半天你也没听懂?一开始我也以己明白和了解本益比,因ؓ本n读金融系的关p,我知道本益比的计方式,但最q我l于明白Q知道计本益比和了解本益比是两回事Q方E式始终只是方程式,必须探讨其中的含义,了解方程式的的由来,才能一探本益比的真实意义,让本益比成ؓ选股的武器?首先先放癑ֺ癄的本益比含义Q?br />本益比(price/earningQ简UP/EQ?本益比是某种股票普通股每股市hQ股P与每股盈利的比率。也U?#8220;股h收益比率”?#8220;市h盈利比率Q简U市盈率Q?#8221;。英文用PER表示。其计算公式为:本益?股票市h/每股U利Q年Q?<br />本益比是某种股票普通股每股市h与每股盈利的比率。所以它也称h益比率或市h盈利比率?如此Q本益比应该是通常所说的市盈率?<br />马来西亚和新加坡财经报章一般将其称?#8220;本益?#8221;Q而香港和中国一般称?#8220;市盈?#8221;Q其实只是称g同,但内容和含义相同Q英文则UCؓP/E RATIO或者PERQ就是PRICE/EARNING RATIO的羃写?<br />本益比的计算方式Q?<br />Market Value per ShareQ股当今h|<br />Earnings per Share (EPS)Q每股盈利) <br />股票当今h也就是股闭市的h?<br />每股盈利则是公司盈利除于股票数量?<br />例子Q一间上市公司拥?00万股Q?012q度公司盈利?0万?<br />每股盈利q?50?#247;100?= 0.50 Q每股分?.50的盈利) <br />EPS(Earning Per Share) 是0.50 <br />如果该公叔R市hgؓRM2.00 本益比就?.00/0.50 = 4?<br />用白话解释本益比Q一句就搞定了: 本益比其实就是回本年份,如果该股本益比ؓ4倍,代表我们购买该股Q?q才能回本?<br />股h好比你的投资额QEPS是我们的回报?如果该股闭市hRM2.00Q我们购买该股本钱就RM2.00QEPS是我们的回报,如果该股EPS?.50Q代表我们投资RM2.00Q每q能拿回0.50Q要4q才能回本,q?q其实就是我们常说的本益比?br />预测本益比就是根据该公司今年的盈利,预测明年的盈利,再计出来的本益比?本益比其实就是回本年份,如果该公司没有盈利,你永q都不能回本Q那么该公司׃会有本益比?马航是没有本益比的最好例子?很多人可能会_如果本益比代表回本年份,那么是不是越低越好?那么pC快回本?其实不然Q本益比虽然是代表着回本q䆾Q但不一定越低越好,要视公司而定Q很多蓝{股的本益比都很高,也有很多垃圾股本益比都很低?一般上互联|科技股的本益比都很高?马来西亚基本面大师冷D得本益比?0以下的公司,都比较合理,本益比超q?0Q该股有被高估的可能?br />转自癑ֺ知道?/div></pre><img src ="http://www.shnenglu.com/abilitytao/aggbug/209399.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.shnenglu.com/abilitytao/" target="_blank">abilitytao</a> 2015-01-05 17:20 <a href="http://www.shnenglu.com/abilitytao/archive/2015/01/05/209399.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>WebSocket的一些资?/title><link>http://www.shnenglu.com/abilitytao/archive/2014/11/19/208927.html</link><dc:creator>abilitytao</dc:creator><author>abilitytao</author><pubDate>Wed, 19 Nov 2014 14:13:00 GMT</pubDate><guid>http://www.shnenglu.com/abilitytao/archive/2014/11/19/208927.html</guid><wfw:comment>http://www.shnenglu.com/abilitytao/comments/208927.html</wfw:comment><comments>http://www.shnenglu.com/abilitytao/archive/2014/11/19/208927.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.shnenglu.com/abilitytao/comments/commentRss/208927.html</wfw:commentRss><trackback:ping>http://www.shnenglu.com/abilitytao/services/trackbacks/208927.html</trackback:ping><description><![CDATA[<a >http://www.cnblogs.com/imayi/archive/2012/05/05/2485343.html</a><img src ="http://www.shnenglu.com/abilitytao/aggbug/208927.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.shnenglu.com/abilitytao/" target="_blank">abilitytao</a> 2014-11-19 22:13 <a href="http://www.shnenglu.com/abilitytao/archive/2014/11/19/208927.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Unix?压羃和解压羃命ohttp://www.shnenglu.com/abilitytao/archive/2014/11/11/208849.htmlabilitytaoabilitytaoTue, 11 Nov 2014 15:34:00 GMThttp://www.shnenglu.com/abilitytao/archive/2014/11/11/208849.htmlhttp://www.shnenglu.com/abilitytao/comments/208849.htmlhttp://www.shnenglu.com/abilitytao/archive/2014/11/11/208849.html#Feedback0http://www.shnenglu.com/abilitytao/comments/commentRss/208849.htmlhttp://www.shnenglu.com/abilitytao/services/trackbacks/208849.html
.tar 
解包Qtar -xvf FileName.tar 
打包Qtar -cvf FileName.tar DirName 
Q注Qtar是打包,不是压羃Q) 
--------------------------------------------- 
.gz 
解压1Qgunzip FileName.gz 
解压2Qgzip -d FileName.gz 
压羃Qgzip FileName 
.tar.gz 
解压Qtar zxvf FileName.tar.gz 
压羃Qtar zcvf FileName.tar.gz DirName 
--------------------------------------------- 
.bz2 
解压1Qbzip2 -d FileName.bz2 
解压2Qbunzip2 FileName.bz2 
压羃Q?bzip2 -z FileName 
.tar.bz2 
解压Qtar jxvf FileName.tar.bz2 
压羃Qtar jcvf FileName.tar.bz2 DirName 
--------------------------------------------- 
.bz 
解压1Qbzip2 -d FileName.bz 
解压2Qbunzip2 FileName.bz 
压羃Q未?nbsp;
--------------------------------------------- 
.tar.bz 
解压Qtar jxvf FileName.tar.bz 
压羃Q未?nbsp;
--------------------------------------------- 
.Z 
解压Quncompress FileName.Z 
压羃Qcompress FileName 
.tar.Z 
解压Qtar Zxvf FileName.tar.Z 
压羃Qtar Zcvf FileName.tar.Z DirName 
--------------------------------------------- 
.tgz 
解压Qtar zxvf FileName.tgz 
压羃Q未?nbsp;
.tar.tgz 
解压Qtar zxvf FileName.tar.tgz 
压羃Qtar zcvf FileName.tar.tgz FileName 
--------------------------------------------- 
.zip 
解压Qunzip FileName.zip 
压羃Qzip FileName.zip DirName 
--------------------------------------------- 
.rar 
解压Qrar a FileName.rar 
压羃Qrar e FileName.rar 

--------------------------------------------- 
压羃解压~?nbsp;
zip文gQ?nbsp;
功能说明Q压~文件?nbsp;

语  法:zip [-AcdDfFghjJKlLmoqrSTuvVwXyz$][-b <工作目录>][-ll][-n <字尾字符?gt;][-t <日期旉>][-<压羃效率>][压羃文g][文g...][-i <范本样式>][-x <范本样式>] 

补充说明Qzip是个使用q泛的压~程序,文gl它压羃后会另外产生h".zip"扩展名的压羃文g?nbsp;

参  敎ͼ 
-A 调整可执行的自动解压~文件?nbsp;
-b<工作目录> 指定暂时存放文g的目录?nbsp;

-c 替每个被压羃的文件加上注释?nbsp;
-d 从压~文件内删除指定的文件?nbsp;
-D 压羃文g内不建立目录名称?nbsp;
-f 此参数的效果和指?-u"参数cMQ但不仅更新既有文gQ如果某些文件原本不存在于压~文件内Q用本参数会一q将其加入压~文件中?nbsp;
-F 试修复已损坏的压羃文g?nbsp;
-g 文件压~后附加在既有的压羃文g之后Q而非另行建立新的压羃文g?nbsp;
-h 在线帮助?nbsp;
-i<范本样式> 只压~符合条件的文g?nbsp;
-j 只保存文件名U及其内容,而不存放M目录名称?nbsp;
-J 删除压羃文g前面不必要的数据?nbsp;
-k 使用MS-DOS兼容格式的文件名U?nbsp;
-l 压羃文gӞ把LF字符|换成LF+CR字符?nbsp;
-ll 压羃文gӞ把LF+CR字符|换成LF字符?nbsp;
-L 昄版权信息?nbsp;
-m 文件压~ƈ加入压羃文g后,删除原始文gQ即把文件移到压~文件中?nbsp;
-n<字尾字符?gt; 不压~具有特定字֭W串的文件?nbsp;
-o 以压~文件内拥有最新更Ҏ间的文g为准Q将压羃文g的更Ҏ间设成和该文件相同?nbsp;
-q 不显C指令执行过E?nbsp;
-r 递归处理Q将指定目录下的所有文件和子目录一q处理?nbsp;
-S 包含pȝ和隐藏文件?nbsp;
-t<日期旉> 把压~文件的日期设成指定的日期?nbsp;
-T 查备份文件内的每个文件是否正无误?nbsp;
-u 更换较新的文件到压羃文g内?nbsp;
-v 昄指o执行q程或显C版本信息?nbsp;
-V 保存VMS操作pȝ的文件属性?nbsp;
-w 在文件名U里假如版本~号Q本参数仅在VMS操作pȝ下有效?nbsp;
-x<范本样式> 压羃时排除符合条件的文g?nbsp;
-X 不保存额外的文g属性?nbsp;
-y 直接保存W号q接Q而非该连接所指向的文Ӟ本参C在UNIX之类的系l下有效?nbsp;
-z 替压~文件加上注释?nbsp;
-$ 保存W一个被压羃文g所在磁盘的卷册名称?nbsp;
-<压羃效率> 压羃效率是一个介?-9的数倹{?nbsp;

rar文gQ?nbsp;

Rar 用法: rar Q命令> -Q选项1Q?....-Q选项NQ?Q操作文档> Q文?..Q?Q@文g列表...Q?Q解压\径> h/](J k!P x l"w:G v K q7i6v 

  通常rar命o׃个主命o加若q选项Q可选)构成Q操作文档ؓ操作施加?rar文g对象Q文件或文g列表为对操作文实现修饰的具体文件或目录Q可选)?nbsp;

  Y0`-o r#V r n ~"p9f5N rar常用命o主要? 

  1) a d文g到操作文?举例rar a test.rar file1.txt 

  若test.rar文g不存在,则打包file1.txt文g成test.rar rar a test.rar file2.txt 若test.rar文g已经存在Q则dfile2.txt文g到test.rar?q样 test.rar中就有两个文件了Q注Q如果操作文中已有某文件的一份拷贝,则a命o更新该文?另,对目录也可以q行操作 eg. rar a test.rar dir1 ?nbsp;

  2) e test.rar 注,用e解压的话Q不仅原来的file1.txt和file2.txt被解压到当前目录Q就qdir1里面的所有文件也被解压到当前目录下,不能保持压羃前的目录l构Q如果想保持压羃前的目录l构Q用x解压?nbsp;

  3) c Ҏ作文添加说明注?eg. rar c test.rar 

  Q会出现Reading comment from stdin字样Q然后输入一行或多行注释Q以ctrl+dl束Q?nbsp;

  4) cf d文g注释Q类g面的cQ不q这个是对压~文中每个文gq行注释 cw 文注释写入文?eg. rar cw test.rar comment.txt?nbsp;

  5) d 从文中删除文g eg. rar d test.rar file1.txt e 

  文件解压到当前目录 eg. rar?nbsp;

  6) e test.rar 注,用e解压的话Q不仅原来的file1.txt和file2.txt被解压到当前目录Q就qdir1里面的所有文件也被解压到当前目录下,不能保持压羃前的目录l构Q如果想保持压羃前的目录l构Q用x解压?nbsp;

  7) r 修复文档 eg. rar r test.rar 

  当rar文g有问题时Q可以尝试用该命令进行修复(鬼知道有多少用) ?nbsp;

  8) s 转换文成自解压文 eg. rar s test.rar 

  会生成一个test.sfx的可执行文Q运行它的效果就相当于rar x test.rarQ?适合于向没有rar的用户传输文件?nbsp;

  9) t 文?eg. rar t test.rar 

  test.rar的完整性?nbsp;

  10) k 锁定文档 eg. rar k test.rar 

  锁定文后,该文就无法q行M更新操作了?nbsp;

.Z文gQ?nbsp;
命oQ?compress 
格式Q?compress 选项 文g列表 
功能Q?用Lempel-ziv压羃Ҏ来压~文件或压羃标准输入 
选项Q?-r 递归操作Q如果指定目录变元,则压~该目录及其子目录中的所有文件?nbsp;
-c 压~数据返回标准输出,而缺省情况下为压~文件时压~数据返回文件?nbsp;
-v 昄每个文g夹的压羃癑ֈ比?nbsp;
解释Q?在用compress压羃文gӞ在原文件名之后加上扩展?Z。如果不指定文gQ则压羃标准输入Q其l果q回标准输出?nbsp;
实例Q?目的Q压~?mnt/lgx/a1.doc文g 
命oQ#compress /mnt/lgx/a1.doc 
l果Q压~后生成a1.doc.Z文g?nbsp;

命oQ?uncompress 
格式Q?uncompress 选项 文g列表 
功能Q?解压~用compress E序压羃q的文g 
选项Q?-c 它将压羃数据发往标准输出而不是改写旧的压~文?nbsp;
解释Q?如果不指定文Ӟ则解压羃标准输入。缺?cӞ压羃?nbsp;
实例Q?目的Q解压羃/mnt/lgx/a1.doc.Z 
命oQ? uncompress /mnt/lgx/a1.doc.Z 

.gz文gQ?nbsp;

命oQ?gzip 
格式Q?gzip 选项 文g目录列表 
功能Q?用Lempel-ziv~码压羃文g 
选项Q?-c 压羃l果写入标准输出Q原文g保持不变。缺省时gzip原文g压羃?gz文gQƈ删除原文件?nbsp;
-v 输出处理信息?nbsp;
-d 解压~指定文件?nbsp;
-t 试压羃文g的完整性?nbsp;
解释Q?值得一提的是,gzip比compress压羃更加有效?nbsp;
实例Q?目的Q压~?mnt/lgx/a1.doc 
命oQ#gzip -v /mnt/lgx/a1.doc 
l果Q生a1.doc.gz的压~文?nbsp;

命oQ?gunzip 
格式Q?gunzip 选项 文g列表 
功能Q?解压~用gzip命oQ以及compress和zip命oQ压~过的文?nbsp;
选项Q?-c 输出写入标准输出,原文件保持不变。缺省时Qgunzip压~文件变成解压羃文g?nbsp;
-l 列出压羃文g中的文g而不解压~?nbsp;
-r 递归解压~,深入目录l构中,解压~命令行变元所指定目录中的所有子目录内的文g?nbsp;
实例Q?目的Q解压羃/mnt/lgx/a1.doc.gz 
命oQ#gunzip /mnt/lgx/a1.doc.gz 

.tar文gQ?nbsp;

命oQ?tar 
格式Q?tar 选项 文g目录列表 
功能Q?Ҏ件目录进行打包备?nbsp;
选项Q?-c 建立新的归文g 
-r 向归档文件末追加文?nbsp;
-x 从归文件中解出文g 
-O 文件解开到标准输?nbsp;
-v 处理q程中输出相关信?nbsp;
-f Ҏ通文件操?nbsp;
-z 调用gzip来压~归档文Ӟ?x联用时调用gzip完成解压~?nbsp;
-Z 调用compress来压~归文Ӟ?x联用时调用compress完成解压~?nbsp;
实例1Q?目的Q用tar打包一个目录下的文?nbsp;
命oQ#tar -cvf /mnt/lgx/a1.doc 
l果Q生一个以.tar为扩展名的打包文?nbsp;
实例2Q?目的Q用tar解开打包文g 
命oQ#tar -xvf /mnt/lgx/a1.doc.tar 
附加说明Q在通常情况下,tar打包与gzipQ压~)l常联合使用Q效果更好。方法是Q?nbsp;
首先用tar打包Q如Q#tar -cvf /mnt/lgx/a1.doc Q生a1.doc.tar文gQ?nbsp;
然后用gzip压羃a1.doc.tar文gQ如Q#gzip /mnt/lgx/a1.doc.tar Q生a1.doc.tar.gz文gQ?nbsp;
实例3Q?目的Q解压a1.doc.tar.gz文g 
Ҏ1Q?nbsp;
Qgzip -dc /mnt/lgx/a1.doc.tar.gz Q生a1.doc.tar文gQ?nbsp;
Qtar -xvf /mnt/lgx/a1.doc.tar Q生a1.doc文gQ?nbsp;
q两ơ命令也可用管道功能,把两个命令合二ؓ一Q?nbsp;
Qgzip -dc /mnt/lgx/a1.doc.tar.gz | tar -xvf 
Ҏ2Q用tar提供的自动调用gzip解压~功?nbsp;
Qtar -xzvf /mnt/lgx/a1.doc.tar.gz 
l过tar打包后,也可用compress命o压羃Q注Qgzip比compress压羃更加有效Q,产生一个以.tar.Z的文Ӟ在解包时Q可先用 “uncompress 文g?#8221;格式解压Q然后用“tar -xvf 文g?#8221;解包。也可直接调?#8220;tar -Zxvf 文g?#8221;解包?br />
转自:http://bjxuguoli.iteye.com/blog/761964



abilitytao 2014-11-11 23:34 发表评论
]]>
Windows上{unix目录http://www.shnenglu.com/abilitytao/archive/2014/10/24/208668.htmlabilitytaoabilitytaoFri, 24 Oct 2014 09:28:00 GMThttp://www.shnenglu.com/abilitytao/archive/2014/10/24/208668.htmlhttp://www.shnenglu.com/abilitytao/comments/208668.htmlhttp://www.shnenglu.com/abilitytao/archive/2014/10/24/208668.html#Feedback0http://www.shnenglu.com/abilitytao/comments/commentRss/208668.htmlhttp://www.shnenglu.com/abilitytao/services/trackbacks/208668.html\\msad\root\ap\apbo\ku\USERS\weitaol\Desktop

q行命o
V:\AP\APBO\KU\USERS\weitaol\Desktop\TAP\Course\System Architecture\SOAP & REST A
ssessment\mybank>xjc -b .\src\binding.xml -d  .\src\ -p src.java.mybank.soap.generated .\src\src\xml\SOAPRequestResponse.xsd

abilitytao 2014-10-24 17:28 发表评论
]]>
数据库练?/title><link>http://www.shnenglu.com/abilitytao/archive/2014/10/15/208582.html</link><dc:creator>abilitytao</dc:creator><author>abilitytao</author><pubDate>Wed, 15 Oct 2014 15:39:00 GMT</pubDate><guid>http://www.shnenglu.com/abilitytao/archive/2014/10/15/208582.html</guid><wfw:comment>http://www.shnenglu.com/abilitytao/comments/208582.html</wfw:comment><comments>http://www.shnenglu.com/abilitytao/archive/2014/10/15/208582.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.shnenglu.com/abilitytao/comments/commentRss/208582.html</wfw:commentRss><trackback:ping>http://www.shnenglu.com/abilitytao/services/trackbacks/208582.html</trackback:ping><description><![CDATA[计算两日期间隔天?br />values (days(current date) - days('2014-09-01'))<br /><br />d某一字符串的的一个单词,I格为分隔符<br />select substr(title,1,instr(title,' ')-1) from titles<br /><br />字W串的一个空格替换ؓ'--hello--'<br />select substr(title,1,locate(' ',title)-1)  || '--hello--' ||  substr(title,locate(' ',title)+1) from titles<br /><br />db2生成随机?br />select case when price is null then INT(rand()*100) else price end from titles<br /><br />两日期相差多月Q?4代表月。参数可以更Ҏ出周Q小时等{?br />select TIMESTAMPDIFF(64,char(TIMESTAMP(CURRENT DATE) - TIMESTAMP(pubdate)) )from titles<br /><br />有关db2日期操作可参考此博客?br /><a >http://www.cnblogs.com/wanghonghu/archive/2012/05/25/2518604.html</a> <br /><br />建立数据表,有generated always?br />create table t1<br />(<br />c1 char(30),<br />c2 double,<br />c3 int not null generated always as identity<br />      (start with 100, increment by 5)<br />)<br />W一ơ更新用insert into t1(c1,c2,c3) values('123',34,default)<br />以后?insert into t1(c1,c2) values('hi',45)<br /><br />如果是generated by default<br />create table t1<br />(<br />c1 char(30),<br />c2 double,<br />c3 int not null generated by default as identity<br />(start with 100, increment by 5)<br />)<br />如果插入时只有两个参敎ͼ按默认的来<br />如果三个参数Q就是插入的那个?br />默认生成的第三个数可以修改,pȝ会有记录Q即使修改了也会从上一ơ的默认位置开始叠加。不会再回到100.<br /><br /><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from authors</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select au_lname, au_fname from authors where state ='CA'</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from publishers</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select distinct state from publishers</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select *from titles</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from titles where price is null</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">-- select case when price is null then 0 else price end from titles-- it works!!!!!!!!!!</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">-- 4 Functions </p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select varchar_format(current date - date('2011-01-01') + date, 'DD-MM-YY') as newDate,</p> <p align="left">-- varchar_format(date,'DD-MM-YY') as olddate from sales</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--values current date - date('2014-01-01') + date('2014-01-02') </p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select *from roysched</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select hex(lorange) from roysched</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from titles where price in (20,19) -- in one shot ZANZANZANZANZAN!!!</p></font></font><font size="2"> <p align="left"></p></font><font color="#800000" size="2"><font color="#800000" size="2"> <p>select</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">case</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">type</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">when</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">'business'</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">then</font></font><font size="2"> Title </font><font color="#800000" size="2"><font color="#800000" size="2">else</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">'other'</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">end</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">from</font></font><font size="2"> titles 联系条g语句q显C成不同的属?/p></font>-----------------------------------------------------------------------------------------------<br /><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from authors</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select au_lname, au_fname from authors where state ='CA'</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from publishers</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select distinct state from publishers</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select *from titles</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from titles where price is null</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">-- select case when price is null then 0 else price end from titles-- it works!!!!!!!!!!</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">-- 4 Functions </p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select varchar_format(current date - date('2011-01-01') + date, 'DD-MM-YY') as newDate,</p> <p align="left">-- varchar_format(date,'DD-MM-YY') as olddate from sales</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--values current date - date('2014-01-01') + date('2014-01-02') </p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select *from roysched</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select hex(lorange) from roysched</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from titles where price in (20,19) -- in one shot ZANZANZANZANZAN!!!</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select case type when 'business' then Title else 'other' end from titles</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select syscolumns.length from syscolumns where syscolumns.id = 'titles' and syscolumns.name = 'title'</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--5 Grouping </p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select (days(max(pubdate)) - days(min(pubdate)) )/365 from titles</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select title from titles order by length(title)</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select *from titles</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select count(*) from authors group by city</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select title from titles where length(title) = (select max(length(title)) from titles)</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select coalesce(price,0) from titles -- yuan lai bushi yong is null shi yong zhe ge a!!!!</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select length(price) from titles </p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">/*</p> <p align="left">select title from titles where length(title) >= all</p> <p align="left">(</p> <p align="left">select length(title) from titles </p> <p align="left">)</p> <p align="left">*/</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select pubdate from titles</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">/*</p> <p align="left">select title,pubdate from titles where pubdate >= all</p> <p align="left">(</p> <p align="left">select pubdate from titles</p> <p align="left">)</p> <p align="left">*/</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select count(*) from sales group by stor_num</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from sales</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from publishers</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from titles as a inner join publishers as b on a.pub_id = b.pub_id</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select title,city,a.pub_id from titles as a inner join publishers as b on a.pub_id = b.pub_id where city not in ('Boston')</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from psales</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">/*</p> <p align="left">select b.ord_num,b.discount,d.discounttype from psales as a inner join salesdetail as b on a.stor_id = b. stor_id and a.ord_num = b.ord_num</p> <p align="left">inner join stores as c on a.stor_id = c.stor_id inner join discounts as d on c.stor_id = d.stor_id order by b.ord_num</p> <p align="left">*/</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from authors</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from publishers</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from authors as a inner join publishers as b on a.city = b.city</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select sum(qty) from salesdetail</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select pub_name, count(distinct type) from publishers as a inner join titles as b on a.pub_id = b.pub_id group by pub_name</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select *from titleauthor</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--7 Sub-Queries</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">/*</p> <p align="left">select pub_name from publishers where pub_id in </p> <p align="left">(</p> <p align="left">select pub_id from titles</p> <p align="left">) </p> <p align="left">*/</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from publishers</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--nice !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</p> <p align="left">/*</p> <p align="left">select type,title,t1.price</p> <p align="left">from titles as t1</p> <p align="left">where price > (select avg(price) from titles as t2 where t2.type = t1.type)</p> <p align="left">*/</p> <p align="left">-- nice !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</p></font></font><font size="2"> <p align="left"></p> <p align="left"> </p></font><font color="#800000" size="2"><font color="#800000" size="2"> <p align="left">select</font></font><font size="2"> title,t1.price</p></font><font color="#800000" size="2"><font color="#800000" size="2"> <p align="left">from</font></font><font size="2"> titles </font><font color="#800000" size="2"><font color="#800000" size="2">as</font></font><font size="2"> t1</p></font><font color="#800000" size="2"><font color="#800000" size="2"> <p align="left">where</font></font><font size="2"> price > </font><font color="#800000" size="2"><font color="#800000" size="2">all</font></font><font size="2">(</font><font color="#800000" size="2"><font color="#800000" size="2">select</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">coalesce</font></font><font size="2">(price,0) </font><font color="#800000" size="2"><font color="#800000" size="2">from</font></font><font size="2"> titles </font><font color="#800000" size="2"><font color="#800000" size="2">as</font></font><font size="2"> t2 </font><font color="#800000" size="2"><font color="#800000" size="2">where</font></font><font size="2"> t2.</font><font color="#800000" size="2"><font color="#800000" size="2">type</font></font><font size="2"> != t1.</font><font color="#800000" size="2"><font color="#800000" size="2">type</font></font><font size="2">)</p> <p align="left"></p> <p align="left"> </p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from titles</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select t1.type,t1.title,t1.price,(select avg(price) from titles as t2 where t2.type = t1.type)</p> <p align="left">--from titles as t1</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--where price > (select avg(price) from titles as t2 where t2.type = t1.type)</p></font></font><font size="2"> <p align="left"></p> <p align="left"> </p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select avg(price) from titles</p> <p align="left">--select abs(13.93750000000000000000000000- price) from titles</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p>--select coalesce(abs((select avg(price) from titles) - price),0) from titles</p></font></font><br /><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select count(*) as ANS from SB_AUCTION where (days(enddate) - days(startdate) < 10)</p></font></font><font size="2"> <p align="left"></p> <p align="left">/*</p></font><font color="#800000" size="2"><font color="#800000" size="2"> <p align="left">select</font></font><font size="2"> description, enddate, reserve </font><font color="#800000" size="2"><font color="#800000" size="2">from</font></font><font size="2"> SB_Auction </font><font color="#800000" size="2"><font color="#800000" size="2">inner</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">join</font></font><font size="2"> sb_item </font><font color="#800000" size="2"><font color="#800000" size="2">on</font></font><font size="2"> SB_Auction.itemid = sb_item.itemid </p> <p align="left"></font><font color="#800000" size="2"><font color="#800000" size="2">where</font></font><font size="2"> (</font><font color="#800000" size="2"><font color="#800000" size="2">date</font></font><font size="2">(</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">'2011-02-20'</font></font><font size="2">) >= startdate </font><font color="#800000" size="2"><font color="#800000" size="2">and</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">date</font></font><font size="2">(</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">'2011-02-20'</font></font><font size="2">) <= enddate) </font><font color="#800000" size="2"><font color="#800000" size="2">order</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">by</font></font><font size="2"> reserve </font><font color="#800000" size="2"><font color="#800000" size="2">desc</p></font></font><font size="2"> <p align="left">*/</p> <p align="left"></p> <p align="left"> </p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from sb_bid</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select name from (sb_bid as a inner join sb_auction as b on a.bidder = b.userid) inner join sb_user as c on b.userid = c.userid group by name</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from authors</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select newA.name from</p> <p align="left">--(</p> <p align="left">--select name,c.itemid from (sb_user as a inner join sb_auction as b on a.userid = b.userid)</p> <p align="left">-- inner join sb_item as c on b.itemid = c.itemid </p> <p align="left">--) AS newA</p></font></font><font size="2"> <p align="left"></p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from sb_auction</p></font></font><font size="2"> <p align="left">/*</p></font><font color="#800000" size="2"><font color="#800000" size="2"> <p align="left">create</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">view</font></font><font size="2"> weitaol_view</p></font><font color="#800000" size="2"><font color="#800000" size="2"> <p align="left">as</p> <p align="left">select</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">c</font></font><font size="2">.auctionid, </font><font color="#800000" size="2"><font color="#800000" size="2">max</font></font><font size="2">(amount) </font><font color="#800000" size="2"><font color="#800000" size="2">as</font></font><font size="2"> winning_bid </font><font color="#800000" size="2"><font color="#800000" size="2">from</font></font><font size="2"> sb_auction </font><font color="#800000" size="2"><font color="#800000" size="2">as</font></font><font size="2"> a </font><font color="#800000" size="2"><font color="#800000" size="2">inner</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">join</font></font><font size="2"> sb_user </font><font color="#800000" size="2"><font color="#800000" size="2">as</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">b</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">on</font></font><font size="2"> a.winnerid = </font><font color="#800000" size="2"><font color="#800000" size="2">b</font></font><font size="2">.</font><font color="#800000" size="2"><font color="#800000" size="2">userid</font></font><font size="2"> </p> <p align="left"></font><font color="#800000" size="2"><font color="#800000" size="2">inner</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">join</font></font><font size="2"> sb_bid </font><font color="#800000" size="2"><font color="#800000" size="2">as</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">c</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">on</font></font><font size="2"> a.auctionid = </font><font color="#800000" size="2"><font color="#800000" size="2">c</font></font><font size="2">.auctionid </font><font color="#800000" size="2"><font color="#800000" size="2">where</font></font><font size="2"> a.</font><font color="#800000" size="2"><font color="#800000" size="2">state</font></font><font size="2"> = </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">'sold'</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">group</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">by</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">c</font></font><font size="2">.auctionid </p> <p align="left">*/</p></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2"> <p align="left">--select * from weitaol_view</p></font></font><font size="2"> <p align="left"></p> <p align="left"> </p></font><font color="#800000" size="2"><font color="#800000" size="2"> <p align="left">select</font></font><font size="2"> enddate, description,</font><font color="#800000" size="2"><font color="#800000" size="2">coalesce</font></font><font size="2">(</font><font color="#800000" size="2"><font color="#800000" size="2">name</font></font><font size="2">,</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">'=='</font></font><font size="2">) </font><font color="#800000" size="2"><font color="#800000" size="2">as</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">name</font></font><font size="2"> ,</font><font color="#800000" size="2"><font color="#800000" size="2">coalesce</font></font><font size="2">(</font><font color="#800000" size="2"><font color="#800000" size="2">c</font></font><font size="2">.winning_bid,0) </font><font color="#800000" size="2"><font color="#800000" size="2">as</font></font><font size="2"> winning_bid </p> <p align="left"></font><font color="#800000" size="2"><font color="#800000" size="2">from</font></font><font size="2"> sb_auction </font><font color="#800000" size="2"><font color="#800000" size="2">as</font></font><font size="2"> a </font><font color="#800000" size="2"><font color="#800000" size="2">inner</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">join</font></font><font size="2"> sb_item </font><font color="#800000" size="2"><font color="#800000" size="2">as</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">b</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">on</font></font><font size="2"> a.itemid = </font><font color="#800000" size="2"><font color="#800000" size="2">b</font></font><font size="2">.itemid </p> <p align="left"></font><font color="#800000" size="2"><font color="#800000" size="2">left</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">join</font></font><font size="2"> sb_user </font><font color="#800000" size="2"><font color="#800000" size="2">on</font></font><font size="2"> a.winnerid = sb_user.</font><font color="#800000" size="2"><font color="#800000" size="2">userid</font></font><font size="2"> </p> <p align="left"></font><font color="#800000" size="2"><font color="#800000" size="2">left</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">join</font></font><font size="2"> weitaol_view </font><font color="#800000" size="2"><font color="#800000" size="2">as</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">c</font></font><font size="2"> </font><font color="#800000" size="2"><font color="#800000" size="2">on</font></font><font size="2"> a.auctionid = </font><font color="#800000" size="2"><font color="#800000" size="2">c</font></font><font size="2">.auctionid</p> <p align="left"></p> <p align="left"></font><font color="#3f7f5f" size="2"><font color="#3f7f5f" size="2">/*</p> <p align="left">select * from sb_auction</p> <p>*/</p></font></font><br /><br /><br /><img src ="http://www.shnenglu.com/abilitytao/aggbug/208582.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.shnenglu.com/abilitytao/" target="_blank">abilitytao</a> 2014-10-15 23:39 <a href="http://www.shnenglu.com/abilitytao/archive/2014/10/15/208582.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Scala数组操作http://www.shnenglu.com/abilitytao/archive/2014/10/04/208489.htmlabilitytaoabilitytaoSat, 04 Oct 2014 03:52:00 GMThttp://www.shnenglu.com/abilitytao/archive/2014/10/04/208489.htmlhttp://www.shnenglu.com/abilitytao/comments/208489.htmlhttp://www.shnenglu.com/abilitytao/archive/2014/10/04/208489.html#Feedback3http://www.shnenglu.com/abilitytao/comments/commentRss/208489.htmlhttp://www.shnenglu.com/abilitytao/services/trackbacks/208489.html
scala中的数组比java的数l强大很?nbsp;  
    1、定长数l:长度不变的数lArrayQ如Q声明一个长度ؓ10的整形数l,val arr = Array[Int](10)Q声明ƈ初始化一个字W串数组Q?nbsp;val arrStr = Array(“wo”,”cha”,”yo”)。访问数l方?讉KarrStrW一个元素,arrStr(1)卛_
    2、变长数l(xl缓ԌQjava中有ArrayList和scala中的ArrayBuffer{效Q但是ArrayBuffer更加强大Q通过下面的事列来熟悉ArrayBufferQ?br />import collection.mutable.ArrayBuffer
    val arrbuff1 = ArrayBuffer[Int]()
    val arrBuff2 = ArrayBuffer(1,3,4,-1,-4)
    arrbuff1 += 23    //?=在尾端添加元?/span>
    arrbuff1 += (2,3,4,32) //同时在尾端添加多个元?/span>
    arrbuff1 ++= arrBuff2 //可以?nbsp;++=操作W追加Q何集?/span>
    arrbuff1 ++= Array(2,43,88,66)
    arrbuff1.trimEnd(2) //U除最后的2个元?/span>
    arrbuff1.remove(2)  //U除arr(2+1)个元?/span>
    arrbuff1.remove(2,4) //从第三个元素开始移?个元?/span>
    val arr = arrbuff1.toArray //数l缓冲{换ؓArray
    val arrbuff2 = arr.toBuffer //Array转换为数l缓?/span>
    3、遍历数l和数组~冲Q在java中数l和数组列表/向量上语法有些不同。scala则更加统一Q通常情况Q我们可以用相同的代码处理这两种数据l构Q?span style="color: #0000FF; ">for
(…) yield 循环创徏一个类型和原集合类型相同的新集合。for循环中还可以带守卫:在for中用if来实现?br />    for(i <- 0 until arrbuff1.length) yield arrbuff1(i) * 2 //得到ArrayBuffer(2,6,4,-2,-4)
    for(i <- 0 until (arrbuff1.length,2)) yield arrbuff1(i) * 2 //得到ArrayBuffer(12,-4)
    for(elem <-0 arrbuff1) print(elem) //如果不需要用下标,用这U方式最单了
    for(i <- arrbuff1 if arrbuff1 > 0) print i //打印出arrbuff1中ؓ整数的?/span>
    arrbuff1.filter( _ > 0).map{ 2 * _} //生成arrbuff1中的正数的两倍的新集?/span>
    arrbuff1.filter {_ > 0} map {2 * _} //另一U写?/span>
    4、常用算法:scala有很多便捷内建函敎ͼ?br />    arrbuff1.sum //对arrbuff1元素求和
    Array("asd","sdf","ss").max //求最大元?/span>
    arrbuff1.sorted(_ < _)  //arrbuff1元素从小到大排序
    arrbuff1.sorted(_ > _)  //从大到小排序
    util.Sorting.quickSort(Array) //针对数组排序Q单不能Ҏl缓冲排?/span>
    val arr = Array(1,23,4,2,45)
    arr.mkString(",") //指定分割W?/span>
    arr.mkString("(",",",")") //指定前缀、分隔符、后~
更多函数参见Scaladoc
    5、多l数l:
val matrix = Array.ofDim[Int](5,4) //三行四列的二l数l?/span>
matrix(2)(3) //讉KW二行、第三个元素
    6、scala数组和java互操作:׃scala数组是用java数组实现的,所以可以在java和scala之间来回传递,引入scala.collectin.JavaConversion Q可以在代码中用scala~冲Q在调用javaҎӞq些对象会被自动包装成java列表。反q来Ԍ引入scala.collection.asScalaBufferӞ当javaҎq回java.util.ListӞ我们可以让它转换成一个Buffer

转自Q?span style="font-size: 14px;">http://www.kankanews.com/ICkengine/archives/128572.shtml


abilitytao 2014-10-04 11:52 发表评论
]]>
C++ 泛型~程l习 Adaptor Functor & Helper Functionhttp://www.shnenglu.com/abilitytao/archive/2014/09/29/208457.htmlabilitytaoabilitytaoMon, 29 Sep 2014 15:50:00 GMThttp://www.shnenglu.com/abilitytao/archive/2014/09/29/208457.htmlhttp://www.shnenglu.com/abilitytao/comments/208457.htmlhttp://www.shnenglu.com/abilitytao/archive/2014/09/29/208457.html#Feedback0http://www.shnenglu.com/abilitytao/comments/commentRss/208457.htmlhttp://www.shnenglu.com/abilitytao/services/trackbacks/208457.html#include<iostream>
using namespace std;

template <class OutputIterator, class Iterator, class predicate>
    void copy(OutputIterator o, Iterator f, Iterator l, predicate p)
    {
        while(f!=l)
        {
            if(p(*f))
            {
                *o = *f;
                ++f;
                ++o;
            }
            else
            {
                ++f;
            }
        }

    }
template <class Predicate>
class negate
{
    Predicate p;
public :
    typedef typename Predicate::value_type value_type;
    negate(const Predicate &pred):p(pred){}
    bool operator()(const value_type v)const
    {
        return !p(v);
    }
};

template<class Number>
struct smallerThanX
{
    typedef Number value_type;
    int x;
    smallerThanX(int x):x(x)
    {

    }

    bool operator()(const Number& n) const
    {
        return n< this->x;
    }
};

template <class Predicate>
inline negate<Predicate > NOT (const Predicate &p)
{
    return negate<Predicate>(p);
}


int main()
{
    int a[] = {1,2,3,4,5,6,7,8};
    int *b = new int [10]; 
    copy(b,a,a+8,NOT(smallerThanX<int>(5)));
    return 0;
}

q种方式实在是有炚w看啊。。?代码不仔l看q看不懂Q不知道Z么要q样写呢。。?/div>

abilitytao 2014-09-29 23:50 发表评论
]]>
C# Dictionary容器l习http://www.shnenglu.com/abilitytao/archive/2014/09/22/208377.htmlabilitytaoabilitytaoMon, 22 Sep 2014 11:06:00 GMThttp://www.shnenglu.com/abilitytao/archive/2014/09/22/208377.htmlhttp://www.shnenglu.com/abilitytao/comments/208377.htmlhttp://www.shnenglu.com/abilitytao/archive/2014/09/22/208377.html#Feedback0http://www.shnenglu.com/abilitytao/comments/commentRss/208377.htmlhttp://www.shnenglu.com/abilitytao/services/trackbacks/208377.html
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

class MagicDictionary
{

    private Dictionary<String, String> dic;

    public MagicDictionary()
    {
        dic = new Dictionary<stringstring>();

    }

    void Add(String key, String value)
    {
        if (dic.ContainsKey(key)&&dic[key]==value)
            throw new Exception("KeyValuePair already exsits");
        dic.Add(key, value);
    }

    void Remove(String key)
    {
        if (!dic.ContainsKey(key))
            throw new Exception("it doesn't exsit");
        dic.Remove(key);
    }

    void Set(String key, String value)
    {
        if (dic.ContainsKey(key))
            dic[key] = value;
        else
            dic.Add(key, value);
    }

    String Get(String key)
    {
        return dic[key];
    }

    void PrintAll()
    {
        foreach (KeyValuePair<String, String> i in dic)
        {
            Console.WriteLine(i.Key + " " + i.Value);
        }
    }

    String TryGetValue(String key)
    {
        if (dic.ContainsKey(key))
            return dic[key];
        else
            return "";
    }

    public String this[String key]
    {
        set
        {
            dic[key] = value;
        }
        get
        {
            return dic[key];
        }
    }

    public static void Main()
    {

        try
        {
            MagicDictionary t = new MagicDictionary();
            t.Add("Hi", "Hello");
          //  t.Add("Hi", "Hello");
            t.Add("What", "ever");
            t.Add("Pretty", "Girl");
            t.Add("Apple", "Google");
            t.PrintAll();
            t.Remove("Pretty");
            t.Remove("#$@#*$");
            t.Set("What", "Whatever");
            if (t.TryGetValue("Hi") != "")
                Console.WriteLine("OK");
            else
                Console.WriteLine("Bu OK");

            if (t.TryGetValue("Appoe") != "")
                Console.WriteLine("OK");
            else
                Console.WriteLine("Bu OK");
            Console.WriteLine(t.Get("Apple"));
            t["Apple"] = "BIG GOOGLE";

            t.PrintAll();
        }
        catch (System.Exception ex)
        {
            Console.WriteLine(ex.Message);
            Console.WriteLine(ex.Message);
        }

    }

}


abilitytao 2014-09-22 19:06 发表评论
]]>
C# 猜数字小游戏(IDisposable接口l习)http://www.shnenglu.com/abilitytao/archive/2014/09/21/208368.htmlabilitytaoabilitytaoSun, 21 Sep 2014 04:26:00 GMThttp://www.shnenglu.com/abilitytao/archive/2014/09/21/208368.htmlhttp://www.shnenglu.com/abilitytao/comments/208368.htmlhttp://www.shnenglu.com/abilitytao/archive/2014/09/21/208368.html#Feedback0http://www.shnenglu.com/abilitytao/comments/commentRss/208368.htmlhttp://www.shnenglu.com/abilitytao/services/trackbacks/208368.htmlusing System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

class iTimer:IDisposable
{
    String mes;
    DateTime s;
    public iTimer(String mes)
    {
        this.mes = mes;
        s = DateTime.Now;
    }

    public void Dispose()
    {

        DateTime t = DateTime.Now;
        TimeSpan ts = t - s;
        Console.Error.WriteLine("spent time(in Milliseconds):");
        Console.Error.WriteLine(ts.TotalMilliseconds);

    }

    public static void Main()
    {

        using (iTimer t = new iTimer("game"))
        {
            int ans = 10;
            int input = Int32.Parse(Console.ReadLine());

            while(ans!=input)
            {
                Console.WriteLine("please try again.");
                input = Int32.Parse(Console.ReadLine());
            }
            Console.WriteLine("Correct!");
                
        }

        Console.Error.WriteLine("the program is terminated");
        

    }


}

abilitytao 2014-09-21 12:26 发表评论
]]>
þۺ¶þü| Ʒþ| ŮƷþþ| þþþһvr| þþþþþþ66ƷƬ| ŷƷþø| þ˳ƷCAOPOREN| þó˾Ʒ| ˾þۺӰԺ| ŷһþþƷ޾Ʒþþþ | Ʒŷһþþ| Ʒþþþþۺձ| þ޹Ʒһ| þֻƷ99| ܻƺ۵վþmimiɫ| þֻоƷƵ99| þԭƷ| ѾƷպȾþ| ձþþþĻ| þù˾Ʒ鶹| þҹɫ˾Ʒ| þۺϹ׾Ʒ| þ99ڹ| þþƷ18| AVþþƷ| þþƷ99Ӱ | ĻۺϾþ2| þùֱ| ĻѾþ| һձȾþۺ| ٸþĻ| ŷ޹Ʒþ| 99þѹۺϾƷ| þ޹ӰԺվ| ޾Ʒ׽þþþþ| һaƬþëƬ| þùƷվ| Ʒþþþþô| ۺϾþҹAV | ޹Ʒþ66| 99þùƷһ|