完整塔建一个spring 注解版 mybaties 过程可供复制代码

第一步引导包。新建工程maven模块 pom.xml 中导入相对应包

++++++++++++++++++++++++++++++++++++++++++++       1      ++++++++++++++++++++++++++++++++++++++++++++++

  <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.32</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.16</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.7</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.2.10.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.0</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.3.20</version>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.4</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>5.3.20</version>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.1.9.RELEASE</version>
        </dependency>
    </dependencies>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++   2    ++++++++++++++++++++
新建配置文件  com.it.config包：分别建用于jdbcConfig  mybatisConfig  SpringConfig
其中jdbConfigs配置包内容如下：由于用到了第三方配置包，properties 文件内等会讲  本包由主包import 导入，

package com.ithm.config;

import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Service;

import javax.sql.DataSource;

public class jdbcConfig {
   @Value("${jdbc.driver}")
   private String driver;
    @Value("${jdbc.url}")
    private String url;
    @Value("${jdbc.username}")
    private String username;
    @Value("${jdbc.password}")
    private String password;

    @Bean
    public DataSource dataSource(){
        DruidDataSource ds = new DruidDataSource();
        ds.setDriverClassName(driver);
        ds.setUrl(url);
        ds.setUsername(username);
        ds.setPassword(password);
        return ds;

    }

}
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++4++++++++++++++++++++++++++

MYbatisConfig 内容如下：本包由主包ippor导入,但组件需要加@bean

package com.ithm.config;
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.setTypeAliasesPackage("com.ithm.domain");  //申明那些包是pojo 的数据类型

package com.ithm.dommin;

public class Account {
    private Integer id;
    private String name;
    private  String   money;

    public Account() {
    }


    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 String getMoney() {
        return money;
    }

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

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

 

        ssfb.setDataSource(dataSource);
        return ssfb;
    }
    @Bean
    //映射扫描
    public MapperScannerConfigurer mapperScannerConfigurer(){
        MapperScannerConfigurer msc = new MapperScannerConfigurer();
        msc.setBasePackage("com.ithm.dao"); // 申明那些包是代理接口，就是写好数据库查询方法

package com.ithm.dao;

import com.ithm.dommin.Account;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;


import java.util.List;


public interface AccountDao {

    @Insert("insert info money (name,money)values(#{name},#{money})")
   // @Insert("insert info money (name,money)values(#{name},#{money})")
    void save(Account account);
    @Delete("delete from money where id = #{id}")
    void  delect(Integer id);
    @Update("update money set name = #{name},money = #{money} where id = #{id}")

    void update(Account account);
    @Select("select * from money")
    List<Account> findAll();
    //
    @Select("select * from money where id =2")
    Account findById(Integer id);
}

 

        return msc;
    }


}
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++5+++++++++++++++++++++++++++++++++++++++
主包内容

package com.ithm.config;

import org.mybatis.spring.batch.MyBatisBatchItemWriter;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Import;
import org.springframework.context.annotation.PropertySource;

@Configuration    //申明这是一个配置类
@ComponentScan("com.ithm")   // 扫描那些包有spring的组件容器
@PropertySource("classpath:jdbc.properties")   //外部读入propeties
@Import({jdbcConfig.class, mybatisConfig.class})  //加载导入配置包
public class SpringConfig {
}

++++++++++++++++++++++++++++++++++++++++++++++++++6++++++++++++++++++++
resources配置文件下，jdbc.properties内容 

jdbc.driver = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/xsytest
jdbc.username = root
jdbc.password = 142857
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++7+++++++++++++++++++++++++++++
其余就是无关重要的服务层和怎么入口测试了
服务层代码如下：

package com.ithm.server.ipml;

import com.ithm.dao.AccountDao;
import com.ithm.dommin.Account;
import com.ithm.server.AccountServive;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class AccountServiceimpl implements AccountServive {
    @Autowired
    private AccountDao accountDao;
    public void save(Account account) {
        accountDao.save(account);
    }
    public void update(Account account) {
        accountDao.update(account);
    }
    public void delete(Integer id) {
        accountDao.delect(id);
    }

    public Account findById(Integer id) {
        return accountDao.findById(id);
    }
    public List<Account> finAll() {
        return accountDao.findAll();
    }

}
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++=忘了发接口+++++++++++++++++++++++++++++

package com.ithm.server;

import com.ithm.dommin.Account;

import java.util.List;

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

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++正常测试方法++++++++++++++++++++++

import com.ithm.config.SpringConfig;
import com.ithm.dommin.Account;
import com.ithm.server.AccountServive;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.AnnotationConfigApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import javax.sql.DataSource;

public class App {
    public static void main(String[] args) {
        AnnotationConfigApplicationContext ctx = new AnnotationConfigApplicationContext(SpringConfig.class);
        AccountServive accountServive = ctx.getBean(AccountServive.class);
        Account byId = accountServive.findById(2);
        System.out.println(byId);
    }   
  
}
+++++++++++++++++++++++++++++++++++++++++++++++junit测试方法+++++++++++++++++++++++++++++++++++++++++++++++++++++

package com.ithm.service;

import com.ithm.config.SpringConfig;
import com.ithm.dommin.Account;
import com.ithm.server.AccountServive;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import javax.sql.DataSource;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(classes = {SpringConfig.class})
public class AccountSer {
    @Autowired
    private AccountServive accountServive;
    @Test
    public void testFindByid(){
       Account b = accountServive.findById(2);
        System.out.println(b);
    }
}
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++==2022-4月写的案例，删文件之前备份++++++++++++++++++++++++++++++