??xml version="1.0" encoding="utf-8" standalone="yes"?>亚洲九九爱视频,99久久久久久中文字幕一区,国产经典三级在线http://www.aygfsteel.com/beyondduke/zh-cnSat, 17 May 2025 22:31:39 GMTSat, 17 May 2025 22:31:39 GMT60初学flexhttp://www.aygfsteel.com/beyondduke/archive/2008/03/12/185689.htmlbeyonddukebeyonddukeWed, 12 Mar 2008 06:28:00 GMThttp://www.aygfsteel.com/beyondduke/archive/2008/03/12/185689.htmlhttp://www.aygfsteel.com/beyondduke/comments/185689.htmlhttp://www.aygfsteel.com/beyondduke/archive/2008/03/12/185689.html#Feedback2http://www.aygfsteel.com/beyondduke/comments/commentRss/185689.htmlhttp://www.aygfsteel.com/beyondduke/services/trackbacks/185689.html     上大学的时候,看到好多_ֽ炫丽的flashQ学习了一些flash的知识。那个时候不怎么会写脚本Q就用动ȝ概念一帧一帧的拼出一个flash。后来工作以后,l客户在U演CZ品,有接触了Captivate?006q末的时候,客户要求开发一个在U品展C^収ͼ我偶然搜Cadobe用flex开发的|上购物演示Q就体会到如果用flex来实现这个品展C^台将是很动h的事情,׃某种原因最l未能如ѝ最q在做一个通用视频培训q_时又用到了FLV播放器,也是用Flex开发的Q最l效果和土豆、优酷非常类伹{这些场景我对flash的展现效果情有独钟,况且有adobeq样的公司在q作flashQ如果可能的话应该在合适的场合来把flex集成到我们现在开发的应用中,比如图表功能、表单功能、打印功能等{。基于以上的l历和思\Q决定花功夫学习一下flexq是值得的?br />     首先Q到adobe官方|站下蝲flex builder 3Q当前最新版本)q安装。安装完毕后会看C些入门文章中提到的Flex SDK已经在builder中存在了Q所以初学仅下蝲个builder够了?br />     然后Q打开builder发现它就是基于eclipse开发的Q我惌个IDE对于大多数java开发着再熟悉不q了。首ơ进入时会有一个欢q界面和初学者向|我比较习惯看看这些东西,点击下蝲提供的入门工EFlex3GSEIII_a_WorkingWithData_JSPQƈ导入builder中。看看工E结构跟我们qx的JAVAEE工程有了一些不同。多了bin-debug和html-template文g夹,文gcd主要?.mxml?.as。在工程的左侧视囑֏?.mxmlq行Q类gq行java文gQ,会有一个编译过E,q后弹出一个htmlQhtml中运行的正式flash。当时比较好奇,一个mxml是如何经q编译生html和flash的,打开刚才提到的bin-debug发现两个文g生成Cq个文g夏V仔l读一下mxml的代码发现跟XHTML基本cMQ其中的一些function都是AS写的。至此我分析得到如下l论Qmxml+as-->swf,中间的{换是adobe集成在builder中的转换工具完成的。如此跟我们以往HTML+JS的编E习惯很cM了,q且XHTML与AS的结合更紧密一些。由于初学原理性的知识我就理解x了?br />    最后,我们兛_的是用flex都能实现哪些控gQƈ且控件的效果如何。我没有q不及待的去googleQ而是又深入到builder的安装目录下Q在D:\Flex Builder 3\sdks\3.0.0发现了好东西Q别的我不关心,先看samplesQ子目录下有一个explorerQ其中包含一个build.bat。看到这个bat我更加确定了我以上的l论。于是运行batQ开始编译其下的mxml文g逐一生成swf文g。花一D|间生成完毕,打开cM于index的swf文gQsdk中提供的样例控g都收眼底了?br />    后箋Q有源文Ӟ有开发工P你可以随意摆弄这些代码,熟悉语法Q熟悉开发环境,熟悉对象属性,拼拼凑凑完成自己的一个组合界面了?/p>

beyondduke 2008-03-12 14:28 发表评论
]]>
谈一谈在家办公的利弊http://www.aygfsteel.com/beyondduke/archive/2008/01/31/178621.htmlbeyonddukebeyonddukeThu, 31 Jan 2008 01:48:00 GMThttp://www.aygfsteel.com/beyondduke/archive/2008/01/31/178621.htmlhttp://www.aygfsteel.com/beyondduke/comments/178621.htmlhttp://www.aygfsteel.com/beyondduke/archive/2008/01/31/178621.html#Feedback12http://www.aygfsteel.com/beyondduke/comments/commentRss/178621.htmlhttp://www.aygfsteel.com/beyondduke/services/trackbacks/178621.html

为缓解早晚高峰带来的拥堵Q北京交通委l过调研Q拟从商业机构、大型商场开始试行错C下班Q同时拟在IT行业、科研单位试行弹性工作制。昨天,市h大代表n凤桐透露Q具体方案政府还在拟订中?
市h大代表刘国祥在去q的Z会上提出“合理调整上下班时?#8221;(见新闻附?。市交通委Ҏ予以回复Uͼ本市拟试行错开上下班时间和实行Ҏ工作时间两U方法,~解早晚高峰的交通压力。目前,已经在开展商业、机关企事业单位{错C下班的研IӞq提Z调整商业、机关企事业单位上下班时间的初步ҎQ拟从商业机构开始实施?此外Q交通委q与相关部门q行了协商,对中x{地行调研,拟对某些行业(如IT行业、科研单位等)实行Ҏ工作制Q鼓励在家网上办公。如果这些措施能够实施,则在一定程度上可以削减高峰时段的交通流峰倹{?
据了解,截至2007q底Q北京的机动车保有量已达?10万辆。市交通委表示Q从城市交通运行态势来看Q出行需求和机动车保有量仍在持箋快速增长,高峰时段道\拥堵区域不断扩大、局部\D^均R速下降,~解拥堵的措施大多被持箋快速增长的交通需求所抉|Q交通Ş势依然十分严峅R?


