ㄓㄤㄑㄧㄤ

js自动补全实例

var oInputField ,oPopDiv , oColorsUl,aColors;  
//初始化变量 
function initVars(modelId,divId,ulId){
    oInputField = document.getElementById(modelId);
    oPopDiv = document.getElementById(divId);
    oColorsUl = document.getElementById(ulId);
}

//查机种、料号 自动补全
function findModel(div_id,ul_id,model_id,form_id,p_cbo_id){
     var keyCode = event.keyCode;
     var arrayStr ='';
    initVars(model_id,div_id,ul_id);
    var aResult = new Array();  //用于存放匹配结果
    var params = document.getElementById(model_id).value; //序列化表格数据"myForm1"为表格的id
    if((keyCode >= 65 && keyCode <= 90) || (keyCode >= 48 && keyCode <= 57) || keyCode == 8 || keyCode == 46){//要过滤的键位 字母、数字、删除键
        if(oInputField.value.length >= 2){//超过两位开始查
        $.ajax({
            type:'post',
            data:{'modelName':params},
            dataType:'json',
            url:'queryPart.action',
            success:function(data) {
                   if(data == "error" || data == null || data == ""){
                    clearModel();
                    return;
                }
                document.getElementById(div_id).style.display = 'block';
                $.each(data,function(index,element){ 
                    arrayStr +=element.model_name+','+element.part_no+','+element.route_id+'$';
                });
                aResult = arrayStr.split("$");
                setModel(model_id,div_id,aResult,p_cbo_id);
            }
         });
        }else{
            clearModel();//无输入时清除提示框
        }
    }
 }
//清除提示内容
function clearModel(){
    for(var i = oColorsUl.childNodes.length - 1 ; i >= 0 ; i-- )
        oColorsUl.removeChild(oColorsUl.childNodes[i]);
    oPopDiv.className = "hide";
}
//设置自动补全数据  
function setModel(modelId,divId,the_models,p_cbo_id){
    //显示提示框、传入的参数即为匹配出来的结果组成的数组
    clearModel();//每输入一个字母就先清除原先的提示、再继续
    oPopDiv.className = "show";
    var oLi;
     
    for(var i = 0 ; i < the_models.length ; i++ ){
        //将匹配的提示结果逐一显示给用户
        oLi = document.createElement("li");
        oColorsUl.appendChild(oLi);
        oLi.appendChild(document.createTextNode(the_models[i]));
        
        oLi.onmouseover = function(){
            this.className = "mouseOver" ;  //鼠标指针经过时高亮
        }
        oLi.onmouseout = function(){
            this.className = "mouseOut" ;   //鼠标指针离开时恢复原样
        }
        oLi.onclick = function(){
            //用户单击某个匹配项时、设置输入框为该项的值
            oInputField.value = this.firstChild.nodeValue;
            clearModel();//同时清除提示框
            document.getElementById(divId).style.display = 'none';
            getProcessNames(modelId,p_cbo_id);
        }
    }
}

JSP代码:

<s:textfield title="请输入机种关键字,至少两位"  name="modelName" size="30" id="model_id" onkeyup="findModel('popup_wip','model_colors_ul_wip',this.id,'queryWIPForm','p_cbo_id_wip');" cssClass="required"></s:textfield>
<div id="popup_wip">  
    <ul id="model_colors_ul_wip"></ul>
</div>

CSS样式代码

<style>
        <!--
        #popup_wip{
            /*提示框div块的样式*/
            position: absolute; width: 200px;
            color: #004a7e; font-size: 12px;
            font-family: Arial,Helvetica,sans-serif;
            left: 43px; top: 28px;
            background-color: #E6EAE9;
            overflow:auto;
            height: 50px;
            display: none;
        }
        #popup_wip.show{
            /*显示提示框的边框*/
            border: 1px solid #004a7e;
        }
        #popup_wip.hide{
            /*隐藏提示框的边框*/
            border: none;
        }
        /*提示框的样式风格*/
        ul{
            list-style: none;
            margin: 0px; padding: 0px;
        }
        li.mouseOver{
            background-color: #004a7e;
            color: #FFFFFF;
        }  
        li.mouseOut{
            background-color: #FFFFFF;
            color: #004a7e;
        }
        -->
    </style>

Action代码:

private List<Map<String,Object>> listParts;
public
void queryPart(){ IQueryDAO query = new IQueryDAOImpl(); listPartMaps = query.queryPart(modelName.toUpperCase()); JSONArray jsonArray = JSONArray.fromObject(listPartMaps); try { ServletActionContext.getResponse().getWriter().print(jsonArray); } catch (IOException e) { e.printStackTrace(); } }

DAO代码:

    public List<Map<String,Object>> queryPart(String modelName) {
        db = new DBManager();
        String sql ="select part_id,model_name,part_no,route_id from sajet.sys_part where upper(model_name) like upper(?) and enabled ='Y'  ORDER BY MODEL_NAME";
        List<Map<String,Object>> listPart = new ArrayList<Map<String,Object>>();
        try {
            connection = db.GetOraConnection();
            pstmt = connection.prepareStatement(sql);
            pstmt.setString(1, modelName+"%");
            rs = pstmt.executeQuery();
            while(rs.next()){
                Map<String,Object> map = new HashMap<String,Object>();
                map.put("part_id", rs.getInt("part_id"));
                map.put("model_name", rs.getString("model_name"));
                map.put("route_id", rs.getInt("route_id"));
                map.put("part_no", rs.getString("part_no"));
                listPart.add(map);
            }
        } catch (SQLException e) {
            log.error("查询机种时出错:"+e.getMessage());
            e.printStackTrace();
        }finally{
            db.closeConnection(connection, rs, pstmt);
        }
        return listPart;
    }

 

posted @ 2014-11-27 08:24  ㄓㄤㄑㄧㄤ  阅读(3786)  评论(1编辑  收藏  举报
哈哈,页脚部分。