将商城项目改为struts2和hibernate,并增加管理员页面

对注册用户的操作:

1.model层:

View Code

 1 package com.shopping.model;
 2 
 3 import java.sql.Timestamp;
 4 
 5 import javax.persistence.Entity;
 6 import javax.persistence.GeneratedValue;
 7 import javax.persistence.Id;
 8 
 9 @Entity(name="ruser")
10 public class User {
11     private int id;
12     private String username;
13     private String password;
14     private String phone;
15     private String address;
16     private Timestamp rdate;
17     
18     @Id
19     @GeneratedValue
20     public int getId() {
21         return id;
22     }
23     public void setId(int id) {
24         this.id = id;
25     }
26     public String getUsername() {
27         return username;
28     }
29     public void setUsername(String username) {
30         this.username = username;
31     }
32     public String getPassword() {
33         return password;
34     }
35     public void setPassword(String password) {
36         this.password = password;
37     }
38     public String getPhone() {
39         return phone;
40     }
41     public void setPhone(String phone) {
42         this.phone = phone;
43     }
44     public String getAddress() {
45         return address;
46     }
47     public void setAddress(String address) {
48         this.address = address;
49     }
50     public Timestamp getRdate() {
51         return rdate;
52     }
53     public void setRdate(Timestamp rdate) {
54         this.rdate = rdate;
55     }
56     
57     
58 }

2.DAO层:

View Code

 1 package com.shopping.dao;
 2 
 3 import java.util.List;
 4 
 5 import com.shopping.model.User;
 6 
 7 public interface UserDAO {
 8 
 9     public boolean save(User u);
10     
11     public List<User> getUsers();
12     
13     public void deleteById(int id);
14     
15 }

3.DAOImpl:

View Code

 1 package com.shopping.dao.impl;
 2 
 3 import java.util.List;
 4 
 5 import org.hibernate.HibernateException;
 6 import org.hibernate.Query;
 7 import org.hibernate.Session;
 8 
 9 import com.shopping.dao.UserDAO;
10 import com.shopping.model.User;
11 import com.shopping.util.HibernateUtil;
12 
13 public class UserDAOImpl implements UserDAO{
14 
15     Session s = null;
16     
17     private void begin(){
18         if(null != s){
19             s.beginTransaction();
20         }
21     }
22     
23     private void commit(){
24         if(null != s){
25             s.getTransaction().commit();
26         }
27     }
28     
29     @Override
30     public boolean save(User u) {
31         s = HibernateUtil.getSession();
32         this.begin();
33         try {
34             s.save(u);
35         } catch (HibernateException e) {
36             e.printStackTrace();
37             return false;
38         }
39         this.commit();
40         return true;
41     }
42 
43     @Override
44     public List<User> getUsers() {
45         s = HibernateUtil.getSession();
46         this.begin();
47         Query q = s.createQuery("from ruser");
48         List<User> users = (List<User>)q.list();
49         this.commit();
50         return users;
51     }
52 
53     @Override
54     public void deleteById(int id) {
55         s = HibernateUtil.getSession();
56         this.begin();
57         User u = new User();
58         u.setId(id);
59         s.delete(u);
60         this.commit();
61     }
62 
63 }

4.Service层:

View Code

 1 package com.shopping.service;
 2 
 3 import java.util.List;
 4 
 5 import com.shopping.dao.UserDAO;
 6 import com.shopping.dao.impl.UserDAOImpl;
 7 import com.shopping.model.User;
 8 
 9 public class UserService {
10 
11     UserDAO userDAO;
12 
13     public UserService() {
14         userDAO = new UserDAOImpl();
15     }
16     
17     public boolean addUser(User u){
18         return userDAO.save(u);
19     }
20     
21     public void delUser(int id){
22         userDAO.deleteById(id);
23     }
24     
25     public List<User> getUsers(){
26         return userDAO.getUsers();
27     }
28 }

5.Action层:

