private List<Map<String,String>> getColumnsBySQL(String sql) throws SQLException {
List<Map<String,String>> columns = new ArrayList<Map<String,String>>();
Connection con = sqlSessionTemplate.getSqlSessionFactory().openSession().getConnection();//.getConnection();
Statement stmt = null;
ResultSet rs = null;
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
ResultSetMetaData rsMetaData = rs.getMetaData();
int columnCount = rsMetaData.getColumnCount();
for (int i = 1; i <= columnCount; i++)
{
Map<String,String> column = new HashMap<String,String>();
// System.out.println("getCatalogName:"+rsMetaData.getCatalogName(i));
// System.out.println("getColumnClassName:"+rsMetaData.getColumnClassName(i));
// System.out.println("getColumnLabel:"+rsMetaData.getColumnLabel(i));
// System.out.println("getColumnName:"+rsMetaData.getColumnName(i));
// System.out.println("getSchemaName:"+rsMetaData.getSchemaName(i));
// System.out.println("getTableName:"+rsMetaData.getTableName(i));
// column.put("RESOURCE_ID", "");
// column.put("TABLE_NAME", rsMetaData.getTableName(i));
// String ColumnType = rsMetaData.getColumnTypeName(i);
// column.put("FILED_NAME", rsMetaData.getColumnName(i));
column.put("FILED_DESC", rsMetaData.getColumnLabel(i));
// column.put("CODE_TABLE", "");
// column.put("FILED_TYPE", convertFiledType(ColumnType,""));
// column.put("DISPLAY", "1");
// column.put("REQUIRED", "0");
// column.put("CREAT_TIME", "");
// column.put("ORDER_XH", ""+i);
// column.put("FILED_ISKEY", "0");
// column.put("DATALENGTH", "0");
// column.put("DATASCALE", "0");
columns.add(column);
}
rs.close();
stmt.close();
con.close();
// session.close();
return columns;
List<Map<String,String>> columns = new ArrayList<Map<String,String>>();
Connection con = sqlSessionTemplate.getSqlSessionFactory().openSession().getConnection();//.getConnection();
Statement stmt = null;
ResultSet rs = null;
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
ResultSetMetaData rsMetaData = rs.getMetaData();
int columnCount = rsMetaData.getColumnCount();
for (int i = 1; i <= columnCount; i++)
{
Map<String,String> column = new HashMap<String,String>();
// System.out.println("getCatalogName:"+rsMetaData.getCatalogName(i));
// System.out.println("getColumnClassName:"+rsMetaData.getColumnClassName(i));
// System.out.println("getColumnLabel:"+rsMetaData.getColumnLabel(i));
// System.out.println("getColumnName:"+rsMetaData.getColumnName(i));
// System.out.println("getSchemaName:"+rsMetaData.getSchemaName(i));
// System.out.println("getTableName:"+rsMetaData.getTableName(i));
// column.put("RESOURCE_ID", "");
// column.put("TABLE_NAME", rsMetaData.getTableName(i));
// String ColumnType = rsMetaData.getColumnTypeName(i);
// column.put("FILED_NAME", rsMetaData.getColumnName(i));
column.put("FILED_DESC", rsMetaData.getColumnLabel(i));
// column.put("CODE_TABLE", "");
// column.put("FILED_TYPE", convertFiledType(ColumnType,""));
// column.put("DISPLAY", "1");
// column.put("REQUIRED", "0");
// column.put("CREAT_TIME", "");
// column.put("ORDER_XH", ""+i);
// column.put("FILED_ISKEY", "0");
// column.put("DATALENGTH", "0");
// column.put("DATASCALE", "0");
columns.add(column);
}
rs.close();
stmt.close();
con.close();
// session.close();
return columns;
}
mybatis-spring-1.2.2.jar
import java.sql.Connection;