임시 참조 - DB Connection

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package kr.org.kisti.morph;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

/**
 *
 * @author hwang
 */
public class DBConnection {
    public DBConnection() {
        dbconn = null;
        stmt = null;
        rs = null;
        dburl = "jdbc:oracle:thin:@localhost:1521:XE";
        dbuser = "hr";
        dbpass = "";

        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        }
        catch(Exception exception)
        {
            System.out.println(exception);
        }

        try
        {
            dbconn = DriverManager.getConnection(dburl, dbuser, dbpass);
        }
        catch(SQLException sqlexception)
        {
            System.out.println(sqlexception);
        }
    }

    public Connection getConnection() {
        return dbconn;
    }

    public List<String> ExcuteQuery(String query) {
        List<String> result = new ArrayList<String>();         //Size problem
        try {
            stmt = dbconn.createStatement();
            rs = stmt.executeQuery(query);

            while (rs.next()) {
                result.add(rs.getString("paper_nm"));
            }
            rs.close();
            stmt.close();
        } catch (SQLException e) {
            System.out.println(e);
        }
        return result;
    }

    public void close(){
        if(dbconn != null) {
            try {
                dbconn.close();
            } catch (SQLException e) {
                System.out.println(e);
            }
        }
    }

    Connection dbconn;
    Statement stmt;
    ResultSet rs;
    String dburl;
    String dbuser;
    String dbpass;
}