我想把查询到的结果放到一个数组中,但是怎么才行啊?以下是我写的:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
package com.declareol.trashbox;import java.sql.ResultSet;
import java.util.Vector;
import com.declareol.commons.CommConnDataBase;public class TrashBox {
public String[] strUser; public void getTrashBox(String strName) {
CommConnDataBase CCDB = new CommConnDataBase();
ResultSet objRsInfo = null;
int intI = 0;
String strSelect = "select * from DOL_OFTEN_CASE"; try {
objRsInfo = CCDB.getResult(strSelect);
while (objRsInfo.next()) {
strUser[intI] = objRsInfo.getString(3);
System.out.println("Number :" + strUser[intI]);
intI++;
}
} catch (Exception e) {
System.out.print(e.getMessage());
} finally {
CCDB.Release();
} } public String[] putUser() {
return strUser;
}}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
package com.declareol.trashbox;import java.sql.ResultSet;
import java.util.Vector;
import com.declareol.commons.CommConnDataBase;public class TrashBox {
public String[] strUser; public void getTrashBox(String strName) {
CommConnDataBase CCDB = new CommConnDataBase();
ResultSet objRsInfo = null;
int intI = 0;
String strSelect = "select * from DOL_OFTEN_CASE"; try {
objRsInfo = CCDB.getResult(strSelect);
while (objRsInfo.next()) {
strUser[intI] = objRsInfo.getString(3);
System.out.println("Number :" + strUser[intI]);
intI++;
}
} catch (Exception e) {
System.out.print(e.getMessage());
} finally {
CCDB.Release();
} } public String[] putUser() {
return strUser;
}}
objRsInfo = CCDB.getResult(strSelect);
while (objRsInfo.next()) {
list.add(objRsInfo.getString(3));
intI++;
} strUser=list.toArray();//这不一定对,可能需要加(String[]),转成toArray()也可能不对,不过肯定会有类似这样的一个方法