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ÐÞÊηû
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......