手把手配置Hibernate环境(JBuilderX版)
来源:互联网 发布:coc刷墙软件 编辑:程序博客网 时间:2024/06/05 02:14
1.安装JBuilderX和Oracle9i,并使用以下信息配置Oracle
用户名:system
密码:admin
服务:cpdb
2.先去http://prodownloads.sourceforge.net/hibernate/下载Hibernate API的包hibernate-2.1.6.zip,如下图所示
3.在JBuilder中选择Project菜单中的Project Properties,在Require Library中加入Hibernate所有的API包,还要加入Oracle目录ORANT/jdbc/lib/classes12.zip
4.然后将截压缩后的hibernate-2.1/etc/hibernate.properties拷贝到本地project的classes目录下然后做以下变化:
①注释默认的数据库连接,将
## HypersonicSQL
hibernate.dialect net.sf.hibernate.dialect.HSQLDialect
hibernate.connection.driver_class org.hsqldb.jdbcDriver
hibernate.connection.username sa
hibernate.connection.password
hibernate.connection.url jdbc:hsqldb:hsql://localhost
hibernate.connection.url jdbc:hsqldb:test
hibernate.connection.url jdbc:hsqldb:.
改为
## HypersonicSQL
#hibernate.dialect net.sf.hibernate.dialect.HSQLDialect
#hibernate.connection.driver_class org.hsqldb.jdbcDriver
#hibernate.connection.username sa
#hibernate.connection.password
#hibernate.connection.url jdbc:hsqldb:hsql://localhost
#hibernate.connection.url jdbc:hsqldb:test
#hibernate.connection.url jdbc:hsqldb:.
然后修改Oracle的连接,将
## Oracle
#hibernate.dialect net.sf.hibernate.dialect.Oracle9Dialect
#hibernate.dialect net.sf.hibernate.dialect.OracleDialect
#hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
#hibernate.connection.username ora
#hibernate.connection.password ora
#hibernate.connection.url jdbc:oracle:thin:@localhost:1521:test
改为
## Oracle
hibernate.dialect net.sf.hibernate.dialect.Oracle9Dialect
hibernate.dialect net.sf.hibernate.dialect.OracleDialect
hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
hibernate.connection.username system
hibernate.connection.password admin
hibernate.connection.url jdbc:oracle:thin:@172.28.122.49:1521:cpdb
注意:@172.28.122.49为Oracle服务器的ip地址,1521为端口号
5.在project下建立package person,在package下建立四个class,分别为:
①PersonModel.java
package person;
import java.io.Serializable;
public class PersonModel implements Serializable {
private Long id;
private String name;
private String address;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public void setName(String name) {
this.name = name;
}
public String getName() {
return name;
}
public void setAddress(String address) {
this.address = address;
}
public String getAddress() {
return address;
}
}
②TestPersonModel1.java
package person;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
import net.sf.hibernate.tool.hbm2ddl.SchemaExport;
public class TestPersonModel1 {
private static SessionFactory sessionFactory;
public static void main(String[] args) throws Exception{
System.out.println("start");
Configuration conf= new Configuration().addClass(PersonModel.class);
SchemaExport dbExport=new SchemaExport(conf);
dbExport.setOutputFile("sql_out_lib//sql.txt");
dbExport.create(true, true);
}
}
③TestPersonModel2.java
package person;
import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
public class TestPersonModel2 {
private static SessionFactory sessionFactory;
public static void main(String[] args) throws Exception{
Configuration conf= new Configuration().addClass(PersonModel.class);
//在表中插入第一条数据
sessionFactory = conf.buildSessionFactory();
Session s = sessionFactory.openSession();
Transaction t = s.beginTransaction();
PersonModel p1=new PersonModel();
p1.setName("zhaol");
p1.setAddress("shanghai");
//持久化
s.save(p1);
//数据库中已有记录
t.commit();
s.close();
}
}
④TestPersonModel3.java
package person;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
import net.sf.hibernate.Query;
public class TestPersonModel3 {
private static SessionFactory sessionFactory;
public static void main(String[] args) throws Exception{
Configuration conf= new Configuration().addClass(PersonModel.class);
sessionFactory = conf.buildSessionFactory();
Session s = sessionFactory.openSession();
PersonModel p = new PersonModel();
Query q = s.createQuery("from PersonModel as p where p.id=1");
p = (PersonModel) q.list().get(0);
System.out.println(p.getName());
s.close();
}
}
其中PersonModel.java是对应数据库中字段的存储结构,TestPersonModel1.java是测试自动创建表和字段,TestPersonModel2.java是测试在表中插入记录,TestPersonModel3.java是测试从表中取得记录.
6.编译所有的java文件
7.好了,到最后一步了,也是最关键的一步,我们已经定义了数据库连接(hibernate.properties)
创建了字段的存储结构(PersonModel.java),也写好了操作数据库的代码(TestPersonModel1.java~TestPersonModel3.java),接下来要做的是定义数据库中表的配置文件,因为我们的字段的存储结构文件是PersonModel.java,所以创建PersonModel.hbm.xml(注意:表的配置文件名是由[字段的存储结构文件名+.hbm.xml]构成,创建位置为project的class/person目录下(注意:数据库定义文件hibernate.properties是放在class目录下的,而表的配置文件要放在相对应的包下,我们这里的包名是person,所以就放在class/person下)
PersonModel.hbm.xml的内容如下:
<?xml version="1.0" encoding="GB2312"?>
<!DOCTYPE hibernate-mapping SYSTEM "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<hibernate-mapping>
<class name="person.PersonModel"
table="zl">
<id name="id" type="long">
<generator class="sequence">
<param name="sequence">ZL_ID_SEQ</param>
</generator>
</id>
<property name="name"/>
<property name="address"/>
</class>
</hibernate-mapping>
表名为zl,里面有两个字段(name和address,对应person.PersonModel),id是一个sequence.
总的目录结构如下图所示
JBuilder内部结构如下:
9.好了,配置完成,接下来运行一下吧,先运行TestPersonModel1.class,让hibernate为我们自动建立一张名为zl(内有字段name和address)的表,运行完成后的JB显示以及数据库的变化如下:
怎么样?表是不是已经建好了,呵呵.
接下来运行TestPersonModel2.class,让hibernate再为我们插入一条记录,运行结果如下:
- [原创]手把手配置Hibernate环境(JBuilderX版)
- 手把手配置Hibernate环境(JBuilderX版)
- 手把手配置Hibernate环境(JBuilderX版)
- 手把手配置hibernate环境
- 利用cvsnt和JBuilderX配置CVS环境
- JBuilderX+SQL Server开发hibernate JBuilderX,SQL
- 手把手教你配置hibernate
- JBuilderX+SQL Server2000开发hibernate
- JBuilderX+SQL Server开发hibernate
- 配置WebLogic 8.1到jbuilderX!
- 手把手教你配置Spring+hibernate
- 手把手教你配置OGRE环境
- Hibernate实验项目全程跟踪,手把手教你配置Hibernate
- Windows Server 2003环境下安装JBuilderX
- 开发环境JBuilderX 向 Eclipse3 迁移
- 配置Hibernate环境
- hibernate环境配置
- 配置hibernate环境
- VCL中ExtractFileName 的問題
- 正则表达式教程之二
- 一个实现图片切换的js代码
- 一段非常简单的创建缩略图的.NET代码
- Toamcat + Soap 配置
- 手把手配置Hibernate环境(JBuilderX版)
- TreeView点击空白处的问题
- acer的罪行!!
- 学习JAVA要学习的东西
- 手机研发的基本流程
- 好书推荐
- 精妙SQL语句
- 直联垄断:深圳银行卡收单市场开放的谎言
- Test1