輸入框搜索功能的實(shí)現(xiàn)

先寫(xiě)輸入框：

<label class="col-md-1 control-label" for="txtRDKeyWord">關(guān)鍵字</label>
    <div class="col-md-9">
        <input type="text" id="txtRDKeyWord" class="form-control" autocomplete="off" placeholder="請(qǐng)輸入病歷號(hào)/門(mén)診號(hào)關(guān)鍵字"/>
    </div>
    <div class="col-sm-2">
        <button id="btnRDSearch" class="btn btn-block btn-pink">搜索</button>
    </div>

按鈕觸發(fā)事件及function方法(window.open為打開(kāi)新的頁(yè)面具體頁(yè)面后續(xù))：

$("#btnRDSearch").click(reserveDetail.loadReserve);

//搜索關(guān)鍵字
reserveDetail.loadReserve = function(){
    var sUrl = "reserveAction_loadReserve";
    var objParams = { "hasLoading": false, "cvoParameter.keyWord": $("#txtRDKeyWord").val()};
        commonJs.openAjax(sUrl, objParams,function(data){
            if (!data.success) {
                commonJs.openDialog("error", data.message);
            } else {
                var lstResult = data.lstResult;
                if (typeof(lstResult) =="undefined") {
                    commonJs.openDialog("error", "無(wú)查詢(xún)結(jié)果請(qǐng)重新輸入！");
                } else {
                    if (lstResult.length == 1) {
                        var sId = lstResult[0].id;
                        var sMrn = lstResult[0].medicalRecordNumber;
                        var sCn = lstResult[0].clinicNumber;
                        var sOrderId = lstResult[0].orderId;
                        var sTargetId = lstResult[0].targetId;
                        window.open(BASE_PATH + "/spv2/nurse/reserve/reserve_detail.jsp?id="+sId+"&mrn="+sMrn+"&cn="+sCn+"&oid="+sOrderId+"&tid="+sTargetId);
                    } else if (lstResult.length > 1){
                        commonJs.openDialog("warning","查詢(xún)數(shù)據(jù)條數(shù)為"+lstResult.length+",請(qǐng)重新輸入！");
                        return;
                    }
                }
            }
        });
}

在commonJs中已經(jīng)封裝好openAjax、openDialog方法了：

//打開(kāi)ajax請(qǐng)求(請(qǐng)求地址, 參數(shù), 成功后回調(diào)的函數(shù), 失敗后回調(diào)的函數(shù))
commonJs.openAjax = function(sUrl, vParams, funSuccess, funError) {
    if (sUrl == null || sUrl == '') return false;
    // 默認(rèn)顯示加載層，如果不需要，請(qǐng)?jiān)O(shè)置vParams.hasLoading為false
    var hasLoading = true;
    if (vParams != null && vParams.hasLoading == false) { hasLoading = false; }
    if (hasLoading) { commonJs.openLoadDialog(); }
    $.ajax({
        url:        sUrl,
        data:       vParams,
        type:       'POST',
        dataType:   'json',// xml,html,script,json,jsonp
        timeout:    30 * 60 * 1000,
        success:    function(data) {
            if (hasLoading) { commonJs.closeLoadDialog(); }
            if (data != null && data.code == "login"){
                commonJs.openDialog("error", data.message, function(){
                    location.href = BASE_PATH + "/spv2/login.jsp?returnUrl=" + commonJs.enReturnUrl();
                });
            }else{
                funSuccess(data);
            }
        },
        error:      funError
    });
};

// 打開(kāi)頁(yè)面對(duì)話(huà)框
commonJs.openPageDialog = function(par) {
    if (par != null && par.closable == null) { par.closable = false; }
    if (par != null && par.lg != null && par.lg == true) {
        par.lg = BootstrapDialog.SIZE_WIDE;
    } else {
        par.lg = BootstrapDialog.SIZE_NORMAL;
    }
    var dialog = new BootstrapDialog({
        id:     par.id,// 窗口id
        title:  par.title,// 標(biāo)題
        size:   par.lg,// 是否大窗口
        closable: par.closable,// 是否可關(guān)閉（默認(rèn)為不關(guān)閉）
        closeByKeyboard: par.closable,// 是否可用Esc關(guān)閉窗口（與closable一致）
        message: function(dialog) {
            var $message = $('<div><i class="fa fa-spinner fa-spin loading" style="font-size:24px;"></i><span style="font-size:16px;">?加載中，請(qǐng)稍候...</span></div>');
            setTimeout(function() {
                if (par.url == null || par.url == '') return;
                if (par.url.indexOf('?') > -1) {
                    // par.url += '&ran=' + Math.random();
                } else {
                    // par.url += '?ran=' + Math.random();
                }
                $message.load(par.url, par.data, function() { });
            }, 500);
            return $message;
        },
        buttons: par.buttons
    }).open();
    return dialog;
}

