SpringBoot入门（四）

客官°小女子只卖身不卖艺 2022-01-23 11:31 205阅读 0赞

数据库连接池druid  
1.添加依赖  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70]![在这里插入图片描述][20190603114733179.png]  
2.在属性文件中配置  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70 1]  
3.实例化Druid对象  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70 3]  
4.打开监控中心  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70 4]  
servletRegistrationBean.setServlet(new StatViewServlet());  
servletRegistrationBean.addUrlMappings("/druid/*");  
servletRegistrationBean.addInitParameter(“loginUsername”,“admin”);  
servletRegistrationBean.addInitParameter(“loginPassword”,“admin”);  
return servletRegistrationBean;  
\}  
@Bean  
public FilterRegistrationBean fiterRegist()\{  
FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();  
filterRegistrationBean.setFilter(new WebStatFilter());  
filterRegistrationBean.addUrlPatterns("/*");  
filterRegistrationBean.addInitParameter(“exclusions”,".js,*.git,jpg,.css,*.ico,/druid/*");  
filterRegistrationBean.addInitParameter(“profileEnable”,“true”);  
return filterRegistrationBean;  
\}  
\}  
整合mybatis  
1.添加依赖  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70 5]  
2.在属性文件中的添加配置  
mybatis:  
mapper-locations: classpath:mapper/*.Mapper.xml  
3.创建一个实体类  
@Data  
public class User \{  
private int id;  
private String name;  
private int age;  
\}  
4.编写Dao  
@Mapper  
public interface UserMapper \{  
void save(User user);  
\}  
在resources/mapper中  
  
  
insert into user(name,age) values(\#\{name\},\#\{age\});  
  
  
测试  
@Test  
public void testAdd()\{  
User user = new User();  
user.setName(“aaa”);  
user.setAge(20);  
userMapper.save(user);  
\}  
单元测试  
@Test  
public void testAaa()\{  
//断言  
String aaa=“111”;  
System.out.println(aaa);  
// Assert.assertEquals(aaa,“222”);  
Assert.assertNotEquals(aaa,“111”);  
\}

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190603114713655.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ==,size_16,color_FFFFFF,t_70
[20190603114733179.png]: /images/20220123/b407a689ce2e4cea953a8f9d37562fb9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70 1]: /images/20220123/31628a47987c4e1c903c69db7a9f0bb6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70 2]: /images/20220123/5e9a199ad8c24f5c954529b59f699098.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70 3]: /images/20220123/daf1bfe29c124cd5a4ef37daadf3369f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70 4]: /images/20220123/8bbd7b88d3a44355b94905fc78187440.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTEzOTkyOQ_size_16_color_FFFFFF_t_70 5]: /images/20220123/107ed72048d343509c33f6705875f7a2.png