/**
* 读取列名;
* @return void [返回类型说明]
* @exception throws [违例类型] [违例说明]
* @see [类、类#方法、类#成员]
*/
public List<String> getColumnNames()
{
List<String> columnList = new ArrayList<String>();
try
{
// Class.forName("oracle.jdbc.driver.OracleDriver");
// Connection conn = DriverManager.getConnection(
// "jdbc:oracle:thin:@10.10.101.11:1521:wv247", "wven",
// "wven");
Connection conn = sqlMap.getDataSource().getConnection();
conn.setAutoCommit(true);
String sql = "select * from t_user_attribute where rownum = 0";
logger.debug(sql);
PreparedStatement stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
for (int i = 1; i <= columnCount; i++)
{
System.out.println(rsmd.getColumnName(i).toLowerCase());
columnList.add(rsmd.getColumnName(i).toLowerCase());
}
rs.close();
rs = null;
stmt.close();
stmt = null;
}
catch (Exception e)
{
// System.out.println("other exception happens!");
// System.out.println(e.getMessage());
logger.error("TaskDao.getColumnNames() error!", e);
}
return columnList;
}
ibatis中取列名,呵呵
最新推荐文章于 2018-11-11 08:06:02 发布