mysql集群 主键生成_生成整数自增ID(集群主键生成服务)

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;importjava.util.concurrent.Callable;importjava.util.concurrent.ExecutionException;importjava.util.concurrent.ExecutorService;importjava.util.concurrent.Executors;importjava.util.concurrent.Future;public classSeqGenerator {private static ExecutorService singleThreadExecutor =Executors.newSingleThreadExecutor();private static int currentVal = -1;private static int maxVal = -1;private static int fetchSize = 10000;//每次生成一万个idstatic{try{

fetchFromDB();

}catch(Exception e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}public static int getSeq() throwsInterruptedException, ExecutionException {

Callable c = new Callable() {

@Overridepublic Integer call() throwsException {int result =currentVal;if (currentVal >maxVal) {//如果当前值>数据库最大值，重新生成id

fetchFromDB();

result=currentVal;

}

currentVal++;returnresult;

}

};

Future task =singleThreadExecutor.submit(c);returntask.get().intValue();

}private static void fetchFromDB() throwsException {

Class.forName("com.mysql.jdbc.Driver");

Connection connection= DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "xx", "xx");

connection.setAutoCommit(false);

Statement st=connection.createStatement();

ResultSet rs= st.executeQuery("select * from test for update");

rs.next();

currentVal= rs.getInt(1) + 1;//当前值

rs.close();

st.executeUpdate("update test set id=id+" +fetchSize);//更新db中最大值

rs= st.executeQuery("select * from test for update");

rs.next();

maxVal= rs.getInt(1);//最大值

connection.commit();

rs.close();

st.close();

connection.close();

}public static void main(String[] args) throwsException {int i = 1000000;long start =System.currentTimeMillis();while (i > 0) {

System.out.println(SeqGenerator.getSeq());

i--;

}long end =System.currentTimeMillis();

System.out.println(end-start);

}

}