免费高清在线一区,一级香蕉视频在线观看,午夜精品久久久

一凡@ITO — Thu, 02 Mar 2006 17:07:00 GMT

一凡@ITO 2006-03-03 01:07 发表评论

�q�尾,�q�初好多事干呀

一凡@ITO — Fri, 27 Jan 2006 12:00:00 GMT

1.springside Promatic Enterprise Application KickStart��目
   说实�?�׃��q�段旉��比较�?�q�没攑֤��时间上�?真难�?A href="/calvin">白衣老大以及几位team Worker�?)
http://www.aygfsteel.com/calvin/archive/2006/01/02/26347.html

2.各个开源的新版本还没有旉��研究
    spring 2.0
    hibernate3.1

3.说要加强的东西还没安�?/STRONG>
   oracle

4.��C��q�的开源工具好象可以用上场�?/STRONG>
   bi tools
   openi (Roadmap 刚修改了,估计1.2版本�?006 1Q release,�{�了我好�?
   birt (2.0版本��单介�l?A HREF="/davidxu/archive/2006/01/27/29305.html">http://www.aygfsteel.com/davidxu/archive/2006/01/27/29305.html)
   pentaho

�q�有好多�?sh��)子没看�?)
不管怎样�Q�年�q�是要过�Q�happy new year!

一凡@ITO 2006-01-27 20:00 发表评论

一凡@ITO — Fri, 27 Jan 2006 08:58:00 GMT

what is BIRT

BIRT is an open source, Eclipse-based reporting system that integrates with your application to produce compelling reports for both web and PDF.

BIRT provides core reporting features such as report layout, data access and scripting. The current released version is 2.0. Please try BIRT and tell us what you think by filling bugs reports & enhancement requests through Bugzilla as explained on the community page.

New and Notable Features within BIRT 2.0

New BIRT Viewer
JavaScript/Java Events And Report Debugging
Runtime Data Source Property Binding
Chart Builder and SVG Output
Templates
Libraries
XML ODA
URL Builder
Multi-pass Aggregate, Sorting and Filtering
Improved Report Performance and PDF Fidelity
Dynamic Parameters/Cascading Parameters
Expression Builder
Importing of Style Sheets
Report XML Editor
Passing of External Object to Custom Data Sources
Stored Procedures
CLOB/BLOB Support

New and Notable Features within BIRT 2.0�Q?BR>http://www.eclipse.org/birt/phoenix/project/notable2.0.php

project home:http://www.eclipse.org/birt/

new report viewer [截图]

The Viewer also supports data extraction to CSV format [截图]

export to CSV [截图]

它的report designer �q�独立出来（不用依赖eclipse�Q�直接打开　BIRT.exe　��Ｏ�Q�．

个�h感觉�q�步了不��，但负责地说一句，应用到实际项目中我猜惌��会有不少的问题，�q�请大家抱学�?f��n)的态度�?BR>

马上��试了一下，发现之前好几点疑问都可以不用担心了，基本解决掉了:
1�Q�AJAX的分��?BR>　　只要自定义好报表/grid的宽以及高，实现css分页�Q�初步感觉效果还不错�Q�有待实际应用）

2�Q�导出excel
      支持export to csv�Q�虽然有中文��q��问题�Q�，另外当报表没有dataset(静态报�?时好象导不出�Q?BR>
3�Q�BIRT and POJOs as datasources example
      http://tools.osmosis.gr/blog/archives/2005/06/birt_and_object.html

4�Q�更人性化�Q�提供四个servlet
　a. /frameset?__report=test.rptdesign   (工具�?目录��D��,分页操作)
    b./preview?__report=test.rptdesign (工具�?目录��D��,分页操作)

    c./run?__report=test.rptdesign
    d./download?__report=test.rptdesign

一凡@ITO 2006-01-27 16:58 发表评论

了解jasperreport ,让web报表跑得更好

一凡@ITO — Mon, 28 Nov 2005 12:35:00 GMT

一、�ؓ什么是jasperreport
         很简单两点：
　　　　�Q�　免费
　　　　�Q�　在大多数开源��品中最能满��x��?公司的需求．
　　     如果要一句话�ȝ��那么��是 "适合��好!" �Q�其�ơ再��x��一�?其实jasperreport可以做得更好�Q�只是缺��大家去发现�?
             在erp软�g开发中一套强大易用的报表工具�q�是相当重要的地位，在这里我只针对一些日�怸�务报表．
              jasperreport + ireport 报表套装在普通的报表中已做得很不错：��水账式的，分组报表都可以轻村֮��?在这里提出的是一些相对特别以及少用到的报表设计问题．
             当前版本 : jasperreport 1.1.0
                                 ireport : 0.5.2

二、问题与解决

1.操作
        初用ireport 设计报表�Q�特别是早期的版本）感觉�q�是比较原始�Q�相对于birt �c�M��于在 Dreamweaver中画table 式的设计�q�是有点差距�Q�但新版�?0.5.2)中也有不��的改善�Q�增加了很多快速对齐，格式化的工具栏以及快��h��作方式．通过�l�合�q�些操作�q�算是方便了不少�Q?BR>
