mybatis使用idea自动生成的

1. 查出来是一个 list<model>

                      SqlSessionFactory sqlSessionFactory =                      . DBSessionFactory.getConnection();
      SqlSession session = null;

                        session = sqlSessionFactory.openSession(false);
// 查询报价置换
String staSelect = "com.iris.live.data.dao.报价付款详细DtoMapper.selectByQID";
List<报价付款详细Dto> dtoList = new ArrayList<报价付款详细Dto>();
dtoList = session.selectList(staSelect, Integer.valueOf(QPID));

session.commit();
session.close();

>>>>

    model.xml的

 <select id="selectByQID" parameterType="java.lang.Integer" resultMap="BaseResultMap">SELECT   <include refid="Base_Column_List" />   FROM `付款款项` a LEFT JOIN `报价付款详细` b USING (`付款事由`)    WHERE `报价编号`= #{报价编号,jdbcType=INTEGER} ORDER BY `款项编号` ASC   </select>

Base_Column_list

 是返回的 数据库的表的 字段：

      

<sql id="Base_Column_List">   报价编号, 付款事由, 应付金额, 实付金额, 附加参数, 更新账号, 更新时间, 财务备注</sql>

>>>

返回的 

         BaseResultMap

<resultMap id="BaseResultMap" type="com.iris.live.data.model.报价付款详细Dto">  <!--    WARNING - @mbggenerated    This element is automatically generated by MyBatis Generator, do not modify.  -->  <id column="报价编号" jdbcType="INTEGER" property="报价编号" />  <id column="付款事由" jdbcType="VARCHAR" property="付款事由" />  <result column="应付金额" jdbcType="VARCHAR" property="应付金额" />  <result column="实付金额" jdbcType="VARCHAR" property="实付金额" />  <result column="附加参数" jdbcType="VARCHAR" property="附加参数" />  <result column="更新账号" jdbcType="VARCHAR" property="更新账号" />  <result column="更新时间" jdbcType="TIMESTAMP" property="更新时间" />  <result column="财务备注" jdbcType="VARCHAR" property="财务备注" /></resultMap>

model：

    

public class 报价付款详细Dto extends 报价付款详细DtoKey {


/**
* This field was generated by MyBatis Generator. This field corresponds to the database column 报价付款详细.应付金额
* @mbggenerated
*/
private String 应付金额;
/**
* This field was generated by MyBatis Generator. This field corresponds to the database column 报价付款详细.实付金额
* @mbggenerated
*/

/**
* This method was generated by MyBatis Generator. This method sets the value of the database column 报价付款详细.财务备注
* @param 财务备注  the value for 报价付款详细.财务备注
* @mbggenerated
*/
public void set财务备注(String 财务备注) {
this.财务备注 = 财务备注;
}
}

链接数据库：

                                                        这个 是取 电脑里面的  环境变量的 值

private static String env = System.getenv("env");

public static SqlSessionFactory getConnection() {

Reader reader = null;

reader = Resources
.getResourceAsReader("com/iris/live/config/mybatisConfig.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader, env);

return sqlSessionFactory;
}

>>>>>

private static String fileName = "/db.properties";
 
private static String env_url = env+"_url";
private static String env_username = env+"_username";
private static String env_password = env+"_password";
private static String env_approvel=env+"_approvel";


public static Connection getCommonConnection() {
InputStream in = null;
Properties p = new Properties();
Connection con = null;
 
in = DBSessionFactory.class
.getResourceAsStream(fileName);
p.load(in);
if (p.containsKey("driver")) {
driver = p.getProperty("driver");
}
if (p.containsKey(env_url)) {
url = p.getProperty(env_url);
}
if (p.containsKey(env_username)) {
username = p.getProperty(env_username);
}
if (p.containsKey(env_password)) {
password = p.getProperty(env_password);
}
Class.forName(driver);
con = DriverManager.getConnection(url, username, password);
 
return con;
}

》》》》》》》》》》》》

4.mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 引用db.properties配置文件 -->
<properties resource="db.properties" />
<environments default="development">
<environment id="dev">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${driver}" />
<property name="url" value="${dev_url}" />
<property name="username" value="${dev_username}" />
<property name="password" value="${dev_password}" />
<property name="poolMaximumActiveConnections" value="100"></property>
<property name="poolMaximumIdleConnections" value="10"></property>
<property name="poolMaximumCheckoutTime" value="20000"></property>
<property name="poolTimeToWait" value="20000"></property>
</dataSource>
</environment>
<environment id="prod">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${driver}" />
<property name="url" value="${prod_url}" />
<property name="username" value="${prod_username}" />
<property name="password" value="${prod_password}" />
<property name="poolMaximumActiveConnections" value="100"></property>
<property name="poolMaximumIdleConnections" value="10"></property>
<property name="poolMaximumCheckoutTime" value="20000"></property>
<property name="poolTimeToWait" value="20000"></property>
</dataSource>
</environment>
<environment id="test">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${driver}" />
<property name="url" value="${test_url}" />
<property name="username" value="${test_username}" />
<property name="password" value="${test_password}" />
<property name="poolMaximumActiveConnections" value="100"></property>
<property name="poolMaximumIdleConnections" value="10"></property>
<property name="poolMaximumCheckoutTime" value="20000"></property>
<property name="poolTimeToWait" value="20000"></property>
</dataSource>
</environment>
<environment id="local">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${driver}" />
<property name="url" value="${local_url}" />
<property name="username" value="${local_username}" />
<property name="password" value="${local_password}" />
<property name="poolMaximumActiveConnections" value="100"></property>
<property name="poolMaximumIdleConnections" value="10"></property>
<property name="poolMaximumCheckoutTime" value="20000"></property>
<property name="poolTimeToWait" value="20000"></property>
</dataSource>
</environment>
</environments>
<mappers>
<!-- 注册userMapper.xml文件， userMapper.xml位于me.gacl.mapping这个包下，所以resource写成me/gacl/mapping/userMapper.xml -->
<mapper resource="com/iris/live/data/xml/临时接待记录DtoMapper.xml" />
</mappers>
</configuration>