mysqlbenchmark.java

来自「多种开源数据库（mysql、hsqldb、derby等等）性能比较源文件」· Java 代码 · 共 50 行

/*
 * MySQLBenchmark.java
 *
 * Created on 28 February 2005, 12:07
 */

package com.ideasasylum.dbbenchmark;

import java.util.logging.*;

/**
 *
 * @author  jel03r
 */
public class MySQLBenchmark 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 test";
    private static final String CREATE = "CREATE TABLE test (" +
            "id INT NOT NULL AUTO_INCREMENT ," +
            "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 MySQLBenchmark */
    public MySQLBenchmark() {
    }

    protected String getSelectSQL() {
        return SELECT;
    }

    protected String getInsertSQL() {
        return INSERT;
    }

    protected String getDropSQL() {
        return DROP;
    }

    protected String getCreateSQL() {
        return CREATE;
    }   
}