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
Ïà¹ØÎĵµ£º
from:http://topic.csdn.net/u/20080123/10/28c8cf34-5eb1-40e6-a117-7abe9cd92291.html
1.ûÓа²×°matlab2007֮ǰ£¬³ÌÐò±¨´í£º
Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\WINDOWS\system32\nativemcl77.dll
ÎÒ²éÕÒ×ÊÁÏ·¢ÏÖ£¬Èç¹û²»°²×°matlab£¬Ôò±ØÐëÒª°²×°MATLAB Component Run-time(MCR)£¬
2. ......
ÒÔÏÂÕª×ÔÍøÂç
----------------------------------------
½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ûÕâÑù×Ó²Ù×÷mysql¿â£¬¼´¿É½â¾ö¡£ÔÚ±¾»úµÇÈëmysqlº ......
µÚ1ÕÂ
Java»ù´¡
1.1 JavaµÄÀúÊ·ºÍ»ù±¾ÔÀí
1.2 Java×Ö½ÚÂë
1.3 JavaÊõÓï
1.4 &nbs ......
×î½üÓöµ½ÁËÒ»¸öÎÊÌ⣬¾ÍÊÇÔÚÓõ½List.toArray ·½·¨Ê±£¬·µ»ØObject[]Êý×飬ֱ½Ó°ÑËüǿת³ÉÆäËûÀàÐ͵Ļᱨ´í£º
code: ArrayList list=getList();
String[] s=(String[])list.toArray();
except ......