培训3-Hibernate.doc

配置jdbc驱动的选择MyEclipse的DB Browser视图：新建一个数据库连接：配置数据库驱动：选择Oracle Thin Driver，点配置驱动：选择Oracle Thin Driver，输入名称：oracle9i，修改url：jdbc:oracle:thin:localhost:1521:admin点击“next”，选择所需要的表空间：选择hyth表空间：完成结果如下：配置hibernate：选择next：选择Existing：选择oracle9i驱动：选择：SessionFactory Class：选择test包：用myeclipse的hibernate编辑器打开配置文件：数据库配置结果图：实体关系映射选择数据库：选择映射的temp表：选择java的源：选择映射类型java types：选择主键映射类型：点击finish，然后选择ok：打开hibernate配置文件：选择映射文件：配置成功结果如下图：然后打开：修改Temp.hbm.xml内容：原内容： 修改为： SEQUENCE_TEMP 修改后主键为sequence类型新建Test类：package test;import org.hibernate.Session;import org.hibernate.Transaction;import java.util.List;public class Test public Test() / 得到数据listpublic List getData(String table) Transaction tx = null;Session s = null;List list = null;String sql = from + table;try s = HibernateSessionFactory.currentSession();tx = s.beginTransaction();list = s.createQuery(sql).list();mit(); catch (Exception e) e.printStackTrace(); finally if (HibernateSessionFactory.currentSession() != null)HibernateSessionFactory.closeSession();return list;/ 增加数据public void addData(String name, Long score) Transaction tx = null;Session s = null;List list = null;Temp temp = null;try s = HibernateSessionFactory.currentSession();tx = s.beginTransaction();temp = new Temp();temp.setName(name);temp.setScore(score);s.save(temp);mit();System.out.println(Insert Data Success!); catch (Exception e) e.printStackTrace();/ 修改数据public void updateData(Long id, String name, Long score) Transaction tx = null;Session s = null;List list = null;Temp temp = null;try s = HibernateSessionFactory.currentSession();tx = s.beginTransaction();temp = (Temp) s.get(Temp.class, id);temp.setName(name);temp.setScore(score);s.save(temp);mit();System.out.println(Update Data Success!); catch (Exception e) e.printStackTrace();/ 删除数据public void deleteData(Long id) Transaction tx = null;Session s = null;List list = null;Temp temp = null;try s = HibernateSessionFactory.currentSession();tx = s.beginTransaction();temp = (Temp) s.get(Temp.class, id);s.delete(temp);mit();System.out.println(Delete Data Success!); catch (Exception e) e.printStackTrace();public static void main(String args) Test t = new Test();t.deleteData(2l);t.updateData(1l, qq, 93l);t.addData(djxx, 99l);List list = t.getData(Temp);Temp temp = null;for (int i = 0; i list.size();