还是ibatis的中文乱码问题
jdk 1.6eclipse 3.3
sqlserver2000
ibatis2.3
在执行数据插入时出现乱码。多方查找资料，仍无法解决；源码如下：
sqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<property name="JDBC.ConnectionURL" value="jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=UserDB;SelectMethod=Cursor"/>
<property name="JDBC.Username" value="sa"/>
<property name="JDBC.Password" value="sa"/>
</dataSource>
</transactionManager>
<sqlMap resource="com/hanhl/map/User.xml"></sqlMap>
</sqlMapConfig>
User.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="User">
<select id="getuser" parameterClass="int" resultClass="com.hanhl.obj.User">
<!--select id,name,sex from t_user where id=#id#-->
<!]>
</select>
<select id="getAlluser" resultClass="com.hanhl.obj.User">
<!--select * from t_user-->
<!]>
</select>
<insert id="insertuser" parameterClass="com.hanhl.obj.User">
<!--insert into t_user values(#name#,#sex#)-->
<!]>
</insert>
<delete id="delete user" parameterClass="int">
<!--deletefrom t_user where id=#id#-->
<!]>
</delete>
</sqlMap>
User:
package com.hanhl.obj;
import java.io.Serializable;
@SuppressWarnings("serial")
public class User implements Serializable {
private int id;
private String name;
private int sex;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getSex() {
return sex;
}
public void setSex(int sex) {
this.sex = sex;
}
}
TestClass:
package com.hanhl.unmi;
import java.io.Reader;
import java.nio.charset.Charset;
import java.util.Iterator;
import java.util.List;
import com.hanhl.obj.User;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
public class MySqlMapConfig {
@SuppressWarnings("unchecked")
public static void main(String[] args) throws Exception{
//从配置文件中得到SqlMapClient对象
Reader reader = Resources.getResourceAsReader("com/hanhl/xml/salMapConfig.xml");
SqlMapClient sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
reader.close();
//创建用户数据
for(int i=0; i<10; i++){
User user = new User();
user.setName("我");
if(i%2==0){
user.setSex(0);
}else{
user.setSex(1);
}
sqlMapper.insert("insertuser", user);
}
//查询用户数据
List users = sqlMapper.queryForList("getAlluser");
for (Iterator iter = users.iterator(); iter.hasNext();) {
User user = (User) iter.next();
System.out.println(user.getId());
System.out.println(user.getName());
System.out.println(user.getSex());
}
// for(Iterator iter = users.iterator(); iter.hasNext();){
// User user = (User) iter.next();
// if(user.getSex()!=1||user.getSex()!=0){
// sqlMapper.delete(String.valueOf(user.getId()));
// }
// }
}
}
以上信息在执行后，不出错，但是数据库中name字段为“ ”空格 ，无法显示插入的“我”，请各位指点，初次接触ibatis请各位提供宝贵学习资料，在下不甚感激......
解决之道： 数据库驱动换成jtds(驱动下载链接)http://www.dy-chem.com/wmin/art/list2.asp?page=1&id=57即可；代码如下
<property name="JDBC.Driver" value="net.sourceforge.jtds.jdbc.Driver"/>
<property name="JDBC.ConnectionURL" value="jdbc:jtds:sqlserver://localhost:1433/UserDB;charset=UTF-8"/>后面的charset=UTF-8/GB2312可要可不要！！
页:
[1]