hsqldbbenchmark.java

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

/*
 * HsqldbBenchmark.java
 *
 * Created on 28 February 2005, 13:45
 */

package com.ideasasylum.dbbenchmark;

import java.util.logging.*;

/**
 *
 * @author  jel03r
 */
public class HsqldbBenchmark extends Benchmark {
    private static final java.util.logging.Logger logger = Logger.getLogger("com.ideasasylum.dbbenchmark");
    private static final String INSERT = "INSERT INTO test (name, value, date, longnumber, floatnumber) VALUES(?, ?, ?, ?, ?)";
    private static final String SELECT = "SELECT * FROM test";
    private static final String DROP = "DROP TABLE IF EXISTS test";
    private static final String CREATE = "CREATE 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 ))";
    
    
    /** Creates a new instance of HsqldbBenchmark */
    public HsqldbBenchmark() {
    }
    
    protected String getSelectSQL() {
        return SELECT;
    }
    
    protected String getInsertSQL() {
        return INSERT;
    }
    
    protected String getDropSQL() {
        return DROP;
    }
    
    protected String getCreateSQL() {
        return CREATE;
    }
}