从Oracle的table反向生成.hbm配置文件和java类.
1.连接数据库
打开MyEclipse->Window->Open Perspective->MyEclipse Hibernate或者MyEclipse->Window->Open Perspective->MyEclipse Database Explorer, 看到DB Browser视图.
右键New打开Database Driver对话框, 配置如下图:
Driver template: 选择Oracle (Thin driver)
Driver name: oracle.jdbc.driver.OracleDriver
Connection URL: jdbc:oracle:thin:@<server>[:<1521>]:<database_name>, 其中
<server> 数据库IP
[:<1521>] 端口号
<database_name> 数据库服务名
本例中, 为jdbc:oracle:thin:@10.6.183.82:1525:WEBET
其中, database_name的获取方法, 为下述SQL(http://www.orafaq.com/scripts/sql/whoami.txt)中的global_name:
select 'User: '|| user || ' on database ' || global_name, ' (term='||USERENV('TERMINAL')|| ', audsid='||USERENV('SESSIONID')||')' as MYCONTEXT from global_name;
2.添加Hibernate兼容性
点击项目右键->MyEclipse->Add Hibernate Capabilities:
3.生成class文件和hbm文件
DB Browser中, 选择目标表, 右键->Hibernate Reverse Engineering, 在对话框中:
A. 选择Java src folder
B.Java package设置包
C.勾选Java Data Access Object (DAO), DAO type选择Spring DAO
D.点击finish