由于昨天的UML画的错误,这次又重新画一下,但也不能确定正确。Hibernate的生命周期UML图如下:
HQL查询实例:
测试代码如下:
/*测试HQL的语句*/
public void testHql(String keyName,String sex){
Session session=null;
List<User> list=null;
try{
/*利用写好的工具类得到session对象*/
session=HibernateUtil.getSession();
String sql="";
/*利用名字的关键字进行模糊查询记录*/
sql="from Useruser where name like :key";
/*利用session对象创建query对象*/
Query query=session.createQuery(sql);
query.setString("key", keyName);
list=query.list();
System.out.println("HQL测试一:");
for(User user:list){
System.out.println(user.getId()+"\t"+user.getName()+"\t"+user.getSex()
+"\t"+user.getEmail()+"\t"+user.getBirthday().toGMTString());
}
/*查询与and操作*/
sql="from Useruser where name like :key and sex=:s";
query=session.createQuery(sql);
query.setString("key", keyName);
query.setString("s", sex);
list=query.list();
System.out.println("HQL测试二:");
for(User user:list){
System.out.println(user.getId()+"\t"+user.getName()+"\t"+user.getSex()
+"\t"+user.getEmail()+"\t"+user.getBirthday().toGMTString());
}
/*查询或or操作*/
sql="from Useruser where name like :key or sex=:s";
query=session.createQuery(sql);
query.setString("key", keyName);
query.setString("s", sex);
list=query.list();
System.out.println("HQL测试三:");
for(User user:list){
System.out.println(user.getId()+"\t"+user.getName()+"\t"+user.getSex()
+"\t"+user.getEmail()+"\t"+user.getBirthday().toGMTString());
}
}finally{
if(session!=null){
session.close();
}
}
}
如下是关于配置信息的源码
1、 配置文件代码:
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql:///crud</property>
<property name="connection.username">root</property>
<property name="connection.password">123456</property>
<!--方言,告诉hibernate是哪一种数据库 -->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<property name="hibernate.show_sql">true</property>
<!--告诉hibernate的映射文件在那里-->
<mapping resource="cn/csdn/domain/User.hbm.xml"/>
</session-factory>
2、 映射文件代码:
<hibernate-mapping
package="cn.csdn.domain">
<class name="User" table="user">
<id name="id">
<generator class="native"/>
</id>
<property name="name"/>
<property name="sex"/>
<property name="email"/>
<property name="birthday"/>
</class>
</hibernate-mapping>
3、 实体定义的domian字段如下并实现无参构造函数与无意义的字段id且没有finaly字段
/*序号id,自动递增*/
private Integer id;
private String name;
private String sex;
private String email;
private Date birthday;
public User() {
super();
// TODO Auto-generatedconstructor stub
}
4、 工具类HibernateUtil类的代码:
public final class HibernateUtil {
private static SessionFactory sessionFactory;
private HibernateUtil(){
}
static{
Configuration cfg=new Configuration();
cfg.configure();
sessionFactory=cfg.buildSessionFactory();
}
public static SessionFactory getSessionFactory() {
return sessionFactory;
}
public static Session getSession(){
return sessionFactory.openSession();
}
}