Skip to content

Commit ae9bfde

Browse files
lmxdawnlmxdawn
committed
初始化项目
0 parents  commit ae9bfde

File tree

18 files changed

+459
-0
lines changed

18 files changed

+459
-0
lines changed

‎.gitignore

Lines changed: 25 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,25 @@
1+
/target/
2+
!.mvn/wrapper/maven-wrapper.jar
3+
4+
### STS ###
5+
.apt_generated
6+
.classpath
7+
.factorypath
8+
.project
9+
.settings
10+
.springBeans
11+
.sts4-cache
12+
13+
### IntelliJ IDEA ###
14+
.idea
15+
*.iws
16+
*.iml
17+
*.ipr
18+
19+
### NetBeans ###
20+
/nbproject/private/
21+
/build/
22+
/nbbuild/
23+
/dist/
24+
/nbdist/
25+
/.nb-gradle/

‎dao/pom.xml

Lines changed: 42 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,42 @@
1+
<?xml version="1.0" encoding="UTF-8"?>
2+
<project xmlns="http://maven.apache.org/POM/4.0.0"
3+
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4+
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
5+
<parent>
6+
<artifactId>admin</artifactId>
7+
<groupId>com.lmxdawn</groupId>
8+
<version>0.0.1</version>
9+
</parent>
10+
<modelVersion>4.0.0</modelVersion>
11+
12+
<artifactId>dao</artifactId>
13+
14+
<dependencies>
15+
16+
<dependency>
17+
<groupId>org.mybatis.spring.boot</groupId>
18+
<artifactId>mybatis-spring-boot-starter</artifactId>
19+
<version>1.3.2</version>
20+
</dependency>
21+
22+
<dependency>
23+
<groupId>mysql</groupId>
24+
<artifactId>mysql-connector-java</artifactId>
25+
<scope>runtime</scope>
26+
</dependency>
27+
28+
<dependency>
29+
<groupId>com.alibaba</groupId>
30+
<artifactId>druid</artifactId>
31+
<version>1.1.12</version>
32+
</dependency>
33+
34+
<dependency>
35+
<groupId>com.lmxdawn</groupId>
36+
<artifactId>entity</artifactId>
37+
<version>${parent.version}</version>
38+
</dependency>
39+
40+
</dependencies>
41+
42+
</project>

‎dao/src/main/java/com/lmxdawn/admin/config/DruidConfiguration.java

Lines changed: 16 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,16 @@
1+
package com.lmxdawn.admin.config;
2+
3+
import com.alibaba.druid.pool.DruidDataSource;
4+
import org.springframework.boot.context.properties.ConfigurationProperties;
5+
import org.springframework.context.annotation.Bean;
6+
7+
import javax.sql.DataSource;
8+
9+
public class DruidConfiguration {
10+
11+
@Bean(name = "duridDatasource")
12+
@ConfigurationProperties(prefix = "spring.datasource")
13+
public DataSource druidDataSource() {
14+
return new DruidDataSource();
15+
}
16+
}

‎dao/src/main/java/com/lmxdawn/admin/config/DruidStatFilter.java

Lines changed: 18 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,18 @@
1+
package com.lmxdawn.admin.config;
2+
3+
import com.alibaba.druid.support.http.WebStatFilter;
4+
5+
import javax.servlet.annotation.WebFilter;
6+
import javax.servlet.annotation.WebInitParam;
7+
8+
/**
9+
* 配置监控拦截器 (过滤不需要监控的后缀)
10+
* druid监控拦截器
11+
*/
12+
@WebFilter(filterName = "druidWebStatFilter", urlPatterns = "/*",
13+
initParams = {
14+
@WebInitParam(name = "exclusions", value = "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*")//忽略资源
15+
}
16+
)
17+
public class DruidStatFilter extends WebStatFilter {
18+
}

‎dao/src/main/java/com/lmxdawn/admin/config/DruidStatViewServlet.java

Lines changed: 21 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,21 @@
1+
package com.lmxdawn.admin.config;
2+
3+
import com.alibaba.druid.support.http.StatViewServlet;
4+
5+
import javax.servlet.annotation.WebInitParam;
6+
import javax.servlet.annotation.WebServlet;
7+
8+
/**
9+
* druid监控视图配置 (监控视图配置)
10+
*/
11+
@WebServlet(urlPatterns = "/druid/*", initParams={
12+
@WebInitParam(name="allow",value="127.0.0.1"),// IP白名单 (没有配置或者为空，则允许所有访问)
13+
@WebInitParam(name="deny",value="192.168.16.111"),// IP黑名单 (存在共同时，deny优先于allow)
14+
@WebInitParam(name="loginUsername",value="admin"),// 用户名
15+
@WebInitParam(name="loginPassword",value="admin"),// 密码
16+
@WebInitParam(name="resetEnable",value="true")// 禁用HTML页面上的“Reset All”功能
17+
})
18+
public class DruidStatViewServlet extends StatViewServlet {
19+
private static final long serialVersionUID = 2359758657306626394L;
20+
21+
}

‎dao/src/main/java/com/lmxdawn/admin/dao/AuthAdminDao.java

