ÔõÑùÓÃjavaдһ¶Î±¸·ÝMySQLÊý¾Ý¿âµÄ´úÂ룬Çë¸ßÊÖÖ¸µã
ÈçÌâ
ÓÃmysqldumpÃüÁ²»ÒªÓÃjavaд£¬µÈÄãдÍ꣬ÎÒÒѾ±¸·ÝÁË´ó°ë¸öÔµÄÀúÊ·Êý¾Ý¡£
jspÒ³ÃæÒªÕâ¸ö¹¦ÄÜ
µÚÒ»ÖÖ¿ÉÄÜ£¬ÄãµÄÃèÊö´íÎó£¬ÄǸö²»ÊÇÊý¾Ý±¸·Ý£¬¶øÊÇÊý¾Ýµ¼³ö£¬Õâ¸öÊÇ×î³£¼ûµÄ¹¦ÄÜ£¬Èç¹ûÖ»ÊÇtableÐÎʽ£¬Î޷ǾÍÊÇÑ»·¡£ÍøÉÏÀý×ÓÒ»´ó¶Ñ
µÚ¶þÖÖ¿ÉÄÜ£¬ÄãµÄÉè¼ÆÎÊÌ⣬±¸·Ý±È½ÏºÄ×ÊÔ´¡¢Ê±¼ä£¬Èç¹û»»ÎÒ£¬¾ø²»»á¿ª·¢ÕâÑùÒ»¸ö¹¦ÄÜ¡£µ½Ê±ºò£¬Êý¾ÝÁ¿´ó£¬´ó¼ÒÒ»Æðµã£¬È»ºóÒ»ÆðÇì×£·þÎñÆ÷±ÀÀ£¡£
Ϊʲô»áÉè¼Æ³ÉÕâÑùÎÒÒ²²»ÊǺÜÇå³þ£¬
Runtime.getRuntime().exec("mysqldump --set-charset=utf8 Êý¾Ý¿âÃû "+±íÃû --user=root --password= ");
ÒªÓÃÕâÑùµÄ´úÂë½øÐб¸·Ý£¬µ«ÊÇÌáʾjava.io.IOException: CreateProcess: mysqldump --set-charset=utf8 da table --user=root --password= error=2
¸ßÊÖÖ¸µãÒ»ÏÂÁË
PATHÎÊÌ⣿
ÊÇ·¾¶²»¶Ô£¬µ«ÊÇÓõÄÊÇÍâÍøµÄ·þÎñÆ÷£¬Ôõô֪µÀËûÓÐûÓа²×°MySQL£¬ÓÖÔõôÄÜÖªµÀmysqlµÄÔËÐз¾¶£¬ËùÒÔÕâÖÖ±¸·ÝÄÜʵÏÖÂð£¿
ÒªÊDz»ÖªµÀÊý¾Ý¿âµÄ·¾¶Ó¦¸Ãû°ì·¨ÊµÏÖ±¸·ÝµÄ£¬ÒªÊÇÂ¥Ö÷¿ÉÒÔÄõ½MysqlÅäÖÃÒ²¿ÉÒÔÕÒÒ»ÏÂMysql°²×°Â·¾¶¡£
Äã¿ÉÒÔ°ÑÕâ¸öÎÊÌâ½»¸øÌá³öÕâ¸öÐèÇóµÄÈË¡£Èç¹ûÊǿͻ§£¬¿ÉÒÔÏë°ì·¨Òýµ¼ËûÃÇÓøüºÏÀí¡¢¸ü¼ò±ãµÄ½â¾ö·½°¸
¼ÌÐøÑо¿
н¨Ò»¸öJavaÀà ÔÚÀïÃæÐ´Ò»¸ö±¸·Ý·½·¨ ÓÃioÁ÷д½øµ½Ä¿±êÎļþ¾ÍokÁË
½ö¹©²Î¿¼
public static void main(String[] args) {
Ïà¹ØÎÊ´ð£º
ÎÊÌâÃèÊö£ºÐ´ÈÕÖ¾¹¦ÄÜ£¬Ð´ºÃµÄдÈÕÖ¾·þÎñ£¬ÆäËûÓû§Í¨¹ýhttpµ÷Ó÷þÎñ£¬´«Èë²ÎÊý£¬È»ºó¼Ç¼ÈÕÖ¾£¬
ÎҵķþÎñ¸ÃÔõôд£¬ ±ðÈËÔõôͨ¹ýhttpµ÷ÓÃÎҵķþÎñ£¬ÎÒÓÃwebserviceдºÃÁËÒ»¸ö£¬¿ÉÊDz¢·¢ÓÐÉÏÏߣ¬Ïë¸ÄÓ ......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......