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

ProxoolÀ´Á¬½Ómysql½éÉÜ

±¾ÎÄÖ÷Òª½éÉÜÁ˲ÉÓÃProxoolÀ´Á¬½ÓmysqlµÄ·½·¨£¬Í¨¹ýjava  application·½Ê½¿ÉÒÔÑéÖ¤Êý¾Ý¿âµÄÁ¬½Ó¼°»ñÈ¡±íÖеÄÊý¾Ý¡£ÎªÁËÄܹ»Ó봫ͳµÄJDBC·½Ê½µÄÁ¬½Ó½øÐбȽϣ¬±¾ÎIJÉÈ¡ÁËÁ½ÖÖ·½Ê½½øÐÐÊý¾Ý¿âµÄÁ¬½Ó£¬´úÂëÈçÏ¡£
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;
public class TestProxool {
public static String dburl = "jdbc:mysql://localhost:3306/dma";
public static String user = "root";
public static String password = "888888";

public static void test1() throws Exception {
String testsql = "select * from user where userID = 13";
//1£º×¢²áÇý¶¯Àà
Class.forName("com.mysql.jdbc.Driver");
//2£º´´½¨Êý¾Ý¿âÁ¬½Ó
Connection conn = DriverManager.getConnection(dburl, user, password);
//3£º´´½¨Ö´ÐÐSQLµÄ¶ÔÏó
Statement stmt = conn.createStatement();
//4£ºÖ´ÐÐSQL£¬²¢»ñÈ¡·µ»Ø½á¹û
ResultSet rs = stmt.executeQuery(testsql);
//5£º´¦Àí·µ»Ø½á¹û£¬´Ë´¦´òÓ¡²éѯ½á¹û
while (rs.next()) {
System.out.print(rs.getInt("userID") + "\t");
System.out.print(rs.getString("sourceIP") + "\t");
System.out.println();
}
//6£º¹Ø±ÕÊý¾Ý¿âÁ¬½Ó
conn.close();
}

/**
* proxool·½Ê½²âÊÔ
*
* @throws Exception
*/
public static void test2() throws Exception {
//¼ÓÔØÅäÖÃÎļþ,ÅäÖÃÎļþ¿ÉÒÔÊÇÏà¶Ô·¾¶£¬Ò²¿ÉÒÔÊǾø¶Ô·¾¶
JAXPConfigurator.configure("proxool.xml", false);
// System.out.println("You have already load the xml file");
String testsql = "select * from user where userID = 13";
//1£º×¢²áÇý¶¯À࣬ÊÇProxoolרÓõÄÇý¶¯
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
//2£º´´½¨Êý¾Ý¿âÁ¬½Ó£¬Õâ¸ö²ÎÊýÊÇÒ»¸ö×Ö·û´®£¬ÊÇÊý¾ÝÔ´µÄ±ðÃû£¬ÔÚÅäÖÃÎļþÖÐÅäÖõÄdma£¬²ÎÊý¸ñʽΪ£ºproxool.Êý¾ÝÔ´µÄ±ðÃû
Connection conn = DriverManage


Ïà¹ØÎĵµ£º

ÈçºÎд³ö¸ßÐÔÄܵÄMySQL²éѯ

ÏëдÕâÑùһƪÎÄÕºܾÃÁË£¬µ«Ê¼ÖÕûÓÐÏÂÊÖ¡£×î½ü°ïͬÊ¿´Á˼¸¸ö²éѯ£¬¶øÇÒ×Ô¼ºÒ²ÔÚ¿¼ÂÇÒ»¸öË÷ÒýϵͳµÄÎÊÌ⣬ËùÒÔ½ñÌì¾Í°ÑÕâ¸öдÁË¡£½éÉÜÒ»ÏÂMySQLµÄË÷Òý»úÖÆ£¬»¹ÓÐһЩMySQL²éѯµÄÓÅ»¯²ßÂÔ¡£±ÉÈ˲ÅÊèѧdz£¬ºÜ¿ÉÄÜ˵µÄ²»¶Ô£¬Çë·¹ýµÄ¸÷λ´óÏÀÅúÆÀÖ¸Õý£¬Ï׳óÁË¡£
------------------- jiajun.org ¹Ù·½·Ö¸îÏß ---------------- ......

mysqlÉèÖÃbitÀàÐÍÊý¾Ý


Êý¾Ý¿âµÄÒ»ÕűíÀïÃæ´æÁ˹ØÓÚһ̨É豸µÄ±¸·ÝÅäÖÃÐÅÏ¢£¬ÀàÐÍÊÇbit£¬Ö÷Òª¾ÍÊÇÊÇ·ñÒѾ­ÅäÖã¬ÉèÖõÄʱºòȡֵÊÇtrue,false,»¹ÊÇ0£¬1ÄØ£¿
¾À½áÁ˰ëÌ죬¶¯Ê־ͺÃÁË£¬ÊÇ0£¬1£¬¶ø·Çtrue,false£¬
¸üÐÂÓï¾äÈçÏÂ
update  table_a
set configBaked= 0
where id in (2,3,4)
......

ʹÓÃMySQL connector/C++Á´½ÓMySQLÊý¾Ý¿â

Ê×ÏÈÈ¥MySQL¹ÙÍøÏÂÔØMySQL connector/C++
http://dev.mysql.com/downloads/connector/cpp/1.0.html
ÏÂÔØµÚ¶þ¸ö°ü£¬windows32λ·Ç°²×°°æ£¨¸öÈ˾õµÃÕâ¸ö°ü¸É¾»£©¡£Ä¿Ç°µÄ°æ±¾ÊÇConnector/C++ 1.0.5¡£
Windows (x86, 32-bit), ZIP Archive
(mysql-connector-c++-noinstall-1.0.5-win32.zip)
½«Õû¸ö°ü½âѹµ½ÏîÄ¿Îļþ¼Ðϵ ......

ÔõôÑùÐÞ¸Ämysqlµ¼ÈëÎļþ´óСÏÞÖÆ

×Ô¼ºµçÄÔÉÏ×°µÄWAMP£¬ÔÚµ¼ÈëÊý¾Ý¿â±È½Ï´ó£¨´óÓÚ2M£©Ê±Óöµ½´íÎ󣬲»Äܵ¼Èë¡£
ÕÒµ½½â¾ö·½·¨£º php.iniÅäÖÃÎļþÖÐÓÐÈý´¦µØ·½ÐèÒª¸Ä¶¯£º
upload_max_filesize
memory_limit
post_max_size
ÕâÈý¸öÖµ¶¼¹¤¾ßʵ¼ÊÇé¿ö¸ÄÏ£¬ÖØÆô·þÎñÆ÷ÒÔºó£¬ËäÈ»µ¼ÈëʱÈÔÈ»ÏÔʾÊÇ ×î´óÏÞÖÆ£º2,048 KB) £» µ«Êµ¼ÊÉÏÒѾ­¿ÉÒÔµ¼ÈëºÜ´óµÄÊý¾Ý¿â ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