idea使用maven搭建ssm框架实现登陆商品增删改查
创建项目->maven->webapp->输入坐标->完成。
pom.xml
<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.david.mySSM</groupId> <artifactId>mySSM</artifactId> <packaging>war</packaging> <version>1.0-SNAPSHOT</version> <name>maven ssm</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版本号 --> <spring.version>4.3.5.RELEASE</spring.version> <!-- mybatis版本号 --> <mybatis.version>3.4.1</mybatis.version> </properties> <dependencies> <!-- java ee --> <dependency> <groupId>javax</groupId> <artifactId>javaee-api</artifactId> <version>7.0</version> </dependency> <!-- 单元测试 --> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency> <!-- 实现slf4j接口并整合 --> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-classic</artifactId> <version>1.2.2</version> </dependency> <!-- JSON --> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> <version>2.8.7</version> </dependency> <!-- 数据库 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.41</version> <scope>runtime</scope> </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> <!-- Spring --> <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-jdbc</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>${spring.version}</version> </dependency> <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> <!--jstl --> <dependency> <groupId>jstl</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <dependency> <groupId>taglibs</groupId> <artifactId>standard</artifactId> <version>1.1.2</version> </dependency> </dependencies> <build> <finalName>mySSM</finalName> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <configuration> <!-- 设置JDK版本 --> <source>1.8</source> <target>1.8</target> </configuration> </plugin> </plugins> <!--打包设置 以下文件强行加入编译文件 --> <resources> <resource> <directory>src/main/java</directory> </resource> <resource> <directory>src/main/resources</directory> </resource> </resources> </build> </project>
index.html
<html> <head> <title>index</title> </head> <body> <a href="/login">登陆</a> <a href="/product/list">商品管理</a> </body> </html>
web.xml
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1"> <display-name>mySSM</display-name> <!--post乱码 --> <filter> <filter-name>encoding</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> <init-param> <param-name>forceEncoding</param-name> <param-value>true</param-value> </init-param> </filter> <filter-mapping> <filter-name>encoding</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- 配置前端控制器 --> <servlet> <servlet-name>SpringMVC</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <!-- 配置springMVC需要加载的配置文件--> <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>SpringMVC</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <!--spring监听器 --> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:applicationContext.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <welcome-file-list> <welcome-file>index.html</welcome-file> </welcome-file-list> </web-app>
loginfaild.jsp
<%-- Created by IntelliJ IDEA. User: baidawei Date: 2018/5/27 Time: 下午9:47 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>重试</title> </head> <body> 登陆失败啦，账号错误请重试<a href="/login">登陆</a> </body> </html>
login.jsp
<%-- Created by IntelliJ IDEA. User: baidawei Date: 2018/5/27 Time: 下午7:42 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>login</title> </head> <body> <form action="/doLogin" method="post"> 用户名：<input name="userName"><br> 密码：<input name="passWord"><br> <button type="submit">提交</button> </form> </body> </html>
product/list.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> <html> <head> <title>list</title> <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"> </head> <body> <a href="/product/add" class="btn btn-primary">添加</a> <table class="table table-hover table-bordered "> <tr> <td>id</td> <td>name</td> <td>price</td> <td>operation</td> </tr> <c:forEach items="${list}" var="p"> <tr> <td>${p.id}</td> <td>${p.name}</td> <td>${p.price}</td> <td><a href="/product/edit/${p.id}" class="btn btn-danger">修改</a>|<a href="/product/delete/${p.id}" class="btn btn-info">删除</a></td> </tr> </c:forEach> </table> </body> </html>
product/edit
<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>edit</title> <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"> </head> <body> <form action="/product/editData" method="post"> <div class="form-group"> <label for="name">name</label> <input class="form-control" id="name" name="name" value="${p.name}" placeholder="name"> </div> <div class="form-group"> <label for="price">price</label> <input class="form-control" id="price" name="price" value="${p.price}" placeholder="price"> </div> <input name="id" value="${p.id}"> <button type="submit" class="btn btn-default">提交</button> </form> </body> </html>
product/add
<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>add</title> <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"> </head> <body> <form action="/product/addData" method="post"> <div class="form-group"> <label for="name">name</label> <input class="form-control" id="name" name="name" placeholder="name"> </div> <div class="form-group"> <label for="price">price</label> <input class="form-control" id="price" name="price" placeholder="price"> </div> <button type="submit" class="btn btn-default">提交</button> </form> </body> </html>
SqlMapConfig.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> <!-- 设置别名 --> <typeAliases> <package name="com.david.pojo"/> </typeAliases> </configuration>
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-3.0.xsd"> <!-- 扫描controller --> <context:component-scan base-package="com.david.controller"/> <!-- 扫描service --> <context:component-scan base-package="com.david.service"/> <!-- 开启注解模式 --> <mvc:annotation-driven/> <!-- 解决静态资源无法被springMVC处理的问题 --> <mvc:default-servlet-handler /> <!-- 配置视图解析器--> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="/WEB-INF/views/"/> <property name="suffix" value=".jsp"/> </bean> <!--登陆拦截器 --> <mvc:interceptors> <mvc:interceptor> <mvc:mapping path="/product/*"/> <bean class="com.david.utils.MyInterceptor"></bean> </mvc:interceptor> </mvc:interceptors> </beans>
jdbc.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/david2018_db?characterEncoding=utf-8
jdbc.username=root
jdbc.password=1234
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: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"> <!-- 加载配置文件--> <context:property-placeholder location="classpath:jdbc.properties"/> <!-- 数据库连接池 --> <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}"/> </bean> <!-- 配置SqlSessionFactory对象 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <!--mybatis核心文件 --> <property name="configLocation" value="classpath:SqlMapConfig.xml"></property> <!-- 注入数据库连接池 --> <property name="dataSource" ref="dataSource"/> </bean> <!-- 配置Mapper扫描 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.david.mapper" /> </bean> <!-- 配置事务管理器 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <!-- 注入数据库连接池 --> <property name="dataSource" ref="dataSource"/> </bean> <!-- 配置基于注解的声明式事务 --> <tx:annotation-driven transaction-manager="transactionManager"/> </beans>
MyInterceptor
package com.david.utils; import org.springframework.web.servlet.HandlerInterceptor; import org.springframework.web.servlet.ModelAndView; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class MyInterceptor implements HandlerInterceptor { /** * controller执行前调用此方法 * 返回true表示继续执行，返回false终止执行 这里可以加入登陆校验、权限拦截等 */ @Override public boolean preHandle(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o) throws Exception { String userName = (String) httpServletRequest.getSession().getAttribute("userName"); if(userName != "" && userName != null){ return true; } httpServletResponse.sendRedirect("/login"); return false; } /** * controller执行后但未返回视图前调用此方法 * 这里可在返回用户前对模型数据进行加工处理 比如可以加入共用信息以便页面显示 */ @Override public void postHandle(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, ModelAndView modelAndView) throws Exception { System.out.print("postHandle"); } /** * controller执行后且试图返回后调用此方法 * 这里可得到执行controller时的异常信息 也可以记录日志 */ @Override public void afterCompletion(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, Exception e) throws Exception { System.out.print("afterCompletion"); } }
UserServiceImpl
package com.david.service; import com.david.mapper.UserMapper; import com.david.pojo.User; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @Service public class UserServiceImpl implements UserService { @Autowired private UserMapper mapper; @Override public User GetUserByNameAndPass(User user) { return mapper.GetUserByNameAndPass(user); } }
UserService
package com.david.service; import com.david.pojo.User; public interface UserService { User GetUserByNameAndPass(User user); }
ProductServiceImpl
package com.david.service; import com.david.mapper.ProductMapper; import com.david.pojo.Product; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import javax.transaction.Transactional; @Service @Transactional public class ProductServiceImpl implements ProductService { @Autowired private ProductMapper mapper; @Override public List<Product> GetProductList() { return mapper.GetProductList(); } @Override public Product GetProductById(Integer id) { return mapper.GetProductById(id); } @Override public void addProduct(Product product) { mapper.addProduct(product); } @Override public void updateProduct(Product product) { mapper.updateProduct(product); } @Override public void deleteProduct(Integer id) { mapper.deleteProduct(id); } }
ProductService
package com.david.service; import com.david.pojo.Product; import java.util.List; public interface ProductService { List<Product> GetProductList(); Product GetProductById(Integer id); void addProduct(Product product); void updateProduct(Product product); void deleteProduct(Integer id); }
User
package com.david.pojo; public class User { private Integer UserId; private String UserName; private String PassWord; public User() { } public Integer getUserId() { return UserId; } public void setUserId(Integer userId) { UserId = userId; } public String getUserName() { return UserName; } public void setUserName(String userName) { UserName = userName; } public String getPassWord() { return PassWord; } public void setPassWord(String passWord) { PassWord = passWord; } }
Product
package com.david.pojo; public class Product { private Integer id; private String name; private String price; public Product() { } public Product(Integer id, String name, String price) { this.id = id; this.name = name; this.price = price; } public Product(String name, String price) { this.name = name; this.price = price; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPrice() { return price; } public void setPrice(String price) { this.price = price; } }
UserMapper.xml
<?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.david.mapper.UserMapper"> <select > select * from User where userName = #{userName} and PassWord = #{PassWord} </select> </mapper>
UserMappper
package com.david.mapper; import com.david.pojo.User; public interface UserMapper { User GetUserByNameAndPass(User user); }
ProductMapper.xml
<?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.david.mapper.ProductMapper"> <select > select * from Product </select> <select > select * from Product where id = #{id} </select> <insert > insert into product (name,price) values(#{name},#{price}) </insert> <update > update product set name = #{name},price = #{price} where id = #{id} </update> <delete > delete from product where id = #{id} </delete> </mapper>
ProductMapper
package com.david.mapper; import com.david.pojo.Product; import java.util.List; public interface ProductMapper { List<Product> GetProductList(); Product GetProductById(Integer id); void addProduct(Product product); void updateProduct(Product product); void deleteProduct(Integer id); }
ProductController
package com.david.controller; import com.david.pojo.Product; import com.david.service.ProductService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import java.util.List; @Controller @RequestMapping("/product") public class ProductController { @Autowired private ProductService productService; @RequestMapping("/list") public String list(Model model){ List<Product> pro = productService.GetProductList(); model.addAttribute("list",pro); return "product/list"; } @RequestMapping("/add") public String add(){ return "product/add"; } @RequestMapping("/addData") public String addData(Product p){ productService.addProduct(p); return "redirect:/product/list"; } @RequestMapping("/edit/{id}") public String edit(@PathVariable() Integer id,Model model){ Product p = productService.GetProductById(id); model.addAttribute("p",p); return "product/edit"; } @RequestMapping("/editData") public String editData(Product p){ productService.updateProduct(p); return "redirect:/product/list"; } @RequestMapping("/delete/{id}") public String delete(@PathVariable() Integer id){ productService.deleteProduct(id); return "redirect:/product/list"; } }
LoginController
package com.david.controller; import com.david.pojo.User; import com.david.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import javax.servlet.http.HttpServletRequest; @Controller public class LoginController { @Autowired private UserService userService; @RequestMapping("/login") public String login(){ return "login"; } @RequestMapping("/doLogin") public String doLogin(HttpServletRequest request){ String userName = request.getParameter("userName"); String passWord = request.getParameter("passWord"); User u = new User(); u.setUserName(userName); u.setPassWord(passWord); User user = userService.GetUserByNameAndPass(u); if(user != null){ request.getSession().setAttribute("userName",userName); return "redirect:/product/list"; }else{ return "redirect:/loginFaild"; } } @RequestMapping("/loginFaild") public String loginFaild(){ return "loginFaild"; } }
jdbc.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/david2018_db?characterEncoding=utf-8
jdbc.username=root
jdbc.password=1234