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

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();
}
}
}
}


Ïà¹ØÎĵµ£º

Java Set Delete Remove

       // ɾ³ýʱ±ØÐëͨ¹ýiterator.remove()À´Ö´ÐУ¬²»ÄÜÖ±½ÓʹÓÃsetµÄremove()À´Ö´ÐУ¬²»È»»á³öÏÖjava.util.ConcurrentModificationExceptionÒì³£
/*       Iterator<String> delIter = keySet.iterator();
      ......

MySQL Archive Storage Engine

The MySQL 5.0 Archive Storage Engine
http://dev.mysql.com/tech-resources/articles/storage-engine.html
ÌØµã£º
1.²»Ö§³ÖÈκÎË÷Òý£¬µ«Ê¹Óòéѯ»º´æ
2.¸ù¾Ýmysql¹¤³ÌʦµÄ˵·¨£¬µ±±í´óС´ïµ½1.5Gʱ£¬±íɨÃèarchiveʱ¼äÉÙÓÚmyisam±í
3.Èç¹ûÄãÏë¸Ä±äÆäËû´æ´¢ÒýÇæµÄ±íµ½archiveÒýÇæ£¬ÇëÏÈdropÏÂÈκÎË÷Òý
4.myisam¿ÉÒÔÓ ......

Mysql¸´ÖƼ¼ÊõÖеÄÖ÷¼ü³åÍ»

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 ......

mysqlµÄ±È½ÏÔËËã

ÔÚmenzhi007µÄblogÀï¿´µ½·Ç³£ÓÐÒâ˼µÄ¶«Î÷£ºhttp://hi.baidu.com/menzhi007/blog/item/c2e98551a18754848c54301c.html
ÔÚmysqlÊÖ²áÀ
http://www.phpchina.com/manual/mysql/functions.html#comparison-operators
MySQL°´ÕÕÒÔϹæÔò½øÐÐÊýÖµ±È½Ï£º
ÈôÓÐÒ»¸ö»òÁ½¸ö²ÎÊýΪ NULL£¬³ý·ÇNULL-safe <=> µÈËã·û£¬Ôò±È ......

mysql´æ´¢ÒýÇæµÄË÷Òý¶Ô±È

´æ´¢ÒýÇæ Ö§³ÖË÷Òý myisam b-tree,r-tree,full-text,²»Ö§³Öhash innodb b-tree(clustered-index) merge b-tree,r-tree memory b-tree,hash archive ÎÞË÷Òý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