i need some help finding these 2 errors
error one - customer.java:71: cannot resolve symbol
symbol : method displayResultSet (java.sql.ResultSet)
location: class customer
displayResultSet(resultSet);
^
error two - customer.java:93: cannot resolve symbol
symbol : class vector
location: class customer
Vector columnHeads = new vector();
^
THIS IS THE CODE I HAVE MARKED THE LINES WHERE ERRORS ARE
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
public class customer extends JFrame {
private Connection connection;
private JTable table;
public customer()
{
String url = "jdbc
dbc:Info";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection = DriverManager.getConnection(url);
}
catch (ClassNotFoundException cnfex){
System.err.println(
"Failed to load JDBC/ODBC driver.");
cnfex.printStackTrace();
System.exit(1);
}
catch(SQLException sqlex){
System.err.println("Unable to connect");
sqlex.printStackTrace();
}
getTable();
setSize(450,200);
show();
}
private void getTable()
{
Statement statement;
ResultSet resultSet;
try{
String query = "Select * from custDetails";
//FIRST ERROR HERE SOMEWHERE
statement = connection.createStatement();
resultSet = statement.executeQuery(query);
displayResultSet(resultSet);
statement.close();
}
catch (SQLException sqlex){
sqlex.printStackTrace();
}
}
private void displayresultSet(ResultSet rs)
throws SQLException
{
boolean moreRecords = rs.next();
if(!moreRecords){
JOptionPane.showMessageDialog(this,
"ResultSet contained no records");
setTitle("No records to diaplay");
return;
}
setTitle("Customer Details Table from Customer");
//SECCOND ERROR HERE SOMEWHERE
Vector columnHeads = new vector();
Vector rows = new Vector();
try{
ResultSetMetaData rsmd = rs.getMetaData();
for(int i=1; i<=rsmd.getColumnCount();++i)
columnHeads.addElement(rsmd.getColumnName(1));
do{
rows.addElement(getNextRow(rs, rsmd));
}while (rs.next());
table = new JTable(rows, columnHeads);
JScrollPane scroller = new JScrollPane(table);
getContentPane().add(
scroller, BorderLayout.CENTER);
validate();
}
catch (SQLException sqlex){
sqlex.printStackTrace();
}
}
private Vector getNextRow(ResultSet rs,
ResultSetMetaData rsmd)throws SQLException
{
Vector currentRow = new Vector();
for (int i=1; i<rsmd.getColumnCount();++i)
switch(rsmd.getColumnType(i)){
case Types.VARCHAR:
currentRow.addElement(rs.getString(i));
break;
case Types.INTEGER:
currentRow.addElement(
new Long(rs.getLong(i)));
break;
default:
System.out.println("Type was:"+
rsmd.getColumnTypeName(i));
}
return currentRow;
}
public void shutDown()
{
try{
connection.close();
}
catch (SQLException sqlex){
System.err.println("Unable to disconnect");
sqlex.printStackTrace();
}
}
public static void main(String args[])
{
final customer app = new customer();
app.addWindowListener(
new WindowAdapter(){
public void windowClosing(WindowEvent e)
{
app.shutDown();
System.exit(0);
}
}
);
}
}
thanks in advance!!!
