javaµ÷ÓÃbatÎļþµÄÐÔÄÜÎÊÌâ
ÓÃjavaµ÷ÓÃÒ»¸öbatÎļþ
process = Runtime.getRuntime().exec("f:/insert.bat");
batÊÇһЩÊý¾ÝµÄinsert²Ù×÷£¬Ê¹ÓÃsqlplus
Ö±½ÓÔËÐÐbatµÄʱºò£¬Ò²¾Í2·ÖÖÓ¾ÍÍêÊÂÁË
µ«ÊÇÓÃjavaµ÷ÓÃÐèÒª30·ÖÖÓ
Êý¾ÝÁ¿±È½Ï´ó£¬´ó¸ÅÓм¸Ç§ÌõÊý¾Ý°É
ÄÄλ´óϺ֪µÀÈçºÎ¸ÄÉÆÕâ¸öЧÂʰ¢
ʵÔÚÊDzîµÄÌ«¶àÁË
ллÁËÏÈ
ÔÙ¸ø´ó¼Ò°Ý¸öÍíÄê
javaµÄruntimeµ÷ÓÃËÙ¶ÈÊǺÜÂýµÄ
²»ÄܰÑÎļþ¶Á½øÀ´£¬ÓÃjdbc²Ù×÷Âð£¿
Õâ¸öÎÊÌâÓеãÄѶÈ.
°ÑbatÀïÃæµÄechoÊäÈëÊä³ö½»»¥É¾³ýÊÔÊÔ¿´.
???????..........................
º¹£¬jaVAÖÐÄÜÔËÐпÉÖ´ÐÐÎļþÂ𣿣¿
Â¥Éϵģ¬Â¥Ö÷´úÂë¶¼¸øÁË£¬¿ÉÒÔÖ´Ðеġ£
batÊÇ×Ô¶¯Ö´Ðеģ¬Â¥Ö÷µ÷ÓÃÁ˼¸´Îbat£¿
µ÷ÓÃÁ˺ü¸´Î
ÆäËû¼¸¸ö»¹ÐУ¬²Ù×÷Êý¾Ý¿â£¬´´½¨±í¿Õ¼ä£¬Óû§£¬±í
Õâ¸öʱ¼ä»¹¿ÉÒÔ°Ñ
²»¹ýµ½µ¼ÈëÊý¾ÝµÄʱºò£¬ÓÉÓÚÊý¾Ý±È½Ï´ó£¬»¨µÄʱ¼ä¾ÍÌØ±ð¶à
Â¥ÉÏ£¬
ÓÐʲôºÃ°ì·¨Âï
ÐÂÄê¿ìÀÖ£¬»¢Ä꼪ÏéÈçÒ⣡
°ï¶¥
Êý¾ÝÁ¿±È½Ï´ó£¬´ó¸ÅÓм¸Ç§ÌõÊý¾Ý°É
O(¡É_¡É)O¹þ£¡
LZ±¾ßÁË£¬ÕâôµãÊý¾ÝÒ²½Ð´óÂð£¿ÓÃbatch
Ö»µ÷ÓÃÒ»´Îbat£¬
Èç¹ûµ¥¶ÀÔËÐÐÕâ¸öbatÎļþ£¬²»Ê¹ÓÃjavaµ÷Óõϰ£¬1·ÖÖÓ¶àµã¾ÍOkÁË
½á¹ûÓÃjavaµ÷Óþͻ¨ÁËÀ϶àʱ¼äÁË
batµÄÄÚÈÝ£º
sqlplus 1.sql
1.sqlµÄÄÚÈÝ£º
spool 1.log
connect user/password
insert ....
insert ....
spool off
exit
Õâ¸öÊÇÖ±½ÓÔÚDB·þÎñÆ÷ÉÏÖ´ÐеÄ
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
<part name="bstrPnrNO" type="s:string" />
<part name ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......