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ѹËõÎĵµµÄÄÚ²¿½á¹¹ÊÇûÓй²¿ªµÄ¡£ËùÒÔûÓÐרÃŵĽâÎö¿â³ÌÐò¡£×Ô¼ºÒ²¾ÍÖ»ºÃÓÃÃüÁîÐÐÁË£¬µ« ......
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. ......
Ò»£® Incident
import java.util.ArrayList;
import java.util.List;
public class Test {
public static void main(String[] args) {
......
MySQLÐÔÄÜÓÅ»¯µÄ×î¼Ñ20+Ìõ¾Ñé
½ñÌ죬Êý¾Ý¿âµÄ²Ù×÷Ô½À´Ô½³ÉΪÕû¸öÓ¦ÓõÄÐÔÄÜÆ¿¾±ÁË£¬Õâµã¶ÔÓÚWebÓ¦ÓÃÓÈÆäÃ÷ÏÔ¡£¹ØÓÚÊý¾Ý¿âµÄÐÔÄÜ£¬Õâ²¢²»Ö»ÊÇDBA²ÅÐèÒªµ£ÐĵÄÊ£¬¶øÕâ¸üÊÇÎÒÃdzÌÐòÔ±ÐèҪȥ¹Ø×¢µÄÊÂÇé¡£µ±ÎÒÃÇÈ¥Éè¼ÆÊý¾Ý¿â±í½á¹¹£¬¶Ô²Ù×÷Êý¾Ý¿âʱ£¨ÓÈÆäÊDzé±íʱµÄSQLÓï¾ä£©£¬ÎÒÃǶ¼ÐèҪעÒâÊý¾Ý²Ù×÷µÄÐÔÄÜ¡£ÕâÀÎÒÃDz»» ......