基于Java（SSM）+Mysql实现移动大厅业务办理（增删改查）

基于 SSM 框架的移动业务大厅

数据库需要自行创建！

一、 整体基本实现情况

对本学期的 Java 作业 1 的 SOSO 移动大厅进行改进， 基于 SSM、JSP、Maven、Tomcat、MySQL 等实现。

二、 实现详情

1、 工程结构图

2、 工程结构各部分实现

（1）Java

pojo: 存放自定义的 Java 类。每个类的属性设为 private，并提供 public 属性的 getter/setter 方法让外界访问。

// MobileCard.java

package com.pojo;//手机卡类
public class MobileCard {private String cardNumber;         //卡号private String userName;           //用户名private String passWord;           //密码private String serPackage;         //服务包private double consumAmount;       //总消费额private double money;              //余额private int realTalkTime;          //实际通话时间private int realSMSCount;          //实际短信数量private int realFlow;              //实际流量消耗public MobileCard() {this.realTalkTime = 0;this.realSMSCount = 0;this.realFlow = 0;}public String getcardNumber() {return cardNumber;}public String getuserName() {return userName;}public String getpassWord() {return passWord;}public String getserPackage() {return serPackage;}public double getconsumAmount() {return consumAmount;}public double getmoney() {return money;}public int getrealTalkTime() {return realTalkTime;}public int getrealSMSCount() {return realSMSCount;}public int getrealFlow() {return realFlow;}public void setcardNumber(String temp) {cardNumber = temp;}public void setuserName(String temp) {userName = temp;}public void setpassWord(String temp) {passWord = temp;}public void setserPackage(String temp) { serPackage = temp; }public void setconsumAmount(double temp) {consumAmount = temp;}public void setmoney(double temp) {money = temp;}public void setrealTalkTime(int temp) {realTalkTime = temp;}public void setrealSMSCount(int temp) {realSMSCount = temp;}public void setrealFlow(int temp) {realFlow = temp;}
}

service：定义接口，包含系统所提供的功能。此外还会在 service 包下再新建 impl 包。

//SosoService.java

package com.service;
import com.pojo.MobileCard;
import java.util.List;public interface SosoService {int userRegister(MobileCard newUser);List<MobileCard> queryAllUser();
}

dao：定义接口，包含与数据库进行交互的功能。

//SosoDao.java

package com.dao;
import com.pojo.MobileCard;
import java.util.List;public interface SosoDao {int userRegister(MobileCard newUser);List<MobileCard> queryAllUser();
}

controller：控制器，负责接收页面请求，转发和处理。

//SosoController.java

package com.controller;
import com.pojo.MobileCard;
import com.service.SosoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;import javax.servlet.http.HttpServletRequest;
import java.util.List;@Controller
@RequestMapping("/soso")
public class SosoController {@Autowiredprivate SosoService sosoService;@AutowiredHttpServletRequest request;@RequestMapping("/userRegisterWeb")public String userRegisterWeb(MobileCard newUser) {return "userRegister";}@RequestMapping(value = "/userRegister")public String userRegister() {MobileCard newUser = new MobileCard();newUser.setcardNumber(request.getParameter("cardNumber"));newUser.setuserName(request.getParameter("userName"));newUser.setpassWord(request.getParameter("passWord"));newUser.setserPackage(request.getParameter("serPackage"));newUser.setconsumAmount(Double.valueOf(request.getParameter("consumAmount")));newUser.setmoney(Double.valueOf(request.getParameter("money")));newUser.setrealTalkTime(Integer.valueOf(request.getParameter("realTalkTime")));newUser.setrealSMSCount(Integer.valueOf(request.getParameter("realSMSCount")));newUser.setrealFlow(Integer.valueOf(request.getParameter("realFlow")));sosoService.userRegister(newUser);return "userRegister";}@RequestMapping("/allUserWeb")public String allUserWeb(Model model) {List<MobileCard> list = sosoService.queryAllUser();model.addAttribute("list", list);return "allUser";}
}

（2）resource

在 resource 包下有两个文件夹， “mapper”（用于存放 xxxMapper.xml 文件）和“Spring”（用于存放 spring-xxx.xml 配置文件）。

