Well basically for the assignment I have to write a project that reads data from a .mdb database file and stores this data into a 2D array, then lets the user manipulate the data in the array (stuff like adding, editing, sorting, deleting and searching data) by using GUI and then finally writing back from the array into the database.
Everything in the program works exept for where I have to write to and from the array. :cry:
This is my program so far:
The class that creates an object that the array will consist of
public class CarObject
{
private String make;
private String model;
private int year;
private String price;
//Default constructor
public CarObject()
{ }
//parameterised constructor
public CarObject(String m, String mod, int y, String p)
{
make = m;
model = mod;
year = y;
price = p;
}
/**Mutator method for make field
*@param m make as String
*/ public void setMake(String m)
{
make = m;
}
/**Mutator method for model field
*@param mod model as String
*/ public void setModel(String mod)
{ model = mod;
}
/**Mutator method for year field
*@param y year as int
*/ public void setYear(int y)
{
year = y;
}
/**Mutator method for price field
*@param p price as String
*/ public void setPrice(String p)
{
price = p;
}
/**Accessor method for make field
*@return make as String
*/ public String getMake()
{
return make;
}
/**Accessor method for model field
*@return model as String
*/ public String getModel()
{
return model;
}
/**Accessor method for year field
*@return year as int
*/ public int getYear()
{
return year;
}
/**Accessor method for price field
*@return price as String
*/ public String getPrice()
{
return price;
}
/**toString method for CarObject, intended for screen output
*@return CarObject properties as String
*/ public String toString()
{
return this.getMake()+ ", " + this.getModel() + ", made in "
+ this.getYear() + " costs " + this.getPrice();
}
}//end of classThis is the main component of the program that calls mot of the other classes
import javax.swing.*;
import java.awt.event.*;
import java.awt.*;
import java.io.*;
import java.sql.*;
/**Car application class
*/
public class CarApplication extends JFrame
{
protected static CarArray ca = new CarArray();
public CarApplication()
{
//Creates panel
super("Main Menu");
JPanel firstPanel = new JPanel();
//Allows the frame to be closed when the cross is clicked setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
//Adds buttons to it
JButton displayButton = new JButton("Display");
JButton addButton = new JButton("Add");
JButton deleteButton = new JButton("Delete");
JButton editButton = new JButton("Edit");
JButton sortButton = new JButton("Sort");
JButton searchButton = new JButton("Search");
JButton exitButton = new JButton("EXIT");
//Add components to it.
getContentPane().add(firstPanel);
firstPanel.add(displayButton);
firstPanel.add(addButton);
firstPanel.add(deleteButton);
firstPanel.add(editButton);
firstPanel.add(sortButton);
firstPanel.add(searchButton);
firstPanel.add(exitButton);
//Displays the window.
setSize(200,200);
setLocationRelativeTo(null); //centers it
show();
displayButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{new DisplayFrame();}
});
addButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{new AddFrame(); }
});
deleteButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{new DeleteFrame();}
});
editButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{new EditFrame1();}
});
sortButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{ new SortArray();}
});
searchButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{new SearchFrame();}
});
exitButton.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{ setVisible(false);
dispose();
try
{
ca.arrayToFile();
}
catch(SQLException se)
{
System.out.println("ERROR!!!! CAN'T WRITE TO DATABASE FILE");
}
}
});
}
public static void main(String [] args) throws IOException
{
try
{
ca.fileToArray();
}
catch(SQLException se)
{
System.out.println("ERROR!!! CAN'T READ FROM DATABASE FILE");
}
new CarApplication();
}
}This is where the error occurs, in the in the FileToArray() and ArrayToFile() methods. :mad: :o
import java.io.*;
import java.sql.*;
/**Creates a CarArray object<br>
*CarArray object is an array of length 20 of CarObject objects
*/
public class CarArray
{
/**Array of length 20 of CarObject objects*/
private CarObject[] carArr = new CarObject[20];
/**Number of items used in array, ie number of CarObject objects in array
*/
private int size = 0;
/**Default constructor */
public CarArray()
{}
/**Loads JDBC-ODBC bridge driver*/
public static boolean loadODBC ()
{
try
{
Class.forName
("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println ("Bridge loaded");
return true;
}
catch (ClassNotFoundException e)
{
System.out.println ("Bridge not found"); return false;
} // catch block
} // loadODBC method
/**Reads contents of cars.mdb file containing properties of CarObject
*objects and constructs CarObject objects in array using data as parameters.
*<br>size field is updated to reflect number of CarObject objects in array.*/
public void fileToArray() throws SQLException
{
Connection conn;
conn = DriverManager.getConnection ("jdbc:odbc:Cars", "", "");
Statement stmt = conn.createStatement();
String query = "SELECT Make, Model, Year, Price ";
ResultSet rs = stmt.executeQuery(query);
while (rs.next())
{
String m = rs.getString("Make");
String mod = rs.getString("Model");
int y = rs.getInt("Year");
String p = rs.getString("Price");
carArr[size] = new CarObject(m, mod, y, p);
size++;
}
}
/**Writes contents of array to cars.mdb database file.
*The properties of each CarObject object in the array are recorded in the file */
public void arrayToFile()throws SQLException
{
Connection conn;
conn = DriverManager.getConnection ("jdbc:odbc:Cars", "", "");
for(int x = 0; x < size; x++)
{
Statement stmt = conn.createStatement();
stmt.executeUpdate( "INSERT INTO Cars " + "VALUES (carArr[x].getMake(), carArr[x].getModel(), carArr[x].getYear(), carArr[x].getPrice())");
}
}
/**Sends carArr to DisplayFrame which calls it so that the data can be displayed
*/
public CarObject[] display()
{
return carArr;
}
/**Allows user to input data for a new CarObject object to be added to the end
*of the array.
*<br>size field is incremented to account for new CarObject object added.
*@throws IOException*/
public void addToArray(String m, String mod, String y, String p) throws IOException
{
carArr[size] = new CarObject(m, mod, Integer.parseInt(y), p);
size++;
}
/**Deletes one CarObject object from array.
*Position of object to be deleted is determined by user input.
*@throws IOException*/
public void deleteCar(int pos) throws IOException
{
if(pos<19)//prevents array out of bound error if last object in the list is selected
{
for(int x = pos; x < size; x++)
{
carArr[x] = carArr[x+1];
}
}
size--;
}
/**Edits the properties of a CarObject object in the array. *@throws IOException
*/
public void editArray(String m, String mod, String y, String p, int edNum) throws IOException
{
String make
; String model
; int year;
String price;
if(!(m.equals(null)))
{
make = m;
}
else
{
make = carArr[edNum].getMake();
}
if(!(mod.equals(null)))
{
model = mod;
}
else
{
model = carArr[edNum].getModel();
}
if(!(y.equals(null)))
{
year = Integer.parseInt(y);
}
else
{
year = carArr[edNum].getYear();
}
if(!(p.equals(null)))
{
price = p;
}
else
{
price = carArr[edNum].getPrice();
}
carArr[edNum] = new CarObject(make, model, year, price);
}
/**Sorts the records in the array ascending by price property
*/
public void sortPrice()
{
//uses bubble sort
for(int outt = size - 1; outt >= 0; outt--)
{
for(int inn = 0; inn < outt; inn++)
{
if(carArr[inn].getPrice().compareToIgnoreCase(carArr[inn + 1].getPrice()) > 0)
{
CarObject temp = new CarObject();
temp = carArr[inn];
carArr[inn] = carArr[inn + 1];
carArr[inn + 1] = temp;
}
}
}
}
/**Searches for make input by user.
*<br>calls FoundFrame if found or NotFoundFrame if not found,
*@throws IOException
*/
public void searchArray(String searchText) throws IOException
{
//use binary search
boolean found = false;
int startPt = 0;
int endPt = size - 1;
int midPt = 0;
while(startPt <= endPt && !found)
{
midPt = (endPt + startPt) / 2;
if(carArr[midPt].getMake().equalsIgnoreCase(searchText))
//it has been found
{
found = true;
}
else if(carArr[midPt].getMake().compareToIgnoreCase(searchText) > 0)
//searchText may be in 1st half
{
endPt = midPt - 1;
}
else
//searchText may be in 2nd half
{
startPt = midPt + 1;
}
}
if(found)
{
new FoundFrame();
}
else
{
new NotFoundFrame();
}
}
}//end of class:idea:I have managed to find a fragment of code on writing to the array but I have not yet had time to test this:
dbArray = rs.GetRows()
for i = 0 to ubound(dbArray, 2)
response.write dbArray(0, i) & ",
" response.write dbArray(1, i) & "<br>"
nextWould this work effectively?
Please note that these are not all my classes but the rest just have to do with displaying different windows depends on which button the user presses in window created in the CarApplication class and these all work so it would just be a waste of both your and my time by posting them.
Any help would be grately apprechiated, so please don't hesitate if you can think of anything
