# TimeHouse

**Repository Path**: lyl521/TimeHouse

## Basic Information

- **Project Name**: TimeHouse
- **Description**:  任务： 分析nginx log
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 2
- **Forks**: 0
- **Created**: 2019-03-22
- **Last Updated**: 2023-01-31

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# TimeHouse

#### Description
 任务： 分析nginx log

#### Software Architecture
Software architecture description

#### Installation

1. eclipse
2. springmvc
3. mybatis
4. bootstrap
5. mysql

#### Instructions

1. 这里是列表文本数据录入，将所有日志入库(数据库无要求，自己熟悉的即可)，按空格字段分割，只统计android，iphone的访问记录，其他记录忽略
2. 统计出URL访问前十并展示，url去掉query参数，即去掉?之后的所有内容
3. 统计访问最多的IP排行前十并展示
4. 统计android，ios占比，及各端版本占比并展示
5. 上面要求展示的不要求使用图展示，只用表格展示即可，如果有熟悉的图表可以使用，如(echarts, g2, d3,highcharts等)
6. 如果可以从日志中分析出其他内容或实现其他功能，也可以输出并说明
7. 时间上可以按照自己的工作来安排，实现完毕之后要求页面截图(或可访问地址)，数据库建表sql和代码片段都要回传回来(或有自己的github，gitbucket，coding，gitee等可查看地址也可以)
- nginx日志字段说明 
日志格式如下：‘请求机器IP(非需要的IP) | 一般为空 | 请求时间 | 请求体(方法 地址 HTTP版本) | host | 状态码 | 请求发送数据大小| refer | UA | 用户IP | 后端地址 | 后端状态码 | 后端响应时间 | 请求响应时间'
#### Contribution

1. 主页

![输入图片说明](https://gitee.com/uploads/images/2019/0405/221817_8e83754c_1997954.png "QQ截图20190405221721.png")

2. 表页面

![输入图片说明](https://gitee.com/uploads/images/2019/0405/211918_47853fcc_1997954.png "QQ截图20190405211733.png")

3. 图页面

![输入图片说明](https://gitee.com/uploads/images/2019/0405/211940_516ff237_1997954.png "QQ截图20190405211815.png")

4. 主要sql语句


```
	<!-- 添加日志 -->
	<insert id="addLog" parameterType="Log">
		insert into timehouse_log(requestMechineIP,requestTime,requestBody,host,statusCode,requestDataSize,refer,
UA,userIP,backgroundAddress,backgroundStatusCode,backgroundResponseTime,requestResponseTime)
			values(#{requestMechineIP},#{requestTime},#{requestBody},#{host},#{statusCode},#{requestDataSize},#{refer},#{UA},#{userIP},#{backgroundAddress},#{backgroundStatusCode},#{backgroundResponseTime},#{requestResponseTime})
	</insert>
	
	<!-- 统计总访问量 -->
	<select id="countTotalVisit" resultType="int">
		select count(*) from timehouse_log
	</select>
	<!-- 总IP数量 -->
	<select id="countUserIP" resultType="int">
		select count(t.userIP) from (select distinct userIP from timehouse_log) t		
	</select>
	<!-- 总Url量 -->
	<select id="countUrl" resultType="int">
		select count(t.requestBody) from (select distinct requestBody from timehouse_log) t
	</select>
	<!-- 状态吗 -->
	<!-- countStatusCode -->
	<select id="countStatusCode" resultType="int">
		select count(t.statusCode) from (select distinct statusCode from timehouse_log) t
	</select>
	<!-- 统计android,iphone的访问记录，其他记录忽略 -->
	<select id="countByUA_AndroidandIphnoe" parameterType="Log" resultType="int">
		select count(*) from timehouse_log
		where UA like CONCAT('%',#{UA},'%')	
	</select>
	<!-- 模糊查找 -->
	<select id="getLogListByUA_AndroidandIphnoe" parameterType="Log" resultType="Log">
		select * from timehouse_log
		where UA like CONCAT('%',#{UA},'%')	
	</select>
	<!--  统计URL访问前十 -->
	<select id="urlTop10" resultType="String">
        SELECT requestBody from timehouse_log
    </select>
    
	<select id="getUrlTopTen" resultType="String">
		select requestBody,count(requestBody)
		from timehouse_log 
		group by requestBody 
	    order by count(requestBody) DESC limit 10              		
	</select>
	<!--  统计IP访问前十 -->
	<select id="getUserIPTopTen" resultType="java.util.TreeMap">
		select userIP,count(userIP)
		from timehouse_log 
		group by userIP 
	    order by count(userIP) DESC limit 10              		
	</select>
```


#### Gitee Feature

1. You can use Readme\_XXX.md to support different languages, such as Readme\_en.md, Readme\_zh.md
2. Gitee blog [blog.gitee.com](https://blog.gitee.com)
3. Explore open source project [https://gitee.com/explore](https://gitee.com/explore)
4. The most valuable open source project [GVP](https://gitee.com/gvp)
5. The manual of Gitee [https://gitee.com/help](https://gitee.com/help)
6. The most popular members  [https://gitee.com/gitee-stars/](https://gitee.com/gitee-stars/)