2009年7月24日

今天create db instance，sqlplus 登錄后遇到PLS-00201這個錯：

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 人在旅途閱讀(585) | 評論 (0) | 編輯收藏

2008年10月15日

樹狀菜單查詢SQL

? 有一表a???? 字段???????????? a.dir?? ,...?
? 數據如下????????????????????? 1???????????????
??????????????????????????????? 1/01?
??????????????????????????????? 1/01/1?
??????????????????????????????? 1/02?
??????????????????????????????? 2?
??????????????????????????????? 。。。?
? 表b?????????? 字段?????????? b.dir,?????????? b.class?
? 數據如下????????????????????? 1/01?????????? b?
??????????????????????????????? 1/01?????????? bb?
??????????????????????????????? 1/01/1?????? c?
??????????????????????????????? 1/01/1?????? cc?
??????????????????????????????? 1/01/1?????? cd?
??????????????????????????????? 1/02?????????? e?
??????????????????????????????? 2???????????????? f?
??????????????????????????????? 。。。?
??
求出對應a表每行對應b表的數據和,如下?
??
??????????????? 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 人在旅途閱讀(644) | 評論 (0) | 編輯收藏

2008年7月18日

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

采用Struts中的Mock方式模擬action和actionForm進行測試
基礎類：STCRequestProcessor
作用：Ioc 將模擬的Action,ActionForm注入到struts-config.xml中的相應的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類：
setUp()方法：
super.setUp();//調用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，設置web應用的根??
??11.?-??setRequestPathInfo，設置request的請求??
??12.?-??addRequestParameter，將參數和對應的值加入request中??
??13.?-??actionPerform，執行這個請求??
??14.?-??verifyForward，驗證forward的名字是否正確??
??15.?-??verifyForwardPath，驗證forward的path是否正確??
??16.?-??verifyNoActionErrors，驗證在action執行過程中沒有ActionError產生??
??17.?-??verifyActionErrors，驗證在action執行過程中產生的ActionError集合的內容??
??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 人在旅途閱讀(724) | 評論 (0) | 編輯收藏

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

摘要: TestDBConnection父類所有test類繼承該類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 人在旅途閱讀(579) | 評論 (0) | 編輯收藏

2008年4月24日

apache與weblogic整合

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

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

?

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

2007年7月18日

下拉的文本框限定大小，而里面的內容比文本框的長度長

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

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

2007年4月24日

SSH+ajax學習筆記（一）

1。基礎的就不說了，配置環境。用MYECLIPSE傻瓜式的點下一步就行
      注意的是最好在WEB.XML中配一下applicationContext的監聽器。
      容易犯錯：1。找不到action : 原因找不到applicationContext.xml路徑，在classes下面
                        2。找不到項目包：原因 web.xml配的不對，加個spring的路徑就行了。
2。hibernate 的查詢：
      hql一開始確實用的不順，關鍵是sql用常了，面向POJO的查詢剛用比較痛苦。昨天看了個帖子說要學hql去查hibernate的API。。這個人純粹扯淡。hibernate的API里面一大堆全TMD 是看不懂的難記的類明，找了半天也沒個介紹hql的。BS這個閉著眼裝明白的帖子。
初學hibernate 讀讀doctor王的深入淺出hibernate還是很有幫助的。
3。ajax 火熱的領域，但還沒有統一的標準。現在大多都是用的google的那套。
現在遇到一個問題：當一個系統的功能非常強，所需要后臺的處理就相當的頻繁。
是應該建多點的 action 響應呢還是在已經有的action里多加方法響應呢？？

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

2006年1月11日

從txt文件中導數據

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){
   //語句
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 人在旅途閱讀(123) | 評論 (0) | 編輯收藏

2005年10月24日

工作日志——權限管理

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

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

2005年10月21日

test

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

僅列出標題下一頁

2025年5月

日

一

二

三

四

五

六

統計

隨筆： 46
文章： 14
評論： 27
引用： 0

常用鏈接

留言簿(1)

隨筆檔案

文章檔案

收藏夾

drools(2) (rss)

搜索

積分與排名

積分 - 30100
排名 - 1382