mybatis中的select 出现实体类属性名与表属性名不一致的解决方法

方法一:通过取别名来实现数据库表属性名与实体类属性名对应

entity:

public class User {
    private Long id;
    
    private String passWord;

    private String userName;
    }

数据库表属性名:

dao层:

 @Select("select id,user_name as userName,pass_word as passWord from user where id=#{param1} and user_name=#{param2}")
    User findByIdAndName(Long id,String name);

说明:在不通过xml文件,直接在sql语句中取好与实体类属性名一致的别名可以有效的解决这个问题

方法二:通过@Results注解

 @Select("select id,user_name ,pass_word  from user where id=#{param1} and user_name=#{param2}")

@Results({
		@Result(column="user_name",property="userName"),
		@Result(column="pass_word",property="passWord",
	})
	    User findByIdAndName(Long id,String name);

说明:column是数据库的属性名,property是实体类的属性名字.