ÔõÑùÓÃ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) {
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
ÎÒ¶¨ÒåÁËÒ»¸öJRadioButtonNanµÄµ¥Ñ¡°´Å¥£¬Èç¹ûÔÚÎÒÑ¡ÔñÁËÕâ¸ö°´Å¥ºóÏëµã»÷ÖØÖÃÈÃÕâ¸ö°´Å¥´¦ÓÚδѡÔñµÄ״̬¸ÃÔõô×öÄØ£¿Çë¸ßÊÖÖ¸½Ì
jRadioButton.setSelected(false);
²»ÖªµÀÄãÊÇʲôÒâ˼
Õâ¸öÊDz»Ñ¡Ôñ״̬ÁË
Î ......