java ±¸·ÝºÍ»Ö¸´PostgreSQLÊý¾Ý¿â - Java / Web ¿ª·¢
Êý¾Ý¿â·þÎñÆ÷192.168.0.123
Óû§Ãû£ºpostgres
ÃÜÂ룺postgres
Êý¾Ý¿âÃû£ºmydb
web³ÌÐò£¬ÔÚÍøÒ³Éϱ¸·Ý·þÎñÆ÷ÉϵÄÊý¾Ý¸ÃÔõôд£¿
²é×ÊÁÏ´ó¶à˵ÓÃpg_dumpдbatÎļþÀ´ÓÃjavaÖ´ÐС£µ«ÊDZ¸·ÝÔ¶³Ì·þÎñÆ÷µÄÊý¾Ý¿â¸ÃÈçºÎʵÏÖ£¿
ÎÒµ¥¶ÀдÁËbatÎļþ±¸·Ý±¾»úµÄÊý¾Ý¾Ö£¬·Åµ½×ÀÃæÉÏÖ´Ðгɹ¦£¬Ð´ÔÚjava³ÌÐòÖÐÍøÒ³ÔËÐÐÈ´²»ÐУ¡
bakup.batÎļþÄÚÈÝ
cd C:\Program Files\PostgreSQL\8.2\bin\
CLS
pg_dump -h 127.0.0.1 -U postgres -p 5432 -D test > d:\temp\mydb.sql
pause
javaµÄaction
Java code:
public String addDBbak() throws Exception {
//Êý¾Ý¿â±¸·Ý
BufferedWriter mBufWriter = null;
//½¨Á¢Ò»¸öBackupDb.batÎļþ
FileWriter fileWriter = new FileWriter("BackupDb.bat");
mBufWriter = new BufferedWriter(fileWriter);
/*
* °ÑÊý¾Ý¿â±¸·Ý·½·¨Ð´ÈëBackupDb.batÎļþÖС£
* BackupDbUrl ÊÇÊý¾Ý¿â±¸·ÝÃüÁî¡£
* pg_dump.exe -U postgres -E utf8 test ±¸·ÝÊý¾Ý¿âÃüÁî¡£
* —U postgres Êý¾Ý¿âÓû§Ãû -E utf8 É趨×Ö·û±àÂë¸ñʽ¡£test Êý¾Ý¿âÃû
* BackupDbName ±¸·ÝÎļþËù´æÄ¿Â¼ºÍÃû³Æ£¬ÎÒÊÇÒÔ±¸·Ýʱ¼äÃüÃû¡£
*/
String BackupDbUrl="c:\\Program Files\\PostgreSQL\\8.2\\bin\\pg_dump -h 127.0.0.1 -p 5432 -U postgres -W postgres -E utf-8 -d mydb>&
Ïà¹ØÎÊ´ð£º
ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾÌá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......
´ó¼ÒºÃ£¬ÎÒÏÖÔÚÓÐÒ»¸öÓÃaspдµÄÁÄÌìÊÒ£¬ÏÖÔÚµÄÏëÌí¼ÓÒ»¸ö¹¦ÄÜ£¬¾ÍÊǵ±ÓÐÈËÉÏÏßµÄʱºò£¬·¢³öÌáʾ£¬±ÈÈçÉùÒôÏìһϣ¬ÏÖÔÚÏëÓÃjavaʵÏÖÕâ¸ö¹¦ÄÜ£¬ÇëÎÊ´ó¼ÒÔõôʵÏÖ£¿
ллÁË£¬ÎÒ»á¼Ó·ÖµÄ
aspºÍjavaÕûºÏµ½Ò»ÆðÈ¥£¿ºÎ±Ø ......
ÎÒдÁ˸öjspÒ³Ãæ£¬È»ºó¸Ä¶¯ÁËһϣ¬¸Ä¶¯µÄÄÚÈݾÍÊÇÔÚjspÒ³ÃæµÄjsº¯ÊýÀï¼ÓÁ˸öalert()Óï¾ä£¬µ«ÊÇÎÒ·ÃÎÊÕâ¸öÒ³ÃæÊ±£¬ËÀ»î¶¼ÊÇÔÀ´Ò³ÃæµÄÄÚÈÝ£¬ÎÒ¼ÓÁ˺ܶàalertº¯Êý»¹ÊÇû¸Ä¶¯Ç°µÄÒ³ÃæÄÚÈÝ£»tomcatÖØÆôÁË£¬Ò²ÖØÐ²¿ÊðÕâ ......
ÈçÌâ¡£¡£
ÏÖÔÚСµÜ ¸Õ¸Õ½Ó´¥ flex ÏëÕÒÒ»¸ö ¾ßÌåµÄÀý×Ó £¨Èç µÇ½ ×¢²áµÄ ¹¦ÄÜʵÏÖ £©¡£¡£
java ºÍ flex ͨÐŵÄ
ÅäÖÃÎļþ java ´úÂë flex ǰ̨ AS ½Å±¾ ×îºÃ ¶¼ дÉÏÈ¥¡£¡£¡£¡£
СµÜ ÏîÑо¿Ñо¿¡£¡£¡£ ......
ÓÃStruts2+Spring+Hibernate×öµÄÒ»¸öwebµÄERPСÏîÄ¿£¬×ܲ¿Ò»Ì¨·þÎñÆ÷£¨Êý¾Ý¿âÓëWeb·þÎñÆ÷ÔÚͬһ»ú×ÓÉÏ£©Êǵ¥¶À²¦ºÅÉÏÍøµÄ£¬Óë·Ö¹«Ë¾Ã»ÓÐÓþÖÓòÍøÏߣ¬Ó²¼þÌ«¹óÁË£¬ÆäËû¼¸¸öÊ¡Êзֹ«Ë¾¶¼À´·ÃÎÊÕâÒ»·þÎñÆ÷£¬¸Ð¾õºǫ́´ú ......