java查询的时候有些字段取不到值是怎么回事_数据库有数据_java获取不到时间字段中含有下划线的字段数据created_dt，但是改成createdDt就可以获取到，这是什么问题？...

import lombok.Getter;

import lombok.Setter;

import lombok.ToString;

import java.sql.Timestamp;

@Setter

@Getter

@ToString

public class User {

private String id;

private String name;

private String password;

private int type;

private String nikename;

private int age;

private int sex;

private String email;

private String phone;

private String avatar;

private String location;

private int del_flag;

private String memo;

private Timestamp created_dt;

private Timestamp updated_dt;

}

User user = userService.findBy(name, password);

System.out.println("==============userinfo=============" + user.toString());

==============userinfo=============User(id=afe77d04-c38f-11e7-abc4-cec278b6b50a, name=zhangwei, password=123456, type=3, nikename=null, age=0, sex=0, email=null, phone=null, avatar=null, location=null, del_flag=0, memo=null, created_dt=null, updated_dt=null)

从上面打印的数据可以发现created_dt和updated_dt都为空，这是为什么，下面贴一下我的mapper文件和mysql数据：

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

select * from users

where name = #{name} and password = #{password}