艳辉网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