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"
&
Ïà¹ØÎĵµ£º
½ñÌìÏë¶ÁÈ¡srcϵÄÅäÖÃÎļþ£¬ÒÔǰһֱûÕÒµ½·½·¨£¬½ñÌìÑо¿ÁËÏÂÖÕÓÚOKÁË
System.out.println("path1:" + getClass().getResource("config.xml").getPath());
System.out.println("path2:" + getClass().getClassLoader().getResource("config.xml").getPath());
path1:/D:/DJ/workspace/.metadata ......
¶ÔÓÚXml,ÎÒµÄÈÏʶÊÇ,Ò»¸öÓÃÀ´´æ·ÅÊý¾ÝµÄ±ê×¼¸ñʽ.Ôõô¿´ÎÒ¶¼¾õµÃXMLºÍHtml,ÍêÈ«²»Ò»Ñù,Ò²Ðí½ö½öÖ»ÊǶ¼Ê¹ÓÃÁ˱ê¼ÇÀ´×÷ΪÎĵµ½âÊ͵ÄÔÒò°É.ËùÒÔÈËÃDzÅϲ»¶°ÑXMLºÍHTML¶Ô±ÈÀ´¿´.¶ÔÓÚÎÒ¸öÈ˶øÑÔ,XML¾ÍÊÇÒ»¸ö¼òµ¥·½±ãµÄÊý¾ÝÎļþ.ÒòΪ.Ëü²»Í¬ÓëÒ»°ãµÄ¹ØÏµÐÍÊý¾Ý¿â,°ÑÊý¾Ý¿´³ö¶þά±í.ͨ¹ý»ù±¾µÄ¹ØÏµÔËËã,»ñÈ¡¶þά±íÖеÄÊý ......
1.µÃµ½µ±Ç°µÄʱ¼ä
Calendar cal = Calendar.getInstance();
String time=formatter.format(cal.getTime());
String strEnd=time.substring(0, 16);// 2007-10-30 09:30
2.µÃµ½Ç°Ò»ÌìµÄʱ¼ä
Calendar c = Calendar.getInstance();
c.add(Calendar.DAY_OF_MONTH, -1);
SimpleDateFormat ......
¶ÔÓÚjavaÏîÄ¿ÖеİüÃüÃû¶ÔÓÚ¿ª·¢ÈËÔ±À´ËµÔÙ¼òµ¥²»¹ýÁË£¬¿ÉÄÜÓÐЩÈËÈÏΪÈç¹û²ÉÓÃStruts+Spring+Hibernate¿ª·¢¿ò¼Ü£¬ÄÇô¾ÍÓÃaction+service+modelÀ´ÃüÃûºÃÁË£¬²ã´ÎÇåÎú£¬Ò×ÓÚÀí½â£¬ÕâЩ¿´ËÆÃ»ÓÐÈκÎÎÊÌ⣬µ«ÊÇÄãÓÐûÓÐÅöµ½¹ýҪʵÏÖ¸ö¹¦ÄÜʱ£¬ÏîÄ¿ÀïµÄÀàÎļþºÜ¶à£¬ÄãÐèÒªÔÚaction¡¢service¡¢model°üÏÂÀ´» ......