ÏòOracle²åÈëÊý¾ÝÔõô±¨´í°¡£¿£¨ÔôÏ벻ͨ£©
ÒÔǰûÓÐÔõôÓùýOracle£¬oralceµÄ°üÒ²µ¼ÈëÁ˰¡£¬ÕæÊÇÏ벻ͨ°¡¡£¡£¡£¡£¡£Ï£Íû´ó¼ÒÄܰïÎÒ¿´¿´°¡£¬Ð»Ð»°¡¡£¡£¡£
java´úÂ룺
package com.xiaotong.taobao.bean;
public class Teacher {
private int id;
private String teachername;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getTeachername() {
return teachername;
}
public void setTeachername(String teachername) {
this.teachername = teachername;
}
}
Ó³ÉäÎļþ£º***********************************************
<hibernate-mapping package="com.xiaotong.taobao.bean">
<class name="Teacher">
<id name="id">
<generator class="sequence">
<param name="sequence">Teacher_id_seq </param>
</generator>
</id>
<property name="teachername" column="teacher_name"/>
</class>
</hibernate-mapping>
²âÊÔÀà´úÂ룺***********************************
package com.xiaotong.taobao.test;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.xiaotong.taobao.bean.Teacher;
import com.xiaoton
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......