报表中的导入操作

function exportIn(){
    with(document.getElementById("nameInfo")){
        action = "<%=strContext%>/pretreament/exportAction.do?method=specExportIn";
        method = "post";
        enctype="multipart/form-data";
        submit();
    }
}

<input type="button" value=">>>开始  onclick="exportIn()" />

/** 通过specIn.jsp跳转 通过剂型标准化 Excel导入 (liyc添加) */
    public ActionForward specExportIn(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse response)
    throws Exception {
        System.out.println("+++++++++++++++++++++++++++++++++++++++in_expore_action++++++++");
        try {
            String med_type = (String)request.getSession(true).getAttribute("med_type");
            String taskId = (String) request.getSession(true).getAttribute("taskId");
            String filePath = "" + request.getRealPath("/")
            + "\\jsp\\pretreament\\fileUpload";
            String path = p.uploadFile(form, request, filePath); // 文件的路径
            String result = biz.specExportIn(path, med_type,taskId); // 导入excel
            int num_insert = 0;
            int num_update = 0;
            if(result!=null && !result.trim().equals("")&& !result.trim().equals("0,0")){
                String[] temp = result.split(",");
                num_insert = Integer.parseInt(temp[0]);
                num_update = Integer.parseInt(temp[1]);
            }
            IStandardService sBiz = new StandardServiceImpl();
            ParamUtils pu = new ParamUtils();
            CriterionInfo c = new CriterionInfo();
            String userName = (String) pu.getSessionObject(request, "userNm");
            c.setUserId(userName);
            c.setTitle("PRE_CRITERIONSPEC");
            c.setTaskId(taskId);
            c.setOpeLink("1");
            c.setMedType(med_type);
            c.setTotal(String.valueOf(num_update));
            System.out.println("result===>>>>"+result);
            // 如果插入结果返回值等于0，就不会插入
            if (result!=null && !result.trim().equals("")&& !result.trim().equals("0,0")) {
                sBiz.saveCriterionLog(c); // 添加规则导入日志
                Cronlog cronlog = new Cronlog();
                cronlog.setLogMisId(taskId);
                cronlog.setLogContent("更新规则到剂型全匹配规则库，共添加数据"+num_insert+"条；更新数据"+num_update+"条");
                cronlog.setLogUserId(userName);
                cronlog.setLogModule("2"); // 2：剂型标准化
                cronlog.setLogFlag("1");
                cronlog.setMedType(med_type);
                dLog.createDiary(cronlog);
            }
            /************ 删除服务器上缓存文件 ***********/
            p.deleteFile(filePath, path);
            /***************************/
        } catch (Exception e) {
            e.printStackTrace();
        }
        return new ActionForward(
        "/standardAction.do?method=getCriterionLog&opeLink=1");
    }


