hibernate1

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:@localhost:1521:xe</property>
        <property name="connection.username">oa100Admin</property>
        <property name="connection.password">oa100Admin</property>
        <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="myeclipse.connection.profile">Oracle10g</property>
   
    <mapping resource="com/hy/oa/entity/Users.hbm.xml"/>
    <mapping resource="com/hy/oa/entity/Vacation.hbm.xml"/>
    <mapping resource="com/hy/oa/entity/Email.hbm.xml"/>
    </session-factory>

</hibernate-configuration>

Users.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">
<!--
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.hy.oa.entity.Users" table="USERS"  >
        <id name="UId" type="java.lang.Integer">
            <column name="U_ID" precision="5" scale="0" />
            <generator class="increment" />
        </id>
        <property name="uname" type="java.lang.String">
            <column name="UNAME" length="20" not-null="true" />
        </property>
        <property name="nickname" type="java.lang.String">
            <column name="NICKNAME" length="20" not-null="true" />
        </property>
        <property name="upassword" type="java.lang.String">
            <column name="UPASSWORD" length="16" not-null="true" />
        </property>
        <property name="usex" type="java.lang.Integer">
            <column name="USEX" length="2" />
        </property>
        <property name="uage" type="java.lang.Integer">
            <column name="UAGE" precision="3" scale="0" not-null="true" />
        </property>
        <property name="utelephone" type="java.lang.String">
            <column name="UTELEPHONE" length="20" not-null="true" />
        </property>
        <property name="uaddress" type="java.lang.String">
            <column name="UADDRESS" length="50" />
        </property>
        <property name="role" type="java.lang.String">
            <column name="ROLE" length="20" not-null="true" />
        </property>
        <property name="isdeleted" type="java.lang.Integer">
            <column name="ISDELETED" precision="2" scale="0" />
        </property>
    </class>
</hibernate-mapping>

HibernateUtil.java


import javax.servlet.jsp.jstl.core.Config;

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

/**
* ThreadLocal是解决线程安全问题一个很好的思路，它通过为每个线程提供一个独立的变量副本解决了变量并发访问的冲突问题。
* 在很多情况下，ThreadLocal比直接使用synchronized同步机制解决线程安全问题更简单，更方便，且结果程序拥有更高的并发性
*
* @author huangyue
*
*/
public class HibernateUtil {
private static ThreadLocal<Session> session = new ThreadLocal<Session>();
private static SessionFactory sf;

static {
// 读取配置文件hibernate.cfg.xml，实现hibernate初始化
sf = new Configuration().configure().buildSessionFactory();
}

public static Session getSession() {
Session s = session.get();
if (s == null || !s.isOpen()) {
s = sf.openSession();
session.set(s);
}
return s;
}

}

public class UsersDaoImpl implements UsersDao {
//查找所有用户信息
public List<Users> findAll() {
Session s = HibernateUtil.getSession();
Query query = s.createQuery("from Users");
List<Users> list = query.list();
s.close();
return list;
}
public static void main(String[] args) {
UsersDaoImpl im = new UsersDaoImpl();
List<Users> list =im.findAll();
}
public boolean update(Users user) {
System.out.println("dao-"+user);
Session s = HibernateUtil.getSession();
Transaction t = s.beginTransaction();
s.update(user);
t.commit();
s.close();
return true;
}
public boolean addUser(Users u){
Session s = HibernateUtil.getSession();
Transaction t = s.beginTransaction();
s.save(u);
t.commit();
s.close();
return true;
}
//是否重名
public boolean findByName(String uname){
String hql ="from Users as u where u.uname=:sameName";
Session s = HibernateUtil.getSession();
Query q = s.createQuery(hql);
q.setString("sameName", uname);

List<Users> list = (List<Users>)q.list();
if(list.size() == 0){
return true;
}
if(list.size() > 0){
return false;
}
return false;
}
}

List<Vacation> list = getHibernateTemplate().find("from Vacation");