添加控制操作日志记录功能

Administrator

2021-02-19 f7c8ccbaa43fdda57fd04cce5f409f1a99bde86b

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
package com.modbus.data; 
 
import java.sql.SQLException; 
import java.util.List; 
 
import com.base.Com; 
import com.sql.MysqlConnPool; 
import com.sql.Sql_Mysql; 
 
public class User_Log_SQL { 
     
    /** 
     * ¼Ç¼Óû§²Ù×÷ÈÕÖ¾ 
     * @param pool 
     * @param logs 
     */ 
    public static void recordUserLog(MysqlConnPool pool,List<User_Log> logs) { 
        String sql_str = "INSERT INTO " + Sql_Mysql.UserLogTable + "(uid,uOprateType,uOprateDay,uTerminalIp,uOprateMsg,uSystemType) VALUES"; 
        if(logs.size()>0) { 
            for(int i=0;i<logs.size();i++) { 
                User_Log log = logs.get(i); 
                if(i>0) { 
                    sql_str += ","; 
                } 
                sql_str += "("+log.getuId()+","+log.getuOprateType()+",'"+Com.getDateTimeFormat(log.uOprateDay, Com.DTF_YMDhms)+"','"+log.getuTerminalIp()+"','"+log.getuOprateMsg()+"',"+log.getuSystemType()+")"; 
            } 
            Sql_Mysql sql = new Sql_Mysql(pool.getConn()); 
            try { 
                //System.out.println(sql_str); 
                sql.sqlMysqlExecute(sql_str); 
            } catch (SQLException e) { 
                e.printStackTrace(); 
            } finally { 
                sql.close_con(); 
            } 
        } 
    }     
}