@Configuration

@ComponentScan("com.spring.annotation.jdbc")

@EnableTransactionManagement

public class JDBConfig {

    @Bean

    public PlatformTransactionManager transactionManager(DataSource dataSource){

        return new DataSourceTransactionManager(dataSource);

    }

    @Bean

    public DataSource dataSource() throws Exception{

        ComboPooledDataSource dataSource = new ComboPooledDataSource();

        dataSource.setUser("root");

        dataSource.setPassword("MyPass@123");

        dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/spring?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false");

        dataSource.setDriverClass("com.mysql.cj.jdbc.Driver");

        dataSource.setMaxPoolSize(10);

        dataSource.setInitialPoolSize(20);

        System.out.println(dataSource);

        return dataSource;

    }

    @Bean

    public JdbcTemplate jdbcTemplate(DataSource dataSource){

        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

        return jdbcTemplate;

    }

}

@Service

public class OrgService {

    @Autowired

    private OrgDao orgDao;

    @Transactional

    public int insertOrg(String orgcode, String orgname, String areacode){

        return orgDao.insert(orgcode,orgname,areacode);

    }

}