未加星标

Struts2+Spring3+Hibernate3+MySQL简单登录实现

字体大小 | |
[数据库(mysql) 所属分类 数据库(mysql) | 发布者 店小二03 | 时间 2017 | 作者 红领巾 ] 0人收藏点击收藏

使用Struts2+Spring3+Hibernate3+mysql实现简单登录,下面就开始说小编写的代码。

1.导入相关的jar包
Struts2+Spring3+Hibernate3+MySQL简单登录实现
2.建立数据库 1 create table account(
2 id int(10),
3 user varchar(50),
4 paw varchar(50)
5 );
6 insert into account values(1,'admin','admin'); 3.建立包结构
Struts2+Spring3+Hibernate3+MySQL简单登录实现
4.配置文件的配置及代码 4.1 数据库配置文件:db.properties 1 #jdbc
2 jdbc.driver=com.mysql.jdbc.Driver
3 jdbc.url=jdbc:mysql://127.0.0.1:3306/test
4 jdbc.username=root
5 jdbc.password= 4.2 spring配置文件:applicationContext.xml 1 <?xml version="1.0" encoding="UTF-8"?>
2 <beans xmlns="http://www.springframework.org/schema/beans"
3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
4 xmlns:util="http://www.springframework.org/schema/util" xmlns:jee="http://www.springframework.org/schema/jee"
5 xmlns:tx="http://www.springframework.org/schema/tx" xmlns:jpa="http://www.springframework.org/schema/data/jpa"
6 xmlns:mvc="http://www.springframework.org/schema/mvc"
7 xsi:schemaLocation="
8 http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
9 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd
10 http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.2.xsd
11 http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.2.xsd
12 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
13 http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd
14 http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd">
15 <context:component-scan base-package="ssh.ft"></context:component-scan>
16
17 <context:property-placeholder location="classpath:configs/db.properties" />
18 <!-- datasource -->
19 <bean id="dataSource"
20 class="org.springframework.jdbc.datasource.DriverManagerDataSource">
21 <property name="driverClassName" value="${jdbc.driver}" />
22 <property name="url" value="${jdbc.url}" />
23 <property name="username" value="${jdbc.username}" />
24 <property name="password" value="${jdbc.password}" />
25 </bean>
26 <!-- spring与hibernate整合 spring来管理session的创建、打开和关闭 -->
27 <bean id="sessionFactory"
28 class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
29 <!-- 通过配置文件的方式获取数据源,出现异常,未解决 -->
30 <property name="hibernateProperties">
31 <props>
32 <prop key="connection.useUnicode">true</prop>
33 <prop key="connection.characterEncoding">utf-8</prop>
34 <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
35 <prop key="hibernate.show_sql">true</prop>
36 <prop key="hibernate.hbm2ddl.auto">update</prop>
37 </props>
38 </property>
39 <property name="dataSource" ref="dataSource" />
40 <property name="mappingResources">
41 <list>
42 <!-- 以下用来列出所有的PO映射文件 -->
43 <value>configs/account.hbm.xml</value>
44 </list>
45 </property>
46 </bean>
47 <!-- 定义事物管理器,并位事物管理器配置上述所定义的session -->
48 <!-- <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
49 <property name="sessionFactory"> <ref bean="sessionFactory" /> </property>
50 </bean> <tx:annotation-driven transaction-manager="transactionManager"/> -->
51
52 <!-- 对事物管理器进行设置 表示对save、del、update开头的方法应用事物 -->
53 <!-- <tx:advice id="txAdvice" transaction-manager="transactionManager">
54 <tx:attributes> <tx:method name="save*" propagation="REQUIRED" /> <tx:method
55 name="del*" propagation="REQUIRED" /> <tx:method name="update*" propagation="REQUIRED"
56 /> </tx:attributes> </tx:advice> -->
57
58 <!-- 注入dao -->
59 <bean class="ssh.ft.dao.impl.AccountDaoImpl" id="accountDao">
60 <property name="sessionFactory" ref="sessionFactory"></property>
61 </bean>
62
63 <!--注入service -->
64 <bean class="ssh.ft.service.impl.AccountManagerImpl" id="accountManager">
65 <property name="dao" ref="accountDao"></property>
66 </bean>
67
68 <!--写action和业务逻辑层依赖注入 -->
69 <!--将scope设置成prototype,预防了线程安全问题 -->
70 <bean class="ssh.ft.action.LoginAction" id="loginAction" scope="prototype">
71 <property name="accountManager" ref="accountManager"></property>
72 </bean>
73 </beans>

注: 上述配置中注释掉的事物部分,因为小编未使用到,所以也没有认证,在配置时可去掉

