SpringBoot学习笔记四：springBoot整合Mybatis实现连接mysql数据库

一、在application.peroperties文件中加入数据和mybatis的配置；

#数据库链接配置
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/admin?useUnicode=true&serverTimezone=Asia/Shanghai&characterEncoding=utf8&autoReconnect=true&useSSL=false&allowMultiQueries=true&allowPublicKeyRetrieval=true
spring.datasource.username=root
spring.datasource.password=123456

#mybatis配置(*Mapper.xml:表示所有的以Mapper结尾的xml文件)
mybatis.mapper-locations=classpath:mapper
	 AdminUser getoneByPrk(Integer prk);

}

package com.springboot.business.service.impl;

import javax.annotation.Resource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.springboot.business.mapper.AdminUserMapper;
import com.springboot.business.model.AdminUser;
import com.springboot.business.service.AdminUserService;

@Service
public class AdminUserServiceImpl implements AdminUserService{

	@Autowired
	private AdminUserMapper adminUserMapper;
	@Override
	public AdminUser getoneByPrk(Integer prk) {
		
		return adminUserMapper.selectByPrimaryKey(prk);
	}

}

五、启动程序，运行查看结果；

package com.springboot.business;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;


//加入扫描 依赖，就不需要在每个mapper中加入注解@Mapper
@MapperScan("com.springboot.business.mapper")
@SpringBootApplication
public class Application {

	public static void main(String[] args) {
		SpringApplication.run(Application.class, args);
	}

}