Spring整合Mybatis

Mybatis

• 首先会在数据库创建一个表，比如username：张三；sex：男；age：39
• 然后在idea中创建一个类写username，sex，age属性，以及相应的get/set方法等等
• 接着定义一个接口来写相关的sql语句
• 在主程序中写获取数据库的代码

  //1．创建SqLSessionFactoryBuiLder对象
  sqlSessionFactoryBuilder sq1SessionFactoryBuilder = new SqlSessionFactoryBuilder();
  // 2．加载SqLMapconfig.xmL配置文件
  Inputstream inputstream = Resources.getResourceAsStream("sqlMapConfig.xml");
  //3．创建SqLSessionFactory对象
  sqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);
  //4．获取SqLSession
  sqlsession sqlsession = sqlsessionFactory.opensession( ) ;
  //5．执行SqlSession对象执行查询，获取结果User
  AccountDao accountDao = sqlsession.getMapper(AccountDao.class);
  

• Mapper，和Mysql设置 

 

 

---

---

第一步 导入坐标

<dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>5.2.10.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.16</version>
    </dependency>
<dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.46</version>
    </dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</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.3</version>
</dependency>

第二步 定义一个Spring和jdbc的配置类

​​​​@Configuration
@ComponentScan( "com.itheima")
@PropertySource("classpath:jdbc.properties")
@Import(dbcconfig.class,Mybatisconfig.class})
public class springConfig {
}

 第三步 写一个类配置Mybatis

public class Mybatisconfig {
@Bean
public SqlSessionFactoryBean SqlSessionFactory(DataSource dataSource){
SqlSessionFactoryBean ssfb = new SqlSessionFactoryBean();
ssfb.setTypeAliasesPackage( " com.itheima. domain" );
ssfb.setDataSource( dataSource);
return ssfb;
}
@bean
public MapperScannerConfigurer mapperScannerConfigurer(){
MapperScannerConfigurer msc = new MapperScannerConfigurer();
msc.setBasePackageb;
return msc;
   }
}

 第四步 main方法中操作一下

public class App2 {
public static void main(string[] args) {
ApplicationContext ctx = new AnnotationConfigApplicationContext(SpringConfig.class);
AccountService accountService = ctx.getBean(AccountService.class);
Account ac = accountservice.findById(2);
system.out.print1n(ac);
   }
}