Struts+hibernate简单连接数据库注册实例

最新推荐文章于 2022-03-01 21:52:08 发布

qq_1572902205

最新推荐文章于 2022-03-01 21:52:08 发布

阅读量451

点赞数

分类专栏：学习之路文章标签： hibernate struts2.0 实例

本文链接：https://blog.csdn.net/qq_20477309/article/details/51356913

版权

学习之路专栏收录该内容

26 篇文章 0 订阅

订阅专栏

1、ALT+SHIFT+S generate Getters and Setter
2、首个jsp页面不显示原因：web.xml中

 <filter-mapping>
    <filter-name>struts2</filter-name>
    <url-pattern>*.action</url-pattern>
  </filter-mapping>

应改为:

 <filter-mapping>
    <filter-name>struts2</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>

3、不能解析User.hbm.xml文件，原因丢失如下代码：

private int id;
public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }

4、注册信息为空原因：参数传递不一致，变量命名重复，作用空间理解混乱。

5、index.jsp页面代码：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

  </head>

  <body>
    <form action="hello" method="post">
        用户名：<input type="text" name="name"><br><br>
        密码：<input type="text" name="birthday"><br><br>
        <input type="submit" value="登录">
    </form>
  </body>
</html>

6、web.xml代码如下：

<?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">
  <display-name></display-name> 
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  <filter>
    <filter-name>struts2</filter-name>
    <filter-class>
        org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
    </filter-class>
  </filter>
  <filter-mapping>
    <filter-name>struts2</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  <servlet>
    <description>This is the description of my J2EE component</description>
    <display-name>This is the display name of my J2EE component</display-name>
    <servlet-name>loginser</servlet-name>
    <servlet-class>Action.loginser</servlet-class>
  </servlet>

  <servlet-mapping>
    <servlet-name>loginser</servlet-name>
    <url-pattern>/servlet/loginser</url-pattern>
  </servlet-mapping></web-app>

7、struts.xml代码如下：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">
<struts>
    <package name="Action" namespace="/" extends="struts-default">
    <action name="hello" class="Action.login">
    <result name="success">/positive.jsp</result>
    <result name="error">/negative.jsp</result>
    </action>
    </package>
</struts>

8、login.java代码如下：

package Action;
import domain.User;
import domain.userDatabase;
import com.opensymphony.xwork2.ActionSupport;
import java.io.IOException;
import javax.servlet.ServletException;


public class login extends ActionSupport{
    private User user;
    userDatabase Database=new userDatabase();
    private String name;
    private String birthday;
    public String getName() {
        return name;
    }
    public void setName(String name){
        this.name=name;
    }

    public String getBirthday() {
        return birthday;
    }
    public void setBirthday(String birthday){
        this.birthday=birthday;
    }

    public String execute()
            throws ServletException, IOException
    {
        try {
            user=new User();
            user.setName(name);
            user.setBirthday(birthday);
        } catch (Exception e) {
            // TODO: handle exception
        }

        if(Database.addUser(user)==1)
            return "success";
        else 
            return "error";
    }

}

9、User.java代码如下：

package domain;
public class User{
    private int id;
    private String name;
    private String birthday;
    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;
    }
    public String getBirthday() {
        return birthday;
    }
    public void setBirthday(String birthday) {
        this.birthday = birthday;
    }



}

10、User.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">
<hibernate-mapping package="domain">
    <class name="User">
        <id name="id">
            <generator class="native"/>
        </id>
        <property name="name"/>
        <property name="birthday"></property>
    </class>
</hibernate-mapping>

11、userDatabase.java代码如下：

package domain;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

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


public class userDatabase 
{
    public int addUser(User user) 
    {
        Configuration cfg=new Configuration();
        cfg.configure();
        SessionFactory sessionFactory=cfg.buildSessionFactory();
        Session session=null;
        Transaction tx=null;
            try {

                session=sessionFactory.openSession();
                tx=session.beginTransaction();
                session.save(user);
                tx.commit();
            } catch (Exception e) {
                // TODO: handle exception
            }
        return 1;
    }

}

12、hibernate.cfg.xml代码如下：

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

    <session-factory>

        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/test
        </property>
        <property name="connection.username">root</property>
        <property name="connection.password">0514</property>
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="hbm2ddl.auto">update</property>
        <property name="show_sql">true</property>
        <mapping resource="domain/User.hbm.xml"/>
    </session-factory>


</hibernate-configuration>