q是前两周的新闻了,当时一看到新闻感觉这条消息很利好Q尤其对我们北京的程序员来说。在家办公的利弊Q现在业内也没有个具体的说法Q这几天有幸在家办公Q体验了一把想跟大家谈一谈我的看法?
一Q利Q?
1Q节U时_花在{R、\上、堵车、倒R或开车、停车等交通出行的旉成本?
2Q节U金钱:上下班的路费或R位费、a费等Q还不算看不到的旉兑换的钱Q时间就是金钱)?
3Qؓ国家做A献:不但l上q新M的交通部门减压力,而且减少了碳的排NQ节能减排)?
4Qؓ公司节约日常费用Q占位费Q水费,费Q办公费Q交通费。。。?
5Q自己时间把握更准确Q由于减了交通环节,个h旉上更有可控性?
二,弊:
1Q缺办公气氛:家中的环境毕竟没有公叔R么统一Q一个家一个样儿,有条件给自己打造办公环境和气氛的员工恐怕只有少数?
2Q增加交成本:公司面对面的交流只能Ҏ手机Ҏ机,或麦克对麦克Q或手指Ҏ指。这些肯定都比面寚wq旉长,q要通讯费上|费?
3Q容易受外界q扰Q如果家中有d老小Q家里很隄你一个封闭环境,你会不断的被“骚扰”Q毕竟工作的事情像写E序需要比较心静的环境?
4Q容易自由散漫:没有了公叔R导的监控和同事的督促Qh的自控能力是有限的,没准看新L论坛玩游戏就q了_耽误的肯定是正事?
5Q造成公共资源费Q公叔R的公p源在家是很难利用好的Q比如内部的服务器,局域网和通讯工具?
以上q些是我所能想到的Q至于利大还是弊大我没有偏向都是5条。个是觉得天时地利h和才适合在家办公Q对于不同的人或同一个h的不同时间段都是利弊难L的?
希望大家能聊一聊自q看法?

beyondduke 2008-01-31 09:48 发表评论
]]>
Excel报表之js?/title><link>http://www.aygfsteel.com/beyondduke/archive/2006/08/05/61911.html</link><dc:creator>beyondduke</dc:creator><author>beyondduke</author><pubDate>Sat, 05 Aug 2006 03:14:00 GMT</pubDate><guid>http://www.aygfsteel.com/beyondduke/archive/2006/08/05/61911.html</guid><wfw:comment>http://www.aygfsteel.com/beyondduke/comments/61911.html</wfw:comment><comments>http://www.aygfsteel.com/beyondduke/archive/2006/08/05/61911.html#Feedback</comments><slash:comments>7</slash:comments><wfw:commentRss>http://www.aygfsteel.com/beyondduke/comments/commentRss/61911.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/beyondduke/services/trackbacks/61911.html</trackback:ping><description><![CDATA[ 半年以前做过server端生成excel的简单引擎,L觉不够轻便,其在一些固定格式,数据量又不是很大的情况下Q上周写了一<br /><br />个根据表单数据在client端用js生成excle的demoQo我我Ȁ动了半天------js太强了!<br /><br />下面分n一下这DjsQ?<br />  <div style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee"><span style="COLOR: #008080"> 1</span><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> excel  </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">new</span><span style="COLOR: #000000"> ActiveXObject(</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">Excel.Application</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">); </span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">创徏AX对象excel</span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080"> 2</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000">excel.visible </span><span style="COLOR: #000000">=</span><span style="COLOR: #0000ff">true</span><span style="COLOR: #000000">; </span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">讄excel可见属?/span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080"> 3</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> workbook </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> excel.Workbooks.Add; </span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">获取workbook对象</span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080"> 4</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> sheet1 </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> xlBook.Worksheets(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">);  </span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">创徏sheet1</span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080"> 5</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> sheet2 </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> xlBook.Worksheets(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">);  </span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">创徏sheet2</span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080"> 6</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000">sheet1.Range(sheet1.Cells(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">),sheet1.Cells(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">14</span><span style="COLOR: #000000">)).mergecells</span><span style="COLOR: #000000">=</span><span style="COLOR: #0000ff">true</span><span style="COLOR: #000000">; </span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">合ƈ单元?/span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080"> 7</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000">sheet1.Range(sheet1.Cells(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">),sheet1.Cells(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">14</span><span style="COLOR: #000000">)).value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">员工月考核成W</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">; </span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">讄单元格内?/span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080"> 8</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000">sheet1.Range(sheet1.Cells(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">),sheet1.Cells(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">14</span><span style="COLOR: #000000">)).Interior.ColorIndex</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">6</span><span style="COLOR: #000000">;</span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">讄底色 </span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080"> 9</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000">sheet1.Range(sheet1.Cells(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">),sheet1.Cells(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">14</span><span style="COLOR: #000000">)).Font.ColorIndex</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">5</span><span style="COLOR: #000000">;</span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">讄字体色?/span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080">10</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000">sheet1.Rows(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">).RowHeight </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">20</span><span style="COLOR: #000000">; </span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">讄列高</span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080">11</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000">sheet1.Rows(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">).Font.Size</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">16</span><span style="COLOR: #000000">;  </span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">讄文字大小</span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080">12</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000">sheet1.Rows(</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">).Font.Name</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">宋体</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">; </span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">讄字体</span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080">13</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />//</span><span style="COLOR: #008000">讄每一列的标题</span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080">14</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000">sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">工程师考核?/span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">15</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">d</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">16</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">3</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">研发q度</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">17</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">4</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">出勤?/span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">18</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">5</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">执行?/span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">19</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">6</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">责Q?/span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">20</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">7</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">工作规范</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">21</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">8</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">协作_</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">22</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">9</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">q取?/span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">23</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">10</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">工作合理?/span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">24</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">11</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">解决问题能力</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">25</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">12</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">应变能力</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">26</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">13</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">人际技?/span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">27</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" />sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">,</span><span style="COLOR: #000000">14</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">理解能力</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;<br /></span><span style="COLOR: #008080">28</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">从表单@环控件中取出数据逐行插入对应列的数据</span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080">29</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> count </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetAttributeValue('Repeat','Count');<br /></span><span style="COLOR: #008080">30</span><span style="COLOR: #000000"><img id="Codehighlighter1_1253_2657_Open_Image" onclick="this.style.display='none'; Codehighlighter1_1253_2657_Open_Text.style.display='none'; Codehighlighter1_1253_2657_Closed_Image.style.display='inline'; Codehighlighter1_1253_2657_Closed_Text.style.display='inline';" src="http://www.aygfsteel.com/images/OutliningIndicators/ExpandedBlockStart.gif" align="top" /><img id="Codehighlighter1_1253_2657_Closed_Image" style="DISPLAY: none" onclick="this.style.display='none'; Codehighlighter1_1253_2657_Closed_Text.style.display='none'; Codehighlighter1_1253_2657_Open_Image.style.display='inline'; Codehighlighter1_1253_2657_Open_Text.style.display='inline';" src="http://www.aygfsteel.com/images/OutliningIndicators/ContractedBlock.gif" align="top" /></span><span style="COLOR: #0000ff">for</span><span style="COLOR: #000000">(</span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> line</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">;line</span><span style="COLOR: #000000"><=</span><span style="COLOR: #000000">count;line</span><span style="COLOR: #000000">++</span><span style="COLOR: #000000">)</span><span id="Codehighlighter1_1253_2657_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff"><img src="http://www.aygfsteel.com/images/dot.gif" /></span><span id="Codehighlighter1_1253_2657_Open_Text"><span style="COLOR: #000000">{ </span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">begin for</span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080">31</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: #000000">  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> name  </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].name');<br /></span><span style="COLOR: #008080">32</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> total</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].total');<br /></span><span style="COLOR: #008080">33</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> yfjd </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].yfjd');<br /></span><span style="COLOR: #008080">34</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> jh </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].jh');<br /></span><span style="COLOR: #008080">35</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> gcgj </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].gcgj');<br /></span><span style="COLOR: #008080">36</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> cql </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].cql');<br /></span><span style="COLOR: #008080">37</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> zxl </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].zxl');<br /></span><span style="COLOR: #008080">38</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> gzgf </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].gzgf');<br /></span><span style="COLOR: #008080">39</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> zrx </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].zrx');<br /></span><span style="COLOR: #008080">40</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> xzjs </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].xzjs');<br /></span><span style="COLOR: #008080">41</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> jqx </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].jqx');<br /></span><span style="COLOR: #008080">42</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> gzhl </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].gzh');<br /></span><span style="COLOR: #008080">43</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> jjwt </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].jjwt');<br /></span><span style="COLOR: #008080">44</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> ybnl </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].ybnl');<br /></span><span style="COLOR: #008080">45</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> rjjn </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].rjjn');<br /></span><span style="COLOR: #008080">46</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  </span><span style="COLOR: #0000ff">var</span><span style="COLOR: #000000"> ljnl </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> sfform.GetValue('Repeat['</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">'].ljnl');<br /></span><span style="COLOR: #008080">47</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">1</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">name;<br /></span><span style="COLOR: #008080">48</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">total;<br /></span><span style="COLOR: #008080">49</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">3</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">yfjd;<br /></span><span style="COLOR: #008080">50</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">4</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">cql;<br /></span><span style="COLOR: #008080">51</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">5</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">zxl;<br /></span><span style="COLOR: #008080">52</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">6</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">gzgf;<br /></span><span style="COLOR: #008080">53</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">7</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">zrx;<br /></span><span style="COLOR: #008080">54</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">8</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">xzjs;<br /></span><span style="COLOR: #008080">55</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">9</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">jqx;<br /></span><span style="COLOR: #008080">56</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">10</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">gzhl;<br /></span><span style="COLOR: #008080">57</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">11</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">jjwt;<br /></span><span style="COLOR: #008080">58</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">12</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">ybnl;<br /></span><span style="COLOR: #008080">59</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">13</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">rjjn;<br /></span><span style="COLOR: #008080">60</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" />  sheet1.Cells(</span><span style="COLOR: #000000">2</span><span style="COLOR: #000000">+</span><span style="COLOR: #000000">line,</span><span style="COLOR: #000000">14</span><span style="COLOR: #000000">).Value</span><span style="COLOR: #000000">=</span><span style="COLOR: #000000">ljnl;<br /></span><span style="COLOR: #008080">61</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/InBlock.gif" align="top" /><br /></span><span style="COLOR: #008080">62</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/ExpandedBlockEnd.gif" align="top" />}</span></span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">end for</span><span style="COLOR: #008000"><br /></span><span style="COLOR: #008080">63</span><span style="COLOR: #008000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000"><br /></span><span style="COLOR: #008080">64</span><span style="COLOR: #000000"><img src="http://www.aygfsteel.com/images/OutliningIndicators/None.gif" align="top" /></span></div><br />基本的代码已l实CQ生成excel的格式和一些统计计,用js写应该是很方便的Q以后有例子再作补充?br /><br />从代码角度来看这U写法不是很灉|Q但在能满用户的需求前提下Q这U生成方式还是很受欢q的Q给用户的感觉就是轻<br /><br />ѝ个为简单就是美Q?img src ="http://www.aygfsteel.com/beyondduke/aggbug/61911.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/beyondduke/" target="_blank">beyondduke</a> 2006-08-05 11:14 <a href="http://www.aygfsteel.com/beyondduke/archive/2006/08/05/61911.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>数据库常见的三种join方式Q收藏)http://www.aygfsteel.com/beyondduke/archive/2006/05/18/46745.htmlbeyonddukebeyonddukeThu, 18 May 2006 01:43:00 GMThttp://www.aygfsteel.com/beyondduke/archive/2006/05/18/46745.htmlhttp://www.aygfsteel.com/beyondduke/comments/46745.htmlhttp://www.aygfsteel.com/beyondduke/archive/2006/05/18/46745.html#Feedback1http://www.aygfsteel.com/beyondduke/comments/commentRss/46745.htmlhttp://www.aygfsteel.com/beyondduke/services/trackbacks/46745.html数据库常见的join方式有三U:inner join, left outter join, right outter join(q有一Ufull joinQ因不常用,本文不讨?。这三种q接方式都是两个以上的表通过on条g语句Q拼成一个大表。以下是它们的共同点Q?/p>

  1. 关于左右表的概念。左表指的是在SQL语句中排在left join左边的表Q右表指的是排在left join双的表?br />  2. 在拼成的大表中,左表排在左边Q右表排在右辏V?br />  3. on条g语句最好用=号对两表相应的主外键q行q接。当Ӟ也可以用其他操作W,?gt;, <, 来连接两表的M字段Q此时的关系非常复杂,q接后的记录C随之而变得不定。如果在一些特D的场合中需要用到这U方式,必须通过单的实例加以认Q否则,q接l果很可能不是我们所惌的!
  4. on条g语句不能省略?br />  5. 可以q锁使用joinQ每ơ用join都o另一表与当前的表或连接的l果相连接?/p>