編寫(xiě)action方法：

    IReserve funReserve = FunFactory.getReserve();
    /**
     * 加載預(yù)約就診客戶(hù)
     * @return
     */
    @IAccess(competenceNumber = { GlobalCache.UserRole.SPD }, returnFormat = GlobalCache.JSON)
    public void loadReserve() {
        MessageVo mvoResult = new MessageVo();
        CommonVo cvoParams = getCvoParameter();
        if ("".equals(cvoParams.getKeyWord()) || cvoParams.getKeyWord() == null) {
            mvoResult.setSuccess(false);
            mvoResult.setMessage("輸入關(guān)鍵字不能為空!");
        } else {
            mvoResult = funReserve.pageListReserve(cvoParams);
        }
        this.outJson(mvoResult);
    }

commonVo為公共值對(duì)象，MessageVo 為返回值對(duì)象，立面包含你所要傳輸?shù)闹祵?duì)象。
funReserve 為FunFactory的獲取對(duì)象。
pageListReserve方法為：

/**
     * 獲取預(yù)約確認(rèn)列表
     */
    public MessageVo pageListReserve(CommonVo cvoParams) {
        String sSql = "";
        cvoParams.setIsPay("1");// 已付款
        sSql += CommonBean.getRangeCondition(cvoParams.getRange(), "reserve_date", "4");
        if (!"".equals(cvoParams.getKeyWord()) && cvoParams.getKeyWord() != null) {
            sSql += " and (CLINIC_NUMBER LIKE '%" + cvoParams.getKeyWord() + "%' OR MEDICAL_RECORD_NUMBER LIKE '%" + cvoParams.getKeyWord() + "%' OR TARGET_NAME LIKE '%" + cvoParams.getKeyWord()
                    + "%')";
            sSql += " and (DOCTOR_ID = '" + cvoParams.getDoctorId() + "' OR DOCTOR_ID IS NULL)";
        }
        cvoParams.setSql(sSql);
        cvoParams.setOrderBy("order by DOCTOR_ID,RESERVE_DATE,QUEUE_ID");
        return tdoReserveOrder.getList(cvoParams);
    }

封裝好的dao包(盡量不要修改這文件)：

@Repository("VReserveOrderViewDao")
public class VReserveOrderViewDao extends DaoSupport implements IViewDao {
    private static String TABLE_NAME = "VReserveOrder";

