mybatis+servlet

1. 

  首先 在 web.xml里面 配置 别名

<servlet>
  <description>This is the description of my J2EE component</description>
  <display-name>This is the display name of my J2EE component</display-name>
  <servlet-name>IMgtApprovalInfo</servlet-name>
  <servlet-class>com.iris.live.servlet.IMgtApprovalInfo</servlet-class>
</servlet>

<servlet-mapping>
  <servlet-name>IMgtApprovalInfo</servlet-name>
  <url-pattern>/IMgtApprovalInfo</url-pattern>
</servlet-mapping>

2. servlet层的：

public class IMgtApprovalInfo extends HttpServlet {

private static final long serialVersionUID = 1L;
public IMgtApprovalInfo() {
super();
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=UTF-8");
String DealCode = request.getParameter("dlcode");
String User = request.getParameter("sccode");
String QID = request.getParameter("qid");
String isOld = request.getParameter("old");
try {
StageInfo result = ApprovalHelper.GetApprovalDetail(DealCode, User, QID, isOld);
String json = JsonTools.createJsonString(result);
response.getWriter().println(json);
} catch (Exception e) {
e.printStackTrace();
}
}
}

3. helper层;

public class ApprovalHelper {


public static StageInfo GetApprovalDetail(String DealCode, String User,
String QID, String isOld) {
StageInfo reBean = new StageInfo();
ArrayList<QuoteInfo> qList = new ArrayList<QuoteInfo>();
// 获取链接
SqlSessionFactory sqlSessionFactory = DBSessionFactory.getConnection();
SqlSession session = null;
try {
// 开启事务
session = sqlSessionFactory.openSession(false);
报价单表Dto qDto = new 报价单表Dto();
QuoteInfo qInfo = new QuoteInfo();
Integer tempQID = Integer.valueOf(QID);
if (isOld != null && isOld.equals("是")) {
// 获取报价单(历史)
String staQuote = "com.iris.live.data.dao.报价单表DtoMapper.selectHistoryOrder";
qDto = session.selectOne(staQuote, tempQID);
tempQID = qDto.get报价编号();
} else {
// 获取报价单(当前)
String staQuote = "com.iris.live.data.dao.报价单表DtoMapper.selectByPrimaryKey";
qDto = session.selectOne(staQuote, tempQID);
}

qInfo.setQuoteAInfo(aInfo);
qInfo.setStockInfoAI(stInfoAI);
qInfo.setStockInfoA(stInfoA);
qList.add(qInfo);
reBean.setQuoteList(qList);
reBean.setCustInfo(custInfo);
session.commit();
} catch (Exception e) {
e.printStackTrace();
session.rollback();
} finally {
session.close();
}
return reBean;
}
}

4. vo层： 自己手动的拼接的 列

public class StageInfo implements Serializable{


/**
* 
*/
private static final long serialVersionUID = 1L;


/**
* 平台编号
*/
private String StageID;
/**
* 顾客信息
*/
private QuoteCustomerInfo CustInfo;
/**
* 报价方案，最多3个
*/
private ArrayList<QuoteInfo> QuoteList;




public StageInfo() {
super();
}
public String getStageID() {
return StageID;
}
public void setStageID(String stageID) {
StageID = stageID;
}
public QuoteCustomerInfo getCustInfo() {
return CustInfo;
}
public void setCustInfo(QuoteCustomerInfo custInfo) {
CustInfo = custInfo;
}
public ArrayList<QuoteInfo> getQuoteList() {
return QuoteList;
}
public void setQuoteList(ArrayList<QuoteInfo> quoteList) {
QuoteList = quoteList;
}
public static long getSerialversionuid() {
return serialVersionUID;
}
@Override
public String toString() {
return "StageInfo [StageID=" + StageID + ", CustInfo=" + CustInfo
+ ", QuoteList=" + QuoteList + "]";
}
}

5.

