HSQL简介

前言 在对dao层写测试类的时候，我们需要一个测试数据库，一般我们会是专门建立一个真实的测试数据库，但是有了HSQLDB事情就变得简单了起来。 正题 一、简介： hsql数据库是一款纯Java编写的免费数据库，许可是BSD-style的协议，如果你是使用Java编程的话，

package com.demandforce.dao;

import java.util.Collection;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.util.Assert;

import com.demandforce.model.TextMessageTemplate;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = {"classpath:context/hyperSqlContext.xml"})
public class TextMessageTemplateRetrievalTest {

    @Autowired
    private TextMessageTemplateDao textMessageTemplateDao;
            
    @Test
    public void testSelectByBusinessCategory() {
        Collection tmts = textMessageTemplateDao.selectByBusinessCategory( 203, 0);
        Assert.notNull(tmts);
        Assert.isTrue(tmts.size() == 2);
    }  
}

--
-- MySQL compatibility mode for Hyper SQL

SET DATABASE SQL SYNTAX MYS TRUE;

DROP TABLE IF EXISTS TextMessageTemplate;

CREATE TABLE TextMessageTemplate (
  ID INT NOT NULL AUTO_INCREMENT,
  BusinessID INT NOT NULL,
  Type INT NOT NULL,
  Template varchar(1000),
  CreatedDate datetime DEFAULT NULL,
  LastModifiedDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  CreatedUserId INT DEFAULT 0,
  LastModifiedUserId INT DEFAULT 0,
  Delivery INT DEFAULT 0,
  DeliveryWindow INT DEFAULT 1,
  BusinessCalendar INT NOT NULL DEFAULT 0,
  DeliveryTime datetime DEFAULT NULL,
  CardCount INT DEFAULT 0,
  Segment INT DEFAULT 0,
  FrontImage varchar(255) DEFAULT NULL,
  IncludeItems INT DEFAULT 1,
  IncludeReview INT DEFAULT 1,
  IncludeCoupon INT DEFAULT 1,
  services varchar(5000) DEFAULT NULL,
  Industry INT DEFAULT NULL,
  PRIMARY KEY (ID)
);

INSERT INTO TextMessageTemplate (BusinessID, Type, Template, Industry) 
VALUES ('0', '203', 'Template1', null);

INSERT INTO TextMessageTemplate (BusinessID, Type, Template, Industry)
VALUES ('0', '204', 'Template2', null);