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>