配置Druid數(shù)據(jù)庫(kù)連接池
先進(jìn)行 pom 的導(dǎo)包 (我的版本在父pom控制了锌奴，這里只貼出了引用)
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
</dependency>
druid 的 yml 配置文件
server:
port: 8088
thymeleaf:
cache: false
model: HTML5
prefix: classpath:/templates/**
suffix: .html
servlet:
content-type: text/html
spring:
messages:
basename: i18n/Messages,i18n/Pages
datasource:
type: com.alibaba.druid.pool.DruidDataSource #配置當(dāng)前要使用的數(shù)據(jù)源的操作類型
driver-class-name: com.mysql.jdbc.Driver #配置mysql的驅(qū)動(dòng)程序類
url: jdbc:mysql://localhost:3306/mldn?useUnicode=true&characterEncoding=UTF-8 #數(shù)據(jù)庫(kù)連接地址
username: root #數(shù)據(jù)庫(kù)用戶名
password: root #數(shù)據(jù)庫(kù)連接密碼
dbcp2: #配置數(shù)據(jù)庫(kù)連接池的配置
min-idle: 5 #數(shù)據(jù)庫(kù)連接池最小維持連接數(shù)
initial-size: 5 #初始化提供的連接數(shù)
max-total: 20 #最大連接數(shù)
max-wait-millis: 20 #等待連接獲取的最大超時(shí)時(shí)間
對(duì)連接進(jìn)行驗(yàn)證測(cè)試
@SpringBootTest(classes = bootBaseController.class)
@RunWith(SpringJUnit4ClassRunner.class)
@WebAppConfiguration
public class testDataSource{
@Autowired
private DataSource dataSource;
@Test
public void testConnection()throws SQLException {
System.out.println("++++++++++++++++++++++"+this.dataSource.getConnection());
}
}
springboot整合mybatis開(kāi)發(fā)框架
mybatis得yml配置
mybatis:
config-location: classpath:mybatis/mybatis.cfg.xml # mybatis配置文件所在路徑
type-aliases-package: boot.vo # 定義所有操作類的別名所在包
mapper-locations: # 所有的mapper映射文件
- classpath:mybatis/mapper/**/*.xml
mybatis得 entity 實(shí)體類(省略get/set方法)
*/
@SuppressWarnings("serial")
public class Dept implements Serializable {
private Long deptno;
private String dname;
mybatis得 dao 和 xml
//@Repository
@Mapper //我平常使用的是Repository ，但是在這里使用測(cè)試類必須用@Mapper否則注入不了測(cè)試類
public interface IDeptDao {
public List<Dept> findAll();
}
<mapper namespace="boot.dao.IDeptDao">
<select id="findAll" resultType="Dept">
SELECT deptno,dname FROM dept
</select>
</mapper>
mybatis得service 和 impl
public interface IDeptService {
public List<Dept> findAll();
}
@Service
public class IDeptServiceImpl implements IDeptService {
@Autowired
private IDeptDao deptDao;
@Override
public List<Dept> findAll() {
return this.deptDao.findAll();
}
}
測(cè)試類
@SpringBootTest(classes = bootBaseController.class)
@RunWith(SpringJUnit4ClassRunner.class)
@WebAppConfiguration
public class testDeptService {
@Autowired
private IDeptDao service;
@Test
public void testDeptService() {
System.out.println("+++++++++++++++++++++++++++"+service.findAll());
}
}}
測(cè)試結(jié)果
++++++++++++++++++++++++++++++++++++++[boot.vo.Dept@315f09ef, boot.vo.Dept@3a66e67e, boot.vo.Dept@75d4a80f, boot.vo.Dept@4596f8f3, boot.vo.Dept@ccf91df]
事務(wù)控制
報(bào)錯(cuò)信息(service 設(shè)置為只讀時(shí)進(jìn)行添加報(bào)錯(cuò))
nested exception is java.sql.SQLException:
Connection is read-only. Queries leading to data modification are not allowed
dao 和 xml
public boolean doCreate(Dept dept);
<insert id="doCreate" parameterType="Dept">
insert into dept(dname) values (#{dname})
</insert>
service 和 impl
注解表示支持事務(wù)
@Transactional(propagation = Propagation.REQUIRED)
public boolean add(Dept dept);
@Override
public boolean add(Dept dept) {
return this.deptDao.doCreate(dept);
}
引入logback pom包
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-core</artifactId>
</dependency>
logback.xml
<?xml version="1.0" encoding="UTF-8"?>
<configuration scan="true">
<property name="APP" value="${project.artifactId}" />
<property name="LOG_HOME" value="/data/www/log/${APP}" />
<appender name="CONSOLE" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<pattern>%d{yy-MM-dd.HH:mm:ss.SSS} [%-16t] %-5p %-22c{0} %X{ServiceId} - %m%n</pattern>
</encoder>
</appender>
<appender name="DETAIL"
class="ch.qos.logback.core.rolling.RollingFileAppender" additivity="false">
<File>${LOG_HOME}/${APP}_detail.log</File>
<encoder>
<pattern>%d{yy-MM-dd.HH:mm:ss.SSS} [%-16t] %-5p %-22c{0} %X{ServiceId} - %m%n</pattern>
</encoder>
<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
<fileNamePattern>${LOG_HOME}/${APP}_detail.log.%d{yyyyMMdd}</fileNamePattern>
</rollingPolicy>
</appender>
<appender name="ACCESS"
class="ch.qos.logback.core.rolling.RollingFileAppender" additivity="false">
<File>${LOG_HOME}/${APP}_access.log</File>
<encoder>
<pattern>%d{yy-MM-dd.HH:mm:ss.SSS};%X{ServiceId};%m%n</pattern>
</encoder>
<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
<fileNamePattern>${LOG_HOME}/${APP}_access.log.%d{yyyyMMdd}</fileNamePattern>
</rollingPolicy>
</appender>
<logger name="ACCESS">
<appender-ref ref="ACCESS" />
</logger>
<logger name="druid.sql.Statement" level="DEBUG" />
下面是自己dao接口得全類名包名
<logger name="boot.dao" level="TRACE" />
<root level="INFO">
<appender-ref ref="DETAIL" />
<appender-ref ref="CONSOLE" />
</root>
</configuration>
測(cè)試類
@Test
public void testAdd() throws Exception{
Dept dept =new Dept();
dept.setDname("張三");
System.out.println("------------------"+service.add(dept));
}
結(jié)果
19-11-13.01:16:47.811 [main ] TRACE findAll - <== Columns: deptno, dname
19-11-13.01:16:47.811 [main ] TRACE findAll - <== Row: 1, 開(kāi)發(fā)部
19-11-13.01:16:47.814 [main ] TRACE findAll - <== Row: 2, 財(cái)務(wù)部
19-11-13.01:16:47.815 [main ] TRACE findAll - <== Row: 3, 市場(chǎng)部
19-11-13.01:16:47.815 [main ] TRACE findAll - <== Row: 4, 后勤部
19-11-13.01:16:47.815 [main ] TRACE findAll - <== Row: 5, 公關(guān)部
druid 監(jiān)控配置（application 中加一個(gè) spring.datasource.filters=stat,wall,log4j）
@Configuration
public class DruidConfig {
@Bean
public ServletRegistrationBean<StatViewServlet> druidStatViewServlet() {
ServletRegistrationBean<StatViewServlet> registrationBean = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
registrationBean.addInitParameter("allow", "127.0.0.1");// IP白名單 (沒(méi)有配置或者為空坤候，則允許所有訪問(wèn))
registrationBean.addInitParameter("deny", "");// IP黑名單 (存在共同時(shí)英遭，deny優(yōu)先于allow)
registrationBean.addInitParameter("loginUsername", "root");
registrationBean.addInitParameter("loginPassword", "1234");
registrationBean.addInitParameter("resetEnable", "false");
return registrationBean;
}
@Bean
public FilterRegistrationBean filterRegistrationBean() {
FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean() ;
filterRegistrationBean.setFilter(new WebStatFilter());
filterRegistrationBean.addUrlPatterns("/*"); // 所有請(qǐng)求進(jìn)行監(jiān)控處理
filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.css,/druid/*");
return filterRegistrationBean ;
}
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource druidDataSource() {
return new DruidDataSource();
}
}
