你的位置:首页 > Java教程

[Java教程]Java_Web三大框架之Hibernate+jsp+selvect+HQL登入验证


刚开始接触Hibernate有些举手无措,觉得配置信息太多。经过一个星期的适应,Hibernate比sql简单方便多了。下面做一下Hibernate+jsp+selvect+HQL登入验证。

第一步:编写用户实体类和配置用户Users2.hbm.

/* * 用户实体类 */public class Users2 { private int id;//用户id private String name;//用户昵称 private String password;//用户密码 private String telephone;//用户号码 private String username;//用户姓名 private String isadmin;//是否是管理员//省略get和set方法}

<??><!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.

<!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. />          </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 {    public 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();  }    public static void closeSession(Session session){    if(session!=null){      session.clear();    }  }}

 

 

public interface UserDao {  /*   * 验证登入   */  public int isExist(String name,String password);}

public class UserDaoImpl implements UserDao{  public int isExist(String name, String password) {       int i=0;       //获取Session     Session session = HibernateUtil.getSession();     //开启事物     Transaction Transaction=session.beginTransaction();        //HQL语句      Query query = session.createQuery("from Users2 u where u.username = ? and u.password = ?");     query.setString(0, name);     query.setString(1, password);     List<Users2> list = query.list();    if(list.size()>0){      i=1;    }else{      i=0;    }           return i;  }}

第四步:编写UserSelvect和web_

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 Biz.Users2Biz;import Biz.Impl.Users2BizImpl;public class UserSelvect extends HttpServlet {  /**   * Constructor of the object.   */  public UserSelvect() {    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 {    request.setCharacterEncoding("utf-8");    String name=request.getParameter("name");    String password=request.getParameter("password");    Users2Biz biz=new Users2BizImpl();    int i=biz.isExist(name, password);    if(i>0){            response.sendRedirect("index.jsp");    }else{      response.sendRedirect("login.jsp");          }    }  /**   * Initialization of the servlet. <br>   *   * @throws ServletException if an error occurs   */  public void init() throws ServletException {    // Put your code here  }}

<??><web-app version="2.5"   ="http://java.sun.com/   ="http://www.w3.org/2001/   xsi:schemaLocation="http://java.sun.com/>            <!--验证用户登入-->  <servlet>  <servlet-name>UserSelvect</servlet-name>  <servlet-class>selvect.UserSelvect</servlet-class>  </servlet>   <!-- 映射servlet --> <servlet-mapping>   <servlet-name>UserSelvect</servlet-name>   <url-pattern>/UserSelvect</url-pattern> </servlet-mapping>    <welcome-file-list>  <welcome-file>index.jsp</welcome-file> </welcome-file-list></web-app>

login.jsp页面

<H4>用户登录</H4><FORM method="post" action="UserSelvect"><DIV class=infos><TABLE class=field> <TBODY> <TR>  <TD colSpan=2></TD></TR> <TR>  <TD class=field>用 户 名:</TD>  <TD><!-- <input type="text" name="name" /> --><INPUT    id=user_name class=text type=text name=name> </TD></TR> <TR>  <TD class=field>密  码:</TD>  <TD><input type="password" class="text" name="password" /> </TD></TR></TBODY></TABLE><DIV class=buttons> <INPUT onclick='document.location="UserSelvect"' value=登陆 type="submit"> <INPUT onclick='document.location="regs.jsp"' value=注册 type=button> </DIV></DIV></FORM>

 

成功页面:

<%@ 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 'index.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="description" content="This is my page">  <!--  <link rel="stylesheet" type="text/css" href="styles.css">  --> </head>  <body>  登入成功。 </body></html>