springboot 创建非web项目及数据源简单使用
项目组马上要使用springboot来重构程序,首先要对几个比较小的非web项目重构,所以新手入门,简单做了个小例子
代码结构如下:
dao层
package com.mysping.myboot001.dao.impl; import java.util.List; import java.util.Map; import javax.annotation.Resource; import javax.sql.DataSource; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Repository; import com.mysping.myboot001.dao.UserDao; @Repository public class UserDaoImpl implements UserDao{ @Resource private JdbcTemplate jdbcTemplate; @Override public List<Map<String, Object>> queryForList() throws Exception { String sql = "select * from springboot.sys_user"; return this.jdbcTemplate.queryForList(sql); } @Override public DataSource getDataSource() { return this.jdbcTemplate.getDataSource(); } }
service层
package com.mysping.myboot001.service.impl; import java.util.List; import java.util.Map; import javax.annotation.Resource; import org.springframework.stereotype.Service; import com.mysping.myboot001.dao.UserDao; import com.mysping.myboot001.service.UserService; import com.zaxxer.hikari.HikariDataSource; @Service public class UserServiceImpl implements UserService{ @Resource private UserDao userDao; @Override public List<Map<String, Object>> queryForUserList() throws Exception { return userDao.queryForList(); } @Override public HikariDataSource getHikariCpDataSource() { return (HikariDataSource) userDao.getDataSource(); } }