Spring整合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设置 

      org.springframework
      spring-context
      5.2.10.RELEASE
    
    
      com.alibaba
      druid
      1.1.16
    

      mysql
      mysql-connector-java
      5.1.46
    

org.mybatis
mybatis
3.5.6


org.springframework
spring-jdbc
5.2.10.RELEASE


org.mybatis
mybatis-spring
1.3.3

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

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;
   }
}

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);
   }
}