jdbc.properties：MySQL 数据库配置文件

log4j.properties：日志输出配置文件

mybatis-config.xml：MyBatis 框架配置文件

//mapper 文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.dao.SosoDao">
<resultMap type="MobileCard" id="sosoResultMap" >
<id property="cardNumber" column="CardNumber"/>
<result property="userName" column="UserName"/>
<result property="passWord" column="PassWord"/>
<result property="serPackage" column="SerPackage"/>
<result property="consumAmount" column="ConsumAmount"/>
<result property="money" column="Money"/>
<result property="realTalkTime" column="RealTalkTime"/>
<result property="realSMSCount" column="RealSMSCount"/>
<result property="realFlow" column="RealFlow"/>
</resultMap><insert id="userRegister" parameterType="MobileCard">INSERT INTO MobileCardMYSQL(CardNumber,UserName,PassWord,SerPackage,ConsumAmount,Money, RealTalkTime, RealSMSCount, RealFlow) VALUE (#{cardNumber},#{userName}, #{passWord}, #{serPackage}, #{consumAmount},#{money}, #{realTalkTime}, #{realSMSCount}, #{realFlow})</insert><select id="queryAllUser" resultMap="sosoResultMap">SELECT * FROM MobileCardMYSQL</select>
</mapper>
<!--<?xml version="1.0" encoding="UTF-8" ?>-->
<!--<!DOCTYPE mapper-->
<!--        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"-->
<!--        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">-->
<!--<mapper namespace="com.dao.PaperDao">-->
<!--    <resultMap type="Paper" id="paperResultMap" >-->
<!--        <id property="paperId" column="paper_id"/>-->
<!--        <result property="paperName" column="name"/>-->
<!--        <result property="paperNum" column="number"/>-->
<!--        <result property="paperDetail" column="detail"/>-->
<!--    </resultMap>-->
<!--    <insert id="addPaper" parameterType="Paper">-->
<!--        INSERT INTO paper(paper_id,name,number,detail) VALUE (#{paperId},#{paperName}, #{paperNum}, #{paperDetail})-->
<!--    </insert>--><!--    <delete id="deletePaperById" parameterType="long">-->
<!--        DELETE FROM paper WHERE paper_id=#{paperID}-->
<!--    </delete>--><!--    <update id="updatePaper" parameterType="Paper">-->
<!--        UPDATE paper-->
<!--        SET NAME = #{paperName},NUMBER = #{paperNum},detail = #{paperDetail}-->
<!--        WHERE  paper_id = #{paperId}-->
<!--    </update>--><!--    <select id="queryById" resultType="Paper" parameterType="long">-->
<!--        SELECT paper_id,name,number,detail-->
<!--        FROM paper-->
<!--        WHERE paper_id=#{paperId}-->
<!--    </select>-->
<!--    <select id="queryAllPaper" resultMap="paperResultMap">-->
<!--        SELECT paper_id,name,number,detail-->
<!--        FROM paper-->
<!--    </select>--><!--</mapper>-->

// jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/soso?useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=root

// log4j.properties

log4j.rootLogger=ERROR, stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

// mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 配置全局属性 -->
<settings>
<!-- 使用jdbc的getGeneratedKeys获取数据库自增主键值 -->
<setting name="useGeneratedKeys" value="true" /><!-- 使用列别名替换列名 默认:true -->
<setting name="useColumnLabel" value="true" /><!-- 开启驼峰命名转换:Table{create_time} -> Entity{createTime} -->
<setting name="mapUnderscoreToCamelCase" value="true" />
</settings>
</configuration>

（3）JSP

Web 界面配置

// index.jsp 主界面

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" %>
<% pageContext.setAttribute("path", request.getContextPath()); %>
<!DOCTYPE HTML>
<html>
<head>
<title>首页</title>
<style type="text/css">
a {text-align: center;text-decoration: none;color: black;font-size: 18px;
}
h3 {width: 180px;height: 38px;margin: 20px auto;text-align: center;line-height: 38px;background: deepskyblue;border-radius: 4px;
}
</style>
</head>
<body>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1> Soso移动应用大厅 </h1>
</div>
</div>
</div>
</div>
<br><br>
<h3> <a href="${path }/soso/allUserWeb">用户登录</a> </h3>
<h3> <a href="${path }/soso/userRegisterWeb">用户注册</a> </h3>
<h3> <a href="${path }/paper/addPaper">使用嗖嗖</a> </h3>
<h3> <a href="${path }/paper/updatePaper">话费充值</a> </h3>
<h3> <a href="${path }/paper/allPaper">资费说明</a> </h3>
<h3> <a href="${path }/paper/updatePaper">退出系统</a> </h3>
</body>
</html>

（4）pom.xml

在此文件中配置项目所需要的 jar 包。

<!--<?xml version="1.0" encoding="UTF-8"?>--><!--<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"-->
<!--  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">-->
<!--  <modelVersion>4.0.0</modelVersion>--><!--  <groupId>com</groupId>-->
<!--  <artifactId>first</artifactId>-->
<!--  <version>1.0-SNAPSHOT</version>-->
<!--  <packaging>war</packaging>--><!--  <name>first Maven Webapp</name>-->
<!--  &lt;!&ndash; FIXME change it to the project's website &ndash;&gt;-->
<!--  <url>http://www.example.com</url>--><!--  <properties>-->
<!--    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>-->
<!--    <maven.compiler.source>1.7</maven.compiler.source>-->
<!--    <maven.compiler.target>1.7</maven.compiler.target>-->
<!--  </properties>--><!--  <dependencies>-->
<!--    <dependency>-->
<!--      <groupId>junit</groupId>-->
<!--      <artifactId>junit</artifactId>-->
<!--      <version>4.11</version>-->
<!--      <scope>test</scope>-->
<!--    </dependency>-->
<!--  </dependencies>--><!--  <build>-->
<!--    <finalName>first</finalName>-->
<!--    <pluginManagement>&lt;!&ndash; lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) &ndash;&gt;-->
<!--      <plugins>-->
<!--        <plugin>-->
<!--          <artifactId>maven-clean-plugin</artifactId>-->
<!--          <version>3.1.0</version>-->
<!--        </plugin>-->
<!--        &lt;!&ndash; see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging &ndash;&gt;-->
<!--        <plugin>-->
<!--          <artifactId>maven-resources-plugin</artifactId>-->
<!--          <version>3.0.2</version>-->
<!--        </plugin>-->
<!--        <plugin>-->
<!--          <artifactId>maven-compiler-plugin</artifactId>-->
<!--          <version>3.8.0</version>-->
<!--        </plugin>-->
<!--        <plugin>-->
<!--          <artifactId>maven-surefire-plugin</artifactId>-->
<!--          <version>2.22.1</version>-->
<!--        </plugin>-->
<!--        <plugin>-->
<!--          <artifactId>maven-war-plugin</artifactId>-->
<!--          <version>3.2.2</version>-->
<!--        </plugin>-->
<!--        <plugin>-->
<!--          <artifactId>maven-install-plugin</artifactId>-->
<!--          <version>2.5.2</version>-->
<!--        </plugin>-->
<!--        <plugin>-->
<!--          <artifactId>maven-deploy-plugin</artifactId>-->
<!--          <version>2.8.2</version>-->
<!--        </plugin>-->
<!--      </plugins>-->
<!--    </pluginManagement>-->
<!--  </build>-->
<!--</project>--><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com</groupId><artifactId>first</artifactId><packaging>war</packaging><version>1.0-SNAPSHOT</version><name>first Maven Webapp</name><url>http://maven.apache.org</url><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding><spring.version>5.0.3.RELEASE</spring.version><mybatis.version>3.4.4</mybatis.version></properties><dependencies><!-- 单元测试 --><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>3.8.1</version><scope>test</scope></dependency><!-- 第一部分：Spring 配置--><!-- Spring core --><dependency><groupId>org.springframework</groupId><artifactId>spring-core</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-beans</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context-support</artifactId><version>${spring.version}</version></dependency><!-- Spring DAO --><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>${spring.version}</version></dependency><!-- Spring mvc --><dependency><groupId>org.springframework</groupId><artifactId>spring-web</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId><version>${spring.version}</version></dependency><!-- 第二部分：Servlet web --><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>3.0.1</version><scope>provided</scope></dependency><dependency><groupId>javax.servlet.jsp</groupId><artifactId>jsp-api</artifactId><version>2.2</version><scope>provided</scope></dependency><dependency><groupId>javax.servlet</groupId><artifactId>jstl</artifactId><version>1.2</version></dependency><dependency><groupId>taglibs</groupId><artifactId>standard</artifactId><version>1.1.2</version></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-databind</artifactId><version>2.9.4</version></dependency><!-- 第三部分：数据库和mybatis --><!-- 数据库 --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.38</version></dependency><!-- 数据库连接池 --><dependency><groupId>com.mchange</groupId><artifactId>c3p0</artifactId><version>0.9.5.2</version></dependency><!-- MyBatis --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>${mybatis.version}</version></dependency><!-- mybatis-spring整合包 --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.3.1</version></dependency><!-- 第四部分：日志 --><!-- 实现slf4j接口并整合 --><dependency><groupId>ch.qos.logback</groupId><artifactId>logback-classic</artifactId><version>1.1.1</version></dependency></dependencies><build><finalName>first</finalName><plugins><plugin><groupId>org.apache.maven.plugins</groupId><artifactId>maven-compiler-plugin</artifactId><configuration><source>1.8</source><target>1.8</target></configuration></plugin></plugins></build>
</project>

（5）Spring

spring-dao.xml：（spring-mybatis 整合配置文件）

<?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"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsd"><!-- 配置整合mybatis过程 --><!-- 1.配置数据库相关参数properties的属性：${url} --><context:property-placeholder location="classpath:jdbc.properties"/><!-- 2.数据库连接池 --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><!-- 配置连接池属性 --><property name="driverClass" value="${jdbc.driver}"/><property name="jdbcUrl" value="${jdbc.url}"/><property name="user" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/><!-- c3p0连接池的私有属性 --><property name="maxPoolSize" value="30"/><property name="minPoolSize" value="10"/><!-- 关闭连接后不自动commit --><property name="autoCommitOnClose" value="false"/><!-- 获取连接超时时间 --><property name="checkoutTimeout" value="10000"/><!-- 当获取连接失败重试次数 --><property name="acquireRetryAttempts" value="2"/></bean><!-- 3.配置SqlSessionFactory对象 --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><!-- 注入数据库连接池 --><property name="dataSource" ref="dataSource"/><!-- 配置MyBaties全局配置文件:mybatis-config.xml --><property name="configLocation" value="classpath:mybatis-config.xml"/><!-- 扫描pojo包 使用别名 --><property name="typeAliasesPackage" value="com.pojo"/><!-- 扫描sql配置文件:mapper需要的xml文件 --><property name="mapperLocations" value="classpath:mapper/*.xml"/></bean><!-- 4.配置扫描Dao接口包，动态实现Dao接口，注入到spring容器中 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!-- 注入sqlSessionFactory --><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/><!-- 给出需要扫描Dao接口包 --><property name="basePackage" value="com.dao"/></bean>
</beans>

Spring-mvc

<?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:mvc="http://www.springframework.org/schema/mvc"
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/mvc
http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
<!-- 配置SpringMVC -->
<!-- 1.开启SpringMVC注解模式 -->
<!-- 简化配置：
(1)自动注册DefaultAnootationHandlerMapping,AnotationMethodHandlerAdapter
(2)提供一些列：数据绑定，数字和日期的format @NumberFormat, @DateTimeFormat, xml,json默认读写支持
-->
<mvc:annotation-driven /><!-- 2.静态资源默认servlet配置
(1)加入对静态资源的处理：js,gif,png
(2)允许使用"/"做整体映射
-->
<mvc:default-servlet-handler/><!-- 3.配置jsp 显示ViewResolver -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp" />
</bean><!-- 4.扫描web相关的bean -->
<context:component-scan base-package="com.controller" />
</beans>

Spring-service

<?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"
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">
<!-- 扫描service包下所有使用注解的类型 -->
<context:component-scan base-package="com.service" /><!-- 配置事务管理器 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<!-- 注入数据库连接池 -->
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 配置基于注解的声明式事务 -->
<tx:annotation-driven transaction-manager="transactionManager" />
</beans>