java¿ª·¢ÖÐMysqlÖÐÎÄÂÒÂëÎÊÌâµÄ½â¾ö
MysqlÔÚĬÈÏÇé¿öϽ¨Á¢±íµÄ×Ö·û±àÂëÊÇlatin1£¬ËùÒÔÔÚ²åÈëÖÐÎÄʱ»á³ö´í¡£
eg£º
1¡¢²é¿´±í½¨Á¢µÄsqlÔ´Â룺
1: sqlÃüÁshow create table users
2:
3: ½á¹û£º
4: CREATE TABLE `users` (
5: `userID` int(10) unsigned NOT NULL AUTO_INCREMENT,
6: `userName` varchar(45) NOT NULL,
7: `password` varchar(45) NOT NULL,
8: PRIMARY KEY (`userID`)
9: ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin1
2¡¢²é¿´±íÖи÷ÁеÄÊôÐÔ£º
ÃüÁshow full columns from users
½á¹û£º
ÆäÖÐCollationÁбíʾ×Ö·û±àÂë¡£
½â¾ö·½·¨£º
Ò»¡¢ÐÞ¸ÄmysqlµÄÅäÖÃÎļþ£º
ÔÚmysqlµÄ°²×°Ä¿Â¼£¨C:\Program Files\MySQL\MySQL Server 5.1£©Ï£¬ÐÞ¸Ämy.ini¡£
²éÕÒdefault-character-setÊôÐÔ£¬½«Á½´¦¶¼¸ÄΪGBK¡£ÒÔºóÔÙ½¨±íʱ½«Ä¬ÈÏΪGBK±àÂ뷽ʽ¡£
ÐèÒªÖØÐÂÆô¶¯mysql·þÎñ¡£
¶þ¡¢Ð޸ıíµÄ×Ö·û±àÂëÊôÐÔ£º
ÃüÁalter table users CONVERT TO CHARACTER SET gbk
ÃüÁîÔËÐк󣬱íµÄÊôÐÔCHARSET=GBK£¬userNameºÍPasswordÁеÄCollationÊôÐÔ±äΪgbk_chinese_ci¡£
Èý¡¢ÐÞ¸ÄservletÖеĴúÂ룺
ÔÚservlet»ñÈ¡´«¹ýÀ´µÄ²ÎÊý֮ǰÉèÖñàÂ뷽ʽ£¬Èç:
request.setCharacterEncoding("gbk");
String msgTitle = request.getParameter("msgTitle");
String msgContent = request.getParameter("msgContent");
Ïà¹ØÎĵµ£º
MySqlÊý¾Ý¿âµÄÁÐÀàÐÍ£¨×Ö¶ÎÀàÐÍ)
MySQLÊý¾Ý¿âµÄ±íÊÇÒ»¸ö¶þά±í£¬ÓÉÒ»¸ö»ò¶à¸öÊý¾ÝÁй¹³É¡£
ÿ¸öÊý¾ÝÁж¼ÓÐËüµÄÌض¨ÀàÐÍ£¬¸ÃÀàÐ;ö¶¨ÁËMySQLÈçºÎ¿´´ý¸ÃÁÐÊý¾Ý£¬ÎÒÃÇ¿ÉÒÔ°ÑÕûÐÍÊýÖµ´æ·Åµ½×Ö·ûÀàÐ͵ÄÁÐÖУ¬MySQLÔò»á°ÑËü¿´³É×Ö·û´®À´´¦Àí¡£
MySQLÖеÄÁÐÀàÐÍÓÐÈýÖÖ£ºÊýÖµÀà¡¢×Ö·û´®ÀàºÍÈÕÆÚ/ʱ¼äÀà¡£
´Ó´óÀàÀ´¿´ÁÐÀàÐͺÍÊýÖ ......
¼ÓÃܽâÃÜ£¬Ôø¾ÊÇÎÒÒ»¸ö±ÏÒµÉè¼ÆµÄÖØÒª×é¼þ¡£ÔÚ¹¤×÷Á˶àÄêÒÔºó»ØÏ뵱ʱÄǸö¼ÓÃÜ¡¢½âÃÜËã·¨£¬ÊµÔÚÊÇÌ«µ¥´¿ÁË¡£
ÑÔ¹éÕý´«£¬ÕâÀïÎÒÃÇÖ÷ÒªÃèÊöJavaÒѾʵÏÖµÄһЩ¼ÓÃܽâÃÜËã·¨£¬×îºó½éÉÜÊý×ÖÖ¤Êé¡£
Èç»ù±¾µÄµ¥Ïò¼ÓÃÜËã·¨£º
¡ñ BASE64 ÑϸñµØ˵£¬ÊôÓÚ±àÂë¸ñÊ ......
HMAC
HMAC£¨Hash Message Authentication Code£¬É¢ÁÐÏûÏ¢¼ø±ðÂ룬»ùÓÚÃÜÔ¿µÄHashËã·¨µÄÈÏÖ¤ÐÒé¡£ÏûÏ¢¼ø±ðÂëʵÏÖ¼ø±ðµÄÔÀíÊÇ£¬Óù«¿ªº¯ÊýºÍÃÜÔ¿²úÉúÒ»¸ö¹Ì¶¨³¤¶ÈµÄÖµ×÷ΪÈÏÖ¤±êʶ£¬ÓÃÕâ¸ö±êʶ¼ø±ðÏûÏ¢µÄÍêÕûÐÔ¡£Ê¹ÓÃÒ»¸öÃÜÔ¿Éú³ÉÒ»¸ö¹Ì¶¨´óСµÄСÊý¾Ý¿é£¬¼´MAC£¬²¢½«Æä¼ÓÈëµ½ÏûÏ¢ÖУ¬È»ºó´«Êä¡ ......
±¾ÈË´Óʽü10ÄêµÄjava¿ª·¢£¬×ܽáÒ»Ì×ÓÐЧµÄjavaʵսÊÓƵ½Ì³Ì£¬°üÀ¨£ºjava»ù´¡¡¢jspÅàѵ¡¢strutsʹÓá¢hibernateʹÓúÍspringµÄʹÓ㬻¹°üº¬´óÁ¿µÄÅàѵ´úÂ룬ÒÔ¼°sshÕûºÏ¿ª·¢È«¹ý³Ì¡£±¾Ì×ÊÓƵ5Ô·ݾͽ«Â¼ÖÆÍê³É£¬Èç¹ûÄúÓÐÒâÇëÁªÏµÎÒ£¬ÎÒµÄQQ£º1429154728 ......
ͨ¹ýJDBC£¬ÎÒÃÇ¿ÉÒÔÏòoracle²åÈë´ó¶ÔÏó£¬ÈçͼƬ£¬ÒôƵ£¬³¤Îı¾µÈ£¬Æä²åÈë·½·¨Óкܶ࣬ÕâÀïÑÝʾһÏÂͨ¹ýÁ÷¸üиüеÄÐÎʽ²åÈëCLOB´ó¶ÔÏó¡£
ÕâÊÇÒ»¸ö´æ´¢Îı¾µÄÀý×Ó£¬½âÊÍÎÒ»áÔÚ³ÌÐòÖÐÒÔ×¢Ê͵ÄÐÎʽд³ö
/**
* ½«Éú³ÉµÄ±íÑù´æ´¢µ½Êý¾Ý¿â
*
* @param htmlParam
* @return
*/
  ......