application.properties

spring.profiles.active=test
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=none
logging.level.root=info
logging.level.org.hibernate=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicExtractor=DEBUG
logging.level.com.itmuch=DEBUG

web訪問數(shù)據(jù)庫

 @Bean(name = "h2WebServer", initMethod = "start", destroyMethod = "stop")
  //啟動(dòng)一個(gè)H2的web server， 調(diào)試時(shí)可以通過localhost:8082訪問到H2的內(nèi)容
  //JDBC URL: jdbc:h2:mem:testdb
  //User Name: sa
  //Password: 無
  //注意如果使用斷點(diǎn)，斷點(diǎn)類型(Suspend Type)一定要設(shè)置成Thread而不能是All,否則web server無法正常訪問!
  public Server server() throws Exception {
    //在8082端口上啟動(dòng)一個(gè)web server
    Server server = Server.createWebServer("-web", "-webAllowOthers", "-webDaemon", "-webPort", "8082");
    return server;
  }

@Configuration
@Profile("test")
public class DataSourceTestConfig {

  @Bean(name = "tagDataSource")
  @Qualifier("tagDataSource")
  @Primary
  public DataSource tagDataSource() {
    EmbeddedDatabaseBuilder databaseBuilder = new EmbeddedDatabaseBuilder();

    EmbeddedDatabase db = databaseBuilder
        .setType(EmbeddedDatabaseType.H2)
        //啟動(dòng)時(shí)初始化建表語句
        .addScript("classpath:tag-schema.sql")
        .build();

    return db;
  }

  @Bean(name = "hbaseDataSource")
  @Qualifier("hbaseDataSource")
  @ConfigurationProperties(prefix = "hbase.datasource", locations = "classpath:datasource-dev.properties")
  public DataSource hbaseDataSource() {
    DruidDataSource druidDataSource = new DruidDataSource();
    try {
      druidDataSource.setFilters("stat");
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return druidDataSource;
  }
}

配置

driverClassName=org.h2.Driver
url=jdbc:h2:men:test
username=sa
password=

初始化腳本

/*
注意 不支持timestamp 自動(dòng)更新  這里的sql也是有問題的
還有就是要開啟spring.jpa.hibernate.ddl-auto=none
否則線上數(shù)據(jù)庫會(huì)被清空
還有就是h2 嚴(yán)格區(qū)分sql里面的單引號和雙引號 字符串必須使用單引號
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` varchar(64) NOT NULL,
  `org_id` varchar(32) DEFAULT NULL COMMENT '企業(yè)ID',
  `user_name` varchar(60) DEFAULT NULL COMMENT '用戶姓名',
  `user_tag` varchar(64) DEFAULT NULL COMMENT '姓名標(biāo)簽',
  `user_sign` varchar(64) DEFAULT NULL COMMENT '人員唯一標(biāo)志（學(xué)號，學(xué)籍號，工號。。。） 現(xiàn)在暫為 學(xué)生：學(xué)號，老師：工號',
  `photo_url` varchar(200) DEFAULT NULL COMMENT '頭像地址 ../user_id.jpg',
  `born_date` varchar(50) DEFAULT NULL COMMENT '出生日期',
  `sex` varchar(32) DEFAULT NULL COMMENT '姓別  1:男; 2:女',
  `is_delete` varchar(1) DEFAULT NULL COMMENT '是否刪除 1:刪除；0：正常',
  `create_user` varchar(64) DEFAULT NULL,
  `gmt_create` datetime DEFAULT NULL,
  `modify_user` varchar(64) DEFAULT NULL,
  `gmt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `tag_project_tag_group`;
CREATE TABLE `tag_project_tag_group` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `tag_project_tag_user_backup`;
CREATE TABLE `tag_project_tag_user_backup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `tag_project_user_tag_checked`;
CREATE TABLE `tag_project_user_tag_checked` (
  `id` varchar(40) NOT NULL DEFAULT '' ,
  `name` varchar(60) DEFAULT NULL ,
  `is_delete` tinyint(1) DEFAULT NULL ,
  `modify_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `is_checked` tinyint(1) DEFAULT NULL ,
  `is_group` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for user_group
-- ----------------------------
DROP TABLE IF EXISTS `user_group`;
CREATE TABLE `user_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) DEFAULT NULL,
  `application_id` varchar(11) DEFAULT NULL,
  `is_delete` tinyint(1) DEFAULT '0',
  `create_time` datetime DEFAULT NULL,
  `modify_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for user_group_event_group
-- ----------------------------
DROP TABLE IF EXISTS `user_group_event_group`;
CREATE TABLE `user_group_event_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_group_id` int(11) DEFAULT NULL,
  `event_id` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `modify_time` datetime DEFAULT NULL,
  `is_delete` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for user_group_event_status
-- ----------------------------
DROP TABLE IF EXISTS `user_group_event_status`;
CREATE TABLE `user_group_event_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) DEFAULT NULL,
  `code` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `modify_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `is_delete` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for user_group_events
-- ----------------------------
DROP TABLE IF EXISTS `user_group_events`;
CREATE TABLE `user_group_events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `is_delete` tinyint(1) DEFAULT '0',
  `modify_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for user_group_groups
-- ----------------------------
DROP TABLE IF EXISTS `user_group_groups`;
CREATE TABLE `user_group_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `is_delete` tinyint(1) DEFAULT '0',
  `modify_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `user_group` VALUES ('7', '12', '1', '0', '2017-08-28 17:29:51', '2017-08-28 17:29:51');
INSERT INTO `user_group` VALUES ('8', '13', '1', '0', '2017-08-28 17:37:45', '2017-08-28 17:37:45');