Dev environment :
maven 3.54 、mysql 8、jdk 1.8 、 springboot 2.0
项目 DEMO 如下:
https://github.com/medoo-Ai/springbootMYSQL
1、创建maven项目,引入依赖,配置yml 配置文件
2、 监听数据库连接池的类型,在 database 包下
@Component
public class DataSourceShow implements ApplicationContextAware {
ApplicationContext applicationContext = null;
// Spring 容器会自动调用这个方法,注入 Spring IoC 容器
@Override
public void setApplicationContext(ApplicationContext applicationContext)
throws BeansException {
this.applicationContext = applicationContext;
DataSource dataSource = applicationContext.getBean(DataSource.class);
System.out.println(dataSource.getClass().getName());
}
}
2、依据table 创建 pojo ,引入 lombok ,并对其方访问
可引入逆向工程生成
https://blog.csdn.net/weixin_42323802/article/details/83050762
lombok 可参考
https://blog.csdn.net/weixin_42323802/article/details/84547988
@Getter
@Setter
@TosString
public class User {
private Long id = null;
private String userName = null;
<strong>private SexEnum sex = null;// 枚举</strong>
private String note = null;
}
3、 创建枚举,对数据库进行操作,可引入事务进行测试
2019.03.28 23:17 刚下班 ,洗了澡没吃饭就这个点了
@Service
public class UsserServiceImpl implements UserService {
@Autowired
private JdbcTemplate jdbcTemplate;
// 集
private RowMapper<User> getRowMapper(){
RowMapper<User> userRowMapper=(ResultSet rs,int row)->{
User user = new User();
user.setId(rs.getLong("id"));
user.setAge(rs.getInt("age"));
user.setName(rs.getString("name"));
user.setSexEnum(SexEnum.getEnumById(rs.getInt("sex")));
return user