½â¾ömysqlÊý¾Ý¿âÖÐÎÄÂÒÂëÎÊÌâ
½â¾öÂÒÂë×îºÃµÄ·½·¨ÊÇÔÚÏîÄ¿Éè¼ÆÖ®³õ£¬Í³Ò»ËùÓеÄ×Ö·û¼¯£¬ÀýÈçÒ³Ãæ¡¢request¶ÔÏóÒÔ¼°Êý¾Ý¿âµÈµÈ¡£
Ò»¡¢ ¼¸ÖÖ³£¼ûµÄÂÒÂëÏÖÏó£º
1¡¢Ò³ÃæÂÒÂë
µ¥´¿µÄÒ³ÃæÂÒÂëÊǺܺýâ¾öµÄ£¬Ö»ÒªÐÞ¸ÄÍ·²¿ÊʺϵÄ×Ö·û¼¯¼´¿É£¬Èç¹ûÒ³ÃæÖÐÎÄÏÔʾÂÒÂ룬Äã¿ÉÒÔ°Ñ×Ö·û¼¯ÐÞ¸ÄΪ£ºgb2312»ògbk¡£
2¡¢Ò³ÃæÖ®¼ä´«µÝµÄ²ÎÊýÊÇÂÒÂë
Ò³ÃæÖ®¼ä´«µÝ²ÎÊý³öÏÖµÄÂÒÂ룬¾ÍÒª½â¾öÒ³Ãæ±àÂëºÍrequsetµÄ×Ö·û¼¯ÎÊÌ⣬ÔÚ²ÎÊý´«½ø´«³öÊ±ÖØÐÂÉèÖÃÏàÓ¦µÄ×Ö·û¼¯¡£±ÈÈ磺request.setCharacterEncoding("UTF-8");
3¡¢Êý¾Ý¿âÂÒÂ루ÏÂÃæÏêϸ½éÉÜ£©
ÔÚssh¿ò¼ÜÖнâ¾öÖÐÎÄÂÒÂëÎÊÌ⣨ϣÍû¶ÔÄãÓÐÓã¡£©
1. jspÒ³ÃæÖÐ È«²¿Îªutf-8
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="UTF-8"%>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
2.actionÖÐΪutf-8(ÓÐʱÓÐ×÷ÓÃ)
HttpServletRequest request =ServletActionContext.getRequest();
request.setCharacterEncoding("UTF-8");
3. web.xmlÖÐΪutf-8
<!-- Character Encoding filter -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter- class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
4.Êý¾Ý¿âÁ¬½ÓΪutf-8
jdbc:mysql://localhost/Êý¾Ý¿âÃû?useUnicode=true&characterEncoding=UTF-8
5 Êý¾Ý¿â±àÂëΪgbk£¨¼û¸½¼þ£©
Ò³ÃæºÍÒ³Ãæ´«Öµ¶¼Ã»ÓÐÎÊÌ⣬½á¹û·¢ÏÖ´æ´¢ÔÚÊý¾Ý¿âÖеÄÊý¾Ý³öÏÖÁËÂÒÂ룬ÔòÎÊÌâÊdzöÏÖÔÚÊý¾Ý¿âµÄ±àÂëÎÊÌâ¡£
ÏÂÃæÎÒÒÑMySqlÊý¾Ý¿âΪÀý˵Ã÷½â¾ö·½·¨£º
Èç¹ûÄã°²×°Êý¾Ý¿âµÄʱºò×Ö·û¼¯Ê¹ÓõÄĬÈÏÑ¡Ïlatin1
DOSÃüÁîϽøÈëÊý¾Ý¿âshow Ò»ÏÂ×Ö·û¼¯£¨ÃüÁshow variables like"%char%"; £©
Ïà¹ØÎĵµ£º
1.install mysql
get mysql
http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.1/mysql-5.1.41-linux-i686-icc-glibc23.tar.gz
[root@localhost mysql]# tar -zxvf mysql-5.1.41-linux-i686-icc-glibc23.tar.gz
[root@localhost mysql]# cd mysql-5.1.41-linux-i686-icc-glibc23
[root@localhost mysql]# vim RE ......
how to install apache, PHP and MySQL on Linux
This tutorial explains the installation of Apache web server, bundled
with PHP and MySQL server on a Linux machine. The tutorial is primarily for SuSE
9.2, 9.3, 10.0 & 10.1, but most of the steps ought to be valid for all
Linux-like operating ......
mysqlµ¼³ösql½Å±¾ ÊÕ²Ø
×¢ÒâÊÂÏî:
*±ØÐëÔÚD:\LTSOFT\MYSQL4\bin> mysqldump -u root -p test > c:\a.sql
ÏȵýøÈëmysql°²×°Ä¿Â¼µÄbinÏ£¨¿ÉÒÔ¿´µ½ÀïÃæÓÐmysqldump.exe£©£¬Í¨³£mysqlĬÈϰ²×°ÔÚC:\Program Files\MySQL\MySQL Server 5.0
* ²»ÄܽøÈëmysql ÃüÁîÀï.
MySQLµ¼³ ......
1.PRIMARY KEY£¨Ö÷¼üË÷Òý£©
mysql>ALTER TABLE `table_name` ADD PRIMARY KEY ( `column` )
2.UNIQUE(ΨһË÷Òý)
mysql>ALTER TABLE `table_name` ADD UNIQUE (
`column`
)
3.INDEX(ÆÕͨË÷Òý)
mysql>ALTER TABLE `table_name` ADD INDEX index_name ( `column` )
4.FULLTEX ......
ÎÒÔڵǼMySQLºóµÄÃüÁîÐÐÊÇÕâ¸öÑù×ӵģº
warmbupt@pchuang:/windows/MyCode/SS$ mysql -u root -ppassw0rd
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 5.1.37-1ubuntu5.1 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the curr ......