maven 整合spring+springmvc+mybatis+mysql

时间：2023-06-19 18:37:00 jst连接器07p

maven 环境变量配置

Maven下载

下载地址：http://maven.apache.org/download.cgi

apache-maven路径(版本会不断更新)

系统环境变量配置HOME_MAVEN

电脑——>属性——>高级系统设置——>环境变量

1.新建环境变量(用户变量)HOME_MAVEN，变量值是apache-maven路径。

2.编辑系统变量中的编辑系统变量path，把apache-maven里的bin路径添加到变量值后面，我的是;F:\mvn\apache-maven-3.5.4\bin;。(注意前后；号码，也可以是%MAVEN_HOME%\bin，如何使用个错误来尝试前面的绝对路径。)

3.配置本地maven仓库路径

找到文件settings.xml ，我的在F:\mvn\apache-maven-3.5.4\conf文件夹下

本地库默认路径为C盘${user}/.m2/repository/

配置自定义仓库地址

F:/repository

maven配置阿里镜像。

alimaven
aliyun maven
http://maven.aliyun.com/nexus/content/groups/public/
central

4.eclipse配置maven。

Windows->preferences,配置maven的installations，点击add，点击directory，installation home是maven安装路径，installation name自动带出。

配置maven user settins。点击Window的属性。

在解决更新项目时，报告以下配置Dmaven.multiModuleProjectDirectory某某set的问题。

在default vm处配置改为-Dmaven.multiModuleProjectDirectory=$MAVEN_HOME。(等号前固定，等号后固定Maven变量名称的配置)。

*新建maven工程。

建好项目后会报红星错误，bulid path jdk默认版本，或以下版本jdk相同版本，然后根据以下配置，然后clean一下。

点击project里的属性。

上面错误解决方式。

1.web.xml里的

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_3_0.xsd"
version="3.0">的web-app的版本号改为3.0.

2.找到org.eclipse.wst.common.project.facet.core.xml文件，修改java为1.8，jst.web为3.0.

若未显示.settings文件夹。按以下操作。

1.选择工程，选择Filters

2.取消.resources勾选，点击OK.显示.settings文件夹, .classpath 文件, .project文件, .gitignore文件

新建src/main/resources.(注意必须是新建的source Folder类型的)

SSM整合。

首先，看看项目的目录结构

未展开的目录结构。

展开后的目录结构。

二、maven需要引入的jar包，pom.xml

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

project_star Maven Webapp

http://maven.apache.org

4.0.2.RELEASE

3.2.6

div class="cnblogs_code_toolbar"> 1.7.7

spring-context-support

org.mybatis.generator

mybatis-generator-core

1.3.6

project_star

org.apache.maven.plugins

maven-compiler-plugin

3.5.1

1.8

UTF-8

三、建立JDBC属性配置文件，jdbc.properties

#数据库驱动

driver=com.mysql.jdbc.Driver

#数据库连接

url=jdbc:mysql://localhost:3306/konglx?useUnicode=true&characterEncoding=UTF-8

#用户名

username=root

#用户密码

password=root

#定义初始连接数

initialSize=0

#定义最大连接数

maxActive=20

#定义最大空闲

maxIdle=20

#定义最小空闲

minIdle=1

#定义最长等待时间

maxWait=60000

四、log4j日志配置文件， log4j.properties

# This is the configuring for logging displayed in the Application Server
log4j.rootCategory=INFO, stdout,common-default,common-warn,common-error

# project loggers
#log4j.logger.com.konglx.dao=INFO,project-dao
log4j.logger.com.konglx.service=INFO,project-service
log4j.logger.com.konglx.controller=INFO,project-web

# common appenders
#stdout configure
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.conversionPattern= %d [%X{loginUserId}/%X{req.remoteAddr}/%X{traceId} - %X{entranceMethod} - %X{req.requestURIWithQueryString}] %-5p %c - %m%n

#common-default file appender
log4j.appender.common-default=org.apache.log4j.DailyRollingFileAppender
log4j.appender.common-default.file=${user.home}/logs/common-default.log
log4j.appender.common-default.layout=org.apache.log4j.PatternLayout
log4j.appender.common-default.layout.conversionPattern= %d [%X{loginUserId}/%X{req.remoteAddr}/%X{traceId} - %X{entranceMethod} - %X{req.requestURIWithQueryString}] %-5p %c - %m%n

