java mysqlÁ¬½ÓÊý¾Ý¿â´úÂë
package com.lovo.cq.shopping10_1.common;
import java.sql.*;
public class DbUtil {
private PreparedStatement pstmt = null;
private Connection con = null;
public DbUtil() {
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/ShoppingBook10_1",
"root", "root");;
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public Connection getCon() {
return con;
}
public void close() {
if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (con != null) {
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
Ïà¹ØÎĵµ£º
// ɾ³ýʱ±ØÐëͨ¹ýiterator.remove()À´Ö´ÐУ¬²»ÄÜÖ±½ÓʹÓÃsetµÄremove()À´Ö´ÐУ¬²»È»»á³öÏÖjava.util.ConcurrentModificationExceptionÒì³£
/* Iterator<String> delIter = keySet.iterator();
  ......
java 23ÖÖÉè¼ÆÄ£Ê½£¬Ò»°ãÇé¿öÏ£¬³£ÓõÄÓÐÄÄЩ?
¹¤³§Ä£Ê½£¬ ¹¤³§·½·¨Ä£Ê½£¬µ¥Àýģʽ£¬ Íâ¹Û£¨Facade£©Ä£Ê½£¬ ¹Û²ìÕߣ¨Observer£©Ä£Ê½£¬ÇŽӣ¨Bridge£©Ä£Ê½¶¼ÊDZȽϳ£Óõ쬲»Í¬µÄÏîÄ¿Óв»Í¬µÄÉè¼Æ·½Ïò£¬¿ÉÒԲο¼µÄÉè¼ÆÄ£Ê½Ò²²»¾¡Ïàͬ£¬Ã»Óж¨Êý£¬Ö»ÊÇÉÏÃæÕ⼸¸öģʽÓõıȽ϶àһЩ¡£
ÆäËûµÄÄ ......
ÓÃÌØÊâµÄMySQLÔËËã·û»ñµÃ¸ü¶àÊý¾Ý±È½Ï¹¦ÄÜ
Èç¹ûÄãÔÚ×î½ü½øÐйýSELECT»òUPDATE²éѯ£¬ÄÇôÄãºÜ¿ÉÄÜÓõ½¹ýÒ»¸ö»òÕß¶à¸öMySQLµÄ±È½ÏÔËËã·ûÀ´ÏÞÖÆ²éѯµÄÊä³ö½á¹û¡£±È½ÏÊÇ´ó¶àÊýSELECT²éѯ²»¿É·Ö¸îµÄÒ»²¿·Ö£¬¶øMySQLΪÕâÒ»¹¦ÄÜÌṩÁ˺ܶຯÊý£»¸ù¾Ý×î½üÒ»´Îͳ¼Æ£¬ËüÓг¬¹ý20¸öÕâÑùµÄÔËËã·ûºÍº¯Êý£¬´ÓÖøÃûµÄ=ºÍLIKEµ½¸ü¼ÓÄѶ®µÄNO ......
Advanced MySQL Replication Techniques
http://dev.mysql.com/tech-resources/articles/advanced-mysql-replication.html
ÔÚ¶à¸ömasterÖи´ÖƵÄÎÊÌ⣬Ö÷ÒªÊÇ×ÔÔöÖ÷¼üÎÊÌâ¡£
¿ÉÒÔÓÃauto_increment_incrementºÍauto_increment_offset²ÎÊý½â¾ö
£¨1£©auto_increment_increment£º¿ØÖÆÔö³¤µÄ¼ä¸ô
£¨2£©auto_increment_of ......
½ñÌìÓöµ½Òªµ¼³öÊý¾Ý¿âÖбíµÄÊý¾Ý¡£ÏÂÃæÕâ¸ö¾Í¿ÉÒԸ㶨¡£¡£
#µ¼³öÖ¸¶¨µÄ±í #µ¼³öÃüÁî -uÓû§Ãû -pÃÜÂë -hÖ÷»úIPµØÖ· Êý¾Ý¿âÃû ±íÃû1 ±íÃû2 > µ¼³öÎļþ.sql
mysqldump -uroot -proot -h192.168.0.88 ok_db oktable1 oktable2 > ok_db.sql
ÁíÍâÔÚ¸ü¸ÄmysqlÃÜÂëʱºò£¬ÍøÉÏÓÐЩÃüÁî²»¶Ô£º
ÎÒÓÃÈçÏ£ºset password=pas ......