IDEA的Spring+SpringMVC+Mybatis整合

最新推荐文章于 2023-02-04 13:34:58 发布

置顶人美就不要想得美

最新推荐文章于 2023-02-04 13:34:58 发布

阅读量341

点赞数 1

分类专栏： SSM

本文链接：https://blog.csdn.net/chen_long_yue/article/details/90247084

版权

SSM 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

IDEA搭建Spring、SpringMVC、Mybatis简单的项目整合很详细的注释和解释，简单入门上手

这里给大家演示一个简单的SSM框架快速入门和简单的代码解释，如果在部署的过程，出现了问题，而自己没有解决，可以联系我，给大家一些指导！

1、点击file–>new project

在这里插入图片描述

2、如图所示：可以参考写，一般groupID写域名，下面写项目名，版本不用管

在这里插入图片描述

3、下面点击右边的箭头加号，为了使maven的项目的初始化更快，不用慢慢等着

在这里插入图片描述

4、添加键值对：archetypeCatalog = internal

在这里插入图片描述

5、如下图，你也可以更改路径

在这里插入图片描述

点击完成，即maven的项目建立好了，下面我们来开始配置框架的配置

6、打开项目的的pom.xml 文件，添加以下依赖

 <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
    <spring.version>5.0.2.RELEASE</spring.version>
    <mybatis.version>3.4.4</mybatis.version>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</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 数据库相关操作 -->
    <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>
    <!--文件上传-->
    <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.6</version>
    </dependency>
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.17</version>
    </dependency>
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-api</artifactId>
      <version>1.7.7</version>
    </dependency>
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
      <version>1.7.7</version>
    </dependency>
    <dependency>
      <groupId>cglib</groupId>
      <artifactId>cglib</artifactId>
      <version>2.2</version>
    </dependency>
    <dependency>
      <groupId>com.google.code.gson</groupId>
      <artifactId>gson</artifactId>
      <version>2.2.4</version>
    </dependency>
  </dependencies>

7、点击如下，进行project structure设置

在这里插入图片描述

在main文件下，创建java文件夹，点击上面的source，使该目录为源码文件夹、新建resource文件夹，点击resource使该文件夹为配置文件的目录

8、在java目录下新建四个包，

controller springMVC 的控制层，负责和用户交互数据

bean javaBean 对象

service.imp 服务层

mapper 持久层

在这里插入图片描述

9、创建数据库

