涓銆乴oadrunner鐩戞帶linux瀹夎鏂囨。
1錛庡畨瑁卹sh錛屽拰rsh-server涓や釜鏈嶅姟鍖呫?br />
a. 鍗歌澆rsh
rpm –q rsh----------鏌ョ湅鐗堟湰鍙?/p>
璇存槑錛氬鏋滅増鏈瓨鍦紝鍒欑洿鎺ュ畨瑁卹pc.rstatd-4.0.1.tar.gz
銆銆銆濡傛灉鐗堟湰涓嶅瓨鍦紝鍒欏湪linux瀹夎鍖呬笅鎵緍sh-0.17-14.i386.rpm rsh-server-0.17-14.i386.rpm
銆銆銆鍙兘鐗堟湰涓嶄竴鑷達(dá)紝浣嗘槸鍧囧彲浣跨敤
B錛庡畨瑁?/p>
rpm –ivh rsh-0.17-14.i386.rpm rsh-server-0.17-14.i386.rpm
2錛?涓嬭澆騫跺畨瑁卹statd錛堣繖涓寘鍦ㄦ垜鐨勫叡浜洰褰曚笅涔熸湁錛?br />
gunzip rpc.rstatd-4.0.1.tar.gz
tar –cvf rpc.rstatd-4.0.1.tar
./configure ---閰嶇疆
make ---緙栬瘧
璇存槑錛歛.濡傛灉鍦╨inux涓嬩笉鑳借В鍘嬶紝鍒欏湪window涓嬭В鍘嬶紝鐒跺悗鎷峰埌l(fā)inux涓嬶紝鐩綍涓嶅畾錛岀敤鎴蜂負(fù)root鐢ㄦ埛
銆銆銆b.淇敼configure鏂囦歡鐨勪嬌鐢ㄦ潈闄?br />
銆銆銆 chmod 777 configure
c.鎸夌収涓婇潰鐨勬楠ゆ搷浣?/p>
3銆?鎵撳紑/etc/xinetd.conf
閲岄潰鍐呭鏄細(xì)
# Simple configuration file for xinetd
#
# Some defaults, and include /etc/xinetd.d/
defaults
{
instances = 60
log_type = SYSLOG authpriv
log_on_success = HOST PID
log_on_failure = HOST
cps = 25 30
}
includedir /etc/xinetd.d
4錛庨噸鍚痻inetd錛?/p>
A:
service xinetd reload
璇存槑錛氬彲鑳戒細(xì)鏈夋彁紺哄嚭鐜幫紝涓嶇敤澶勭悊錛岀洿鎺ヨ繘鍏ヤ笅涓姝?/p>
6錛庡湪鍚姩rstatd錛?br /> 銆銆榪涘叆浣爎pc.rstatd-4.0.1.tar.gz鐨勮В鍘嬫枃浠剁洰褰?br /> 銆銆rpc.rstatd
7.鏌ョ湅rstatd鏄惁鍚姩錛?/p>
rpcinfo –p
濡傛灉鑳界湅鍒幫細(xì)
100001 5 udp 618 rstatd
100001 3 udp 618 rstatd
100001 2 udp 618 rstatd
100001 1 udp 618 rstatd
灝辮鏄巖statd鏈嶅姟宸茬粡鍚姩銆傚彲浠ョ敤LR鍘葷洃瑙嗕簡(jiǎn)銆?/p>
浜屻乴oadrunner鐩戞帶weblogic8.1
1.鎷瘋礉weblogic.jar鍒?{lr_home}/classes涓嬶紝鍚屾椂錛屽垹闄mxri.jar鎴栬呬慨鏀筳mxri.jar涓轟換浣曞悕縐?br />
2.淇敼${lr_home}/dat/monitors涓嬬殑WebLogicMon.ini鏂囦歡錛屽唴瀹瑰涓嬶細(xì)
鍘熷鍐呭涓猴細(xì)JVM=javaw.exe JavaVersion=1.4;JavaVendor=Sun Microsystems Inc.
銆淇敼鍚庡唴瀹逛負(fù)錛欽VM=D:\bea\jdk141_03\bin\javaw.exe JavaVersion=1.4;JavaVendor=Sun Microsystems Inc.
銆鍏朵腑D:\bea\jdk141_03\bin\javaw.exe涓鴻嚜宸辨湰鍦皐eblogic鐨刯dk鎵鍦ㄤ綅緗?br />
銆javaVersion涓簑eblogic鎵鐢ㄧ殑jdk鐗堟湰鍙?br />
銆
銆鍦ㄧ綉涓婃湁鐨勮姹備慨鏀筗eblogic=weblogic.jar銆Port=1112錛岃姹傛妸PORT淇敼涓?001錛屼絾鍦ㄨ繖閲岀殑瀹為檯瀹夎榪囩▼涓紝娌℃湁鍋氫慨鏀廣?br />
3.閰嶇疆濡備綍鐩戞帶lr鐨剋eblogic(jmx)
銆鎵撳紑weglogic(jmx),娣誨姞搴﹂噺
銆鍏朵腑鐩戞帶鐨勮綆楁満鍚嶇О涓猴細(xì)ip:7001錛屽192.168.1.88:7001錛屽鉤鍙伴夋嫨鎵鍐檌p鐨凮S
鐒跺悗鐐瑰嚮涓嬮潰鐨勮祫婧愬害閲忕殑娣誨姞錛岃緭鍏ョ櫥褰曠殑鐢ㄦ埛鍚嶅拰瀵嗙爜錛屾澶勭殑鐢ㄦ埛鍚嶅拰瀵嗙爜涓猴細(xì)ip鎵鍦∣S涓婄殑weblogic鐨勭櫥褰曠敤鎴峰悕鍜屽瘑鐮?br />
銆鍦ㄧ偣鍑葷‘瀹氬悗浼?xì)鍑虹幇闇瑕佺洃鎺х殑璧勬簮淇℃伅錛屽彲浠ラ夋嫨鑷繁鎰熷叴瓚ｇ殑鏂歸潰榪涜鐩戞帶
]]>
]]>
錛戙佸浣曞皢java.util.Date杞寲涓簀ava.sql.Date?
杞寲錛?br />
java.sql.Date sd;
java.util.Date ud;
//initialize the ud such as ud = new java.util.Date();
sd = new java.sql.Date(ud.getTime());
錛掋佸鏋滆鎻掑叆鍒版暟鎹簱騫朵笖鐩稿簲鐨勫瓧孌典負(fù)Date綾誨瀷
閭ｄ箞鍙互鐢≒reparedStatement.setDate(int ,java.sql.Date)鏂規(guī)硶
鍏朵腑鐨刯ava.sql.Date鍙互鐢ㄤ笂闈㈢殑鏂規(guī)硶寰楀埌
涔熷彲浠ョ敤鏁版嵁搴撴彁渚汿O_DATE鍑芥暟
姣斿 鐜版湁 ud
TO_DATE(new SimpleDateFormat().format(ud,"yyyy-MM-dd HH:mm:ss"),
"YYYY-MM-DD HH24:MI:SS")
娉ㄦ剰java涓〃紺烘牸寮忓拰鏁版嵁搴撴彁渚涚殑鏍煎紡鐨勪笉鍚?br />
涓涓疄闄呯殑渚嬪瓙
sql="update tablename set timer=to_date('"+t+"','yyyymmddhh24miss') where ....."
榪欓噷鐨則涓哄彉閲忎負(fù)綾諱技:20051211131223
錛撱佸浣曞皢"yyyy-mm-dd"鏍煎紡鐨勫瓧絎︿覆杞崲涓簀ava.sql.Date
鏂規(guī)硶錛?/p>
SimpleDateFormat bartDateFormat =
new SimpleDateFormat("yyyy-MM-dd");
String dateStringToParse = "2007-7-12";
try {
java.util.Date date = bartDateFormat.parse(dateStringToParse);
java.sql.Date sqlDate = new java.sql.Date(date.getTime());
System.out.println(sqlDate.getTime());
}
catch (Exception ex) {
System.out.println(ex.getMessage());
}
------------------------------------------------------------
鏂規(guī)硶錛?br />
String strDate = "2002-08-09";
StringTokenizer st = new StringTokenizer(strDate, "-");
java.sql.Date date = new java.sql.Date(Integer.parseInt(st.nextToken()),
Integer.parseInt(st.nextToken()),
Integer.parseInt(st.nextToken()));
浣嗘槸涓轟粈涔坖ava.sql.Date綾誨瀷鐨勫兼彃鍏ュ埌鏁版嵁搴撲腑Date瀛楁涓細(xì)鍙戠敓鏁版嵁鎴彇鍛紵
java.sql.Date鏄負(fù)浜?jiǎn)閰嶅悎SQL DATE鑰岃緗殑鏁版嵁綾誨瀷銆?#8220;瑙勮寖鍖?#8221;鐨刯ava.sql.Date鍙寘鍚勾鏈堟棩淇℃伅錛屾椂鍒嗙姣閮戒細(xì)娓呴浂銆傛牸寮忕被浼鹼細(xì)YYYY-MM-DD銆傚綋鎴戜滑璋冪敤ResultSet鐨刧etDate()鏂規(guī)硶鏉ヨ幏寰楄繑鍥炲兼椂錛宩ava紼嬪簭浼?xì)鍙傜?瑙勮寖"鐨刯ava.sql.Date鏉ユ牸寮忓寲鏁版嵁搴撲腑鐨勬暟鍊箋傚洜姝わ紝濡傛灉鏁版嵁搴撲腑瀛樺湪鐨勯潪瑙勮寖鍖栭儴鍒嗙殑淇℃伅灝嗕細(xì)琚姭鍙栥?/div>
Retrieves the of the designated column in the current row of this <code>ResultSet</code> object as a “java.sql.Date” object in the Java programming language.
鍚岀悊銆傚鏋滄垜浠妸涓涓猨ava.sql.Date鍊奸氳繃PrepareStatement鐨剆etDate鏂規(guī)硶瀛樺叆鏁版嵁搴撴椂錛宩ava紼嬪簭浼?xì)瀵逛紶鍏ョ殑java.sql.Date瑙勮寖鍖栵紝闈炶鑼冨寲鐨勯儴鍒嗗皢浼?xì)琚姭鍙栥傜劧鑰岋紝鎴戜滑java.sql.Date涓鑸敱java.util.Date杞崲榪囨潵錛屽錛歫ava.sql.Date sqlDate=new java.sql.Date(new java.util.Date().getTime()).
鏄劇劧錛岃繖鏍瘋漿鎹㈣繃鏉ョ殑java.sql.Date寰寰涓嶆槸涓涓鑼冪殑java.sql.Date.瑕佷繚瀛榡ava.util.Date鐨勭簿紜鹼紝
鎴戜滑闇瑕佸埄鐢╦ava.sql.Timestamp.
Calendar calendar=Calendar.getInstance();
//鑾峰緱褰撳墠鏃墮棿錛屽０鏄庢椂闂村彉閲?nbsp;
int year=calendar.get(Calendar.YEAR);
//寰楀埌騫?br /> int month=calendar.get(Calendar.MONTH);
//寰楀埌鏈堬紝浣嗘槸錛屾湀浠借鍔犱笂1
month=month+1;
int date=calendar.get(Calendar.DATE);
//鑾峰緱鏃ユ湡
String today=""+year+"-"+month+"-"+date+"";
]]>
鐢↗DBC API鏃舵渶浠や漢璁ㄥ帉鐨勫氨鏄紓甯稿鐞嗭紝涔熷緢鐑?chǔ)鐞愬Q岃屼笖寰堝鏄撳嚭閿欙紝鏈漢鏇捐冭檻榪囧埄鐢ㄦā鏉胯繘琛屽鐞嗭紝鍚庢潵鐪嬪埌浜?jiǎn)dbutils錛屼箣鍚庡氨閲囩敤閭ｄ釜dbutils錛岄噰鐢ㄦā鏉跨殑鏂瑰紡鍚勪綅鏈嬪弸鍙互鍙傝僑pring錛孲pring鐨凧dbcTemplate涓嶇伒媧昏屽己澶э紝鍛靛懙錛岃鍙ラ棽璇濓紝瀹炲湪澶僵鏈峈od Johnson浜?jiǎn)锛孯od Johnson鐪熺殑寰堜護(hù)浜哄皧鏁?br /> Dbutils鐨凲ueryRunner鎶婂ぇ澶氭暟涓庡叧闂祫婧愮浉鍏崇殑灝佽璧鋒潵錛屽彟澶栵紝浣犱篃鍙互浣跨敤DbUtils榪涜鍏抽棴錛屽綋鐒禗bUtils鎻愪緵鐨勫姛鑳藉綋鐒朵笉姝㈣繖浜涳紝瀹冩彁榪囦簡(jiǎn)鍑犱釜甯哥敤鐨勯潤(rùn)鎬佹柟娉曪紝闄や簡(jiǎn)涓婅堪鐨勫叧闂祫婧愬錛孌bUtils. commitAndClose(Connection conn)榪樻彁渚涗簨鍔℃彁鍙?qiáng)绛夋搷浣溿?br /> 榪樻槸浠ヤ竴涓緥瀛愭潵璇磋鍚э紝姣曠珶鎴戜笉鏄悶涓氬姟鐨勶紝灝忓槾宸村惂鍡掑惂鍝掍笉璧鋒潵鍟婏紝鍛靛懙銆?br /> 涓轟簡(jiǎn)鍜岄噰鐢˙eanutils鏇村ソ鐨勮繘琛屽姣旓紝榪欎釜渚嬪瓙榪樻槸瀹炵幇鍚屾牱鐨勫姛鑳斤紝鏁版嵁搴撳悓鏍烽噰鐢ㄥ墠涓綃囨枃绔犱腑鎻愬埌鐨刾ublish銆?br /> 鍚屾牱鐨勶紝鐢ㄤ綘鍠滄鐨勭紪杈戝櫒寤虹珛涓涓被DbutilsJDBCTest錛岀ず渚嬩唬鐮佸涓嬫墍紺?
package cn.qtone.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.MapListHandler;
public class DbutilsJDBCTest{
public static void main(String[] args) {
Connection conn = null;
String jdbcURL = "jdbc:mysql://127.0.0.1:3306/publish?useUnicode=true&characterEncoding=GBK";
String jdbcDriver = "com.mysql.jdbc.Driver";
try {
DbUtils.loadDriver(jdbcDriver);
// Username "root". Password "root"
conn = DriverManager.getConnection(jdbcURL, "root", "root");
QueryRunner qRunner = new QueryRunner();
System.out.println("***Using MapListHandler***");
//浠ヤ笅閮ㄥ垎浠ｇ爜閲囩敤Map瀛樺偍鏂瑰紡錛屽彲浠ラ噰鐢˙ean鐨勬柟寮忎唬鏇胯繘琛屽鐞?br /> List lMap = (List) qRunner.query(conn,
"select title,authors from books", new MapListHandler());
//浠ヤ笅鏄鐞嗕唬鐮侊紝鍙互鎶藉彇鍑烘潵
System.out.println("title ------------- authors ");
for (int i = 0; i < lMap.size(); i++) {
Map vals = (Map) lMap.get(i);
System.out.println(vals.get("title")+"-------------"+ vals.get("authors"));
}
} catch (SQLException ex) {
ex.printStackTrace();
} finally {
DbUtils.closeQuietly(conn);
}
}
}
鎬庝箞鏍?鏄笉鏄瘮閲囩敤Beanutils鐨凴esultSetDynaTrial鍜孯owSetDynaClass濂藉浜?jiǎn)锛熼噰鐢˙eanutils浠や漢闅劇紶鐨勬槸鍏抽棴閭ｄ簺璧勬簮浠ュ強(qiáng)澶勭悊閭ｄ簺寮傚父錛岃岃繖閲岄噰鐢―butils鏄劇劧浠ｇ爜閲忓噺灝戜簡(jiǎn)寰堝銆?br /> 涓婁緥鍦ㄥ鐞嗙粨鏋滈泦鏃訛紝瀹冩妸鏁版嵁搴撲腑鐨勬瘡涓琛屾槧灝勬垚涓涓狹ap錛屽叾涓垪鍚嶄綔涓篕ey錛岃鍒楀搴旂殑鍊間綔涓篤alue瀛樻斁錛屾煡璇㈢殑鎵鏈夌殑鏁版嵁涓璧鋒斁鍦ㄤ竴涓狶ist閲岋紝鐒跺悗榪涜澶勭悊錛屽綋鐒?dòng)灱屼竴涓洿鏄庢櫤鐨勫鐞嗘槸鐩存帴榪斿洖List鐒跺悗鍐嶅崟鐙繘琛屽鐞嗐?br /> 浜嬪疄涓婁笂渚嬭繑鍥炵殑緇撴灉闆嗕腑鐨勬瘡涓琛屼笉蹇呮斁鍦ㄤ竴涓狹ap閲岋紝浣犲彲浠ユ斁鍦ㄤ竴涓狟ean閲岋紝褰撶劧濡傛灉浣犵湡鐨勫緢鎳掞紝浣犱篃鍙互浣跨敤Beanutils鐨凩azyDynaClass鍜孡azyDynaBean錛屼笉榪囦篃璁告病鏈夊繀瑕侀偅涔堝仛錛岃嚦浜庡師鍥犺鐪嬩笅鏂囥?br />
濡傛灉浣跨敤Bean鑰屼笉鏄敤Map錛岄偅涔堬紝浣犱篃璁?dāng)R渶瑕佸緩绔嬩竴涓狟ean錛屽涓嬶細(xì)
package cn.qtone.test;
public class Book {
public int id;
public String title;
public String authors ;
public StudentBean() {
}
public String getAuthors() {
return authors;
}
public void setAuthors(String authors) {
this.authors = authors;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
}
鐒跺悗綆鍗曚慨鏀逛竴涓婦butilsJDBCTest 涓殑閮ㄥ垎浠ｇ爜鍗沖彲錛屼唬鏇夸箣鍚庣殑婧愪唬鐮佸涓嬶細(xì)
package cn.qtone.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
public class DbutilsJDBCTest{
public static void main(String[] args) {
Connection conn = null;
String jdbcURL = "jdbc:mysql://127.0.0.1:3306/publish?useUnicode=true&characterEncoding=GBK";
String jdbcDriver = "com.mysql.jdbc.Driver";
try {
DbUtils.loadDriver(jdbcDriver);
// Username "root". Password "root"
conn = DriverManager.getConnection(jdbcURL, "root", "root");
QueryRunner qRunner = new QueryRunner();
System.out.println("***Using BeanListHandler ***");
//浠ヤ笅閮ㄥ垎浠ｇ爜閲囩敤Map瀛樺偍鏂瑰紡錛屽彲浠ラ噰鐢˙ean鐨勬柟寮忎唬鏇胯繘琛屽鐞?br /> List lBeans = (List) qRunner.query(conn," select title,authors from books ", new BeanListHandler(Book.class));
//浠ヤ笅鏄鐞嗕唬鐮侊紝鍙互鎶藉彇鍑烘潵
System.out.println("title ------------- authors ");
for (int i = 0; i < lBeans.size(); i++) {
Book vals = (Book) lBeans.get(i);
System.out.println(vals.getTitle ()+"-------------"+ vals. getAuthors ());
}
} catch (SQLException ex) {
ex.printStackTrace();
} finally {
DbUtils.closeQuietly(conn);
}
}
}
榪欎袱縐嶆硶杈撳嚭鐨勭粨鏋滃簲璇ユ槸涓鏍風(fēng)殑銆備袱縐嶅鐞嗘柟寮忛兘宸笉澶氾紝浣嗘垜鏇存効鎰忛噰鐢ㄧ涓縐嶏紝鍥犱負(fù)絎竴縐嶅皯鍐欎竴涓猙ean錛岃屼笖鎴戞祴璇曡繃閲囩敤Map鐨勬柟寮忓嵆絎竴縐嶆柟寮忔ц兘瑕佸ソ鐨勫錛岄噰鐢˙ean鎬ц兘姣旇緝浣庡彲鑳芥槸鍥犱負(fù)閲囩敤鍙嶅皠鐨勭紭鏁咃紝閲囩敤鍙嶅皠鐨勪笢涓滄ц兘鍜屼笉閲囩敤鍙嶅皠鐨勮繕鏄湁鐐瑰樊璺濄備篃鏄繖涓師鍥狅紝涓嶆帹鑽愰噰鐢↙azyDynaClass鍜孡azyDynaBean錛屽洜涓洪噰鐢ㄨ繖浜岃呮槸鍦ㄨ繍琛屾湡鍔ㄦ佸垱寤築ean綾誨拰Bean灞炴э紝鐒跺悗鍐嶅垱寤築ean瀵硅薄鐨勶紝鍏舵ц兘鍙兂鑰岀煡浜?jiǎn)锛堜笉杩囨垜娌℃湁娴嬭瘯杩囧晩锛屾墍浠ユ垜璇磋繖涓瘽鍙鏄病鏈夋牴鎹殑錛屾劅鍏磋叮鐨勬湅鍙嬭嚜宸辨祴璇曚竴涓嬶紝璁板緱鍛婅瘔鎴戠粨鏋滃摝錛屽懙鍛碉級(jí)錛岄櫎浜?jiǎn)MapListHandler浠ュ強(qiáng)BeanListHandler涔嬪錛孌Butils榪樻彁渚涗簡(jiǎn)鍏朵粬鐨凥andler錛屽鏋滆繖浜涗笉鑳芥弧瓚充綘鐨勯渶姹傦紝浣犱篃鍙互鑷繁瀹炵幇涓涓狧andler銆?br /> 鏈鍚庯紝涔熸槸鏈澶х殑浣撲細(xì),涔熻鏄渶澶х殑鏀惰幏鍚э紝閭ｅ氨鏄?瀵逛簬姣忎竴涓」鐩?鍦ㄦ牴鎹瘡涓涓渶姹傝幏鍙栫浉搴旇В鍐蟲(chóng)柟妗堟椂,鍏堝鎵懼紑婧愮粍浠?鐪嬫槸鍚﹀凡緇忔湁婊¤凍鏌愪簺鍔熻兘闇姹傜殑寮婧愮粍浠?濡傛灉娌℃湁,鍐嶈冭檻鑷富寮鍙戞垨鑰呭悜絎笁鏂硅喘涔幫紝鍚﹀垯灝介噺閲囩敤寮婧愮粍浠?
璇峰敖閲忎韓鐢ㄥ紑婧愮殑欖呭姏錛屽敖鎯呯殑鎷ユ姳寮婧愬惂銆?br />
]]>
鍏朵竴:瀵規(guī)暟鎹簱涓殑鍘熻〃榪涜姣忓ぉ鐨勫浠?
鍏朵簩:閫氳繃瀵規(guī)渶鏂扮殑澶囦喚琛ㄨ繘琛屽彇鍊兼搷浣?閫氳繃鍒ゆ柇,鍚戝師琛ㄤ腑鎻掑叆鏁版嵁.
鍏跺疄榪欎袱涓瓨鍌ㄨ繃紼嬩篃娌℃湁浠涔堥毦鐨?涓鏂歸潰鎴戞槸榪欐柟闈㈢殑鏂版墜,鍙︿竴鏂歸潰瑕佹搷浣滀竴涓復(fù)鏃惰〃,鑰屼笖瑕佷粠涓彇寰楁暟鎹?娌℃湁浼犲叆鍊?,鎴戝湪緗戜笂鎵句簡(jiǎn)涓涓?娌℃湁浠涔堟垚鍔熺殑渚嬪瓙,鎵浠?鎶婃垜榪欎袱澶╃殑鎴愭灉鏅掍竴涓?
鍏堣鍑犱釜鍏抽敭璇?鎴戠敤鐨勬椂鍊?娌″皯涓鴻繖鍑犱釜璇嶈垂鑴戝瓙)
1. execute Immediate,涓涓墽琛屽姩鎬丼QL鐨勪笢涓?鍦ㄦ瘡澶╃敓鎴愬浠借〃鏃?绔嬩笅浜?jiǎn)姹夐┈鍔熷?鎴戠殑琛ㄥ悕涓?鍘熻〃鍚?yyyymmdd
2. creat table 琛ㄥ悕 as select * from 宸叉湁琛?榪欐槸涓涓垱寤鴻〃,鎴戣涓烘渶蹇殑涓縐嶆柟娉?鍦ㄥ垱寤鴻〃鐨勫悓鏃?涔熷彲浠ョ洿鎺ユ妸宸叉湁琛ㄤ腑鐨勬暟鎹篃涓璧穋opy榪囨潵,鍛靛懙,寰堟槸紲炲
3. sys_refcursor,榪欐槸涓涓猚ursor,寰堟紓鐨勪竴涓猚ursor,鑳藉鐢熸垚鍔ㄦ佺殑cursor,鍙互澶氱敤涓浜?
涓嬮潰鎴戝啓鐨勫瓨鍌ㄨ繃紼?涓昏鍦頒笟鍔￠昏緫鍘繪帀浜?涓昏璇翠竴涓嬭繃紼?o:p>
1. 姣忓ぉ鐢熸垚琛ㄥ浠界殑瀛樺偍榪囩▼
create or replace procedure P_HOLD_COPY Is
--姣忓ぉ緇撶畻鏃?涓哄綋澶╃殑鎸佽偂鍋氬浠?br>--寰楀埌琛ㄥ悕涓哄師琛ㄥ悕+yyyymmdd鐨勬牸寮?br>table_name Varchar2(20) := 'test'||To_char(Sysdate,'yyyymmdd');
Begin
execute Immediate 'Create Table '||table_name||' As Select * From T_STOC_HOLD';
Commit;
end P_HOLD_COPY;
2. 浠庡浠借〃涓彇寰楁暟鎹?鐒跺悗鏍規(guī)嵁鏁版嵁,瀵瑰師琛ㄨ繘琛屾搷浣?/p>
create or replace procedure P__SHARE is
--******************************************************************
--瀛樺偍榪囩▼鍚嶇О錛歅_SHARE
--鍔熻兘鎻忚堪錛氬澶囦喚琛ㄨ繘琛屾暟鎹搷浣?br>--******************************************************************
balance Number;
totalmoney Number;
h_amount Number;
allot_stock Number;
allot_money Number;
str Varchar2(1);
v_product_oid Varchar2(32);
table_name Varchar2(20);
sqlstr Varchar2(1000);
v_allot_row t_stoc_allot%rowtype;
v_hold_row t_stoc_hold%rowtype;
Cursor c_allot is select * from t_stoc_allot where to_char(t_stoc_allot.regdate,'yymmdd') < to_char(sysdate+1,'yymmdd') And (t_stoc_allot.is_allot Is Null Or t_stoc_allot.is_allot='1');
c_hold sys_refcursor ;
Begin
open c_allot;
loop
fetch c_allot into v_allot_row;
table_name := 'T_STOC_HOLD'||To_char(v_allot_row.regdate,'yyyymmdd');
v_product_oid := v_allot_row.product_oid;
sqlstr := 'select * from '||table_name||' where stock_code='||v_product_oid;
exit when c_allot%NOTFOUND;
open c_hold For sqlstr ;
loop
fetch c_hold into v_hold_row;
exit when c_hold%NOTFOUND;
end loop;
close c_hold;
end loop;
close c_allot;
Commit;
end P_SHARE;
涓涓猅imerTask瀹為檯涓婂氨鏄竴涓嫢鏈塺un鏂規(guī)硶鐨勭被錛岄渶瑕佸畾鏃舵墽琛岀殑浠ｇ爜鏀懼埌run鏂規(guī)硶浣撳唴錛孴imerTask涓鑸槸浠ュ尶鍚嶇被鐨勬柟寮忓垱寤恒?
涓涓畬鏁寸殑Timer錛?
java.util.Timer timer = new java.util.Timer(true);
// true 璇存槑榪欎釜timer浠aemon鏂瑰紡榪愯錛堜紭鍏堢駭浣庯紝
// 紼嬪簭緇撴潫timer涔熻嚜鍔ㄧ粨鏉燂級(jí)錛屾敞鎰忥紝javax.swing
// 鍖呬腑涔熸湁涓涓猅imer綾伙紝濡傛灉import涓敤鍒皊wing鍖咃紝
// 瑕佹敞鎰忓悕瀛楃殑鍐茬獊銆?
TimerTask task = new TimerTask() {
public void run() {
... //姣忔闇瑕佹墽琛岀殑浠ｇ爜鏀懼埌榪欓噷闈€?
}
};
//浠ヤ笅鏄嚑縐嶈皟搴ask鐨勬柟娉曪細(xì)
timer.schedule(task, time);
// time涓篋ate綾誨瀷錛氬湪鎸囧畾鏃墮棿鎵ц涓嬈°?
timer.schedule(task, firstTime, period);
// firstTime涓篋ate綾誨瀷,period涓簂ong
// 浠巉irstTime鏃跺埢寮濮嬶紝姣忛殧period姣鎵ц涓嬈°?
timer.schedule(task, delay)
// delay 涓簂ong綾誨瀷錛氫粠鐜板湪璧瘋繃delay姣鎵ц涓嬈?
timer.schedule(task, delay, period)
// delay涓簂ong,period涓簂ong錛氫粠鐜板湪璧瘋繃delay姣浠ュ悗錛屾瘡闅攑eriod
// 姣鎵ц涓嬈°?nbsp;
涓嬮潰鏄竴涓畬鏁寸殑渚嬪瓙,鐢變袱涓被緇勬垚,涓涓畾鍒朵換鍔?涓涓皟鐢╦ava.util.Timer
瀹氬埗浠誨姟:
import java.util.Timer;
public class TimerTaskTest extends java.util.TimerTask{
@Override
public void run() {
// TODO Auto-generated method stub
System.out.println("start");
}
}
2.璋冪敤java.util.Timer
import java.util.Timer;
public class Test {
public static void main(String[] args){
Timer timer = new Timer();
timer.schedule(new TimerTaskTest(), 1000, 2000);
try{
Thread.sleep(1000);
}catch(Exception ex){
timer.cancel();
}
}
}
鏍規(guī)嵁涓婇潰鐨勪粙緇?渚垮彲浠ュ湪1縐掑悗,姣忛殧2縐掓墽琛屼竴嬈＄▼搴?br>寤鴻:鍦ㄤ嬌鐢═imer timer = new Timer()鏃?涓嶈鐢═imer timer = new Timer(true).鍥犱負(fù)榪欐牱,鍦ㄧ▼搴忕粨鏉熷悗,timer涔熻嚜鍔ㄧ粨鏉熶簡(jiǎn),涓嶅埄浜庝嬌鐢?br>
]]>
榪欎釜鏂規(guī)硶搴旇鏄渶甯哥敤鐨勶紝涓嶈繃榪欎釜鏂規(guī)硶闇瑕佹墜宸ュ惎鍔ㄤ綘鐨勪換鍔★細(xì)
Timer timer=new Timer();
timer.schedule(new ListByDayTimerTask(),10000,86400000);
榪欓噷鐨凩istByDayTimerTask綾誨繀欏籩xtends TimerTask閲岄潰鐨剅un()鏂規(guī)硶銆?/p>
2錛塖ervletContextListener
榪欎釜鏂規(guī)硶鍦╳eb瀹瑰櫒鐜姣旇緝鏂逛究錛岃繖鏍鳳紝鍦╳eb server鍚姩鍚庡氨鍙互
鑷姩榪愯璇ヤ換鍔★紝涓嶉渶瑕佹墜宸ユ搷浣溿?br>灝哃istByDayListener implements ServletContextListener鎺ュ彛錛屽湪
contextInitialized鏂規(guī)硶涓姞鍏ュ惎鍔═imer鐨勪唬鐮侊紝鍦╟ontextDestroyed
鏂規(guī)硶涓姞鍏ancel璇imer鐨勪唬鐮侊紱鐒跺悗鍦╳eb.xml涓紝鍔犲叆listener:
<listener>
<listener-class>com.qq.customer.ListByDayListener</listener-class>
</listener>
3)org.springframework.scheduling.timer.ScheduledTimerTask
濡傛灉浣犵敤spring錛岄偅涔堜綘涓嶉渶瑕佸啓Timer綾諱簡(jiǎn)錛屽湪schedulingContext-timer
.xml涓姞鍏ヤ笅闈㈢殑鍐呭灝卞彲浠ヤ簡(jiǎn)錛?br><?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="timer" class="org.springframework.scheduling.timer.TimerFactoryBean">
<property name="scheduledTimerTasks">
<list>
<ref local="MyTimeTask1"/>
</list>
</property>
</bean>
<bean id="MyTimeTask" class="com.qq.timer.ListByDayTimerTask"/>
<bean id="MyTimeTask1" class="org.springframework.scheduling.timer.ScheduledTimerTask">
<property name="timerTask">
<ref bean="MyTimeTask"/>
</property>
<property name="delay">
<value>10000</value>
</property>
<property name="period">
<value>86400000</value>
</property>
</bean>
</beans>
]]>