hsqldbcachedshutdownbenchmark.java

多种开源数据库（mysql、hsqldb、derby等等）性能比较源文件

/*
 * HsqldbCachedShutdownBenchmark.java
 *
 * Created on 07 March 2005, 13:17
 */

package com.ideasasylum.dbbenchmark;

import java.sql.*;

public class HsqldbCachedShutdownBenchmark extends HsqldbCachedBenchmark {
    private static final String CREATE = "CREATE CACHED TABLE test (" +
            "id INTEGER GENERATED BY DEFAULT AS IDENTITY," +
            "name VARCHAR( 254 ) NOT NULL," +
            "value INT NOT NULL," +
            "date DATE NOT NULL," +
            "longnumber BIGINT NOT NULL," +
            "floatnumber FLOAT NOT NULL," +
            "PRIMARY KEY ( id ))";
    private static final String SHUTDOWN = "SHUTDOWN";
    
    /** Creates a new instance of HsqldbCachedShutdownBenchmark */
    public HsqldbCachedShutdownBenchmark() {
    }

    protected String getCreateSQL() {
        return CREATE;
    }    
    
    protected void closeConnection() throws java.sql.SQLException {
        Statement close = connection.createStatement();
        close.executeUpdate(SHUTDOWN);
        super.closeConnection();
    }
}