public String[][] getData(String _sql) {
try {
StringManager str = new StringManager();
int rows = this.getRows(_sql);
//System.out.println("rows=["+rows+"]");
rs = this.executeQuery(_sql);
ResultSetMetaData rsmd = rs.getMetaData();
String data = "";
NumberFormat format = NumberFormat.getNumberInstance();
format.setGroupingUsed(false);
// int rows = this.getRows(rs);
int cols = rsmd.getColumnCount();
/*
String[] types = new String[cols];
for(int _i =0;_i<cols;_i++){
//types[_i]= rsmd.getColumnTypeName(_i);
System.out.println(rsmd.getColumnTypeName(_i+1));
}*/
String[][] t = new String[rows][cols];
int row = 0;
while (rs.next()) {
for (int i = 0; i < cols; i++) {
if (rsmd.getColumnTypeName(i + 1).equals("FLOAT")) {
data = format.format(rs.getFloat(i + 1) / 1000000);
} else
data = rs.getString(i + 1);
if (data == null)
data = "";
t[row][i] = data;
}
//System.out.println(t[row][0]+ " "+ t[row][1]+ " "+t[row][2]);
row++;
}
errMsg = "";
rs.close();
if (row == 0)
return null;
else
return t;
} catch (Exception e) {
errMsg = e.getMessage();
return null;
}
}
try {
StringManager str = new StringManager();
int rows = this.getRows(_sql);
//System.out.println("rows=["+rows+"]");
rs = this.executeQuery(_sql);
ResultSetMetaData rsmd = rs.getMetaData();
String data = "";
NumberFormat format = NumberFormat.getNumberInstance();
format.setGroupingUsed(false);
// int rows = this.getRows(rs);
int cols = rsmd.getColumnCount();
/*
String[] types = new String[cols];
for(int _i =0;_i<cols;_i++){
//types[_i]= rsmd.getColumnTypeName(_i);
System.out.println(rsmd.getColumnTypeName(_i+1));
}*/
String[][] t = new String[rows][cols];
int row = 0;
while (rs.next()) {
for (int i = 0; i < cols; i++) {
if (rsmd.getColumnTypeName(i + 1).equals("FLOAT")) {
data = format.format(rs.getFloat(i + 1) / 1000000);
} else
data = rs.getString(i + 1);
if (data == null)
data = "";
t[row][i] = data;
}
//System.out.println(t[row][0]+ " "+ t[row][1]+ " "+t[row][2]);
row++;
}
errMsg = "";
rs.close();
if (row == 0)
return null;
else
return t;
} catch (Exception e) {
errMsg = e.getMessage();
return null;
}
}
解决方案 »
- java应用程序打包问题 如何设置JVM heap大小!
- 帮忙写个校验密码的类,谢谢,在线等
- java新手的问题 真的很困惑 求结
- 一直没有弄明白的多线程和线程安全问题?
- 十六进制问题
- 怎么在一个带有checkbox的tree上根据tree的子结点的选种情况设置跟节点checkbox的三种状态(半选中,选中,没选中)? ===>100点 实在很急
- Linux下的j2sdk-1_4_2_04-linux-i586-rpm.bin怎么才能运行?
- 请教
- 请教一个简单的日期格式化问题.谢谢
- java中连ORACLE的 DriverManager.getConnection(String url) 的url要怎么写啊
- java中不明白的问题
- 小小问题:)20分
while(rst.next()){
for(int i=0;i<2;i++){
ss[a][i]=rst.getString(i);
}
a++;
}