2.分页
           刚接触jasper report �Q�无论是看其官方的example�q�是自己动手设计报表, html view �ȝ��人很��q��印象�Q?怎么字体那么��，而且实际打印一下，分页功能�q�没真正实现"
        �l�过客户一轮的抗义�Q�最�l�还是下定决心去修补一下，
　　其实jasper report 原理�q�是挺简单：
　   它默认的分页方式是能�q�一轮的高度计算�Q�再用两�?lt;br>��׃��Z��事了�Q?/P>
<table>
<tr>
<td>
   <table>

   table>
   <br/>
   <br/>
   <table>

   table>
td>
tr>
table>

       解决�Ҏ(gu��)��Q?BR>       好在jasperreport�q�提供了很好的扩展方�?它允许我们自定义分页方式�Q�就是说在两��?table之间能让我们放自��q��代码�Q�，自己定义betweenPagesHtml ��Ｏ�Q�了�Q�可以能�q��E�Q�I��定义分页�Q�在�q�里�Q�我��q��接改它代码算了．大家可以自己选择.

net.sf.jasperreports.engine.export.JRHtmlExporter

pageEnd {page-break-after:always}

if (betweenPagesHtml == null)
                        {
                            writer.write(""pageEnd\">");   // 原来是两�?

                        } else
                        {
                            writer.write(betweenPagesHtml);
                        }

3. 打印
    　　分页解决后可以发现当报表预览时真的能一��一��分得很好．却又发现了一个问题．报表明显不能满一张Ａ�Q�张大小(ireport 设计选择的是�Q�４�U�张),疑惑了一际子�Q�其实不能算是BUG�Q?BR>　　　ireport 报表属性中明显(21 * 29.7 CM) 一张Ａ�Q�纸的大��，��Z��么ￃ�Q�_݋�Q�出来的效果却明昑ְ�的那么多了．其实�q�与计算机的分��L率有�?BR>　　　计算��Z��的分辨率�Q�普遍是72 象素/英寸�Q�而打印机普通是300象素/英寸�Q?BR>　　　jasperreport 与ireport 默认单位是px�Q�我猜想如果用CM做单位的话可以解册��个问题．但在�q�里我们的做法是��量加大报表设计时的宽度与高度．另一个要注意的是记得��所有页边距设�ؓ0,因�ؓ�q�些讄��在打印的时候已在ﾃ�Q�／��览器中讑֮�了，不用重复�Q?BR>
4.分栏
    　　以前没多注意,但刚用ireport新版本时可以发现在报表属性设计的时候可以设�|�栏�Q�这下子如果当报表主体部分列��C��多时实现分栏昄��Q�以节省�U�张�Q?BR>
5.斑马�U�式昄��报表��M��
　　　有时我们惌��报表更美化，让用��h��方便地观看数据，可以讄��两种色相隔．�q�种效果在jasperreport 中的example中有demo一下，大家如果惛_��?f��n)可以下载看看�?BR>
6.交叉报表

　　　关于jasperreport的交叉报表设计网上还是有不小的讨论，而真正实现的不多�Q�我观察�q�大多用jasperreport实现都是伪交叉报表．�q�不是真正实现真正的动态行与列�Q?BR>　　　其实在jaspert report下蝲包中�q�是有个交叉报表的实现example(crosstabs)�Q�只不过据我了解�Q�现在ireport�q�不能实现设计．只能通过手工写jrxml文�g实现�Q�本人小试一下，�q�是��Z��错的�Q?BR>

