SMM整合配置模板

时间：2023-02-07 17:30:00 smm0204色环电阻

这段时间，ssm框架整合简直就是配置地狱，经过大量的练习，发现还是记不住。
简单写个博客，mark下面，方便后期直接取写配置。

Maven篇

资源导出配置
这个是我自己用的版本，大家随意，我就是放个样式方便后期cv，如果您配置了问题，请回复沟通。

 <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.0modelVersion>      <groupId>com.ckvsokgroupId>     <artifactId>springmvcstudyartifactId>     <packaging>pompackaging>     <version>1.0-SNAPSHOTversion>     <modules>         <module>springmvc01module>         <module>springmvc02module>         <module>springmvc03module>     modules>      <properties>         <project.build.sourceEncoding>UTF-8span class="token tag">project.build.sourceEncoding>
        <maven.compiler.source>1.8maven.compiler.source>
        <maven.compiler.target>1.8maven.compiler.target>
    properties>

    <dependencies>
        
        <dependency>
            <groupId>org.springframeworkgroupId>
            <artifactId>spring-webmvcartifactId>
            <version>5.3.5version>
        dependency>
        
        <dependency>
            <groupId>org.mybatisgroupId>
            <artifactId>mybatisartifactId>
            <version>3.5.6version>
        dependency>
        
        <dependency>
            <groupId>org.mybatisgroupId>
            <artifactId>mybatis-springartifactId>
            <version>2.0.6version>
        dependency>


        
        <dependency>
            <groupId>javax.servletgroupId>
            <artifactId>servlet-apiartifactId>
            <version>2.5version>
        dependency>
        <dependency>
            <groupId>javax.servlet.jspgroupId>
            <artifactId>jsp-apiartifactId>
            <version>2.1.3-b06version>
        dependency>
        <dependency>
            <groupId>javax.servletgroupId>
            <artifactId>jstlartifactId>
            <version>1.2version>
        dependency>

        
        
        <dependency>
            <groupId>com.mchangegroupId>
            <artifactId>c3p0artifactId>
            <version>0.9.5.5version>
        dependency>
        
        <dependency>
            <groupId>mysqlgroupId>
            <artifactId>mysql-connector-javaartifactId>
            <version>5.1.23version>
        dependency>
        
        <dependency>
            <groupId>org.springframeworkgroupId>
            <artifactId>spring-jdbcartifactId>
            <version>5.3.5version>
        dependency>
        
        <dependency>
            <groupId>org.projectlombokgroupId>
            <artifactId>lombokartifactId>
            <version>1.18.20version>
        dependency>
    dependencies>
    <build>
        <resources>
            <resource>
                
                <directory>src/main/resourcesdirectory>
                <includes>
                    <include>**/*.propertiesinclude>
                    <include>**/*.xmlinclude>
                includes>
            resource>
            <resource>
                <directory>src/main/javadirectory>
                <includes>
                    <include>**/*.propertiesinclude>
                    <include>**/*.xmlinclude>
                includes>
                <filtering>truefiltering>
            resource>
        resources>
    build>

project>

Mybatis篇

mybatis的配置文件
数据源就放在spring中配置



<configuration>
    <settings>
        
        <setting name="mapUnderscoreToCamelCase" value="true"/>
        
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    settings>
    
    <typeAliases>
        <package name="com.ckvsok.pojo"/>
    typeAliases>
    
    <mappers>
        <package name="com.ckvsok.dao"/>
    mappers>
configuration>

mapper的配置文件
常见的CRUD，后面更新的话，把ResultMap的使用加上




<mapper namespace="com.ckvsok.dao.BookMapper">
    
    <insert id="addBook">
        insert into book (bookName, bookCounts, detail) VALUES (#{bookName} ,#{bookCounts} , #{detail})
    insert>
    <delete id="deleteBookById">
        delete from book where bookId = #{id}
    delete>
    <update id="updateBook" parameterType="Book">
        update book set bookName = #{bookName},bookCounts=#{bookCounts},detail=#{detail} where bookId = #{bookId};
    update>
    <select id="queryBookById" resultType="Book">
        select bookId, bookName, bookCounts, detail from book where bookId = #{id}
    select>
    <select id="queryAllBook" resultType="Book">
        select bookId, bookName, bookCounts, detail from book
    select>
    
    <select id="queryBookByName" resultType="Book">
        select bookId, bookName, bookCounts, detail from book
        <where>
          <if test="name !=null">
            bookName like #{name} or detail like #{name}
          if>
        where>
    select>
mapper>

springmvc

我会分的比较细，也是方便记忆。后面会通过一个applicationContext把几个配置文件整合到一起。

Dao 持久层

常用数据库连接信息properties文件，这个方便拷贝URL地址

c3p0.driverClass=com.mysql.jdbc.Driver
c3p0.jdbcUrl=jdbc:mysql://localhost:3306/springmvc?characterEncoding=utf8&useUnicode=true&useSSL=false
c3p0.user=root
c3p0.password=123456

spring-dao配置文件


<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" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">

    
    <context:property-placeholder location="classpath:c3p0.properties"/>

    
    <bean class="com.mchange.v2.c3p0.ComboPooledDataSource" id="dataSource">
        
        <property name="driverClass" value="${c3p0.driverClass}"/>
        <property name="jdbcUrl" value="${c3p0.jdbcUrl}"/>
        <property name="user" value="${c3p0.user}"/>
        <property name="password" value="${c3p0.password}"/>
        
        
        
        
        
        
        
        
        
        

        
        
        
        
        
        
        
                
                
        
        
        

        
                
               
        
    bean>

    
    <bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sqlSessionFactory">
        <property name="dataSource" ref="dataSource"/>
        <property name="configLocation" value="classpath:mybaits-config.xml"/>
    bean>

    
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        <property name="basePackage" value="com.ckvsok.dao"/>
    bean>
beans>

Service 业务层


<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" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
    
    <context:annotation-config/>
    
    <context:component-scan base-package="com.ckvsok.service"/>

    
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        
        <property name="dataSource" ref="dataSource"/>
    bean>

beans>

视图层


<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
    
    <mvc:annotation-driven/>

    
    <mvc:default-servlet-handler/>

    
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" id="internalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/jsp/"/>
        <property name="suffix" value=".jsp"/>
    bean>
    
    <context:component-scan base-package="com.ckvsok.controller"/>

beans>

最后通过一个配置文件集合


<beans xmlns="http://www.springframework.org/schema/beans" 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.xsd">
    
    <import resource="classpath:spring-dao.xml"/>
    <import resource="classpath:spring-mvc.xml"/>
    <import resource="classpath:spring-service.xml"/>

beans>

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

SMM整合配置模板

相关文章