    public MessageVo getList(CommonVo cvoSelect) {
        String sHql = "from " + TABLE_NAME + " where 1=1 ";// 查詢(xún)語(yǔ)句
        String sCount = "select count(*) from " + TABLE_NAME + " where 1=1 ";// 分頁(yè)語(yǔ)句
        MessageVo mvoResult = new MessageVo();
        try {
            Object[] objParameter = null;
            ArrayList<Object[]> arrParameter = new ArrayList<Object[]>();
            // 設(shè)置搜索條件
            objParameter = new Object[] { " and id = ? ", cvoSelect.getId() };
            arrParameter.add(objParameter);// 編號(hào)
            objParameter = new Object[] { " and order_number like ? ", "%" + cvoSelect.getOrderNumber() + "%" };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and medical_record_number like ? ", "%" + cvoSelect.getMedicalRecordNumber() + "%" };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and target_id = ? ", cvoSelect.getTargetId() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and customer_id = ? ", cvoSelect.getCustomerId() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and target_name like ? ", "%" + cvoSelect.getTargetName() + "%" };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and room_id = ? ", cvoSelect.getRoomId() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and room_name like ? ", "%" + cvoSelect.getRoomName() + "%" };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and doctor_name like ? ", "%" + cvoSelect.getDoctorName() + "%" };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and reserve_type = ? ", cvoSelect.getReserveType() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and order_status = ? ", cvoSelect.getOrderStatus() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and evaluate_status = ? ", cvoSelect.getEvaluateStatus() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and is_pay = ? ", cvoSelect.getIsPay() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and reserve_mode = ? ", cvoSelect.getReserveMode() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and create_time >= ? ", cvoSelect.getBeginTime() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and create_time <= ? ", cvoSelect.getEndTime() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and sp_id = ? ", cvoSelect.getSpId() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and service_mode = ? ", cvoSelect.getServiceMode() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and is_book_time = ? ", cvoSelect.getIsBookTime() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and is_deduct = ? ", cvoSelect.getIsDeduct() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and clinic_type = ? ", cvoSelect.getClinicType() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and create_name like ? ", "%" + cvoSelect.getCreateName() + "%" };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and is_delete = ? ", cvoSelect.getIsDelete() };
            arrParameter.add(objParameter);// 是否已刪除

            // 將參數(shù)傳入到分頁(yè)Bean中
            String[] sHqlArr = { sHql, sCount, cvoSelect.getSql(), cvoSelect.getOrderBy() };
            int[] iInfoArr = { cvoSelect.getPageNum(), cvoSelect.getLimitNum(), cvoSelect.getForUpdateWait() };
            SpringPageBean spbQuery = new SpringPageBean(sHqlArr, iInfoArr, arrParameter, getCustomSession());;
            List<?> lstResult = (List<?>) getHibernateTemplate().execute(spbQuery);
            mvoResult.setSuccess(true);
            mvoResult.setLstResult(lstResult);
            mvoResult.setTotalPage(spbQuery.getTotalPage());
            mvoResult.setTotalSize(spbQuery.getTotalNum());
        } catch (Exception e) {
            e.printStackTrace();
        }
        // 返回搜索結(jié)果
        return mvoResult;
    }

    public CommonVo getOne(CommonVo cvoSelect) {
        String sHql = "from " + TABLE_NAME + " where 1=1 ";// 查詢(xún)語(yǔ)句
        CommonVo cvoResult = null;
        try {
            Object[] objParameter = null;
            ArrayList<Object[]> arrParameter = new ArrayList<Object[]>();
            // 設(shè)置排序和是否刪除的默認(rèn)值
            if (cvoSelect.getOrderBy() == null || "".equals(cvoSelect.getOrderBy())) {
                cvoSelect.setOrderBy(" order by id desc");
            }
            // 設(shè)置搜索條件
            objParameter = new Object[] { " and id = ? ", cvoSelect.getId() };
            arrParameter.add(objParameter);// 編號(hào)
            objParameter = new Object[] { " and order_number = ? ", cvoSelect.getOrderNumber() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and medical_record_number = ? ", cvoSelect.getMedicalRecordNumber() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and target_id = ? ", cvoSelect.getTargetId() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and room_id = ? ", cvoSelect.getRoomId() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and sp_id = ? ", cvoSelect.getSpId() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and doctor_id = ? ", cvoSelect.getDoctorId() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and doctor_name like ? ", "%" + cvoSelect.getDoctorName() + "%" };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and reserve_type = ? ", cvoSelect.getReserveType() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and order_status = ? ", cvoSelect.getOrderStatus() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and customer_id = ? ", cvoSelect.getCustomerId() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and service_mode = ? ", cvoSelect.getServiceMode() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and clinic_type = ? ", cvoSelect.getClinicType() };
            arrParameter.add(objParameter);//
            objParameter = new Object[] { " and is_delete = ? ", cvoSelect.getIsDelete() };
            arrParameter.add(objParameter);// 是否已刪除
            // 將參數(shù)傳入到分頁(yè)Bean中
            String[] sHqlArr = { sHql, null, cvoSelect.getSql(), cvoSelect.getOrderBy() };
            int[] iInfoArr = { 1, 1 };
            SpringPageBean spbQuery = new SpringPageBean(sHqlArr, iInfoArr, arrParameter, getCustomSession());;
            // 搜索數(shù)據(jù)
            List<?> lstResult = (List<?>) getHibernateTemplate().execute(spbQuery);
            if (lstResult != null && lstResult.size() > 0) {
                cvoResult = (CommonVo) lstResult.get(0);
                getHibernateTemplate().evict(cvoResult);// 分離對(duì)象
                lstResult.clear();
            }
            // 清空參數(shù)
            lstResult = null;
            arrParameter.clear();
            arrParameter = null;
            objParameter = null;
        } catch (Exception e) {
            e.printStackTrace();
        }
        // 返回搜索結(jié)果
        return cvoResult;
    }

}
最后編輯于 ：
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請(qǐng)聯(lián)系作者
【社區(qū)內(nèi)容提示】社區(qū)部分內(nèi)容疑似由AI輔助生成，瀏覽時(shí)請(qǐng)結(jié)合常識(shí)與多方信息審慎甄別。
平臺(tái)聲明：文章內(nèi)容（如有圖片或視頻亦包括在內(nèi)）由作者上傳并發(fā)布，文章內(nèi)容僅代表作者本人觀點(diǎn)，簡(jiǎn)書(shū)系信息發(fā)布平臺(tái)，僅提供信息存儲(chǔ)服務(wù)。

相關(guān)閱讀更多精彩內(nèi)容

友情鏈接更多精彩內(nèi)容