4.4 配置完spring,可以先测试下配置是否正确 1 package ssh.ft.test;
2
3 import java.util.List;
4
5 import org.hibernate.SessionFactory;
6 import org.junit.Test;
7 import org.springframework.context.ApplicationContext;
8 import org.springframework.context.support.ClassPathXmlApplicationContext;
9
10 import ssh.ft.entity.Account;
11
12 public class DBTest {
13 @Test
14 public void test1() {
15 String config = "configs/applicationContext.xml";
16 ApplicationContext ac = new ClassPathXmlApplicationContext(config);
17 SessionFactory sf = ac.getBean(SessionFactory.class);
18 String sql = "from Account";
19 @SuppressWarnings("unchecked")
20 List<Account> list = sf.openSession().createQuery(sql).list();
21 System.out.println(list.size());
22 }
23 }

若配置正确则有如下结果:红色框中的数字1表示数据库中表account中有一条数据,若未出现正确结果,则需要检查上述代码哪里出错,或者是jar的问题

因为小编也遇到过很多jar包不全之类的问题,务必正确之后再往下编写,否则到后面错误或更多导致无法查找


Struts2+Spring3+Hibernate3+MySQL简单登录实现
4.5 struts配置文件:struts.xml 1 <?xml version="1.0" encoding="UTF-8" ?>
2 <!DOCTYPE struts PUBLIC
3 "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
4 "http://struts.apache.org/dtds/struts-2.3.dtd">
5 <struts>
6 <!-- 开发模式 -->
7 <constant name="struts.devMode" value="true" />
8 <!-- 将Action的创建交给spring来管理 -->
9 <constant name="struts.objectFactory" value="spring" />
10
11 <!-- 包含的配置文件 <include file="/configs/struts-user.xml"></include> -->
12 <package name="s2sh" extends="s2sh1">
13 <!-- Action的配置在这里 -->
14 <action name="login" class="loginAction" method="login">
15 <result name="success">/WEB-INF/index.jsp</result>
16 <result name="error">/WEB-INF/login.jsp</result>
17 </action>
18 </package>
19 <package name="s2sh1" extends="struts-default">
20 <action name="tologin" >
21 <result >/WEB-INF/login.jsp</result>
22 </action>
23 </package>
24 </struts> 4.6 hibernate配置文件:hibernate.cfg.xml 1 <!DOCTYPE hibernate-configuration PUBLIC
2 "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
3 "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
4 <hibernate-configuration>
5 <session-factory>
6
7 <!-- 配置数据库方言 -->
8 <property name="dialect"> org.hibernate.dialect.MySQLDialect</property>
9 <!-- 配置打印语句 -->
10 <property name="show_sql">true</property>
11 <property name="format_sql">true</property>
12 <!-- 配置线程安全的session -->
13 <property name="hibernate.current_session_context_class">thread</property>
14 <!--如果表不存在,则会帮你新建 -->
15 <property name="hbm2ddl.auto">create</property>
16 <!-- 映射文件 -->
17 <mapping resource="configs/account.hbm.xml" />
18 </session-factory>
19 </hibernate-configuration> hibernate配置文件还有一个实体映射文件:account.hbm.xml 1 <!DOCTYPE hibernate-mapping PUBLIC
2 "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
3 "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
4 <hibernate-mapping>
5 <class name="ssh.ft.entity.Account" table="account">
6 <!-- 主键 -->
7 <id name="id">
8 <!-- 固定值:主键生成策略 -->
9 <generator class="native"></generator>
10 </id>
11 <!-- 普通属性 -->
12 <property name="user"></property>
13 <property name="paw"></property>
14 </class>
15 </hibernate-mapping>

在hibernate.cfg.xml中的

<mapping resource="configs/account.hbm.xml" />

这个语句里面的account.hbm.xml就是指上述的account.hbm.xml配置文件

