记录问题2:mybatisplus映射数据库表与实体类

一、问题

1. 创建了代码、数据库表后点击查询报错。

2. 我们拿出sql进行检查，可以发现字段查询时，实体类字段以每个字母以下划线的结构进行了查询，导致查询失败。

SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT id,l_o_g_i_n__n_o AS LOGIN_NO,g_r_o_u_p__i_d AS GROUP_ID,b_u_s_i__t_y_p_e AS BUSI_TYPE,w_h_i_t_e__f_l_a_g AS WHITE_FLAG,o_p_e_r_a_t_i_o_n__d_a_t_e AS OPERATION_DATE,b_e_g_i_n__t_i_m_e AS BEGIN_TIME,e_n_d__t_i_m_e AS END_TIME,f_u_n_c__c_o_d_e AS FUNC_CODE FROM SXM_MEC_BUSINESS_WHITE_LIST ) TMP WHERE ROWNUM <=10) WHERE ROW_ID > 0

二、解决方法

修改实体类字段为驼峰式，与数据库对应。