terminalmessagedetailquerier.java

oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码

/*
 * TerminalMessageDetailQuerier.java
 *
 * Created on 2007年3月1日, 下午2:26
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package com.huashi.util;

import java.sql.SQLException;
import java.util.Date;

/**
 *
 * @author dell
 */
public class TerminalMessageDetailQuerier extends AbstractTerminalMessageQuerier {
    
    /** Creates a new instance of TerminalMessageDetailQuerier */
    public TerminalMessageDetailQuerier() {
        columnLabels = new String[]{"日期时间", "命令", "命令描述", "消息参数", "I/O", "经由", "操作人", "中心", "SIM"};
    }

    public void query() throws SQLException {
        if (connection == null) {
            throw new SQLException("No DB connection!");
        }
        
        buildStatement();
        
        resultSet = statement.executeQuery(sql);

    }

    protected void buildStatement() throws SQLException {

        processParameters();
        
        sql = "SELECT msg_date," +
                   "msg_cmd," +
                   "cmd_desc," +
                   "msg_para," +
                   "io,via," +
                   "admin_nm," +
                   "center_nm, " +
                   "(SELECT tmnl_sim " +
                     "FROM asc_tmnl_msg_detail_tbl " +
                    "WHERE msg_id = t.msg_id) AS tmnl_sim " +
               "FROM asc_tmnl_msg_io_tbl t " +
              "WHERE t.msg_date BETWEEN to_date('" + DateUtil.format(dateFrom, "yyyyMMddHHmmss") + "','yyyymmddhh24miss') " +
                "AND to_date('" + DateUtil.format(dateTo, "yyyyMMddHHmmss") + "','yyyymmddhh24miss') " +
                "AND t.tmnl_id = '" + tmnlId + "' " +
                ioCon + viaCon;
        
        statement = connection.createStatement();

    }

    public void processParameters() {
        
        super.processParameters();
        
    }


    
}