jdbc 获取数据库列名,列类型

package org.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

public class TestOracle {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String url = "jdbc:oracle:thin:@localhost:1521:ora";
			String uname = "scott";
			String pssw = "tiger";
			Connection cn = DriverManager.getConnection(url,uname,pssw);
			
			PreparedStatement ps = cn.prepareStatement("select * from emp where sal>?");
			ps.setObject(1, 300);
			ResultSet rs = ps.executeQuery();
		
			ResultSetMetaData rsmd = rs.getMetaData();
			//获取当前表共有多少列
			int tableLength = rsmd.getColumnCount();
			for(int i=1 ;i<tableLength ;i++){
				//获取数据库类型
				String rolumnDbClass = rsmd.getColumnTypeName(i);
				System.out.println("数据库设置的列类型:"+rolumnDbClass);
				
				//获取数据库类型与java相对于的类型
				String rolumnClass = rsmd.getColumnClassName(i);
				System.out.println("java对应:"+rolumnClass);
				
				//获取列名
				String columnName = rsmd.getColumnName(i);
				System.out.println("获取列名:"+columnName);
				
				
			}
			
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}

}