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Îļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ã滹¿ÉÒÔÈ¡³öÖµÀ´.
µ«ÊÇһˢÐÂ,»òÕß´ò¿ªÐµÄÒ³Ãæ¾ÍÈ¡²»³öÖµÀ´ÁË.
Ææ¹ÖµÄÊÇ,ÎÒ²âÊÔÁíÒ»¸ö³ÌÐòʱºò
ÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ãæ¿ÉÒÔÈ¡³öÖµÀ´,ˢлò´ò¿ªÐÂÒ³ÃæÖµÄÜÈ¡³öÀ´ÁË.
......
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
ÓÃRandomAccessFileдÈëTXTÎļþ²é¿´Ê±ÊÇÂÒÂ룬ÇëÎÊÓÐʲô·½·¨¿ÉÒÔд³É¿É¶ÁµÄÎļþ£¬²»ÊÇÓÃÆäËûµÄÎļþ²Ù×÷£¬¾ÍÊÇÖ»ÓÃRandomAccessFileµÄ·½·¨ÊÇ·ñ¿ÉÒÔʵÏÖ£¿
Java code:
import java.io.*;
public class RandomAcce ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......