获取表的字段

方法一：通过connection来获得

Java代码

1. private String getIdName(Connection conn,String tableName){ 
2.     String idName = ""; 
3.     DatabaseMetaData  metaData = null; 
4.     try { 
5.          metaData = conn.getMetaData(); 
6.          ResultSet rs = metaData.getColumns(conn.getCatalog(), "%", tableName, "%ID"); 
7.          if(rs.next()){ 
8.              idName = rs.getString("COLUMN_NAME");  
9.          } 
10.     } catch (Exception e) { 
11.         logger.error(e); 
12.     } 
13.     return idName; 
14. } 

	private String getIdName(Connection conn,String tableName){
		String idName = "";
		DatabaseMetaData  metaData = null;
		try {
			 metaData = conn.getMetaData();
			 ResultSet rs = metaData.getColumns(conn.getCatalog(), "%", tableName, "%ID");
			 if(rs.next()){
				 idName = rs.getString("COLUMN_NAME"); 
			 }
		} catch (Exception e) {
			logger.error(e);
		}
		return idName;
	}

方法二：通过结果集ResultSet获得

Java代码

1. private String getIdName(ResultSet rs){ 
2.     String idName = ""; 
3.     ResultSetMetaData metaData = null; 
4.     try { 
5.          metaData = rs.getMetaData(); 
6.          idName = metaData.getColumnName(1); 
7.     } catch (Exception e) { 
8.         logger.error("查询表的主键名出错！ ",e); 
9.     } 
10.     return idName; 
11. }