三、待研究
　通过�l�承net.sf.jasperreports.engine.export.JRHtmlExporter ,�q�是能扩展不��的功能�Q�例如用�Q�Ｓ�Q�x��式化�Q�可以大大减��代码量�Q�动态列�Q�可讑ֈ�宽度大大增强我们的报表功能．
　现本人初部实�?00�Q�宽度，不再用jasperreport中h(hu��n)ardcode列度�{�等,以下三点�q�有待时间去跟进:)

1.动态列
　
2.可设列宽�?BR>
3.CSS设计
　　

一凡@ITO 2005-11-28 20:35 发表评论

一凡@ITO — Sat, 27 Aug 2005 07:09:00 GMT
说明
extreme Table 是个很不错的table tag,打算记录底它的版本发�?change Log :)

它的RoadMap :
http://extremecomponents.org/extremesite/public/roadMap.jsp
以往本BLOG介绍: http://www.aygfsteel.com/davidxu/archive/2005/08/09/9683.aspx

我们从这里开�?

[1.0.0-M2-A2]
1.0.0-M2-A2 - by 官方

Able to mix the ColumnTag and the ColumnsTag. Will need to use the method
model.getColumnHandler().addAutoGenerateColumn(column);
Every attribute of every tag will accept an EL Expression
Will accept a Set for the collection now

部分使用说明 --by david xu

1 table 新增加var属�?支持定义bean name (可选择),可以不用${collectionName.memberName}�q�样难以理解的语�?
    用官方的话就�?BR>    "Added TableTag var attribute. Used (optionally) as the name of the variable to hold the current bean. "


<ec:table
    collection="humanList"
    action="${pageContext.request.contextPath}/index.jsp"
    imagePath="${pageContext.request.contextPath}/images/table/*.gif"
    cellpadding="1"
    saveFilterSort="true"
    var="human"
    title="我的�W�一个tag table">
ec:table>
${human.name} 取得

[1.0.1-M2]
1.0.1-M2 release by 官方

1. Things that changed and need to be aware of:

The ColumnTag exportable attribute has been removed

Replaced with the viewsAllowed and the viewsDenied attributes (see items 3 and 4)

Changed Cell interface

new interface ->public void init(BaseModel model, Column column);
Matches the View interface for consistency
The rowcount is part of the new Row bean. Can retrieve the rowcount by doing a model.getRowHandler().getRow().getRowCount()

Changed View interface

new interface -> public void body(BaseModel model, Column column);
Matches the Cell interface for consistency
Can get the column position by doing column.isFirstColumn() and column.isLastColumn()

New TableTag attributes to replace the deprecated collection attribute

The collection attribute has been deprecated in favor of three new attributes. The attributes are call tableId, items, and var
Read the full discussion for more information

Moved the element back on the Cell for the FilterCell.

If you modified the HtmlView, and specifically the filter row, then remove the element in the View.

2. New RowTag with cooresponding Row Bean

Able to do row level javascript onmouseover, onmouseout, and onclick
Ability to do row level highlighting. See stylesheet change (below) for proper formating.
Moved the stylesheet class attribute from the column () to the row ()

3. New ColumnTag attribute viewsAllowed

Can specify whether the column should be used for the current view. The views include html, pdf, xls, csv, plus any custom views.
If you specify a given view (or views), then only that view (or views) will use the column
For example you can specify viewsAllowed="pdf" which will use the column for the PDF export, but not any other export or default html View
Replaces the ColumnTag exportable attribute

4. New ColumnTag attribute viewsDenied

Can specify whether the column should not be used for the current view. The views include html, pdf, xls, csv, plus any custom views
If you specify a given view (or views), then only that view (or views) will not use the column
For example you can specify viewsDenied="html" which will not use the column for the html View, but will for all the exports
Replaces the ColumnTag exportable attribute

5. Enhancements

Every attribute of every tag will accept an EL Expression
Will accept a Set for the collection now
Confirmed to work with a RowSetDynaClass (if send as List)
Able to mix the ColumnTag and the ColumnsTag. Will need to use the method model.getColumnHandler().addAutoGenerateColumn(column);
Improved the default stylesheet

