查询操作日志

whyclxw

2020-11-07 7ba5d965710a0c3796978f3e5ec1a7ed2932c945

查询操作日志

 DyEnvir_system/src/com/fgkj/actions/User_logAction.java

@@ -14,19 +14,11 @@
    
    //5.4用户操作记录查询(根据用户名和操作类型以及操作时间)
    public String serchByCondition(){
        User_log ulog = ActionUtil.getGson("yyyy-MM-dd HH:mm:ss").fromJson(result, User_log.class);
        User_log ulog = ActionUtil.getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, User_log.class);
        ServiceModel model=service.serchByCondition(ulog);
        result=ActionUtil.tojson(model);
        return SUCCESS;
    }
	
    //查询所有的用户操作记录
    public String searchAll(){
        ServiceModel model=service.searchAll();
        result=ActionUtil.tojson(model);
        return SUCCESS;
    }


    public String getResult() {
        return result;
@@ -35,6 +27,9 @@
    public void setJson(String json) {
        this.json = json;
    }
	





}

 DyEnvir_system/src/com/fgkj/dao/impl/User_logImpl.java

@@ -83,68 +83,76 @@
        return list;
    }
    
    //5.4用户操作记录查询(根据用户名和操作类型)
    //用户操作记录查询(根据用户名和操作类型)
    public List serchByCondition(Object obj) {
            User_log ulog=(User_log) obj;
            String sql="";
            String numberSql=" SELECT FOUND_ROWS() number";
            Connection conn=DBUtil.getConn();
            String baseSql = "select SQL_CALC_FOUND_ROWS tb_user_log.uId,uoprateType,uoprateDay,uterminalIp,uoprateMsg" +
                    ",tb_user_inf.uName " +
                    "from db_equip_user.tb_user_inf,db_equip_user.tb_user_log " +
                    "where tb_user_inf.uId=tb_user_log.uId  " +
                    "and tb_user_inf.uName like ?" +
                    "and (uoprateDay)>(?) " +
                    "and (uoprateDay)<(?) ";
            String sqlT="and uoprateType=?";
            String sqlF="and uoprateType!=?";
			
            if(ulog.getuOprateType()==0){
                sql=baseSql+sqlF;
            }else{
                sql=baseSql+sqlT;
            }
            String endsql = "   ORDER BY uOprateDay DESC ";
            sql= sql+endsql;
            String limitSql=" limit ?,? ";
            sql+=limitSql;
            List<User_log> list = DAOHelper
                    .executeQueryLimit(sql, conn, new Object[]{"%"+ulog.getuName()+"%",ulog.getuOprateDay(),ulog.getuOprateDay1(),ulog.getuOprateType(),(ulog.getPage().getPageCurr() - 1)* ulog.getPage().getPageSize(),
                            ulog.getPage().getPageSize()
              },new CallBack() {
						
                        public List getResults(ResultSet rs) {
                            List list=new ArrayList();
                            try {
                                while(rs.next()){
                                    User_log ulog=new User_log();
                                    ulog.setuId(rs.getInt("uId"));
                                    ulog.setuName(rs.getString("uName"));
                                    ulog.setuOprateType(rs.getInt("uOprateType"));
                                    ulog.setuOprateDay(rs.getTimestamp("uOprateDay"));
                                    ulog.setuTerminalIp(rs.getString("uTerminalIp"));
                                    ulog.setuOprateMsg(rs.getString("uOprateMsg"));
									
                                    Page page=new Page();
                                    ulog.setPage(page);
                                    list.add(ulog);
                                }
                            } catch (SQLException e) {
                                // TODO Auto-generated catch block
                                e.printStackTrace();
                            } 
                            return list;
                        }
                    });
			
            //去掉limit条件后的总数
            int number=LimitNumberFactory.GetLimtitNumber(conn, numberSql);
            //System.out.println("number: "+number);
            if(list!=null&&list.size()>0){
                list.get(list.size()-1).getPage().setPageAll(number);
            }
            return list;
        User_log ulog=(User_log) obj;
        String sql="";
        String numberSql=" SELECT FOUND_ROWS() number";
        Connection conn=DBUtil.getConn();
        String baseSql = "select SQL_CALC_FOUND_ROWS tb_user_log.uId,uoprateType,uSystemType,uoprateDay,uterminalIp,uoprateMsg" +
                ",tb_user_inf.uName " +
                "from db_user.tb_user_inf,db_user.tb_user_log " +
                "where tb_user_inf.uId=tb_user_log.uId  " +
                //"and tb_user_inf.uName like ?" +
                "and (uoprateDay)>=(?) " +
                "and (uoprateDay)<=(?) ";
        //操作
        String sqlT=" and uoprateType=? ";
        String sqlF=" and uoprateType!=? ";
        if(ulog.getuOprateType()==0){
            sql=baseSql+sqlF;
        }else{
            sql=baseSql+sqlT;
        }
        //设备类型 
        String sql_devT=" and uSystemType=? ";
        String sql_devF=" and uSystemType!=? ";
        if(ulog.getuSystemType()==0){
            sql+=sql_devF;
        }else{
            sql+=sql_devT;
        }
        String endsql = "   ORDER BY uOprateDay DESC ";
        sql= sql+endsql;
        String limitSql=" limit ?,? ";
        sql+=limitSql;
        //System.out.println(sql);
        List<User_log> list = DAOHelper.executeQueryLimit(sql, conn, new Object[]{ulog.getuOprateDay(),ulog.getuOprateDay1(),ulog.getuOprateType(),ulog.getuSystemType(),(ulog.getPage().getPageCurr() - 1)* ulog.getPage().getPageSize(),
                        ulog.getPage().getPageSize()
          },new CallBack() {
					
                    public List getResults(ResultSet rs) {
                        List list=new ArrayList();
                        try {
                            while(rs.next()){
                                User_log ulog=new User_log();
                                ulog.setuId(rs.getInt("uId"));
                                ulog.setuName(rs.getString("uName"));
                                ulog.setuOprateType(rs.getInt("uOprateType"));
                                ulog.setuOprateDay(rs.getTimestamp("uOprateDay"));
                                ulog.setuSystemType(rs.getInt("uSystemType"));
                                ulog.setuTerminalIp(rs.getString("uTerminalIp"));
                                ulog.setuOprateMsg(rs.getString("uOprateMsg"));
                                Page page=new Page();
                                ulog.setPage(page);
                                list.add(ulog);
                            }
                        } catch (SQLException e) {
                            // TODO Auto-generated catch block
                            e.printStackTrace();
                        } 
                        return list;
                    }
                });
		
        //去掉limit条件后的总数
        int number=LimitNumberFactory.GetLimtitNumber(conn, numberSql);
        //System.out.println("number: "+number);
        if(list!=null&&list.size()>0){
            list.get(list.size()-1).getPage().setPageAll(number);
        }
        return list;
    }
    
    


 DyEnvir_system/src/com/fgkj/services/User_logService.java

@@ -61,33 +61,26 @@
            model.setCode(1);
            model.setMsg("删除成功!");
        } else {
            model.setCode(0);
            model.setMsg("删除失败!");
        }
        return model;
    }
    //5.4用户操作记录查询(根据用户名和操作类型)
    //用户操作记录查询(根据用户名和操作类型)
    public ServiceModel serchByCondition(Object obj) {
        List list = dao.serchByCondition(obj);
        if (list != null && list.size() > 0) {
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功!");
        }else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }

    public ServiceModel searchAll() {
        List list = dao.searchAll();
//        for (Object object : list) {
//            System.out.println(object);
//        }
        // System.out.println(list);
        if (list != null && list.size() > 0) {
            model.setCode(1);
            model.setData(list);
        }
        return model;
    }