2009年7月24日

今天create db instance，sqlplus 登錄后遇到PLS-00201這個(gè)錯(cuò)：

SQL> set serveroutput on
ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

SQL> exec dbms_output.enable(10000);
BEGIN dbms_output.enable(10000); END;

? ?? ?*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

解決辦法：

1. use sysdba to execute two sql(/$Oracle_home/rdbms/admin).

logging as sysdba
try to run standard.sql,catalog.sql

2. use sys and system to execute these sql scrīpt

as SYS (or connect internal)
$Oracle_home/rdbms/admin/catalog.sql
$Oracle_home/rdbms/admin/catsnmp.sql
$Oracle_home/rdbms/admin/catexp7.sql
$Oracle_home/rdbms/admin/catproc.sql
$Oracle_home/rdbms/admin/caths.sql
as SYSTEM (not SYS)
$Oracle_home/rdbms/admin/catdbsyn.sql

unix 重啟oracle

su -oracle
sqlplus / as sysdba
shutdown immediate;
startup

posted @ 2009-07-24 15:35 人在旅途閱讀(596) | 評(píng)論 (0) | 編輯收藏

2008年10月15日

樹(shù)狀菜單查詢SQL

? 有一表a???? 字段???????????? a.dir?? ,...?
? 數(shù)據(jù)如下????????????????????? 1???????????????
??????????????????????????????? 1/01?
??????????????????????????????? 1/01/1?
??????????????????????????????? 1/02?
??????????????????????????????? 2?
??????????????????????????????? 。。。?
? 表b?????????? 字段?????????? b.dir,?????????? b.class?
? 數(shù)據(jù)如下????????????????????? 1/01?????????? b?
??????????????????????????????? 1/01?????????? bb?
??????????????????????????????? 1/01/1?????? c?
??????????????????????????????? 1/01/1?????? cc?
??????????????????????????????? 1/01/1?????? cd?
??????????????????????????????? 1/02?????????? e?
??????????????????????????????? 2???????????????? f?
??????????????????????????????? 。。。?
??
求出對(duì)應(yīng)a表每行對(duì)應(yīng)b表的數(shù)據(jù)和,如下?
??
??????????????? dir?????????????? count?
??????????????????????????????? 1?????????????????? 6?
??????????????????????????????? 1/01???????????? 5?
??????????????????????????????? 1/01/1???????? 3?
??????????????????????????????? 1/02???????????? 1?
??????????????????????????????? 2?????????????????? 1?
??

select?? a.dir,[count]=count(b.class)?
? from?? 表a???? a?? join?? 表b?? b?? on?? b.dir?? like?? a.dir+'%'?
? group?? by?? a.dir

posted @ 2008-10-15 15:36 人在旅途閱讀(652) | 評(píng)論 (0) | 編輯收藏

2008年7月18日

基于StrutsTestCase的單元測(cè)試(Action測(cè)試方法)

采用Struts中的Mock方式模擬action和actionForm進(jìn)行測(cè)試
基礎(chǔ)類(lèi)：STCRequestProcessor
作用：Ioc 將模擬的Action,ActionForm注入到struts-config.xml中的相應(yīng)的action位置

