Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

JDBCÁ´½Ómysql£¬Ò»¸ö¸úÆæ¹ÖµÄÎÊÌ⣿

ÏÂÃæÊÇÒ»¸öÎÒдµÄÈ¡Á¬½ÓµÄ·½·¨£º
public static Connection getConn(String user,String password,String url,String driver){
Connection connection = null;
try {
System.out.println("DBConnectionTemp1");
Class.forName(driver);
System.out.println("DBConnectionTemp2");
connection = DriverManager.getConnection(url, user, password);
System.out.println("DBConnectionTemp3");
} catch (ClassNotFoundException e1){
e1.printStackTrace();
} catch (SQLException e){
e.printStackTrace();
}
return connection;
}
ÎҵijÌÐòÔÚ²»¶ÏµÄÈ¡Á¬½Ó£¬µ«Êǵ±ÎÒ°ÑÊý¾Ý¿âËùÔڵļÆËã»úÍøÏß°ÎÁËÒÔºó£¬ÉÏÃæ³ÌÐò¾ÍÊä³öÁË£º
DBConnectionTemp1
DBConnectionTemp2
È»ºó¾Í²»¶¯ÁË£¬Ò²²»±¨´í£¬Ò²²»ÍùÏÂÔËÐУ¬³ÌÐòҲûͣ£¬¾ÍÕâôһֱͣ×Å£¬Ë­Óöµ½¹ýÕâÖÖÇé¿ö£¬Ö¸µãһϣ¡ÏÈлÁË
²»»á°É£¬Ã»Óö¼û¹ýÕâÖÖÎÊÌ⣬ÄãÁ´½ÓµÄÊý¾Ý¿â²»ÔÚ±¾»úÂð£¿

(String user,String password,String url,String driver){

ÕâЩ²ÎÊýÓÐûÓзûºÏÄãµÄÁ´½ÓÊý¾Ý¿âµÄÇé¿ö£¡£¡

lizhey314£¬ÄãºÃ£¬ÎÒÉÏÃæµÄÕâ¸ö·½·¨ÊÇÔÚ²»¶ÏµÄÈ¡Á¬½Ó£¬¶øÇÒÒ²ÊÇÕý³£µÄ£¬µ«ÊÇÎÒ°ÑÍøÏß°ÎÁËÖ®ºó¾ÍÓÐÎÊÌâÁË£¬¾ÍÊÇÉÏÃæÎÒ˵µÄÕâ¸öÎÊÌ⣡

DriverManager.setLoginTimeout(int seconds)
// ÉèÖÃÇý¶¯³ÌÐòÊÔͼÁ¬½Óµ½Ä³Ò»Êý¾Ý¿âʱ½«µÈ´ýµÄ×ʱ¼ä£¬ÒÔÃëΪµ¥Î»¡£

ºÇºÇ û¼û¹ý

ÁéÒìʼþ

public static Connection getConn(String user,String password,String url,String driver)ÄãÕâÀïʹÓõÄstaticÐÞÊηû


Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......

mysql ÔõÑù²ÅÄܶÔͬһÕűí²éѯºóÔÙ¸üÐÂ?

Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......

°ïæ¿´¿´MySQLÓйصÄÅú´¦ÀíÎļþµÄÓï·¨

echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£

echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