在下文中Q用C两个表,"部门"表与"l织"表,其中Q?部门"表有一名ؓ"l织~号"的外键,指向"l织"表中的主?~号"?/p>

inner join

  格式Qselect * from 部门 inner join l织 on 部门.l织~号 = l织.~号

  目的Q将两表中符合on条g的所有记录都扑և来?/p>

  规律Q?/p>

    1. 拼出的大表记录不会增加?br />    2. 如果左边与右表的关系是一对多的关p,在选出的Q一记录中,假若双有多个记录与其对应,那么Q连接后的左表,主键不再唯一?/p>

  典型应用Q将存在多关pȝ引用表放在左表,存在一关系的被引用表放在右表,通过=号将d键进行连接,通过对右表设定过滤条Ӟ选出相应的且主键唯一的左表记录?/p>

  备注Qinner join 是默认的q接方式Q可~写为join?/p>

  转化为where子句Q?/p>

    select * from 部门, l织 where 部门.l织~号 = l织.~号

 

left outter join

  格式: select * from 部门 left join l织 on 部门.l织~号 = l织.~号

  格式: select * from l织 left join 部门 on l织.~号 = 部门.l织~号

  目的Q将左表的所有记录列出,双中只要符合on条g的,与左表记录相拼合Q不W合条g的,填以null倹{?/p>

  规律Q?/p>

    1. 选出所有符合条件的左表Q如果左边与双的关pL一对一的关p,则拼成的大表记录不会改变?br />       如果左边与右表的关系是多对一的关p,则拼成的大表记录也不会改变?br />       如果左边与右表的关系是一对多的关p,则拼成的大表记录会增加。对于每一h一对多关系的左表记录,如果左表1QN与右表对应,那么会多出N-1条记录。例如,如果左表W一条记?Q?对应于右表,多出2条记录。如果左表第二条记录1Q?对应于右表,则再多出1条记录。这Pd多出3条记录。其他类推?br />    2. 如果左边与右表的关系是一对多的关p,在选出的Q一记录中,假若双有多个记录与其对应,那么Q连接后的左表,主键不再唯一?br />    3. 如果左边与右表的关系是一对多的关p,对于左表M记录Q如果右表没有记录与其相对应Q则全部填以null倹{?/p>

  典型应用Q将存在多关pȝ引用表放在左表,存在一关系的被引用表放在右表,通过对右表设定过滤条Ӟ选出相应的且主键唯一的左表记录?/p>

  备注Qleft outter join可用left join代替。在有些数据库中Q如HSqlDb, 只能使用left join而不能用left outter join?/p>

  转化为where子句Q?/p>

    select * from 部门, l织 where 部门.l织~号 = l织.~号


right outter join

  格式: select * from 部门 right join l织 on 部门.l织~号 = l织.~号

  格式: select * from l织 right join 部门 on 部门.l织~号 = l织.~号

  目的Q将双的所有记录列出,左表中只要符合on条g的,与右表记录相拼合Q不W合条g的,填以null倹{?/p>

  规律Q?与left outter join相反)

  典型应用Q可转化成left outter join。例?/p>

    select * from l织 right join 部门 on 部门.l织~号 = l织.~号
    ?br />    select * from 部门 left join l织 on 部门.l织~号 = l织.~号
    的效果一?/p>

  备注Qright outter join可用right join代替。在有些数据库中Q如HSqlDb, 没有实现right join功能?/p>

  转化为where子句Q?/p>

    select * from 部门, l织 where 部门.l织~号 = l织.~号



beyondduke 2006-05-18 09:43 发表评论
]]>
递归程?/title><link>http://www.aygfsteel.com/beyondduke/archive/2006/03/29/37965.html</link><dc:creator>beyondduke</dc:creator><author>beyondduke</author><pubDate>Wed, 29 Mar 2006 01:31:00 GMT</pubDate><guid>http://www.aygfsteel.com/beyondduke/archive/2006/03/29/37965.html</guid><wfw:comment>http://www.aygfsteel.com/beyondduke/comments/37965.html</wfw:comment><comments>http://www.aygfsteel.com/beyondduke/archive/2006/03/29/37965.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/beyondduke/comments/commentRss/37965.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/beyondduke/services/trackbacks/37965.html</trackback:ping><description><![CDATA[递归<img src ="http://www.aygfsteel.com/beyondduke/aggbug/37965.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/beyondduke/" target="_blank">beyondduke</a> 2006-03-29 09:31 <a href="http://www.aygfsteel.com/beyondduke/archive/2006/03/29/37965.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>E序员的方向http://www.aygfsteel.com/beyondduke/archive/2006/03/25/37317.htmlbeyonddukebeyonddukeSat, 25 Mar 2006 03:21:00 GMThttp://www.aygfsteel.com/beyondduke/archive/2006/03/25/37317.htmlhttp://www.aygfsteel.com/beyondduke/comments/37317.htmlhttp://www.aygfsteel.com/beyondduke/archive/2006/03/25/37317.html#Feedback0http://www.aygfsteel.com/beyondduke/comments/commentRss/37317.htmlhttp://www.aygfsteel.com/beyondduke/services/trackbacks/37317.html