???1.?package?test.sample.service.util;??
???2.?import?java.io.IOException;??
???3.?import?java.util.HashMap;??
???4.?import?javax.servlet.http.HttpServletRequest;??
???5.?import?javax.servlet.http.HttpServletResponse;??
???6.?import?javax.servlet.http.HttpSession;??
???7.???
???8.?import?org.apache.struts.action.Action;??
???9.?import?org.apache.struts.action.ActionForm;??
??10.?import?org.apache.struts.action.ActionMapping;??
??11.?import?org.apache.struts.action.RequestProcessor;??
??12.?import?org.apache.struts.util.RequestUtils;??
??13.???
??14.?/**?*//**?
??15.??*?@author?administrator?
??16.??*?
??17.??*?To?change?this?generated?comment?edit?the?template?variable?"typecomment":?
??18.??*?Window>Preferences>Java>Templates.?
??19.??*?To?enable?and?disable?the?creation?of?type?comments?go?to?
??20.??*?Window>Preferences>Java>Code?Generation.?
??21.??*/??
??22.?public?class?STCRequestProcessor?extends?RequestProcessor?{??
??23.???
??24.?????private?static?HashMap?mockActionFormMap?=?new?HashMap();??
??25.?????private?static?HashMap?mockActionMap?=?new?HashMap();??
??26.???
??27.?????public?static?void?addMockAction(String?actionStr,?String?className)???
??28.?????{??
??29.?????????mockActionMap.put(actionStr,?className);??
??30.?????}??
??31.?????public?static?void?addMockActionForm(String?actionFormStr,String?className)??
??32.?????{??????
??33.?????????mockActionFormMap.put(actionFormStr,?className);??
??34.?????}??
??35.?????/**?*//**?
??36.??????*?We?will?insert?Mock?ActionForm?for?testing?through?this?method?
??37.??????*/??
??38.?????protected?ActionForm?processActionForm(??
??39.?????????HttpServletRequest?request,??
??40.?????????HttpServletResponse?response,??
??41.?????????ActionMapping?mapping)?{??
??42.???
??43.???????????
??44.?????????//?Create?(if?necessary?a?form?bean?to?use??
??45.?????????String?formBeanName?=?mapping.getName();??
??46.?????????String?mockBeanClassName?=?(String)?mockActionFormMap.get(formBeanName);??
??47.?????????if?(mockBeanClassName?==?null)??
??48.?????????????return?super.processActionForm(request,?response,?mapping);??
??49.???
??50.?????????ActionForm?instance?=?null;??
??51.?????????try?{??
??52.?????????????Class?formClass?=?Class.forName(mockBeanClassName?);??
??53.?????????????instance?=?(ActionForm)?formClass.newInstance();??
??54.?????????}?catch?(ClassNotFoundException?e)?{??
??55.?????????????e.printStackTrace();??
??56.?????????}?catch?(InstantiationException?e)?{??
??57.?????????????e.printStackTrace();??
??58.?????????}?catch?(IllegalAccessException?e)?{??
??59.?????????????e.printStackTrace();??
??60.?????????}??
??61.???
??62.?????????instance.setServlet(servlet);??
??63.?????????if?(instance?==?null)?{??
??64.?????????????return?(null);??
??65.?????????}??
??66.???
??67.?????????if?(log.isDebugEnabled())?{??
??68.?????????????log.debug(??
??69.?????????????????"?Storing?ActionForm?bean?instance?in?scope?'"??
??70.?????????????????????+?mapping.getScope()??
??71.?????????????????????+?"'?under?attribute?key?'"??
??72.?????????????????????+?mapping.getAttribute()??
??73.?????????????????????+?"'");??
??74.?????????}??
??75.?????????if?("request".equals(mapping.getScope()))?{??
??76.?????????????request.setAttribute(mapping.getAttribute(),?instance);??
??77.?????????}?else?{??
??78.?????????????HttpSession?session?=?request.getSession();??
??79.?????????????session.setAttribute(mapping.getAttribute(),?instance);??
??80.?????????}??
??81.?????????return?(instance);??
??82.???
??83.?????}??
??84.???
??85.?????/**?*//**?
??86.??????*?We?will?insert?Mock?Action?Class?through?this?method?
??87.??????*/??
??88.?????protected?Action?processActionCreate(??
??89.?????????HttpServletRequest?request,??
??90.?????????HttpServletResponse?response,??
??91.?????????ActionMapping?mapping)??
??92.?????????throws?IOException?{??
??93.?????????String?orignalClassName?=?mapping.getType();??
??94.?????????String?mockClassName?=?(String)mockActionMap.get(orignalClassName);??
??95.?????????if(?mockClassName?==?null?)??
??96.?????????????return?super.processActionCreate(request,response,mapping);??
??97.?????????String?className?=?mockClassName;??????????
??98.?????????if?(log.isDebugEnabled())?{??
??99.?????????????log.debug("?Looking?for?Action?instance?for?class?"?+?className);??
?100.?????????}??
?101.???
?102.?????????Action?instance?=?null;??
?103.?????????synchronized?(actions)?{??
?104.???
?105.?????????????//?Return?any?existing?Action?instance?of?this?class??
?106.?????????????instance?=?(Action)?actions.get(className);??
?107.?????????????if?(instance?!=?null)?{??
?108.?????????????????if?(log.isTraceEnabled())?{??
?109.?????????????????????log.trace("??Returning?existing?Action?instance");??
?110.?????????????????}??
?111.?????????????????return?(instance);??
?112.?????????????}??
?113.???
?114.?????????????//?Create?and?return?a?new?Action?instance??
?115.?????????????if?(log.isTraceEnabled())?{??
?116.?????????????????log.trace("??Creating?new?Action?instance");??
?117.?????????????}??
?118.???
?119.?????????????try?{??
?120.?????????????????instance?=?(Action)?RequestUtils.applicationInstance(className);??
?121.?????????????}?catch?(Exception?e)?{??
?122.?????????????????log.error(??
?123.?????????????????????getInternal().getMessage("actionCreate",?mapping.getPath()),??
?124.?????????????????????e);??
?125.???
?126.?????????????????response.sendError(??
?127.?????????????????????HttpServletResponse.SC_INTERNAL_SERVER_ERROR,??
?128.?????????????????????getInternal().getMessage(??
?129.?????????????????????????"actionCreate",??
?130.?????????????????????????mapping.getPath()));??
?131.???
?132.?????????????????return?(null);??
?133.?????????????}??
?134.???
?135.?????????????instance.setServlet(this.servlet);??
?136.?????????????actions.put(className,?instance);??
?137.?????????}??
?138.???
?139.?????????return?(instance);??
?140.?????}??
?141.???
?142.?}??

