JdbcTemplate和MyBatis判断表是否存在

    
    public boolean existsTable(String tableName) {
        String isTableSql = String.format("SELECt COUNT(*) as count FROM information_schema.TABLES WHERe " + "table_name = '%s'", tableName);
        Map map = jdbctemplate.queryForMap(isTableSql);
        return Integer.parseInt(map.get("count").toString()) > 0;
    }

    
    Integer existsTable(@Param("tableName") String tableName);

    
    
        SELECT COUNT(*) as count FROM information_schema.TABLES WHERe table_name = #{tableName}
    

	
	public Boolean existsTable(String tableName) {
        Integer tableNumber = reportMapper.existsTable(tableName);
        return tableNumber > 0;
    }