Lines changed: 43 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,43 @@
1+
package com.lmxdawn.admin.dao;
2+
3+
import com.lmxdawn.admin.entity.AuthAdmin;
4+
5+
import java.util.List;
6+
7+
public interface AuthAdminDao {
8+
9+
/**
10+
* 查询列表
11+
* @return 列表
12+
*/
13+
List<AuthAdmin> queryAuthAdmin();
14+
15+
/**
16+
* 根据id查询
17+
* @param id 传入的id
18+
* @return
19+
*/
20+
AuthAdmin queryAuthAdminById(Long id);
21+
22+
/**
23+
* 插入
24+
* @param authAdmin
25+
* @return
26+
*/
27+
int insertAuthAdmin(AuthAdmin authAdmin);
28+
29+
/**
30+
* 更新
31+
* @param authAdmin
32+
* @return
33+
*/
34+
int updateAuthAdmin(AuthAdmin authAdmin);
35+
36+
/**
37+
* 删除
38+
* @param id
39+
* @return
40+
*/
41+
int deleteAuthAdminById(Long id);
42+
43+
}

‎dao/src/main/resources/application.properties

Lines changed: 30 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,30 @@
1+
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
2+
3+
mybatis.config-location=classpath:mybatis/mybatis-config.xml
4+
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
5+
6+
7+
#连接池的配置信息
8+
## 初始化大小，最小，最大
9+
spring.datasource.initialSize=5
10+
spring.datasource.minIdle=5
11+
spring.datasource.maxActive=20
12+
## 配置获取连接等待超时的时间
13+
spring.datasource.maxWait=60000
14+
# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
15+
spring.datasource.timeBetweenEvictionRunsMillis=60000
16+
# 配置一个连接在池中最小生存的时间，单位是毫秒
17+
spring.datasource.minEvictableIdleTimeMillis=300000
18+
spring.datasource.validationQuery=SELECT 1 FROM DUAL
19+
spring.datasource.testWhileIdle=true
20+
spring.datasource.testOnBorrow=false
21+
spring.datasource.testOnReturn=false
22+
# 打开PSCache，并且指定每个连接上PSCache的大小
23+
spring.datasource.poolPreparedStatements=true
24+
spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
25+
# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
26+
spring.datasource.filters=stat,wall,log4j
27+
# 通过connectProperties属性来打开mergeSql功能；慢SQL记录
28+
spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
29+
# 合并多个DruidDataSource的监控数据
30+
#spring.datasource.useGlobalDataSourceStat=true

‎dao/src/main/resources/mybatis/mapper/AuthAdminDao.xml

Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,13 @@
1+
<?xml version="1.0" encoding="UTF-8" ?>
2+
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
3+
4+
<mapper namespace="com.lmxdawn.admin.dao.AuthAdminDao" >
5+
6+
<select id="queryAuthAdmin" resultType="com.lmxdawn.admin.entity.AuthAdmin">
7+
SELECT id,username
8+
FROM auth_admin
9+
ORDER BY id
10+
DESC
11+
</select>
12+
13+
</mapper>

‎dao/src/main/resources/mybatis/mybatis-config.xml

Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,13 @@
1+
<?xml version="1.0" encoding="UTF-8" ?>
2+
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
3+
<configuration>
4+
<!--配置全局属性-->
5+
<settings>
6+
<!-- 允许JDBC 生成主键。需要驱动器支持。如果设为了true，这个设置将强制使用被生成的主键，有一些驱动器不兼容不过仍然可以执行。 default:false -->
7+
<setting name="useGeneratedKeys" value="true"/>
8+
<!-- 是否可以使用列的别名 (取决于驱动的兼容性) default:true -->
9+
<setting name="useColumnLabel" value="true"/>
10+
<!-- 使用驼峰命名法转换字段。 -->
11+
<setting name="mapUnderscoreToCamelCase" value="true"/>
12+
</settings>
13+
</configuration>

‎dao/src/test/java/com/lmxdawn/admin/dao/AuthAdminDaoTest.java

Lines changed: 47 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,47 @@
1+
package com.lmxdawn.admin.dao;
2+
3+
import com.lmxdawn.admin.entity.AuthAdmin;
4+
import org.junit.Ignore;
5+
import org.junit.Test;
6+
import org.junit.runner.RunWith;
7+
import org.springframework.beans.factory.annotation.Autowired;
8+
import org.springframework.boot.test.context.SpringBootTest;
9+
import org.springframework.test.context.junit4.SpringRunner;
10+
11+
import java.util.List;
12+
13+
import static org.junit.Assert.*;
14+
15+
@RunWith(SpringRunner.class)
16+
@SpringBootTest
17+
public class AuthAdminDaoTest {
18+
19+
@Autowired
20+
private AuthAdminDao authAdminDao;
21+
22+
@Test
23+
public void queryAuthAdmin() {
24+
List<AuthAdmin> authAdmins = authAdminDao.queryAuthAdmin();
25+
assertNotNull(authAdmins);
26+
}
27+
28+
@Test
29+
@Ignore
30+
public void queryAuthAdminById() {
31+
}
32+
33+
@Test
34+
@Ignore
35+
public void insertAuthAdmin() {
36+
}
37+
38+
@Test
39+
@Ignore
40+
public void updateAuthAdmin() {
41+
}
42+
43+
@Test
44+
@Ignore
45+
public void deleteAuthAdminById() {
46+
}
47+
}

0 commit comments

Comments
 (0)