艷輝網V3.0之登錄系統

2019-11-11 03:38:10

字體：大中小

來源：轉載

供稿：網友

1、前言

不是真的登錄驗證，而是假裝登錄，然后根據登錄的數據進行分析匯總成報表。

2、技術

1、使用java讀取txt的內容，獲取QQ號和郵箱地址。 2、使用echart做用戶粘度報表，用戶活躍度報表，用戶惡意登錄報表。

3、實現

1、獲取QQ群里的QQ號

if(!lineTxt.equals("")){ if(lineTxt.startsWith("(")){ lineTxt = lineTxt.replace("(", ""); lineTxt = lineTxt.replace(")", ""); qqNum = lineTxt; Connection con = dbUtil.getConnection(); // 獲取連接 String sql = "insert into qqnum values(null,?,?,now(),?,1)"; PReparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, qqName); pstmt.setString(2, qqNum); pstmt.setString(3, search); int result = pstmt.executeUpdate(); dbUtil.closeResources(con, pstmt, null); if(result==1){ System.out.println("添加"+qqNum+"成功！"); }else{ System.out.println("添加"+qqNum+"失敗！"); } }else{ qqName = lineTxt; } }

2、獲取文本中的郵箱地址

String txt=lineTxt; Matcher matchr = emailer.matcher(txt); while (matchr.find()) { String email = matchr.group(); if(email.contains("@qq.com")){ String qq = email.replace("@qq.com", "");// System.out.println(qq); Connection con = dbUtil.getConnection(); // 獲取連接 String sql = "insert into qqnum values(null,null,?,now(),?,1)"; PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, qq); pstmt.setString(2, search); int result = pstmt.executeUpdate(); dbUtil.closeResources(con, pstmt, null); if(result==1){ System.out.println("添加"+qq+"成功！"); }else{ System.out.println("添加"+qq+"失敗！"); } } }

1、用戶粘度報表sql語句

SELECT u.username,count(log.id) as num FROM loginlog logLEFT JOIN user u on u.id = log.userIdwhere log.type = 0 and status = 1GROUP BY u.usernameORDER BY num DESC

2、用戶活躍度報表sql語句

select * FROM(SELECT u.username,count(log.id) as num FROM loginlog logLEFT JOIN user u on u.id = log.userIdwhere log.type = 0 and status = 1and date_format(log.createTime,'%Y-%m')=date_format(now(),'%Y-%m') GROUP BY u.usernameORDER BY num DESC ) Awhere A.num > 15

3、用戶惡意登錄報表sql語句

select * FROM(SELECT u.username,count(log.id) as num FROM loginlog logLEFT JOIN user u on u.id = log.userIdwhere log.type = 0 and status = 0and date_format(log.createTime,'%Y-%m')=date_format(now(),'%Y-%m') GROUP BY u.usernameORDER BY num DESC ) Awhere A.num > 6