beyondduke 2006-03-25 11:21 发表评论
]]>
linux 下配|java环境Qjdk和tomcat)http://www.aygfsteel.com/beyondduke/archive/2006/02/14/30573.htmlbeyonddukebeyonddukeTue, 14 Feb 2006 04:34:00 GMThttp://www.aygfsteel.com/beyondduke/archive/2006/02/14/30573.htmlhttp://www.aygfsteel.com/beyondduke/comments/30573.htmlhttp://www.aygfsteel.com/beyondduke/archive/2006/02/14/30573.html#Feedback0http://www.aygfsteel.com/beyondduke/comments/commentRss/30573.htmlhttp://www.aygfsteel.com/beyondduke/services/trackbacks/30573.htmlJDK的配|:

    1,  下蝲j2sdk-linux-i386-rpm.bin
    2Q运行命令:chmod +x j2sdk-linux-i386-rpm.bin     Q修Ҏ可执行权限)
    3Q执?FONT style="BACKGROUND-COLOR: #d3d3d3" color=#0000ff>Q?/ j2sdk-1_3_1-linux-i386-rpm.bin        (执行后生成rpm安装包j2sdk-linux-i386.rpm)
    4Q?FONT style="BACKGROUND-COLOR: #d3d3d3" color=#0000ff>rpm -ivh j2sdk-1_3_1-linux-i386-rpm     (安装成功后,jdk被安装?usr/java/目录?
    5,   vi当前用户Q例root目录下)?bash_profile文gQ添加内容如下:

1export JAVA_HOME=/usr/java/j2sdk1.4.2_10
2export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.
jar
3export PATH=$PATH:$JAVA_HOME/bin

     6Qjava命oQ验证环境是否配|成功?BR>
TOMCAT的配|:
    
     1Q下载jakarta-tomcat-5.0.28.tar.gz
     2Q?tar zxvf jakarta-tomcat.tar.gz
     3Q?转换路径cd到tomcat/bin目录?FONT style="BACKGROUND-COLOR: #d3d3d3" color=#0000ff>Q?/startup.sh
(启动tomcat)
     4Q?在ie览器输?A href="http://servername:port">http://servername:port   Q验证tomcat是否启动成功Q?BR>      

   



beyondduke 2006-02-14 12:34 发表评论
]]>
JDBC实现oracle blob 出库入库http://www.aygfsteel.com/beyondduke/archive/2006/02/14/30542.htmlbeyonddukebeyonddukeTue, 14 Feb 2006 01:23:00 GMThttp://www.aygfsteel.com/beyondduke/archive/2006/02/14/30542.htmlhttp://www.aygfsteel.com/beyondduke/comments/30542.htmlhttp://www.aygfsteel.com/beyondduke/archive/2006/02/14/30542.html#Feedback0http://www.aygfsteel.com/beyondduke/comments/commentRss/30542.htmlhttp://www.aygfsteel.com/beyondduke/services/trackbacks/30542.html      id         varcharQ?0Q?BR>      image   blob
2Qblob入库
      拯Sunset.jpg囄在C盘根目录?nbsp;    
 1      DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); 
 2      Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:beyondduke","duke","duke"); 
 3      conn.setAutoCommit(false); 
 4      BLOB blob = null
 5      PreparedStatement pstmt = conn.prepareStatement("insert into imageTable(id,image) values(?,empty_blob())"); 
 6      pstmt.setString(1,"10001"); 
 7      pstmt.executeUpdate(); 
 8      pstmt.close(); 
 9      pstmt = conn.prepareStatement("select content from imageTable where id= ? for update"); 
