本文整理汇总了Java中org.springframework.jdbc.support.rowset.SqlRowSetMetaData.getColumnCount方法的典型用法代码示例。如果您正苦于以下问题:Java SqlRowSetMetaData.getColumnCount方法的具体用法?Java SqlRowSetMetaData.getColumnCount怎么用?Java SqlRowSetMetaData.getColumnCount使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.springframework.jdbc.support.rowset.SqlRowSetMetaData
的用法示例。
在下文中一共展示了SqlRowSetMetaData.getColumnCount方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: dump
import org.springframework.jdbc.support.rowset.SqlRowSetMetaData; //导入方法依赖的package包/类
private static void dump(String sql) {
logger.fine("\n" + sql);
SqlRowSet rs = dao.getJdbcTemplate().queryForRowSet(sql);
try {
SqlRowSetMetaData rsmd = rs.getMetaData();
int c = rsmd.getColumnCount();
StringBuffer buff = new StringBuffer();
for (int i = 1; i <= c; i++) {
buff.append(rsmd.getColumnLabel(i));
buff.append(i == c ? "\n" : "\t");
}
logger.fine(buff.toString());
buff.delete(0, buff.length());
while (rs.next()) {
for (int i = 1; i <= c; i++) {
buff.append(rs.getObject(i));
buff.append(i == c ? "\n" : "\t");
}
logger.fine(buff.toString());
buff.delete(0, buff.length());
}
logger.fine("================\n\n");
} catch (Exception e) {
e.printStackTrace();
}
}
示例2: addHeaders
import org.springframework.jdbc.support.rowset.SqlRowSetMetaData; //导入方法依赖的package包/类
@Override
public Grid addHeaders( SqlRowSet rs )
{
SqlRowSetMetaData rsmd = rs.getMetaData();
int columnNo = rsmd.getColumnCount();
for ( int i = 1; i <= columnNo; i++ )
{
addHeader( new GridHeader( rsmd.getColumnLabel( i ), false, false ) );
}
return this;
}
示例3: addHeaders
import org.springframework.jdbc.support.rowset.SqlRowSetMetaData; //导入方法依赖的package包/类
@Override
public Grid addHeaders( SqlRowSet rs )
{
SqlRowSetMetaData rsmd = rs.getMetaData();
int columnNo = rsmd.getColumnCount();
for ( int i = 1; i <= columnNo; i++ )
{
addHeader( new GridHeader( rsmd.getColumnLabel( i ), false, false ) );
}
return this;
}
示例4: CreateEntity
import org.springframework.jdbc.support.rowset.SqlRowSetMetaData; //导入方法依赖的package包/类
public void CreateEntity(String tablename,String packagename,JdbcTemplate jdbcTemplate) throws SQLException {
_tablename=tablename;
_packagename=packagename;
String strsql = "select * from " + tablename;
try {
SqlRowSet sqlRowSet = jdbcTemplate.queryForRowSet(strsql);
SqlRowSetMetaData sqlRsmd = sqlRowSet.getMetaData();
int size = sqlRsmd.getColumnCount();
colnames = new String[size];
colTypes = new String[size];
colSizes = new int[size];
for (int i = 0; i < size; i++) {
colnames[i] = sqlRsmd.getColumnName(i + 1);
colTypes[i] = sqlRsmd.getColumnTypeName(i + 1);
if (colTypes[i].equalsIgnoreCase("datetime")) {
f_util = true;
}
if (colTypes[i].equalsIgnoreCase("image")
|| colTypes[i].equalsIgnoreCase("text")) {
f_sql = true;
}
colSizes[i] = sqlRsmd.getColumnDisplaySize(i + 1);
}
String content = parse(colnames, colTypes, colSizes);
try {
FileWriter fw = new FileWriter(initcap(tablename) + ".java");
PrintWriter pw = new PrintWriter(fw);
pw.println(content);
pw.flush();
pw.close();
} catch (IOException e) {
e.printStackTrace();
}
} finally {
}
}
示例5: get
import org.springframework.jdbc.support.rowset.SqlRowSetMetaData; //导入方法依赖的package包/类
@Override
public Map<String, Object> get() {
Map<String, Object> result = Maps.newHashMap();
final SqlRowSetMetaData metadata = rowSet.getMetaData();
for(int i = 1; i <= metadata.getColumnCount(); i++) {
String columnTypeName = metadata.getColumnTypeName(i);
final Object value;
if("array".equalsIgnoreCase(columnTypeName)) {
value = parseJson(rowSet.getString(i), List.class);
} else if("map".equalsIgnoreCase(columnTypeName)
|| "struct".equalsIgnoreCase(columnTypeName)) {
value = parseJson(rowSet.getString(i), Map.class);
} else if("string".equalsIgnoreCase(columnTypeName)) {
value = HiveUtils.unescapeString(rowSet.getString(i));
} else {
value = rowSet.getObject(i);
}
result.put(metadata.getColumnName(i), value);
}
return result;
}