19c的驱动是在oracle官网下载的，应该是正确的吧。
https://www.oracle.com/database/technologies/appdev/jdbc-ucp-19c-downloads.html

@Wizzercn

为什么查询19c版本的数据库字段为null值，求解？

@wendal
使用自定义sql record拿回来的是正确的数据。

                Dao dao;
                Ioc ioc;
		try {
			ioc = new NutIoc(new ComboIocLoader("*js", "config/"));
			dao = ioc.get(Dao.class);
			/** fetch/query方法  */
			User userByName = dao.fetch(User.class, Cnd.where("login_name", "=", "admin"));
			System.err.println(userByName);
			
			/** 自定义sql record回调 */
			Sql sql = Sqls.create("SELECT t.* FROM GPM_USER t WHERE login_name= 'admin'");
			sql.setCallback(Sqls.callback.record());
			sql.setEntity(dao.getEntity(User.class));
			dao.execute(sql);
			Record re = (Record) sql.getResult();
			System.err.println(re);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}

日志：

For example:> "SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT * FROM GPM_USER  WHERE login_name='admin') T WHERE ROWNUM <= 1) WHERE RN > 0 "
User{id='null', loginName='null', password='null', name='null', organ='null', pwdErrorNumber=0, status='null', lastLoginTime=null}
20-09-16 08:40:36.807 DEBUG [main] SELECT t.* FROM GPM_USER t WHERE login_name= 'admin'
{
   "id": "c8a4b083df484807af6b9a6162c14e61",
   "login_name": "admin",
   "password": "d033e22ae348aeb5660fc2140aec35850c4da997",
   "name": null,
   "organ": "1700000000",
   "status": "1",
   "pwd_error_number": 0,
   "last_login_time": "2020-08-25 19:41:25"
}

为何fetch方法和query方法查询到的是异常数据

@wendal
在自定义sql中增加分页、自定义使用entity回调

        Dao dao;
        Ioc ioc;
		try {
			ioc = new NutIoc(new ComboIocLoader("*js", "config/"));
			dao = ioc.get(Dao.class);
			/** fetch/query方法  */
			User userByName = dao.fetch(User.class, Cnd.where("login_name", "=", "admin"));
			System.err.println(userByName);
			
			/** 自定义sql entity回调 */
			Sql sqlEntity = Sqls.create("SELECT t.* FROM GPM_USER t");
			sqlEntity.setCallback(Sqls.callback.entities());
			sqlEntity.setEntity(dao.getEntity(User.class));
			dao.execute(sqlEntity);
			List<NutMap> reEntity = (List<NutMap>) sqlEntity.getResult();
			System.err.println(reEntity);
			
			/** 自定义sql record回调 加分页*/
			Sql sqlRecord = Sqls.create("SELECT t.* FROM GPM_USER t");
			sqlRecord.setCallback(Sqls.callback.records());
			Pager pager = dao.createPager(1, 1);
			sqlRecord.setPager(pager);
			sqlRecord.setEntity(dao.getEntity(User.class));
			dao.execute(sqlRecord);
			List<NutMap> reRecord = (List<NutMap>) sqlRecord.getResult();
			System.err.println(reRecord);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}

输出结果：

 For example:> "SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT * FROM GPM_USER  WHERE login_name='admin') T WHERE ROWNUM <= 1) WHERE RN > 0 "
User{id='null', loginName='null', password='null', name='null', organ='null', pwdErrorNumber=0, status='null', lastLoginTime=null}
20-09-17 10:48:28.916 DEBUG [main] SELECT t.* FROM GPM_USER t
[User{id='null', loginName='null', password='null', name='null', organ='null', pwdErrorNumber=0, status='null', lastLoginTime=null}, User{id='null', loginName='null', password='null', name='null', organ='null', pwdErrorNumber=0, status='null', lastLoginTime=null}, User{id='null', loginName='null', password='null', name='null', organ='null', pwdErrorNumber=0, status='null', lastLoginTime=null}]
20-09-17 10:48:28.920 DEBUG [main] SELECT * FROM (SELECT T.*, ROWNUM RN FROM (SELECT t.* FROM GPM_USER t) T WHERE ROWNUM <= 1) WHERE RN > 0
[{
   "id": "c8a4b083df484807af6b9a6162c14e61",
   "login_name": "admin",
   "password": "d033e22ae348aeb5660fc2140aec35850c4da997",
   "name": null,
   "organ": "1700000000",
   "status": "1",
   "pwd_error_number": 0,
   "last_login_time": "2020-08-25 19:41:25",
   "rn": 1
}]

自定义sql中的record回调增加分页查询，结果仍然是正确的。

自定义sql使用entities回调，也有问题。

感谢大佬，问题解决了。
刚开始的时候我以为只需要引入ojdbc的包就行了，运行的时候也没有报错，所以不知道问题原因。
debug发现是setEntity时报：不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK

项目引入orai18n.jar这个jar包，问题就解决了。

	public void injectValue(Object obj, ResultSet rs, String prefix) {
		try {
                        // 此处向obj中注入值时，因为字符集的原因报错
			this.setValue(obj, adaptor.get(rs, prefix == null ? columnName : prefix + columnName));
		}
		catch (SQLException e) {
		    if (log.isTraceEnabled()) {
		        log.tracef("columnName="+columnName, e);
		    }
		}
	}

感谢！