10      pstmt.setString(1,"10001"); 
11      ResultSet rs = pstmt.executeQuery(); 
12     if (rs.next()) blob = (BLOB) rs.getBlob(1); 
13      String fileName = "c://Sunset.jpg"
14      File f = new File(fileName); 
15      FileInputStream fin = new FileInputStream(f); 
16      System.out.println("file size = " + fin.available()); 
17      pstmt = conn.prepareStatement("update imageTable set image=? where id=?"); 
18      OutputStream out = blob.getBinaryOutputStream(); 
19       byte[] data = new byte[(int)fin.available()]; 
20      fin.read(data); 
21      out.write(data); 
22      out.close(); 
23      fin.close(); 
24
25      pstmt.setBlob(1,blob); 
26      pstmt.setString(2,"fankai"); 
27
28      pstmt.executeUpdate(); 
29      pstmt.close(); 
30
31      conn.commit(); 
32      conn.close(); 
览数据库的数据Q发现image中数据大小与图片大一_说明入库了!
 3Qblob出库
 1   DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
 2   Connection conn = DriverManager.getConnection(            "jdbc:oracle:thin:@localhost:1521:beyondduke""duke","duke");     
          conn.setAutoCommit(
false);
 3    Statement stmt = conn.createStatement();
 4/* 查询BLOB对象 */
 5    ResultSet rs = stmt.executeQuery("SELECT content FROM javatest WHERE id='1001'");
 6while (rs.next()) {
 7/* 取出此BLOB对象 */    
 8    oracle.sql.BLOB blob = (oracle.sql.BLOB) rs.getBlob("image");
 9 BufferedOutputStream out = new BufferedOutputStream(new FileOutputStream("d://Sunset.jpg"));            
           BufferedInputStream in 
= new BufferedInputStream(blob    .getBinaryStream());        
10    int c;
11while ((c = in.read()) != -1{ out.write(c);        
12   }

13   in.close();
14   out.close();
15   rs.close();
16   stmt.close();
17   conn.close();
18
查D盘根目录Q会发现Sunset.jpg文gQ跟C盘下是一LQ说明入库出库成功!

beyondduke 2006-02-14 09:23 发表评论
]]>
java名h录(csdn摘)http://www.aygfsteel.com/beyondduke/archive/2006/01/07/26974.htmlbeyonddukebeyonddukeSat, 07 Jan 2006 05:59:00 GMThttp://www.aygfsteel.com/beyondduke/archive/2006/01/07/26974.htmlhttp://www.aygfsteel.com/beyondduke/comments/26974.htmlhttp://www.aygfsteel.com/beyondduke/archive/2006/01/07/26974.html#Feedback0http://www.aygfsteel.com/beyondduke/comments/commentRss/26974.htmlhttp://www.aygfsteel.com/beyondduke/services/trackbacks/26974.html Adrian Colyer AspectJ leaderQAJDJ leaderQIBM    Ben Galbraith z跃人士   Benjamin Renaud BEA副CTO   Bill Burke JBoss 架构师,EJB 3.0专家l里的Jboss代表   Bob McWhirter Groovy,Drools founder   Cedric Beust Weblogic架构?BEA   Cameron Purpy  JCache LeadQTangosol公司CEO blog Cliff Schmidt  BEA's Open source strategist and Apache Beehive leader   Craig McClanahan Struts founder, JSF 1.0 spec lead, Java Studio Creator leaderQ《Struts in action作者? SUN   David Nuescheler JSR 170, Content Repository for Java spec lead   Dion Almaer  TSSȝ, JDO专家l成?/FONT> blog Doug Cutting Lucene founder Ed Roman TSS CEO, MiddleWare CEOQ《Mastering EJB》作?/FONT>   Erich Gamma 设计模式开创者,Eclipse 的总设计师Q?Junit founderQIBM   Edward Burns JSF 1.2 spec leader   Floyd Marinescu TSS General ManagerQ《EJB Design Patterns》作?/FONT>   Gavin King Hibernate founder,《Hibernate in Action》作者,Jboss Gregor Hohpe  《Enterprise Integration Patterns》作者,ThoughtWorks   Gregor Kiczales AOP之父,AspectJ founder   Graham Hamilton Sun副总裁QJ2SE1.3,1.4,5.0 leader   Hani Suleiman OSWorkflow开发者,BileBlog作?/FONT> blog Howard Lewis Ship Tapestry和Hivemind founderQ《Tapestry in Action 》作?/FONT> James Duncan Davidson Ant and Tomcat founder James Strachan Geronimo的发赯之一, Jakarta目理委员会成?N多JSR expert group的成?/FONT>   Jason Careria  Webwork2QXwork core developer   blog Jason Hunter Apache基金会管理员Q《Java Servlet Programming》作?Xquery,Jdom{的开发?/FONT>   John Crupi 目前专著于SOA, Sun   Jonathan Bruce  JDBC spec leader,Sun   Joshua Bloch 《Effective Java》作者,前javaq_核心开发者,目前在google?/FONT>   Jon Tirsen Nanning lead developer, PicoContainer和NanoContainerz跃开 ?ThoughtWorks    Juergen Hoeler SpringFramework core developer,Co-Author Of《J2EE Development without EJB?/FONT>   Kent Beck 设计模式的开创者之一。XP ?TDD 的创始hQxUnit 的开发者?/FONT>   Linda DeMichiel  EJB 3.0 spec leadQSun   Marc Fleury JBoss Group CEO   Mark Hapner  J2EE1.4 lead. Sun Chief WebService Strategist and  JMS spec lead   Martin Fowler 软g工程和徏模领域的大师,Thoughtworks CEO blog Matt Raible 《Spring live》作?/FONT> blog Mike Cannon-Brookes
OpenSymphony founder,Atlassian founder(JIRA的公?,
<Java Open Source programing>作?javablogs founder
  Pat Lightbody  Webwork founder   Patrick Linskey
JDOz跃人士QJDO2.0,EJB3.0专家l成?/FONT>   Rick Ross Javalobby founder   Rickard Oberg Xdoclet,Webwork founder, jboss的前架构师,目前主要研究AOP   Robin Roos JDO2.0z跃人士Q《Java Data Object》作?/FONT>   Rod Johnson SpringFramework    Scott Ambler Senior ConsultantQ?很多书的作?/FONT>   Sergey Dmitriev Jetbrains CEOQIntelij IDEA founder   Ted Neward 《Effective Enterprise Java》作?/FONT> blog Vincent Massol Jakarta Cactus founderQMaven开发组成员, 《Junit in action》作?/FONT>


beyondduke 2006-01-07 13:59 发表评论
]]>
TheServerSide.com's 4th annual Java Symposium --Session Descriptions http://www.aygfsteel.com/beyondduke/archive/2005/12/24/25287.htmlbeyonddukebeyonddukeSat, 24 Dec 2005 02:55:00 GMThttp://www.aygfsteel.com/beyondduke/archive/2005/12/24/25287.htmlhttp://www.aygfsteel.com/beyondduke/comments/25287.htmlhttp://www.aygfsteel.com/beyondduke/archive/2005/12/24/25287.html#Feedback0http://www.aygfsteel.com/beyondduke/comments/commentRss/25287.htmlhttp://www.aygfsteel.com/beyondduke/services/trackbacks/25287.htmlSession Descriptions

