SSH项目实战---图书销售及后台管理系统

短命女 2022-07-12 08:11 183阅读 0赞

1.项目结构

![Center][]

2.配置文件

Spring.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xmlns:context="http://www.springframework.org/schema/context"
         xmlns:tx="http://www.springframework.org/schema/tx"
         xmlns:aop="http://www.springframework.org/schema/aop"
         xsi:schemaLocation="http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context.xsd
            http://www.springframework.org/schema/tx
           	http://www.springframework.org/schema/tx/spring-tx.xsd
           	http://www.springframework.org/schema/aop 
           	http://www.springframework.org/schema/aop/spring-aop.xsd">
    
    
    	
    	<context:component-scan base-package="action"/>
    	<context:component-scan base-package="service"/> 
    	<context:component-scan base-package="dao"/>
    
    
    	
    	<context:property-placeholder location="classpath:jdbc.properties"/>
    
    	
    	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
    		<property name="driverClass" value="${jdbc.driver}" />
    		<property name="jdbcUrl" value="${jdbc.url}" />
    		<property name="user" value="${jdbc.username}" />
    		<property name="password" value="${jdbc.password}" />
    		
    		
            <property name="initialPoolSize" value="${c3p0.initialPoolSize}" />			
            <property name="minPoolSize" value="${c3p0.minPoolSize}" />			
            <property name="maxPoolSize" value="${c3p0.maxPoolSize}" />
    		<property name="maxIdleTime" value="${c3p0.maxIdleTime}" />
            <property name="idleConnectionTestPeriod" value="${c3p0.idleConnectionTestPeriod}" />
    	</bean>
    
    	
    	
    	<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    		<property name="dataSource" ref="dataSource" />
    		
    		<property name="packagesToScan">
    			<list><value>model</value></list>
    		</property>
    		
    		<property name="hibernateProperties">
    			<props>
    				<prop key="hibernate.dialect">${hibernate.dialect}</prop>
    				<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
    				<prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
    			</props>
    		</property>
    	</bean>
    
    
    	
      	<bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        	<property name="sessionFactory" ref="sessionFactory"/>
      	</bean>
      	
    	
    	<tx:annotation-driven transaction-manager="transactionManager"/>
    
    
    </beans>

jdbc.properties(数据库连接池配置文件)

