java.sql.SQLException: Cannot set cid: incompatible types. Query: select * from category Parameters:

数据库查询出数据类型和实体类字段定义类型不匹配。

java.sql.SQLException: Cannot set cid: incompatible types. Query: select * from category Parameters: []

查询语句

package com.yang1.Dao.impl;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.yang1.Dao.CategoryDao;
import com.yang1.domain.Category;
import com.yang1.utils.DataSourceUtils;

public class CategoryDaoImpl implements CategoryDao {

 @Override
 public List<Category> findAll() throws Exception {
  // TODO Auto-generated method stub
   QueryRunner qr = new QueryRunner(DataSourceUtils.getDataSource());
   String sql = "select * from category";
  
 
  return qr.query(sql, new BeanListHandler<>(Category.class));
 }

}

 Category.class

package com.yang1.domain;

import com.sun.org.apache.xpath.internal.operations.String;

//分类实体
public class Category {
 
 private String cid;
 private String cname;
 
 public String getCid() {
  return cid;
 }
 
 public void setCid(String cid) {
  this.cid = cid;
 }
 
 public String getCname() {
  return cname;
 }
 
 public void setCname(String cname) {
  this.cname = cname;
 }
 
}

sql建表语句

create table
CREATE TABLE `category` (    `cid` varchar(32) NOT NULL,    `cname` varchar(20) DEFAULT NULL,    PRIMARY KEY (`cid`)  ) ENGINE=InnoDB DEFAULT CHARSET=utf8

求指点