4.7 web.xml配置文件 1 <?xml version="1.0" encoding="UTF-8"?>
2 <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
3 <display-name>ssh</display-name>
4 <!-- spring -->
5 <listener>
6 <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
7 </listener>
8 <context-param>
9 <param-name>contextConfigLocation</param-name>
10 <param-value>classpath:configs/applicationContext.xml</param-value>
11 </context-param>
12 <filter>
13 <filter-name>struts2</filter-name>
14 <filter-class>
15 org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
16 </filter-class>
17 <!-- 将struts.xml配置文件放置在src的其他位置无法访问,未解决
18 <init-param>
19 <param-name>filterConfig</param-name>
20 <param-value>classpath:configs/struts.xml</param-value>
21 </init-param>
22 -->
23 </filter>
24 <filter-mapping>
25 <filter-name>struts2</filter-name>
26 <url-pattern>/*</url-pattern>
27 </filter-mapping>
28 </web-app>

注: 上述小编注释了一个未解决的问题,就是struts.xml文件一定要在src目录下方,否则会报错,如果想放在其他地方的话,若有人解决希望一定要留言告诉小编

4.8 实体类:Account.java 1 package ssh.ft.entity;
2
3 public class Account {
4 private Integer id;
5 private String user;
6 private String paw;
7
8 public Integer getId() {
9 return id;
10 }
11
12 public void setId(Integer id) {
13 this.id = id;
14 }
15
16 public String getUser() {
17 return user;
18 }
19
20 public void setUser(String user) {
21 this.user = user;
22 }
23
24 public String getPaw() {
25 return paw;
26 }
27
28 public void setPaw(String paw) {
29 this.paw = paw;
30 }
31
32 } 4.9 dao和daoImpl:AccountDao.java 1 package ssh.ft.dao;
2
3 import ssh.ft.entity.Account;
4
5 public interface AccountDao {
6 public Account findByUser(String user);
7 } AccountDaoImpl.java 1 package ssh.ft.dao.impl;
2
3 import java.util.List;
4
5 import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
6
7 import ssh.ft.dao.AccountDao;
8 import ssh.ft.entity.Account;
9
10 public class AccountDaoImpl extends HibernateDaoSupport implements AccountDao {
11
12 @Override
13 public Account findByUser(String user) {
14 @SuppressWarnings("unchecked")
15 List<Account> list = this.getHibernateTemplate().find("from Account a where a.user=?", user);
16 if (list == null || list.isEmpty()) {
17 return null;
18 }
19 return list.get(0);
20 }
21 } 4.10 service和serviceImpl:AccountManager.java 1 package ssh.ft.service;
2
3 public interface AccountManager {
4 public boolean login(String user, String paw);
5 } AccountManagerImpl.java 1 package ssh.ft.service.impl;
2
3 import ssh.ft.dao.AccountDao;
4 import ssh.ft.entity.Account;
5 import ssh.ft.service.AccountManager;
6
7 public class AccountManagerImpl implements AccountManager {
8 private AccountDao dao;
9
10 public AccountDao getDao() {
11 return dao;
12 }
13
14 public void setDao(AccountDao dao) {
15 this.dao = dao;
16 }
17
18 @Override
19 public boolean login(String user, String paw) {
20 Account account = dao.findByUser(user);
21 if (account == null) {
22 return false;
23 }
24 if (account.getPaw().equals(paw)) {
25 return true;
26 }
27 return false;
28 }
29
30 } 4.11 account处理类:LoginAction.java 1 package ssh.ft.action;
2
3 import com.opensymphony.xwork2.ActionSupport;
4
5 import ssh.ft.entity.Account;
6 import ssh.ft.service.AccountManager;
7
8 public class LoginAction extends ActionSupport {
9 private static final long serialVersionUID = 1L;
10
11 private Account account;
12
13 public Account getAccount() {
14 return account;
15 }
16
17 public void setAccount(Account account) {
18 this.account = account;
19 }
20
21 private AccountManager accountManager;
22
23 public AccountManager getAccountManager() {
24 return accountManager;
25 }
26
27 public void setAccountManager(AccountManager accountManager) {
28 this.accountManager = accountManager;
29 }
30
31 private String msg;
32
33 public String getMsg() {
34 return msg;
35 }
36
37 public void setMsg(String msg) {
38 this.msg = msg;
39 }
40
41 public String login() {
42 System.out.println("login........");44 if (accountManager.login(account.getUser(), account.getPaw())) {
45 return SUCCESS;
46 }
47 setMsg("用户或密码错误");
48 return ERROR;
49 }
50 } 5.页面部分 5.1 页面结构
Struts2+Spring3+Hibernate3+MySQL简单登录实现
5.2 登录页面:login.jsp 1 <[email protected] contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
2 <%@ taglib uri="/struts-tags" prefix="s"%>
3 <!DOCTYPE html>
4 <html>
5 <head>
6 <meta charset="UTF-8">
7 <title>Login</title>
8 </head>
9 <body>
10 <s:form action="login.action">
11 <s:textfield name="account.user" label="用户" />
12 <s:password name="account.paw" label="密码" />
13 <s:submit value="提交" />
14 </s:form>
15 <s:property value="msg"/>
16 </body>
17 </html> 5.3 登录成功页面:index.jsp 1 <[email protected] contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
2 <%@ taglib uri="/struts-tags" prefix="s"%>
3 <!DOCTYPE html>
4 <html>
5 <head>
6 <meta charset="UTF-8">
7 <title>Login</title>
8 </head>
9 <body>
10 <span style="font-family: KaiTi_GB2312; font-size: 18px;">欢迎【<s:property value="account.user" />】登陆!</span>
11 </body>
12 </html> 6.测试,在浏览器输入:http://localhost:8080/ssh/tologin
Struts2+Spring3+Hibernate3+MySQL简单登录实现

成功页面:


Struts2+Spring3+Hibernate3+MySQL简单登录实现

整合到此结束。

Eclipse搭建SSH(Struts2+Spring+Hibernate)框架教程 http://www.linuxidc.com/Linux/2016-11/137193.htm

本文数据库(mysql)相关术语:navicat for mysql mysql workbench mysql数据库 mysql 存储过程 mysql安装图解 mysql教程 mysql 管理工具

主题: HibernateStrutsMySQLSQLSpringXMLUT浏览器Linux数据
分页:12
转载请注明
本文标题:Struts2+Spring3+Hibernate3+MySQL简单登录实现
本站链接:http://www.codesec.net/view/531994.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mysql) | 评论(0) | 阅读(15)