A Dozen Ways to Get the Testing Bug Advanced Agile Technologies: Beyond XP Advanced Analytic Applications with Java Data Mining Advanced Testing Techniques with TestNG AOP in the Enterprise Apache Geronimo Prime-time Beyond Java: Technologies to Watch "Bottom 10" Reasons Agile Teams Fail Building Identity Management Solutions Building Quality Applications with Ajax Building Quality Applications with Ajax Frameworks Distributed Caching: Essential Lessons Dive into RIFE Essential EJB 3.0 Persistence Extreme Web Caching FastSOA: Applying Native XML Database Technology To Improve SOA Performance Flow with Continuations Java Specialists in Action JCR vs. RDBMS: Your App. is a "Content App.", 10 symptoms! The Mobile Java Application Continuum Patterns in Service-Oriented Architectures Open Source SOA using POJOs OSWorkflow Persistence with iBATIS - Hands On Portlet Development with JSF Productive Coder RAD That Ain't Bad: Domain Driven Development with Trails Refactoring Databases: Evolutionary Database Design Shale: The Next Struts? Software Visualization and Model Generation State of Web Frameworks Using Java Business Integration to Enable Composite Applications with ServiceMix XQuery for the Java Geek XML, Schemas and Performance The Importance of Preserving Object Identity while Clustering



A Dozen Ways to Get the Testing Bug
Mike Clark

You've heard everyone praising the benefits of test-driven development, and you'd really like to try it yourself, but how do you get started on a real project? This talk gives you 12 practical ways to start writing tests, and keep writing them, regardless of your project's technology or development process. You'll be able to immediately apply these no-nonsense techniques toward improving your design and testing skills. In no time you'll be writing better software, and faster!


Advanced Agile Techniques: Beyond XP
Scott Ambler

Many development teams have adopted some, if not all, of the techniques of Extreme Programming (XP). There is far more to agile software development, however, than XP. In this presentation you'll learn advanced techniques such as initial architectural modeling, database refactoring, model storming, and agile documentation practices (yes, you still have to write documentation).


Advanced Analytic Applications with Java Data Mining
Mark Hornick

Building applications without advanced analytics is becoming a dangerous practice. Applications that merely collect and report data using queries or OLAP will soon give way to competitor applications that enlist the help of advanced analytics capabilities such as data mining. The Java Data Mining standard (JSR-73) enables building advanced analytic applications natively in Java.

In this session, Mark highlights an application involving campaign management ?selecting customers for a product promotion. Response modeling involves identifying which customers are likely to respond to the promotion. First, Mark explores a solution without the use of data mining, then illustrate how that same application can be augmented with data mining technology to improve the response rate as well as the profitability of the campaign. Mark also provides an overview of JDM 1.0 (JSR-73) and the upcoming JDM 2.0 (JSR-247) standards and how these can be used to build such applications.


Advanced Testing Techniques with TestNG
Cedric Beust

TestNG is a recent testing framework built on annotations that offers advanced testing functionalities such as test groups, method parameters, dependent methods and time-outs.  This presentation will offer a short introduction to TestNG and then will discuss some testing scenarios typically encountered by programmers in various software areas and how TestNG can help create elegant and simple testing designs.


AOP in the Enterprise

Adrian Colyer

In this session Adrian will describe how and why you should be using AOP within your enterprise applications. You will gain a deeper understanding of the goals of AOP, and the different ways that AOP frameworks realize those goals. Spring AOP and AspectJ 5 will then be introduced, and their complementary roles within enterprise applications explained. Recommendations and a roadmap for getting started with these technologies will be presented (with examples and demos) so that you can begin applying what you learn during the talk straight away.


Apache Geronimo Prime-time
Jeff Genender

Apache Geronimo is the latest open source application server to achieve J2EE 1.4 certification, making it ready for prime time in the Enterprise. It is now a real contender in the open source application server market and offers a unique architecture making different open-source projects pluggable and capable of building customized stacks. This session will present an overview of Apache Geronimo, its architecture, its major open source components, how it works, and how to configure and use the application server. This session will cover Geronimo's different concepts such as the kernel, GBeans, deployment and different configurations, and running the application server.



Beyond Java: Technologies to Watch
Bruce Tate

Recently, we've seen a flurry of innovation happen in dynamic languages. From the Ruby on Rails framework to continuation servers to Erlang, a language based on concurrency, we've seen incredible innovation over the last two years. Many of these ideas are just now showing up on the Java platform in frameworks like Rife, Seam and Spring Web Flow.

"Bottom 10" Reasons Agile Teams Fail
Clinton Begin

Agile methodologies such as eXtreme Programming and SCRUM are hot topics today -- and they are also hot targets.  When things go wrong on an agile project, it's far too convenient to blame the methodology.  Consequently it's often the case that the methodology is blamed, instead of the people charged with implementing it correctly.  In this talk Clinton will discuss the most common reasons a team may fail when trying to execute a project using an agile methodology.  He'll cover how to learn from the mistakes of others, and avoid repeating new mistakes of your own.

Building Identity Management Solutions
Justen Stepka

Application developers are with what seems to be an unlimited number of approaches to integrating identity management and single sign-on(SSO).

This presentation will focus on the existing solutions that are available, commerical and open-source and examples from each to help you understand what solution might best work for you. Best practices and lessons learned from popular approaches will be covered too.

Building Quality Applications with Ajax
Dion Almaer & Justin Gehtland

Ajax has revolutionized Web application development in the short year since the term was coined. What is it all about? Why are we excited about a set of capabilities that have been sitting in our browser for years? What can you do with it? And, how can you do it?

Ajax , short for Asynchronous JavaScript and XML, is a technique for communicating with servers from within a web page without causing a page refresh.

This session provides:

  • An introduction to Ajax and an orientation to the state of the ajaxian universe
  • A demonstration of the basic ajaxian techniques through live coding. More advanced examples of Ajax will be demonstrated and deconstructed