My initial intentions were to just change the stylesheet to work with the row highlighting, but I ended up tweaking it enough that now it just works better. For instance if you have some filters turned off then it seamlessly flows with the statusbar because it no longer uses cellspacing. If you use the new stylesheet be sure to remove the table.cellspacing=2 from your extremecomponents.properties file.

6. Bugs Fixed

Fixed Rows Displayed bug

The Rows Displayed was not working correctly with the Show All under certain conditions
Can set the median and max values in the extremecomponents.properties. The default values are table.medianRowsDisplayed=50 and table.maxRowsDisplayed=100, respectively

部分使用说明 --by david xu
1、TableTag 的改�?BR>      collection attribute 不再赞成使用,可以使用tableId, items, and var 取而代�?BR>

<ec:table
    items="customerList"
        tableId="customer"
        var="customer"
    title="customerList"
        ………�?BR>
>
………�?BR>ec:table>

2、ColumnTag 新属性的用法viewAllowed�Q�viewsDenied
      支持view包括:html, pdf, xls, csv以及自定的view

     viewsAllowed="pdf"    //说明�Q�只允许在pdf view �?/SPAN>
      viewsAllowed="html,xls" //也可以用,分隔

3�?STRONG> Cell interface 的改�?BR>       通过model.getRowHandler().getRow().getRowCount() �q�回 rowcount
4、新增RowTag

<ec:row highlightRow="true" onclick="alert('david')" >
   <ec:column/>
   <ec:column/>
   <ec:column/>
   ………�?BR>ec:row>

5、set ,RowSetDynaClass 的支�?/FONT>

<%
    List customerList = new ArrayList();
    LazyDynaBean temp = new LazyDynaBean();
    temp.set("code", "001");
    temp.set("name", "david xu");
    customerList.add(temp);
    request.setAttribute("customerList", customerList);
%>

   ………�?BR> ………�?BR>

6、Totalling Columns

<ec:table
        totalTitle="合计"
>
   <ec:column property="salary" showTotal="true"/>
ec:table>

New and Noteworthy 1.0.1-M3

This build represents a massive refacoring of the handler code and includes a new limit package. I believe the state of the code is the best it has ever been and in general has really gone to a new level. This was initially sparked by a refactoring of the Pagination (now Limit) and Rows Displayed features but then trickled down into the handler code and also resulted in a new Limit and LimitFactory.

Be sure to give yourself time to move to this release as you will need to fix your custom cells and views. I had to move some classes to different packages as things changed internally. The changes will make working with the eXtremeTable much easier and were unavoidable.

1. Things that changed and need to be aware of:

The Show All is no longer an option in the Rows Displayed droplist. It was confusing as the median and max rows would sometimes appear and sometimes go away. It was way to buggy also...you could filter the rows, select show all, and the hit clear. At that point you would display all the rows.
The BaseModel moved from the base package to the core package as there is no base package left.
The Limit, CollectionOfBeans, CurrentCollectionBean moved to the BaseModel.
org.extremecomponents.table.base.ModelUtils --> (moved) org.extremecomponents.table.core.ExportFilterUtils
The TableTag attribute rowsDisplayed="0" no longer has any meaning. If you would like to show all the rows then remove the pagination with the TableTag attribute showPagination="false". The reason for the change is because the rows displayed was reworked and the meaning dropped. Also, I could tell from code examples that many people were confused by the attribute and its meaning as both the showPagination="false" and rowsDisplayed="0" were used together. I would prefer one clear way to display all the rows.

2. Limit and LimitFactory

Basically you just build a Limit object and it self populates with everything that you need to figure out the sorting, filtering, rowStart, rowEnd, page, currentRows and totalRows. You used to have to deal with Strings and Maps versus now you work with simple intuitive objects and ints. I also use the Limit object internally with a different factory.

This is all you have to do:
Limit limit = LimitFactory.createInstanceOfLimit(request, tableId); LimitFactory.setLimitFilterAndSortAttr(limit); //once you know the total rows LimitFactory.setLimitPageAndRowAttr(limit, DEFAULT_ROWS_DISPLAYED, totalRows);

The example demonstrates how to work in a Controller (Spring) or Action (Struts).