########################################
    ########     database configuration     #######
    #######################################
    ##\u6570\u636E\u5E93\u9A71\u52A8
    jdbc.driver=com.mysql.jdbc.Driver
    ##\u8FDE\u63A5\u5B57\u7B26\u4E32
    jdbc.url=jdbc:mysql://localhost:3306/book
    ##\u6570\u636E\u5E93\u7528\u6237\u540D
    jdbc.username=root
    ##\u6570\u636E\u5E93\u6570\u636E\u5E93\u5BC6\u7801
    jdbc.password=123456
    
    
    ########################################
    ########     c3p0 configuration     #######
    #######################################
     
    ##\u521D\u59CB\u5316\u8FDE\u63A5\u6570 Default: 3
    c3p0.initialPoolSize=3
    ##\u6700\u5C0F\u8FDE\u63A5\u6570
    c3p0.minPoolSize=2
    ##\u8FDE\u63A5\u6C60\u4E2D\u4FDD\u7559\u7684\u6700\u5927\u8FDE\u63A5\u6570 Default: 15
    c3p0.maxPoolSize=10
    ##\u8FDE\u63A5\u7684\u8FC7\u671F\u65F6\u95F4(\u79D2), (<mysql 28800) Default: 0-\u6C38\u4E0D\u4E22\u5F03
    c3p0.maxIdleTime=28000
    ##\u9694\u591A\u5C11\u79D2\u68C0\u67E5\u6240\u6709\u8FDE\u63A5\u6C60\u4E2D\u7684\u7A7A\u95F2\u8FDE\u63A5, (<mysql 28800) Default: 0-\u4E0D\u68C0\u67E5
    c3p0.idleConnectionTestPeriod=3600
    
    
    
    
    ########################################
    ########     hibernate configuration     #######
    #######################################
    
    ##\u6570\u636E\u5E93\u65B9\u8A00
    hibernate.dialect=org.hibernate.dialect.MySQLDialect
    #hibernate.dialect=org.hibernate.dialect.SQLServerDialect
    #hibernate.dialect=org.hibernate.dialect.OracleDialect
    
    ##\u662F\u5426\u6253\u5370sql\u8BED\u53E5
    hibernate.show_sql=true
    ##\u662F\u5426\u683C\u5F0F\u5316sql\u8BED\u53E5(\u5206\u884C\u663E\u793A)
    hibernate.format_sql=false
    
    ##session\u6BCF\u6B21\u4ECE\u6570\u636E\u5E93\u4E2D\u8BFB\u53D6\u6570\u636E\u6570\u91CF
    #hibernate.jdbc.fetch_size=10
    ##\u6BCF\u6B21\u6279\u91CF\u5904\u7406\u63D2\u5165\u6216\u66F4\u65B0\u7684\u6570\u91CF
    #hibernate.jdbc.batch_size=10
    
    ##\u662F\u5426\u4F7F\u7528JDBC\u53EF\u6EDA\u52A8\u7684\u7ED3\u679C\u96C6, \u5BF9\u5206\u9875\u6709\u5E2E\u52A9
    #hibernate.jdbc.use_scrollable_resultset=true
    
    ##create\uFF1A\u8868\u793A\u542F\u52A8\u7684\u65F6\u5019\u5148drop\uFF0C\u518Dcreate
    ##create-drop: \u4E5F\u8868\u793A\u521B\u5EFA\uFF0C\u53EA\u4E0D\u8FC7\u518D\u7CFB\u7EDF\u5173\u95ED\u524D\u6267\u884C\u4E00\u4E0Bdrop
    ##update: \u8FD9\u4E2A\u64CD\u4F5C\u542F\u52A8\u7684\u65F6\u5019\u4F1A\u53BB\u68C0\u67E5schema\u662F\u5426\u4E00\u81F4\uFF0C\u5982\u679C\u4E0D\u4E00\u81F4\u4F1A\u505Ascheme\u66F4\u65B0
    ##validate: \u542F\u52A8\u65F6\u9A8C\u8BC1\u73B0\u6709schema\u4E0E\u4F60\u914D\u7F6E\u7684hibernate\u662F\u5426\u4E00\u81F4\uFF0C\u5982\u679C\u4E0D\u4E00\u81F4\u5C31\u629B\u51FA\u5F02\u5E38\uFF0C\u5E76\u4E0D\u505A\u66F4\u65B0
    #hibernate.hbm2ddl.auto=validate
    
    ##\u8FDE\u63A5\u6570\u636E\u5E93\u65F6\u662F\u5426\u4F7F\u7528Unicode\u7F16\u7801
    #hibernate.connection.useUnicode=true
    ##\u8FDE\u63A5\u6570\u636E\u5E93\u65F6\u6570\u636E\u7684\u4F20\u8F93\u5B57\u7B26\u96C6\u7F16\u7801\u65B9\u5F0F
    #hibernate.connection.characterEncoding=utf8

Struts.xml(注：这里的许多action都采用注解的方式进行配置，所以极大简化了xml文件的内容)

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE struts PUBLIC
    	"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
    	"http://struts.apache.org/dtds/struts-2.3.dtd">
    
    <struts>
    
    	
    	<constant name="struts.i18n.encoding" value="UTF-8" />
    
    	
    	<constant name="struts.action.extension" value="action,do" />
    
    	
    	<constant name="struts.configuration.xml.reload" value="true" />
    
    	
    	<constant name="struts.devMode" value="false" />
    
    	
    	<constant name="struts.serve.static.browserCache" value="false" />
    
    	
    	<constant name="struts.enable.DynamicMethodInvocation" value="true" />
    
    	
    
    
    </struts>

3.部分代码(项目代码比较庞大，就发一部分即可这里以用户操作为例)

UserAction.java