#common-warn file appender
log4j.appender.common-warn=org.apache.log4j.DailyRollingFileAppender
log4j.appender.common-warn.file=${user.home}/logs/common-warn.log
log4j.appender.common-warn.layout=org.apache.log4j.PatternLayout
log4j.appender.common-warn.filter.ID=org.apache.log4j.varia.LevelRangeFilter
log4j.appender.common-warn.filter.ID.levelMin=WARN
log4j.appender.common-warn.filter.ID.levelMax=WARN
log4j.appender.common-warn.layout.conversionPattern= %d [%X{loginUserId}/%X{req.remoteAddr}/%X{traceId} - %X{entranceMethod} - %X{req.requestURIWithQueryString}] %-5p %c - %m%n

#common-error file appender
log4j.appender.common-error=org.apache.log4j.DailyRollingFileAppender
log4j.appender.common-error.file=${user.home}/logs/common-error.log
log4j.appender.common-error.layout=org.apache.log4j.PatternLayout
log4j.appender.common-error.threshold=ERROR
log4j.appender.common-error.layout.conversionPattern= %d [%X{loginUserId}/%X{req.remoteAddr}/%X{traceId} - %X{entranceMethod} - %X{req.requestURIWithQueryString}] %-5p %c - %m%n

#common-dao file appender
log4j.appender.common-dao=org.apache.log4j.DailyRollingFileAppender
log4j.appender.common-dao.file=${user.home}/logs/common-dao.log
log4j.appender.common-dao.layout=org.apache.log4j.PatternLayout
log4j.appender.common-dao.layout.conversionPattern= %d [%X{loginUserId}/%X{req.remoteAddr}/%X{traceId} - %X{entranceMethod} - %X{req.requestURIWithQueryString}] %-5p %c - %m%n

#common-web file appender
log4j.appender.common-web=org.apache.log4j.DailyRollingFileAppender
log4j.appender.common-web.file=${user.home}/logs/common-web.log
log4j.appender.common-web.layout=org.apache.log4j.PatternLayout
log4j.appender.common-web.layout.conversionPattern= %d [%X{loginUserId}/%X{req.remoteAddr}/%X{traceId} - %X{entranceMethod} - %X{req.requestURIWithQueryString}] %-5p %c - %m%n

#common-pageNotFound file appender
log4j.appender.common-pageNotFound=org.apache.log4j.DailyRollingFileAppender
log4j.appender.common-pageNotFound.file=${user.home}/logs/common-pageNotFound.log
log4j.appender.common-pageNotFound.layout=org.apache.log4j.PatternLayout
log4j.appender.common-pageNotFound.layout.conversionPattern= %d [%X{loginUserId}/%X{req.remoteAddr}/%X{traceId} - %X{entranceMethod} - %X{req.requestURIWithQueryString}] %-5p %c - %m%n

# project appenders

#project-dao file appender
#log4j.appender.project-dao=org.apache.log4j.DailyRollingFileAppender
#log4j.appender.project-dao.file=${user.home}/logs/project-dao.log
#log4j.appender.project-dao.layout=org.apache.log4j.PatternLayout
#log4j.appender.project-dao.threshold=INFO
#log4j.appender.project-dao.layout.conversionPattern= %d [%X{loginUserId}/%X{req.remoteAddr}/%X{traceId} - %X{entranceMethod} - %X{req.requestURIWithQueryString}] %-5p %c - %m%n

#project-web file appender
log4j.appender.project-web=org.apache.log4j.DailyRollingFileAppender
log4j.appender.project-web.file=${user.home}/logs/project-web.log
log4j.appender.project-web.layout=org.apache.log4j.PatternLayout
log4j.appender.project-web.threshold=INFO
log4j.appender.project-web.layout.conversionPattern= %d [%X{loginUserId}/%X{req.remoteAddr}/%X{traceId} - %X{entranceMethod} - %X{req.requestURIWithQueryString}] %-5p %c - %m%n

#project-service file appender
log4j.appender.project-service=org.apache.log4j.DailyRollingFileAppender
log4j.appender.project-service.file=${user.home}/logs/project-service.log
log4j.appender.project-service.layout=org.apache.log4j.PatternLayout
log4j.appender.project-service.threshold=INFO
log4j.appender.project-service.layout.conversionPattern= %d [%X{loginUserId}/%X{req.remoteAddr}/%X{traceId} - %X{entranceMethod} - %X{req.requestURIWithQueryString}] %-5p %c - %m%n

# open source framework loggers

#spring
log4j.logger.org.springframework=INFO
log4j.logger.org.springframework.jdbc=DEBUG,common-dao

