java select数据库_JAVA 关于数据库select问题

packagecom.student;importcom.student.DatabaseExecute;publicclassAextendsDatabaseExecute{voidstart(){//insert("insertintouserinfo(name,age,sex)values('leo',22,'a')");java....

package com.student;

import com.student.DatabaseExecute;

public class A extends DatabaseExecute

{

void start()

{

//insert("insert into userinfo (name,age,sex) values ('leo',22,'a')");

java.util.Vector v = select("select * from userinfo");

for(int i=0;i

{

System.out.println(v.get(i));

}

}

public static void main(String[] args)

{

new A().start();

}

}

----------------------------------------------------------------

package com.student;

import java.sql.*;

import java.util.Vector;

public class DatabaseExecute

{

private Connection con;

private Statement stat;

private ResultSet rs;

private void connection()

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con = DriverManager.getConnection("jdbc:odbc:sourceName", "", "");

stat = con.createStatement();

}

catch(Exception e)

{

e.printStackTrace();

}

}

public Vector select(String selectStr)

{

connection();

try

{

Vector v = new Vector();

rs=stat.executeQuery(selectStr);

while(rs.next())

{

v.add(rs.getString(1));//这里怎么写能让它显示出全部?而不是现在这样单独显示1列

}

rs.close();

return v;

}

catch(Exception ex)

{

ex.printStackTrace();

}

finally

{

try {

if(stat!=null)

stat.close();

if(con!=null)

con.close();

}

catch (Exception ex) {

ex.printStackTrace();

}

}

return null;

}

}

----------------------------------------------------------------

v.add(rs.getString(1));//这里怎么写能让它显示出全部?而不是现在这样单独显示1列

展开