Hibernate学习总结

首先声明这是个坑爹的框架

属于ssh经典框架中的持久层框架，说白了就是管理数据库的。

下载地址：http://hibernate.org/orm/

这里写了版本5.2，下载下来的基本不怎么会用，因为文件结构变化太大，也可能没什么人用了。所以我下了3点多版的。

想方便使用Hibernate框架，还要下个Hibernate Tools，不下也行就是写配置文件方便点而已。

下载地址：http://hibernate.org/tools/

配置Tools只要把features，plugins两个文件夹copy到eclipse中就行，eclipse本身就有这两个文件夹，点合并。

想要在项目中用Hibernate，肯定要导jar包吧，教程坑爹的只告诉你导入hibernate3.jar这个包。

是的，导入之后运行就会告诉你还要导别的包。现在一次说总结清楚。

首先导入hibernate3.jar

然后导入required包，运行发现还要个jpa，就把jpa包导入，才能运行成功，它们都在lib下的。

写成一个Hibernate的Demo真的麻烦，有人教你在配置后用mapping这玩意么

运行需要几个东西：hibernate.cfg.xml,类名.cfg.xml,类

有了Tools这个东西，就不用担心了。

首先hibernate.cfg.xml放在src包下，类名.cfg.xml放在与类同包下。

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">

<hibernate-configuration>

    <session-factory>

        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>

        <property name="connection.username">账号</property>

        <property name="connection.password">密码</property>

        <property name="connection.url">jdbc:mysql://localhost:3306/数据库名?useSSL=true</property>

        <property name="connection.characterEncoding">utf-8</property>

        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

        <mapping resource="package2/persion.hbm.xml" />

    </session-factory>

</hibernate-configuration>

类名.cfg.xml

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<!-- Generated 2016-7-20 15:57:35 by Hibernate Tools 3.4.0.CR1 -->

<hibernate-mapping>

    <class name="package2.persion" table="PERSION">

        <id name="id" type="int">

            <column name="id" />

            <generator class="assigned" />

        </id>

        <property name="name" type="java.lang.String">

            <column name="name" />

        </property>

    </class>

</hibernate-mapping>

persion.java

public class persion {

    int id;

    String name;

    public int getId() {

        return id;

    }

    public void setId(int id) {

        this.id = id;

    }

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

}

HibernateExecute.java

import java.util.Iterator;

import java.util.List;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.cfg.Configuration;

public class HibernateExecute {

    public static void main(String[] args) {

        Configuration cfg=new Configuration().configure();

        SessionFactory ssf=cfg.buildSessionFactory();

        Session session=ssf.openSession();

        session.beginTransaction();

        String hql="FROM persion";

        Query q=session.createQuery(hql);

        List list=q.list();

        Iterator<persion> it=list.iterator();

        while(it.hasNext()){

            persion p=it.next();

            System.out.println(p.getId()+" "+p.getName());

        }

        if(session.isOpen())

            session.close();

    }

}

persion是这样一个简单的表

运行后无疑是正常的

写单机程序是非常无趣的，只不过它给定了一个范式。

struts2+hibernate3合体是这样写的

DAO层该干嘛干嘛，Action负责调用DAO层处理数据然后传输到页面。就这么简单。

按照惯例先定义一个接口：

import java.util.List;

public interface DataOperation {

    public boolean InsertIntoUser(user user);

    public boolean DeleteUser(user user);

    public List QueryAllUser();

    public void updateUser(user user);

    public List<user> SelectUser(user user);

}

然后接口实现类:

import java.util.List;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.envers.RevisionTimestamp;

public class OperationImpl implements DataOperation{

    @Override

    public boolean InsertIntoUser(user user) {

        // TODO Auto-generated method stub

        boolean success=false;

        SessionInstance getsession=new SessionInstance();

        Session session=getsession.SessionInstance();

        session.beginTransaction();

        String hql="from user as user where user.username=:name";

        Query q=session.createQuery(hql);

        q.setString("name", user.getUsername());

        List<user> list=q.list();

        if(list.isEmpty())

        {

            session.save(user);

            session.getTransaction().commit();

            success=true;

        }

        session.close();

        return success;

    }

    @Override

    public boolean DeleteUser(user user) {

        System.out.println("删除执行");

        // TODO Auto-generated method stub

        boolean isDelete=false;

        SessionInstance getsession=new SessionInstance();

        Session session=getsession.SessionInstance();

        session.beginTransaction();

        String hql="from user as user where user.username=:name";

        Query q=session.createQuery(hql);

        q.setString("name", user.getUsername());

        List<user> l=q.list();

        if(!l.isEmpty())

        {

            String del="delete user where username=:name";

            Query delete=session.createQuery(del);

            delete.setParameter("name", user.getUsername());

            delete.executeUpdate();

            session.getTransaction().commit();

            isDelete=true;

            System.out.println("删除成功:"+user.getUsername());

        }

        session.close();

        return isDelete;

    }

    @Override

    public List<user> QueryAllUser() {

        SessionInstance getsession=new SessionInstance();

        Session session=getsession.SessionInstance();

        Query q=session.createQuery("from user");

        List<user> list=q.list();

        session.close();

        return list;

    }

    @Override

    public void updateUser(user user) {

        // TODO Auto-generated method stub

    }

    @Override

    public List<user> SelectUser(user user) {

        SessionInstance getsession=new SessionInstance();

        Session session=getsession.SessionInstance();

        session.beginTransaction();

        String hql="from user as user where user.username=:name and user.tel=:tel";

        Query q=session.createQuery(hql);

        q.setString("name", user.getUsername());

        q.setString("tel", user.getTel());

        List<user> l=q.list();

        System.out.println("空:"+l.isEmpty());

        session.close();

        return l;

    }

}

