SSH使用总结(xml配置)-白红宇

SSH使用总结(xml配置)

阅读量：4566 次

发布时间：2019-06-08

本文共 17015 字，大约阅读时间需要 56 分钟。

beans.xml


     
     
          
              
                   
        
         classpath:jdbc.properties
                
           
          
              
               
               
               
           
      
          
              
               
                   
                        
         
          com/anllin/usermgr/model/User.hbm.xml
                     
                
               
                   
                        
         
          org.hibernate.dialect.MySQL5Dialect
                         
         
          true
                         
         
          true

struts.xml


     
         
              
                   
        
         /listUsers.jsp
                
                       
                   
        
         listUser.action
                
                       
                   
        
         listUser.action
                
                       
                   
        
         updateUser.jsp
                
                       
                   
        
         listUser.action

jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc\:mysql\://localhost\:3306/usermgrjdbc.username=rootjdbc.password=123

log4j.properties

## Hibernate, Relational Persistence for Idiomatic Java## Copyright (c) 2008, Red Hat Middleware LLC or third-party contributors as# indicated by the @author tags or express copyright attribution# statements applied by the authors.  All third-party contributions are# distributed under license by Red Hat Middleware LLC.## This copyrighted material is made available to anyone wishing to use, modify,# copy, or redistribute it subject to the terms and conditions of the GNU# Lesser General Public License, as published by the Free Software Foundation.## This program is distributed in the hope that it will be useful,# but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY# or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Lesser General Public License# for more details.## You should have received a copy of the GNU Lesser General Public License# along with this distribution; if not, write to:# Free Software Foundation, Inc.# 51 Franklin Street, Fifth Floor# Boston, MA  02110-1301  USA##log4j.rootLogger=info, stdoutlog4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.Target=System.outlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{
    1}:%L - %m%nlog4j.rootLogger=warn, stdout#log4j.logger.org.hibernate=debug#log4j.logger.org.hibernate.test=info### log schema export/update ###log4j.logger.org.hibernate.tool.hbm2ddl=debug#log4j.logger.org.hibernate.sql.ordering.antlr.OrderByFragmentTranslator=trace#log4j.logger.org.hibernate.ejb=debug#log4j.logger.org.hibernate.ejb.packaging=debug#log4j.logger.org.hibernate.reflection=debug#log4j.logger.org.hibernate.hql.ast.QueryTranslatorImpl=trace#log4j.logger.org.hibernate.hql.ast.HqlSqlWalker=trace#log4j.logger.org.hibernate.hql.ast.SqlGenerator=trace#log4j.logger.org.hibernate.hql.ast.AST=trace#log4j.logger.org.hibernate.type.descriptor.sql.BasicBinder=trace#log4j.logger.org.hibernate.type.BasicTypeRegistry=trace#log4j.logger.org.hibernate.engine.Cascades=debug#log4j.logger.org.hibernate.hql=debug### log just the SQL#log4j.logger.org.hibernate.SQL=debug### log JDBC bind parameters ####log4j.logger.org.hibernate.type=info#log4j.logger.org.hibernate.type=trace### log HQL parse trees#log4j.logger.org.hibernate.hql=debug### log cache activity ####log4j.logger.org.hibernate.cache=debug### log JDBC resource acquisition#log4j.logger.org.hibernate.jdbc=debug### enable the following line if you want to track down connection ###### leakages when using DriverManagerConnectionProvider ####log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=trace#log4j.logger.org.jgroups=info#log4j.logger.org.jboss.cache=trace#log4j.logger.org.jboss.cache.RegionManager=info#log4j.logger.org.jboss.cache.lock=info#log4j.logger.org.jboss.cache.interceptors.PessimisticLockInterceptor=info#log4j.logger.org.jboss.cache.interceptors.UnlockInterceptor=info

AddUserAction.java

