자바 DB 연동 - SELECT 문 실행시키는 소스

import java.io.BufferedReader;

import java.io.InputStreamReader;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.Statement;

import com.util.DBConn;

public class Test1 {

public static void main(String[] args) {

BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

Statement stmt = null;

Connection conn = DBConn.getConnection();

ResultSet rs = null;

ResultSetMetaData rsmd = null;

try {

String sql;

int cols;

System.out.print("쿼리 ?");

sql = br.readLine();

stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

rsmd = rs.getMetaData();

cols = rsmd.getColumnCount();

System.out.print("\n\t");

for (int i = 1; i <= cols; i++) {

System.out.print(rsmd.getColumnName(i) + "\t");

}

System.out.println();

System.out.print("\t");

while (rs.next()) {

for (int i = 1; i <= cols; i++) {

System.out.print(rs.getString(i) + "\t");

}

System.out.println();

rs.close();

stmt.close();

DBConn.close();

}

} catch (Exception ex) {

}

}

}