spring boot实战

oradbm

2017-09-26

接着初探篇，继续深入，解决自定义过滤器、监听器、拦截器这些常用编码。先来看看项目结构：

spring boot实战

实现上面所说的问题前，先来个简单的数据库操作。这里用的orm框架是mybatis：

1.在application.properties编码数据库连接参数（application.properties是spring boot默认的资源文件）

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&amp;characterEncoding=UTF-8
jdbc.username=root
jdbc.password=123456

2.编码数据库连接池，用的是HikariCP（在默认的资源文件下配置的参数可通过@Value("${keyName}")这种方式获取值）

@Configuration
@MapperScan(basePackages = "com.tboot.mapper", sqlSessionFactoryRef = "sqlSessionFactory")
public class DataSourceConfig {
	
    @Value("${jdbc.url}")
    private String url;
 
    @Value("${jdbc.username}")
    private String user;
 
    @Value("${jdbc.password}")
    private String password;
 
    @Value("${jdbc.driverClassName}")
    private String driverClass;
    
    @Bean(name = "dataSource",destroyMethod = "close")
	//标志这个 Bean 如果在多个同类 Bean 候选时，该 Bean 优先被考虑。「多数据源配置的时候注意，必须要有一个主数据源，用 @Primary 标志该 Bean
    @Primary
    public DataSource dataSource() {
    	HikariDataSource dataSource = new HikariDataSource();
        dataSource.setDriverClassName(driverClass);
        dataSource.setJdbcUrl(url);
        dataSource.setUsername(user);
        dataSource.setPassword(password);
        
        dataSource.setConnectionTimeout(30000);
        //一个连接idle状态的最大时长（毫秒），超时则被释放（retired），缺省:10分钟
        dataSource.setIdleTimeout(60000);
        //一个连接的生命时长（毫秒），超时而且没被使用则被释放（retired），缺省:30分钟，建议设置比数据库超时时长少30秒，参考MySQL wait_timeout参数（show variables like '%timeout%';）
        dataSource.setMaxLifetime(600000);
        //连接池中允许的最大连接数。缺省值：10；推荐的公式：((core_count * 2) + effective_spindle_count)
        dataSource.setMaximumPoolSize(15);
        return dataSource;
    }
 
    @Bean(name = "transactionManager")
    @Primary
    @Qualifier("tm1")
    public DataSourceTransactionManager transactionManager() {
        return new DataSourceTransactionManager(dataSource());
    }
 
    @Bean(name = "sqlSessionFactory")
    @Primary
    public SqlSessionFactory sqlSessionFactory(@Qualifier("dataSource") DataSource dataSource)
            throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource);
        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources("classpath:mapping/*.xml"));
        return sessionFactory.getObject();
    }

}

3.创建model、mapper和编码sql

public class User {
    private Integer id;

    private String name;

    private String password;

    private Boolean state;

    private String email;

    private Date createtime;

    private Boolean deleted;

……
}

public interface UserMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(User record);

    int insertSelective(User record);

    User selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(User record);

    int updateByPrimaryKey(User record);
    
    User selectByPassword(@Param("name")String name, @Param("password")String password);
}

具体的sql就不贴了，太占篇幅。

4.编码Controller和视图（用的是Freemarker）

@RestController //@RestController相当于@Controller+@ResponseBody
@RequestMapping("/test")
public class HelloController {
	
	@Resource
	private UserMapper userMapper;
	
	@RequestMapping(value = "/view")
	public ModelAndView view(int id) {
		ModelAndView mv = new ModelAndView("backweb/view");
		mv.addObject("user", userMapper.selectByPrimaryKey(id));
		return mv;
	}
	
}

<!DOCTYPE html>
<html>
<head>
<title>view</title>
</head>
<body>
<div>${user.name }---${user.email}</div>
</body>
</html>

这样数据库操作方面就告一段落。

接下来回归正题，等来实现自定义拦截器，篇幅太长，这里只贴出关键代码，整个项目代码可下载附件。

1.编码登录拦截器

public class LoginInterceptor extends HandlerInterceptorAdapter {
	private static Logger logger = Logger.getLogger(LoginInterceptor.class.getName());
	
    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
    	//业务代码
	return super.preHandle(request, response, handler);
    }

}

2.编码Config，将拦截器添加到Config中

@Configuration
public class MyConfig extends WebMvcConfigurerAdapter {

	@Override
	public void addInterceptors(InterceptorRegistry registry) {
		registry.addInterceptor(new LoginInterceptor()).addPathPatterns("/manage/**").excludePathPatterns("/manage/login");
		//registry.addInterceptor(new AuthInterceptor()).addPathPatterns("/manage/**")
			//.excludePathPatterns("/manage/login","/manage/index","/manage/menu","/manage/sysExit");
	}
	
}

自定义拦截器的关键代码就这些。

紧接着实现自定义过滤器：

@Order(1) //执行过滤顺序，值越小，越先执行
@WebFilter(filterName = "requestSessionFilter", urlPatterns = "/*")
public class RequestSessionFilter implements Filter {
	private static Logger logger = Logger.getLogger(RequestSessionFilter.class.getName());
	@Override
	public void destroy() {

	}

	@Override
	public void doFilter(ServletRequest request, ServletResponse response,FilterChain fchain) throws IOException, ServletException {
		//业务代码
	}

	@Override
	public void init(FilterConfig arg0) throws ServletException {

	}

}

在初探篇中，Run.java类上面已加了个@ServletComponentScan注解，它的作用就是可以直接通过@WebServlet、@WebFilter、@WebListener注解自动注册Servlet、Filter、Listener。

很遗憾这项目中并没有实现监听器和servlet，往后有时间再补吧……

还有多数据源配置是实现了的，自己下载项目看吧，这里就不多说了……

补上项目sql脚本：

CREATE TABLE IF NOT EXISTS `t_function` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) DEFAULT NULL,
  `Authurl` varchar(100) DEFAULT NULL,
  `Url` varchar(100) DEFAULT NULL,
  `ParentID` int(11) DEFAULT NULL,
  `Sort` int(11) DEFAULT NULL,
  `Deleted` bit(1) DEFAULT b'0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `t_role` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) DEFAULT NULL,
  `Remark` varchar(50) DEFAULT NULL,
  `Deleted` bit(1) DEFAULT b'0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `t_role_function` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RoleID` int(11) DEFAULT NULL,
  `FunctionID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `t_user` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) DEFAULT NULL,
  `Password` varchar(50) DEFAULT NULL,
  `State` bit(1) DEFAULT b'0',
  `Email` varchar(150) DEFAULT NULL,
  `CreateTime` date DEFAULT NULL,
  `Deleted` bit(1) DEFAULT b'0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `t_user_role` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `UserID` int(11) DEFAULT NULL,
  `RoleID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

boot spring框架 jdbc