Then in your JSP set the callbacks to point to the LimitCallback.

3. Enhancements

If you hard coded in any of the filter parameters then be sure to look at the TableContants class to see how they changed. The URL is more of a code than something you can read now.

4. Bugs Fixed

Fixed the FOP errors messages associated with the PDF Export View.
If the filter is invoked with no filter criteria the table no longer tries to match empty results. The effect before was the table would show no results, and now just remains the same.
Removed org.extremecomponents.table.tag.TableTagExtraInfo

一凡@ITO 2005-08-27 15:09 发表评论

Excel ��明操�?

一凡@ITO — Sat, 27 Aug 2005 03:30:00 GMT

�W�一�?/SPAN> ��M��说明... 2

前言... 2

操作界面... 2

�W�二�?/SPAN> 实例操作... 2

成�W单实�?/SPAN>... 2

�W�三�?/SPAN> 其它补充... 2

    格式�?/FONT>... 3

    打印... 5

�W�一�?/SPAN> ��M��说明

前言

MS设计�?/SPAN>office套装每一个都有其专注�Q�每一斚w��都�ؓ用户着惻I��不能不赞�Q��h家赚钱是为用��h��到最好！�Q?/SPAN>

Excel�q�是一个用于徏立与使用�?sh��)子报�?/SPAN>(表格)的实用程序，以表格的形式来储存数据，支持一整套函数操作�Q�方便统计以及打印�?BR>     无论是胦务部门制作工资表�q�是教师职工制作学生成�W表，无需很强的电(sh��)脑操作能力，都能快速制�?

操作界面

先了解一些概念：
工作��?/U>: Excel中定义一�?/SPAN>EXCEL文�g��是一个工作簿�Q�工作簿中可以放N张有相关的工作表�?/SPAN>
工作�?/U>: 若干个工作表�l�成一个工作簿�Q?/SPAN>EXCEL文�g�Q�，工作表之间可�?SPAN class=article>使用特定的方法相互引用数�?/SPAN>.
             如下图：最下面的Sheet1 Sheet2�{�就是一个一个工作表�Q�可能通过双击��其改名�Q�以及右键新增加工作表．
表格: 通常一个工作表中至��包含一个表��|��表格可由表头�Q�列(Excel中以A、B、C�{�字母表�C?�Q�行(Excel中以1�?�?数字表示)�l�成.
单元�Q�单元是最��的单位�Q�单元选定的行与列�l�成�Q?BR>          例如A列的�W�一行就是A1单元,B列的�W�六行就是B6单元

函数: excel中提供一整套函数公式方便用户�q�行数据�l�计与运��? 如AVERAGE(D3:D8)　意指�l�计D3-D8的��^均分.

如下囑֏�以直观地了对其有个大概的了解:

�W�二�?/SPAN> 实例操作

成�W单实�?/SPAN>

1、制作表�?/SPAN>
选择范围,讄��单元格属�?/SPAN>

寚w��全�ƈ单元�?BR>

�?[寚w��]标签中[合�ƈ单元格]操作�Q��ƈ在字体中讄��加粗�Q�输入＂学生成�W表＂　效果如下:

2、输入行�?以及相关的基��数据
点击单元�Q�cell�Q�分别录入相关的数据�Q�太��单，�q�里跌��Q�）

3、函��C��?BR>
�q�里主要学习(f��n)的是函数的��用，以其中AVERAEG��Z��说明

A.炚w��要录入的单�?/FONT>

B.插入函数

C.选择要进行��^均分的单�?BR>

OK,�q�样��完成了�l�计语文�q�_��成�W的工作．
观察一下上面的函数公司�?=AVERAGE(C3,C4,C5,C6,C7,C8)　
其实如果我们熟�?zh��n)�相关的函敎ͼ�可以在输入框中直接输�?=AVERAGE(C3:C8) 也达到同��L(f��ng)��效果.

�W�三�?/SPAN> 其它补充
1.格式�?BR>文字竖着�?BR>有时候我们要��一些文字格式化成竖��h��的效果，excel操作也挺��?/FONT>

2.打印
讄��打印��端标题�?BR>有时候表格太长，打印出来后会分页�Q�然而我们行头是不变�Q�希望它能在每一��늚��头都能打出来．
�W�一��：

�W�二��?

�q�种情况我们��p��讄��端标题�?

具体操作:
文�g- ��面属�?- 工作�?�Q�顶端标题行�Q�　然后点击选择每二行（在这里第二行是顶端标题行�Q?/FONT>

一凡@ITO 2005-08-27 11:30 发表评论

[other] office "办公三剑�?

一凡@ITO — Sat, 27 Aug 2005 02:47:00 GMT
       信息化时代，技术的不断发展�Q�计��机已不象当�q�那��h��富�h们的专有�?BR>本�h帮亲戚朋友装��Z��下十収ͼ�
使用者从大的三四十岁到小的十来岁都有,基本上目的都很明��————学�?工作需要�?BR>我估计随着�C�会发展�Q�电(sh��)脑普及率会更高，到时装机可能会象现在菜市��Z��P��Q?BR>   关于信息化的话题可能说上N天也说不完，今天��׃��扯得太远,主要介绍一下office "办公三剑�?�Q?BR>注意�q�边说的不是�|�页制作有三剑客�Q�DW,FW,FLASH�Q?而是微��Y公司的office软�g中的word,excel,powerpoint�?BR>因�ؓ安��有弟弟妹妹们�q�在��d��中、高中，了解��C��们的评��中早有计��机
�q�门课，听说�q�是学网��制作等的，哈，听来有点搞笑�Q�不懂得��Z��么这栯��计课�E�！
    个�h认�ؓ�Q�现在中��学生最需要学�?f��n)的计算机技能其实应该与实际�C�会需求相��d��Q�就是办公��Y件的应用�Q�原因很��单，
�q�些东西不管对于个�h�q�是以后工作都是必修课�?BR>    有幸出生在信息化的时代，感受�q�信息化�l�予我以及我的工作带来的好处�Q�体验过�w�边朋友的需�?
    在这里以我个人经验，�ȝ��一下，��L��三个:

    文档�~�写--word
    表格制作--excel
    演示�Q�课件制�?-powerpoint

�?文章部分是前旉��为家里一些朋友写�?现在拿出来与大家分��n一下�?BR>   本文介绍的是一些基��Q�也是实用的东西�Q�适合对这斚w��了解甚少的朋�?)


   Windows 文本操作软�g使用说明

   excel��明操�?/A>

   powerpoint 实操指南



 一凡@ITO 2005-08-27 10:47 发表评论

