JAVA JDBC(MySQL)Çý¶¯Ô´Âë·ÖÎö(ËÄ)
connect·½·¨ÊÇjava.sql.Driver½Ó¿ÚÖж¨ÒåµÄ·½·¨£¬Èç¹ûÁ¬½ÓµÄÊý¾Ý¿â²»Í¬£¬ÄÇôΪ²»Í¬µÄÊý¾Ý¿â±àдJDBCÇý¶¯½«±äµÃºÜÁé»î£¬ÊµÏÖDriver½Ó¿Ú¼´¿É¡£Á¬½ÓÊý¾Ý¿âʱÊ×ÏȵÃ×°ÔØJDBCÇý¶¯£¬Ò²¾ÍÊǵ÷Óà Class.forName(“com.mysql.jdbc.Driver”)·½·¨£¬ÔÚµÚһƪÖÐÒѾÁгömysql jdbc DriverÀàµÄÔ´Â룬´ËÀà¼Ì³ÐNonRegisteringDriverͬʱʵÏÖÁËjava.sql.Driver½Ó¿Ú¡£ÕÒµ½NonRegisteringDriverÀà»á·¢ÏÖËüҲʵÏÖÁËjava.sql.Driver½Ó¿Ú£º
public class NonRegisteringDriver implements java.sql.Driver {
……
}
ÔÚgetConnection·½·¨ÖÐÓÐÈçÏÂÒ»¾ä´úÂ룬
Connection result = di.driver.connect(url, info);
diÊÇDriverInfoÀàÐ͵ĶÔÏ󣬴˶ÔÏóÖаüº¬ÁËDriverµÄÒýÓ㬵«ÊÇÔÚcom.mysql.jdbc.DriverÀàÖÐÖ»ÓÐÒ»¸ö¾²Ì¬¿éºÍÒ»¸ö¹¹Ôì·½·¨£¬ÄÇôconnect·½·¨ÓпÉÄÜÊÇÔÚÆä¸¸ÀàÖÐʵÏÖ¡£ÈçǰËùÊö£¬¸¸ÀàΪNonRegisteringDriver£¬ÔÚmysqlÇý¶¯°üµÄÔ´ÂëÖпÉÒÔÕÒµ½´ËÀà,£º
com.mysql.jdbc.NonRegisteringDriver
ÄÇôdi.driver.connect(url, info) µ÷ÓõÄconnect·½·¨¾ÍÊÇNonRegisteringDriverÀàÖеÄconnect·½·¨£¬Ô´ÂëÈçÏÂ:
public java.sql.Connection connect(String url, Properties info)
throws SQLException {
if (url != null) {
if (StringUtils.startsWithIgnoreCase(url, LOADBALANCE_URL_PREFIX)) {
return connectLoadBalanced(url, info);
} else if (StringUtils.startsWithIgnoreCase(url,
REPLICATION_URL_PREFIX)) {
return connectReplicationConnection(url, info);
}
}
Properties props = null;
if ((props = parseURL(url, info)) == null) {
return null;
}
try {
Connection newConn = com.mysql.jdbc.ConnectionImpl.getInstance(
host(props), port(props), props, database(props), url);
return newConn;
} catch (SQLException sqlEx) {
// Don't wrap SQLExceptions, throw
// them un-changed.
throw sqlEx;
} catch (Exception ex) {
SQLException sqlEx = SQLError.createSQLException(Messages
.getString("NonRegisteringDriver.17") //$NON-NLS-1$
+ ex.toString()
+ Messages.getString("NonRegisteringDriver.18"), //$NON-NLS-1$
SQLError.SQL_STATE_UNABLE_TO_CONN
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://hi.baidu.com/wqj403/blog/item/149957345cd6a11891ef3976.html
ÓÃjavaÔõôÌáÈ¡»òÊǽâѹrarѹËõÎĵµ£¿ÒÔǰ²éÁ˺ܶàµÄ×ÊÁÏ£¬Ã»ÓÐÕÒµ½Ïà¹ØµÄµÚÈý·½¿â£¬ÍøÉϲéÕÒµÄ×ÊÁÏ˵ÊǽâÎörarÖ»Äܸü¼ÓrarµÄÃüÁîÐвÎÊýÀ´½âÎö¡£ÒòΪrarѹËõÎĵµµÄÄÚ²¿½á¹¹ÊÇûÓй²¿ªµÄ¡£ËùÒÔûÓÐרÃŵĽâÎö¿â³ÌÐò¡£×Ô¼ºÒ²¾ÍÖ»ºÃÓÃÃüÁîÐÐÁË£¬µ« ......
ÒÔÏÂÕª×ÔÍøÂç
----------------------------------------
½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ûÕâÑù×Ó²Ù×÷mysql¿â£¬¼´¿É½â¾ö¡£ÔÚ±¾»úµÇÈëmysqlº ......
MySqlѧϰ±Ê¼Ç MySql¸ÅÊö£ºMySqlÊÇÒ»¸öÖÖ¹ØÁªÊý¾Ý¿â¹ÜÀíϵͳ£¬Ëùν¹ØÁªÊý¾Ý¿â¾ÍÊǽ«Êý¾Ý±£´æÔÚ²»Í¬µÄ±íÖУ¬¶ø²»Êǽ«ËùÓÐÊý¾Ý·ÅÔÚÒ»¸ö´óµÄ²Ö¿âÖС£ÕâÑù¾ÍÔö¼ÓÁËËÙ¶ÈÓëÌá¸ßÁËÁé»îÐÔ¡£²¢ÇÒMySqlÈí¼þÊÇÒ»¸ö¿ª·ÅÔ´ÂëÈí¼þ¡£ ×¢Ò⣬MySqlËùÖ§³ÖµÄTimeStampµÄ×î´ó·¶Î§µÄÎÊÌ⣬ÔÚ32λ»úÆ÷ÉÏ£¬Ö§³ÖµÄȡֵ·¶Î§ÊÇÄê·Ý×îºÃ²»Òª³¬¹ý2030Äê ......
ÎÒÏÖÔÚ¸øÄãÒ»¸öJAVAºÍJSPÖ®¼äµÄ¹ØÏµ,ÒÔ¼°JAVAµÄÍêÕûÈÏʶ
JAVA·ÖΪJ2EE,J2SE.J2ME,ÏÂÃæ·Ö±ð½éÉÜ:
Ò».J2EE£ºJava 2 Platform Enterprise Edition ÆóÒµ°æ£¬ÓÃÓÚÆóÒµÓ¦Óã¬Ö§³Ö·Ö²¼Ê½²¿Êð¡£
J2EEƽ̨ÓÉÒ»ÕûÌ×·þÎñ£¨Services£©¡¢Ó¦ÓóÌÐò½Ó¿Ú£¨APIs£©ºÍÐÒé¹¹³É£¬
Ëü¶Ô¿ª·¢»ùÓÚWebµÄ¶à²ãÓ¦ÓÃÌṩÁ˹¦ÄÜÉϵÄÖ§³Ö¡£Ëü°ü ......
Eclipse ¾ßÌåµÄ¾Í²»ËµÁË£¬¶¼ÊìϤÁËO(¡É_¡É)O~£¬ ×î´óµÄÌØµã£ºËüÄܽÓÊÜÓÉjava¿ª·¢Õß×Ô¼º±àдµÄ¿ª·ÅÔ´´úÂëµÄ²å¼þ¡£ NetBeans NetBeansÊÇsunµÄΨһһ¿îÍêÈ«¿ªÔ´µÄ²úÆ·£¬ÔÚ¹¦ÄÜÉÏÓëEclipseÀàËÆ£¬µ«Ò²ÓÐÒ»Ð©Çø±ð¡£È磺Ëü¼¯³ÉÁË×îÁ÷ÐеÄAjax£¬EclipseÐèÒª°²×°µÚÈý·½²å¼þ£¬Eclipse¹ÄÀøÊ¹ÓÃswt×÷ΪjavaGUI¿â ......