Test類(lèi)：
setUp()方法：
super.setUp();//調(diào)用mockStrutsTestCase中的setUp方法
File web = new File("E:/project/portal/WebContent");
this.setContextDirectory(web);//定位工程包的位置
setConfigFile("/WEB-INF/web.xml");//定位工程中的web.xml位置
setConfigFile("/WEB-INF/struts-config.xml");//定位工程中struts-config.xml位置
STCRequestProcessor.addMockActionForm("ser_wordForm", "test.sample.service.form.MockWordForm");//注入模擬的form
STCRequestProcessor.addMockAction("com.huawei.service.action.WordAction","test.sample.service.action.MockWordAction");// 注入模擬的action
setRequestPathInfo("/service/word");//定義struts-config.xml中的path名稱

???1.?package?test.sample.service.action;??
???2.???
???3.???
???4.?import?java.io.File;??
???5.???
???6.?import?servletunit.struts.MockStrutsTestCase;??
???7.?import?test.sample.service.util.STCRequestProcessor;??
???8.?/**?*//**?
???9.??*??
??10.?-??setContextDirectory，設(shè)置web應(yīng)用的根??
??11.?-??setRequestPathInfo，設(shè)置request的請(qǐng)求??
??12.?-??addRequestParameter，將參數(shù)和對(duì)應(yīng)的值加入request中??
??13.?-??actionPerform，執(zhí)行這個(gè)請(qǐng)求??
??14.?-??verifyForward，驗(yàn)證forward的名字是否正確??
??15.?-??verifyForwardPath，驗(yàn)證forward的path是否正確??
??16.?-??verifyNoActionErrors，驗(yàn)證在action執(zhí)行過(guò)程中沒(méi)有ActionError產(chǎn)生??
??17.?-??verifyActionErrors，驗(yàn)證在action執(zhí)行過(guò)程中產(chǎn)生的ActionError集合的內(nèi)容??
??18.??*?@author?donganlei?
??19.??*?
??20.??*/??
??21.?public?class?MockWordActionTest?extends?MockStrutsTestCase?{??
??22.???????
??23.?????public?void?testInvalidPageflag1()throws?Exception{??
??24.???????????addRequestParameter("reqCode","getWordList");??
??25.???????????addRequestParameter("pageflag","userquery");??
??26.???????????actionPerform();??
??27.???????????verifyNoActionErrors();??
??28.???????????verifyForward("querylist");??
??29.?????}??
??30.???????
??31.?????public?void?testInvalidPageflag2()throws?Exception{??
??32.???????????addRequestParameter("reqCode","getWordList");??
??33.???????????addRequestParameter("pageflag","seatquery");??
??34.???????????actionPerform();??
??35.???????????verifyNoActionErrors();??
??36.???????????verifyForward("querylist");??
??37.?????}??
??38.???????
??39.?????public?void?testInvalidInitUpdate()throws?Exception{??
??40.???????????addRequestParameter("reqCode","initUpdate");??
??41.???????????actionPerform();??
??42.???????????verifyNoActionErrors();??
??43.???????????verifyForward("update");??
??44.?????}??
??45.?????public?void?testinitUpdate()throws?Exception{??
??46.???????????addRequestParameter("reqCode","initUpdate");??
??47.???????????addRequestParameter("wordid","3");??
??48.???????????addRequestParameter("roomid","3");??
??49.???????????actionPerform();??
??50.???????????verifyNoActionErrors();??
??51.???????????verifyForward("update");??
??52.?????}??
??53.?????protected?void?setUp()?throws?Exception?{??
??54.?????????super.setUp();??
??55.?????????File?web?=?new?File("E:/project/portal/WebContent");??
??56.?????????this.setContextDirectory(web);??
??57.?????????setConfigFile("/WEB-INF/web.xml");??
??58.?????????setConfigFile("/WEB-INF/struts-config.xml");??
??59.?????????STCRequestProcessor.addMockActionForm("ser_wordForm",?"test.sample.service.form.MockWordForm");??
??60.?????????STCRequestProcessor.addMockAction("com.huawei.service.action.WordAction","test.sample.service.action.MockWordAction");??
??61.?????????setRequestPathInfo("/service/word");??
??62.?????}??
??63.?????public?static?void?main(String?args[]){??
??64.?????????junit.textui.TestRunner.run(MockWordActionTest.class);??
??65.?????}????
??66.?}??

