U 鲁星伟调试

whychw

2020-11-10 35fa8009a93a92c25a0c046d14f4dcd237e3f0af

U 鲁星伟调试

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

@@ -45,7 +45,7 @@
    //用户的操作记录下来
    public boolean add(Object obj) {
        User_log ulog=(User_log) obj;
        String sql="insert into db_equip_user.tb_user_log(uId,uOprateType,uSystemType,uOprateDay,uTerminalIp,uOprateMsg) values(?,?,?,?,?,?)";
        String sql="insert into db_user.tb_user_log(uId,uOprateType,uSystemType,uOprateDay,uTerminalIp,uOprateMsg) values(?,?,?,?,?,?)";
        Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ulog.getuId(),
            ulog.getuOprateType(),ulog.getuSystemType(),ulog.getuOprateDay(),ulog.getuTerminalIp(),ulog.getuOprateMsg()});
        return bl;
@@ -56,7 +56,7 @@
        ArrayList sql_strs=new ArrayList();
        if(list!=null&&list.size()>0){
            for (User_log ulog : list) {
                String sql="insert into db_equip_user.tb_user_log(uId,uOprateType,uOprateDay,uTerminalIp,uOprateMsg) values("+ulog.getuId()+","+ulog.getuOprateType()+",'"+DAOHelper.sdf.format(ulog.getuOprateDay())+"','"+ulog.getuTerminalIp()+"','"+ulog.getuOprateMsg()+"')";
                String sql="insert into db_user.tb_user_log(uId,uOprateType,uOprateDay,uTerminalIp,uOprateMsg) values("+ulog.getuId()+","+ulog.getuOprateType()+",'"+DAOHelper.sdf.format(ulog.getuOprateDay())+"','"+ulog.getuTerminalIp()+"','"+ulog.getuOprateMsg()+"')";
                sql_strs.add(sql);
            }
        }
@@ -70,13 +70,13 @@

    public boolean del(Object obj) {
        User_log ulog=(User_log) obj;
        String sql="delete from db_equip_user.tb_user_log where num=?";
        String sql="delete from db_user.tb_user_log where num=?";
        Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ulog.getNum()});
        return bl;
    }

    public List searchAll() {
        String sql = "select num,uId,uOprateType,uOprateDay,uTerminalIp,uOprateMsg from db_equip_user.tb_user_log order by (uOprateDay) desc";
        String sql = "select num,uId,uOprateType,uOprateDay,uTerminalIp,uOprateMsg from db_user.tb_user_log order by (uOprateDay) desc";
        List list = DAOHelper
                .executeQuery(sql, DBUtil.getConn(), null,
                        new User_logImpl());