Java9 + Spring5 + Gradle + Hibernate 개발환경 만들기

package com.chaedae.db.config; 

import javax.sql.DataSource; 
import org.springframework.beans.factory.annotation.Autowired; 
import org.springframework.context.annotation.Bean; 
import org.springframework.context.annotation.Configuration; 
import org.springframework.context.annotation.Primary; 
import org.springframework.context.annotation.PropertySource; 
import org.springframework.core.env.Environment; 
import com.zaxxer.hikari.HikariConfig; 
import com.zaxxer.hikari.HikariDataSource; 

/** 
 * <h1>Datasource Configuration</h1> 
 * old : root-context.xml > dataSource 
 * @author ChaeDae 
 */ 
@Configuration 
@PropertySource("classpath:config/props/db.properties") 
public class DataSourceConfig { 
    
    @Autowired private Environment env; 
    
    @Primary 
    @Bean 
    public DataSource dataSource() { 
        HikariConfig config = new HikariConfig(); 
        // Set Database Info 
        config.setDriverClassName(env.getProperty("jdbc.driverClassName")); 
        config.setJdbcUrl(env.getProperty("jdbc.url")); 
        config.setUsername(env.getProperty("jdbc.user")); 
        config.setPassword(env.getProperty("jdbc.passwd")); 

        // Set HikariCP Configuration 
        config.setConnectionTimeout(Integer.parseInt(env.getProperty("hikaricp.connection_timeout"))); 
        config.setMinimumIdle(Integer.parseInt(env.getProperty("hikaricp.minimum_idle"))); 
        config.setMaximumPoolSize(Integer.parseInt(env.getProperty("hikaricp.maximum_pool_size"))); 
        config.setIdleTimeout(Integer.parseInt(env.getProperty("hikaricp.idle_timeout"))); 
        
        return new HikariDataSource(config); 
    } 
}

package com.chaedae.db.config; 

import java.util.Properties; 
import org.springframework.beans.factory.annotation.Autowired; 
import org.springframework.context.ApplicationContext; 
import org.springframework.context.annotation.Bean; 
import org.springframework.context.annotation.ComponentScan; 
import org.springframework.context.annotation.Configuration; 
import org.springframework.orm.hibernate5.HibernateTransactionManager; 
import org.springframework.orm.hibernate5.LocalSessionFactoryBean; 
import org.springframework.transaction.annotation.EnableTransactionManagement; 

@Configuration 
@EnableTransactionManagement 
@ComponentScan(basePackages = { "com.chaedae" }) 
public class HibernateConfig { 
    
    @Autowired private ApplicationContext applicationContext; 
    
    @Autowired private DataSourceConfig dataSourceConfig; 
    
    @Bean 
    public LocalSessionFactoryBean getSessionFactory() throws Exception { 
        LocalSessionFactoryBean factoryBean = new LocalSessionFactoryBean(); 
        factoryBean.setDataSource(dataSourceConfig.dataSource()); 
        factoryBean.setPackagesToScan(new String[] {"com.chaedae.model"}); 
        
        Properties props = new Properties(); 
        props.load(applicationContext.getResource("classpath:/config/props/hibernate.properties").getInputStream()); 
        factoryBean.setHibernateProperties(props); 
        
        return factoryBean; 
    } 
    
    @Bean public HibernateTransactionManager getTransactionManager() throws Exception { 
        HibernateTransactionManager transactionManager = new HibernateTransactionManager(); 
        transactionManager.setSessionFactory(getSessionFactory().getObject()); 
        
        return transactionManager; 
    } 
}

@Override protected Class<?>[] getRootConfigClasses() { 
    return new Class[] { 
        HibernateConfig.class
    }; 
}

/** 
 * Default Database Schema & data 
 * @return 
 */ 
@Bean public DataSourceInitializer dataSourceInitializer() { 
    ResourceDatabasePopulator resourceDatabasePopulator = new ResourceDatabasePopulator(); 
    resourceDatabasePopulator.addScript(new ClassPathResource("/config/sql/H2DB-schema.sql")); 
    resourceDatabasePopulator.addScript(new ClassPathResource("/config/sql/H2DB-data.sql")); 
    
    DataSourceInitializer dataSourceInitializer = new DataSourceInitializer(); 
    dataSourceInitializer.setDataSource(dataSource()); 
    dataSourceInitializer.setDatabasePopulator(resourceDatabasePopulator); 
    
    return dataSourceInitializer; 
}

package com.chaedae.model; 

import java.io.Serializable; 
import java.util.Date; 
import javax.persistence.Entity; 
import javax.persistence.Id; 
import javax.persistence.Table; 

@SuppressWarnings("serial") 
@Entity(name = "TB_USER") 
@Table(name = "TB_USER") 
public class User implements Serializable { 
    
    @Id 
    String userId; 
    String pwd; 
    String userNm; 
    String hpNo; 
    String email; 
    Date regDt; 
    String regId; 
    
    Getter / Setter

}

package com.chaedae.service; 

import java.util.List; 
import org.springframework.beans.factory.annotation.Autowired; 
import org.springframework.stereotype.Service; 
import com.chaedae.dao.UserDAO; 
import com.chaedae.model.User; 

@Service public class UserService { 
    @Autowired 
    private UserDAO userDAO; 
    
    public User selectByUserId(User vo) { 
        return userDAO.selectByUserId(vo); 
    } 
    
    public List<User> selectList(User vo) { 
        return userDAO.selectList(vo); 
    } 
}

package com.chaedae.dao; 

import java.util.List; 
import org.hibernate.SessionFactory; 
import org.springframework.beans.factory.annotation.Autowired; 
import org.springframework.stereotype.Repository; 
import org.springframework.transaction.annotation.Transactional; 
import com.chaedae.model.User; 

@Repository public class UserDAO { 
    @Autowired 
    private SessionFactory sessionFactory; 
    
    @Transactional 
    public User selectByUserId(User vo) { 
        return this.sessionFactory.getCurrentSession().get(User.class, vo.getUserId()); 
    } 
    
    @SuppressWarnings("unchecked") 
    @Transactional 
    public List<User> selectList(User vo) { 
        return this.sessionFactory.getCurrentSession().createQuery("FROM TB_USER").list(); 
    } 
}

package com.chaedae.welcome; 

import java.text.SimpleDateFormat; 
import java.util.Date; 
import java.util.Locale; 
import org.springframework.beans.factory.annotation.Autowired; 
import org.springframework.stereotype.Controller; 
import org.springframework.ui.Model; 
import org.springframework.web.bind.annotation.GetMapping; 
import com.chaedae.model.User; 
import com.chaedae.service.UserService; 

@Controller 
public class WelcomeController { 
    @Autowired 
    private UserService userService; 
    
    @GetMapping("/") 
    public String welcome(Locale locale, Model model) { 
        Date date = new Date(); 
        String simpleDate = new SimpleDateFormat("YYYY년 MM월 dd일 HH:mm:ss").format(date); 
        model.addAttribute("time", simpleDate); 
        
        User user = new User(); 
        user.setUserId("master"); 
        model.addAttribute("user", this.userService.selectByUserId(user)); 
        model.addAttribute("userList", this.userService.selectList(user)); 
        
        return "welcome"; 
    } 
}