ssm和ssh框架中，oracle数据库，表主键自增如何解决

1.ssh框架：
hibernate反向生成实体类中映射文件一般如下：

<id name="basiNo" type="java.lang.Long">     <column name="BASI_NO" precision="10" scale="0"/>            <generator class="sequence" /> </id>

oracle中添加自增序列：

-- Create sequence create sequence BASI_SEQminvalue 1maxvalue 999999999999999999999999999start with 61increment by 1cache 20;

然后在映射文件中修改如下：
BASI_SEQ为oracle中设置的自增序列名。

 <id name="basiNo" type="java.lang.Long">     <column name="BASI_NO" precision="10" scale="0" />            <generator class="sequence" >                <param name="sequence">BASI_SEQ</param>            </generator> </id>

在service中实现添加方法时不用理会主键，会自行增加。

2.ssm框架
通过在oracle中创建主键自增触发器来完成。
如下表：

-- Create tablecreate table TEST(  ID       NUMBER(16) not null,  QUESTION VARCHAR2(100),  ANSWER   VARCHAR2(4000),  FLAG     NUMBER(8))tablespace USERS  pctfree 10  initrans 1  maxtrans 255  storage  (    initial 64K    next 1M    minextents 1    maxextents unlimited  );-- Create/Recreate primary, unique and foreign key constraints alter table TEST  add constraint TEST_PK primary key (ID)  using index   tablespace USERS  pctfree 10  initrans 2  maxtrans 255  storage  (    initial 64K    next 1M    minextents 1    maxextents unlimited  );

创建自增序列：

-- Create sequence create sequence TEST_SEQminvalue 1maxvalue 9999999999999999999999999999start with 23increment by 1cache 20;

添加触发器：

create or replace trigger test_trigger  before insert on test    for each rowbegin  select test_seq.nextval into :new.id from dual;

mapping.xml文件中增加语句如下：

<insert id="insert" parameterType="com.bean.entity.Test" useGeneratedKeys="true" flushCache="true">        <!-- WARNING - @mbggenerated This element is automatically generated by             MyBatis Generator, do not modify. -->        <!-- <selectKey keyProperty="id" resultType="java.lang.Long" order="BEFORE">            select max(id)+1 from TEST        </selectKey> -->        insert into TEST         (QUESTION, ANSWER,FLAG)        values         (#{question,jdbcType=VARCHAR},#{answer,jdbcType=VARCHAR},#{flag,jdbcType=DECIMAL})    </insert>

以上就完成了ssm框架中对主键自增的处理。