报价单表Dto.xml 

  <?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="com.iris.live.data.dao.报价单表DtoMapper">
  <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="报价编号" />
    <result column="许可" jdbcType="VARCHAR" property="许可" />
    <result column="报价单号" jdbcType="VARCHAR" property="报价单号" />
    <result column="销售顾问" jdbcType="VARCHAR" property="销售顾问" />
    <result column="顾客编号" jdbcType="INTEGER" property="顾客编号" />
    <result column="客户类型" jdbcType="CHAR" property="客户类型" />
    <result column="公司名称" jdbcType="VARCHAR" property="公司名称" />
    <result column="车型编号" jdbcType="INTEGER" property="车型编号" />
    <result column="库存编号" jdbcType="INTEGER" property="库存编号" />
    <result column="外观" jdbcType="VARCHAR" property="外观" />
    <result column="内饰" jdbcType="VARCHAR" property="内饰" />
    <result column="原价" jdbcType="DECIMAL" property="原价" />
    <result column="折后价" jdbcType="DECIMAL" property="折后价" />
    <result column="车辆备注" jdbcType="VARCHAR" property="车辆备注" />
    <result column="客户详细" jdbcType="INTEGER" property="客户详细" />
    <result column="金融A" jdbcType="INTEGER" property="金融a" />
    <result column="金融B" jdbcType="INTEGER" property="金融b" />
    <result column="金融C" jdbcType="INTEGER" property="金融c" />
    <result column="金融" jdbcType="INTEGER" property="金融" />
    <result column="金融所属经销商" jdbcType="VARCHAR" property="金融所属经销商" />
    <result column="金融战败原因编号" jdbcType="INTEGER" property="金融战败原因编号" />
    <result column="金融战败附加原因" jdbcType="VARCHAR" property="金融战败附加原因" />
    <result column="保险编号" jdbcType="INTEGER" property="保险编号" />
    <result column="新保准战败原因" jdbcType="VARCHAR" property="新保准战败原因" />
    <result column="新保战败原因编号" jdbcType="INTEGER" property="新保战败原因编号" />
    <result column="精品" jdbcType="INTEGER" property="精品" />
    <result column="费用编号" jdbcType="INTEGER" property="费用编号" />
    <result column="置换编号" jdbcType="INTEGER" property="置换编号" />
    <result column="延保编号" jdbcType="INTEGER" property="延保编号" />
    <result column="订单编号" jdbcType="INTEGER" property="订单编号" />
    <result column="交车" jdbcType="INTEGER" property="交车" />
    <result column="当前状态" jdbcType="VARCHAR" property="当前状态" />
    <result column="报价时间" jdbcType="TIMESTAMP" property="报价时间" />
    <result column="预计交车日期" jdbcType="DATE" property="预计交车日期" />
    <result column="更新账号" jdbcType="VARCHAR" property="更新账号" />
    <result column="更新时间" jdbcType="TIMESTAMP" property="更新时间" />
    <result column="初始报价单号" jdbcType="VARCHAR" property="初始报价单号" />
    <result column="是否还原点" jdbcType="CHAR" property="是否还原点" />
    <result column="还原点创建时间" jdbcType="TIMESTAMP" property="还原点创建时间" />
    <result column="是否驳回" jdbcType="CHAR" property="是否驳回" />
    <result column="驳回时间" jdbcType="TIMESTAMP" property="驳回时间" />
  </resultMap>
  <sql id="Base_Column_List">
    报价编号, 许可, 报价单号, 销售顾问, 顾客编号, 客户类型, 公司名称, 车型编号, 库存编号, 外观, 内饰, 原价, 折后价, 车辆备注, 客户详细, 
    金融A, 金融B, 金融C, 金融, 金融所属经销商, 金融战败原因编号, 金融战败附加原因, 保险编号, 新保准战败原因, 新保战败原因编号, 精品, 费用编号, 
    置换编号, 延保编号, 订单编号, 交车, 当前状态, 报价时间, 预计交车日期, 更新账号, 更新时间, 初始报价单号, 是否还原点, 还原点创建时间, 是否驳回, 
    驳回时间
  </sql>

<select id="selectHistoryOrder" parameterType="java.lang.Integer" resultMap="BaseResultMap">
SELECT
<include refid="Base_Column_List" />
FROM `报价单表` WHERE `初始报价单号` = ( SELECT `初始报价单号` FROM `报价单表`
WHERE `报价编号` = #{报价编号,jdbcType=INTEGER} ) AND `是否还原点` = '是'
ORDER BY `报价编号` DESC LIMIT 1
</select>

</maper>