3. 使用注解方式配置
在接口方法上使用 @Results
注解:
java
复制
@Select("SELECT user_name, create_time FROM user WHERE id = #{id}") @Results({@Result(column = "user_name", property = "userName"),@Result(column = "create_time", property = "createTime") }) User selectUserById(Long id);
开启自动驼峰命名在spring配置文件中写如下的代码:
<!-- MyBatis配置 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"/><property name="mapperLocations" value="classpath:mappers/*.xml"/><property name="typeAliasesPackage" value="com.stu.entity"/><property name="configuration"><bean class="org.apache.ibatis.session.Configuration"><!-- 开启驼峰转下划线自动映射 --><property name="mapUnderscoreToCamelCase" value="true"/></bean></property></bean>