javaÓëmysqlÂÒÂëµÄÎÊÌâ [ת]
½â¾ö·½·¨Ò»:(×îÖØÒªµÄÒ»ÖÖ·½·¨)
Äã¿´ÏÂmy.ini£¬ÓÐÎÞ
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
È»ºó½¨Á¢±íʱ£¬Ò²ÒªÓ㨱ÈÈ磩
DROP TABLE IF EXISTS `Company`;
CREATE TABLE IF NOT EXISTS `Company`
(
`Cname` VARCHAR(10) NOT NULL,
`Caddr` VARCHAR(100),
`Ctel` VARCHAR(16)
)ENGINE=InnoDB DEFAULT CHARSET=UTF8;
ÕâÑù¾ÍûÎÊÌâ¡£
Èç¹ûÊÇjspÒªÉùÃ÷£º
contentType="text/html;charset=gb2312"
½â¾ö·½·¨¶þ£º
Á¬½Ómysqlʱ(ÎÞÂÛÔÚ´Ómysql¶Á»¹ÊÇÈ¡Êý¾ÝµÄÇé¿ö)£¬Ö¸¶¨Ê¹ÓõıàÂ뷽ʽΪutf-8£¬¾ßÌå´úÂëÈçÏÂ
//×°ÔØmysql-jdbcÇý¶¯
Class.forName("com.mysql.jdbc.Driver").newInstance();
//Á¬½ÓÊý¾Ý¿â
Connection sqlCon = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test? user=root&password=1&useUnicode=true&characterEncoding=utf-8" );
½â¾ö·½·¨Èý£º
Èç¹û·½·¨Ò»²»ÐÐÄÇôÔÚ·½·¨Ò»µÄ»ù´¡É϶ԶÁÈëµÄ×Ö·û´®½øÐÐÇ¿ÖÆ±àÂ뷽ʽת»»¡£
´úÂëʾÀýÈçÏ£º
String name = rst.getString("name");
name= new String(name.getBytes("ISO-8859-1"),"utf-8");
×¢£º´úÂëÒ²¿ÉÒÔΪ£ºString name =new String( rst.getString("name").getBytes("ISO-8859-1"),"utf-8"));ÆäÖÐrstΪ·µ»ØµÄresultset,ISO-8859-1ΪmysqlĬÈϵıàÂ뷽ʽ£¬´úÂëµÄÄ¿µÄÊǰÑÒÔISO-8859-1µÄ±àÂëת»»Îªgb2312±àÂ뷽ʽ£¬ÕâÑùÇ¿ÖÆ×ª»»£¬¿ÉÒÔ½â¾öÒ»²¿·ÖÎÊÌ⣬Èç¹û½áºÏ·½·¨Ò»£¬Ó¦¸Ã¿ÉÒÔ½â¾öÖÐÎÄÂÒÂëÎÊÌâ¡£
½â¾ö·½·¨ËÄ£º
Õâ¸ö·½·¨ÔÚÓÐЩÎÄÕÂÀïÊÇÊ×ÍÆµÄ£¬ÎÒÊ×ÏÈÒ²ÊÇÊÔÁËÕâ¸ö·½·¨£¬µ«ÊǺÃÏñ²»ÐС£ÕâÀﻹÊÇ˵һÏ£¬²»ÖªÊDz»ÊÇÎÒ²Ù×÷´íÎó¡£»¹ÊÇÏÈÌùÔÎİɣº
"Èç¹ûÊý¾Ý¿âÖÐÓÐÖÐÎĵϰ¶ømysqlĬÈϵÄÓïÑÔ²»ÊÇÖÐÎÄʱҪÔÚÅäÖÃÎļþC:winntmy.ini ÖÐµÄ [mysqld] ÀïÌí¼ÓÒ»ÐУº
default-character-set=utf-
Ïà¹ØÎĵµ£º
ǰ¶Îʱ¼ä°²×°MySQL, ·Ç³£Ë³Àû, ºÜ¿ì¾Í°²×°ÁË, È»ºó¾¹ý¼òµ¥µÄÅäÖÃ. ½øÈëMySQLµÄ¿ØÖÆÌ¨, ÊäÈëÃÜÂë. È»ºó¾Í˳ÀûµØ½øÈëµ½Á˹¤×÷״̬.
µ«Êǵ±ÎÒµÚ¶þÌì½øÈëMySQLµÄ¿ØÖÆÌ¨, ÊäÈëÃÜÂëʱ, µÎµÄÒ»Éùºó,Õû¸ö¿ØÖÆÌ¨¾ÍÏûʧÁË.ÖØÐÂÊÔÁ˼¸´Î, ÎÊÌâÒÀ¾É. ¾ÍÉÏÍø°Ù¶ÈÒ»ÏÂ,·¢ÏÖÓв»ÉÙÈËÓöµ½Í¬ÑùµÄÎÊÌâ, ºÜ¶àÈ˶¼ËµÊ±my.iniÅäÖôíÎó, ÓÚÊÇ´ò¿ ......
½ñÌìÁ·Ï°ÔÚJSPÒ³ÃæÖÐʵÏÖ·ÖҳЧ¹û£¬ÔÚ²éѯÓï¾ä·½ÃæÇ£³¶µ½ÁËtopµÄÓ÷¨¡£¼òÒª×öÒ»ÏÂ×ܽ᣺
ΪʵÏÖÀàËÆtopµÄ¹¦ÄÜ£¬ÎÒÃÇÔÚSQL ServerÖкÍMySQLÖÐʹÓõ½µÄSQLÓï¾äÊDz»Í¬µÄ¡£
1¡¢ÔÚSQL ServerÖУ¬ÎÒÃÇʹÓà select top N * ......
(×ªÔØ±êÇ©£ºfckeditorit ·ÖÀࣺJava)
1.½«FCKeditorĿ¼ÏµÄeditor¿½±´µ½ÏîÄ¿µÄWebContentĿ¼ÏÂ
2.²¢°ÑECKeditor-2.3.jar ºÍ commons-fileupload.jar¿½±´µ½ÏîÄ¿\WebContent\WEB-INF\libĿ¼ÏÂ
3.°Ñ FCKeditor.tld¿½±´µ½ÏîÄ¿\WebContent\WEB-INFÏÂ
4.ÔÚweb.xmlÀïÌí¼ÓÈçÏ´úÂë
´úÂë
<servlet> ......
¡¶Java¸ß¼¶¼¼Êõ¡·¿Î³Ì¼ò½é
1. Java³ÌÐòÉè¼ÆÓïÑÔÒýÂÛ
2. JavaÓïÑԵĽṹ»¯ÌØÐÔ
3.1. JavaÓïÑÔµÄÃæÏò¶ÔÏóÌØÐÔ£¨1£©
3.2. JavaÓïÑÔµÄÃæÏò¶ÔÏóÌØÐÔ£¨2£©
3.3. JavaÓïÑÔµÄÃæÏò¶ÔÏóÌØÐÔ£¨3£©
3.4. JavaÓïÑÔµÄÃæÏò¶ÔÏóÌØÐÔ£¨4£©
4.1. ÃæÏò¶ÔÏóÉè¼ÆÔÔò
4.2. ÃæÏò¶ÔÏóÉè¼ÆÄ£Ê½Ê¾Àý
5.1. JavaµÄÒì³£´¦Àí»úÖÆ
5.2. JavaÓïÑÔ ......
Ïß³Ì×é
ÔÚJavaÖÐÿһ¸öÏ̶߳¼¹éÊôÓÚij¸öÏß³Ì×é¹ÜÀíµÄÒ»Ô±£¬ÀýÈçÔÚÖ÷º¯Êýmain()Ö÷¹¤×÷Á÷³ÌÖвúÉúÒ»¸öỊ̈߳¬Ôò²úÉúµÄÏß³ÌÊôÓÚmainÕâ¸öÏß³Ì×é¹ÜÀíµÄÒ»Ô±¡£¼òµ¥µØËµ£¬Ïß³Ì×é¾ÍÊÇÓÉÏß³Ì×é³ÉµÄ¹ÜÀíÏ̵߳ÄÀ࣬Õâ¸öÀàÊÇjava.lang.ThreadGroupÀà¡£
¿ÉÒÔͨ¹ýʹÓÃÈçÏ´úÂë»ñÈ¡´ËÏß³ÌËùÊôÏß³Ì×éµÄÃû³Æ¡£
Thread.currentThread().ge ......