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");
Ïà¹ØÎĵµ£º
·ÀÖ¹×¢ÈëµÄ¼¸ÖÖ°ì·¨
ÆäʵÔÀ´¾ÍÊÇÎÒÃÇÐèÒª¹ýÂËһЩÎÒÃdz£¼ûµÄ¹Ø¼ü×ֺͷûºÏÈ磺
Select£¬insert£¬update£¬delete£¬and£¬*£¬µÈµÈ
function inject_check($sql_str) {
return eregi('select|insert|update|delete|\'|\/\*|\*|\.\.\/|\.\/|union|into|load_file
|outfile', $sql_str); & ......
1.1 °²×°JDK
1.1.1 ÏÂÔØJDK
´ò¿ªhttp://java.sun.com/ÍøÕ¾£¬ÔÚĿ¼ÀïÃæÑ¡ÔñDownload£¬ÔÚÏÂÀ²Ëµ¥ÖÐÑ¡ÔñJava SE
½øÈëÏÂÒ»¸öÒ³Ãæ£¬ÒªÑ¡ÔñÏÂÔØJDK£¬¶ø²»ÒªÏÂÔØJRE£º
½ÓÏÂÀ´ÊÇÑ¡ÔñÔËÐÐµÄÆ½Ì¨£¬ÕâÀﵱȻÊÇÑ¡ÔñlinuxÁË£º
Ñ¡ÔñºÃƽ̨ºó£¬µã»÷continue:
ÕâÀï¿ÉÒÔÖ±½Óµ ......
×î½üÔÚдjava²âÊÔ³ÌÐòµÄʱºòͻȻÓöµ½ÁËÒ»¸öÎÊÌ⣺javaĬÈϰüÖеÄpublicÀàÊDz»ÄÜÔÚÆäËû°üÖÐÖ±½Óµ÷ÓõÄ
Ê×ÏÈ£¬×ܽáÒ»ÏÂĬÈϰüÖÐÀàµÄʹÓ÷¶Î§£¬javaĬÈϰüÖеÄÀà¿ÉÒÔʵÀý»¯ÆäËü°üÖеÄpublicÀ࣬µ«ÊÇÆäËü°üÖеÄÀàÊDz»ÄÜÏÔʽʵÀý»¯Ä¬ÈϰüÖеÄÀàÕâ¸öÌØÐÔÔÚJDK1.4ÒÔºóµÄ°æ±¾³ÉÁ¢£»
& ......
ÔÚJavaÖУ¬²»Í¬µÄÀà¶¼ÓÐ×Ô¼ºµ¥¶ÀµÄCache»úÖÆ£¬ÊµÏֵķ½·¨Ò²¿ÉÄÜÓÐËù²»Í¬£¬ÎÄÕÂÁоÙÁËJavaÖг£¼ûµÄ¸÷ÀàCache»úÖÆµÄʵÏÖ·½·¨£¬Í¬Ê±½øÐÐÁË×ۺϵıȽϡ£
OSCache
OSCacheÊǸöÒ»¸ö¹ã·º²ÉÓõĸßÐÔÄܵÄJava EE»º´æ¿ò¼Ü£¬OSCacheÄÜÓÃÓÚÈκÎJavaÓ¦ÓóÌÐòµÄÆÕͨµÄ»º´æ½â¾ö·½°¸¡£
OSCacheÓÐÒÔÏÂÌØµã£º»º´æÈκζÔÏó£¬Äã¿ÉÒÔ²»ÊÜÏÞÖÆµ ......