daffodilbenchmark.java

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

/*
 * DaffodilBenchmark.java
 *
 * Created on 28 February 2005, 13:46
 */

package com.ideasasylum.dbbenchmark;

import java.util.logging.*;

/**
 *
 * @author  jel03r
 */
public class DaffodilBenchmark 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, mydate, longnumber, floatnumber) VALUES(?, ?, ?, ?, ?)";
    private static final String SELECT = "SELECT * FROM test";
    private static final String DROP = "DROP TABLE test";
    private static final String CREATE = "CREATE TABLE test (" +
            "id INTEGER AUTOINCREMENT," +
            "name VARCHAR( 254 )," +
            "value INTEGER," +
            "mydate DATE," +
            "longnumber BIGINT," +
            "floatnumber FLOAT," +
            "PRIMARY KEY ( id ))";
    
    
    /** Creates a new instance of DaffodilBenchmark */
    public DaffodilBenchmark() {
    }

    protected String getSelectSQL() {
        return SELECT;
    }

    protected String getInsertSQL() {
        return INSERT;
    }

    protected String getDropSQL() {
        return DROP;
    }

    protected String getCreateSQL() {
        return CREATE;
    }   
}