You will understand:

  • How the Google Maps UI is built (and why it isn't as hard as it looks)
  • How Ajax can improve portals, community sites, and pretty much any other type of web application.

Furthermore, the issues surrounding how to create an Ajax application that doesn't turn into an unmaintainable pile of hacked up crap JavaScript will be discussed.

This talk will be presented by the founders of Ajaxian.com, a popular Ajax-related web portal.


Building Quality Applications with Ajax Frameworks
Dion Almaer & Justin Gehtland

Ajax techniques can lend tremendous richness to your Web UIs. But Ajax can be tedious and difficult to implement from scratch. Fortunately, there are a number of powerful frameworks that can make it much easier to do Ajax, including some that integrate with Java-based Web frameworks.

This session demonstrates (through live coding):

  • The popular Prototype, Dojo, MochiKit, DWR and Scriptaculous frameworks, each of which offers unique abilities to enhance your applications. These frameworks can be used with any server-side framework
  • Their use with Struts and JavaServer Faces applications

This talk will also discuss the state of Ajax support for JavaServer Faces via third-party JSF components and JSF-specific frameworks.

You will understand:

  • How to easily add amazing Ajax effects to your Java-based Web application.


Distributed Caching: Essential Lessons
Cameron Purdy

This presentation covers application development considerations for achieving maximum scalable performance and reliability in clustered J2EE environments, improving scalability and scalable performance of applications through the use of clustered caching to reliably share live data among clustered JVMs in the application tier, providing transparent fail-over as a key element of uninterrupted operation, and reduced load on the database tier as a key element of scalability.


Dive into RIFE
Geert Bevin

RIFE is a full-stack, open-source Java web application framework, offering fast results with the promise of maintainability and code clarity. This presentation gives you an exclusive insight into its goals and underlying ideas. Through some practical examples, the most important modules are introduced and you'll understand that it's very easy to quickly cover a great distance.

Essential EJB 3.0 Persistence
Doug Clarke

A crash course introduction to EJB 3.0 Persistence of Java Enterprise Edition 5.0. The goal of this session is to demonstrate how to apply the EJB 3.0 Persistence functionality in enterprise application development. Attendees will leave with enough information to get them started building enterprise applications using this new standard. The material will be presented using live demos of application development, testing, and deployment. The persistence capabilities both within and outside of an EJB container will be highlighted.

The open source reference implementation of the EJB 3.0 Persistence, TopLink Essentials, will be used in conjunction with the Eclipse Dali EJB ORM Project tools to build an end to end application illustrating common patterns and best practices.


Extreme Web Caching
Jason Hunter

Web Caching is very important for high traffic, high performance web site but few people know all the professional-level strategies. In this talk I'll share some of the tricks of the trade, including advanced tips from Yahoo's Mike Radwin.

We'll start with the basics: using client-side caches, conditional get, and proxies. Then we'll talk about more advanced features: how best to handle personalized content, setting up an image caching server, using a cookie-free domain for static content, and using randomization in URLs for accurate hit metering or sensitive content.

Attendees should have experience or interest in how the web works and in cajoling the web into doing their bidding.


FastSOA: Applying Native XML Database Technology To Improve SOA Performance
Frank Cohen

The choices Web Service architects and developers make on XML handling libraries, XML message encoding styles and binding utilities, and XML schema design and complexity, have a great impact on the scalability and performance of the deployed service. In this presentation, Frank Cohen will show the results of a recently completed research project that show the performance characteristics of three representative use case implementations on a variety of application servers, both commercial and open-source. Cohen will describe the developer learning curve and productivity story encountered when building the implementations with a wide variety of tools. Cohen will give attendees a kit of the software, a performance test, and developer guide book to use in your own environment.

Flow with Continuations
Geert Bevin

Get back in control of the natural flow of your application.

Continuations leverage the expressiveness of Java for the creation of re-enterable execution points. This presentation explains what continuations are and why they are useful. The benefits quickly become apparent through side-by-side comparisons with traditional flow management. You'll get an overview of the different approaches of today's tools and will see that continuations are handy in many application domains.

Java Specialists in Action
Dr. Heinz Kabutz

Java has some features that make it highly flexible to work with, like putty in the hands of a craftsman. Java specialists are not shy to use advanced features like dynamic proxies, generics, enums to their advantage. In this talk, we will demonstrate some approaches of using Java's dynamic proxies to create virtual proxies, protection proxies, dynamic object adapters and dynamic decorators. A part of the talk will also explore the performance implications and compare it with the benefits gained. P.S. If you are wondering why “enum?is listed under “advanced features?you should definitely attend this talk.


JCR vs. RDBMS: Your App. is a "Content App.", 10 symptoms!
David Nuescheler

In many applications the typical short-comings of relational databases are covered up either by using database centric frameworks or even worse by using secondary storage. This shows in symptoms that we all know: Binaries go into a Filesystem, "unstructured" information is stored in XML, etc...

This session is geared to prove that a JCR compliant content repository is the ideal general purpose "Future Storage" for modern Applications that require commodity features like Versioning, Fulltext search, Hierarchy support, Ranking, Namespaces without sacrificing transactions, referencial integrity and scalability.

Expect real-life examples and code-snippets.

The Mobile Java Application Continuum
Eugene Ciurana

J Mobile Java has historically being confined to games and trivial applications for personal and mobile devices.  Failure or reluctance on behalf of the manufacturers and carriers to implement a full range of services has prevented the wide adoption of the technology for robust applications.  This presentation introduces an execution architecture for rich mobile Java applications and for interacting with e-commerce or enterprise systems.  Robust mobile application design requires coordination with multiple tiers of resources and overcoming the limitations of J2ME/CLDC and the current crop of JSR implementations.  This presentation will teach you how to design and implement a Java mobile application that operates in a seamless continuum from the handset device to your data warehouse and with third-party service providers.

Open Source SOA Using POJOs
James Strachan

This session will provide an overview of how folks should develop SOA applications so they can take advantage of various middleware technologies like JMS, RMI, WS, JBI, BPEL etc yet keep their code simple and POJO like and to deal with things like asynchronous messaging, ESBs and so forth showing examples using different Apache tools and frameworks.


OSWorkflow

Hani Suleiman

OSWorkflow is a workflow engine from the OpenSymphony group. The talk will be an introduction of the osworkflow engine, a brief discussion of its architecture, as well as highlighting use cases and illustrating integration and usage patterns.

Patterns in Service-Oriented Architectures
Gregor Hohpe

If this was buzzword bingo I probably would be an instant winner with this session title. Nevertheless, patterns and service-oriented architectures do have very interesting and relevant intersection points. Both terms are fashionable, somewhat blurry and often abused. Both terms are also very much about architecture and design trade-offs ?the softer side of software development. Despite all the hype, SOA brings alternative architecture styles and programming models into the mainstream. We now write software using process engines, asynchronous message flow, rules engines, transformations etc. Each style comes with a collection of patterns that should be recognized and documented so that we can build effective solutions and discuss design trade-offs outside of specific technology choices and implementations.


Persistence with iBATIS - Hands On
Clinton Begin

A wise man once said: "PowerPoint is the worst thing ever to happen to public speaking." So, in this session, Clinton will use only a Java IDE and real-world examples to demonstrate how iBATIS is used to create an effective persistence layer for your application.  He will risk life and limb (or at least his reputation) coding before an audience, to build the back end of a simple Java application using a Test Driven approach.  No code snippets here, the persistence layer will be coded from scratch -- with no safety net!



Portlet Development with JSF
Kito Mann

Component-oriented user interface frameworks such as JavaServer Faces (JSF) are growing in popularity, and organizations are also beginning to recognize the power of building application components with the Portlet API. What many don't realize, however, is the fact that JSF has integrated support for the Portlet API, making it a natural fit for building portlets. This session starts with a brief overview of JSF, portlets, and portals. It then explains how JSF portlet support works, and examines the process of developing portlets with JSF. Next, it walks through the development of a simple JSF application and deployment of that application as a portlet inside of Liferay Enterprise Portal, an open-source portal server.

Productive Coder
Dr. Heinz Kabutz

Code Java at the speed of light. Modern IDEs have revolutionised the way in which we are able to churn out code. But sadly, most programmers are held back by bad habits and so never fully utilise the power that is at their fingertips. This talk will demonstrate practical tips on how to go from 2nd gear to overdrive. Topics range from keyboard skills to writing useful comments to refactoring quickly and correctly. Keywords such as final, which is not so final anymore in Java 5, and tools to help you detect dead and duplicate code. Have more fun in your day-to-day Java work by becoming one with your machine.


RAD That Ain't Bad: Domain Driven Development with Trails
Chris Nelson

The Trails framework aims to take a new approach to Rapid Application Development in Java using proven frameworks like Spring, Tapestry, and Hibernate. By eliminating redundant steps in the development process and stressing convention over configuration, Trail can greatly accelerate development of RDBMS persistent web applications. In this session, we'll build a real Trails application in a few minutes, and then dive into the details of how Trails works and how to customize it to your heart's content. We'll also cover how Trails provides features you need to build real application such as validation, internationalization, and security.


Refactoring Databases: Evolutionary Database Design
Scott Ambler

Just like you can refactor your Java code, you can also refactor your database schema. Unfortunately, it's about an order of magnitude tougher to do, in part because of the increased coupling which your schema is involved with, in part because of a lack of tooling, and in part because of cultural challenges within the data community (and that's the nice way to say it). In this presentation you'll learn how to successfully overcome these challenges and discover how to take an agile approach to database development.


