使用Hibernate实现简单的数据库增删改查。

我所使用的是oracle数据库，首先建库：

select *from userinfo
drop table userinfo

create table userinfo(id number primary key not null,uname nvarchar2(20),upwd nvarchar2(20))
insert into userinfo values(1,'lisi','123')

CREATE SEQUENCE HIBERNATE_SEQUENCE MINVALUE 0 MAXVALUE 999;

环境搭建好后，编辑实体类UserInfo，

package po;

public class UserInfo {
    private int id;
    private String uname;
    private String upwd;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUname() {
        return uname;
    }
    public void setUname(String uname) {
        this.uname = uname;
    }
    public String getUpwd() {
        return upwd;
    }
    public void setUpwd(String upwd) {
        this.upwd = upwd;
    }
    

}

UserInfo.hbm.xml配置文件：

<?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="po.UserInfo" table="userinfo">
            <id name="id" column="id" type="java.lang.Integer">
                <generator class="native"/>
            </id>
            <property name="uname" column="uname" type="java.lang.String"/>
            <property name="upwd" column="upwd" type="java.lang.String"/>
        </class>
    </hibernate-mapping>

测试类Test：

package ui;

import java.util.List;

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

import po.UserInfo;

public class Test {

    /**
     * @param args
     */
    public static void main(String[] args) {
        SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
        Session session=sessionFactory.openSession();
        
        Transaction tran = session.beginTransaction();
        
        UserInfo user = new UserInfo();
        user.setId(7);
        user.setUname("lixin");
        user.setUpwd("123");
        
        //session.save(user);    //增
        
        //session.update(user);     //改
        session.delete(user);   //删
    
        //Query query = session.createQuery("from UserInfo where upwd=:upwd").setString("upwd","123");  //查
        Query query = session.createQuery("from UserInfo where uname=:uname and upwd=:upwd").setString("uname","lixin").setString("upwd","123");

        List list = query.list();
        System.out.println(list.size());
        tran.commit();
    
    }

}


当然hibernate.cfg.xml配置文件一定要设置为自己的数据库：

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

    <session-factory>
        <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
        <property name="connection.url">jdbc:oracle:thin:@10.25.117.19:1521:oracle</property>
        <property name="connection.username">scott</property>
        <property name="connection.password">tiger</property>
        <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="myeclipse.connection.profile">oracle</property>
            <mapping resource="po/UserInfo.hbm.xml" />    
    
    </session-factory>

</hibernate-configuration>

最后在Test类里面测试，即可在数据库中看到效果。

需要源码及视频的可以私信我！！！