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;
}