package action;
    
    import javax.annotation.Resource;
    
    import model.User;
    
    import org.apache.struts2.convention.annotation.Action;
    import org.apache.struts2.convention.annotation.Namespace;
    import org.apache.struts2.convention.annotation.Result;
    import org.apache.struts2.convention.annotation.Results;
    
    import service.UserService;
    
    @Action("user")
    @Namespace("/book")
    @Results({
    	@Result(name="login",location="/book/login.jsp"),
    	@Result(name="register",location="/book/register.jsp"),
    	@Result(name="index",location="index.action",type="redirect"),
    })
    public class UserAction extends BaseAction{
    	private static final long serialVersionUID = 1L;
    	
    	private User user;
    	
    	@Resource
    	private UserService userService;
    
    	
    	/**
    	 * 注册用户
    	 * @return
    	 */
    	public String register(){
    		if (user.getUsername().isEmpty()) {
    			addActionMessage("用户名不能为空!");
    			return "register";
    		}else if (userService.isExist(user.getUsername())) {
    			addActionMessage("用户名已存在!");
    			return "register";
    		}else {
    			userService.add(user);
    			addActionMessage("注册成功, 请登录!");
    			return "login";
    		}
    	}
    	
    	/**
    	 * 用户登录
    	 * @return
    	 * @throws Exception
    	 */
    	public String login() {
    		if(userService.checkUser(user.getUsername(), user.getPassword())){
    			getSession().put("username", user.getUsername());
    			return "index";
    		} else {
    			addActionMessage("用户名或密码错误!");
    			return "login";
    		}
    	}
    
    	/**
    	 * 注销登录
    	 * @return
    	 */
    	public String logout() {
    		getSession().remove("username");
    		getSession().remove("indent");
    		return "login";
    	}
    	
    	
    	
    	public User getUser() {
    		return user;
    	}
    
    	public void setUser(User user) {
    		this.user = user;
    	}
    
    	
    }

UserDao.java

package dao;
    
    import java.util.List;
    
    import model.User;
    
    import org.springframework.stereotype.Repository;
    
    @Repository // 注册dao层bean等同于@Component
    public class UserDao extends BaseDao{
    
    	
    	/**
    	 * 通过用户名查找用户
    	 * @return 无记录返回null
    	 */
    	public User getByUsername(String username){
    		return (User) getSession().createQuery("from User where username=:username")
    				.setString("username", username).uniqueResult();	// HQL语句方式
    	}
    	
    	/**
    	 * 通过用户名和密码查找
    	 * @param username
    	 * @param password
    	 * @return 无记录返回null
    	 */
    	public User getByUsernameAndPassword(String username, String password){
    		return (User)getSession().createSQLQuery("select * from user where username=? and password=?")
    				.addEntity(User.class).setString(0, username).setString(1, password).uniqueResult();	// SQL语句方式
    	}
    	
    	/**
    	 * 获取列表
    	 * @param page
    	 * @param rows
    	 * @return 无记录返回空集合
    	 */
    	@SuppressWarnings("unchecked")
    	public List<User> getList(int page, int rows){
    		return getSession().createQuery("from User").setFirstResult(rows*(page-1)).setMaxResults(rows).list();
    	}
    
    	/**
    	 * 总数
    	 * @return
    	 */
    	public long getTotal() {
    		return (long) getSession().createQuery("select count(*) from User").uniqueResult();
    	}
    	
    }

User.java

package model;
    
    import javax.persistence.Entity;
    import javax.persistence.GeneratedValue;
    import javax.persistence.Id;
    
    @Entity // 注解为hibernate实体 对应数据库中user表
    public class User {
    	
    	@Id	// 注解主键
    	@GeneratedValue //id生成策略  默认auto 相当于hibernate的native - 自增字段
    	private int id;
    	private String username;
    	private String password;
    	private String address;
    	private String phone;
    
    	
    	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 String getAddress() {
    		return address;
    	}
    	public void setAddress(String address) {
    		this.address = address;
    	}
    	public String getPhone() {
    		return phone;
    	}
    	public void setPhone(String phone) {
    		this.phone = phone;
    	}
    	
    	
    }

UserService.java