然后类似一个工具类

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.cfg.Configuration;

public class  SessionInstance {

    public Session SessionInstance(){

        Configuration cfg=new Configuration().configure();

        SessionFactory sessionFactory=cfg.buildSessionFactory();

        Session session=sessionFactory.openSession();

        return session;

    }

}

注意Session，Configuration这些都是hibernate包下的。

然后就是写几个页面了，配action啊之类的。

QueryAll和Update没写，一个模式就不写了。还没搞懂怎么从POJO的List传到前端,所以QueryAll直接写成JSP了。

<%@page import="org.hibernate.SessionFactory"%>

<%@page import="DAOLayer.user"%>

<%@page import="java.util.Iterator"%>

<%@page import="java.util.List"%>

<%@page import="org.hibernate.Query"%>

<%@page import="org.hibernate.Session"%>

<%@page import="org.hibernate.cfg.Configuration"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>遍历数据表</title>

</head>

<body>

    <%

        Configuration cfg=new Configuration().configure();

        SessionFactory sf=cfg.buildSessionFactory();

        Session ses=sf.openSession();

        ses.beginTransaction();

        String hql="FROM user";

        Query q=ses.createQuery(hql);

        List list=q.list();

        Iterator<user> it=list.iterator();

        while(it.hasNext()){

            user u=it.next();

            out.write("用户名："+u.getUsername()+" 密码："+u.getPassword()+" 电话号码："+u.getTel());

            out.print("<br/>");

        }

        if(ses.isOpen())

            ses.close();

    %>

</body>

</html>

持久层对象user.java

public class user {

    private String username;

    private String password;

    private String tel;

    public String getUsername() {

        return username;

    }

    public void setUsername(String username) {

        this.username = username;

    }

    public String getPassword() {

        return password;

    }

    public void setPassword(String password) {

        this.password = password;

    }

    public String getTel() {

        return tel;

    }

    public void setTel(String tel) {

        this.tel = tel;

    }

}

数据表也是个简单表。

值得注意的是，这个主键id根本不需要管它，自增的话不需要写进持久层对象，会有什么问题我就不懂了，至今还正常。

再贴几个Action

InsertActon.java

import com.opensymphony.xwork2.ActionContext;

import com.opensymphony.xwork2.ActionSupport;

import com.opensymphony.xwork2.ModelDriven;

import DAOLayer.OperationImpl;

import DAOLayer.user;

public class InsertAction extends ActionSupport implements ModelDriven<user>{

    private user user =new user();

    public user getUser() {

        return user;

    }

    public void setUser(user user) {

        this.user = user;

    }

    public String execute(){

        System.out.println(user.getUsername() + " " + user.getPassword() + " " + user.getTel());

        OperationImpl insert = new OperationImpl();

        boolean IsSuccess = insert.InsertIntoUser(user);

        if (IsSuccess) {

            ActionContext context = ActionContext.getContext();

            context.getSession().put("username", user.getUsername());

            context.getSession().put("telephone", user.getTel());

            return SUCCESS;

        }

        return "faliure";

    }

    @Override

    public user getModel() {

        return this.user;

    }

}

DeleteAction.java

import com.opensymphony.xwork2.ActionSupport;

import com.opensymphony.xwork2.ModelDriven;

import DAOLayer.OperationImpl;

import DAOLayer.user;

public class DeleteAction extends ActionSupport implements ModelDriven<user>{

    private user user=new user();

    @Override

    public user getModel() {

        // TODO Auto-generated method stub

        return user;

    }

    public String execute(){

        OperationImpl delete=new OperationImpl();

        boolean b=delete.DeleteUser(user);

        if(b)

            return SUCCESS;

        return "faliure";

    } 

}

SelectAction.java

import java.util.List;

import com.opensymphony.xwork2.ActionContext;

import com.opensymphony.xwork2.ActionSupport;

import com.opensymphony.xwork2.ModelDriven;

import DAOLayer.OperationImpl;

import DAOLayer.user;

public class SelectAction extends ActionSupport implements ModelDriven<user>{

    private user user=new user();

    public String execute(){

        OperationImpl select=new OperationImpl();

        List<user> list=select.SelectUser(user);

        if (!list.isEmpty()) {

            for (user u : list)

                System.out.println(u.getUsername() + " " + u.getPassword() + " " + u.getTel());

            ActionContext context = ActionContext.getContext();

            context.getSession().put("username_result", list.get(0).getUsername());

            context.getSession().put("password_result", list.get(0).getPassword());

            context.getSession().put("tel_result", list.get(0).getTel());

        }

        return SUCCESS;

    }

    @Override

    public user getModel() {

        // TODO Auto-generated method stub

        return user;

    }

}

最后贴个搜索结果处理，感觉这些api还不够方便，而且Action传值只能使用s标签库，每个jsp都会被服务器解析，会影响服务器效率。今后尝试使用AJAX技术吧，还没学会。

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>查询结果</title>

</head>

<body>

    <%

        String username="";

        if(!(session.getAttribute("username_result")==null))

            username=session.getAttribute("username_result").toString();

        String passwd="";

        if(!(session.getAttribute("password_result")==null))

             passwd=session.getAttribute("password_result").toString();

        String tel="";

        if(!(session.getAttribute("tel_result")==null))

            tel=session.getAttribute("tel_result").toString();

        System.out.println("用户名："+username);

        if(username.equals(""))

        {

            out.print("没有此用户");

            out.print("<br/>");

        }

        else

        {

            out.print("用户名："+username);

            out.print("<br/>");

            out.print("密码："+passwd);

            out.print("<br/>");

            out.print("电话："+tel);

            out.print("<br/>");

        }

    %>

</body>

</html>

运行还算顺利。

巴特西

Hibernate学习总结

最新文章

热门文章