oracle-query1.txt
资源名称:OA.rar [点击查看]
上传用户:mingda
上传日期:2017-06-20
资源大小:27691k
文件大小:7k
源码类别:
OA系统
开发平台:
Java
- <TABLE onmouseup=t_onmouseup() onmousemove=t_onmousemove() onmousedown=t_onmousedown() id=t style="BORDER-RIGHT: 1px solid; TABLE-LAYOUT: fixed; BORDER-TOP: 1px solid; FILTER: alpha(opacity=90); LEFT: 0px; BORDER-LEFT: 1px solid; CURSOR: default; BORDER-BOTTOM: 1px solid; POSITION: absolute; TOP: 0px; BORDER-COLLAPSE: collapse" borderColor=lightgrey cellSpacing=0 borderColorDark=white cellPadding=0 frame=box graph="%3Croot%3E%3C/root%3E" recordsetxml="%3Crecord%3E%0D%0A%3Cr%3E4%3C/r%3E%3Cc%3E2%3C/c%3E%3Cpagesize%3E10%3C/pagesize%3E%0D%0A%3Cmainsql%3E%3Csql%3Eselect%20fstrkey%2Csum%28fdbl1%29%20from%20test1%20where%202000%3D2000%20group%20by%20fstrkey%0D%0A%3C/sql%3E%3C/mainsql%3E%0D%0A%3C/record%3E%0D%0A" initwhere buttonxml="%3Croot%3E%3Cbutton%3E%3Cvalue%3Efcpage%3C/value%3E%3C/button%3E%0D%0A%3Cbutton%3E%3Cvalue%3E%u67E5%u8BE2%3C/value%3E%3Cclick%3Efc_getwhere%28%29%3C/click%3E%3C/button%3E%0D%0A%3Cbutton%3E%3Cvalue%3E%u6253%u5370%u9884%u89C8%3C/value%3E%3Cclick%3EPreviewReport%28%29%3C/click%3E%3C/button%3E%0D%0A%3Cbutton%3E%3Cvalue%3E%u6253%u5370%3C/value%3E%3Cclick%3EPrintReport%28%29%3C/click%3E%3C/button%3E%0D%0A%3C/root%3E" condition="%3Croot%3E%0D%0A%3Croot%3E%3Coption%20selected%3D%221%22%20%3E%u79D1%u76EE%3C/option%3E%3Coption%3E%u65B9%u5411%3C/option%3E%3C/root%3E%0D%0A%3Ccztype%3E%3Cfc%3E3%3Csql1%3Eselect%20fstrkey%2Cfstrtable%20from%20test1%20%3C/sql1%3E%3Cformat%3E%u79D1%u76EE%u7F16%u7801%21%7C%u79D1%20%u76EE%20%u540D%20%u79F0%3C/format%3E%3C/fc%3E%0D%0A%3Cfc%3E3%3Cxml%3E%u501F%u65B9%3B%u8D37%u65B9%3C/xml%3E%3Cformat%3E%u65B9%u5411%21%3C/format%3E%3C/fc%3E%0D%0A%3C/cztype%3E%0D%0A%3C/root%3E%0D%0A" fixrows="1" fixcols="1" queryorder="0"><COLGROUP id=tg>
- <COL class=fixedStyle style="WIDTH: 35px; CURSOR: default" align=middle>
- <COL style="WIDTH: 70px">
- <COL style="WIDTH: 70px">
- <COL style="WIDTH: 70px">
- <COL style="WIDTH: 70px">
- <COL style="WIDTH: 70px">
- <COL style="WIDTH: 70px">
- <COL style="WIDTH: 70px">
- <COL style="WIDTH: 70px">
- <COL style="WIDTH: 70px">
- <COL style="WIDTH: 70px"></COLGROUP>
- <THEAD>
- <TR class=fixedStyle style="CURSOR: default; HEIGHT: 21px" align=middle>
- <TD style="COLOR: black"></TD>
- <TD style="COLOR: black">A</TD>
- <TD style="COLOR: black">B</TD>
- <TD style="COLOR: black">C</TD>
- <TD style="COLOR: black">D</TD>
- <TD style="COLOR: black">E</TD>
- <TD style="COLOR: blue">F</TD>
- <TD style="COLOR: black">G</TD>
- <TD style="COLOR: black">H</TD>
- <TD style="COLOR: black">I</TD>
- <TD style="COLOR: black">J</TD></TR></THEAD>
- <TBODY>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">1</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">2</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">3</TD>
- <TD></TD>
- <TD colSpan=6>要正确运行此示例,你的oracle库中应有一个test1的表</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">4</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: blue">5</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">6</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">7</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">8</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">9</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">10</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">11</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">12</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">13</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">14</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">15</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">16</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">17</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">18</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">19</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">20</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">21</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">22</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">23</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">24</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR>
- <TR style="HEIGHT: 21px">
- <TD style="COLOR: black">25</TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD>
- <TD></TD></TR></TBODY></TABLE>