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-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÏë×ö¹»¹ºÎï³µÓÃsession µ«ÊDz»ÖªµÀÔõô»ñÈ¡¹ºÂòÊýÁ¿ ËÓоßÌåµÄ´úÂëÂð Ï£ÍûÄܸîÉá
ÏÂÃæÊǹºÎï³µµÄºËÐÄ´úÂë
ÓÐÁËÕâ¸ö ¾ÍÓ¦¸ÃÄܹ»×ö³öÀ´°É
Java code:
public void doPost(HttpServletRequest reque ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......