首页 > 代码库 > Hibernate逆向工程

Hibernate逆向工程

MySQL Administrator 创建表

 
MyEclipse Database Explorer视图:
1. New 
2 .Driver template: MySQL Connector/J
Driver name: 给定一个连接名称
Connection URL: jdbc:mysql://<hostname>[<:3306>]/<dbname>相应的修改
User name: MySQL连接名
Password: MySQL连接密码
Driver JARs: 添加 mysql-connector-java-5.1.7-bin.jar包
Save password + Connect to database on MyEclipse startup
3. 选择Display the seleted schemas - 添加表名
4. Finish
 
1. 右击表名—Hibernate Reverse Engineering...
2. Next — Id Generator:native
3. Finish
 
添加Struts 1.3 capabilities 和 Hibernate 3.1 capabilities
 
新建Struts1.3 Action: CRUD(create、read、update、delete)
例子:
create:
  //创建一个HibernateCrud实体类,以供数据的填充
  //HibernateCrud实体类相当于一条数据库中的记录(相当于一个bean)
  HibernateCrud HibernateCrud_ref = new HibernateCrud();
  HibernateCrud_ref.setUsername("大小");
  HibernateCrud_ref.setAge(22);
 
  //从HibernateSessionFactory类中的ThreadLocal类中获得一个Session对象
  //这个session对象就相当于JDBC中的Connection类
  Session session = HibernateSessionFactory.getSession();
 
  //启动事务保证数据的完整性
  Transaction tra = session.beginTransaction();
  //保存实体类以将这个实体类通过Hibernate映射机制转换成数据库中的一条记录
  session.save(HibernateCrud_ref);
  //提交事务
  tra.commit();
  //关闭session,释放数据库的链接资源
  session.close();
read:
  //获得Session对象从HibernateSessionFactory类中的ThreadLocal对象中
  Session session = HibernateSessionFactory.getSession();
  //启动事务
  Transaction tra = session.beginTransaction();
  //通过Session对象的引用session的load方法来从数据库中取得一个id为1的实体类HibernateCrud.class
  HibernateCrud HibernateCrud_ref = (HibernateCrud) session.load(HibernateCrud.class, new Integer(1));
  //显示这个实体类的信息
  System.out.println("id=" + HibernateCrud_ref.getId());
  System.out.println("username=" + HibernateCrud_ref.getUsername());
  System.out.println("age=" + HibernateCrud_ref.getAge());
  System.out.println("registerTime=" + HibernateCrud_ref.getRegisterTime());
  //提交事务
  tra.commit();
  //关闭session,释放数据库的连接
  session.close();
update:
  //取得session对象
  Session session = HibernateSessionFactory.getSession();
  //启动事务
  Transaction tra = session.beginTransaction();
  //取得旧数据并且开始更新旧数据
  HibernateCrud HibernateCrud_old_ref = (HibernateCrud) session.load(HibernateCrud.class, new Integer(1));
  System.out.println("id=" + HibernateCrud_old_ref.getId());
  System.out.println("username="+ HibernateCrud_old_ref.getUsername());
  System.out.println("age=" + HibernateCrud_old_ref.getAge());
  System.out.println("registerTime=" + HibernateCrud_old_ref.getRegisterTime());
  //重新对实体类的属性进行更改,然后同步更新数据库中记录的字段
  HibernateCrud_old_ref.setUsername("最新版");
  HibernateCrud_old_ref.setAge(100);
  //同步更新到数据库中
  session.update(HibernateCrud_old_ref);
  //提交事务
  tra.commit();
  //关闭session对象,释放数据库连接
  session.close();
delete:
  //取得Session对象
  Session session = HibernateSessionFactory.getSession();
  //启动事务
  Transaction tra = session.beginTransaction();
  //从数据库中通过load方法取得HibernateCrud的实体类,查询条件是主键为1
  HibernateCrud HibernateCrud_old_ref = (HibernateCrud) session.load(HibernateCrud.class, new Integer(1));
  System.out.println("id=" + HibernateCrud_old_ref.getId());
  System.out.println("username" + HibernateCrud_old_ref.getUsername());
  System.out.println("age=" + HibernateCrud_old_ref.getAge());
  System.out.println("registerTime=" + HibernateCrud_old_ref.getRegisterTime());
  //在Hibernate中删除数据库中的记录是通过一个实体类进行删除的
  //所以在删除的操作中需要先找到实体类,然后再通过Session对象的delete()方法
  //来删除数据库中的记录
  session.delete(HibernateCrud_old_ref);
  //提交事务
  tra.commit();
  //关闭session对象,释放数据库的连接
  session.close();
 
部署、测试