View Code

  1 package com.shopping.action;
  2 
  3 import java.sql.Timestamp;
  4 import java.util.List;
  5 
  6 import com.opensymphony.xwork2.ActionSupport;
  7 import com.shopping.model.User;
  8 import com.shopping.service.UserService;
  9 import com.shopping.util.DBUtil;
 10 
 11 public class UserAction extends ActionSupport{
 12 
 13     private UserService userService;
 14     
 15     private int id;
 16     private String username;
 17     private String password;
 18     private String phone;
 19     private String address;
 20     private Timestamp rdate;
 21     
 22     private List<User> users = null;
 23     
 24     public void setUsers(List<User> users) {
 25         this.users = users;
 26     }
 27     public List<User> getUsers() {
 28         return users;
 29     }
 30 
 31 
 32     public int getId() {
 33         return id;
 34     }
 35     public void setId(int id) {
 36         this.id = id;
 37     }
 38     public String getUsername() {
 39         return username;
 40     }
 41     public void setUsername(String username) {
 42         this.username = username;
 43     }
 44     public String getPassword() {
 45         return password;
 46     }
 47     public void setPassword(String password) {
 48         this.password = password;
 49     }
 50     public String getPhone() {
 51         return phone;
 52     }
 53     public void setPhone(String phone) {
 54         this.phone = phone;
 55     }
 56     public String getAddress() {
 57         return address;
 58     }
 59     public void setAddress(String address) {
 60         this.address = address;
 61     }
 62     public Timestamp getRdate() {
 63         return rdate;
 64     }
 65     public void setRdate(Timestamp rdate) {
 66         this.rdate = rdate;
 67     }
 68 
 69     public void initUserService(){
 70         userService = new UserService();
 71     }
 72     
 73     public String getAllUsers(){
 74         initUserService();
 75         users = userService.getUsers();
 76         if(null != users){
 77             return "getSuccess";
 78         }
 79         
 80         return ERROR;
 81     }
 82     
 83     public String add() throws Exception {
 84         
 85         initUserService();
 86         User u = new User();
 87         u.setUsername(username);
 88         u.setPassword(password);
 89         u.setAddress(address);
 90         u.setPhone(phone);
 91         u.setRdate(new Timestamp(System.currentTimeMillis()));
 92         
 93         boolean flag = userService.addUser(u);
 94         if(!flag){
 95             return "adderror";
 96         }
 97         
 98         return "addsuccess";
 99     }
100     
101     public String delete() throws Exception {
102         
103         initUserService();
104         
105         
106         userService.delUser(id);
107         
108         return "delsuccess";
109     }
110 }

6.写一个Hibernate辅助类,用于得到Session:

View Code

 1 package com.shopping.util;
 2 
 3 import org.hibernate.Session;
 4 import org.hibernate.SessionFactory;
 5 import org.hibernate.cfg.AnnotationConfiguration;
 6 
 7 public class HibernateUtil {
 8 
 9     private static SessionFactory sf = null;
10     
11     public static Session getSession(){
12         sf = new AnnotationConfiguration().configure().buildSessionFactory();
13         
14         return sf.getCurrentSession();
15     }
16     
17 }

7.列出用户列表(带用户删除功能)jsp:

View Code

 1 <%@ page language="java" contentType="text/html; charset=GB18030"
 2     pageEncoding="GB18030"%>
 3 <%@ taglib uri="/struts-tags" prefix="s" %>
 4 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 5 <html>
 6 <head>
 7 <meta http-equiv="Content-Type" content="text/html; charset=GB18030">
 8 <title>用户列表</title>
 9 </head>
10 <body>
11 
12 <%
13 String path=request.getContextPath();
14 String rpath=request.getScheme()+"://" + request.getServerName()+":" +
15                 request.getServerPort() + path + "/";
16 %>
17 
18     <table border="1">
19         
20         <tr>
21             <td>ID</td>
22             <td>用户名</td>
23             <td>密码</td>
24             <td>电话</td>
25             <td>地址</td>
26             <td>注册日期</td>
27             <td>删除</td>
28         </tr>
29         
30         <s:iterator value="users">
31             <tr>
32                 <td><s:property value="id"/></td>
33                 <td><s:property value="username"/></td>
34                 <td><s:property value="password"/></td>
35                 <td><s:property value="phone"/></td>
36                 <td><s:property value="address"/></td>
37                 <td><s:property value="rdate"/></td>
38                 <td><a href="<%=rpath %>delete!delete?id=<s:property value="id"/>">删除</a></td>
39             </tr>
40         </s:iterator>
41         
42     </table>
43     <s:debug></s:debug>
44 </body>
45 </html>

8.struts2配置文件:

View Code

 1 <?xml version="1.0" encoding="UTF-8" ?>
 2 <!DOCTYPE struts PUBLIC
 3     "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
 4     "http://struts.apache.org/dtds/struts-2.0.dtd">
 5 
 6 <struts>
 7     <!--  
 8     <constant name="struts.enable.DynamicMethodInvocation" value="false" />
 9     <constant name="struts.devMode" value="false" />