// 剂型标准化,导入Excel.【传入参数为：解读的文件路径和药品类型以及任务的ID】
    public String specExprotIn(String filename, String med_type,String taskId) throws Exception {
        Excel ex = new Excel();
        //        String[] list = null;
        String[] array = null;
        boolean result = false;
        int number = 0;
        int num_update = 0;
        PreUtils pu = new PreUtils();
        db = db.getDBTool();
        conn = db.getConn(dbSource);
        // excel总行数
        System.out.println("+++++++++++++++++++++++++++++++++++++++in_spec_daoImpl++++++++");
        int row = 0;
        String sql = "insert into PRE_CRITERIONSPEC(REP_SPEC,MEDNAME,SPEC,CONTENT,CONTENTUNIT,DOSAGE,DOSAGEUNIT,SCALAR,"
            + "PRODUCE_COM,CHARACT,WRAPPER,REST,CREATE_USER,DEPARTMENT,med_type) values("
            + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        /*增加一个更新语句*/
        String sql_update = "UPDATE PRE_CRITERIONSPEC SET SPEC = ? WHERE PRE_CRITERIONSPEC.REP_SPEC= ? and PRE_CRITERIONSPEC.MED_TYPE='"+med_type+"'";

        //增加一个剔除的语句
        String sql_delete = "update pre_standarddata set w_flag='1' where (rep_spec=? or rep_spec is null) and standardtask_id="+taskId+" and (med_type=? or med_type is null)";

        try {
            // 打开excel文件
            result = ex.openExcel(filename);
            if (result) {
                // 读excel文件0号工作薄
                row = ex.getRowCount(0);
                // 如果这个Excel行数 小于1 就返回.
                if (row < 1) {
                    result = false;
                } else {
                    // 执行SQL语句
                    System.out.println(row+"################################################ssss######################"+sql);
                    pst = conn.prepareStatement(sql);
                    //增加一个update预编译
                    pst_update = conn.prepareStatement(sql_update);
                    //增加一个update删除标识预编译
                    pst_delete =conn.prepareStatement(sql_delete);

                    for (int i = 1; i < row; i++) {
                        array = ex.getRowArray(i);
                        int len = array.length;
                        System.out.println(array[1] + "=1 " + array[2]
                                                                    + "=2 " + array[3] + "=3 " + array[4] + "=4 "
                                                                    + array[5] + " =5" + array[6] + "=6 "
                                                                    + array[7] + "=7 " + array[8] + "=8 "
                                                                    + array[9] + "=9 " + array[10] + "=10 "
                                                                    + array[11] + "=11 " + array[12] + " =12"   
                                                                    + array[13]+"=13"+array[14]+"=14"+array[15]+"=15"+array[17]);

                        if (len > 0&&array[14]!=null&&!array[14].trim().equals("")) {  
                            String mSql = "select * from PRE_CRITERIONSPEC where rep_spec='"
                                + array[2] + "' and med_type='"+pu.format5(array[1])+"'";
                            System.out.println(len+"========ddddd=1");
                            int num = pu.getNum(mSql);
                            if (num > 0) {
                                System.out.println("num====="+num);

                                //看有没有删除标识,有的话执行删除规则库操作
                                if(array[15]!=null&&array[15].trim().equals("1")){

                                    pst_delete.setString(1, pu.format4_yuchuli(array[2]));
                                    pst_delete.setString(2, pu.format4_yuchuli(array[1]));
                                    pst_delete.addBatch();
                                    /*看有没有修改标示,有的话执行更新规则库操作*/
                                }else if(array[17]!=null&&array[17].trim().equals("1")){

                                    System.out.println("*&*&*&*&");
                                    pst_update.setString(1, pu.format4(array[4]));
                                    pst_update.setString(2, pu.format4(array[2]));
                                    pst_update.addBatch();
                                    num_update++;

                                }
                                System.out.println(pu.format5(array[1])+"===="+array[2] + ":重复条目");
                            } else if (num == 0) {
                                number++;

                                pst.setString(1, pu.format3(array[2]));
                                pst.setString(2, pu.format4(array[3]));
                                pst.setString(3, pu.format4(array[4]));
                                pst.setString(4, pu.format4(array[5]));
                                pst.setString(5, pu.format4(array[6]));
                                pst.setString(6, pu.format4(array[7]));
                                pst.setString(7, pu.format4(array[8]));
                                pst.setString(8, pu.format4(array[9]));
                                pst.setString(9, pu.format4(array[10]));
                                pst.setString(10, pu.format4(array[11]));
                                pst.setString(11, pu.format4(array[12]));
                                pst.setString(12, pu.format4(array[13]));
                                pst.setString(13, pu.format4(array[14]));
                                pst.setString(14, pu.format4(array[15]));
                                pst.setString(15, pu.format5(array[1]));
                                pst.addBatch();
                            }
                        }
                    }
                    //piliang
                    pst_update.executeBatch();
                    pst.executeBatch();
                    pst_delete.executeBatch();
                }
            }
        } catch (Exception e) {
            number = 0;
            e.printStackTrace();
        } finally {
            this.closeRs();
        }
        return number+","+num_update;
    }



public final static String PRE_WHOLESALE_TOP[] = {"序号","上报药品名称","上报药品类别","医保序号","上报剂型","上报规格",
        "生产企业名称","最小零售单位","销售数量","销售价格","购进数量","购进价格","批发报送单位","调查年度","地域","标准药品类别","标准医保序号","标准药品名称","标准剂型",
         "标准含量", "标准含量单位", "标准装量","标准装量单位", "包装数量","包装数量单位", "标准生产企业名称", "性状", "包装材料", "其他",
         "标准地域名称","处室","原研定价", "单独定价", "统一定价"};