Window 文本操作软�g使用说明

一凡@ITO — Fri, 26 Aug 2005 02:53:00 GMT
     摘要: �W�一�?文本处理软�g说明... 2 1、前�a�... 2 2、三大常用��Y�?.. 2 �W�二�?操作快捷键说�?.. 3 前言... 3 新徏文档�Q�Ctrl + N�Q?.. 3 保存�Q�Ctrl + S�Q?.. 3 复制�Q�Ctrl + C�Q?.. 3 剪切�Q�Ctrl + X�Q?.. 3 撤消�Q�Ctrl + Z�Q?.. 4 恢复�Q�Ctrl + Y�Q?.. 4 全选（Ctrl + A�Q?..  阅读全文

一凡@ITO 2005-08-26 10:53 发表评论

一凡@ITO — Sat, 20 Aug 2005 04:44:00 GMT
一�?Microsoft Office Web Components

Spreadsheets

Charts

二、Open Source

1 、pentaho
Project Home Page: http://www.pentaho.org/

2、operni

Project Home Page: http://openi.sourceforge.net/

演示:   http://demo.openi.org/          用户�Q�tomcat 密码�Q�shallow
介绍: http://openi.sourceforge.net/open_source_BI-openi_story.PDF

3、JasperReports
Project Home Page: http://jasperreports.sourceforge.net/

4、Eclipse BIRT Project
Project Home Page: http://www.eclipse.org/birt

5、jfreechar
Project Home Page: http://www.jfree.org/jfreechart

其它相关 �Q�生xsl �Q�pdf
jakarta poi    http://jakarta.apache.org/poi/
itext http://www.lowagie.com/iText
FOP http://xml.apache.org/fop/index.html

后注�Q�本站将不定期发布相关的应用文章:)

一凡@ITO 2005-08-20 12:44 发表评论

