一个生成唯一序号的服务，虽然技术不先进，但是很好用

package com.highcom.seqgen.dao.jdbc;

import java.sql.*;
import javax.sql.*;

import org.apache.commons.logging.*;
import org.springframework.beans.factory.*;
import org.springframework.context.*;
import org.springframework.jdbc.core.*;
import org.springframework.jdbc.object.*;
import com.highcom.seqgen.dao.*;
import com.highcom.seqgen.domain.*;

public class SequenceDaoJdbcImpl
    implements SequenceDao, InitializingBean {

  private DataSource dataSource;
  private static Log logger = LogFactory.getLog(SequenceDaoJdbcImpl.class);

  //
  SequenceQuery sequenceQuery;
  SequenceUpdate sequenceUpdate;
  SequenceInsert sequenceInsert;
  //
  protected static final String INSERT_SQL =
      "insert into sequence(seq_name,seq_value) values( ? , ? )";
  protected static final String UPDATE_SQL =
      "update sequence set seq_value = ? where seq_name = ?";
  protected static final String SELECT_SQL =
      "select seq_name,seq_value from sequence where seq_name =?";

  public SequenceDaoJdbcImpl() {

  }

  public int getSequence(String seq_name) {
    int result;
    Object obj = sequenceQuery.findObject(new Object[] {seq_name});
    if (obj == null) {
      sequenceInsert.insert(seq_name, 0);
    }

    Sequence seq = (Sequence) sequenceQuery.findObject(new Object[] {seq_name});
    sequenceUpdate.update(seq.getName(), seq.getValue() + 1);
    result = seq.getValue() + 1;
    return result;
  }

  public void afterPropertiesSet() throws Exception {
    if (dataSource == null) {
      logger.error("Must set dataSource bean property on " + getClass());
      throw new ApplicationContextException(
          "Must set dataSource bean property on " + getClass());
    }
    //
    sequenceQuery = new SequenceQuery(this.dataSource);
    sequenceUpdate = new SequenceUpdate(this.dataSource);
    sequenceInsert = new SequenceInsert(this.dataSource);
  }

  public void setDataSource(DataSource dataSource) {
    this.dataSource = dataSource;
  }

  ///////////////////////jdbc内部类
  class SequenceInsert
      extends SqlUpdate {
    public SequenceInsert(DataSource dataSource) {
      super(dataSource, INSERT_SQL);
      declareParameter(new SqlParameter(Types.VARCHAR));
      declareParameter(new SqlParameter(Types.INTEGER));
      compile();
    }

    public void insert(String seqName, int segValue) {
      Object[] objs = new Object[] {
          seqName, new Integer(segValue)};
      super.update(objs);
    }
  }

  class SequenceUpdate
      extends SqlUpdate {
    public SequenceUpdate(DataSource dataSource) {
      super(dataSource, UPDATE_SQL);
      declareParameter(new SqlParameter(Types.INTEGER));
      declareParameter(new SqlParameter(Types.VARCHAR));

      compile();

    }

    public void update(String seqName, int segValue) {
      Object[] objs = new Object[] {
          new Integer(segValue), seqName};
      super.update(objs);
    }
  }

  class SequenceQuery
      extends MappingSqlQuery {
    public SequenceQuery(DataSource dataSource) {
      super(dataSource, SELECT_SQL);
      declareParameter(new SqlParameter(Types.VARCHAR));
      compile();
    }

    protected Object mapRow(ResultSet resultSet, int _int) throws SQLException {
      Sequence seq = new Sequence();
      seq.setName(resultSet.getString("seq_name"));
      seq.setValue(resultSet.getInt("seq_value"));
      return seq;
    }
  }

}

本文地址：http://com.8s8s.com/it/it10196.htm