http://www.batchconverter.com/download.shtml

這種錯(cuò)誤可能是數(shù)據(jù)庫(kù)服務(wù)沒(méi)有啟動(dòng)或是沒(méi)有安裝補(bǔ)丁!

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection refused: connect
	at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
	at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
	at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
	at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
	at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
	at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
	at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)
	at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:101)
	at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78)
	at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:203)
	at com.telehot.dao.org.PmsUserDAOImpl.selectByExample(PmsUserDAOImpl.java:48)
	at com.telehot.dao.org.PmsUserDAOImpl.selectByExample(PmsUserDAOImpl.java:60)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
	at $Proxy23.selectByExample(Unknown Source)
	at com.telehot.action.Login.act(Login.java:56)
	at org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTypeNode.java:124)
	at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:46)
	at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:130)
	at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)
	at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:142)
	at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)
	at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:92)
	at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:234)
	at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:176)
	at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:248)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:679)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1154)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
	at java.lang.Thread.run(Thread.java:595)

??????（轉(zhuǎn)載別人的）
用Javascript取float型小數(shù)點(diǎn)后兩位，例22.127456取成22.13,如何做？

1. 最笨的辦法....... [我就怎么干的.........]

function get()
{
??? var s = 22.127456 + "";
??? var str = s.substring(0,s.indexOf(".") + 3);
??? alert(str);
}

2. 正則表達(dá)式效果不錯(cuò)

<script type="text/javascript">
onload = function(){
??? var a = "23.456322";
??? var aNew;
??? var re = /([0-9]+\.[0-9]{2})[0-9]*/;
??? aNew = a.replace(re,"$1");
??? alert(aNew);
}
</script>

3. 他就比較聰明了.....

<script>
var num=22.127456;
alert( Math.round(num*100)/100);
</script>

4.會(huì)用新鮮東西的朋友....... 但是需要 IE5.5+才支持。

?<script>
var num=22.127456;
alert( num.toFixed(2));
</script>

ANT Doc
http://ant.apache.org/manual/index.html
Dhtml Doc
http://www.phpx.com/man/dhtmlcn/
Hibernate3 Doc
http://www.redsaga.com/hibernate-ref/3.x/zh-cn/html/
Spring Doc
http://www.jactiongroup.net/reference/html/
J2se1.5 Doc
http://gceclub.sun.com.cn/Java_Docs/html/zh_CN/api/index.html
JavaScript Doc
http://man.ddvip.com/web/JScriptzhref/
Mysql Doc
http://www.linuxforum.net/books/mysqlmanual/manual_toc.html
Xpath Doc
http://www.zvon.org/xxl/XPathTutorial/General_chi/examples.html

??????昨天遇到一個(gè)問(wèn)題讓我困惑了半天，window.open("url?param="+paramvalue)傳遞參數(shù)出現(xiàn)亂碼，以前從沒(méi)有遇到過(guò)這種問(wèn)題，在客房端顯示是正常的，可是到服務(wù)端就是亂碼，不管用什么方式轉(zhuǎn)碼都不行，經(jīng)過(guò)和同事一翻調(diào)試，最后想到了一個(gè)js在客戶(hù)端轉(zhuǎn)碼的函數(shù)，escape(str);但是傳到服務(wù)端仍然是亂碼，必須在服務(wù)端進(jìn)行解碼。服務(wù)端執(zhí)行request.setCharacterEncoding("utf-8");或GBK,這樣傳過(guò)來(lái)的參數(shù)就不用轉(zhuǎn)碼也是中文了。唉，總算功夫沒(méi)有白費(fèi)!
?window.open("WindowCustomerListAction?username="+encodeURIComponent(form1.name.value), "customerList", "width=550,height=250,scrollbars=yes,resizable=yes,status=yes");
服務(wù)端
public class WindowCustomerListAction extends AbstractAction{
?/**
? * (non-Javadoc)
? *
? * @see org.apache.cocoon.acting.Action#act(org.apache.cocoon.environment.Redirector,
? *????? org.apache.cocoon.environment.SourceResolver, java.util.Map,
? *????? java.lang.String, org.apache.avalon.framework.parameters.Parameters)
? */
?public Map act(Redirector redirector, SourceResolver resolver,
???Map objectMode, String source, Parameters param) throws Exception {
??// TODO Auto-generated method stub
??Request request = ObjectModelHelper.getRequest(objectMode);
??String userName = request.getParameter("username")==null?"":request.getParameter("username").trim();
??//獲得要顯示的頁(yè)碼
??String showpage = request.getParameter("showpage") == null ? "1"
????: request.getParameter("showpage");
??//客戶(hù)信息接口
??ThProcessCustomerDAO customerDao = (ThProcessCustomerDAO) AppSqlConfig
????.getDaoManagerInstance().getDao(ThProcessCustomerDAO.class,
??????"sqlmap");
??//獲得客戶(hù)列表
??ThProcessCustomerExample example = new ThProcessCustomerExample();?
??example.setName("%"+userName+"%");
??example.setName_Indicator(ThProcessCustomerExample.EXAMPLE_LIKE);??
??List customerlist = customerDao.selectByExample(example);??
??int count = customerlist.size();
??
??//分頁(yè)
??PageControl pageControl = new PageControl();
??pageControl.setPageSize(10);
??pageControl.setRowCount(count);
??pageControl.setRequestUrl("WindowCustomerListAction?userName="+userName+"&amp;showpage=");
???????
??pageControl.setShowPage(Integer.parseInt(showpage));

??request.setAttribute("pageControl", pageControl);
??request.setAttribute("customerlist", customerlist);
??return null;
?}
}

