• Home
• com.viiyue.plugins
• mybatis-mapper
• 1.3.0
• source code
• AutoIncrement.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.viiyue.plugins.mybatis.enums.AutoIncrement Maven / Gradle / Ivy

/**
 * Copyright (C) 2017 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.viiyue.plugins.mybatis.enums;

import com.viiyue.plugins.mybatis.annotation.member.GeneratedKey;

/**
 * Provide an enumeration object for partial query auto-incrementing primary
 * key. You can easily use the enumeration name to find the corresponding
 * statement. If you can't find it here, then you can only provide your own
 * statement text.
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 
 * 
Database
Statement
DB2
VALUES IDENTITY_VAL_LOCAL()
MYSQL
SELECT LAST_INSERT_ID()
SQLSERVER
VALUES IDENTITY_VAL_LOCAL()
CLOUDSCAPE
SELECT SCOPE_IDENTITY()
DERBY
VALUES IDENTITY_VAL_LOCAL()
HSQLDB
CALL IDENTITY()
SYBASE
SELECT @@IDENTITY
DB2_MF
SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1
 * 
 * @author tangxbai
 * @since 1.1.0
 * @see GeneratedKey#statement()
 */
public enum AutoIncrement {

	DB2( "VALUES IDENTITY_VAL_LOCAL()" ), 
	MYSQL( "SELECT LAST_INSERT_ID()" ), 
	SQLSERVER( "SELECT SCOPE_IDENTITY()" ), 
	CLOUDSCAPE( "VALUES IDENTITY_VAL_LOCAL()" ), 
	DERBY( "VALUES IDENTITY_VAL_LOCAL()" ), 
	HSQLDB( "CALL IDENTITY()" ), 
	SYBASE( "SELECT @@IDENTITY" ), 
	DB2_MF( "SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1" );

	private String statement;

	private AutoIncrement( String statement ) {
		this.statement = statement;
	}

	public String statement() {
		return statement;
	}

}