注解版：
package cn.tx.sboot.model; import lombok.Data; import java.util.Date; @Data public class Person { private int pid; private String pname; private String personAddr; private int gender; private Date birth; }package cn.tx.sboot.mapper; import cn.tx.sboot.model.Person; import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Options; import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Component; import java.util.List; @Component @Mapper public interface PersonMapper { @Select("select * from person t where t.pid = #{pid}") public Person selectById(int pid); @Select("select * from person") public List<Person> selectAll(); @Options(useGeneratedKeys = true, keyProperty = "pid") @Insert("insert into person(pid, pname, addr, gender, birth)values(#{pid},#{pname},#{addr},#{gender},#{birth} )") public void insert(Person p); @Select("delete from person where pid = #{pid}") public void delete(int pid); }
package cn.tx.sboot.config; import com.alibaba.druid.pool.DruidDataSource; import com.alibaba.druid.support.http.StatViewServlet; import com.alibaba.druid.support.http.WebStatFilter; import org.springframework.boot.context.properties.ConfigurationProperties; import org.springframework.boot.web.servlet.FilterRegistrationBean; import org.springframework.boot.web.servlet.ServletRegistrationBean; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; @Configuration public class DatasourceConfig { @Bean @ConfigurationProperties(prefix = "spring.datasource") public DruidDataSource dataSource(){ return new DruidDataSource(); } /** * springboot继承 druid监控 */ @Configuration public class DruidConfiguration { @Bean public ServletRegistrationBean statViewServlet() { ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*"); //白名单： servletRegistrationBean.addInitParameter("allow", "127.0.0.1"); //IP黑名单 (存在共同时，deny优先于allow) : 如果满足deny的即提示:Sorry, you are not permitted to view this page. servletRegistrationBean.addInitParameter("deny", "192.168.1.100"); //登录查看信息的账号密码. servletRegistrationBean.addInitParameter("loginUsername", "druid"); servletRegistrationBean.addInitParameter("loginPassword", "12345678"); //是否能够重置数据. servletRegistrationBean.addInitParameter("resetEnable", "false"); return servletRegistrationBean; } @Bean public FilterRegistrationBean statFilter() { FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter()); //添加过滤规则. filterRegistrationBean.addUrlPatterns("/*"); //添加不需要忽略的格式信息. filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"); return filterRegistrationBean; } } }
配置文件：
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="cn.tx.sboot.mapper.PersonMapper"> <select id="selectById" resultType="Person"> select * from person t where t.pid = #{pid} </select> <select id="selectAll" resultType="Person"> select * from person </select> <insert id="insert" parameterType="person"> <selectKey keyProperty="pid" resultType="int" order="BEFORE"> select last_insert_id() </selectKey> insert into person(pid, pname, addr, gender, birth)values(#{pid},#{pname},#{addr},#{gender},#{birth} ) </insert> <delete id="delete" parameterType="int" > delete from person where pid = #{pid} </delete> </mapper> #数据源的配置 spring: datasource: url: jdbc:mysql://localhost:3306/mybatis?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC driver-class-name: com.mysql.cj.jdbc.Driver username: root password: root type: com.alibaba.druid.pool.DruidDataSource initialSize: 5 minIdle: 5 maxActive: 20 maxWait: 60000 timeBetweenEvictionRunsMillis: 60000 minEvictableIdleTimeMillis: 300000 validationQuery: SELECT 1 FROM DUAL testWhileIdle: true testOnBorrow: false testOnReturn: false poolPreparedStatements: true filters: stat,wall,log4j maxPoolPreparedStatementPerConnectionSize: 20 useGlobalDataSourceStat: true connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500 #mybatis的配置 mybatis: #config-location: classpath:sqlMapConfig.xml mapper-locations: classpath:mapper/*.xml configuration: map-underscore-to-camel-case: true type-aliases-package: cn.tx.sboot.model
