Ïò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 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......