测试session与数据库链接出现错误

public class Test {
    public static void main(String[] args) {
        //获取session对象
        SqlSession session = GetSqlSession.createSqlSession();
        //得到对应Mapper
        UserMapper userMapper=session.getMapper(UserMapper.class);
        //调用方法
        User user = userMapper.queryUserByName("zhangsan");
        System.out.println(user);
    }
}

出现以下错误:

Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'userName' from result set.  Cause: java.sql.SQLDataException: Cannot determine value type from string 'zhangsan'
### The error may exist in com/xxxx/mapper/UserMapper.xml
### The error may involve com.xxxx.mapper.UserMapper.queryUserByName
### The error occurred while handling results
### SQL: select * from tb_user where userName = ?
### Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'userName' from result set.  Cause: java.sql.SQLDataException: Cannot determine value type from string 'zhangsan'

解决办法:
1.看mapper的配置文件:parameterType="String"是否写成parameterMap=“String”
2.看自己数据类型有没有搞错
例如:

private String userName写成private Integer userName
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值