com.centit.support.database.jsonmaptable.H2JsonObjectDao Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of centit-database Show documentation

数据库操作通用方法和函数，从以前的util包中分离出来，并且整合了部分sys-module中的函数

The newest version!

package com.centit.support.database.jsonmaptable;

import com.centit.support.algorithm.NumberBaseOpt;
import com.centit.support.database.metadata.TableInfo;
import com.centit.support.database.utils.DatabaseAccess;

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;

/**
 * 使用H2数据库时请打开MySql兼容模式
 * jdbc:h2: <url>;MODE=<databaseType>
 * MODE=MySQL：兼容模式，H2兼容多种数据库，
 * 该值可以为：DB2、Derby、HSQLDB、MSSQLServer、MySQL、Oracle、PostgreSQL
 * 
 * http://www.h2database.com/html/features.html#compatibility
 */
public class H2JsonObjectDao extends MySqlJsonObjectDao {

    public H2JsonObjectDao() {

    }

    public H2JsonObjectDao(Connection conn) {
        super(conn);
    }

    public H2JsonObjectDao(TableInfo tableInfo) {
        super(tableInfo);
    }

    public H2JsonObjectDao(Connection conn, TableInfo tableInfo) {
        super(conn, tableInfo);
    }


    /**
     * 用表来模拟sequence
     * create table simulate_sequence (seqname varchar(100) not null primary key,
     * currvalue integer, increment integer);
     *
     * @param sequenceName sequenceName
     * @return Long
     * @throws SQLException SQLException
     * @throws IOException  IOException
     */
    @Override
    public Long getSequenceNextValue(final String sequenceName) throws SQLException, IOException {
        Object object = DatabaseAccess.getScalarObjectQuery(
            getConnect(),
            "SELECT NEXT VALUE FOR " + sequenceName);
        return NumberBaseOpt.castObjectToLong(object);
    }

}