Spring-06-Ioc-案例练习

一，.案例环境搭建-搭建spring+mybatis整合环境进行。

1.导入相关环境jar包

<?xml version="1.0" encoding="UTF-8"?>
<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">
    <parent>
        <artifactId>Spring2020</artifactId>
        <groupId>org.example</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>Spring-Text04</artifactId>
    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.20</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.16</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.3.1</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.23</version>
        </dependency>
        <!--mybatis整合spring  jar包-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.5</version>
        </dependency>
    </dependencies>
</project>

2.创建实体类com.liuboss.domain.       Account

package com.liuboss.domain;

import lombok.Data;

@Data
public class Account {
    private Integer id;
    private String name;
    private String pwd;
}

创建 Dao层                        接口 com.liuboss.dao.       AccountDao

package com.liuboss.dao;

import com.liuboss.domain.Account;

import java.util.List;

public interface AccountDao {
    void save(Account account);
    void delete(Integer id);
    void update(Account account);
    List<Account> findAll();
    Account findById(Integer id);
}

----创建service层   接口 com.liuboss.service.      AccountService 

package com.liuboss.service;

import com.liuboss.domain.Account;

import java.util.List;

public interface AccountService {
    void save(Account id);
    void delete(Integer id);
    void update(Account account);
    List<Account> findAll();
    Account findById(Integer id);
}

---com.liuboss.service.Impl.AccountServiceImpl   实现接口

package com.liuboss.service.Impl;

import com.liuboss.dao.AccountDao;
import com.liuboss.domain.Account;
import com.liuboss.service.AccountService;

import java.util.List;

public class AccountServiceImpl implements AccountService {

    //注入Dao层的接口
    private AccountDao accountDao;

    public void setAccountDao(AccountDao accountDao) {
        this.accountDao = accountDao;
    }


    public void save(Account id) {
        
    }

    public void delete(Integer id) {

    }

    public void update(Account account) {

    }

    public List<Account> findAll() {
        return null;
    }

    public Account findById(Integer id) {
        return null;
    }
}

创建数据库实现类   实现数据库的crud   在resources文件下  创建com.liuboss.dao    AccountDao.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.liuboss.dao.AccountDao">

    <select id="findById" resultType="account" parameterType="int">
        select * from user where id=#{id};
    </select>
   <select id="findAll" resultType="account">
       select * from user;
   </select>
    <insert id="save" parameterType="account">
        insert into user(name,pwd),values (#{name},#{pwd})
    </insert>
    <delete id="delete" parameterType="int">
        delete from user where id = #{id}
    </delete>
    <update id="update" parameterType="account">
        update user set name=#{name},pwd=#{pwd} where id=#{id}
    </update>
</mapper>

创建数据库配置文件 jdbc.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC
jdbc.username=root
jdbc.password=123456

数据库核心配置文件

<?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">
<!--mybatis核心配置文件-->
<configuration>
    <typeAliases>
        <typeAlias type="com.liuboss.domain.Account" alias="account"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url"
                          value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=utf8&amp;serverTimezone=UTC"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <package name="com.liuboss.dao"/>
    </mappers>
</configuration>

在spring配置文件中进行配置  空文件

<?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:p="http://www.springframework.org/schema/p"
       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
       http://www.springframework.org/schema/context/spring-context.xsd">


</beans>