# debug log for ibatis2.3
#log4j.logger.java.sql.Connection=DEBUG,common-dao
#log4j.logger.java.sql.Statement=INFO,common-dao
#log4j.logger.java.sql.PreparedStatement=INFO,common-dao
#log4j.logger.java.sql.ResultSet=INFO,common-dao

# debug log for mybatis
log4j.logger.java.sql.Connection=DEBUG,common-dao
log4j.logger.java.sql.Statement=DEBUG,common-dao
log4j.logger.java.sql.PreparedStatement=DEBUG,common-dao
log4j.logger.java.sql.ResultSet=DEBUG,common-dao
log4j.logger.org.mybatis.spring=DEBUG,common-dao
log4j.logger.com.springframework=DEBUG

# hibernate: Changing the log level to DEBUG will display SQL Hibernate generated
#log4j.logger.org.hibernate=INFO,common-dao
#log4j.logger.org.hibernate.SQL=ERROR
#log4j.logger.org.hibernate.cache=ERROR
#log4j.logger.net.sf.ehcache=ERROR

#springmvc pageNotFound
log4j.logger.org.springframework.web.servlet.PageNotFound=INFO,common-pageNotFound

#HibernateValidator
log4j.logger.org.apache.commons.validator.ValidatorResources=INFO

#log4jdbc,
log4j.logger.jdbc.sqlonly=ON
log4j.logger.jdbc.sqltiming=INFO,common-dao
log4j.logger.jdbc.audit=ON
log4j.logger.jdbc.resultset=ON
log4j.logger.jdbc.connection=ON

#====add==
### direct messages to file hibernate.log ###
#log4j.appender.file=org.apache.log4j.FileAppender
#log4j.appender.file.File=hibernate.log
#log4j.appender.file.layout=org.apache.log4j.PatternLayout
#log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger = debug , stdout

#log4j.logger.org.hibernate=info
#log4j.logger.org.hibernate=debug

### log HQL query parser activity
#log4j.logger.org.hibernate.hql.ast.AST=debug

### log just the SQL
#log4j.logger.org.hibernate.SQL=debug

### log JDBC bind parameters ###
#log4j.logger.org.hibernate.type=trace
#log4j.logger.org.hibernate.type=debug

### log schema export/update ###
#log4j.logger.org.hibernate.tool.hbm2ddl=debug

### log HQL parse trees
#log4j.logger.org.hibernate.hql=debug

### log cache activity ###
#log4j.logger.org.hibernate.cache=debug

### log transaction activity
#log4j.logger.org.hibernate.transaction=debug

### log JDBC resource acquisition
#log4j.logger.org.hibernate.jdbc=debug

### enable the following line if you want to track down connection ###
### leakages when using DriverManagerConnectionProvider ###
#log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=trace

五、建立spring-mybatis.xml配置文件

这个文件就是用来完成spring和mybatis的整合的，包含spring和mybatis的配置，包括自动扫描，自动注入，配置数据库；

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"

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-4.0.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-4.0.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

destroy-method="close">

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

六、整合springMVC，spring-mvc.xml

上面已经完成了2大框架的整合，SpringMVC的配置文件单独放，然后在web.xml中配置整合，主要是自动扫描控制器，视图模式，注解的启动这三个



    
    
        
            
                text/html;charset=UTF-8

七、配置web.xml