Struts-congfig.xml中的processorClass
<controller>
<set-property property="processorClass" value="test.sample.service.util.STCRequestProcessor"/>
</controller>

posted @ 2008-07-18 11:22 人在旅途閱讀(736) | 評(píng)論 (0) | 編輯收藏

基于DBUnit的manage(Dao)單元測(cè)試

摘要: TestDBConnection父類(lèi) 所有test類(lèi)繼承該類(lèi)Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->???1.?package?test.sample.service.util;?????2.??????3.?import?java.io.Fi... 閱讀全文

posted @ 2008-07-18 11:20 人在旅途閱讀(587) | 評(píng)論 (0) | 編輯收藏

2008年4月24日

apache與weblogic整合

web服務(wù)器與應(yīng)用服務(wù)器的整合中,apache與weblogic 的整合算的上最普遍也是最基礎(chǔ)的整合了
今天配置了一下：
apache 2.0
weblogic 8.1
1.將weblogic中的mod_wl_22.so 拷貝到 apache的modules目錄下
（*注：weblogic8.1中沒(méi)有針對(duì)apache2.2版的mod_wl_22.so,只有針對(duì)apache2.0版的mod_wl_20.so ，需要從別的地方比如down一個(gè)）
2.配置apache下的httpd.conf文件
（1）<Directory "應(yīng)用程序目錄"></Directory>//配置apache啟動(dòng)時(shí)的訪問(wèn)路徑
（2）<IfModule dir_module>
???????????? DirectoryIndex index.htm??? //配置apache的默認(rèn)訪問(wèn)文件
?????????</IfModule>
（3）LoadModule weblogic_module modules/mod_wl_22.so//加載weblogic的module
（4）<IfModule mod_weblogic.c>
???????????? WebLogicHost 127.0.0.1//配置應(yīng)用程序的主機(jī)地址
?????????????WebLogicPort 7001 //配置端口
???????????? MatchExpression *.jsp //配置匹配文件
???????????? MatchExpression *.do
?????????????MatchExpression */portal/*
?????????</IfModule>
（注 4是配單服務(wù)是配置，配置集群服務(wù)

??????<IfModule mod_weblogic.c>
? ???????????WebLogicCluster 192.168.0.100:7001,192.168.0.52:7001? //集群下各個(gè)應(yīng)用的addr+port
???????????? MatchExpression *.jsp
???????????? MatchExpression *.*
???????????? MatchExpression *
??????</IfModule>
）

?

posted @ 2008-04-24 13:36 人在旅途閱讀(897) | 評(píng)論 (6) | 編輯收藏

2007年7月18日

下拉的文本框限定大小，而里面的內(nèi)容比文本框的長(zhǎng)度長(zhǎng)

?<span style="width:130; solid black;overflow:hidden">
<select></select>
</span>

posted @ 2007-07-18 10:48 人在旅途閱讀(171) | 評(píng)論 (0) | 編輯收藏

2007年4月24日

SSH+ajax學(xué)習(xí)筆記（一）

1。基礎(chǔ)的就不說(shuō)了，配置環(huán)境。用MYECLIPSE傻瓜式的點(diǎn)下一步就行
      注意的是最好在WEB.XML中配一下applicationContext的監(jiān)聽(tīng)器。
      容易犯錯(cuò)：1。找不到action : 原因找不到applicationContext.xml路徑，在classes下面
                        2。找不到項(xiàng)目包：原因 web.xml配的不對(duì)，加個(gè)spring的路徑就行了。
2。hibernate 的查詢：
      hql一開(kāi)始確實(shí)用的不順，關(guān)鍵是sql用常了，面向POJO的查詢剛用比較痛苦。昨天看了個(gè)帖子說(shuō)要學(xué)hql去查hibernate的API。。這個(gè)人純粹扯淡。hibernate的API里面一大堆全TMD 是看不懂的難記的類(lèi)明，找了半天也沒(méi)個(gè)介紹hql的。BS這個(gè)閉著眼裝明白的帖子。
初學(xué)hibernate 讀讀doctor王的深入淺出hibernate還是很有幫助的。
3。ajax 火熱的領(lǐng)域，但還沒(méi)有統(tǒng)一的標(biāo)準(zhǔn)。現(xiàn)在大多都是用的google的那套。
現(xiàn)在遇到一個(gè)問(wèn)題：當(dāng)一個(gè)系統(tǒng)的功能非常強(qiáng)，所需要后臺(tái)的處理就相當(dāng)?shù)念l繁。
是應(yīng)該建多點(diǎn)的 action 響應(yīng)呢還是在已經(jīng)有的action里多加方法響應(yīng)呢？？

posted @ 2007-04-24 20:57 人在旅途閱讀(557) | 評(píng)論 (0) | 編輯收藏

2006年1月11日

從txt文件中導(dǎo)數(shù)據(jù)

try{
Connection conn=DBManager.getConnection();
FileInputStream file=new FileInputStream("e:/t.txt");
BufferReader read=new BufferReader(new InputStreamReader(file));
String line="";
line=read.readLine();
int i=0;
while(line!=null){
   //語(yǔ)句
i=line.indexOf("");
Statement stat=conn.creatStatement();
String account="";
String password="";
String str1="";
StringTokenizer str=new StringTokenizer(line.subString(i+1),"");
while(str.hasMoreElement()){
   account=str.nextToken();
   password=str.nextToken();
   str1=str.nextToken();
   String sql="insert into table (account,password) values('"+account+" ' ,' "+password+"   ' )";
stat.executeUpdate(sql);
}
   line=read.readLine();
}
}catch(FileNotFoundError e){
   e.printStackTrace();
}catch(IOException e){
   e.printStackTrace();
}catch(Exception e){]
   e.printStackTrace();
}

posted @ 2006-01-11 09:08 人在旅途閱讀(127) | 評(píng)論 (0) | 編輯收藏

2005年10月24日

工作日志——權(quán)限管理

將權(quán)限分配好之后。就開(kāi)始向頁(yè)面中加入權(quán)限。
這可以有兩種選擇：
a、將沒(méi)有權(quán)限的按鈕屏蔽，不能點(diǎn)擊
b、將沒(méi)有權(quán)限的按鈕做返回框，
我用的是第一種方法
幾個(gè)表
user??????roles??????userinroles???和１３個(gè)permission表
username,rolename,和permission表里的roleid都是唯一的便于關(guān)聯(lián)。
系統(tǒng)共有13個(gè)模塊，也就是13個(gè)權(quán)限組。
每個(gè)user中可對(duì)應(yīng)多個(gè)權(quán)限名稱，但屬于每個(gè)模塊的名稱只能有一個(gè)
所以可以在用戶登錄時(shí)，對(duì)用戶所攜帶的權(quán)限信息進(jìn)行判斷。
在判斷時(shí)，將用戶的角色名稱給取出來(lái)。

posted @ 2005-10-24 16:35 人在旅途閱讀(229) | 評(píng)論 (0) | 編輯收藏

2005年10月21日

test

posted @ 2005-10-21 08:46 人在旅途閱讀(94) | 評(píng)論 (0) | 編輯收藏

僅列出標(biāo)題下一頁(yè)

2025年7月

日

一

二

三

四

五

六

導(dǎo)航

統(tǒng)計(jì)

隨筆： 46
文章： 14
評(píng)論： 27
引用： 0

常用鏈接

留言簿(1)

隨筆檔案

文章檔案

收藏夾

drools(2) (rss)

搜索

積分與排名

積分 - 30461
排名 - 1376