三个��tips

一凡@ITO — Thu, 18 Aug 2005 11:21:00 GMT

��小的tips记录一�?

一、取回mysql ROOT��理员密�?/STRONG>
         [1] 跌��MySQL的访问控�?BR>              �q�入CMD命��o�?nbsp;
              C:\mysql\bin > mysqld-nt --skip-grant-tables&
             �q�样��M��人都可以在以��理员的�w�䆾�q�入MySQL,��Z��改ROOT密码提供前提条�g.
         [2] 控制台进入mysql
               C:\mysql\bin>mysql
               mysql> select * from mysql.user;          //查用戯��
              mysql> update mysql.user set password=password('david') where user='root';
               mysql>commit;
               重启mysql服务卛_��用刚才我们设�|�的'david'密码��d��?)

二、用jsp文�g存放CSS
        通常我们有这��L(f��ng)��需要，在��E�Q�I��中定义图片以及一些ￃ�Q�_�E文�g�Q?BR>然而在�~�写�q�程中，我们的代码��M��象这�?

background: #66A1D5 url(../images/headBg.gif) center left repeat;

form input.Rootcalendar {}{
    width: 65px;
    behavior: url(../js/calendar.htc)
}

       使用相对路径的�Ş式，�q�样做有一个限�Ӟ��是调用文�g的�\径一定是固定的．
然而当比较深入的文件调用时�Q�就会找不到相应的图片或相关的资源．
       好在jstl �l�我们提供了一�U�解��x��?然而要求css攑ֈ�jsp中这��L(f��ng)��需要就来了,应用挺简�?BR>

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
//原来的��E�Q�I��代码
……………�?BR>……………�?BR>……………�?BR>background: #66A1D5 url() center left repeat;

……………�?BR>……………�?BR>……………�?BR>……………�?BR>……………�?/FONT>

其它��面中调�?BR>

<link rel="stylesheet" href=""/css/style.jsp"/>" type="text/css">

三、日期时间函�?/STRONG>
        1、Oracel �?BR>        [1]取当月的日子�?


select to_char(last_day(sysdate),'dd') from dual
//如本�?8�? - 31�?/SPAN>


        [2]EXTRACT的应用（取年月日�Q?BR>

select EXTRACT(year FROM SYSDATE) from dual;
//本年 2005
select EXTRACT(month FROM SYSDATE) from dual;
//本月 8月䆾
select EXTRACT(day FROM SYSDATE) from dual;
//本日 18�?/SPAN>

        2�?nbsp;Mysql �?BR>
(本文未完!!)

一凡@ITO 2005-08-18 19:21 发表评论

免费高清在线一区,一级香蕉视频在线观看,午夜精品久久久

�q�尾,�q�初好多事干呀

what is BIRT

New and Notable Features within BIRT 2.0

了解jasperreport ,让web报表跑得更好

1. Things that changed and need to be aware of:

2. New RowTag with cooresponding Row Bean

3. New ColumnTag attribute viewsAllowed

4. New ColumnTag attribute viewsDenied

5. Enhancements

6. Bugs Fixed

New and Noteworthy 1.0.1-M3

1. Things that changed and need to be aware of:

2. Limit and LimitFactory

3. Enhancements

4. Bugs Fixed

Excel ���明操�?

�W�一�?/SPAN> ��M��说明

前言

操作界面

函数: excel中提供一整套函数公式方便用户�q�行数据�l�计与运��? 如AVERAGE(D3:D8) 意指�l�计D3-D8的��^均分.如下囑֏�以直观地了对其有个大概的了解:�W�二�?/SPAN> 实例操作

成�W单实�?/SPAN>

1、制作表�?/SPAN> 选择范围,讄���单元格属�?/SPAN>

[other] office "办公三剑�?

Window 文本操作软�g使用说明

三个���tips

Excel ��明操�?

函数: excel中提供一整套函数公式方便用户�q�行数据�l�计与运��? 如AVERAGE(D3:D8)　意指�l�计D3-D8的��^均分.

如下囑֏�以直观地了对其有个大概的了解:

�W�二�?/SPAN> 实例操作

1、制作表�?/SPAN>
选择范围,讄��单元格属�?/SPAN>

三个��tips