http://www.chinaenglish.com.cn/n839c35.aspx 今天遇到上面的錯(cuò)誤,如果用Navicat工具連接可以成功，用命令方式就不行，后來(lái)在網(wǎng)上找了一下，用mysql -u <你數(shù)據(jù)庫(kù)的用戶(hù)名> -p<你數(shù)據(jù)庫(kù)的密碼>? 就可以啟動(dòng)了!
(引用)
導(dǎo)出要用到MySQL的mysqldump工具，基本用法是：??

shell>?mysqldump?[OPTIONS]?database?[tables]??

如果你不給定任何表，整個(gè)數(shù)據(jù)庫(kù)將被導(dǎo)出。??

通過(guò)執(zhí)行mysqldump?--help，你能得到你mysqldump的版本支持的選項(xiàng)表。??

注意，如果你運(yùn)行mysqldump沒(méi)有--quick或--opt選項(xiàng)，mysqldump將在導(dǎo)出結(jié)果前裝載整個(gè)結(jié)果集到內(nèi)存中，如果你正在導(dǎo)出一個(gè)大的數(shù)據(jù)庫(kù)，這將可能是一個(gè)問(wèn)題。??

mysqldump支持下列選項(xiàng)：??

--add-locks??
在每個(gè)表導(dǎo)出之前增加LOCK?TABLES并且之后UNLOCK?TABLE。(為了使得更快地插入到MySQL)。??
--add-drop-table??
在每個(gè)create語(yǔ)句之前增加一個(gè)drop?table。??
--allow-keywords??
允許創(chuàng)建是關(guān)鍵詞的列名字。這由表名前綴于每個(gè)列名做到。??
-c,?--complete-insert??
使用完整的insert語(yǔ)句(用列名字)。??
-C,?--compress??
如果客戶(hù)和服務(wù)器均支持壓縮，壓縮兩者間所有的信息。??
--delayed??
用INSERT?DELAYED命令插入行。??
-e,?--extended-insert??
使用全新多行INSERT語(yǔ)法。（給出更緊縮并且更快的插入語(yǔ)句）??
-#,?--debug[=option_string]??
跟蹤程序的使用(為了調(diào)試)。??
--help??
顯示一條幫助消息并且退出。??
--fields-terminated-by=...??
　??
--fields-enclosed-by=...??
　??
--fields-optionally-enclosed-by=...??
　??
--fields-escaped-by=...??
　??
--fields-terminated-by=...??
這些選擇與-T選擇一起使用，并且有相應(yīng)的LOAD?DATA?INFILE子句相同的含義。??
LOAD?DATA?INFILE語(yǔ)法。??
-F,?--flush-logs??
在開(kāi)始導(dǎo)出前，洗掉在MySQL服務(wù)器中的日志文件。??
-f,?--force,??
即使我們?cè)谝粋€(gè)表導(dǎo)出期間得到一個(gè)SQL錯(cuò)誤，繼續(xù)。??
-h,?--host=..??
從命名的主機(jī)上的MySQL服務(wù)器導(dǎo)出數(shù)據(jù)。缺省主機(jī)是localhost。??
-l,?--lock-tables.??
為開(kāi)始導(dǎo)出鎖定所有表。??
-t,?--no-create-info??
不寫(xiě)入表創(chuàng)建信息(CREATE?TABLE語(yǔ)句）??
-d,?--no-data??
不寫(xiě)入表的任何行信息。如果你只想得到一個(gè)表的結(jié)構(gòu)的導(dǎo)出，這是很有用的！??
--opt??
同--quick?--add-drop-table?--add-locks?--extended-insert?--lock-tables。??
應(yīng)該給你為讀入一個(gè)MySQL服務(wù)器的盡可能最快的導(dǎo)出。??
-pyour_pass,?--password[=your_pass]??
與服務(wù)器連接時(shí)使用的口令。如果你不指定“=your_pass”部分，mysqldump需要來(lái)自終端的口令。??
-P?port_num,?--port=port_num??
與一臺(tái)主機(jī)連接時(shí)使用的TCP/IP端口號(hào)。（這用于連接到localhost以外的主機(jī)，因?yàn)樗褂?Unix套接字。）??
-q,?--quick??
不緩沖查詢(xún)，直接導(dǎo)出至stdout；使用mysql_use_result()做它。??
-S?/path/to/socket,?--socket=/path/to/socket??
與localhost連接時(shí)（它是缺省主機(jī))使用的套接字文件。??
-T,?--tab=path-to-some-directory??
對(duì)于每個(gè)給定的表，創(chuàng)建一個(gè)table_name.sql文件，它包含SQL?CREATE?命令，和一個(gè)table_name.txt文件，它包含數(shù)據(jù)。?注意：這只有在mysqldump運(yùn)行在mysqld守護(hù)進(jìn)程運(yùn)行的同一臺(tái)機(jī)器上的時(shí)候才工作。.txt文件的格式根據(jù)--fields-xxx和--lines--xxx選項(xiàng)來(lái)定。??
-u?user_name,?--user=user_name??
與服務(wù)器連接時(shí)，MySQL使用的用戶(hù)名。缺省值是你的Unix登錄名。??
-O?var=option,?--set-variable?var=option設(shè)置一個(gè)變量的值。可能的變量被列在下面。??
-v,?--verbose??
冗長(zhǎng)模式。打印出程序所做的更多的信息。??
-V,?--version??
打印版本信息并且退出。??
-w,?--where='where-condition'??
只導(dǎo)出被選擇了的記錄；注意引號(hào)是強(qiáng)制的！??
"--where=user='jimf'"?"-wuserid>1"?"-wuserid<1"?

