这问题还奇怪了:
我的数据库:
mysql> show variables like "char%";
+--------------------------+--------------------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | D:\Run\mysql-5.7.11-winx64\share\charsets\ |
+--------------------------+--------------------------------------------+
8 rows in set, 1 warning (0.00 sec)
mysql>
jdbc:
jdbc:mysql://127.0.0.1:3306/stockmarket?useUnicode=true&characterEncoding=UTF-8
private synchronized void test(){
TestObj t = new TestObj();
t.setZqdm("002038");
t.setZqmc("双鹭药业");
List reasons = new ArrayList();
reasons.add("日跌幅偏离值达到7%的前五只证券");
reasons.add("日换手率达到20%的前五只证券");
t.setReasons(reasons);
TestObj tt = dao.fetch(t);
if(tt==null){
dao.insert(t);
}else{
dao.update(t);
}
System.out.println(t.getZqmc());
for(String r: t.getReasons()){
System.out.println(r);
}
List list = dao.query(TestObj.class, Cnd.where("zqdm", "=", "002038"));
if(list!=null && list.size()>0){
TestObj t2 = list.get(0);
System.out.println(t2.getZqmc());
for(String r: t2.getReasons()){
System.out.println(r);
}
}
}
输出结果:
双鹭药业
日跌幅偏离值达到7%的前五只证券
日换手率达到20%的前五只证券
双鹭药业
æ¥è·å¹å离å¼è¾¾å°7%çåäºåªè¯å¸
æ¥æ¢æçè¾¾å°20%çåäºåªè¯å¸