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

MySQLÂÒÂëÎÊÌâ

Ò»¸öÒ³ÃæÌá½»±íµ¥µ½servlet£¬ Õâ¸öservlet°ÑÊý¾Ý±£´æµ½MySQLÊý¾Ý¿âÖС£

Ìá½»±íµ¥µÄÒ³Ãæ²ÉÓÃutf-8Ò³Ãæ£¬ÎÄ×ÖÏÔʾÕý³£¡£ÔÚservletÖУ¬´ÓjspÒ³Ãæ´«¹ýÀ´µÄ²ÎÊý¾­¹ýutf-8±àÂëת»»ÓÃSystem.out.println(²ÎÊý);Êä³öµ½Myeclipseºǫ́£¬ÏÔʾҲÊÇÕý³£¡£µ«ÊÇ·ÅÈëÊý¾Ý¿â ÀïÃæ¶¼ÊÇÂÒÂ룬 MySQL ×Ö·û¼¯Ò²ÊÇÉ趨Ϊutf-8£»

ÇëÖ¸½Ì£¡£¡


tomcatÖÐÉèÖÃÁËURIEncoding=¡°utf-8¡±ÁËÂð£¿

ÄãÁ¬½ÓÊý¾Ý¿âµÄURLÖ¸¶¨×Ö·û±àÂëΪUTF8û?
Èç¹ûÄãÊÇÔÚMYSQLµÄÃüÁîÐнçÃæ¿´µ½µÄÊÇÂÒÂë,ÄÇÊÇÒòΪÃüÁîÐеÄÏÔʾ×Ö·û±àÂë²»ÄÜÏÔʾÖÐÎÄ.
ÄãÔڲ鿴Êý¾ÝǰʹÓÃÃüÁî set names gbk;
È»ºóÔÙ²éÊý¾ÝÊÔÊÔ.Ó¦¸Ã¿ÉÒÔÁË.
Ò²¿ÉÒÔʹÓÃshow create table table_name À´²é¿´ÄãµÄ½¨±íÓï¾äÈ·¶¨ÎªUTF8


ÄãÓ¦¸ÃÏÈÔÚÂÛ̳ÉÏËÑË÷һϣ¬
¿´ÓÐûÓÐÏàͬµÄÎÊÌâ¼°½â¾ö°ì·¨ÔÙ·¢ÌûµÄ¡£
MySqlÂÒÂëÒ»¹²¿ÉÄÜÓÐÁ½Èý°Ù¸ö½á¹û!


ÒýÓÃ
tomcatÖÐÉèÖÃÁËURIEncoding=¡°utf-8¡±ÁËÂð£¿


ÎÒÊÇÓÃÁ¬½Ó³Ø
    <Resource name="jdbc/mysqlds"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/crh?useUnicode=true&characterEncoding=UTF-8"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="root"
password="admin"
/>


ÒýÓÃ


Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

String SQL=&q ......

mysqlÖÐÎÄÂÒÂë - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......

¹ØÓÚMySQLɾ³ý¼Ç¼ºóIDÈçºÎÁªÏµ

id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿
ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