这里面是对spring-mybatis.xml的引入以及配置的spring-mvc的Servlet就是为了完成SSM整合，之前2框架整合不需要在此处进行任何配置。



    Archetype Created Web Application
    
    
    
        contextConfigLocation
        classpath:spring-*.xml
    
    
    
    
        encodingFilter
        org.springframework.web.filter.CharacterEncodingFilter
        true
        
            encoding
            UTF-8
        
    
    
        encodingFilter
        /*
    
    
    
    
        org.springframework.web.context.ContextLoaderListener
    
    
    
    
        org.springframework.web.util.IntrospectorCleanupListener
    
    
    
    
        SpringMVC
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath:spring-mvc.xml
        
        1
        true
    
    
        SpringMVC
        
        /
    
    
    
        /index.html
        /index.jsp

到目前为止，所有的整合已经完成，配置文件也搞好了，接下来就利用mybatis来自动生成一些java代码：

首先，我们建立数据库：下面是建库建表的语句

CREATE DATABASE `konglx`

DROP TABLE IF EXISTS `user_t`;

CREATE TABLE `user_t` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(40) NOT NULL,
  `password` varchar(255) NOT NULL,
  `age` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `user_t` VALUES (1,'project_star-konglx','123',24);

逆向工程的2种方式。

1.利用MyBatis Generator自动创建代码

在f盘上建立一个文件夹(本文用到的文件夹不包含中文字符)，然后在里面建个src文件夹，里面的东西如下图：

generatorConfig.xml需要手动配置，下面附上配置的内容信息：

最后，打开cmd，进入该文件夹(也可以在这个文件夹中按住 shift + 右击，选择"在此处打开命令窗口")，复制粘贴以下代码+回车

Java -jar mybatis-generator-core-1.3.6.jar -configfile generatorConfig.xml -overwrite

完成后，到该文件夹下打开src,如下

2.利用java自动创建代码

利用java生成代码，只要在generatorTemp.java文件运行main方法就可以了。run as ->java applicatoin.F5刷新整个项目，会在下面目录生成目录文件。

generatorTemp.java文件和generator.xml文件的目录。

generatorTemp.java文件内容。

package generator;

import java.io.File;
import java.util.ArrayList;
import java.util.List;

import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.Configuration;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.exception.XMLParserException;
import org.mybatis.generator.internal.DefaultShellCallback;
import org.springframework.core.io.DefaultResourceLoader;

public class generatorTemp {

    public void generator() throws Exception {

        List warnings = new ArrayList();
        boolean overwrite = true;
        
        
     // 获取文件分隔符
     		//String separator = File.separator;
     		
     		// 获取工程路径
     		//File projectPath = new DefaultResourceLoader().getResource("").getFile();
     		//while(!new File(projectPath.getPath()+separator+"src"+separator+"main").exists()){
     			//projectPath = projectPath.getParentFile();
     		//}
     		
     		
     		// 模板文件路径  F:\workspace\project_star\src\main\java\generator\generator.xml
     		//String tplPath = StringUtils.replace(projectPath+"/src/main/java/com/thinkgem/jeesite/generate/template", "/", separator);
        //指定 逆向工程配置文件
        File configFile = new File("./src/main/java/generator/generator.xml");
        ConfigurationParser cp = new ConfigurationParser(warnings);
        Configuration config = cp.parseConfiguration(configFile);
        DefaultShellCallback callback = new DefaultShellCallback(overwrite);
        MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config,
                callback, warnings);
        myBatisGenerator.generate(null);

    }

    public static void main(String[] args) throws Exception {
        try {
            generatorTemp generatorSqlmap = new generatorTemp();
            generatorSqlmap.generator();
        } catch (Exception e) {
            e.printStackTrace();
        }

    }
}

generator.xml文件内容。

service接口

package com.konglx.service;

import com.konglx.bean.User;

public interface UserService {
    
     public User getUserById(int userId);
    
}

serviceImpl实现类

package com.konglx.service.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.konglx.bean.User;
import com.konglx.dao.UserMapper;
import com.konglx.service.UserService;

@Service("userService")
public class UserServiceImpl implements UserService{
    
    @Autowired
    private UserMapper userDao;
    
    @Override
    public User getUserById(int userId) {

        return this.userDao.selectByPrimaryKey(userId);

    }

}

手动创建jsp页面

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>




project_star


    ${user.userName}

手动创建controller

package com.konglx.controller;

import javax.servlet.http.HttpServletRequest;

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 com.konglx.bean.User;
import com.konglx.service.impl.UserServiceImpl;

@Controller
@RequestMapping(value = "/user")
public class UserController {
    
    @Autowired
    private UserServiceImpl userServiceImpl;
    
    @RequestMapping(value = "/test")
    public String Index(HttpServletRequest request, Model model){
        int userId = Integer.parseInt(request.getParameter("id"));
        User user = userServiceImpl.getUserById(userId);
        model.addAttribute("user",user);
         return "User";
    }

}

至此，所有的代码已经完成了

最后，项目右键-maven-update project。然后maven-maven install。然后部署项目到Tomcat。

启动服务，访问url。 http://localhost:8080/project_star/user/test?id=1

启动成功，没有报错如下图。

锐单商城拥有海量元器件数据手册、IC替代型号，打造电子元器件IC百科大全！

maven 整合spring+springmvc+mybatis+mysql

三、建立JDBC属性配置文件，jdbc.properties

四、log4j日志配置文件 ， log4j.properties

五、建立spring-mybatis.xml配置文件

七、配置web.xml

逆向工程的2种方式。

1.利用MyBatis Generator自动创建代码

2.利用java自动创建代码

${user.userName}

相关文章

四、log4j日志配置文件， log4j.properties