package com.anllin.usermgr.action;import com.anllin.usermgr.model.User;import com.anllin.usermgr.service.UserService;import com.opensymphony.xwork2.ActionSupport;public class AddUserAction extends ActionSupport{    private User user;    private UserService userService;    public User getUser()    {        return user;    }    public void setUser(User user)    {        this.user = user;    }    public UserService getUserService()    {        return userService;    }    public void setUserService(UserService userService)    {        this.userService = userService;    }    @Override    public String execute() throws Exception    {        if(user != null)        {            this.userService.add(user);        }        return SUCCESS;    }}

DeleteUserAction.java

package com.anllin.usermgr.action;import org.apache.struts2.ServletActionContext;import com.anllin.usermgr.service.UserService;import com.opensymphony.xwork2.ActionSupport;public class DeleteUserAction extends ActionSupport{    private int id;    private UserService userService;    public UserService getUserService()    {        return userService;    }    public void setUserService(UserService userService)    {        this.userService = userService;    }    @Override    public String execute() throws Exception    {        id = Integer.parseInt(ServletActionContext.getRequest().getParameter("id").trim());        if (id > 0)        {            userService.deleteById(id);        }        return SUCCESS;    }}

GetUserAction.java

package com.anllin.usermgr.action;import org.apache.struts2.ServletActionContext;import com.anllin.usermgr.model.User;import com.anllin.usermgr.service.UserService;import com.opensymphony.xwork2.ActionSupport;public class GetUserAction extends ActionSupport{    private User user;    private UserService userService;    public User getUser()    {        return user;    }    public void setUser(User user)    {        this.user = user;    }    public UserService getUserService()    {        return userService;    }    public void setUserService(UserService userService)    {        this.userService = userService;    }        @Override    public String execute() throws Exception    {        int id = Integer.valueOf(ServletActionContext.getRequest().getParameter("id").trim());        if(id >= 0)        {            this.user = userService.getById(id);        }                ServletActionContext.getRequest().setAttribute("user",user);                return SUCCESS;    }}

ListUserAction.java

package com.anllin.usermgr.action;import java.util.List;import org.apache.struts2.ServletActionContext;import com.anllin.usermgr.model.User;import com.anllin.usermgr.service.UserService;import com.opensymphony.xwork2.ActionSupport;public class ListUserAction extends ActionSupport{    private List
     
       users;    private UserService userService;    public List
      
        getUsers()    {        return users;    }    public void setUsers(List
       
         users)    {        this.users = users;    }    public UserService getUserService()    {        return userService;    }    public void setUserService(UserService userService)    {        this.userService = userService;    }    @Override    public String execute() throws Exception    {        users = userService.getAll();        ServletActionContext.getContext().getSession().put("users",users);        return SUCCESS;    }}

UpdateUserAction.java

package com.anllin.usermgr.action;import com.anllin.usermgr.model.User;import com.anllin.usermgr.service.UserService;import com.opensymphony.xwork2.ActionSupport;public class UpdateUserAction extends ActionSupport{    private User user;    private UserService userService;    public User getUser()    {        return user;    }    public void setUser(User user)    {        this.user = user;    }    public UserService getUserService()    {        return userService;    }    public void setUserService(UserService userService)    {        this.userService = userService;    }        @Override    public String execute() throws Exception    {        if(user != null)        {            userService.update(user);        }        return super.execute();    }}

UserDao.java

package com.anllin.usermgr.dao;import java.util.List;import com.anllin.usermgr.model.User;public interface UserDao{    void add(User user);    void update(User user);    void delete(User user);    void deleteById(int id);    User getById(int id);    List
     
       getByName(String username);    List
      
        getAll();}

UserDaoImpl.java

