数据库设计:
在oracle 创建表 :
create table test (in int ,loginname varchar(128),loginpass varchar(128));
alter table test add constraint primary key(id);
在oracle 创建sequence:
create sequence seq_id
minvalue 1
start with 1
increment by 1
cache 20;
java代码:
pojo类:
package com.pojo;
/**
* Test generated by MyEclipse - Hibernate Tools
*/
public class Test implements java.io.Serializable {
// Fields
private long id;
private String name;
private String pass;
// Constructors
/** default constructor */
public Test() {
}
/** minimal constructor */
public Test(long id) {
this.id = id;
}
/** full constructor */
public Test(long id, String name, String pass) {
this.id = id;
this.name = name;
this.pass = pass;
}
// Property accessors
public long getId() {
return this.id;
}
public void setId(long id) {
this.id = id;
}
public String getName() {
return this.name;
}
public void setName(String name) {
this.name = name;
}
public String getPass() {
return this.pass;
}
public void setPass(String pass) {
this.pass = pass;
}
xml映射文件:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
<class name="com.pojo.Test" table="TEST" schema="WTL">
<id name="id" type="long">
<column name="ID" precision="22" scale="0" />
<generator class="sequence">
<param name="sequence">seq_id</param>----------关键代码
</generator>
</id>
<property name="name" type="string">
<column name="NAME" length="128" />
</property>
<property name="pass" type="string">
<column name="PASS" length="128" />
</property>
</class>
</hibernate-mapping>