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

javaÁ¬½ÓmysqlµÄ²ËÄñÎÊÌâ

±¾È˳õѧjava£¬ÏÖÔÚѧµ½jdbcµÄÄÚÈÝ£¬ÓÐÎÊÌâÏò´ó¼ÒÇë½Ì£º

Class.forName("com.mysql.jdbc.Driver").newInstance();

¾­²éAPIÎĵµ£¬Õâ¾äÊÇ´´ÔìÁËÒ»¸öcom.mysql.jdbc.DriverµÄʵÀý£¬ºóÃæÒ²¿ÉÒÔµ÷Óã¬ÎÒµÄÎÊÌâÊÇÕâ¸öʵÀý´´ÔìÔÚÁËʲôλÖã¬ÎªÊ²Ã´Ã»ÓÐÃû×ÖÒà¿ÉÒÔµ÷ÓÃÄØ£¿

conn = DriverManager.getConnection("jdbc:mysql://localhost/menagerie?user=root&password=root");

Õâ¾ä¾ÍÊdzɹ¦µ÷ÓõÄÓï¾ä¡£

Statement stmt = null;
ResultSet rs = null;

È»ºóÕâÀïµÄÎÊÌâÊÇ Statement ºÍ ResultSet ¶¼Êǽӿڣ¬ÊDz»ÄÜʵÀý»¯µÄ¡£ÕâÀïÔõô¿´ÔõôÏñÊÇʵÀý»¯ÁË£¬ÍûÃ÷°×ÈËÖ¸µã¡£

stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * from pet");

if (stmt.execute("SELECT * from pet")) {
rs = stmt.getResultSet();
}

ÕâÀï»ù±¾ÉÏÃ÷°×£¬¾ÍÊÇÓÐÒ»µã£ºÈçºÎÄܹ»ÏÔʾ³ö±ípetÀïÃæµÄËùÓÐÄÚÈÝÄØ£¿²éAPI²»µÃ¡£×Ô¼ºÐ´µÄÊÇÕâÑùµÄ£º
System.out.println(rs);

µ±È»ÊDz»¶ÔµÄ¡£Íû¸ßÈËÖ¸µã¡£
ÉÏÃæµÄ´úÂëÀ´Ô´ÓÚmysqlµÄÎĵµ£¬Ô­À´ÊÇÓÐtry catchµÄ£¬ÎªÁ˼ò½à £¬ÎÒÈ¥µôÁË£¬×îºóÒ»¾äÊÇÎÒ×Ô¼ºÐ´µÄ¡£

ûÓÐÃû×Ö¿ÉÒÔµ÷ÓÃÊÇÒòΪÀà¼ÓÔØµ½ÄÚ´æÀïÁË¡£¿ÉÒÔ¹©DriverManagerʹÓá£

ÒªÏëÏÔʾ½á¹û¼¯£º
È¥ÍøÉϲéһϰɣ¬Í¦¼òµ¥¡£

Class.forName("com.mysql.jdbc.Driver").newInstance();
Õâ¾ä»°Ò²¿ÉÒÔÀí½â³É×°ÔØ¶ÔmysqlÊý¾Ý¿â·ÃÎʵÄÇý¶¯°É,  µ±È»¼Çס¾ÍÐÐ,


È»ºóÕâÀïµÄÎÊÌâÊÇ Statement ºÍ ResultS


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

ÔÚjspÖÐÓÃsessionÔõôʵÏÖ¹ºÂò¹¦ÄÜ - Java / Web ¿ª·¢

ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ Ë­ÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá

ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë 
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:

public void doPost(HttpServletRequest reque ......

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