package com.anllin.usermgr.dao.impl;import java.util.List;import org.springframework.orm.hibernate3.support.HibernateDaoSupport;import com.anllin.usermgr.dao.UserDao;import com.anllin.usermgr.model.User;public class UserDaoImpl extends HibernateDaoSupport implements UserDao{    @Override    public void add(User user)    {        this.getHibernateTemplate().save(user);    }    @Override    public void delete(User user)    {        this.getHibernateTemplate().delete(user);    }    @Override    public void deleteById(int id)    {        User user = (User)this.getHibernateTemplate().get(User.class,id);        delete(user);    }    @SuppressWarnings("unchecked")    @Override    public List
     
       getAll()    {        return (List
      
       )this.getHibernateTemplate().find("from User");    }    @Override    public User getById(int id)    {        return (User)this.getHibernateTemplate().get(User.class,id);    }    @SuppressWarnings("unchecked")    @Override    public List
       
         getByName(String username)    {        List
        
          users = (List
         
          )this.getHibernateTemplate().find("from User as u where u.username=?",username);                return users;    }    @Override    public void update(User user)    {        this.getHibernateTemplate().update(user);    }}

User.java

package com.anllin.usermgr.model;import java.sql.Date;public class User{    private int id;    private String username;    private String password;    private int age;    private Date birthday;    public int getId()    {        return id;    }    public void setId(int id)    {        this.id = id;    }    public String getUsername()    {        return username;    }    public void setUsername(String username)    {        this.username = username;    }    public String getPassword()    {        return password;    }    public void setPassword(String password)    {        this.password = password;    }    public int getAge()    {        return age;    }    public void setAge(int age)    {        this.age = age;    }    public Date getBirthday()    {        return birthday;    }    public void setBirthday(Date birthday)    {        this.birthday = birthday;    }}

User.hbm.xml

UserService.java

package com.anllin.usermgr.service;import java.util.List;import com.anllin.usermgr.model.User;public interface UserService{    void add(User user);    void update(User user);    void delete(User user);    void deleteById(int id);    User getById(int id);    List
     
       getByName(String username);    List
      
        getAll();    boolean isExistsUser(String username);}

UserServiceImpl.java

package com.anllin.usermgr.service.impl;import java.util.List;import com.anllin.usermgr.dao.UserDao;import com.anllin.usermgr.model.User;import com.anllin.usermgr.service.UserService;public class UserServiceImpl implements UserService{    private UserDao userDao;    public UserDao getUserDao()    {        return userDao;    }    public void setUserDao(UserDao userDao)    {        this.userDao = userDao;    }    @Override    public void add(User user)    {        this.userDao.add(user);    }    @Override    public void delete(User user)    {        this.userDao.delete(user);    }    @Override    public void deleteById(int id)    {        this.userDao.deleteById(id);    }    @Override    public List
     
       getAll()    {        return this.userDao.getAll();    }    @Override    public User getById(int id)    {        return this.userDao.getById(id);    }    @Override    public List
      
        getByName(String username)    {        return this.userDao.getByName(username);    }    @Override    public boolean isExistsUser(String username)    {        List
       
         users = getByName(username);        if(users != null && users.size() > 0)        {            return true;        }        return false;    }    @Override    public void update(User user)    {        this.userDao.update(user);    }}

web.xml


     
         
              
       
        index.jsp
           
          
              
       
        struts2
               
       
                    org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
           
          
              
       
        struts2
               
       
        /*
           
          
              
       
        contextConfigLocation
               
       
        classpath:beans.xml
           
          
              
       
        org.springframework.web.context.ContextLoaderListener

addUser.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@taglib prefix="s" uri="/struts-tags"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>              Add User        
         
         "          Add User
    
     
              username: 
      
      
        password: 
      
      
        age: 
      
      
        birthday:

index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@taglib prefix="s" uri="/struts-tags" %><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>              User Manager    
         
                         
             
      User Manager
      
      
      
        
      
       Show All Users
      
      
      
      
        
      
       Add a New User

listUsers.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@taglib prefix="s" uri="/struts-tags"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>              List All Users        
         
                     List All Users
      
                   
     
     
                                             username                       password                       age                       birthday                       update                       delete                  
                                                                 
                                                                           
                                                                           
                                                                           
                                                                           
         
          update
                                                                           
         
          delete

updateUser.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@taglib prefix="s" uri="/struts-tags" %><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>              Update User        
        
                    Update User
      
              
               username: 
     
     
          password: 
     
     
          age: 
     
     
          birthday: