﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>语源科技BlogJava-世界因你而精彩___vv</title><link>http://www.blogjava.net/kingeleven/</link><description>要么忙着生存，要么赶着去死！人总是要做点什么的!</description><language>zh-cn</language><lastBuildDate>Tue, 28 Apr 2026 19:01:15 GMT</lastBuildDate><pubDate>Tue, 28 Apr 2026 19:01:15 GMT</pubDate><ttl>60</ttl><item><title>js 一些常用的正则表达式</title><link>http://www.blogjava.net/kingeleven/articles/242740.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Wed, 26 Nov 2008 02:34:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/articles/242740.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/242740.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/articles/242740.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/242740.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/242740.html</trackback:ping><description><![CDATA[<span class="Apple-style-span" style="border-collapse: separate; color: #000000; font-family: Simsun; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<p style="margin: 10px 0px 15px; padding: 0px;">正则表达式用于字符串处理、表单验证等场合，实用高效。现将一些常用的表达式收集于此，以备不时之需。<br />
</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配中文字符的正则表达式： [\u4e00-\u9fa5]<br />
评注：匹配中文还真是个头疼的事，有了这个表达式就好办了</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配双字节字符(包括汉字在内)：[^\x00-\xff]<br />
评注：可以用来计算字符串的长度（一个双字节字符长度计2，ASCII字符计1）</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配空白行的正则表达式：\n\s*\r<br />
评注：可以用来删除空白行</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配HTML标记的正则表达式：&lt;(\S*?)[^&gt;]*&gt;.*?&lt;/\1&gt;|&lt;.*? /&gt;<br />
评注：网上流传的版本太糟糕，上面这个也仅仅能匹配部分，对于复杂的嵌套标记依旧无能为力</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配首尾空白字符的正则表达式：^\s*|\s*$<br />
评注：可以用来删除行首行尾的空白字符(包括空格、制表符、换页符等等)，非常有用的表达式</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配Email地址的正则表达式：\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*<br />
评注：表单验证时很实用</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配网址URL的正则表达式：[a-zA-z]+://[^\s]*<br />
评注：网上流传的版本功能很有限，上面这个基本可以满足需求</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配帐号是否合法(字母开头，允许5-16字节，允许字母数字下划线)：^[a-zA-Z][a-zA-Z0-9_]{4,15}$<br />
评注：表单验证时很实用</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配国内电话号码：\d{3}-\d{8}|\d{4}-\d{7}<br />
评注：匹配形式如 0511-4405222 或 021-87888822</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配腾讯QQ号：[1-9][0-9]{4,}<br />
评注：腾讯QQ号从10000开始</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配中国邮政编码：[1-9]\d{5}(?!\d)<br />
评注：中国邮政编码为6位数字</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配身份证：\d{15}|\d{18}<br />
评注：中国的身份证为15位或18位</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配ip地址：\d+\.\d+\.\d+\.\d+<br />
评注：提取ip地址时有用</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配特定数字：<br />
^[1-9]\d*$　 　 //匹配正整数<br />
^-[1-9]\d*$ 　 //匹配负整数<br />
^-?[1-9]\d*$　　 //匹配整数<br />
^[1-9]\d*|0$　 //匹配非负整数（正整数 + 0）<br />
^-[1-9]\d*|0$　　 //匹配非正整数（负整数 + 0）<br />
^[1-9]\d*\.\d*|0\.\d*[1-9]\d*$　　 //匹配正浮点数<br />
^-([1-9]\d*\.\d*|0\.\d*[1-9]\d*)$　 //匹配负浮点数<br />
^-?([1-9]\d*\.\d*|0\.\d*[1-9]\d*|0?\.0+|0)$　 //匹配浮点数<br />
^[1-9]\d*\.\d*|0\.\d*[1-9]\d*|0?\.0+|0$　　 //匹配非负浮点数（正浮点数 + 0）<br />
^(-([1-9]\d*\.\d*|0\.\d*[1-9]\d*))|0?\.0+|0$　　//匹配非正浮点数（负浮点数 + 0）<br />
评注：处理大量数据时有用，具体应用时注意修正</p>
<p style="margin: 10px 0px 15px; padding: 0px;">匹配特定字符串：<br />
^[A-Za-z]+$　　//匹配由26个英文字母组成的字符串<br />
^[A-Z]+$　　//匹配由26个英文字母的大写组成的字符串<br />
^[a-z]+$　　//匹配由26个英文字母的小写组成的字符串<br />
^[A-Za-z0-9]+$　　//匹配由数字和26个英文字母组成的字符串<br />
^\w+$　　//匹配由数字、26个英文字母或者下划线组成的字符串<br />
评注：最基本也是最常用的一些表达式</p>
<p style="margin: 10px 0px 15px; padding: 0px;">原载地址：http://lifesinger.3322.org/myblog/?p=185</p>
</span>
<img src ="http://www.blogjava.net/kingeleven/aggbug/242740.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2008-11-26 10:34 <a href="http://www.blogjava.net/kingeleven/articles/242740.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>hbm.xml</title><link>http://www.blogjava.net/kingeleven/articles/220102.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Tue, 05 Aug 2008 02:27:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/articles/220102.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/220102.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/articles/220102.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/220102.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/220102.html</trackback:ping><description><![CDATA[记得以前看到过一篇文章，说<span class="hilite2">HIBERNATE</span>的<span class="hilite3">HBM</span>.<span class="hilite4">XML</span>文件可以不用一个一个写到<span class="hilite1">SPRING</span>的配置文件里，只要指定一个目录就可以，当时我简单试了一下，的确可以，但当时没有记下来，导致现在用到的时候GOOGLE不到（可能找法不对），很是郁闷，只好去看<span class="hilite1">SPRING</span>的源代码，终于被我找到。原来是mappingDirectoryLocations属性。只要如下写就可以:
<br />
&lt;property name="mappingDirectoryLocations"&gt;
<br />
&lt;list&gt;
<br />
&lt;value&gt;<span class="hilite3">HBM</span>.<span class="hilite4">XML</span>文件目录&lt;/value&gt;
<br />
&lt;/list&gt;
<br />
&lt;/property&gt;
<br />
看了<span class="hilite1">SPRING</span>的一些源代码，再次感到<span class="hilite1">SPRING</span>配置的威力！<br />
<img src ="http://www.blogjava.net/kingeleven/aggbug/220102.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2008-08-05 10:27 <a href="http://www.blogjava.net/kingeleven/articles/220102.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>EXT 会向官方网站请求一个 s.gif文件 </title><link>http://www.blogjava.net/kingeleven/articles/210946.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Thu, 26 Jun 2008 12:59:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/articles/210946.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/210946.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/articles/210946.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/210946.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/210946.html</trackback:ping><description><![CDATA[&nbsp;如果想屏蔽掉这个请求的话&nbsp;&nbsp; 就让这个默认的请求改变路径<br />
&nbsp; Ext.BLANK_IMAGE_URL = '../images/default/tree/s.gif';&nbsp; // Ext 2.0<br />
&nbsp; 放在 Ext.onReady(function() 下面 请求 本地的s.gif<br />
&nbsp; 这样就避免不在公网的项目不断的请求官网请求了<br />
<br />
<br />
自动行号 的列上加个标题 new Ext.grid.RowNumberer({header:'aaa',width:30}),<br />
<br />
<img src ="http://www.blogjava.net/kingeleven/aggbug/210946.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2008-06-26 20:59 <a href="http://www.blogjava.net/kingeleven/articles/210946.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>ext grid 的每行最后一列添加 按钮</title><link>http://www.blogjava.net/kingeleven/articles/210396.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Tue, 24 Jun 2008 13:11:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/articles/210396.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/210396.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/articles/210396.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/210396.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/210396.html</trackback:ping><description><![CDATA[var sm = new Ext.grid.CheckboxSelectionModel();<br />
&nbsp;&nbsp;&nbsp; var cm = new Ext.grid.ColumnModel([<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; new Ext.grid.RowNumberer(),<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; sm,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {header:'编号',dataIndex:'id',sortable:true},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {header:'性别',dataIndex:'sex',sortable:true ,renderer:renderSex},<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {header:'名称',dataIndex:'name'},<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {header:'描述',dataIndex:'descn',renderer:renderDescn}<br />
&nbsp;&nbsp;&nbsp; ]);<br />
<br />
&nbsp;&nbsp;&nbsp; var data = [<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ['1','male','name1','descn1'],<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ['2','female','name2','descn2'],<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ['3','male','name3','descn3'],<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ['4','female','name4','descn4'],<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ['5','male','name5','descn5']<br />
&nbsp;&nbsp;&nbsp; ];<br />
<br />
&nbsp;&nbsp;&nbsp; var ds = new Ext.data.Store({&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; proxy: new Ext.data.HttpProxy({url:'http://192.168.0.219/ext-2.1/examples/helloworld/grid.php'}),<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; reader: new Ext.data.JsonReader({<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; totalProperty: 'totalProperty',<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; root: 'root'<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; }, [<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {name: 'id'},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {name: 'sex'},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {name: 'name'},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {name: 'descn'}<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ])<br />
&nbsp;&nbsp;&nbsp; });<br />
<br />
&nbsp;&nbsp;&nbsp; function renderSex(value) {<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; if (value == 'male') {<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; return "&lt;span style='color:red;font-weight:bold;'&gt;男&lt;/span&gt;";<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; } else {<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; return "&lt;span style='color:green;font-weight:bold;'&gt;女&lt;/span&gt;";<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; }<br />
&nbsp;&nbsp;&nbsp; }<br />
<br />
&nbsp;&nbsp;&nbsp; function renderDescn(value, cellmeta, record, rowIndex, columnIndex, store) {<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; var str = "&lt;input type='button' value='详细信息' onclick='alert(\"" +<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; "这个单元格的值是：" + value + "\\n" +<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; "这个单元格的配置是：{cellId:" + cellmeta.cellId + ",id:" + cellmeta.id + ",css:" + cellmeta.css + "}\\n" +<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; "这个单元格对应行的record是：" + record.data["id"] + "，一行的数据都在里边\\n" +<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; "这是第" + rowIndex + "行\\n" +<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; "这是第" + columnIndex + "列\\n" +<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; "这个表格对应的Ext.data.Store在这里：" + store + "，随便用吧。" +<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; "\")'&gt;";<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; return str;<br />
&nbsp;&nbsp;&nbsp; }<br />
&nbsp;&nbsp;&nbsp; <br />
var grid = new Ext.grid.GridPanel({<br />
&nbsp;&nbsp;&nbsp; el: 'grid',<br />
&nbsp;&nbsp;&nbsp; ds: ds,<br />
&nbsp;&nbsp;&nbsp; cm: cm,<br />
&nbsp;&nbsp;&nbsp; sm: sm,<br />
&nbsp;&nbsp;&nbsp; bbar: new Ext.PagingToolbar({<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pageSize: 10,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store: ds,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; displayInfo: true,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; displayMsg: '显示第 {0} 条到 {1} 条记录，一共 {2} 条',<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; emptyMsg: "没有记录"<br />
&nbsp;&nbsp;&nbsp; })<br />
});<br />
ds.load({params:{start:0,limit:10}});<br />
grid.render();&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <br />
<img src ="http://www.blogjava.net/kingeleven/aggbug/210396.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2008-06-24 21:11 <a href="http://www.blogjava.net/kingeleven/articles/210396.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Ext gird分页学习</title><link>http://www.blogjava.net/kingeleven/articles/210395.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Tue, 24 Jun 2008 13:09:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/articles/210395.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/210395.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/articles/210395.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/210395.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/210395.html</trackback:ping><description><![CDATA[&nbsp; var store = new Ext.data.Store({<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; // 使用一个URL获取数据源<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; url:&nbsp; '../ListAlarminfoAfterten.form',<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; //映射关系<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reader: new Ext.data.XmlReader({<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; record: 'tbalarminfo',<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id: 'id',<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; totalRecords:'countRow'<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, [<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {name: 'id', mapping: 'ItemAttributes &gt; id'},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'id','errorid','taskname','alarmtime','descr','matter','rating','status'<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ])<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; });<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; //创建一个表格对象<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; var sm = new Ext.grid.CheckboxSelectionModel();<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; var cm = new Ext.grid.ColumnModel([<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; new Ext.grid.RowNumberer(),//自动行号<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; sm,//添加的地方<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {header: "id", dataIndex: 'id',hidden:true},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {header: "错误ID", width: 100, dataIndex: 'errorid'},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {header: "任务名称", width: 100, dataIndex: 'taskname'},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {header: "时间", width: 100, dataIndex: 'alarmtime'},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {header: "报警描述", width: 150, dataIndex: 'descr'},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {header: "错误内容", width: 150, dataIndex: 'matter',hidden:true},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {header: "级别", width: 100, dataIndex: 'rating'},<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {header: "状态", width: 100, dataIndex: 'status',renderer:function(value){<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (value == '0') {<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return "&lt;span style='color:red;font-weight:bold;'&gt;未通知&lt;/span&gt;";<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } else if (value == '1') {<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return "&lt;span style='color:red;font-weight:bold;'&gt;未处理&lt;/span&gt;";<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }else if (value == '10') {<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return "&lt;span style='color:green;font-weight:bold;'&gt;已处理&lt;/span&gt;";<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }}<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ]);<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; cm.defaultSortable = true;<br />
&nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; // create the grid<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; var grid = new Ext.grid.GridPanel({<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; el:'example-grid',<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store: store,<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cm: cm,<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sm: sm,<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; width: 700,<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; height: 310,<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fitToFrame: true,<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; title:'文件同步历史报警信息列表',<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; selModel: new Ext.grid.RowSelectionModel({singleSelect:false}),<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bbar: new Ext.PagingToolbar({<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pageSize: 20,<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; store: store,<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; displayInfo: true,<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; displayMsg: '显示第 {0} 条到 {1} 条记录，一共 {2} 条',<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; emptyMsg: "没有记录"<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; })<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; });<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; grid.render();<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; store.load({ params : { start : 0, limit : 10 }});&nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; //为grid添加双击事件做弹出窗口处理<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; grid.addListener('rowdblclick',function(){<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; var records = grid.getSelectionModel().getSelections();<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; var stat = records[0].get("status");<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; id=records[0].get('id');<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; errorid=records[0].get('errorid');<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; errordescr=records[0].get('descr');<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; matter=records[0].get('matter');<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; if(stat!="10"){<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; if(!records.length){<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; alert("请选择要处理的报警信息");<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; }<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; else{<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; window.open ('ModifyFileAlarmStatById.jsp?id='+id+","+errorid+","+errordescr+","+matter,'newwindow', 'height=300, width=540, top=200, left=200, toolbar=no, menubar=no, scrollbars=no, resizable=no,location=no, status=no');&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; }<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; }else{<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; window.open ('ViewAlarmDisposenoticeById.jsp?id='+id+","+errorid+","+errordescr+","+matter,'newwindow', 'height=200, width=540, top=200, left=200, toolbar=no, menubar=no, scrollbars=no, resizable=no,location=no, status=no');<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; }<br />
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; });<br />
<br />
<br />
xml 结合 extajax&nbsp; 分页 以及grid 添加监听方法处理操作<br />
后台 java 获得 start的起始条数&nbsp;&nbsp;&nbsp; <br />
数据库写 sql 查询相应的第几条到多少条数的数据<br />
<br />
<img src ="http://www.blogjava.net/kingeleven/aggbug/210395.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2008-06-24 21:09 <a href="http://www.blogjava.net/kingeleven/articles/210395.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>过滤页面中没有用到的图片</title><link>http://www.blogjava.net/kingeleven/articles/180101.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Fri, 15 Feb 2008 08:32:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/articles/180101.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/180101.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/articles/180101.html#Feedback</comments><slash:comments>1</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/180101.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/180101.html</trackback:ping><description><![CDATA[<p>package com.cn.test;</p>
<p>import java.io.BufferedReader;<br />
import java.io.File;<br />
import java.io.FileNotFoundException;<br />
import java.io.FileReader;<br />
import java.io.IOException;<br />
import java.util.ArrayList;<br />
import java.util.Iterator;<br />
import java.util.List;<br />
import java.util.regex.Matcher;<br />
import java.util.regex.Pattern;</p>
<p>public final class CheckPic{</p>
<p>&nbsp;&nbsp; private static String REGEX; </p>
<p>&nbsp;&nbsp; private static String INPUT; </p>
<p>&nbsp;&nbsp; private static Pattern pattern; </p>
<p>&nbsp;&nbsp; private static Matcher matcher; <br />
&nbsp;&nbsp; <br />
&nbsp;&nbsp; private static List PicList = new ArrayList();&nbsp; <br />
&nbsp;&nbsp; <br />
&nbsp;&nbsp; private static List UsedList&nbsp; = new ArrayList();<br />
&nbsp;<br />
&nbsp;&nbsp; public static void main(String[] args) {&nbsp; <br />
&nbsp;&nbsp;&nbsp;REGEX="[a-z0-9A-Z.?_]*.(jpg|jpeg|gif|png)";<br />
&nbsp;&nbsp;&nbsp;pattern = Pattern.compile(REGEX); <br />
&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;initTxt();//初始化存放页面的文件；<br />
&nbsp;&nbsp;&nbsp;System.out.println("页面中出现的pic++++++++++++++++++++++++++++++++++++++++++++++++++");<br />
&nbsp;&nbsp;&nbsp;Iterator&nbsp; it = PicList.iterator();<br />
&nbsp;&nbsp;&nbsp;while(it.hasNext()){<br />
&nbsp;&nbsp;&nbsp;&nbsp;System.out.println(it.next().toString());<br />
&nbsp;&nbsp;&nbsp;}<br />
&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;File&nbsp; filenew&nbsp; =&nbsp; new File("pic");<br />
&nbsp;&nbsp;&nbsp;checkused(filenew);//过滤掉没有用到的图片<br />
&nbsp;&nbsp;&nbsp;System.out.println("过滤后有用的pic**************************************************");<br />
&nbsp;&nbsp;&nbsp;Iterator&nbsp; itr =UsedList.iterator();<br />
&nbsp;&nbsp;&nbsp;while(itr.hasNext())<br />
&nbsp;&nbsp;&nbsp;&nbsp;System.out.println(itr.next().toString());<br />
&nbsp;&nbsp; } <br />
&nbsp;&nbsp; /*　all.txt文件里存放着所有的页面文件　如（.JSP&nbsp; .HTM 等）all.txt可以作为一个参数传进来<br />
&nbsp;&nbsp;&nbsp; 　* 　对all.txt文件进行出始化<br />
&nbsp;&nbsp;&nbsp; * */<br />
&nbsp;&nbsp; private static void initTxt(){<br />
&nbsp;&nbsp;BufferedReader&nbsp; brr=null;<br />
&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp; try { <br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;brr = new BufferedReader(new FileReader("all.txt")); <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (FileNotFoundException fnfe) { <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("Cannot locate input file1! " + fnfe.getMessage()); <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.exit(0); <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INPUT = brr.readLine(); //读入一行（每行存放的是一个页面文件　例如List.jsp ...）<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; while(INPUT!=null){<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; initResources(INPUT);<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INPUT = brr.readLine();<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; brr.close(); <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (IOException ioe) { <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } <br />
&nbsp;&nbsp; }&nbsp; <br />
&nbsp;&nbsp; /*读入每个页面文件的内容<br />
&nbsp;&nbsp;&nbsp; * <br />
&nbsp;&nbsp;&nbsp; */<br />
&nbsp;&nbsp; private static void initResources(String txtname) { <br />
&nbsp;&nbsp;&nbsp; BufferedReader br =&nbsp; null ;<br />
&nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp; try { <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; br = new BufferedReader(new FileReader(txtname)); <br />
&nbsp;&nbsp;&nbsp; } catch (FileNotFoundException fnfe) { <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("Cannot locate input file2! " + fnfe.getMessage()); //判断此文件是否存在<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.exit(0); <br />
&nbsp;&nbsp;&nbsp;&nbsp; } <br />
&nbsp;&nbsp;&nbsp;&nbsp; try { <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INPUT = br.readLine();//读入.jsp文件中的每一行<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; while(INPUT!=null){<br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; processTest(INPUT);//对此行进行分析看有没有用到图片<br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; INPUT =br.readLine();<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; br.close();<br />
&nbsp;&nbsp;&nbsp;&nbsp; } catch (IOException ioe) { <br />
&nbsp;&nbsp;&nbsp;&nbsp; } <br />
&nbsp;&nbsp; } <br />
&nbsp;&nbsp; /*检查页面中用到的图片，并把用到的图片存放在PicList里面（并且消除掉重复使用的图片）<br />
&nbsp;&nbsp; */<br />
&nbsp;&nbsp; private static void processTest(String Input) { <br />
&nbsp;&nbsp;&nbsp;&nbsp; matcher = pattern.matcher(Input); <br />
&nbsp;&nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp;&nbsp; while (matcher.find()) { <br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; System.out.println("I found the text \"" + matcher.group() <br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;+ "\" starting at index " + matcher.start() <br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;+ " and ending at index " + matcher.end() + "."); //图片出现的位置<br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; if(!PicList.contains(matcher.group())){<br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; PicList.add(matcher.group());//判断此图片是否重复使用，如果第一次用该图片就存放在PicList中<br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; }&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; else<br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; {<br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; System.out.println("此图片已经存在");<br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; } <br />
&nbsp;&nbsp;&nbsp;&nbsp; } <br />
&nbsp;&nbsp; } <br />
&nbsp;&nbsp; /*判断图片库所在的文件夹里的图片有那些是页面中用到的，有那些是没有用到的<br />
&nbsp;&nbsp;&nbsp; * 并且把用到的顾虑出来放在UsedList里面<br />
&nbsp;&nbsp;&nbsp; * <br />
&nbsp;&nbsp;&nbsp; */<br />
&nbsp;&nbsp; private static void checkused(File file){<br />
&nbsp;&nbsp;&nbsp; if&nbsp;&nbsp; (file.isFile())&nbsp;&nbsp;&nbsp;&nbsp; //如果是一个文件则返回！&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else{&nbsp;&nbsp;&nbsp; <br />
&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("PIC库里的所有pic如下#######################################");<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for(int i=0;i&lt;file.list().length;i++){&nbsp; <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println(file.list()[i]);<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(PicList.contains(file.list()[i])){<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; UsedList.add(file.list()[i]);<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br />
&nbsp;&nbsp; }<br />
}&nbsp;&nbsp; </p>
<p><br />
&nbsp;</p>
<img src ="http://www.blogjava.net/kingeleven/aggbug/180101.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2008-02-15 16:32 <a href="http://www.blogjava.net/kingeleven/articles/180101.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Java连接各种数据库的实例</title><link>http://www.blogjava.net/kingeleven/articles/172523.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Thu, 03 Jan 2008 09:29:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/articles/172523.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/172523.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/articles/172523.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/172523.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/172523.html</trackback:ping><description><![CDATA[<p><strong>1、Oracle8/8i/9i数据库（thin模式）</strong></p>
<p><strong>
<table cellspacing="0" bordercolordark="#ffffff" cellpadding="2" width="400" align="center" bordercolorlight="black" border="1">
    <tbody>
        <tr>
            <td class="code" bgcolor="#e6e6e6">
            <pre>
            <p>Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();<br />
            <br />
            String url="jdbc:oracle:thin:@localhost:1521:orcl";<br />
            <br />
            //orcl为数据库的SID<br />
            <br />
            String user="test";<br />
            <br />
            String password="test";<br />
            <br />
            Connection conn= DriverManager.getConnection(url,user,password);</p>
            </pre>
            </td>
        </tr>
    </tbody>
</table>
<br />
<br />
</strong><strong>2、<a style="font-size: 14px; color: #0000ff; text-decoration: none" href="http://www.ibm.com/developerworks/cn/db2/zones/db2ii/index_old.html?S_TACT=105AGX52&amp;S_CMP=w-cto" target="_blank">DB2</a>数据库</strong></p>
<p><strong>
<table cellspacing="0" bordercolordark="#ffffff" cellpadding="2" width="400" align="center" bordercolorlight="black" border="1">
    <tbody>
        <tr>
            <td class="code" bgcolor="#e6e6e6">
            <pre>
            <p>Class.forName("com.ibm.db2.jdbc.app.<a style="font-size: 14px; color: #0000ff; text-decoration: none" href="http://www.ibm.com/developerworks/cn/db2/zones/db2ii/index_old.html?S_TACT=105AGX52&amp;S_CMP=w-cto" target="_blank">DB2</a>Driver ").newInstance();<br />
            <br />
            String url="jdbc:db2://localhost:5000/sample";<br />
            <br />
            //sample为你的数据库名<br />
            <br />
            String user="admin";<br />
            <br />
            String password="";<br />
            <br />
            Connection conn= DriverManager.getConnection(url,user,password);</p>
            </pre>
            </td>
        </tr>
    </tbody>
</table>
<br />
<br />
</strong><strong>3、Sql Server7.0/2000数据库</strong></p>
<p><strong>
<table cellspacing="0" bordercolordark="#ffffff" cellpadding="2" width="400" align="center" bordercolorlight="black" border="1">
    <tbody>
        <tr>
            <td class="code" bgcolor="#e6e6e6">
            <pre>
            <p>Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();<br />
            <br />
            String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";<br />
            <br />
            //mydb为数据库<br />
            <br />
            String user="sa";<br />
            <br />
            String password="";<br />
            <br />
            Connection conn= DriverManager.getConnection(url,user,password);</p>
            </pre>
            </td>
        </tr>
    </tbody>
</table>
<br />
<br />
</strong><strong>4、Sybase数据库</strong></p>
<p><strong>
<table cellspacing="0" bordercolordark="#ffffff" cellpadding="2" width="400" align="center" bordercolorlight="black" border="1">
    <tbody>
        <tr>
            <td class="code" bgcolor="#e6e6e6">
            <pre>
            <p>Class.forName("com.sybase.jdbc.SybDriver").newInstance();<br />
            <br />
            String url =" jdbc:sybase:Tds:localhost:5007/myDB";<br />
            <br />
            //myDB为你的数据库名<br />
            <br />
            Properties sysProps = System.getProperties();<br />
            <br />
            SysProps.put("user","userid");<br />
            <br />
            SysProps.put("password","user_password");<br />
            <br />
            Connection conn= DriverManager.getConnection(url, SysProps);</p>
            </pre>
            </td>
        </tr>
    </tbody>
</table>
<br />
<br />
</strong><strong>5、Informix数据库</strong></p>
<p>
<table cellspacing="0" bordercolordark="#ffffff" cellpadding="2" width="400" align="center" bordercolorlight="black" border="1">
    <tbody>
        <tr>
            <td class="code" bgcolor="#e6e6e6">
            <pre>
            <p>Class.forName("com.informix.jdbc.IfxDriver").newInstance();<br />
            <br />
            String url =<br />
            <br />
            "jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;<br />
            <br />
            user=testuser;password=testpassword";<br />
            <br />
            //myDB为数据库名<br />
            <br />
            Connection conn= DriverManager.getConnection(url);</p>
            </pre>
            </td>
        </tr>
    </tbody>
</table>
<br />
<br />
<strong>6、MySQL数据库</strong></p>
<p>
<table cellspacing="0" bordercolordark="#ffffff" cellpadding="2" width="400" align="center" bordercolorlight="black" border="1">
    <tbody>
        <tr>
            <td class="code" bgcolor="#e6e6e6">
            <pre>
            <p>Class.forName("org.gjt.mm.mysql.Driver").newInstance();<br />
            <br />
            String url ="jdbc:mysql://localhost/myDB?</p>
            <p>user=soft&amp;password=soft1234&amp;useUnicode=true&amp;characterEncoding=8859_1"<br />
            <br />
            //myDB为数据库名<br />
            <br />
            Connection conn= DriverManager.getConnection(url);</p>
            </pre>
            </td>
        </tr>
    </tbody>
</table>
<br />
<br />
<strong>7、PostgreSQL数据库</strong></p>
<strong>
<p>
<table cellspacing="0" bordercolordark="#ffffff" cellpadding="2" width="400" align="center" bordercolorlight="black" border="1">
    <tbody>
        <tr>
            <td class="code" bgcolor="#e6e6e6">
            <pre>
            <p>Class.forName("org.postgresql.Driver").newInstance();<br />
            <br />
            String url ="jdbc:postgresql://localhost/myDB"<br />
            <br />
            //myDB为数据库名<br />
            <br />
            String user="myuser";<br />
            <br />
            String password="mypassword";<br />
            <br />
            Connection conn= DriverManager.getConnection(url,user,password);</p>
            </pre>
            </td>
        </tr>
    </tbody>
</table>
</strong></p>
<img src ="http://www.blogjava.net/kingeleven/aggbug/172523.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2008-01-03 17:29 <a href="http://www.blogjava.net/kingeleven/articles/172523.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>PostgreSQL 与 Oracle 相异点   （转）</title><link>http://www.blogjava.net/kingeleven/articles/172487.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Thu, 03 Jan 2008 06:56:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/articles/172487.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/172487.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/articles/172487.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/172487.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/172487.html</trackback:ping><description><![CDATA[<table style="width: 517pt; border-collapse: collapse" cellspacing="0" cellpadding="0" width="688" border="0" x:str="">
    <tbody>
        <tr style="height: 44.25pt; mso-height-source: userset" height="59">
            <td class="xl49" style="border-right: #ece9d8; border-top: #ece9d8; border-left: #ece9d8; width: 517pt; border-bottom: windowtext 1.5pt solid; height: 44.25pt; background-color: transparent" width="688" colspan="4" height="59"><font face="ＭＳ Ｐゴシック" size="3"><strong>ORACLE 与 PostgreSQL 相异点</strong></font></td>
        </tr>
        <tr style="height: 15pt" height="20">
            <td class="xl23" style="border-right: windowtext 1.5pt solid; border-top: windowtext; border-left: windowtext 1.5pt solid; border-bottom: windowtext 1.5pt solid; height: 15pt; background-color: yellow" height="20"><font face="ＭＳ Ｐゴシック" size="2"><strong>NO</strong></font></td>
            <td class="xl24" style="border-right: windowtext 1.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 1.5pt solid; background-color: yellow"><font face="GB BiaoTiSong" size="2"><strong>问题点</strong></font></td>
            <td class="xl25" style="border-right: windowtext 1.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 1.5pt solid; background-color: yellow"><font face="ＭＳ Ｐゴシック" size="2"><strong>Oracle</strong></font></td>
            <td class="xl25" style="border-right: windowtext 1.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 1.5pt solid; background-color: yellow"><font face="ＭＳ Ｐゴシック" size="2"><strong>PostgreSQL</strong></font></td>
        </tr>
        <tr style="height: 57.75pt; mso-height-source: userset" height="77">
            <td class="xl36" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 57.75pt; background-color: silver" align="right" height="77" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">1</font></strong></td>
            <td class="xl28" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">DUAL</font></td>
            <td class="xl28" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">SELECT 1+1 FROM DUAL</font></td>
            <td class="xl29" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT<span style="mso-spacerun: yes">&nbsp; </span>1+1 <br />
            或者<br />
            CREATE VIEW dual AS <br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>SELECT 'X'::VARCHAR(1) AS DUMMY<br />
            再 SELECT 1+1 FROM DUAL</font></td>
        </tr>
        <tr style="height: 24pt; mso-height-source: userset" height="32">
            <td class="xl37" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 24pt; background-color: silver" align="right" height="32" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">2</font></strong></td>
            <td class="xl27" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">NEXTVAL</font></td>
            <td class="xl30" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">SELECT A_TABLE_SEQUENCE.NEXTVAL<br />
            FROM<span style="mso-spacerun: yes">&nbsp;&nbsp; </span>DUAL</font></td>
            <td class="xl30" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT NEXTVAL('A_TABLE_SEQUENCE')<br />
            FROM<span style="mso-spacerun: yes">&nbsp;&nbsp; </span>DUAL</font></td>
        </tr>
        <tr style="height: 34.5pt; mso-height-source: userset" height="46">
            <td class="xl46" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: black 0.5pt solid; height: 103.5pt; background-color: silver" height="138" rowspan="2" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">3</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; background-color: transparent" rowspan="2"><font face="ＭＳ Ｐゴシック">ROWNUM</font></td>
            <td class="xl39" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">①SELECT * <br />
            FROM<span style="mso-spacerun: yes">&nbsp; </span>AGE_TYPE <br />
            WHERE ROWNUM&lt;=5</font></td>
            <td class="xl39" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">①SELECT * <br />
            FROM AGE_TYPE <br />
            LIMIT 5 OFFSET 0</font></td>
        </tr>
        <tr style="height: 69pt; mso-height-source: userset" height="92">
            <td class="xl32" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 230pt; border-bottom: #ece9d8; height: 69pt; background-color: transparent" width="306" height="92"><font face="ＭＳ Ｐゴシック">②SELECT * <br />
            FROM AGE_TYPE<br />
            WHERE CODE IS NOT NULL<br />
            AND ROWNUM&lt;=5 <br />
            ORDER BY CODE DESC</font></td>
            <td class="xl32" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 233pt; border-bottom: #ece9d8; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">②SELECT<span style="mso-spacerun: yes">&nbsp; </span>*<br />
            FROM <br />
            AGE_TYPE<br />
            WHERE CODE IS NOT NULL<br />
            ORDER BY CODE DESC<br />
            LIMIT 5 OFFSET 0</font></td>
        </tr>
        <tr style="height: 57pt; mso-height-source: userset" height="76">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 267pt; background-color: silver" height="356" rowspan="4" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">4</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; background-color: transparent" rowspan="4"><font face="ＭＳ Ｐゴシック">(+)</font></td>
            <td class="xl39" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">①SELECT *<br />
            FROM A_TABLE A , B_TABLE B <br />
            WHERE A.ID(+)=B.ID</font></td>
            <td class="xl39" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">①SELECT * <br />
            FROM A_TABLE A <br />
            RIGHT OUTER JOIN <br />
            B_TABLE B <br />
            ON A.ID=B.ID</font></td>
        </tr>
        <tr style="height: 48pt; mso-height-source: userset" height="64">
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; height: 48pt; background-color: transparent" width="306" height="64"><font face="ＭＳ Ｐゴシック">②SELECT *<br />
            FROM A_TABLE A , B_TABLE B <br />
            WHERE A.ID(+)=B.ID<br />
            AND A.COL1='COL1_VALUE'</font></td>
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">②SELECT * <br />
            FROM A_TABLE A <br />
            RIGHT OUTER JOIN B_TABLE B <br />
            ON A.ID=B.ID AND A.COL1='COL1_VALUE'</font></td>
        </tr>
        <tr style="height: 80.25pt; mso-height-source: userset" height="107">
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; height: 80.25pt; background-color: transparent" width="306" height="107"><font face="ＭＳ Ｐゴシック">③SELECT *<br />
            FROM A_TABLE A, B_TABLE B,C_TABLE C,D_TABLE D<br />
            WHERE <br />
            A.ID=B.ID(+) AND <br />
            A.ID=C.ID(+) AND<br />
            A.COL1=D.COL1</font></td>
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">③SELECT * <br />
            FROM (A_TABLE A<br />
            LEFT OUTER JOIN B_TABLE B<br />
            ON A.ID=B.ID) <br />
            LEFT OUTER JOIN C_TABLE C<br />
            ON A.ID=C.ID,D_TABLE D<br />
            WHERE A.COL1=D.COL1</font></td>
        </tr>
        <tr style="height: 81.75pt; mso-height-source: userset" height="109">
            <td class="xl41" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; height: 81.75pt; background-color: transparent" width="306" height="109"><font face="ＭＳ Ｐゴシック">④!!!<br />
            SELECT * <br />
            FROM A_TABLE A<br />
            WHERE A.COL1(+)=0 AND<br />
            <span style="mso-spacerun: yes">&nbsp;</span>A.COL2(+) ='A_VALUE2'</font></td>
            <td class="xl41" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">④!!!<br />
            SELECT * <br />
            FROM A_TABLE A<br />
            WHERE A.COL1=0 AND<br />
            <span style="mso-spacerun: yes">&nbsp;</span>A.COL2='A_VALUE2'<br />
            </font><font class="font8" face="ＭＳ Ｐゴシック" color="#ff0000"><s><em>WHERE (A.COL1=0 OR A.COL1 IS NULL) AND<br />
            <span style="mso-spacerun: yes">&nbsp;</span>(A.COL2='A_VALUE2' OR A.COL2 IS NULL)</em></s></font></td>
        </tr>
        <tr style="height: 36pt; mso-height-source: userset" height="48">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 36pt; background-color: silver" height="48" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">5</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">AS</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">SELECT A.COL1<span style="mso-spacerun: yes">&nbsp; </span>A_COL1,<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>A.COL2<span style="mso-spacerun: yes">&nbsp; </span>A_COL2<br />
            FROM A_TABLE A</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT A.COL1 AS A_COL1,<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>A.COL2 AS A_COL2<br />
            FROM A_TABLE A</font></td>
        </tr>
        <tr style="height: 48pt; mso-height-source: userset" height="64">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 48pt; background-color: silver" height="64" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">6</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">NVL</font></td>
            <td class="xl32" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 230pt; border-bottom: #ece9d8; background-color: transparent" width="306" x:str="SELECT NVL(SUM(VALUE11),0) FS_VALUE1,            NVL(SUM(VALUE21),0) FS_VALUE2FROM   FIELD_SUM "><font face="ＭＳ Ｐゴシック">SELECT NVL(SUM(VALUE11),0) FS_VALUE1,<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>NVL(SUM(VALUE21),0) FS_VALUE2<br />
            FROM<span style="mso-spacerun: yes">&nbsp;&nbsp; </span>FIELD_SUM<span style="mso-spacerun: yes">&nbsp;</span></font></td>
            <td class="xl32" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 233pt; border-bottom: #ece9d8; background-color: transparent" width="310" x:str="SELECT COALESCE(SUM(VALUE11),0) AS FS_VALUE1,           COALESCE(SUM(VALUE21),0) AS FS_VALUE2FROM   FIELD_SUM "><font face="ＭＳ Ｐゴシック">SELECT COALESCE(SUM(VALUE11),0) AS FS_VALUE1,<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>COALESCE(SUM(VALUE21),0) AS FS_VALUE2<br />
            FROM<span style="mso-spacerun: yes">&nbsp;&nbsp; </span>FIELD_SUM<span style="mso-spacerun: yes">&nbsp;</span></font></td>
        </tr>
        <tr style="height: 51.75pt; mso-height-source: userset" height="69">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 51.75pt; background-color: silver" height="69" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">7</font></strong></td>
            <td class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 40pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="53"><font face="ＭＳ Ｐゴシック">TO_<br />
            NUMBER</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">SELECT COL1 <br />
            FROM A_TABLE<br />
            ORDER BY TO_NUMBER(COL1)</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT COL1 <br />
            FROM A_TABLE<br />
            ORDER BY TO_NUMBER(COL1,999999)<br />
            [注：'999999' ---- 6位数</font><font class="font7" face="GB BiaoTiSong">为</font><font class="font6" face="ＭＳ Ｐゴシック">COL1字段的</font><font class="font7" face="GB BiaoTiSong">长</font><font class="font6" face="ＭＳ Ｐゴシック">度]</font></td>
        </tr>
        <tr style="height: 66pt; mso-height-source: userset" height="88">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 66pt; background-color: silver" height="88" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">8</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">DECODE</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">SELECT DECODE(ENDFLAG,'1','A','B') ENDFLAG<br />
            FROM<span style="mso-spacerun: yes">&nbsp; </span>TEST</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT <br />
            (CASE ENDFLAG <br />
            WHEN '1' THEN 'A'<br />
            ELSE '</font><font class="font9" face="BIG5 Gothic">B</font><font class="font6" face="ＭＳ Ｐゴシック">' END) AS ENDFLAG<br />
            FROM TEST</font></td>
        </tr>
        <tr style="height: 79.5pt; mso-height-source: userset" height="106">
            <td class="xl46" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: black 0.5pt solid; height: 210.75pt; background-color: silver" height="281" rowspan="4" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">9</font></strong></td>
            <td class="xl43" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; width: 40pt; border-bottom: black 0.5pt solid; background-color: transparent" width="53" rowspan="4"><font face="GB BiaoTiSong">时间<br />
            问题</font></td>
            <td class="xl39" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">UPDATE A_TABLE<br />
            SET ENTREDATE=SYSDATE</font></td>
            <td class="xl39" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">UPDATE A_TABLE<br />
            SET ENTREDATE=TO_TIMESTAMP(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS')<br />
            或者<br />
            UPDATE A_TABLE<br />
            SET ENTREDATE=CURRENT_TIMESTAMP</font></td>
        </tr>
        <tr style="height: 57pt; mso-height-source: userset" height="76">
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; height: 57pt; background-color: transparent" width="306" height="76"><font face="ＭＳ Ｐゴシック">SELECT TO_DATE('20010203','YYYY-MM-DD') AS DAY<br />
            FROM DUAL</font></td>
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT TO_DATE('20010203','YYYYMMDD') AS DAY<br />
            FROM DUAL</font><font class="font8"><s><br />
            <em><font face="ＭＳ Ｐゴシック" color="#ff0000">SELECT TO_DATE('20010203','YYYY-MM-DD') AS DAY<br />
            FROM DUAL</font></em></s></font></td>
        </tr>
        <tr style="height: 36pt; mso-height-source: userset" height="48">
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; height: 36pt; background-color: transparent" width="306" height="48"><font face="ＭＳ Ｐゴシック">SELECT TO_DATE(SYSDATE,'YYYY-MM-DD') AS DAY<br />
            FROM DUAL</font></td>
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT TO_DATE(CURRENT_DATE,'YYYY-MM-DD') AS DAY<br />
            FROM DUAL</font></td>
        </tr>
        <tr style="height: 38.25pt; mso-height-source: userset" height="51">
            <td class="xl41" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; height: 38.25pt; background-color: transparent" width="306" height="51"><font face="ＭＳ Ｐゴシック">SELECT TO_DATE(SYSDATE,'YYYY/MM/DD') AS DAY<br />
            FROM DUAL</font></td>
            <td class="xl41" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT TO_DATE(CURRENT_DATE,'YYYY/MM/DD') AS DAY<br />
            FROM DUAL</font></td>
        </tr>
        <tr style="height: 63pt; mso-height-source: userset" height="84">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 63pt; background-color: silver" height="84" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">10</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">||</font></td>
            <td class="xl32" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 230pt; border-bottom: #ece9d8; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">SELECT NULL||'-'||NULL AS VALUES1<br />
            FROM DUAL<br />
            </font></td>
            <td class="xl32" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 233pt; border-bottom: #ece9d8; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT COALESCE(NULL,'')||'-'||COALESCE(NULL,'') AS VALUES1<br />
            FROM DUAL<br />
            </font><font class="font8" face="ＭＳ Ｐゴシック" color="#ff0000"><s><em>SELECT NULL||'-' ||NULL AS VALUES1<br />
            FROM DUAL</em></s></font></td>
        </tr>
        <tr style="height: 89.25pt; mso-height-source: userset" height="119">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 89.25pt; background-color: silver" height="119" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">11</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">aggregate</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">SELECT ROUND(AVG(SUM(BASICCNT1))) BASICCNT<br />
            FROM<span style="mso-spacerun: yes">&nbsp;&nbsp; </span>ACCESS_INFO_SUM1_V<br />
            WHERE YEARCODE BETWEEN '200305' AND '200505'<br />
            GROUP BY SCCODE</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT<span style="mso-spacerun: yes">&nbsp; </span>ROUND(AVG(AIV.BASICCNT)) AS BASICCNT<br />
            FROM<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </span>(SELECT SUM(BASICCNT1)<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>AS BASICCNT<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </span>FROM<span style="mso-spacerun: yes">&nbsp;&nbsp; </span>ACCESS_INFO_SUM1_V<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </span>WHERE YEARCODE BETWEEN '200305' AND '200505'<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </span>GROUP BY sccode<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp; </span>) AIV</font></td>
        </tr>
        <tr style="height: 26.25pt; mso-height-source: userset" height="35">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 219.75pt; background-color: silver" height="293" rowspan="6" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">12</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; background-color: transparent" rowspan="6"><font face="ＭＳ Ｐゴシック">「"」</font></td>
            <td class="xl39" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">①SELECT LENGTH('') AS VALUE1 FROM DUAL<br />
            [Result]VALUE1=NULL</font></td>
            <td class="xl39" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">①SELECT LENGTH('') AS VALUE1 FROM DUAL<br />
            [Result]VALUE1=0</font></td>
        </tr>
        <tr style="height: 37.5pt; mso-height-source: userset" height="50">
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; height: 37.5pt; background-color: transparent" width="306" height="50"><font face="ＭＳ Ｐゴシック">②SELECT TO_DATE('','YYYYMMDD') AS VALUE2 <br />
            FROM DUAL<br />
            [Result]VALUE2=NULL</font></td>
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">②SELECT TO_DATE('','YYYYMMDD') AS VALUE2 <br />
            FROM DUAL<br />
            [Result]VALUE2=0001-01-01 BC</font></td>
        </tr>
        <tr style="height: 27.75pt; mso-height-source: userset" height="37">
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; height: 27.75pt; background-color: transparent" width="306" height="37"><font face="ＭＳ Ｐゴシック">③SELECT TO_NUMBER('',1) AS VALUE3 FROM DUAL<br />
            [Result]VALUE3=NULL</font></td>
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">③SELECT TO_NUMBER('',1) AS VALUE3 FROM DUAL<br />
            [Result]不能</font><font class="font7" face="GB BiaoTiSong">执</font><font class="font6" face="ＭＳ Ｐゴシック">行</font></td>
        </tr>
        <tr style="height: 39pt; mso-height-source: userset" height="52">
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; height: 39pt; background-color: transparent" width="306" height="52"><font face="ＭＳ Ｐゴシック">④INSERT INTO TEST(VALUE4)VALUES('')<br />
            [Result]VALUE4=NULL (注：VALUE3字段</font><font class="font7" face="GB BiaoTiSong">为</font><font class="font6" face="ＭＳ Ｐゴシック">数</font><font class="font9" face="BIG5 Gothic">值</font><font class="font7" face="GB BiaoTiSong">类</font><font class="font6" face="ＭＳ Ｐゴシック">型)</font></td>
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">④INSERT INTO TEST(VALUE4)VALUES('')<br />
            [Result]VALUE4=0<br />
            <span style="mso-spacerun: yes">&nbsp;</span>(注：VALUE4字段</font><font class="font7" face="GB BiaoTiSong">为</font><font class="font6" face="ＭＳ Ｐゴシック">数</font><font class="font9" face="BIG5 Gothic">值</font><font class="font7" face="GB BiaoTiSong">类</font><font class="font6" face="ＭＳ Ｐゴシック">型)</font></td>
        </tr>
        <tr style="height: 39.75pt; mso-height-source: userset" height="53">
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt dotted; height: 39.75pt; background-color: transparent" width="306" height="53"><font face="ＭＳ Ｐゴシック">⑤INSERT INTO TEST(VALUE5)VALUES('')<br />
            [Result]VALUE5=NULL (注：VALUE5字段</font><font class="font7" face="GB BiaoTiSong">为</font><font class="font6" face="ＭＳ Ｐゴシック">字符</font><font class="font7" face="GB BiaoTiSong">类</font><font class="font6" face="ＭＳ Ｐゴシック">型)</font></td>
            <td class="xl40" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt dotted; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">⑤INSERT INTO TEST(VALUE5)VALUES('')<br />
            [Result]VALUE5=''<br />
            <span style="mso-spacerun: yes">&nbsp;</span>(注：VALUE5字段</font><font class="font7" face="GB BiaoTiSong">为</font><font class="font6" face="ＭＳ Ｐゴシック">字符</font><font class="font7" face="GB BiaoTiSong">类</font><font class="font6" face="ＭＳ Ｐゴシック">型,</font><font class="font7" face="GB BiaoTiSong">结果为长度为零的字符串</font><font class="font6" face="ＭＳ Ｐゴシック">)</font></td>
        </tr>
        <tr style="height: 49.5pt; mso-height-source: userset" height="66">
            <td class="xl41" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; height: 49.5pt; background-color: transparent" width="306" height="66"><font face="ＭＳ Ｐゴシック">⑥INSERT INTO TEST(VALUE6)VALUES(TO_DATE('','YYYYMMDD'))<br />
            [Result]VALUE6=NULL (注：VALUE6字段</font><font class="font7" face="GB BiaoTiSong">为时间类</font><font class="font6" face="ＭＳ Ｐゴシック">型)</font></td>
            <td class="xl41" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">⑥INSERT INTO TEST(VALUE6)VALUES(TO_DATE('','YYYYMMDD'))<br />
            [Result]VALUE6=0001-01-01 BC<br />
            <span style="mso-spacerun: yes">&nbsp;</span>(注：VALUE7字段</font><font class="font7" face="GB BiaoTiSong">为时间类</font><font class="font6" face="ＭＳ Ｐゴシック">型)</font></td>
        </tr>
        <tr style="height: 68.25pt; mso-height-source: userset" height="91">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 68.25pt; background-color: silver" height="91" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">13</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">CEIL</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">SELECT CEIL(SYSDATE - TO_DATE('20051027 14:56:10','YYYYMMDD HH24:MI:SS')) AS DAYS<br />
            FROM DUAL</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT <br />
            EXTRACT(DAY FROM (TO_TIMESTAMP(CURRENT_TIMESTAMP,'YYYY-MM-DD-HH24-MI-SS') -TO_TIMESTAMP('2005-10-27 14:56:10','YYYY-MM-DD-HH24-MI-SS') ))+1 AS DAYS<br />
            FROM DUAL</font></td>
        </tr>
        <tr style="height: 36.75pt; mso-height-source: userset" height="49">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 36.75pt; background-color: silver" height="49" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">14</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">NULLIF</font></td>
            <td class="xl27" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">无NULLIF函数</font></td>
            <td class="xl30" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT NULLIF(VALUE1,VALUE2) AS COL1 FROM DUAL<br />
            [注]当VALUE1=VALUE2</font><font class="font7" face="GB BiaoTiSong">时，COL1=NULL</font></td>
        </tr>
        <tr style="height: 55.5pt; mso-height-source: userset" height="74">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 55.5pt; background-color: silver" height="74" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">15</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">CONCAT</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">CONCAT(CHAR,CHAR)</font></td>
            <td class="xl42" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="GB BiaoTiSong">创建函数来解决</font><font class="font6"><br />
            <font face="ＭＳ Ｐゴシック">CREATE FUNCTION CONCAT(CHAR,CHAR)<br />
            RETURNS CHAR AS <br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>'SELECT $1 || $2' LANGUAGE 'sql';</font></font></td>
        </tr>
        <tr style="height: 59.25pt; mso-height-source: userset" height="79">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 59.25pt; background-color: silver" height="79" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">16</font></strong></td>
            <td class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 40pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="53"><font face="ＭＳ Ｐゴシック">ADD_<br />
            MONTHS</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">add_months(date, int)</font></td>
            <td class="xl42" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="GB BiaoTiSong">创</font><font class="font6" face="ＭＳ Ｐゴシック">建函数来解决<br />
            CREATE FUNCTION add_months(date, int) <br />
            RETURNS date AS <br />
            'SELECT ($1 + ( $2::text || ''months'')::interval)::date;' <br />
            LANGUAGE 'sql'</font></td>
        </tr>
        <tr style="height: 70.5pt; mso-height-source: userset" height="94">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 70.5pt; background-color: silver" height="94" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">17</font></strong></td>
            <td class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 40pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="53"><font face="ＭＳ Ｐゴシック">LAST<br />
            _DAY</font></td>
            <td class="xl30" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">LAST_DAY(DATE)</font></td>
            <td class="xl35" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="GB BiaoTiSong">创</font><font class="font6" face="ＭＳ Ｐゴシック">建函数来解决<br />
            CREATE FUNCTION LAST_DAY(DATE)<br />
            RETURNS DATE AS<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>'SELECT date(substr(text($1 + <br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>interval(''1 month'')),1,7)||''-01'')-1'<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>LANGUAGE 'sql';</font></td>
        </tr>
        <tr style="height: 71.25pt; mso-height-source: userset" height="95">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 71.25pt; background-color: silver" height="95" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">18</font></strong></td>
            <td class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 40pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="53"><font face="ＭＳ Ｐゴシック">MONTHS<br />
            _BETWEEN</font></td>
            <td class="xl30" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">MONTH_BETWEEN(DATA,DATA)</font></td>
            <td class="xl35" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="GB BiaoTiSong">创</font><font class="font6" face="ＭＳ Ｐゴシック">建函数来解决<br />
            CREATE FUNCTION MONTH_BETWEEN(DATA,DATA)<br />
            RETURNS NUMERIC AS<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>'SELECT to_number((date($1)-<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>date($2)),''999999999'')/31'<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>LANGUAGE 'sql';</font></td>
        </tr>
        <tr style="height: 234pt; mso-height-source: userset" height="312">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 234pt; background-color: silver" height="312" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">19</font></strong></td>
            <td class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 40pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="53"><font face="ＭＳ Ｐゴシック">GRE~<br />
            ATEST</font></td>
            <td class="xl30" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">GREATEST (LEAST)</font></td>
            <td class="xl35" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="GB BiaoTiSong">创</font><font class="font6" face="ＭＳ Ｐゴシック">建函数来解决<br />
            CREATE OR REPLACE FUNCTION<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp; </span>GREATEST(TEXT[]) RETURNS TEXT AS ' <br />
            DECLARE <br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp; </span>ARRY ALIAS FOR $1;<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp; </span>GREATEST TEXT;<br />
            BEGIN<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp; </span>GREATEST := ARRY[1];<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp; </span>FOR I IN 1 .. ARRAY_UPPER(ARRY,1) LOOP<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>IF ARRY[I] &gt; GREATEST THEN<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>GREATEST := ARRY[I];<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>END IF;<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp; </span>END LOOP;<br />
            <span style="mso-spacerun: yes">&nbsp;&nbsp; </span>RETURN GREATEST;<br />
            END;<br />
            ' LANGUAGE 'PLPGSQL';<br />
            <br />
            SELECT GREATEST( ARRAY['HARRY','HARRIOT','HAROLD'])<br />
            AS "Greatest";</font></td>
        </tr>
        <tr style="height: 16.5pt; mso-height-source: userset" height="22">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 16.5pt; background-color: silver" height="22" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">20</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">BITAND</font></td>
            <td class="xl33" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">BITAND(int,int)</font></td>
            <td class="xl30" style="border-right: windowtext 0.5pt solid; border-top: #ece9d8; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT 値 &amp; 値;</font></td>
        </tr>
        <tr style="height: 30pt; mso-height-source: userset" height="40">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 30pt; background-color: silver" height="40" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">21</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">子条件</font></td>
            <td class="xl34" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 230pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="306"><font face="ＭＳ Ｐゴシック">　</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">在FROM子条件中字段</font><font class="font7" face="GB BiaoTiSong">须有列名，<br />
            处理方法用AS +别名</font></td>
        </tr>
        <tr style="height: 20.25pt; mso-height-source: userset" height="27">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 20.25pt; background-color: silver" height="27" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">22</font></strong></td>
            <td class="xl22" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">MINUS</font></td>
            <td class="xl33" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">MINUS</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">以EXCEPT来替代</font></td>
        </tr>
        <tr style="height: 36pt; mso-height-source: userset" height="48">
            <td class="xl38" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 36pt; background-color: silver" height="48" x:num=""><strong><font face="ＭＳ Ｐゴシック" size="2">23</font></strong></td>
            <td class="xl26" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 40pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="53"><font face="ＭＳ Ｐゴシック">BIN_<br />
            TO_<br />
            NUM</font></td>
            <td class="xl33" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent"><font face="ＭＳ Ｐゴシック">SELECT BIN_TO_NUM(1,0,1,0) AS VALUE1 FROM DUAL</font></td>
            <td class="xl31" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; width: 233pt; border-bottom: windowtext 0.5pt solid; background-color: transparent" width="310"><font face="ＭＳ Ｐゴシック">SELECT CAST(B'1010' AS INTEGER) AS VALUE1</font></td>
        </tr>
    </tbody>
</table>
<img src ="http://www.blogjava.net/kingeleven/aggbug/172487.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2008-01-03 14:56 <a href="http://www.blogjava.net/kingeleven/articles/172487.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>oracle数据类型</title><link>http://www.blogjava.net/kingeleven/articles/170253.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Tue, 25 Dec 2007 03:04:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/articles/170253.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/170253.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/articles/170253.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/170253.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/170253.html</trackback:ping><description><![CDATA[常用的数据库字段类型如下： &nbsp; <br />
&nbsp; &nbsp; <br />
&nbsp; 字段类型 &nbsp; <nobr oncontextmenu="return false;" onmousemove="kwM(0);" id="key0" onmouseover="kwE(event,0, this);" style="color: #6600ff; border-bottom: #6600ff 1px dotted; background-color: transparent; text-decoration: underline" onclick="return kwC();" onmouseout="kwL(event, this);" target="_blank">中文</nobr>说明 &nbsp; 限制条件 &nbsp; 其它说明 &nbsp; &nbsp; <br />
&nbsp; CHAR &nbsp; 固定长度字符串 &nbsp; 最大长度2000 &nbsp; bytes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; VARCHAR2 &nbsp; 可变长度的字符串 &nbsp; 最大长度4000 &nbsp; bytes &nbsp; &nbsp; 可做索引的最大长度749 &nbsp; &nbsp; <br />
&nbsp; NCHAR &nbsp; 根据字符集而定的固定长度字符串 &nbsp; 最大长度2000 &nbsp; bytes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; NVARCHAR2 &nbsp; 根据字符集而定的可变长度字符串 &nbsp; 最大长度4000 &nbsp; bytes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; DATE &nbsp; 日期（日-月-年） &nbsp; DD-MM-YY（HH-MI-SS） &nbsp; 经过严格测试，无千虫问题 &nbsp; &nbsp; <br />
&nbsp; LONG &nbsp; 超长字符串 &nbsp; 最大长度2G（231-1） &nbsp; 足够存储大部头著作 &nbsp; &nbsp; <br />
&nbsp; RAW &nbsp; 固定长度的二进制数据 &nbsp; 最大长度2000 &nbsp; bytes &nbsp; &nbsp; 可存放多<nobr oncontextmenu="return false;" onmousemove="kwM(2);" id="key2" onmouseover="kwE(event,2, this);" style="color: #6600ff; border-bottom: #6600ff 1px dotted; background-color: transparent; text-decoration: underline" onclick="return kwC();" onmouseout="kwL(event, this);" target="_blank">媒体</nobr>图象声音等 &nbsp; &nbsp; <br />
&nbsp; LONG &nbsp; RAW &nbsp; 可变长度的二进制数据 &nbsp; 最大长度2G &nbsp; 同上 &nbsp; &nbsp; <br />
&nbsp; BLOB &nbsp; 二进制数据 &nbsp; 最大长度4G &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; CLOB &nbsp; 字符数据 &nbsp; 最大长度4G &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; NCLOB &nbsp; 根据字符集而定的字符数据 &nbsp; 最大长度4G &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; BFILE &nbsp; 存放在数据库外的二进制数据 &nbsp; 最大长度4G &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; ROWID &nbsp; 数据表中记录的唯一行号 &nbsp; 10 &nbsp; bytes &nbsp; ********.****.****格式，*为0或1 &nbsp; &nbsp; <br />
&nbsp; NROWID &nbsp; 二进制数据表中记录的唯一行号 &nbsp; 最大长度4000 &nbsp; bytes &nbsp; &nbsp; <br />
&nbsp; NUMBER(P,S) &nbsp; <nobr oncontextmenu="return false;" onmousemove="kwM(1);" id="key1" onmouseover="kwE(event,1, this);" style="color: #6600ff; border-bottom: 0px dotted; background-color: transparent; text-decoration: underline" onclick="return kwC();" onmouseout="kwL(event, this);" target="_blank">数字</nobr>类型 &nbsp; P为整数位，S为小数位 &nbsp; &nbsp; <br />
&nbsp; DECIMAL(P,S) &nbsp; 数字类型 &nbsp; P为整数位，S为小数位 &nbsp; &nbsp; <br />
&nbsp; INTEGER &nbsp; 整数类型 &nbsp; 小的整数 &nbsp; &nbsp; <br />
&nbsp; FLOAT &nbsp; 浮点数类型 &nbsp; NUMBER(38)，双精度 &nbsp; &nbsp; <br />
&nbsp; REAL &nbsp; 实数类型 &nbsp; NUMBER(63)，精度更高 &nbsp; &nbsp; <br />
&nbsp; &nbsp; <br />
&nbsp; 这些数据类型的数字代码是多少？ &nbsp; <br />
&nbsp; 如在dbf中 &nbsp; <br />
&nbsp; 8 &nbsp; ----CHAR &nbsp; <br />
&nbsp; 12 &nbsp; -----NUMERIC&nbsp;&nbsp; <br />
<img src ="http://www.blogjava.net/kingeleven/aggbug/170253.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2007-12-25 11:04 <a href="http://www.blogjava.net/kingeleven/articles/170253.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>XML和HTML常用转义字符 </title><link>http://www.blogjava.net/kingeleven/articles/170049.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Mon, 24 Dec 2007 06:30:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/articles/170049.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/170049.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/articles/170049.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/170049.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/170049.html</trackback:ping><description><![CDATA[XML和HTML中都有一些特殊的字符，这些字符在XML和HTML中是不能直接使用的，如果必须使用这些字符，应该使用其对应的转义字符。<br />
<br />
<span style="color: #3366ff">XML常用转义字符：<br />
<table style="border-right: medium none; border-top: medium none; margin: 5px auto auto 0.1pt; border-left: medium none; border-bottom: medium none; border-collapse: collapse" cellspacing="0" cellpadding="0" border="1">
    <tbody>
        <tr style="height: 15.1pt">
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: silver 1pt solid; padding-left: 5.4pt; background: #e6e6e6; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; height: 15.1pt" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center" align="center"><strong><span style="line-height: 150%; font-family: 宋体">字符</span></strong></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: silver 1pt solid; padding-left: 5.4pt; background: #e6e6e6; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; height: 15.1pt" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: center" align="center"><strong><span style="line-height: 150%; font-family: 宋体">转义字符</span></strong></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: silver 1pt solid; padding-left: 5.4pt; background: #e6e6e6; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; height: 15.1pt" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: center" align="center"><strong><span style="line-height: 150%; font-family: 宋体">描述</span></strong></p>
            </td>
        </tr>
        <tr>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: center" align="center"><span style="line-height: 150%">&amp;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%"><span style="line-height: 150%">&amp;amp;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: left" align="left"><span style="line-height: 150%; font-family: 宋体">和</span></p>
            </td>
        </tr>
        <tr style="height: 15.1pt">
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; height: 15.1pt; background-color: transparent" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center" align="center"><span style="line-height: 150%">&lt;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; height: 15.1pt; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%">&amp;lt;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; height: 15.1pt; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: left" align="left"><span style="line-height: 150%; font-family: 宋体">小于号</span></p>
            </td>
        </tr>
        <tr>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: center" align="center"><span style="line-height: 150%">&gt;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%"><span style="line-height: 150%">&amp;gt;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: left" align="left"><span style="line-height: 150%; font-family: 宋体">大于号</span></p>
            </td>
        </tr>
        <tr>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: center" align="center"><span style="line-height: 150%">"</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%"><span style="line-height: 150%">&amp;quot;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: left" align="left"><span style="line-height: 150%; font-family: 宋体">双引号</span></p>
            </td>
        </tr>
        <tr>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: center" align="center"><span style="line-height: 150%">'</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%"><span style="line-height: 150%">&amp;apos;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: left" align="left"><span style="line-height: 150%; font-family: 宋体">单引号</span></p>
            </td>
        </tr>
    </tbody>
</table>
<br />
</span><span style="color: #3366ff">HTML常用转义字符：<br />
<table style="border-right: medium none; border-top: medium none; margin: 5px auto auto 0.1pt; border-left: medium none; border-bottom: medium none; border-collapse: collapse" cellspacing="0" cellpadding="0" border="1">
    <tbody>
        <tr style="height: 15.1pt">
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: silver 1pt solid; padding-left: 5.4pt; background: #e6e6e6; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; height: 15.1pt" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center" align="center"><strong><span style="line-height: 150%; font-family: 宋体">字符</span></strong></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: silver 1pt solid; padding-left: 5.4pt; background: #e6e6e6; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; height: 15.1pt" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: center" align="center"><strong><span style="line-height: 150%; font-family: 宋体">转义字符</span></strong></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: silver 1pt solid; padding-left: 5.4pt; background: #e6e6e6; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; height: 15.1pt" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; word-break: break-all; line-height: 150%; text-align: center" align="center"><strong><span style="line-height: 150%; font-family: 宋体">描述</span></strong></p>
            </td>
        </tr>
        <tr>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center" align="center"><span style="line-height: 150%">&amp;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%">&amp;amp;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%; font-family: 宋体">和</span></p>
            </td>
        </tr>
        <tr>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center" align="center"><span style="line-height: 150%">&lt;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%">&amp;lt;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%; font-family: 宋体">小于号</span></p>
            </td>
        </tr>
        <tr>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center" align="center"><span style="line-height: 150%">&gt;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%">&amp;gt;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%; font-family: 宋体">大于号</span></p>
            </td>
        </tr>
        <tr>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center" align="center"><span style="line-height: 150%">"</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%">&amp;quot;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%; font-family: 宋体">双引号</span></p>
            </td>
        </tr>
        <tr>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="48"></td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%">&amp;nbsp;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%; font-family: 宋体">空格</span></p>
            </td>
        </tr>
        <tr>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center" align="center"><span style="line-height: 150%">&#169;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%">&amp;copy;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%; font-family: 宋体">版权符</span></p>
            </td>
        </tr>
        <tr>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: silver 1pt solid; width: 36pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="48">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%; text-align: center" align="center"><span style="line-height: 150%">&#174;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 135pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="180">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%">&amp;reg;</span></p>
            </td>
            <td style="border-right: silver 1pt solid; padding-right: 5.4pt; border-top: #ece9d8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #ece9d8; width: 225pt; padding-top: 0cm; border-bottom: silver 1pt solid; background-color: transparent" valign="top" width="300">
            <p style="margin: 0cm 0cm 0pt; line-height: 150%"><span style="line-height: 150%; font-family: 宋体">注册符</span></p>
            </td>
        </tr>
    </tbody>
</table>
<br />
说明：转义字符应以&#8220;&amp;&#8221;开头，以&#8220;;&#8221;结尾。</span> <br />
<img src ="http://www.blogjava.net/kingeleven/aggbug/170049.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2007-12-24 14:30 <a href="http://www.blogjava.net/kingeleven/articles/170049.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Oracle中限制返回结果集的行数 </title><link>http://www.blogjava.net/kingeleven/archive/2007/12/13/167555.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Thu, 13 Dec 2007 09:14:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/archive/2007/12/13/167555.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/167555.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/archive/2007/12/13/167555.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/167555.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/167555.html</trackback:ping><description><![CDATA[<h5>　　Oracle不支持类似于 MySQL 中的 limit. 但你还是可以rownum来限制返回的结果集的行数&#8230;&#8230;</h5>
<div></div>
<p>　　Oracle不支持类似于 MySQL 中的 limit. 但你还是可以rownum来限制返回的结果集的行数.</p>
<p>　　如果你只希望返回前十行纪录，你可以这样写：</p>
<p>　　SELECT * FROM table WHERE ROWNUM&lt; 10;</p>
<p>　　但是下面的语句是不对的：</p>
<p>　　SELECT * FROM table WHERE ROWNUM &gt;90 AND ROWNUM&lt; 100;</p>
<p>　　这是因为 Oracle 认为这个条件不成立，所以没有返回。</p>
<p>　　你应该这样写：</p>
<p>
<table style="border-right: #cccccc 1px dotted; table-layout: fixed; border-top: #cccccc 1px dotted; border-left: #cccccc 1px dotted; border-bottom: #cccccc 1px dotted" cellspacing="0" cellpadding="6" align="center" border="0">
    <tbody>
        <tr>
            <td style="word-wrap: break-word" bgcolor="#f3f3f3">　　SELECT&nbsp;*&nbsp;FROM&nbsp;table&nbsp;WHERE&nbsp;ROWNUM&lt;&nbsp;101; <br />
            　　minus <br />
            　　SELECT&nbsp;*&nbsp;FROM&nbsp;table&nbsp;WHERE&nbsp;ROWNUM&lt;&nbsp;91;</td>
        </tr>
    </tbody>
</table>
</p>
<img src ="http://www.blogjava.net/kingeleven/aggbug/167555.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2007-12-13 17:14 <a href="http://www.blogjava.net/kingeleven/archive/2007/12/13/167555.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>人一生中最致命的八个问题</title><link>http://www.blogjava.net/kingeleven/archive/2007/12/01/164481.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Sat, 01 Dec 2007 04:35:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/archive/2007/12/01/164481.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/164481.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/archive/2007/12/01/164481.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/164481.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/164481.html</trackback:ping><description><![CDATA[<p>人一生中最致命的八个问题，在生活每个人都会碰到很多的问题，根据这个问题你能联想到什么？一个简单的问题也许就能讲出一番人生大道理呢，不信你看看，然后看看你犯了哪个没。</p>
<p>问题一：如果你家附近有一家餐厅，东西又贵又难吃，桌上还爬着蟑螂，你会因为它很近很方便，就一而再、再而三地光临吗？ 　　</p>
<p>回答：你一定会说，这是什么烂问题，谁那么笨，花钱买罪受？ 　　 　　</p>
<p>可同样的情况换个场合，自己或许就做类似的蠢事。 　　</p>
<p>不少男女都曾经抱怨过他们的情人或配偶品性不端，三心二意，不负责任。明知在一起没什么好的结果，怨恨已经比爱还多，但却&#8220;不知道为什么&#8221;还是要和他搅和下去，分不了手。 说穿了，只是为了不甘，为了习惯，这不也和光临餐厅一样？</p>
<p>　　-做人，为什么要过于执著？！ 　　</p>
<p>问题二：如果你不小心丢掉100块钱，只知道它好像丢在某个你走过的地方，你会花200块钱的车费去把那100块找回来吗？</p>
<p>回答：一个超级愚蠢的问题。 　　</p>
<p>可是，相似的事情却在人生中不断发生。做错了一件事，明知自己有问题，却怎么也不肯认错，反而花加倍的时间来找藉口，让别人对自己的印象大打折扣。被人骂了一句话，却花了无数时间难过，道理相同。为一件事情发火，不惜损人不利已，不惜血本，不惜时间，只为报复，不也一样无聊？ 　　</p>
<p>失去一个人的感情，明知一切已无法挽回，却还是那么伤心，而且一伤心就是好几年，还要借酒浇愁，形销骨立。其实这样一点用也没有，只是损失更多</p>
<p>　-－做人，干吗为难自己？！ 　　</p>
<p>问题三：你会因为打开报纸发现每天都有车祸，就不敢出门吗？ 　　</p>
<p>回答：这是个什么烂问题？当然不会，那叫因噎废食。 　　</p>
<p>然而，有不少人却曾说：现在的离婚率那么高，让我都不敢谈恋爱了。说得还挺理所当然。也有不少女人看到有关的诸多报道，就对自己的另一半忧心忡忡，这不也是类似的反应？所谓乐观，就是得相信：虽然道路多艰险，我还是那个会平安过马路的人，只要我小心一点，不必害怕过马路。&nbsp; </p>
<p>-做人，先要相信自己。 　　</p>
<p>问题四：你相信每个人随便都可以成功立业吗？</p>
<p>　　回答：当然不会相信。 　　</p>
<p>但据观察，有人总是在听完成功人士绞尽脑汁的建议，比如说，多读书,多 练习之后，问了另一个问题？那不是很难？ 　　</p>
<p>我们都想在3分钟内学好英文，在5分钟内解决所有难题，难道成功是那么容易的吗？改变当然是难的．成功只因不怕困难，所以才能出类拔萃。 　　</p>
<p>有一次坐在出租车上，听见司机看到自己前后都是高档车，兀自感叹：&#8220;唉，为什么别人那么有钱，我的钱这么难赚？&#8221; 　　</p>
<p>我心血来潮，问他：&#8220;你认为世上有什么钱是好赚的？&#8221;他答不出来，过了半晌才说：好像都是别人的钱比较好赚。 　　</p>
<p>其实任何一个成功者都是艰辛取得。我们实在不该抱怨命运。<br />
　　-做人，依靠自己！&nbsp; <br />
问题五：你认为完全没有打过篮球的人，可以当很好的篮球教练吗？</p>
<p>　　回答：当然不可能，外行不可能领导内行。</p>
<p>　　可是，有许多人，对某个行业完全不了解，只听到那个行业好***，就马上开起业来了。</p>
<p>　　我看过对穿着没有任何口味、或根本不在乎穿着的人，梦想却是开间服装店；不知道电脑怎么开机的人，却想在网上聊天，结果道听途说，却不反省自己是否专业能力不足，只抱怨时不我与。</p>
<p>　　-做人，量力而行。</p>
<p>问题六：相似但不相同的问题：你是否认为，篮球教练不上篮球场，闭着眼睛也可以主导一场完美的胜利？<br />
　回答：有病啊，当然是不可能的。</p>
<p>　　可是却有不少朋友，自己没有时间打理，却拼命投资去开咖啡馆，开餐厅，开自己根本不懂的公司，火烧屁股一样急着把辛苦积攒的积蓄花掉，去当一个稀里糊涂的投资人。亏的总是比赚的多，却觉得自己是因为运气不好，而不是想法出了问题。</p>
<p>　　-做人，记得反省自己。</p>
<p>问题七：你宁可永远后悔，也不愿意试一试自己能否转败为胜？</p>
<p>　　解答：恐怕没有人会说：&#8220;对，我就是这样的孬种&#8221;吧。</p>
<p>　　然而，我们却常常在不该打退堂鼓时拼命打退堂鼓，为了恐惧失败而不敢尝试成功。</p>
<p>　　以关颖珊赢得2000年世界花样滑冰冠军时的精彩表现为例：她一心想赢得第一名，然而在最后一场比赛前，她的总积分只排名第三位，在最后的自选曲项目上，她选择了突破，而不是少出错。在4分钟的长曲中，结合了最高难度的三周跳，并且还大胆地连跳了两次。她也可能会败得很难看，但是她毕竟成功了。</p>
<p>　　她说：&#8220;因为我不想等到失败，才后悔自己还有潜力没发挥。&#8221;</p>
<p>　　一个中国伟人曾说；胜利的希望和有利情况的恢复，往往产生于再坚持一下的努力之中。</p>
<p>　　-－做人，何妨放手一搏。</p>
<p>问题八：你的时间无限，长生不老，所以最想做的事，应该无限延期？</p>
<p>　　回答：不，傻瓜才会这样认为。</p>
<p>　　然而我们却常说，等我老了，要去环游世界；等我退休，就要去做想做的事情；等孩子长大了，我就可以&#8230;&#8230;</p>
<p>　　我们都以为自己有无限的时间与精力。其实我们可以一步一步实现理想，不必在等待中徒耗生命。如果现在就能一步一步努力接近，我们就不会活了半生，却出现自己最不想看到的结局。<br />
</p>
<img src ="http://www.blogjava.net/kingeleven/aggbug/164481.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2007-12-01 12:35 <a href="http://www.blogjava.net/kingeleven/archive/2007/12/01/164481.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>改变一生的5句话</title><link>http://www.blogjava.net/kingeleven/archive/2007/12/01/164480.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Sat, 01 Dec 2007 04:35:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/archive/2007/12/01/164480.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/164480.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/archive/2007/12/01/164480.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/164480.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/164480.html</trackback:ping><description><![CDATA[<p>第一句话是：优秀是一种习惯。&nbsp; <br />
&nbsp;&nbsp;&nbsp; 这句话是古希腊哲学家亚里士多德说的。如果说优秀是一种习惯，那么懒惰也是一种习惯。人出生的时候，除了脾气会因为天性而有所不同，其他的东西基本都是后天形成的，是家庭影响和教育的结果。所以，我们的一言一行都是日积月累养成的习惯。我们有的人形成了很好的习惯，有的人形成了很坏的习惯。所以我们从现在起就要把优秀变成一种习惯，使我们的优秀行为习以为常，变成我们的第二天性。让我们习惯性地去创造性思 考，习惯性地去认真做事情，习惯性地对别人友好，习惯性地欣赏大自然。&nbsp; <br />
&nbsp;&nbsp;&nbsp; 注解：要会&#8220;装&#8221;，要持续的、不间断的&#8220;装&#8221;，装久了就成了真的了，就成了习惯了，比如准时到会，每次都按时到会，你装装看，你装30年看看，装的时间长了就形成了习惯。：）&nbsp; </p>
<p>第二句话是：生命是一种过程。&nbsp; <br />
&nbsp;&nbsp;&nbsp; 事情的结果尽管重要，但是做事情的过程更加重要，因为结果好了我们会更加快乐，但过程使我们的生命充实。人的生命最后的结果一定是死亡，我们不能因此说我们的生命没有意义。世界上很少有永恒。大学生谈恋爱，每天都在信誓旦旦地说我会爱你一辈子，这实际上是不真实的。统计数据表明，大学生谈恋爱的100对里有 90对最后会分手，最后结婚了的还有一半会离婚。你说爱情能永恒吗？所以最真实的说法是：&#8220;我今天，此时此刻正在真心地爱着你。&#8221;明天也许你会失恋，失恋后我们会体验到失恋的痛苦。这种体验也是丰富你生命的一个过程。 </p>
<p>&nbsp;&nbsp;&nbsp; 注解：生命本身其实是没有任何意义的，只是你自己赋予你的生命一种你希望实现的意义，因此享受生命的过程就是一种意义所在。&nbsp; </p>
<p>第三句话是：两点之间最短的距离并不一定是直线。&nbsp; <br />
&nbsp;&nbsp;&nbsp; 在人与人的关系以及做事情的过程中，我们很难直截了当就把事情做好。我们有时需要等待，有时需要合作，有时需要技巧。我们做事情会碰到很多困难和障碍，有时候我们并不一定要硬挺、硬冲，我们可以选择有困难绕过去，有障碍绕过去，也许这样做事情更加顺利。大家想一想，我们和别人说话还得想想哪句话更好听呢。尤其在中国这个比较复杂的社会中，大家要学会想办法谅解别人，要让人觉得你这个人很成熟，很不错，你才能把事情做成。 </p>
<p>&nbsp;&nbsp;&nbsp; 注解：如果你在考数学试题，一定要答两点之间直线段最短，如果你在走路，从A到B，明明可以直接过去，但所有人都不走，你最好别走，因为有陷阱。在中国办事情，直线性思维在很多地方要碰壁，这是中国特色的中国处事方式。 </p>
<p>第四句话是：只有知道如何停止的人才知道如何加快速度。&nbsp; <br />
&nbsp;&nbsp;&nbsp; 我在滑雪的时候，最大的体会就是停不下来。我刚开始学滑雪时没有请教练，看着别人滑雪，觉得很容易，不就是从山顶滑到山下吗？于是我穿上滑雪板，哧溜一下就滑下去了，结果我从山顶滑到山下，实际上是滚到山下，摔了很多个跟斗。我发现根本就不知道怎么停止、怎么保持平衡。最后我反复练习怎么在雪地上、斜坡上停下来。练了一个星期，我终于学会了在任何坡上停止、滑行、再停止。这个时候我就发现自己会滑雪了，就敢从山顶高速地往山坡下冲。因为我知道只要我想停，一转身就能停下来。只要你能停下来，你就不会撞上树、撞上石头、撞上人，你就不会被撞死。因此，只有知道如何停止的人，才知道如何高速前进。&nbsp; </p>
<p>&nbsp;&nbsp;&nbsp; 注解：用汽车来比喻，宝马可以上200公里，奇瑞却只能上120公里，为什么？发动机估计不相上下，差距在刹车系统，上了200公里刹不了车，呵呵，我的天！ </p>
<p>第五句话是：放弃是一种智慧，缺陷是一种恩惠。 <br />
&nbsp;&nbsp;&nbsp; 当你拥有六个苹果的时候，千万不要把它们都吃掉，因为你把六个苹果全都吃掉，你也只吃到了六个苹果，只吃到了一种味道，那就是苹果的味道。如果你把六个苹果中的五个拿出来给别人吃，尽管表面上你丢了五个苹果，但实际上你却得到了其他五个人的友情和好感。以后你还能得到更多，当别人有了别的水果的时候，也一定会和你分享，你会从这个人手里得到一个橘子，那个人手里得到一个梨，最后你可能就得到了六种不同的水果，六种不同的味道，六种不同的颜色，六个人的友谊。<br />
&nbsp;&nbsp;&nbsp; 人一定要学会用你拥有的东西去换取对你来说更加重要和丰富的东西。所以说，放弃是一种智慧。 <br />
</p>
<img src ="http://www.blogjava.net/kingeleven/aggbug/164480.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2007-12-01 12:35 <a href="http://www.blogjava.net/kingeleven/archive/2007/12/01/164480.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>编程高手</title><link>http://www.blogjava.net/kingeleven/archive/2007/11/16/160967.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Fri, 16 Nov 2007 03:50:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/archive/2007/11/16/160967.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/160967.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/archive/2007/11/16/160967.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/160967.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/160967.html</trackback:ping><description><![CDATA[<a href="http://tagegg.csdn.net/b.aspx?action=click&amp;unionuser=19&amp;adurl=http%3a%2f%2fbook.csdn.net%2fbookfiles%2f20%2f&amp;adid=1404%7C%7C%7C&amp;tag=.net" target="_blank"><font face="Tahoma"> <strong>Bill Joy</strong>,
前任Sun的首席科学家，当年在Berkeley时主持开发了最早版本的BSD。他还是vi和csh的作者。当然，Csh Programming
Considered Harmful 是另一个话题乐。据说他想看看自己能不能写个操作系统，就在三天里写了个自己的Unix,
也就是BSD的前身。当然是传说了，但足见他的功力。另一个传说是，1980年初的时候，DARPA让BBN在Berkley
Unix里加上BBN开发的TCP/IP代码。但当时还是研究生的B伯伯怒了，拒绝把BBN
TCP/IP加入BSD，因为他觉得BBN的TCP/IP写得不好。于是B伯伯出手了，端的是一箭封喉，很快就写出了高性能的伯克利版TCP/IP。当时
BBN和DARPA签了巨额合同开发TCP/IP
Stack，谁知他们的代码还不如一个研究生的好。于是他们开会。只见当时B伯伯穿个T-shirt出现在会议室(当时穿T-shirt不象现在，还是相
当散漫的哈)。只见BBN问：你怎么写出来的？而B伯伯答：简单，你读协议，然后编程就行了。最令偶晕倒的是，B伯伯硕士毕业后决定到工业界发展，于是就
到了当时只有一间办公室的Sun, 然后他就把Sparc设计出来乐</font>... <font face="Tahoma">象这种软硬通吃的牛人，想不佩服都不行的说。据Bill Joy的同事说，一般开会的时候B伯伯总是拿一堆杂志漫不经心地读。但往往在关键之处，B伯伯发言，直切要害，提出漂亮的构想，让同事们彻底崩溃。对了，他还是Java Spec和JINI的主要作者之一。</font></a><br />
<font face="Tahoma"><strong>John Carmack</strong>，ID Software的founder和Lead Programmer。上个月和一个搞图形的师兄聊天，他竟然不知道John Carmack, 也让偶大大地晕了一把。不过也许搞研究的和搞实战的多少有些隔吧。想必喜欢第一人称射击<a o=""><!---->nclick="tagshow(event, '%D3%CE%CF%B7');return false;" href="javas<!---->cript:;"&gt;<u><strong>游戏</strong></u></a>的
都知道J哥哥。90年代初只要能在PC上搞个小动画都能让人惊叹一番的时候，J哥哥就推出了石破天惊的Castle Wolfstein,
然后再接再励，doom, doomII, Quake...每次都把3-D技术推到极致。J哥哥的简历上说自己的专长是"Exhaust 3-D
technology"，真是牛人之言不我欺的说。做J哥哥这样的人是很幸福的，因为各大图形卡厂家一有了新产品就要向他&#8220;进贡&#8221;，不然如果他的游戏不支
持哪种卡，哪种卡基本就会夭折乐。当初MS的Direct3D也得听取他的意见，修改了不少API。当然，J哥哥在结婚前十数年如一日地每天编程14小时
以上，也是偶们凡人望尘莫及的。对了，J哥哥高中肆业(?!)，可以说是自学成才。不过呢，谁要用这个例子来为自己<a o=""><!---->nclick="tagshow(event, '%D1%A7%CF%B0');return false;" href="javas<!---->cript:;"&gt;<u><strong>学习</strong></u></a>不
好辩护，就大错特错了。那Leonardo Da
Vinci还是自学成才呢(人是私生子，不能上学)。普通人和天才还是有区别的。对了，其实偶们叫&#8220;达分奇&#8221;是相当不对的，因为Vinci是地名，而Da
Vinci就是从Vinci来的人的意思。换句话说，Leonardo Da
Vinci就是&#8220;从Vinci来的Leonardo&#8221;的意思。叫别人&#8220;Da Vinci&#8221;就不知所谓乐。嗯，扯远了，打住。<br />
</font><font face="Tahoma">&nbsp; <strong>David Cutler</strong>，VMS和Windows
NT的首席设计师，去微软前号称硅谷最牛的kernel开发员。当初他和他的手下在微软一周内把一个具备基本功能的bootable
kernel写出来，然后说："who can't write an OS in a
week?"，也是牛气冲天的说。顺便说一句，D爷爷到NT3.5时，管理1500名开发员，自己还兼做设计和编程，不改coder本色啊。D爷爷天生脾
气火爆，和人争论时喜欢双手猛击桌子以壮声势。:-) 日常交谈F-word不离口。他面试秘书时必问："what do you think of
the word 'FUCK'?"，让无数美女刹羽而归。终于有一天，一个同样火爆的女面对这个问题脱口而出："That's my
favorite word"。于是她被录取乐，为D爷爷工作到NT3.5发布。<br />
</font><font face="Tahoma"><strong>Donald E. Knuth</strong>。高爷爷其实用不着偶多说。学编程的不知道他就好像学物理的不知道牛顿，学数学的不知道欧拉，学<a o=""><!---->nclick="tagshow(event, '%D2%F4%C0%D6');return false;" href="javas<!---->cript:;"&gt;<u><strong>音乐</strong></u></a>的
不知道莫扎特，学Delphi的不知到Anders Hejlsberg，或者学Linux不知道Linus
Torvalds一样，不可原谅啊。:-)
为了让文章完整，就再罗唆几句吧。高爷爷本科时就开始给行行色色的公司写各种稀奇古怪的编译器挣外快了。他卖给别人时收一两千美元，那些公司拿了
code，加工一下卖出去就是上万上十万。不过也没见高爷爷不爽过，学者本色的说。想想那可是60年代初啊，高爷爷写编译器写多了，顺带就搞出了个
Attribute Grammar和LR(k)，大大地造福后人啊。至于高爷爷在CalTech的编程比赛(有Alan
Kay得众多高高手参加)总是第一，写的Tex到86年就code
freeze，还附带2^n美分奖励等等都是耳熟能详，偶就不饶舌乐。顺便说一下，高老大爷是无可争议的写作高手。他给Concrete
Mathematics写的前言可谓字字铿锵，堪为前言的典范。他的技术文章也是一绝，文风细致，解释精当，而且没有学究气，不失轻快跳脱。记得几年前读
Concrete
Mathematics，时不时开怀大笑，让老妈极其郁闷，觉得我nerdy到家，不可救药。其实呢，子非鱼，安知鱼之乐，更不知那完全是高爷爷的功劳。
说到写作高手，不能不提Stephen A.
Cook。他的文章当年就被我们的写作老师极力推荐，号称典雅文风的样本。库爷爷一头银发，身材颀长，总是面带谦和的微笑，颇有仙风道骨，正好和他的仙文
相配的说。高爷爷其实还是开源运动的先驱。虽然他没有象Richard
Stallman那样八方奔走，但他捐献了好多作品，都可以在网上看到，比如著名的Mathematical
Writing，MMIXWare，The Tex Book等，更不用说足以让他流芳百世的Tex乐。</font><br />
<img src ="http://www.blogjava.net/kingeleven/aggbug/160967.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2007-11-16 11:50 <a href="http://www.blogjava.net/kingeleven/archive/2007/11/16/160967.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>给哥们过生日</title><link>http://www.blogjava.net/kingeleven/archive/2007/11/15/160873.html</link><dc:creator>vv</dc:creator><author>vv</author><pubDate>Thu, 15 Nov 2007 15:49:00 GMT</pubDate><guid>http://www.blogjava.net/kingeleven/archive/2007/11/15/160873.html</guid><wfw:comment>http://www.blogjava.net/kingeleven/comments/160873.html</wfw:comment><comments>http://www.blogjava.net/kingeleven/archive/2007/11/15/160873.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/kingeleven/comments/commentRss/160873.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/kingeleven/services/trackbacks/160873.html</trackback:ping><description><![CDATA[&nbsp;感觉挺开心的！<br />
&nbsp; 从小的时候就被告知自己是个不太善于言谈的的个孩子！<br />
&nbsp;&nbsp; 语言的表达跟运用总是不够到位，<br />
&nbsp;&nbsp;&nbsp; 心里的事情总是给自己慢慢的留着体味，<br />
&nbsp; 从不放出来给别人看，不论开心得伤心的。<br />
&nbsp;&nbsp; 不知道该怎么去玩沟通的艺术。<br />
&nbsp;&nbsp;&nbsp; 跟陌生的人总是陌生陌生更陌生，<br />
&nbsp;&nbsp;&nbsp;&nbsp; 熟悉的人都忘记是花了多少的时间才能熟悉起来的<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 白天好累，不知道为什么，但是感觉得到是个充实的自己。<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 现在好像什么都没有，又好像什么都有，。感觉自己像个穷人<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 又感觉自己是个富人！！！！！！！<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 感觉。。梦中。也许终究是个梦魇。<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 好不容易来世间走一遭，生活的精彩还想去真正的体会。<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Code&nbsp;&nbsp; Coffee&nbsp; Music&nbsp; Life
<img src ="http://www.blogjava.net/kingeleven/aggbug/160873.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/kingeleven/" target="_blank">vv</a> 2007-11-15 23:49 <a href="http://www.blogjava.net/kingeleven/archive/2007/11/15/160873.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>