populating jtable with resultSet - help needed

[smallmos1]

trying to populate a jtable with a resultSet from a query. the method takes two sql date types in....been searching around a lot and finding it hard to get working, anyone point me in the right direction?

public static void createResult(java.sql.Date jsqlStartDate, java.sql.Date jsqlEndDate)throws SQLException
	{

			
			String query = "SELECT s.shift_date, st.start_time, st.end_time FROM Shift s, Shift_Time st WHERE s.shift_time_id = st.shift_time_id AND st.shift_date  > ? AND st.shift_date < ?";
			pstmt = conn.prepareStatement(query);
			pstmt.setDate(1,jsqlStartDate);
			pstmt.setDate(2,jsqlEndDate);
			Rset = pstmt.executeQuery();
			ResultSetMetaData rsmd = Rset.getMetaData();
			int columnCount = rsmd.getColumnCount();
			Vector columns = new Vector(columnCount);
			
			
			for(int i = 1; i < columnCount; i++)
			{
				columns.add(rsmd.getColumnName(i));
			}
			Vector data = new Vector();
			
			while(Rset.next())
			{
				Vector row = new Vector(columnCount);
				for(int i = 1; i <=columnCount; i++)
				{
					row.add(Rset.getString(i));
				}
				data.add(row);	
			}
			Rset.close();
			pstmt.close();
			
			JTable table = new JTable(data, columns);
			JScrollPane scrollPane = new JScrollPane( table );
	        Container cPane = null;
	        cPane.add( scrollPane, table );
	        
	        table.setVisible(true);

the code for putting the resultSet and jtable is a bit messy i know. basically user will select two dates, start and end, and when they hit the submit button (in the gui class), i want the query to execute, and the resultSet to appear in a jtable in a new window (would it be better to have a results class that displays this jtable, or is ok to have it appear as i have a above?).

all help welcome, thanks

[mine0926]

Do you receive any error? What is the error message?

[jasonwucinski]

i'm still new working with java but here's some of my limited insights, take them for what theyre worth. First, are you're sure your sql string is producing the desired results? Second, by default, result sets are only one direction. you can change this by using this:

stmt = myConnection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

and lastly, i'm sure theres plenty of ways to create a jTable but I was under the impression you needed to create a DefaultTableModel to a jTable and add the columns to that? below is how I add data to a jTable, maybe that exampe can help. good luck.

private void loadPatients(){
        String SQL = "SELECT PatientID, PatientFName,PatientLName,PatientDOB,PatientGender FROM tblPatient ORDER BY PatientLName ASC";
        String curDir = System.getProperty("user.dir");   
        String myUrl = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="
            + curDir
            + "\\"
            + "ADR_DB.accdb";
        String username = "";
        String password = "";
        Connection myConnection;
        Statement stmt;
        ResultSet rs;
        int myCounter = 0;
        
        try { 
                myConnection = DriverManager.getConnection(myUrl,username,password); 
                stmt = myConnection.createStatement(); 
                rs = stmt.executeQuery(SQL);  

                DefaultTableModel model = new DefaultTableModel();
                this.jTable1.setModel(model);             

                model.addColumn("PatientID");
                model.addColumn("First Name");
                model.addColumn("Last Name");
                model.addColumn("DOB");
                model.addColumn("Gender");
                
                jTable1.setAutoResizeMode(0);
            try {
                
                while ( rs.next() ) { 
                                
                  this.patientID = rs.getString(1);
                  this.patientFName   = rs.getString(2);
                  this.patientLName = rs.getString(3);
                  this.patientDOB  = rs.getString(4);  
                  this.patientGender = rs.getString(5);
                  
                  model.addRow(new Object[]{ this.patientID, this.patientFName, this.patientLName, this.patientDOB,this.patientGender});
            } 
               
     
               
                
            } catch (Exception e) { 
                callingFrame.setColor(Color.red);           
                callingFrame.setLable("Error Filling Combo:" + e.toString());
            } finally {
                rs.close();
                stmt.close();
                myConnection.close();           
            }
        } catch (Exception e) {
                callingFrame.setColor(Color.red);           
                callingFrame.setLable("Error Filling Combo:" + e.toString());           
        }
    
}