我的意思是 将查询语句执行后 String[] selectMethod(Bean bean) {
String[] result = new String[100];
int i = 0;
sql = "select *from stu where logname = ?";
try {
con = this.getConnection();
pstm = con.prepareStatement(sql);
pstm.setString(1, bean.getLog());
rs = pstm.executeQuery();
while (rs.next()) {--------------------怎将查询拿出来的值方在数组里啊
}
rs.close();
pstm.close();
con.close(); } catch (SQLException se) {
se.printStackTrace(); }
return result; }
String[] result = new String[100];
int i = 0;
sql = "select *from stu where logname = ?";
try {
con = this.getConnection();
pstm = con.prepareStatement(sql);
pstm.setString(1, bean.getLog());
rs = pstm.executeQuery();
while (rs.next()) {--------------------怎将查询拿出来的值方在数组里啊
}
rs.close();
pstm.close();
con.close(); } catch (SQLException se) {
se.printStackTrace(); }
return result; }
int i = 0;
while (rs.next()) {
result[i++] = rs.getString(1);
}
String[] result = new String[100];
int i = 0;
sql = "select *from stu where logname = ?";
try {
con = this.getConnection();
pstm = con.prepareStatement(sql);
pstm.setString(1, bean.getLog());
rs = pstm.executeQuery();
while (rs.next()) {
String aa= rs.getString(输入你要取的字段);
把aa的值保存进result 不就可以了么? }
rs.close();
pstm.close();
con.close(); } catch (SQLException se) {
se.printStackTrace(); }
return result; }
Vector v = new Vector(); //用Vector装元素作数组
String[] result = new String[100];
int i = 0;
sql = "select *from stu where logname = ?";
try {
con = this.getConnection();
pstm = con.prepareStatement(sql);
pstm.setString(1, bean.getLog());
rs = pstm.executeQuery();
while (rs.next()) {
String str = rs.getString(字段名);
v.addElement(str); //每个元素存成一条记录,这里如果有多个字段自己再作修改,只给个例子啦
}
//读内容
for (int i=0;i<v.size;i++) {
System.out.println(v.elementAt(i).toString());
}
rs.close();
pstm.close();
con.close();
} catch (SQLException se) {
se.printStackTrace(); }
return v; }
写个POJO类MessageVO ( set get ) 将这个类用ArraryList 或者 Vector 保存
Collection ret=new ArrayList();
MessageVO msg;result=stm.executeQuery("select * from message order by time desc");
while(result.next())
{
String title=result.getString("title");
String name=result.getString("name");
String mail=result.getString("mail");
String content=result.getString("content");
java.sql.Date date=result.getDate("time");
MessageVO message=new MessageVO();
message.setName(name);
message.setTitle(title);
message.setContent(content);
message.setDate(date);
message.setEmail(mail);
ret.add(message);
}
result.close();
stm.close();