package service;
    
    import java.util.List;
    
    import javax.annotation.Resource;
    
    import model.User;
    
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Transactional;
    
    import util.SafeUtil;
    import dao.UserDao;
    
    @Service	// 注解为service层spring管理bean
    @Transactional	// 注解此类所有方法加入spring事务, 具体设置默认
    public class UserService {
    
    	@Resource		//spring注入类对象
    	private UserDao userDao;
    	
    	/**
    	 * 验证用户密码
    	 * @param username
    	 * @param password
    	 * @return
    	 */
    	public boolean checkUser(String username, String password){
    		return userDao.getByUsernameAndPassword(username, SafeUtil.encode(password)) != null;
    	}
    
    	/**
    	 * 用户是否存在
    	 * @param username
    	 * @return
    	 */
    	public boolean isExist(String username) {
    		return userDao.getByUsername(username) != null;
    	}
    
    	/**
    	 * 添加
    	 * @param user
    	 * @return
    	 */
    	public boolean add(User user) {
    		user.setPassword(SafeUtil.encode(user.getPassword()));
    		return userDao.save(user) > 0;
    	}
    	
    	/**
    	 * 通过id获取
    	 * @param userid
    	 * @return
    	 */
    	public User get(int userid){
    		return userDao.get(User.class, userid);
    	}
    	
    	/**
    	 * 通过username获取
    	 * @param username
    	 * @return
    	 */
    	public User get(String username){
    		return userDao.getByUsername(username);
    	}
    	
    	/**
    	 * 列表
    	 * @param page
    	 * @param rows
    	 * @return
    	 */
    	public List<User> getList(int page, int rows) {
    		return userDao.getList(page, rows);
    	}
    
    	/**
    	 * 总数
    	 * @return
    	 */
    	public long getTotal() {
    		return userDao.getTotal();
    	}
    
    	/**
    	 * 更新
    	 * @param user
    	 */
    	public boolean update(User user) {
    		return userDao.update(user);
    	}
    
    	/**
    	 * 删除
    	 * @param user
    	 */
    	public boolean delete(int id) {
    		User user = new User();
    		user.setId(id);
    		return userDao.delete(user);
    	}
    	
    }

从上代码可以看出，用SSH框架架构的项目层次比较分明，逻辑清晰，代码比较简洁，可读性好

4.截图：

（1）客户端用户界面

![Center 1][]

图4.1.1 书店首页

![Center 2][]

图4.1.2 书店简介

![Center 3][]

图4.1.3 精品推荐

![Center 4][]

图4.1.4 最新出版

![Center 5][]

图4.1.5 优惠促销

![Center 6][]

图4.1.6 用户注册

![Center 7][]

图4.1.7 用户登录

![Center 8][]

图4.1.8 用户登录后页面

（2）后台管理界面

![Center 9][]

图4.2.1 后台管理首页

![Center 10][]

图4.2.2 后台管理登录页面

![Center 11][]

图4.2.3 订单管理

![Center 12][]

图4.2.4 顾客管理

![Center 13][]

图4.2.5 图书管理

![Center 14][]

图4.2.6 类目管理

![Center 15][]

图4.2.7 用户管理

总结： 参考别人的代码，一步一步地自己写出了这个项目，中间Bug很多，改了两天，幸好有大神指点，才得以如此顺利。以后还得多做项目，多多积累经验。SSH完成了一个，接下来就是SSM框架的了。码农的道路艰辛又漫长，充满了趣味。

[Center]: /images/20220710/d3055efe39fc45ee82200a3e3d3e8e51.png
[Center 1]: /images/20220710/fe3aaf5a5bd74ca1acbaac8d65636463.png
[Center 2]: /images/20220710/c8a4813eaaa4404093010280d9c6d20b.png
[Center 3]: /images/20220710/efd45ceec243445ab5ae4f92b66fa3c3.png
[Center 4]: /images/20220710/652527beb33c440ebf9c9f796fd36f9e.png
[Center 5]: /images/20220710/b300776201584800b8e265a55f7ba573.png
[Center 6]: /images/20220710/6a653f16a2f14465bb49837d0e1e3c01.png
[Center 7]: /images/20220710/c4c69bf06dd74a158315fadb16578640.png
[Center 8]: /images/20220710/2d4672956e1d4e9888faee6360c1d298.png
[Center 9]: /images/20220710/4a7c540dbaba424dbefc0f50f7b53475.png
[Center 10]: /images/20220710/e078b17cdab34d979660c8515999ca32.png
[Center 11]: /images/20220710/ace8307015e54fdbb7cfef6ad8bfd125.png
[Center 12]: /images/20220710/5badb667af074297850eeeb48c950e1e.png
[Center 13]: /images/20220710/478825665a0e4301b2614375510f441a.png
[Center 14]: /images/20220710/499d4c93e33d4a24823b97913ae3d54e.png
[Center 15]: /images/20220710/15b28bacfb924ed8a2d4c3d87a6e67e7.png