10 
11     <package name="default" namespace="/" extends="struts-default">
12 
13         <default-action-ref name="index" />
14 
15         <global-results>
16             <result name="error">/error.jsp</result>
17         </global-results>
18 
19         <global-exception-mappings>
20             <exception-mapping exception="java.lang.Exception" result="error"/>
21         </global-exception-mappings>
22 
23         <action name="index">
24             <result type="redirectAction">
25                 <param name="actionName">HelloWorld</param>
26                 <param name="namespace">/example</param>
27             </result>
28         </action>
29     </package>
30 
31     <include file="example.xml"/>
32 -->
33     <!-- Add packages here -->
34     
35     <constant name="struts.devMode" value="true" />        <!-- 开发模式 -->
36     <constant name="struts.i18n.encoding" value="gbk"/>  <!-- 解决中文乱码 -->
37     <package name="register" namespace="/" extends="struts-default">
38 
39         <action name="register" class="com.shopping.action.UserAction" method="add">
40             <result name="addsuccess">
41                 /registerOK.jsp
42             </result>
43             <result name="adderror">
44                 /registerFail.jsp
45             </result>
46         </action>
47         
48         <action name="delete" class="com.shopping.action.UserAction" method="delete">
49             <result name="delsuccess">
50                 /admin/userlist.jsp
51             </result>
52             <result name="delerror">
53                 /registerFail.jsp
54             </result>
55         </action>
56         
57         <action name="list" class="com.shopping.action.UserAction" method="getUsers">
58             <result name="getSuccess">
59                 /admin/userlist.jsp
60             </result>
61             <result name="error">
62                 /registerFail.jsp
63             </result>
64         </action>
65     </package>
66 </struts>

9.Hibernate配置文件:

View Code

 1 <?xml version='1.0' encoding='utf-8'?>
 2 <!--
 3   ~ Hibernate, Relational Persistence for Idiomatic Java
 4   ~
 5   ~ Copyright (c) 2010, Red Hat Inc. or third-party contributors as
 6   ~ indicated by the @author tags or express copyright attribution
 7   ~ statements applied by the authors.  All third-party contributions are
 8   ~ distributed under license by Red Hat Inc.
 9   ~
10   ~ This copyrighted material is made available to anyone wishing to use, modify,
11   ~ copy, or redistribute it subject to the terms and conditions of the GNU
12   ~ Lesser General Public License, as published by the Free Software Foundation.
13   ~
14   ~ This program is distributed in the hope that it will be useful,
15   ~ but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
16   ~ or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Lesser General Public License
17   ~ for more details.
18   ~
19   ~ You should have received a copy of the GNU Lesser General Public License
20   ~ along with this distribution; if not, write to:
21   ~ Free Software Foundation, Inc.
22   ~ 51 Franklin Street, Fifth Floor
23   ~ Boston, MA  02110-1301  USA
24   -->
25 <!DOCTYPE hibernate-configuration PUBLIC
26         "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
27         "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
28 
29 <hibernate-configuration>
30 
31     <session-factory>
32         
33         <!-- Database connection settings -->
34         <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
35         <property name="connection.url">jdbc:mysql://localhost:3306/shopping</property>
36         <property name="connection.username">root</property>
37         <property name="connection.password">1234</property>
38 
39         <!-- JDBC connection pool (use the built-in) -->
40  <!-- 
41         <property name="connection.pool_size">1</property>
42  -->
43         <!-- SQL dialect -->
44         <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
45         
46         <property name="current_session_context_class">thread</property>
47 
48         <!-- Disable the second-level cache  -->
49         <property name="cache.provider_class">org.hibernate.cache.internal.NoCacheProvider</property>
50 
51         <!-- Echo all executed SQL to stdout 把sql语句输出出来-->
52         <property name="show_sql">true</property>
53         
54         <!-- 把sql语句更漂亮的输出出来-->
55         <property name="format_sql">true</property>
56 
57         <!-- Drop and re-create the database schema on startup --> 
58         <!-- 表示如果表存在则直接操作,若表不存在则创建表后再插入 -->        
59        <property name="hbm2ddl.auto">update</property>  
60           
61  <!-- 用hbm来使用student类 
62         <mapping resource="com/hibernate/model/Student.hbm.xml"/>
63   -->
64         
65         <!-- 用annotation来使用teacher类
66         <mapping class="com.hibernate.model.Teacher"/>
67         -->
68         
69         <!--  
70         <mapping class="com.hibernate.model.hql.Category"/>
71         <mapping class="com.hibernate.model.hql.Topic"/>
72         <mapping class="com.hibernate.model.hql.Msg"/>
73         -->
74  <mapping class="com.shopping.model.User"/>
75     </session-factory>
76 
77 </hibernate-configuration>

管理员界面目前只有显示用户列表功能也就是功能7.

PS:应当在userlist中的删除连接里写上 onclick="return window.confirm('你确定要删除吗?')" .....按下确定才真正删除!

posted on 2012-05-09 21:24 saobchj 阅读(354) 评论(0) 收藏举报

刷新页面返回顶部

将商城项目改为struts2和hibernate,并增加管理员页面

导航

公告