CREATE TABLE `user` (`id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(11) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `password` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8

10、新建一个JavaBean，对应数据库表user—User.java

package jgsu.clong.bean;
import java.io.Serializable;
public class User implements Serializable {
    /*用户ID*/
    private int id;
    /*用户名*/
    private String username;
    /*用户年龄*/
    private int age;
    /*用户密码*/
    private String password;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", age=" + age +
                ", password='" + password + '\'' +
                '}';
    }
}

11、在resource文件夹下建立4个xml文件

application.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">

    <!--配置spring扫描的包-->
    <context:component-scan base-package="jgsu.clong.service">
        <context:include-filter type="annotation"
                              expression="org.springframework.stereotype.Service"/>
    </context:component-scan>
    <!--加载properties文件-->
    <context:property-placeholder location="classpath:jdbcConfig.properties"/>
    <!--配置数据库连接信息-->
    <bean id="dataSource" 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.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>
    <!--配置sqlSessionFactionBean对象-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    <!--配置mybatis扫描的mapper包-->
    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="jgsu.clong.mapper"></property>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>
</beans>

jdbcConfig.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm #数据的对相的数据库名
jdbc.username=root
jdbc.password=123456  #密码

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

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>
    <typeAliases>
    </typeAliases>
</configuration>

springmvc-config.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">
    <!--配置包扫描-->
    <context:component-scan base-package="jgsu.clong.controller">
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        <context:include-filter type="annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice"/>
    </context:component-scan>
    <!--配置视图解析器-->
    <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/pages/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>
    <!--配置SpringMVC 文件上传的配置-->
    <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver" >
        <property name="maxUploadSize" value="1024000"></property>
        <property name="defaultEncoding" value="UTE-8"></property>
    </bean>
    <!--启动SpringMVC注解-->
    <mvc:annotation-driven></mvc:annotation-driven>
    <mvc:default-servlet-handler></mvc:default-servlet-handler>
</beans>

12、在WEB-INF/web.xml,加入代码

<!--配置spring在服务器启动的时候加载applicationContext.xml文件，创建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>
  <!--配置spring前端控制器在服务器启动时，完成加载-->
  <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-config.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>
  <!--配置响应的编码格式-->
  <filter>
    <filter-name>encodingFilter</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>
  </filter>
  <filter-mapping>
    <filter-name>encodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>

13、在controller目录下创建 UserController.java

@Controller
@RequestMapping("/user/")
public class UserController {

    @Autowired
    UserService userService;

    @RequestMapping("findAll")
    public String findAll(Model model){
        List<User> users = userService.findAll();
        for (User user:users){
            System.out.println(user);
        }
        model.addAttribute("users",users);
        return "success";
    }

    @RequestMapping("insertUser")
    public String insertUser(User user){
        System.out.println("执行insertUser方法！！！！");
        userService.insertUser(user);
        return "success";
    }
}

14、在service下创建UserService.java

public interface UserService {
    List<User> findAll();
    void insertUser(User user);
}

15、在service.impl下新建UserServiceImpl.java

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    UserMapper userMapper;
    @Override
    public List<User> findAll() {
        return userMapper.findAll();
    }
    @Override
    public void insertUser(User user) {
        userMapper.insertUser(user);
    }
}

16、在mapper目录新建UserMapper.java

public interface UserMapper {
    List<User> findAll();
    void insertUser(User user);
}

17、mapper新建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="jgsu.clong.mapper.UserMapper">
    <!--查询所有的user-->
    <select id="findAll" resultType="jgsu.clong.bean.User">
        select * from user
    </select>
    <!--插入一个user-->
    <insert id="insertUser" parameterType="jgsu.clong.bean.User">
        insert into user(username,age,password)values (#{username},#{age},#{password})
    </insert>
</mapper>

18、页面的添加，在index.jsp 添加

<form action="user/insertUser" method="post">
    <br>
    用户名：<input type="text" name="username"><br>
    年龄：<input type="text" name="age"><br>
    密码：<input type="text" name="password"><br>
    <input type="submit" value="提交"><br>
</form>

在webapp目录下，新建一个pages,下新建一个success.jsp，添加

<h3>跳转成功</h3>
<p>${users.get(0).username}</p>
<p>${users.get(1).username}</p>

所有的代码完成了，下面我们把项目部署到Tomcat就行了

19、部署tomcat

在这里插入图片描述

选择编辑配置文件

在这里插入图片描述

点击加号，选择本地Tomcat

在这里插入图片描述

可以给Tomcat起一个名字，选择已经配置好的Tomcat，选择游览器

在这里插入图片描述

可以任意选一个，对部署和展示没有任何影响

在这里插入图片描述

可以给自己的项目起一个名字。

然后好了，启动Tomcat，游览器输入：http://localhost:8080/ssm_demo/user/findAll ，查看数据库的用户数据，前提是数据库已经添加了数据

人美就不要想得美

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
IDEA的Spring+SpringMVC+Mybatis整合

IDEA搭建Spring、SpringMVC、Mybatis简单的项目整合很详细的注释和解释，简单入门上手这里给大家演示一个简单的SSM框架快速入门和简单的代码解释，如果在部署的过程，出现了问题，而自己没有解决，可以联系我，给大家一些指导！1、点击file–>new project2、如图所示：可以参考写，一般groupID写域名，下面写项目名，版本不用管3、下面点击右边的箭头...
复制链接

扫一扫