最常見(jiàn)的mysqldump使用可能制作整個(gè)數(shù)據(jù)庫(kù)的一個(gè)備份：?

mysqldump?--opt?database?>?backup-file.sql??

但是它對(duì)用來(lái)自于一個(gè)數(shù)據(jù)庫(kù)的信息充實(shí)另外一個(gè)MySQL數(shù)據(jù)庫(kù)也是有用的：??

mysqldump?--opt?database?|?mysql?--host=remote-host?-C?database??

由于mysqldump導(dǎo)出的是完整的SQL語(yǔ)句，所以用mysql客戶(hù)程序很容易就能把數(shù)據(jù)導(dǎo)入了：??

shell>?mysqladmin?create?target_db_name??
shell>?mysql?target_db_name?<?backup-file.sql?
就是?
shell>?mysql?庫(kù)名?<?文件名 convert d: /fs:ntfs
把fat32轉(zhuǎn)換成ntfs格式

??????對(duì)struts感興趣的朋友可以去這個(gè)網(wǎng)站看看，里面有不少好東西！希望能夠?qū)δ阌兴鶐椭Y源共享。
??????http://www.learntechnology.net/struts-lesson-1.do

???????如果你對(duì)自定義標(biāo)簽庫(kù)比較感興趣的話(huà)，可以去看看這個(gè)網(wǎng)址，里面有不少例子。
??????http://www.orionserver.com/docs/tutorials/taglibs/???