SSM框架——Spring+SpringMVC+MyBatis整合_Oracle

xiaoxaoyu

于 2021-04-30 14:52:36 发布

阅读量229

点赞数 1

分类专栏： # SSM 文章标签： mybatis spring 数据库

本文链接：https://blog.csdn.net/xiaoxaoyu/article/details/116303494

版权

SSM 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

文章目录

参考文章： SSM框架——Spring+SpringMVC+MyBatis整合测试案例

1、spring.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:tx="http://www.springframework.org/schema/tx"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       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
       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
       http://www.springframework.org/schema/mvc
       http://www.springframework.org/schema/mvc/spring-mvc.xsd">

<!--开启自动扫描，只扫描包的三层-->
    <context:annotation-config></context:annotation-config>
    <context:component-scan base-package="cn.kgc.mysmoracle"></context:component-scan>
<!--开启数据库链接,阿里druid连接池class：com.alibaba.druid.pool.DruidDataSource-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
        <property name="url" value="jdbc:oracle:thin:@192.168.221.205:1521:orcl"></property>
        <property name="username" value="xym"></property>
        <property name="password" value="xym"></property>
        <property name="initialSize" value="3"></property>
        <property name="maxActive" value="10"></property>
        <property name="minIdle" value="3"></property>
        <property name="validationQuery" value="select 1 from dual"></property>
    </bean>
<!--开启自动事务-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    <tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>
<!--开启spring和mybatis整合-->
    <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
<!--需要的其他配置文件写在这儿-->
        <property name="mapperLocations" value="classpath*:mapper/*.xml"></property>
        <property name="configLocation" value="classpath:mybatis.cfg.xml"></property>
    </bean>
<!--开启一个映射对象,basePackage="cn.kgc.mysmoracle.dao"-->
    <bean id="scannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="cn.kgc.mysmoracle.dao"></property>
    </bean>
<!--开启允许将用户的实体数据转为json的功能-->
    <mvc:annotation-driven></mvc:annotation-driven>
</beans>

2、mybatis.cfg.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,typeAlias-->
<configuration>
    <typeAliases>
        <typeAlias type="cn.kgc.mysmoracle.entity.Users" alias="user"></typeAlias>
    </typeAliases>
</configuration>

3、entity

public class Users {
    private int userid;
    private String username;
    private Date birthday;
    private float userhigh;
	
    getter、setter方法
}

4、dao

public interface UsersDAO {
    List<Users> findAll();
}

5、ctrl

暴露接口，此处未做

public class InitCtrl {
}

6、services

package cn.kgc.mysmoracle.services;

import cn.kgc.mysmoracle.dao.UsersDAO;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UsersService {
    @Autowired
    private UsersDAO udao;

    public void display(){
        System.out.println(udao.findAll());
    }
}

7、mapper

<?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="cn.kgc.mysmoracle.dao.UsersDAO">
    <select id="findAll" resultType="user">
        select userid,username,birthday,userhigh from users
    </select>
</mapper>

8、demo测试

public class MyTest {
    public static void main(String[] args) {
        ApplicationContext context = new ClassPathXmlApplicationContext("spring.xml");
        UsersService us = context.getBean(UsersService.class);
        us.display();
    }
}

9、依赖

<!-- https://mvnrepository.com/artifact/javax.servlet/servlet-api -->
<dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>servlet-api</artifactId>
    <version>2.5</version>
</dependency>

<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.10</version>
</dependency>
<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.1.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.6</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>1.3.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-core -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-core</artifactId>
    <version>4.3.8.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>4.3.8.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-beans -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-beans</artifactId>
    <version>4.3.8.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-webmvc</artifactId>
    <version>4.3.8.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>4.3.8.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-tx -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-tx</artifactId>
    <version>4.3.8.RELEASE</version>
</dependency>