자바 DB 연동 - 컬럼명과 타입명,폭을 확인하는 소스

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.Statement;

import com.util.DBConn;

public class Test2 {

public static void main(String[] args) {

Connection conn=DBConn.getConnection();

Statement stmt=null;

ResultSet rs=null;

ResultSetMetaData rsmd=null;

String sql;

try {

sql="SELECT * FROM score";

stmt=conn.createStatement();

rs=stmt.executeQuery(sql);

rsmd=rs.getMetaData();

int cols=rsmd.getColumnCount();

System.out.println("컬럼명\t타입\t타입명\t폭");

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

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

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

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

System.out.print(rsmd.getPrecision(i)+"\n");

}

}catch (Exception e){

System.out.println(e.toString());

}

}

}