首先介绍Myeclipse自带hibernate功能;
加入hibernate功能()
打开Myeclipse Database Explore(在myeclipse里面看数据库)
window->open perspective->Myeclipse database explore,点击进去
左边可以新建数据库DB Browser对象
空白处右键-〉New->
Driver template(连接什么数据库,oralce选择Oracle(Thin driver))->
Driver name:出现在左边的名字
connection url:连接url
user name:数据库帐号
password:数据库密码
Driver Jars:add jars添加连接用的JAR包
生成对象domain
打开对应的oracledriver->conneted to oracledriver->neil->table
在要生成的表上右键-〉hibernate reverse enginging->
在弹出的框上java src folder:选择哪个项目的SRC目录
java package:生成的类放在哪个包里面
1. create pojo<> db table mapping infomation,勾选生成JAVABEAN的映射文件XML
2.生成JAVABEAN
*第二------------------------------------------------------------------------------------------------------------
手動加入hibernate功能
1.加jar包
2.編寫hibernate.cfg.xml文件 ,主要用於配置數據庫(oracel),
<!-- 数据库连接配置 -->
<property name="myeclipse.connection.profile">
OracleDriver
<property name="myeclipse.connection.profile">
OracleDriver
<property name="connection.url">
jdbc:oracle:thin:@localhost:1521:xe
</property>
<property name="connection.username">neil</property>---oracel账号
<property name="connection.password">myspace</property>-----oracel密码
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
次要用於加入mapping文件
<mapping resource="domain/Userinfo.hbm.xml"/> ----- 映射文件
3.编写mapping文件 hbm.xml
<hibernate-mapping>
<!-- name是导入包名,table此类映射哪张表名,id是主键,name是属性,column是這張表裡面的字段
如果屬性和和字段名一樣,可以省掉column,如果表名和類名一樣,可以省掉table -->
<!-- *类就就是表, 属性就是字段-->
<class name="domain.Userinfo" table="USERINFO">
<id name="userid" column="USERID">
<generator class="assigned"></generator>
</id>
<property name="userpwd" column="USERPWD" />
</class>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
</hibernate-mapping>
4.测试添加
//如何添加一个对象到数据库
//1.读取hibernate配置文件 :hibernate.cfg.xml
Configuration config = new Configuration().configure();
//2.从配置文件中得到一个factory类
SessionFactory sessionFactory = config.buildSessionFactory();
//3.从SessionFactory工厂中得到Session
Session session = sessionFactory.openSession();
//开启事务
Transaction transaction = session.beginTransaction();
//用session对象添加一条记录
Userinfo u = new Userinfo();
u.setUserid("454545");
u.setUserpwd("232323");
session.save(u);
//两种方式
//1.提交事务,相当于commit;
transaction.commit();
//2.关闭session
//session.close();