import java.sql.*;
import java.util.*;
import java.io.*;public class QueryTemp
{
public static void main(String [] args)
{
ResultSet result;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:LocalServer";
Connection conn = DriverManager.getConnection(url,"sa","000000");
Statement stmt = conn.createStatement();
result = stmt.executeQuery("select pub_name from Publishers");
Vector vector = new Vector(1,1);
Object obj;
while(result.next())
{
System.out.println(result.getString(1));
//如果把下面一行注释掉可以把结果集显示出来
//现在我想把查询到的内容加入一个集合类例如Vector
//然后再显示出来怎么办?????????????????????
vector.addElement(result.getString(1));
}
System.out.println("Vector 中的元素个数是: " + vector.size());
for(int i=0; i < vector.size(); i++)
{
obj = vector.elementAt(i);
System.out.println(obj.toString() );
}
}
catch(Exception e)
{
System.out.println("Error: " + e);
}
}
}
import java.util.*;
import java.io.*;public class QueryTemp
{
public static void main(String [] args)
{
ResultSet result;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:LocalServer";
Connection conn = DriverManager.getConnection(url,"sa","000000");
Statement stmt = conn.createStatement();
result = stmt.executeQuery("select pub_name from Publishers");
Vector vector = new Vector(1,1);
Object obj;
while(result.next())
{
System.out.println(result.getString(1));
//如果把下面一行注释掉可以把结果集显示出来
//现在我想把查询到的内容加入一个集合类例如Vector
//然后再显示出来怎么办?????????????????????
vector.addElement(result.getString(1));
}
System.out.println("Vector 中的元素个数是: " + vector.size());
for(int i=0; i < vector.size(); i++)
{
obj = vector.elementAt(i);
System.out.println(obj.toString() );
}
}
catch(Exception e)
{
System.out.println("Error: " + e);
}
}
}
import java.util.*;
import java.io.*;public class QueryTemp
{
public static void main(String [] args)
{
ResultSet result;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:LocalServer";
Connection conn = DriverManager.getConnection(url,"sa","000000");
Statement stmt = conn.createStatement();
result = stmt.executeQuery("select pub_name from Publishers");
Vector vector = new Vector();
while(result.next())
{
vector.addElement(result.getString(1));
}
System.out.println("Vector 中的元素个数是: " + vector.size());
for(int i=0; i < vector.size(); i++)
{
String x=(String)vector.elementAt(i); System.out.println(x);
}
}
catch(Exception e)
{
System.out.println("Error: " + e);
}
}
}
////////////////////////
这样可以么?没调试。你自己调试下。
System.out.println(str);
}
改
Vector vector = new Vector();
用resultset.getMetaData().getColumnCount() 可以决定Vector的长度.
import java.sql.*;
import java.util.*;
import java.io.*;public class QueryTemp
{
public static void main(String [] args)
{
ResultSet result;
Connection conn=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:LocalServer";
conn = DriverManager.getConnection(url,"sa","000000");
Statement stmt = conn.createStatement();
result = stmt.executeQuery("select pub_name from Publishers");
Object obj;
Vector v=new Vector();
while(result.next())
{
Vector ve=new Vector();
ve.addElement(result.getObject(1));
v.addElement(ve);
}
System.out.println("Vector 中的元素的个数是: " + v.size());
for(int i=0; i < v.size(); i++)
{
obj = v.elementAt(i);
System.out.println(obj.toString());
}
}
catch(Exception e)
{
System.out.println("Error: " + e);
}
}
}