Hibernate比SQL語句簡單多了，代碼冗余少，切方便簡潔明了。下面用Hibernate+jsp+selvect+HQL來實現注冊用戶。

第一步：編寫用戶實體類和Users2.hbm.xml映射。

/* * 用戶實體類 */public class Users2 { PRivate int id;//用戶id private String name;//用戶昵稱 private String passWord;//用戶密碼 private String telephone;//用戶號碼 private String username;//用戶姓名 private String isadmin;//是否是管理員//省略get和set方法}

<?xml version="1.0"?><!DOCTYPE hibernate-mapping PUBLIC     "-//Hibernate/Hibernate Mapping DTD 3.0//EN"    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping    package="entity">    <class name="Users2" table="Users2">        <id name="id">            <generator class="increment"/>        </id>        <property name="name" />        <property name="password" />        <property name="telephone" />        <property name="username" />        <property name="isadmin"/>    </class></hibernate-mapping>

第二步：配置hibernate.cfg.xml數據庫映射

<!DOCTYPE hibernate-configuration PUBLIC    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration>    <session-factory name="foo">        <!-- 數據庫方言 -->        <property name="dialect">            org.hibernate.dialect.OracleDialect        </property>        <!-- 連接數據庫Url -->        <property name="hibernate.connection.url">            jdbc:oracle:thin:@localhost:1521:orcl        </property>        <!-- 連接驅動 -->        <property name="hibernate.connection.driver_class">            oracle.jdbc.driver.OracleDriver        </property>        <!-- 用戶名 -->        <property name="hibernate.connection.username">epet</property>        <!-- 密碼 -->        <property name="hibernate.connection.password">123456</property>                <!-- 在控制臺打印sql信息 -->        <property name="show_sql">true</property>        <!-- 創建表結構 -->        <property name="hibernate.hbm2ddl.auto">update</property>            <!-- 配置映射信息 -->        <mapping resource="entity/Users2.hbm.xml" />                    </session-factory></hibernate-configuration>

第三步：編寫HibernateUtil類，dao層和daoImpl層

package com.msit.hibernate.HibernateUtil;import org.hibernate.Session;import org.hibernate.SessionFactory;import org.hibernate.cfg.Configuration;public class HibernateUtil {        private HibernateUtil(){            };        public static SessionFactory SessionFactory = null;        static{        //hibernate        Configuration cf = new Configuration();        cf.configure();        SessionFactory = cf.buildSessionFactory();//DriverManager.getconnection()//Session session = SessionFactory.openSession();    }        public static Session getSession(){                return SessionFactory.openSession();    }    //關閉session    public static void closeSession(Session session){        if(session!=null){            session.clear();        }    }}

public interface UserDao {    /*     * 用戶注冊     */    public int addUserList(Users2 user);}

package Dao.Impl;import java.util.List;import org.hibernate.Query;import org.hibernate.Session;import org.hibernate.Transaction;import com.msit.hibernate.HibernateUtil.HibernateUtil;import entity.Users2;import Dao.UserDao;public class UserDaoImpl implements UserDao{/* * 注冊用戶 * (non-Javadoc) * @see Dao.UserDao#addUserList(entity.Users2) */    public int addUserList(Users2 user) {            Session session = HibernateUtil.getSession();     Transaction Transaction=session.beginTransaction();     try{            //對數據保存至數據庫            session.save(user);            //提交事務            Transaction.commit();            return 1;        }catch(Exception e){            e.printStackTrace();            //如果出現異常，事務回滾            Transaction.rollback();               return 0;        }finally{            HibernateUtil.closeSession(session);        }    }}

創建selvect（addUser）和配置web.xml

package selvect;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import entity.Users2;import Biz.Users2Biz;import Biz.Impl.Users2BizImpl;public class addUser extends HttpServlet {    /**     * Constructor of the object.     */    public addUser() {        super();    }    /**     * Destruction of the servlet. <br>     */    public void destroy() {        super.destroy(); // Just puts "destroy" string in log        // Put your code here    }    /**     * The doGet method of the servlet. <br>     *     * This method is called when a form has its tag value method equals to get.     *      * @param request the request send by the client to the server     * @param response the response send by the server to the client     * @throws ServletException if an error occurred     * @throws IOException if an error occurred     */    public void doGet(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        doPost(request, response);    }    /**     * The doPost method of the servlet. <br>     *     * This method is called when a form has its tag value method equals to post.     *      * @param request the request send by the client to the server     * @param response the response send by the server to the client     * @throws ServletException if an error occurred     * @throws IOException if an error occurred     */    public void doPost(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        Users2 user=new Users2();        request.setCharacterEncoding("utf-8");         user.setName(request.getParameter("name"));        user.setPassword(request.getParameter("password"));        user.setTelephone(request.getParameter("telephone"));        user.setUsername(request.getParameter("username"));        Users2Biz biz=new Users2BizImpl();        int i=biz.addUserList(user);        if(i>0){            response.sendRedirect("index.jsp");        }else{            response.sendRedirect("login.jsp");            System.out.print("cuol");        }        }    /**     * Initialization of the servlet. <br>     *     * @throws ServletException if an error occurs     */    public void init() throws ServletException {        // Put your code here    }}

<?xml version="1.0" encoding="UTF-8"?><web-app version="2.5"     xmlns="http://java.sun.com/xml/ns/javaee"     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"     xsi:schemaLocation="http://java.sun.com/xml/ns/javaee     http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">                              <!--注冊用戶-->    <servlet>    <servlet-name>addUser</servlet-name>    <servlet-class>selvect.addUser</servlet-class>    </servlet>      <!-- 映射servlet -->  <servlet-mapping>      <servlet-name>addUser</servlet-name>      <url-pattern>/addUser</url-pattern>  </servlet-mapping>              <welcome-file-list>    <welcome-file>index.jsp</welcome-file>  </welcome-file-list></web-app>

jsp頁面：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>  <head>    <base href="<%=basePath%>">        <title>My JSP 'regs.jsp' starting page</title>        <meta http-equiv="pragma" content="no-cache">    <meta http-equiv="cache-control" content="no-cache">    <meta http-equiv="expires" content="0">        <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">    <meta http-equiv="descrCSS" href="styles.css">    --><LINK rel=stylesheet type=text/css href="css/style.css">  </head><BODY><DIV id=header class=wrap><DIV id=logo><IMG src="images/logo.jpg" width="197px;" height="74px;"></DIV></DIV><DIV id=regLogin class=wrap><DIV class=dialog><DL class=clearfix>  <DT>新用戶注冊</DT>  <DD class=past>填寫個人信息</DD></DL><DIV class=box><FORM action="addUser" method="post"><DIV class=infos><TABLE class=field>  <TBODY>  <TR>    <TD class=field>用 戶 名：</TD>    <TD><INPUT class=text type=text name="name"> </TD></TR>  <TR>    <TD class=field>密　　碼：</TD>    <TD><INPUT class=text type=password name="password"></TD></TR>  <TR>    <TD class=field>確認密碼：</TD>    <TD><INPUT class=text type=password name="repassword"> </TD></TR>  <TR>    <TD class=field>電　　話：</TD>    <TD><INPUT class=text type=text name="telephone"> </TD></TR>  <TR>    <TD class=field>用戶姓名：</TD>    <TD><INPUT class=text type=text name="username"> </TD></TR></TBODY></TABLE><DIV class=buttons><INPUT value=立即注冊 type="submit"></DIV></DIV></FORM></DIV></DIV></DIV><DIV id=footer class=wrap><DL>  <DT>趕集網 © 2010 趕集網 京ICP證1000001號</DT>  <DD>關于我們 · 聯系方式 · 意見反饋 · 幫助中心</DD></DL></DIV>  </BODY>  </HTML>