java 数据库 主键 生成器_数据库主键生成器java代码 | 学步园

package com.aspboy.base.database.util;

import java.util.HashMap;

public class KeyGenerator

{

private static KeyGenerator keygen=new KeyGenerator();

private static final int POOL_SIZE=20;

private HashMap keylist=new HashMap(10);

private KeyGenerator()

{}

public static KeyGenerator getInstance()

{

return keygen;

}

public synchronized int  getNextKey(String keyName)

{

KeyInfo keyinfo;

if (keylist.containsKey(keyName))

{

keyinfo=(KeyInfo)keylist.get(keyName);

System.out.println("key found");

}

else

{

keyinfo=new KeyInfo(POOL_SIZE,keyName);

keylist.put(keyName, keyinfo);

System.out.println("new key created");

}

return keyinfo.getNextKey();

}

}

package com.aspboy.base.database.util;

import com.aspboy.base.database.DBBean;

public class KeyInfo

{

private int keyMax;

private int Keymin;

private int nextKey;

private int poolSize;

private String keyName;

//private int times ;

public KeyInfo(int poolSize,String keyName)

{

this.poolSize=poolSize;

this.keyName=keyName;

loadFromDB();

//times++;

//System.out.println("get keyvalue from db tiems=="+times);

}

public int getKeyMax() {

return keyMax;

}

public int getKeymin() {

return Keymin;

}

private void loadFromDB()

{

String sql1="update tb_key set KeyValue=KeyValue+"+poolSize+" where keyName='"+keyName+"'";

DBBean.executeSql(sql1);

String sql2="select KeyValue from  tb_key  where keyName='"+keyName+"'";

int keyFromDB=DBBean.getIntSingle(sql2);

keyMax=keyFromDB;

Keymin=keyFromDB-poolSize+1;

nextKey=Keymin;

}

public int getNextKey() {

if (nextKey>keyMax)

{

loadFromDB();

System.out.println("get keyvalue from db");

}

return nextKey++;

}

}

调用 方法： KeyGenerator.getInstance().getNextKey(keyName);

keyName 为表名称

相关数据库结构：

表tb_key

字段如下：

KeyValue：pk大小

keyName：表名