hsqldb内存数据库和dbunit数据库unit联合测试

来源：互联网发布：超级基因优化液在线编辑：程序博客网时间：2024/05/17 23:36

// 加载驱动

  try {
   Class.forName("org.hsqldb.jdbcDriver");
  } catch (ClassNotFoundException e1) {
   // TODO Auto-generated catch block
   e1.printStackTrace();
  }

// 连接数据库的地址

  String url = "jdbc:hsqldb:mem:.";
  String username = "sa";
  String password = "";
  conn = null;

try {

// 创建与数据库的连接

conn = DriverManager.getConnection(url, username, password);

   System.out.println("成功连接到数据库：" + conn);
   Statement statement = conn.createStatement();
   statement.execute("create table bandwidth_area(AREA_ID    bigint ,USER_ID    bigint , CHANNEL_ID VARCHAR(10) , DAY        DATE , DATA1      bigint , INDATA1    bigint , DATA2      bigint , INDATA2    bigint , DATA3      bigint )");

   File file = new File("D:/java/billqueryservice/src/test/java/com/chinacache/boss/queryservice/bandwidthservice/bandwidth_area.xml");
   System.out.println(file.exists());
   IDataSet dataSet = new FlatXmlDataSet( new FileInputStream(file));

   IDatabaseConnection connection =new DatabaseConnection(conn);
   DatabaseOperation.CLEAN_INSERT.execute(connection,dataSet);

   bandwidthByChannelIds = new QueryBandwidthByChannelIds();
   bandwidthByChannelIds.setLogDataSource(new SingleConnectionDataSource(conn,true));
  } catch (Exception ex) {
   System.out.println("连接失败：" + ex);
  }