Maven+Spring+SpringMVC+Mybatis

旧城等待， 2022-06-02 02:09 103阅读 0赞

# Maven+Spring+SpringMVC+Mybatis #

### 项目注意事项 ###

1.  编码：UTF-8
2.  jdk：1.7
3.  编译环境：1.7
4.  build path：1.7
5.  附图
    
     *  ![GO25xfx.png][]
6.  访问路径
    
     *  http://localhost:8066/selectUsers.action
     *  注：8066不要改，这个在pom.xml中tomcat的插件中配置
7.  先睹为快
    
     *  ![pCfzoGY.png][]

### 功能介绍 ###

*  通过maven管理Spring，SpringMVC，Mybatis
 *  页面展示数据库的信息【主要功能】
 *  增加、删除、更新信息通过js来演示【次要功能】

### 项目结构 ###

*  ![5JpR7Ke.png][]

### 数据库设计 ###

*  数据库名
    
     *  springmvc\_db
 *  表名
    
     *  user
 *  表结构
    
     *  ![djySiyG.png][]

### 具体代码 ###

*  src
    
     *  main
        
         *  java
            
             *  com
                
                 *  peng
                    
                     *  controller
                        
                         *  UserServlet.java
                            
                            #  #
                            
                                package com.peng.controller;
                                
                                import java.util.List;
                                
                                import org.springframework.beans.factory.annotation.Autowired;
                                import org.springframework.beans.factory.annotation.Qualifier;
                                import org.springframework.stereotype.Controller;
                                import org.springframework.ui.Model;
                                import org.springframework.web.bind.annotation.RequestMapping;
                                
                                import com.peng.pojo.User;
                                import com.peng.service.UserService;
                                
                                @Controller(value = "userServlet")
                                public class UserServlet {
                                    @Autowired
                                    @Qualifier(value = "userService")
                                    private UserService userService;
                                
                                    @RequestMapping("/selectUsers.action")
                                    public String findAllAction(Model model) {
                                        List<User> user_list = userService.selectUsers();
                                        System.out.println(user_list);
                                        model.addAttribute("user_list", user_list);
                                        return "users";
                                    }
                                }
                     *  mapper
                        
                         *  UserMapper.java
                            
                            #  #
                            
                                package com.peng.mapper;
                                
                                import java.util.List;
                                
                                import org.springframework.stereotype.Repository;
                                
                                import com.peng.pojo.User;
                                
                                @Repository(value = "userMapper")
                                public interface UserMapper {
                                    public List<User> selectUsers();
                                }
                     *  pojo
                        
                         *  User.java
                            
                            #  #
                            
                                package com.peng.pojo;
                                
                                import java.io.Serializable;
                                
                                @SuppressWarnings("serial")
                                public class User implements Serializable {
                                    private String id;
                                    private String name;
                                    private String email;
                                    private String money;
                                
                                    public User() {
                                        super();
                                    }
                                
                                    public User(String id, String name, String emial, String money) {
                                        super();
                                        this.id = id;
                                        this.name = name;
                                        this.email = emial;
                                        this.money = money;
                                    }
                                
                                    public String getId() {
                                        return id;
                                    }
                                
                                    public void setId(String id) {
                                        this.id = id;
                                    }
                                
                                    public String getName() {
                                        return name;
                                    }
                                
                                    public void setName(String name) {
                                        this.name = name;
                                    }
                                
                                    public String getEmial() {
                                        return email;
                                    }
                                
                                    public void setEmial(String emial) {
                                        this.email = emial;
                                    }
                                
                                    public String getMoney() {
                                        return money;
                                    }
                                
                                    public void setMoney(String money) {
                                        this.money = money;
                                    }
                                
                                    @Override
                                    public String toString() {
                                        return "【编号：" + id + "姓名：" + name + "，邮箱：" + email + "，存款：" + money + "】";
                                    }
                                
                                }
                         *  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.peng.mapper.UserMapper">
                                    <select id="selectUsers" resultType="com.peng.pojo.User">
                                        select * from user
                                    </select>
                                </mapper>
                     *  service
                        
                         *  UserService.java
                            
                            #  #
                            
                                package com.peng.service;
                                
                                import java.util.List;
                                
                                import com.peng.pojo.User;
                                
                                public interface UserService {
                                    /**
                                     * 查询所有的用户
                                     * 
                                     * @return
                                     */
                                    List<User> selectUsers();
                                
                                }
                         *  UserServiceImpl.java
                            
                            #  #
                            
                                package com.peng.service;
                                
                                import java.util.List;
                                
                                import org.springframework.beans.factory.annotation.Autowired;
                                import org.springframework.beans.factory.annotation.Qualifier;
                                import org.springframework.stereotype.Service;
                                
                                import com.peng.mapper.UserMapper;
                                import com.peng.pojo.User;
                                
                                @Service(value = "userService")
                                public class UserServiceImpl implements UserService {
                                
                                    // 注入dao层对象
                                    @Autowired
                                    @Qualifier(value = "userMapper")
                                    private UserMapper userMapper;
                                
                                    public List<User> selectUsers() {
                                        return userMapper.selectUsers();
                                    }
                                
                                }
         *  resources
            
             *  applicationContext.xml
                
                #  #
                
                    <?xml version="1.0" encoding="UTF-8"?>
                    <beans xmlns="http://www.springframework.org/schema/beans"
                        xmlns:context="http://www.springframework.org/schema/context"
                        xmlns:aop="http://www.springframework.org/schema/aop" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
                        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd 
                        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd ">
                        
                        <context:component-scan base-package="com.peng"></context:component-scan>
                        
                        <context:annotation-config></context:annotation-config>
                        
                        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
                            
                            <property name="dataSource" ref="c3p0dataSource"></property>
                            
                            <property name="configLocation" value="classpath:/sqlMapConfig.xml"></property>
                            
                            <property name="mapperLocations" value="classpath:/com/peng/pojo/*.xml"></property>
                        </bean>
                        
                        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
                            <property name="basePackage" value="com.peng.mapper"></property>
                        </bean>
                        
                        <bean
                            class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
                            <property name="location" value="classpath:/jdbc_config.properties"></property>
                        </bean>
                        
                        <bean id="c3p0dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
                            <property name="driverClass" value="${jdbc.driver}"></property>
                            <property name="jdbcUrl" value="${jdbc.url}"></property>
                            <property name="user" value="${jdbc.user}"></property>
                            <property name="password" value="${jdbc.password}"></property>
                            <property name="minPoolSize" value="3"></property>      
                            <property name="initialPoolSize" value="5"></property>  
                            <property name="acquireIncrement" value="3"></property> 
                        </bean>
                    </beans>
             *  applivationContext-mvc.xml
                
                #  #
                
                    <?xml version="1.0" encoding="UTF-8"?>
                    <beans xmlns="http://www.springframework.org/schema/beans"
                        xmlns:context="http://www.springframework.org/schema/context"
                        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
                        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd 
                        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd ">
                        
                        <context:component-scan base-package="com.peng"></context:component-scan>
                        
                        <context:annotation-config></context:annotation-config>
                        
                        <bean
                            class="org.springframework.web.servlet.view.InternalResourceViewResolver">
                            <property name="prefix" value="/WEB-INF/">
                            </property>
                            <property name="suffix" value=".jsp"></property>
                        </bean>
                        
                        <bean id="multipartResolver"
                            class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
                            <property name="defaultEncoding" value="utf-8"></property>
                            <property name="maxUploadSize" value="10485760000"></property>
                            <property name="maxInMemorySize" value="40960"></property>
                        </bean>
                    </beans>
             *  jdbc\_config.properties
                
                #  #
                
                    jdbc.user=root
                    jdbc.password=root
                    jdbc.url=jdbc\:mysql\://localhost\:3306/springmvc_db
                    jdbc.driver=com.mysql.jdbc.Driver
             *  log4j.properties
                
                #  #
                
                    log4j.rootLogger=DEBUG, Console
                    #Console
                    log4j.appender.Console=org.apache.log4j.ConsoleAppender
                    log4j.appender.Console.layout=org.apache.log4j.PatternLayout
                    log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
                    log4j.logger.java.sql.ResultSet=INFO
                    log4j.logger.org.apache=INFO
                    log4j.logger.java.sql.Connection=DEBUG
                    log4j.logger.java.sql.Statement=DEBUG
                    log4j.logger.java.sql.PreparedStatement=DEBUG
             *  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>
                    </configuration>
         *  webapp
            
             *  js
                
                #  #
                
                    jquery的js文件（这个在这里就不粘贴了）
             *  WEB-INF
                
                 *  message.jsp
                    
                    #  #
                    
                        <%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
                        <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
                        <html>
                        <head>
                        <title>My JSP 'index.jsp' starting page</title>
                        </head>
                        
                        <body>
                            success!
                            <br>
                        </body>
                        </html>
                 *  users.jsp
                    
                    #  #
                    
                        <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
                        <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
                        <%@ page isELIgnored="false"%>
                        <!DOCTYPE HTML>
                        <html>
                        <head>
                        <title>用户管理</title>
                        <meta http-equiv="content-type" content="text/html; charset=UTF-8">
                        <style type="text/css">
                        body {
                            font-family: "微软雅黑"
                        }
                        
                        h2, h4 {
                            text-align: center;
                        }
                        
                        div#box1, div#box2 {
                            text-align: center;
                        }
                        
                        hr {
                            margin: 20px 0;
                        }
                        
                        table {
                            margin: 0 auto;
                            width: 70%;
                            text-align: center;
                            border-collapse: collapse;
                        }
                        
                        td, th {
                            padding: 7px;
                            width: 20%;
                        }
                        
                        th {
                            background-color: #DCDCDC;
                        }
                        </style>
                        
                        
                        <script src="js/jquery-1.4.2.js"></script>
                        <script type="text/javascript">
                            $(function() {
                                $("#add").click(
                                        function() {
                                            //获取输入信息
                                            var id = $("#box1 input[name='id']").val().trim();
                                            var name = $("#box1 input[name='name']").val().trim();
                                            var email = $("#box1 input[name='email']").val().trim();
                                            var salary = $("#box1 input[name='salary']").val().trim();
                                            //校验
                                            if (id == "" || name == "" || email == "" || salary == "") {
                                                alert("员工信息不能为空");
                                                return;
                                            }
                                            //员工id不能重复
                                            var flag = false;
                                            $("table tr").each(function() {
                                                if ($(this).find("td:eq(1)").text() == id) {
                                                    alert("ID已存在");
                                                    flag = true;
                                                    return false;
                                                }
                                            });
                                            if (flag) {
                                                return;
                                            }
                                            //将员工信息添加到列表中
                                            var $tab = $("table");
                                            var $tr = $("<tr></tr>");
                                            var $td0 = $("<td><input type='checkbox'/></td>");
                                            var $td1 = $("<td>" + id + "</td>");
                                            var $td2 = $("<td>" + name + "</td>");
                                            var $td3 = $("<td>" + email + "</td>");
                                            var $td4 = $("<td>" + salary + "</td>");
                                            $tr.append($td0).append($td1).append($td2).append($td3)
                                                    .append($td4);
                                            $tab.append($tr);
                        
                                        });
                                //全选按钮
                                $("#all").click(function() {
                                    //获取全选状态
                                    var check = $(this).attr("checked");
                                    //将其他复选框状态与全选一致
                                    $("table input").attr("checked", check);
                                });
                                //删除
                                $("#del").click(function() {
                                    $("input:checked:not(input[id='all'])").parents("tr").remove();
                                });
                                //修改
                                $("#upd").click(function() {
                                    //获取修改信息
                                    var id = $("#box2 input[name='id']").val().trim();
                                    var name = $("#box2 input[name='name']").val().trim();
                                    var email = $("#box2 input[name='email']").val().trim();
                                    var salary = $("#box2 input[name='salary']").val().trim();
                        
                                    //校验
                                    if (id == "" || name == "" || email == "" || salary == "") {
                                        alert("修改信息不能为空");
                                        return;
                                    }
                                    //根据ID进行修改 
                                    var flag = true;
                                    $("table tr").each(function() {
                                        if ($(this).find("td:eq(1)").text() == id) {
                                            //进行修改
                                            flag = false;
                                            $(this).find("td:eq(2)").text(name);
                                            $(this).find("td:eq(3)").text(email);
                                            $(this).find("td:eq(4)").text(salary);
                                            return false;
                        
                                        }
                                    });
                                    if (flag) {
                                        alert("员工id不存在！");
                                    }
                        
                                });
                        
                            });
                        </script>
                        </head>
                        
                        <body>
                            <h2>添加新员工</h2>
                            <div id="box1">
                                ID：<input type="text" name="id" /> 姓名：<input type="text" name="name" />
                                邮箱：<input type="text" name="email" /> 工资：<input type="text"
                                    name="salary" /> <input type="button" id="add" value="添加" />
                            </div>
                            <hr />
                            <table border="1">
                                <tr>
                                    <th><input type="checkbox" id="all" /> </th>
                                    <th>ID</th>
                                    <th>姓名</th>
                                    <th>邮箱</th>
                                    <th>工资</th>
                                </tr>
                                <c:forEach items="${user_list}" var="item">
                                    <tr>
                                        <td><input type="checkbox" /></td>
                                        <td>${item.id}</td>
                                        <td>${item.name}</td>
                                        <td>${item.emial}</td>
                                        <td>${item.money}</td>
                                    </tr>
                                </c:forEach>
                        
                            </table>
                            <p align="center">
                                <a href="#" id="del">删除选中</a>
                            </p>
                        
                            <hr />
                            <div id="box2">
                                ID：<input type="text" name="id" /> 姓名：<input type="text" name="name" />
                                邮箱：<input type="text" name="email" /> 工资：<input type="text"
                                    name="salary" /> <input type="button" id="upd" value="修改" />
                            </div>
                        </body>
                        </html>
                 *  web.xml
                    
                    #  #
                    
                        <!DOCTYPE web-app PUBLIC
                         "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
                         "http://java.sun.com/dtd/web-app_2_3.dtd" >
                        
                        <web-app>
                            
                            
                            <filter>
                                <filter-name>characterFilter</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>characterFilter</filter-name>
                                <url-pattern>/*</url-pattern>
                            </filter-mapping>
                            
                            <servlet>
                                <servlet-name>springmvc_dispatcher</servlet-name>
                                <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
                                <init-param>
                                    <param-name>contextConfigLocation</param-name>
                                    <param-value>classpath:/applicationContext*.xml</param-value>
                                </init-param>
                            </servlet>
                            
                            <servlet-mapping>
                                <servlet-name>springmvc_dispatcher</servlet-name>
                                <url-pattern>*.action</url-pattern>
                            </servlet-mapping>
                            
                            <welcome-file-list>
                                <welcome-file>index.jsp</welcome-file>
                            </welcome-file-list>
                        </web-app>
             *  index.jsp
                
                #  #
                
                    <html>
                    <body>
                    <h2>Hello World!</h2>
                    </body>
                    </html>
     *  test
        
         *  java
 *  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.peng</groupId>
            <artifactId>ssmm</artifactId>
            <packaging>war</packaging>
            <version>0.0.1-SNAPSHOT</version>
            <name>ssmm Maven Webapp</name>
            <url>http://maven.apache.org</url>
            <properties>
                
                <spring.version>4.0.2.RELEASE</spring.version>
                
                <mybatis.version>3.2.6</mybatis.version>
                
                <slf4j.version>1.7.7</slf4j.version>
                <log4j.version>1.2.17</log4j.version>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>c3p0</groupId>
                    <artifactId>c3p0</artifactId>
                    <version>0.9.1.2</version>
                </dependency>
                <dependency>
                    <groupId>junit</groupId>
                    <artifactId>junit</artifactId>
                    <version>3.8.1</version>
                    <scope>test</scope>
                </dependency>
                
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-core</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-oxm</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-jdbc</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-aop</artifactId>
                    <version>${spring.version}</version>
                </dependency>
        
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-context-support</artifactId>
                    <version>${spring.version}</version>
                </dependency>
        
                <dependency>
                    <groupId>org.springframework</groupId>
                    <artifactId>spring-test</artifactId>
                    <version>${spring.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.mybatis</groupId>
                    <artifactId>mybatis</artifactId>
                    <version>${mybatis.version}</version>
                </dependency>
                
                <dependency>
                    <groupId>org.mybatis</groupId>
                    <artifactId>mybatis-spring</artifactId>
                    <version>1.2.2</version>
                </dependency>
        
                
                <dependency>
                    <groupId>mysql</groupId>
                    <artifactId>mysql-connector-java</artifactId>
                    <version>5.1.30</version>
                </dependency>
        
                
                <dependency>
                    <groupId>commons-dbcp</groupId>
                    <artifactId>commons-dbcp</artifactId>
                    <version>1.2.2</version>
                </dependency>
                
                <dependency>
                    <groupId>jstl</groupId>
                    <artifactId>jstl</artifactId>
                    <version>1.2</version>
                </dependency>
                
                
                <dependency>
                    <groupId>log4j</groupId>
                    <artifactId>log4j</artifactId>
                    <version>${log4j.version}</version>
                </dependency>
        
        
                
                <dependency>
                    <groupId>com.alibaba</groupId>
                    <artifactId>fastjson</artifactId>
                    <version>1.1.41</version>
                </dependency>
        
        
                <dependency>
                    <groupId>org.slf4j</groupId>
                    <artifactId>slf4j-api</artifactId>
                    <version>${slf4j.version}</version>
                </dependency>
        
                <dependency>
                    <groupId>org.slf4j</groupId>
                    <artifactId>slf4j-log4j12</artifactId>
                    <version>${slf4j.version}</version>
                </dependency>
                
                
                <dependency>
                    <groupId>org.codehaus.jackson</groupId>
                    <artifactId>jackson-mapper-asl</artifactId>
                    <version>1.9.13</version>
                </dependency>
                
                <dependency>
                    <groupId>commons-fileupload</groupId>
                    <artifactId>commons-fileupload</artifactId>
                    <version>1.3.1</version>
                </dependency>
                <dependency>
                    <groupId>commons-io</groupId>
                    <artifactId>commons-io</artifactId>
                    <version>2.4</version>
                </dependency>
                <dependency>
                    <groupId>commons-codec</groupId>
                    <artifactId>commons-codec</artifactId>
                    <version>1.9</version>
                </dependency>
            </dependencies>
            <build>
                <plugins>
                    
                    <plugin>
                        <groupId>org.apache.tomcat.maven</groupId>
                        <artifactId>tomcat7-maven-plugin</artifactId>
                        <version>2.2</version>
                        <configuration>
                            <port>8066</port>
                            
                            <path>/</path>
                        </configuration>
                    </plugin>
                </plugins>
            </build>
        </project>

[GO25xfx.png]: https://i.imgur.com/GO25xfx.png
[pCfzoGY.png]: https://i.imgur.com/pCfzoGY.png
[5JpR7Ke.png]: https://i.imgur.com/5JpR7Ke.png
[djySiyG.png]: https://i.imgur.com/djySiyG.png

Maven+Spring+SpringMVC+Mybatis

发表评论取消回复

还没有评论，来说两句吧...

相关阅读