Oracle SQL과 Eclipse 연결
1. 연동 public class MyBatisContext { public static SqlSession getSqlSession() { try { // DB접속용 dataSource객체 생성 BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName(“oracle.jdbc.driver.OracleDriver”); dataSource.setUrl(“jdbc:oracle:thin:@서버주소:포트번호:SID”); dataSource.setUsername(“DB아이디”); dataSource.setPassword(“DB비밀번호”); TransactionFactory transactionFactory = new JdbcTransactionFactory(); Environment environment = new Environment(“development”, transactionFactory, dataSource); Configuration config = new Configuration(environment); //만든 mapper등록 config.addMapper(mapper클래스명.class); SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(config); return factory.openSession(true); //true면 자동으로 … Read more