Springboot-JDBC&Druid&一些Web组件

配置文件

1. pom.xml

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.13</version>
    <scope>runtime</scope>
</dependency>

2. application.yml

spring:
  datasource:
    username: root
    password: 932567
    url: jdbc:mysql://192.168.199.131:3307/123?useSSL=FALSE&&serverTimezone=GMT&&characterEncoding=utf-8
    driver-class-name: com.mysql.cj.jdbc.Driver
    # 选择Datasource类型
    type: com.alibaba.druid.pool.DruidDataSource

3. Controller，简单地增删改查

@Autowired //已根据数据源自动注入
JdbcTemplate jdbcTemplate;

//简单的增删改查
@RequestMapping("/customerList")
public List<Map<String,Object>> userList(){
    String sql = "select * from cust_customer";
    List<Map<String, Object>> list_map = jdbcTemplate.queryForList(sql);
    return list_map;
}

@RequestMapping("/addPerson")
public String addUser(){
    String sql = "insert into person values('Acai',16)";
    jdbcTemplate.update(sql);
    System.out.println(jdbcTemplate.getDataSource().getClass());
    return "update_ok";
}

@RequestMapping("/updatePerson")
public String updateUser(){
    String sql = "update person set name = ? where age = ? ";
    //封装
    Object[] objects = new Object[2];
    objects[0] = "张三";
    objects[1] = 16;
    jdbcTemplate.update(sql,objects);
    return "update_ok";
}

@RequestMapping("/deletePerson/{age}")
public String updateUser( @PathVariable int age){
    String sql = "delete from person where age = ?";
    jdbcTemplate.update(sql,age);
    return "delete_ok";
}

添加一些组件

Druid

1. pom.xml

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.21</version>
</dependency>

<dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>1.2.17</version>
</dependency>

2. config包下DruidConfig

@Configuration
public class DruidConfig {
    @ConfigurationProperties(prefix = "spring.datasource")
    @Bean
    public DataSource druidDataSource(){
        return new DruidDataSource();
    }

    //后台监控 通过/druid访问
    //因为SpringBoot内置了servlet容器，所以没有web.xml,替代方法：ServletRegistrationBean
    @Bean
    public ServletRegistrationBean statViewServlet(){
        //固定写法
        ServletRegistrationBean<StatViewServlet> bean = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
        //后台需要有人登陆，账号密码配置
        HashMap<String, String> map = new HashMap<>();

        //增加配置
        map.put("loginUsername","admin");//loginUsername是固定的写法
        map.put("loginPassword","1");//loginPassword是固定的写法

        //允许谁可以访问
        map.put("allow","");//allow固定写法，value是主机地址，空值表示谁都可以

        //禁止谁可以访问
        //map.put("自定义名字","192.168.199.131");

        bean.setInitParameters(map); //设置初始化参数
        return bean;
    }

其他一些web组件

//filter
@Bean
public FilterRegistrationBean webStatFilter(){
    FilterRegistrationBean bean = new FilterRegistrationBean();
    bean.setFilter(new WebStatFilter());

    //过滤那些请求，从源码可得
    /*"profileEnable";
    "sessionStatEnable";
    "sessionStatMaxCount";
    "exclusions";
    "principalSessionName"
    "principalCookieName";
    "realIpHeader";*/
    HashMap<String, String> map = new HashMap<>();
    //这些东西不进行过滤
    map.put("exclusions","*.js,*.css,/druid/*");
    return bean;
}