ibatis查询问题 - ITeye问答

0 0

ibatis查询问题3

我用的MYSQL数据库+ibatis,插入数据中文没问题. 查询的时候字段里的值取出来是??? 我是在JAVA类里测试的,并没在JPS里.
guest.xml

<!-- 修改客户信息 -->
	<select id="queryGuest" parameterClass="int" resultClass= "guest">
	<![CDATA[
		SELECT * FROM GUESTTAB WHERE customer_id= #customer_id#
	]]>
	</select>

java

public Guest guestQuery(int customer_id){

			//读取配置文件
			Reader reader;
			Guest guest=null;
			try {
				reader = Resources.getResourceAsReader(resource);
				SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
				guest=(Guest)sqlMap.queryForObject("queryGuest",customer_id);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			//得到SqlMapClient
			return guest;
	}

public static void main(String[] args) {
		GuestDao guestDao= new GuestDao();
		int id=1;
	Guest guest=guestDao.guestQuery(id);
	System.out.print(guest.getCustomer_name());		
	}

插入的值数据库里查都是中文正常的，取出来就是问号．请问如何解决？

iBATIS

2008年10月23日 11:02

rockxx
0
0 0 0

建议你在项目中增加log4j，这样你就可以看到每一次操作的SQL语句都是什么，这样对于寻找问题的解决是有好处的。
例如我用的PostgreSQL,可以看到这样的提示。
SimpleDataSource - Checked out connection 18306082 from pool.
Connection - {conn-100003} Connection
Connection - {conn-100003} Preparing Statement:     select nextval('sequence_id')
PreparedStatement - {pstm-100004} Executing Statement:     select nextval('sequence_id')
PreparedStatement - {pstm-100004} Parameters: []
PreparedStatement - {pstm-100004} Types: []
ResultSet - {rset-100005} ResultSet
ResultSet - {rset-100005} Header: [nextval]
ResultSet - {rset-100005} Result: [11]
Connection - {conn-100003} Preparing Statement:       INSERT INTO "Student"( id, "name", sex, birthday) VALUES   (?,?, ?, ?);
PreparedStatement - {pstm-100006} Executing Statement:       INSERT INTO "Student"( id, "name", sex, birthday) VALUES   (?,?, ?, ?);
PreparedStatement - {pstm-100006} Parameters: [11, 测试名字, f, 2008-10-23 17:12:28.288]
PreparedStatement - {pstm-100006} Types: [java.lang.Integer, java.lang.String, java.lang.String, java.sql.Timestamp]
SimpleDataSource - Returned connection 18306082 to pool.
这样就容易找问题的错误。