1.创建配置文件

配置文件：jdbc.proerties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/nevpb
jdbc.we=root
jdbc.password=1111111

2.创建spring容器管理：

config类（管理配置文件，连接数据库对象spring类）

@Value("${jdbc.driver}")
public String driver;
相当于 在一个bean中增加了一个属性：
<property name="jdbc.driver" value="${jdbc.driver}"></property>
然后把值给到下面定义的变量driver

@Bean  //创建了bean对象：对象名称是dataSource，之后可以导入管理spring中然后使用

    public DataSource dataSource(){

    DruidDataSource ds=new DruidDataSource();
    ds.setDriverClassName(driver);
    ds.setUrl(url);
    ds.setUsername(we);
    ds.setPassword(password);
    return ds;
}

package config;

import com.alibaba.druid.pool.DruidDataSource;
import impl.CER;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;

import javax.sql.DataSource;

public class jdbcConfig {

@Value("${jdbc.driver}")
public String driver;

@Value("${jdbc.url}")
public String url;
@Value("${jdbc.we}")
public String we;
@Value("${jdbc.password}")
public String password;

@Bean

    public DataSource dataSource(){

    DruidDataSource ds=new DruidDataSource();
    ds.setDriverClassName(driver);
    ds.setUrl(url);
    ds.setUsername(we);
    ds.setPassword(password);
    return ds;
}
  

 
}

MybatisConfig类（管理manper代理，mybaits）spring类

sqlSessionFactoryBean对象：传入是连接池对象：封装好的
创建这个才能使用mybatis的里面的编辑sql语句。

  @Select("select * from account where id=2")
    Account findBtId(Integer id);

mapperScannerConfigurer对象：创建mapper代理
用来管理

Account ac= accoutService.findByld(2);

package config;

import org.apache.ibatis.annotations.Mapper;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.mapper.MapperScannerConfigurer;
import org.springframework.context.annotation.Bean;

import javax.sql.DataSource;


public class MybatisConfig {



@Bean

    public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource){


SqlSessionFactoryBean ssfb=new SqlSessionFactoryBean();

ssfb.setDataSource(dataSource);
return ssfb;

}


@Bean
        public MapperScannerConfigurer mapperScannerConfigurer(){

    MapperScannerConfigurer msc=new MapperScannerConfigurer();
    msc.setBasePackage("dao");

    return msc;


}





}

springconfig类（spring容器类）把所有bean放到这里

package config;


import impl.AccoutService;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Import;
import org.springframework.context.annotation.PropertySource;
import org.springframework.stereotype.Component;

@Configuration
@ComponentScan("dao")
@ComponentScan("impl")
@PropertySource({"classpath:jdbc.properties"})//这里有问题
@Import({jdbcConfig.class,MybatisConfig.class})


public class springconfig {




}

余下的代码

3.数据接口（sql语句）

package dao;

import impl.Account;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

public interface AccountDao {


    
    @Insert("insert into accout(name,money)values(#{name},#{money})")
    void save(Account account);


    @Select("select * from account where id=2")
    Account findBtId(Integer id);


}

Account类：

package impl;

public class Account {


   public   Integer id;
    public String name;
    public Double money;
//这个表的数据层
    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Double getMoney() {
        return money;
    }

    public void setMoney(Double money) {
        this.money = money;
    }

    @Override
    public String toString() {
        return "Account{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", money=" + money +
                '}';
    }
}

AccountServiceImpl类

package impl;

import dao.AccountDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service("AccountService")
public class AccountServiceImpl implements AccoutService {


    @Autowired
    public AccountDao accountDao;

    public void save(Account account){accountDao.save(account);}

    public Account findByld(Integer id){


        return accountDao.findBtId(id);
    }


   // public void update(Account account){accountDao.update(account);}
//    public void save(Account account){accountDao.save(account);}
//    public void save(Account account){accountDao.save(account);}
//    public void save(Account account){accountDao.save(account);}
//    public void save(Account account){accountDao.save(account);}
//

public void we(){
    System.out.println("AccountServiceimpl这个生效");
}





}

AccoutService接口

package impl;

public interface AccoutService {



    public void save(Account account);

    public Account findByld(Integer id);


}

执行代码（测试）

import dao.AccountDao;
import impl.Account;
import impl.AccoutService;
import impl.CER;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.AnnotationConfigApplicationContext;

import config.springconfig;

import javax.sql.DataSource;


public class app2 {




    public static void main(String[] args) {



        ApplicationContext ctx=new AnnotationConfigApplicationContext(springconfig.class);
        //1.注解扫描



 AccoutService accoutService= (AccoutService) ctx.getBean("AccountService");

//Account ac=accoutService.findByld(2);
//        System.out.println(ac);


   //     CER cer= (CER) ctx.getBean("wer");
      //  System.out.println(cer.drive);

      Account ac= accoutService.findByld(2);
       System.out.println(ac);

    }

    

}