java 티베로 연결

java 티베로 연결 예제

import java.io.IOException;
import java.io.InputStream;
import java.net.HttpURLConnection;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TiberoTest{
	private String ip = "ip주소";
    private int port = 포트번호;
    private String database = "데이터베이스";
    private String user = "계정";
    private String password = "비밀번호";

    private final String DRIVER_NAME = "com.tmax.tibero.jdbc.TbDriver";
    private final String TIBERO_JDBC_URL = "jdbc:tibero:thin:@" + ip + ":" + port + ":" + database;

    private Connection conn = null;

    private void connect() {
        try {
        Class.forName(DRIVER_NAME);
            conn = DriverManager.getConnection(TIBERO_JDBC_URL, user, password);
        } catch(ClassNotFoundException e) {
            System.err.println(e);
        } catch(SQLException e) {
            System.err.println(e);
        }
    }

    private void executeQuery() {
        String sql = "select * from testTable";
        try {
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            
            while(rs.next()) {
                System.out.println(rs.getString(1));
            }
        } catch(SQLException e) {
            System.err.println(e);
        }
    }
    
    private void disconnect() {
        if(conn != null) {
            try {
                conn.close();
            } catch(SQLException e) {
                System.err.println(e);
            }
        }
    }
    
	public static void main(String[] args) {
		TiberoTest tibero = new TiberoTest();

        tibero.connect();
        tibero.executeQuery();
        tibero.disconnect();
	}
}