java Á¬½ÓmysqlÒì³££¬ ÇëÎÊÔÒò¡£
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://db.153.com/test","root","bcmedia");
Òì³£·¢ÉúÔÚÕâÒ»¾ä£¬·µ»ØÒì³££º java.sql.SQLException: null, message from server: "#HY000Host '172.16.16.55' is not allowed to connect to this mysql server"
'172.16.16.55' ÊÇÎÒ±¾»úIP. ʲôÔÒò£¿
Ô¶³ÌÁ¬½Ómysql³öµÄ´íÎó°É
ÔÒòÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhostÖеǼ¡£´ËʱֻҪÔÚ localhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"£¨unixΪÀý£©
mysql -u root -pvmwaremysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
linuxÏÂÊÇ·ñºÍunixÒ»Ñù£¿
°ï¶¥..............
Ò»Ñù ÕÕÉÏÃæ²Ù×÷ÊÔÊÔ¿´
ÎÊÌâÒÀÈ»´æÔÚ£¬ÇëÎÊ»¹ÓÐûÓÐÆäËûÔÒò£¿
java.sql.SQLException: null, message from server: "#HY000Host '172.16.16.55' is not allowed to connect to this mysql server"
˵Ã÷ÄãµÄ±¾»úûÓÐȨÏÞÁ¬½Óµ½db.153.com/test
db.153.comÕâÊÇÒ»¸öʲôµØÖ·£¿ ÇëÎÊLZµÃµ½ÊÚȨÁËô£¿
Èç¹ûÊÇÄã±¾»úµÄ»°×îºÃÓÃ127.0.0.1
ÄãÊÔÊÔ
Ó¦¸ÃÊÇȨÏÞÎÊÌâ
ÄãºÃ£¬Â¥Ö÷£¡
Õâ¿Ï¶¨ÊÇÊý¾Ý¿â·ÃÎÊȨÏÞµÄÎÊÌâ¡£
ÊDz»ÊÇÔÚ×°MySql µÄʱºò£¬Ã»ÓÐÉèÖÃMySql µÄ·þÎñ¶ËŶ£¬µ¼ÖÂÎÞ·¨Á¬½Ó¡£
ÄãÏÈÓÃlocalhost ÊÔÊÔ¿´£¬ÔÙÓÃÅųý·¨Ò»²½²½ÂýÂ
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
<part name="bstrPnrNO" type="s:string" />
<part name ......
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ÎÒÊǸöÐÂÊÖ£¬×öÒ»¸öJSPÍøÒ³£¬ÎÒÒª¶Á³öÊý¾Ý¿âÕý³££¬µ«ÊÇÎÒÒªÐ޸ĵÄʱºò£¬Ò²¾ÍÊǶÁÈëµÄʱºò³öÏÖÂÒÂ룬Çë¸ßÊÖ¸æËßÎÒÔõô½â¾ö£¬ÏÈллÁË¡£
request.setCharacterEncoding("UTF-8");
°Ñ±àÂëͳһ
/**
......
ÌâÄ¿£º
ÓÐ1,2,3£¬4,5,6Áù¸öÊý×ÖÅÅÐò£¬ÓÃjava³ÌÐò¼ÆËã³öÅÅÐòµÄÖÖÀà¡£
ÒªÇó£ºÒ»£¬ÒÔ4¿ªÍ·
¶þ£¬2,3²»ÄÜÏàÁÚ
Èý£¬²»ÄÜÒÔ5¿ªÍ·
Ï£Íû´ó¼ÒÄܼ´ ......