org.apache.ibatis.exceptions.PersistenceException: ### Error querying database.

[桃桃2015]

org.apache.ibatis.binding.MapperProxy@2e644784
DEBUG ==> Preparing: select guide_id, guide_card_num, issuance_date, year_careful_date, guide_level, language, guide_company, name, gender, birthday, nation, education, card_type, card_num, phone, self_introduction, password from t_guide where name=? and password=?
DEBUG ==> Parameters: 李狗蛋(String), 123456(String)
DEBUG <== Columns: GUIDE_ID, GUIDE_CARD_NUM, ISSUANCE_DATE, YEAR_CAREFUL_DATE, GUIDE_LEVEL, LANGUAGE, GUIDE_COMPANY, NAME, GENDER, BIRTHDAY, NATION, EDUCATION, CARD_TYPE, CARD_NUM, PHONE, SELF_INTRODUCTION, PASSWORD
DEBUG <== Row: 1, ITANY-LY-32001, 2010-04-17 00:00:00, 2016-04-17 00:00:00, 初级, 英语, 南京itany导游服务管理有限公司, 李狗蛋, 男, 1982-12-18 00:00:00, 汉族, 本科, 身份证, 320100198212180083, 13333333333, <<BLOB>>, 123456
DEBUG <== Total: 1
guideGuide [guideId=null, guideCardNum=null, issuanceDate=null, yearCarefulDate=null, guideLevel=null, language=英语, guideCompany=null, name=李狗蛋, gender=男, birthday=1982-12-18, nation=汉族, education=本科, cardType=null, cardNum=null, phone=13333333333, selfIntroduction=null, password=123456]


###
entity:
public class Guide {
private Integer guideId;
private String guideCardNum;
private Date issuanceDate;
private Date yearCarefulDate;
private String guideLevel;
private String language;
private String guideCompany;
private String name;
private String gender;
private Date birthday;
private String nation;
private String education;
private String cardType;
private String cardNum;
private String phone;
private String selfIntroduction;
private String password;
public Integer getGuideId() {
return guideId;

###########
mapping.xml

<mapper namespace="dao.IGuideDao">

<sql id="guideColumn">
guide_id,
guide_card_num,
issuance_date,
year_careful_date,
guide_level,
language,
guide_company,
name,
gender,
birthday,
nation,
education,
card_type,
card_num,
phone,
self_introduction,
password
</sql>

<resultMap type="guide" id="guideMapper">
<id property="guideId" column="guide_id" />
<result property="guidCardNum" column="guide_card_num" />
<result property="issuanceDate" column="issuance_date" />
<result property="yearCarefulDate" column="year_careful_date" />
<result property="guideLevel" column="guide_level" />
<result property="language" column="language" />
<result property="guideCompany" column="guide_company" />
<result property="name" column="name" />
<result property="gender" column="gender" />
<result property="birthday" column="birthday" />
<result property="nation" column="nation" />
<result property="education" column="education" />
<result property="cardType" column="card_type" />
<result property="cardNum" column="card_num" />
<result property="phone" column="phone" />
<result property="selfIntroduction" column="self_introduction" />
<result property="password" column="password" />
</resultMap>
<select id="selectByUsernameAndPassword" resultType="Guide" >
select
<include refid="guideColumn"></include>
from t_guide
where name=#{0}
and password=#{1}
</select>
###################
测试类：
@Test
public void GuideSelectByUsernameAndPassword() {
SqlSession session=null;
session=MyBatisUtil.getSession();
IGuideDao guideDao = session
.getMapper(IGuideDao.class);
System.out.println(guideDao);
String name = "李狗蛋";
String password = "123456";
Guide guide = guideDao.selectByUsernameAndPassword(name, password);
System.out.println("guide"+guide);
session.commit();
}

[代码间的舞者]

要么把resultType="Guide" 改成resultMap="guideMapper" 要么给Guide的各个属性加上getter和setter