mybatis04-列名不匹配

配置 resultMap

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="test">

	<resultMap type="bean.Information" id="selectUsers">
		<id property="id" column="id" /><!--  第一个为类的属性名，第二个字段为数据库中的属性名 -->
		<result property="userid" column="user_id" />
		<result property="qqnum" column="qq_num" />
		<result property="phonenum" column="phone_num" />
	</resultMap>
	<select id="selectInformation" resultMap="selectUsers">
		select * from
		information
	</select>
</mapper>

调用

package bean;

import java.io.IOException;
import java.io.Reader;
import java.util.List;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class Main {

	public static void main(String[] args) {
		String resource = "config.xml";
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader(resource);
		} catch (IOException e) {

			e.printStackTrace();
		}
		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
		SqlSession session = sessionFactory.openSession();
		List<Information> li = session.selectList("test.selectInformation");
		for(Information in : li) {
			System.out.println(in);
		}
		

	}

}

其余配置相同。