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 ......
ÒªÓõ½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¡£
Èç¹ûΪ¶ÔÏó£ºÕâЩ¶ÔÏó»á°´Ë³Ðò³õʼ»¯¡£
¡ùÔÚËùÓÐÀà³ÉÔ±³õʼ»¯Íê³ÉÖ®ºó£¬²Åµ÷Óñ¾ÀàµÄ¹¹Ôì·½·¨´´½¨¶ÔÏó¡£
¹¹Ôì·½·¨µ ......
Õ⼸Ìì°²×°ÁËһ̨linux·þÎñÆ÷¡£±¾À´Ò»Î»Í¦¼òµ¥¸öÊ£¬Ã»Ïëµ½ÕÛÌÚÁ˺ü¸Ìì¡£
Ê×ÏÈÊÇ °²×° AS4.4
·þÎñÆ÷ÊÇÁªÏë R520 G6£¬±¾ÒÔΪŪ¸öаæµÄunbuntu¾ÍÄÜÇý¶¯ÆðÀ´£¬Ã»Ïëµ½ÉÏÀ´¾ÍÓöµ½ÁËÂé·³¡£Ð°æµÄlinux»¹ÊÇû°ì·¨Çý¶¯ÆðÀ´£¬ÁªÏëËæ»ú¸øµÄÇý¶¯×î¸ß¾Íµ½AS4.4£¬Ã»°ì·¨Ö»ºÃÕÒÕÒAS4.4 °²×°ÁË¡£
Ê×ÏȹâÅÌÆô¶¯ ÊäÈë linux dd&nb ......
ʵÏÖÒ»¸öRMIÓ¦ÓóÌÐò£¨ÊµÑ鱨¸æ£©
¢åʵÑéÄÚÈÝ
ʵÏÖÒ»¸ö¼òµ¥µÄʵʱÁÄÌìϵͳ¡£
¢æ´¦ÀíÁ÷³Ì
1¡¢ÏµÍ³Éè¼Æ
¢Ù ´´½¨»Øµ÷½Ó¿Ú
¶¨ÒåÒ»¸ö»Øµ÷½Ó¿Ú£¬·þÎñÆ÷¶Ë¿ÉÒԻص÷´Ë½Ó¿ÚÖÐÉùÃ÷µÄ·½·¨¡£¸Ã½Ó¿Ú±ØÐë¼Ì³ÐÔ¶³Ì½Ó¿Ú¼´Remote¡£
¢Ú ´´½¨Ò»¸ö±¾µØ½Ó¿Ú
ÔڸýӿÚÖÐÌí¼Ó±¾½Ó¿ÚµÄʵÏÖÀàÖÐµÄ ......