SSM項(xiàng)目整合
一党涕、maven工程
pom.xml
<?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.zengqingfa</groupId>
<artifactId>ssm</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<dependencies>
<!--spring核心包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
<!--spring aop支持包-->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.7</version>
</dependency>
<!--spring 事務(wù)包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
<!--springmvc包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
<!--mybatis包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<!--spring整合mybatis支持包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency>
<!--數(shù)據(jù)庫驅(qū)動(dòng)包吻谋、連接池-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.30</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
<!--servlet支持包-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
</dependency>
<!--junit測試包、spring對junit支持包-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
<!--添加jstl依賴-->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--json支持-->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.9.0</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.0</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.9.0</version>
</dependency>
</dependencies>
<build>
<plugins>
<!-- tomcat 插件 -->
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.2</version>
<configuration>
<path>/</path>
<port>9005</port>
</configuration>
</plugin>
<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>
二增淹、domain
1椿访、Account.java
package com.zengqingfa.entity;
/*
* @ author zengqingfa
* @ created in 2019/2/17 16:22
*
*/
/**
* PO(Persistence Object)持久化類
* 7個(gè)規(guī)范
* 1. 公有類
* 2. 公有無參構(gòu)造
* 3. 私有屬性
* 4. 公有的getter與setter
* 5. 實(shí)現(xiàn)java.io.Serializable接口
* 6. 不能用final修飾
* 7. 如果是基礎(chǔ)類型,要使用它的包裝類
*/
import java.io.Serializable;
public class Account implements Serializable {
private Integer accountid;
private Integer uid;
private Double money;
public Integer getAccountId() {
return accountid;
}
public void setAccountId(Integer accountId) {
this.accountid = accountid;
}
public Integer getUid() {
return uid;
}
public void setUid(Integer uid) {
this.uid = uid;
}
public Double getMoney() {
return money;
}
public void setMoney(Double money) {
this.money = money;
}
}
三虑润、controller
1成玫、AccountController.java
package com.zengqingfa.controller;
import com.zengqingfa.entity.Account;
import com.zengqingfa.service.IAccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;
import java.util.Date;
import java.util.List;
@Controller
public class AccountController {
// 注入service
@Autowired
private IAccountService accountService;
// 查詢?nèi)? @RequestMapping("/findAll")
public ModelAndView findAll() {
//1.調(diào)用service查詢
List<Account> list = accountService.findAll();
//2.返回結(jié)果
ModelAndView mv = new ModelAndView();
mv.setViewName("list");
mv.addObject("list", list);
mv.addObject("date", new Date());
return mv;
}
@RequestMapping("/findAll2")
@ResponseBody
public List<Account> findAll2() {
//1.調(diào)用service查詢
return accountService.findAll();
}
}
四、service
1拳喻、service接口
package com.zengqingfa.service;
import com.zengqingfa.entity.Account;
import java.util.List;
public interface IAccountService {
/**
* 查詢?nèi)? */
List<Account> findAll();
}
2哭当、service實(shí)現(xiàn)
package com.zengqingfa.service.impl;
import com.zengqingfa.dao.IAccountDao;
import com.zengqingfa.entity.Account;
import com.zengqingfa.service.IAccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
// 創(chuàng)建service對象
@Service
public class AccountServiceImpl implements IAccountService {
// 注入dao
@Autowired
private IAccountDao accountDao;
@Override
public List<Account> findAll() {
return accountDao.findAll();
}
}
五、dao
1冗澈、dao接口
package com.zengqingfa.dao;
import com.zengqingfa.entity.Account;
import org.apache.ibatis.annotations.Select;
import java.util.List;
public interface IAccountDao {
/**
* 查詢?nèi)? */
@Select("select * from account")
List<Account> findAll();
}
六钦勘、配置文件
1、web.xml
<?xml version="1.0" encoding="UTF-8"?>
<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_2_5.xsd"
version="2.5">
<!--加載Spring的容器的核心配置文件-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--配置要加載的容器的配置文件-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!--SpringMVC前端控制器-->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springMVC.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
2亚亲、springMVC.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: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.xsd">
<!--1.注解掃描-->
<context:component-scan base-package="com.zengqingfa.controller" />
<!--2.視圖解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/pages/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!--3.注解驅(qū)動(dòng)-->
<mvc:annotation-driven />
</beans>
3彻采、applicationContext.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:comtext="http://www.springframework.org/schema/context"
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">
<!--1.開啟注解掃描,只掃描service-->
<comtext:component-scan base-package="com.zengqingfa.service" />
<!--2. 加載配置文件-->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!--3. 創(chuàng)建連接池-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="${jdbc.driver}"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<!--4.Spring整合Mybatis,把SqlSessionFactory對象的創(chuàng)建交給Spring管理-->
<bean class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!--5. 創(chuàng)建包掃描器捌归,掃描dao接口肛响。自動(dòng)對dao接口生成代理對象-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.zengqingfa.dao"></property>
</bean>
<!--6. Spring聲明式事務(wù)管理-->
<!--6.1 事務(wù)管理器-->
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!--6.2 事務(wù)通知規(guī)則(切入點(diǎn)表達(dá)式攔截到方法后如何應(yīng)用事務(wù))-->
<tx:advice id="txAdvice" transaction-manager="txManager">
<tx:attributes>
<tx:method name="find*" propagation="SUPPORTS" read-only="true" />
<tx:method name="*" propagation="REQUIRED" read-only="false"/>
</tx:attributes>
</tx:advice>
<!--6.3 Aop配置-->
<aop:config>
<!--6.3.1 配置切入點(diǎn)表達(dá)式-->
<aop:pointcut id="pt" expression="execution(* com..*ServiceImpl.*(..))"></aop:pointcut>
<!--6.3.2 建立切入點(diǎn)表達(dá)式與通知規(guī)則的關(guān)系-->
<aop:advisor advice-ref="txAdvice" pointcut-ref="pt"></aop:advisor>
</aop:config>
</beans>
4、jdbc.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/vue?characterEncoding=utf8
jdbc.username=root
jdbc.password=root
jdbc.initialSize=3
jdbc.maxActive=10
5惜索、log4j.properties
# Set root category priority to INFO and its only appender to CONSOLE.
#log4j.rootCategory=INFO, CONSOLE debug info warn error fatal
log4j.rootCategory=debug, CONSOLE, LOGFILE
# Set the enterprise logger category to FATAL and its only appender to CONSOLE.
log4j.logger.org.apache.axis.enterprise=FATAL, CONSOLE
# CONSOLE is set to be a ConsoleAppender using a PatternLayout.
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n
# LOGFILE is set to be a File appender using a PatternLayout.
log4j.appender.LOGFILE=org.apache.log4j.FileAppender
log4j.appender.LOGFILE.File=d:\axis.log
log4j.appender.LOGFILE.Append=true
log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
log4j.appender.LOGFILE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n
七特笋、頁面
list.jsp
<%@ page import="java.util.Date" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%--1.核心標(biāo)簽庫--%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%--2.格式化與國際化標(biāo)簽庫--%>
<%@taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%--3.函數(shù)庫--%>
<%@taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<html>
<head>
<title>list</title>
</head>
<body>
<h3>foreach遍歷標(biāo)簽:遍歷數(shù)字</h3>
<c:forEach var="num" begin="1" end="10" step="2">
${num},
</c:forEach>
<h3>foreach遍歷request域數(shù)據(jù)</h3>
<table border="1" cellspacing="0" cellpadding="3">
<tr>
<td>序號(hào)</td>
<td>編號(hào)</td>
<td>用戶id</td>
<td>金額</td>
</tr>
<c:forEach var="account" items="${list}" varStatus="vs">
<tr>
<td>${vs.count}</td>
<td>${account.accountId}</td>
<td>${account.uid}</td>
<td>${account.money}</td>
</tr>
</c:forEach>
</table>
<h3>格式化金額、日期</h3>
<%--pattern="0.00 保留2位小數(shù)巾兆,不夠兩位自動(dòng)補(bǔ)0--%>
<fmt:formatNumber value="1" pattern="0.00"></fmt:formatNumber> ,
<fmt:formatNumber value="1.985" pattern="0.00"></fmt:formatNumber> ,
<%--pattern="#.## 保留2位小數(shù)猎物,不夠兩位不會(huì)自動(dòng)補(bǔ)0--%>
<fmt:formatNumber value="1" pattern="#.##"></fmt:formatNumber> ,
<fmt:formatNumber value="1.985" pattern="#.##"></fmt:formatNumber> ,
<%--格式化日期:value 就是日期值(java.util.Date)--%>
<fmt:formatDate value="${date}" pattern="yyyy/MM/dd"></fmt:formatDate>
<h3>函數(shù)庫(方便頁面操作字符串函數(shù))</h3>
${fn:contains("itcast", "cast")}
</body>
</html>
八虎囚、展示
1、http://localhost:8080/findAll.do
2蔫磨、http://localhost:8080/findAll2.do
[{"uid":45,"money":1000.0,"accountId":1},{"uid":46,"money":1000.0,"accountId":2},{"uid":46,"money":2000.0,"accountId":3}]