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)
......
ÈçÌ⣬C/C++ÖеÄexeclÔõôµ÷ÓÃдºÃµÄjava³ÌÐò£¬
execl("/opt/java1.5/bin/java","MyClass",NULL);
ÕâÑùµÄ²»ÐÐŶ¡£
²»»á.
ÔËÐÐjava³ÌÐò
ÕÒ¹¤¾ß²é¿´Ò»ÏÂÄǸö³ÌÐòµÄÃüÁîÐÐ
ËÑË÷Ï£ºjni ......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......