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ÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......