Shale: The Next Struts?
Craig McClanahan

The standardization of JavaServer Faces has led to support for this technology in existing web application frameworks. However, most of them treat it as a view tier technology only. Shale, on the other hand, leverages the fact that JavaServer Faces includes a controller tier as well, and focuses on adding value and ease of use features, rather than redundantly implementing functionality that is already available. This session will review the key features added by Shale, as well as its place in the Struts community.


Software Visualization and Model Generation
Gregor Hohpe

Models are often viewed as something you create during design time and use to generate code. What if we turn the approach up-side-down and generate models from code? Humans are very good at recognizing patterns in images, making visualizations a valuable tool, for example to recognize dependencies or data flow. This is particularly true for dynamic, loosely coupled systems that are often less explicit and evolve over time. Once you have generated a model you can take things a step further and run checks and validations against it. Visualizations can also be used to plot out source code metrics over various dimensions to detect potential “hot spots?in the application that may require special attention.

This talk applies the concepts of visualization and model generation to a broad range of usage scenarios, such as asynchronous messaging, software components and object-oriented applications.


The State of Web Frameworks
Craig McClanahan

The last couple of years have seen a burst of both standardization and increased innovation in web application frameworks, to say nothing of the very quick uptake in popularity of AJAX. What does it mean for choosing server side technology? What does AJAX mean to existing frameworks? Should we all go back to rich clients instead? Come to this session for a high level overview of the present, and future, of building rich applications for the web.


Using Java Business Integration to Enable Composite Applications with ServiceMix
Bruce Snyder

Java Business Integration (JBI) is a simple API to a Normalized Message Service and Router along with a component model to facilitate the deployment and management of integration services. ServiceMix is a leading open source Enterprise Service Bus (ESB) and Service Oriented Architecture (SOA) toolkit based on the Java Business Integration

(JBI) specification. ServiceMix provides business integration capabilities using a complete JBI container and a host of JBI components including those for orchestration, rules, scheduling, transformation, validation and JBI transports including those for email, file, FTP, HTTP, JMS, RSS, VFS, VM and many more.

This session will focus on using ServiceMix in a composite application scenario that takes advantage of its JBI implementation and its use of other Java Enterprise Edition specifications.

Using the Apache License, not only can ServiceMix be deployed in a standalone configuration, but it is also fully integrated with Apache Geronimo or any other J2EE 1.4 compliant application server via the J2EE Connector Architecture (JCA). Fully embracing the Java Message Service (JMS) and Web Services standards allows ServiceMix to provide reliable and robust message delivery regardless of the message payload. The ServiceMix SOA platform provides for the managment of its JBI components via the Java Management eXtensions (JMX) using any JMX compliant management console.


XQuery for the Java Geek
Jason Hunter

XQuery is a new language from the W3C that lets you query XML -- or anything that can be represented as XML, such as relational databases.

As a Java developer -- especially a server-side Java developer -- XQuery is key to searching and manipulating large XML repositories or performing any XML-centric task.

This talk introduces XQuery to the Java developer. I'll explain the XQuery language; I'll show how to call XQuery from Java (including coverage of JSR-225, the XQuery API for Java); and I'll show the XQuery and Java code behind a sample custom book publishing application.

As the creator of JDOM, I'll also explain when to use XQuery instead of JDOM, and when to use both.

XML, Schemas and Performance
Frank Cohen

The IT world is dealing with an explosion of XML schemas and the average Java engineer is not prepared with today's XML tools and techniques. For instance, SOAP, RSS, REST, SOA schemas and protocols, and AJAX are challenging developers every day. In this session Frank Cohen will give many examples of XML schema incompatibility, inefficient and needlessly bulky code, and poor performance and scalability that come with popular XML handling libraries, tools, and techniques. Cohen will show how new strategies for on-the-fly data schema transformation, SOA metadata persistence and versioning and policy-driven intelligent data caching are viable solutions.

BOFs

The Importance of Preserving Object Identity while Clustering
Jonas Bonér and Patrick Calahan, Terracotta

Clustering and other forms of distributed computing are not easy in Java. The proliferation of clustered caches in the market today illustrates the need for tools to make clustering in Java easier. The problems with most current solutions are that they break Java's natural programming model ?with unnatural API's and breaking fundamental object identity. This Birds of a Feather session will focus on the importance of preserving object identity in a cluster, and will illustrate a runtime system that understands the developer's domain objects and clusters objects across a cluster transparently while maintaining object identity, using detailed code examples to illustrate the concepts.

 



beyondduke 2005-12-24 10:55 发表评论
]]>
վ֩ģ壺 ̨| | | ˹| | | ľ| | Ϻӿ| կ| | ³| ޻| ѳ| | | | | ԭ| | | տ| | | ԭ| | | ƽ| | | | | ƽ| Ϫ| ͭ| կ| | | ˹| ״| |