Java获取数据库表的字段及类型

public static Map getmap(String synonymsName（表名）) {

Map map = new HashMap();

Connection ct = null;

Statement sm = null;

ResultSet rs = null;

try {

// 加载驱动

Class.forName("oracle.jdbc.driver.OracleDriver")

;

// 得到连接

ct = DriverManager.getConnection(

"jdbc:oracle:thin:@192.168.1.4:1521:orcl",

"dgh_tj",

"dgh_tj");

sm = ct.createStatement();

String sql = "select * from " + synonymsName + " where 1!=1";

rs = sm.executeQuery(sql);

ResultSetMetaData md = rs.getMetaData();

for(int i = 1; i <= md.getColumnCount(); i++) {

map.put(md.getColumnName(i),

md.getColumnTypeName(i));

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

rs.close();

sm.close();

ct.close();

} catch (Exception e) {

e.printStackTrace();

}

}

return map;

}