Switch Frames and Update JTable
Hi ppl
My JTable gets the data from the DB and displays it all very nicely, but when the user clicks search and the data is pulled, I want the screen to switch from one tab to another. And when the user searches again, its creates another table and divides the contentPane into two parts... everytime search is clicked it keeps creating new tables that all have the same data.
User clicks search =
//WHEN PERFORMING A SEARCH
publicvoid Search(){
try{
ResultSet user;
String userMovieName= fieldMovie.getText();
vColumnNames.clear();
vData.clear();
Class.forName(driver);
Connection con = DriverManager.getConnection("jdbc:odbc:Vid_DB","sa","password");
Statement st = con.createStatement();
if (comboBoxSelected == 0){
user = st.executeQuery("SELECT movie_name, movie_desc, genre_name " +
"FROM Movies m INNER JOIN Genres g ON m.genre_id = g.genre_id " +
"WHERE movie_name like '%" + userMovieName +"%' ");
}
else{
user = st.executeQuery("SELECT movie_name, movie_desc, genre_name " +
"FROM Movies m INNER JOIN Genres g ON m.genre_id = g.genre_id " +
"WHERE movie_name like '%" + userMovieName +"%' and m.genre_id = " + comboBoxSelected);
}
ResultSetMetaData md = user.getMetaData();
int columns = md.getColumnCount();
// Get column names
for (int i = 1; i <= columns; i++){
vColumnNames.addElement( md.getColumnName(i) );
}
// Get row data
while (user.next()){
Vector row =new Vector(columns);
for (int i = 1; i <= columns; i++){
row.addElement(user.getObject(i) );
}// end for (int i = 1; i <= columns; i++)
vData.addElement( row );
}//end while (user.next())
user.close();
st.close();
myTable();
//myTable();
}catch (SQLException sqle){
System.out.println("error: "+ sqle);
}catch (ClassNotFoundException cnfe){
System.out.println("error: " + cnfe);
}finally{
}
}
publicvoid myTable(){
table =new JTable(vData, vColumnNames);
scrollPane =new JScrollPane(table);
tabTable.setLayout(new GridLayout(1,0));
tabTable.add(scrollPane);
}
I have chopped and changed too many times, this is the working version, and the version that is in my NetBeans now.
I know its a few easy lines, but I cant for the life of me get it to do what I want.
The help is much appreciated!
Justiz
Note: [url=http://forums.devshed.com/java-help-9/autoscreenchange-and-jtable-update-352319.html]Also posted here[/url]
