不是字符串,而是一个对象,就好象是VB中的RecordSet记录集
可以这样使用它
int i =0;
String[] cell;
while(seed.next()){
i++;
cell[i] = (String)seed("col1Name");
}
这样就把第一列的值全取出来了
可以这样使用它
int i =0;
String[] cell;
while(seed.next()){
i++;
cell[i] = (String)seed("col1Name");
}
这样就把第一列的值全取出来了
String askType;
String askInfo;
Statement smt = con.createStatement();
/* 按顺序读取第一条待发短信 */
String selCode = "SELECT TOP 1 AskType,AskInfo " +
"FROM AskSubmitInfo " +
"ORDER BY LeReferTime ASC";
ResultSet r = smt.executeQuery(selCode);
while(r.next()) {
askType = r.getString("AskType");
askInfo = r.getString("AskInfo");
}//取出ResultSet的结果,只有一条记录
String askType;
String askInfo;
Statement smt = con.createStatement();
/* 按顺序读取第一条待发短信 */
String selCode = "SELECT TOP 1 AskType,AskInfo " +
"FROM AskSubmitInfo " +
"ORDER BY LeReferTime ASC";
ResultSet r = smt.executeQuery(selCode);
while(r.next()) {
askType = r.getString("AskType");
askInfo = r.getString("AskInfo");
}//取出ResultSet的结果,只有一条记录