JavaÓëmysqlÂÒÂëµÄÎÊÌâ
°²×°Ñ¡ÔñGBK£¬Ê¹ÓÃÑ¡ÔñUTF-8¡£
½â¾ö·½·¨Ò»:(×îÖØÒªµÄÒ»ÖÖ·½·¨)
´ò¿ªmysqlĿ¼ÏµÄbinÎļþ¼Ð£¬ÕÒµ½my.ini£¬Ê¹ÓüÇʱ¾ÕÒ¿ª£¬·Ö±ðÕÒ“[mysql]¡¢[client]¡¢[mysqld]”£¬Ìí¼Ó£¨»ò¸Ä³É£©“default-character-set=utf8”¡£
[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"
&
Ïà¹ØÎĵµ£º
ÒªÓõ½jxlµÄ°ü
¾ßÌåʵÀý
1.Éú³ÉexcelÎļþ
package com.createexcel;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.mysql.jdbc.ResultSetMetaData;
import j ......
1¡¢ ¶ÔÏóµÄ³õʼ»¯
(1) ·Ç¾²Ì¬¶ÔÏóµÄ³õʼ»¯
ÔÚ´´½¨¶ÔÏóʱ£¬¶ÔÏóËùÔÚÀàµÄËùÓÐÊý¾Ý³ÉÔ±»áÊ×ÏȽøÐгõʼ»¯¡£
»ù±¾ÀàÐÍ£ºintÐÍ£¬³õʼ»¯Îª0¡£
Èç¹ûΪ¶ÔÏó£ºÕâЩ¶ÔÏó»á°´Ë³Ðò³õʼ»¯¡£
¡ùÔÚËùÓÐÀà³ÉÔ±³õʼ»¯Íê³ÉÖ®ºó£¬²Åµ÷Óñ¾ÀàµÄ¹¹Ôì·½·¨´´½¨¶ÔÏó¡£
¹¹Ôì·½·¨µ ......
¶ÔÓÚXml,ÎÒµÄÈÏʶÊÇ,Ò»¸öÓÃÀ´´æ·ÅÊý¾ÝµÄ±ê×¼¸ñʽ.Ôõô¿´ÎÒ¶¼¾õµÃXMLºÍHtml,ÍêÈ«²»Ò»Ñù,Ò²Ðí½ö½öÖ»ÊǶ¼Ê¹ÓÃÁ˱ê¼ÇÀ´×÷ΪÎĵµ½âÊ͵ÄÔÒò°É.ËùÒÔÈËÃDzÅϲ»¶°ÑXMLºÍHTML¶Ô±ÈÀ´¿´.¶ÔÓÚÎÒ¸öÈ˶øÑÔ,XML¾ÍÊÇÒ»¸ö¼òµ¥·½±ãµÄÊý¾ÝÎļþ.ÒòΪ.Ëü²»Í¬ÓëÒ»°ãµÄ¹ØÏµÐÍÊý¾Ý¿â,°ÑÊý¾Ý¿´³ö¶þά±í.ͨ¹ý»ù±¾µÄ¹ØÏµÔËËã,»ñÈ¡¶þά±íÖеÄÊý ......
¶ÔÓÚjavaÏîÄ¿ÖеİüÃüÃû¶ÔÓÚ¿ª·¢ÈËÔ±À´ËµÔÙ¼òµ¥²»¹ýÁË£¬¿ÉÄÜÓÐЩÈËÈÏΪÈç¹û²ÉÓÃStruts+Spring+Hibernate¿ª·¢¿ò¼Ü£¬ÄÇô¾ÍÓÃaction+service+modelÀ´ÃüÃûºÃÁË£¬²ã´ÎÇåÎú£¬Ò×ÓÚÀí½â£¬ÕâЩ¿´ËÆÃ»ÓÐÈκÎÎÊÌ⣬µ«ÊÇÄãÓÐûÓÐÅöµ½¹ýҪʵÏÖ¸ö¹¦ÄÜʱ£¬ÏîÄ¿ÀïµÄÀàÎļþºÜ¶à£¬ÄãÐèÒªÔÚaction¡¢service¡¢model°üÏÂÀ´» ......
½ñÌìµÄ±ÊÊÔ×îºóÒ»Ì⿼µÄ»¹ÊÇ×Ö·û´®Ìæ»»ÕâÖÖÌ⣬»¨Á˺þÃ×ÜËãдÍêÁË£¡µ«»ØÀ´ÒÔºóËÑÁËһϣ¬Ò»ÏÂ×Ó»¢µ½ÁË£¬È˼ÒÖ»ÒªÒ»¾ä´úÂë¾Í°ÑÎÊÌâ½â¾öÁË£¬²»µÃ²»Åå·þNB°¡£¡
public static void replaceString(String a,String b,String c){
Sy ......