hibernate连接数据库

  计应134 郑寿奎

1.新建项目 
2.新建hibernate.xml框架 右击项目名->MyEclipse->add hibernate
3.新建一个对数据库表进行操作的 名字.hbm.xml模块 右击src->new->XML(Basic templates)->（改名字）Next->(create XMLfile from a DTD file)Next->(Select XML Catalog entry)Key中找到Hibernate Mapping DTD 3.0 Next->Finish
4.配置对数据库表进行操作的名字.hbm.xml模块 视图操作
(1).右击模块名字->new->Class 添加 Name和Table(数据库表名)属性
(2).右击Class 分别new ID和property 注：ID分别new column和generator ID要改为手动输入： <generator class="assigned"/>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
 <class name="com.abc.Person" table="T_person">
  <id name="ID" type="java.lang.Integer">
   <column name="person_id"/>
   <generator class="assigned"/>
  </id>
  <property generated="never" lazy="false" name="Name" type="java.lang.String"/>
  <property generated="never" lazy="false" name="age" type="java.lang.Integer"/>
  <list name="schools" table="school">
   <key column="person_id" not-null="true"/>
   <list-index base="0" column="list_order"/>
   <element column="schoos_name" type="java.lang.String"/>
  </list>
 </class>
</hibernate-mapping>

5.配置hibernate.xml框架

创建一个DB连接数据库

在hibernate.xml选择视图操作

在DB Driver里选择创建好的DB数据库连接，最后在Mappings里Add添加Person.hbm.xml

6.对与数据库表相对应的实体类操作

主要是与数据库表的属性，字段一致，右击空白处->Source->Generate Getters and Setters...添加Get和Set

package com.abc;

import java.util.ArrayList;
import java.util.List;

public class Person {
    private Integer ID;
    private String Name;
    private int age;
    private List<String> schools=new ArrayList<String>();
    public Integer getID() {
        return ID;
    }
    public void setID(Integer iD) {
        ID = iD;
    }
    public String getName() {
        return Name;
    }
    public void setName(String name) {
        Name = name;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    public List<String> getSchools() {
        return schools;
    }
    public void setSchools(List<String> schools) {
        this.schools = schools;
    }

}

7.调用使用

package com.abc;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class Test {

  public static void a(){
      
      Configuration configuration=new Configuration().configure();
      //configuration.configure("/hibernate.cfg.xml");
      
      SessionFactory sessionFactory=configuration.buildSessionFactory();
      Session session=sessionFactory.openSession();
      Transaction trans=session.beginTransaction();
      Person b=new Person();
      b.setID(123);
      b.setAge(0);
      b.setName("张三");
      List<String> schools=new ArrayList<String>();
      schools.add("高中");
      schools.add("学校");
      b.setSchools(schools);
      session.save(b);
      trans.commit();
      session.close();
  }

}

8.index.jsp调用方法

9.单击添加Tomcat服务器运行

用这种方法只用于举例和简单的操作，一般都是用MyEclipse自带的逆向生成实体类方法