½«java³ÌÐò°²×°³Éwindows·þÎñ
×î½ü¹¤×÷ÐèÒª½«java³ÌÐò´ò°ü·¢²¼£¬²¢ÇÒÄܰ²×°³Éwindows·þÎñ£¬¶øÇÒÐèÒªÔÚûÓа²×°jreµÄ»úÆ÷ÉÏÔËÐС£Ñо¿ÁËÒ»ÏÂjava service wrapper£¬ÔÚÍøÉÏÕÒÁËÏà¹ØµÄ×ÊÁÏ£¬µ«ÊǶ¼ËµµÃ²»ÊǺÜÏêϸ£¬ÕÕ×Å×öÓÐÒ»¶¨ÄѶȡ£ËùÒÔÎÒ·Ö²½×ܽáÁËһϣ¬Ï£Íû¸øÓöµ½ÏàͬÎÊÌâµÄͬÈÊÒ»µã°ïÖú¡£
1. Ê×ÏÈÏÂÔØjava service wrapper°ü£¬ÎÒÏÂÔØµÄÊÇwrapper-windows-x86-32-3.2.3£¬²¢½âѹ£¬ÕâÀï¼ÙÉè½âѹµ½warpper3.2.3ÎļþÏÂ
2. н¨Ò»¸öÎļþ¼ÐÃüÃûΪtest,ÔÚ´ËÎļþ¼ÐÄÚ½¨Á¢Îå¸öÎļþ¼Ð£¬·Ö±ðÃüÃûbin,logs,application,lib,conf,È»ºó½«jre¸´ÖƵ½testÎļþ¼ÐÄÚ,²¢½«jreÎļþ¼Ð¸ÄÃûΪjre¡£
3. ½«±àÒëºóµÄjava¹¤³ÌÖеÄbinÎļþ¼Ð£¬ºÍlibÎļþ¼Ð£¨Èç¹ûÓõ½Á˵ÚÈý·½jar°üµÄ»°£¬Ã»Óõ½µÄ»°¿ÉÒÔ²»¸´ÖÆlib£©¸´ÖƵ½applicationÎļþ¼ÐÖÐ
4. ½«warpper3.2.3/src/binÏÂÃæµÄApp.bat.in£¬InstallApp-NT.bat.in£¬UninstallApp-NT.bat.inÈý¸öÎļþ¸´ÖƵ½test/binÖУ¬²¢·Ö±ð¸ÄÃû£¬È¥µô“.in”¡£
5. ½«warpper3.2.3/binÏÂÃæµÄWrapper.exe¸´ÖƵ½test/bin
6. ½«warpper3.2.3/confÏÂÃæµÄwrapper.conf¸´ÖƵ½test/conf
7. ½«wrapper3.2.3/libÏÂÃæµÄwrapper.jarºÍwrapper.dll¸´ÖƵ½test/lib
8. Íê³ÉÒÔÉϼ¸²½ºó£¬´ò¿ªtest/conf/wrapper.conf
l ÕÒµ½
# Java Application
wrapper.java.command=java
¸Ä³É
# Java Application
wrapper.java.command=../jre/bin/java
ÕâÀïÊÇÖ¸¶¨jreµÄ·¾¶
l ÕÒµ½
wrapper.java.mainclass=org.tanukisoftware.wrapper.test.Main
¸Ä³É
wrapper.java.mainclass=org.tanukisoftware.wrapper.WrapperSimpleApp
ÕâÀïÊÇÖ¸¶¨wrapperµÄÆô¶¯·½Ê½£¬ÓÃwrapper´úÀíÆô¶¯
l ÕÒµ½
# Initial Java Heap Size (in MB)
#wrapper.java.initmemory=3
# Maximum Java Heap Size (in MB)
#wrapper.java.maxmemory=64
¸Ä³É
# Initial Java Heap Size (in MB)
wrapper.java.initmemory=128
Ïà¹ØÎĵµ£º
Ò» ÎÊÌâµÄÌá³ö
JavaµÄÒ»¸öÖØÒªÓŵã¾ÍÊÇͨ¹ýÀ¬»øÊÕ¼¯Æ÷(Garbage Collection£¬GC)×Ô¶¯¹ÜÀíÄÚ´æµÄ»ØÊÕ£¬³ÌÐòÔ±²»ÐèҪͨ¹ýµ÷Óú¯ÊýÀ´ÊÍ·ÅÄÚ´æ¡£Òò´Ë£¬ºÜ¶à³ÌÐòÔ±ÈÏΪJava²»´æÔÚÄÚ´æÐ¹Â©ÎÊÌ⣬»òÕßÈÏΪ¼´Ê¹ ÓÐÄÚ´æÐ¹Â©Ò²²»ÊdzÌÐòµÄÔðÈΣ¬¶øÊÇGC»òJVMµÄÎÊÌâ¡£Æäʵ£¬ÕâÖÖÏë·¨ÊDz»ÕýÈ·µÄ£¬Òò ......
»·¾³£ºÊý¾Ý¿âsql server2005£¬jdk1.6 £¬myeclipse£¬Çý¶¯jdts1.2.2
Ö´ÐÐÒÔÏ´úÂ룬±¨´í£º
String querySQL = "{?=call p_sys_manager_csReport(?,?,?,?,?)}";
cstmt = conn.prepareCall(querySQL);
cstmt.registerOutParameter(1, java.sql.Types.INTEGER);
cstmt.setInt(2, modType);
cstmt.setInt(3, dptI ......
1¡¢´´½¨ Statement ¶ÔÏó
½¨Á¢Á˵½Ìض¨Êý¾Ý¿âµÄÁ¬½ÓÖ®ºó£¬¾Í¿ÉÓøÃÁ¬½Ó·¢ËÍ SQL Óï¾ä¡£Statement ¶ÔÏóÓà Connection µÄ·½·¨ createStatement ´´½¨£¬ÈçÏÂÁдúÂë¶ÎÖÐËùʾ£º
Connection con = DriverManager.getConnection(url, "sunny", "");
Statement stmt = con.createStatement();
ΪÁËÖ´ÐÐ Statement ¶ÔÏ󣬱»· ......
A:²»´øÊä³ö²ÎÊýµÄ
---------------²»´øÊä³ö²ÎÊýµÄ----------------------------------
create procedure getsum
@n int =0<--´Ë´¦Îª²ÎÊý-->
as
declare @sum int<--¶¨Òå±äÁ¿-->
declare @i int
set @sum=0
set @i=0
while @i<=@n begin
set @sum=@sum+@i
set @i=@i+1
end
print ......