retrieving data from table and saving into database

[Anita Nair]

hello,

I have used Table and passed it to a TableEditor element.
I have a few text boxes and combo from which the user enters data.
Then there is a editable table using which user is allowed to enter data into table directly.
I want to know how to know how many rows have the user entered data when they click on the save button.
also how to save multiple rows to the db at the same time ie on click of save button. my code doesnt seem to work
There is also a delete and edit button. Please help.
Here is my code.

save_btn.addSelectionListener(new SelectionAdapter()
	{
		public void widgetSelected(SelectionEvent e) 
		{
			
		 try 
		 {    
			 Class.forName(driver);
		     conn = DriverManager.getConnection(url+dbName,userName,password);
			 PreparedStatement pstmt;
			 Statement st=null;
		     ResultSet rs=null;
		     String str_id = null;
		     st=conn.createStatement();
		     select_strategy_combo_val =select_strategy_combo.getText();
		     String test="select id from strategies where name='"+select_strategy_combo_val+"';";
		     rs= st.executeQuery(test);
		     System.out.println("rs "+rs);
		     while(rs.next()){
		    	 str_id= rs.getString(1);
		     }
		     System.out.println("str_id "+str_id);
			 strategy_template_name_combo_val=strategy_template_combo.getText();
			 strategy_template_name_val=strategy_template_name_txt.getText();
			 pstmt=(PreparedStatement) conn.prepareStatement
			 ("insert into strategycsvstructure(strategy_id,strategy_name,strategy_template_name,sr_no," +
		     "column_name,column_nullable,column_datatype,column_size,source, drp_down_id)" +
		     "values(?,?,?,?,?,?,?,?,?,?);");
		      
		      pstmt.setString(1,str_id);
		      pstmt.setString(2,select_strategy_combo_val);
		      pstmt.setString(3,strategy_template_name_val);
		      
		      TableItem[]  tItemArr=table.getItems();
		      System.out.println("tItemArr.length" +tItemArr.length);
		      for (int i = 0; i < tItemArr.length; i++) 
		    	  
		      {
		    	  String columnName =tItemArr[i].getText(1);
		    	  if(columnName != null && !columnName.equals(""))
		    		  pstmt.setString(3,columnName);
		    	  
		    	  String columnNullable =tItemArr[i].getText(4);
		    	  if(columnNullable != null && !columnNullable.equals(""))
		    		  pstmt.setString(4,columnNullable);
		    	  
		    	  String columnDataType =tItemArr[i].getText(2);
		    	  if(columnDataType != null && !columnDataType.equals(""))
		    		  pstmt.setString(5,columnDataType);
		    	  
		    	  String columnSize =tItemArr[i].getText(3);
		    	  if(columnSize != null && !columnSize.equals(""))
		    		  pstmt.setString(6,columnSize);
		    	  
		    	  String columnSource =tItemArr[i].getText(5);
		    	  if(columnSource != null && !columnSource.equals(""))
		    		  pstmt.setString(7,columnSource);
		    	  
		    	  String columndrp_down_id =tItemArr[i].getText(6);
		    	  if(columndrp_down_id != null && !columndrp_down_id.equals(""))
		    		  pstmt.setString(8,columndrp_down_id);
		      }
			  

			  
			  pstmt.executeUpdate();
			   conn.close();
			  }
		  catch (Exception e2)
			  {
			  e2.printStackTrace();
			  }        
	}			
});
			
 }    
    

[Rob Spoor]

ItDoesntWorkIsUseless. Does the code throw an error? Does it get called at all? What exactly is not working?

[Anita Nair]

my code is as given below..
now i want to allow users to enter data directly into the table..
on the click of save button i want to know how many rows the user has entered so that i can save it into my database using for loop
now i am doing it by reading a textbox which asks the user for the number of rows they want to enter.
Though this is very inefficient i dont know what else to do? Please help

private void createContents(final Shell shell)
 {
	shell.setLayout(new RowLayout(SWT.VERTICAL));
	RowLayout rw=new RowLayout(SWT.HORIZONTAL);
    Composite composite1= new Composite(shell,0); 
    composite1.setLayout(rw);
    select_strategy_lbl=new Label(composite1,0);
	select_strategy_lbl.setText("Select Strategy");
	dummy1=new Label(composite1,0);
	dummy1.setText("      ");
	select_strategy_combo = new Combo(composite1, SWT.DROP_DOWN);
	dummy10=new Label(composite1,0);
	dummy10.setText("      ");	 
	 strategy_template_lbl=new Label(composite1,0);
	 strategy_template_lbl.setText("New Template?");
	   dummy2=new Label(composite1,0);
	   dummy2.setText("      ");
	   strategy_template_combo = new Combo(composite1, SWT.DROP_DOWN);
	   strategy_template_combo.setItems(strategy_template_type); 
	 select_strategy_combo.add(strategy_names);
 
   Composite composite2= new Composite(shell,0); 
   composite2.setLayout(rw);
   strategy_name_lbl=new Label(composite2,0);
   strategy_name_lbl.setText("Strategy Template Name");
   dummy4=new Label(composite2,0);
   dummy4.setText("      ");
   strategy_template_name_txt=new Text(composite2,0);
   dummy3=new Label(composite2,0);
   dummy3.setText("      ");
   dummy5=new Label(composite2,0);
   dummy5.setText("      ");
   dummy6=new Label(composite2,0);
   dummy6.setText("      ");
   dummy7=new Label(composite2,0);
   dummy7.setText("      ");
   
    row_no=new Label(composite2,0);
	row_no.setText(" Rows?");
	dummy8=new Label(composite2,0);
	dummy8.setText("      ");
	row_no_txt=new Text(composite2,0);
   strategy_template_combo.addListener(SWT.DROP_DOWN, new Listener() 
   {
	   public void handleEvent(Event event) {
	   selected =  strategy_template_combo.getText();
	   if(selected=="New")
	   {    
		   strategy_template_name_txt.setText(" ");
		  
	   }
	   else
	   {  
		   //code yet to be written
		
	   }
	}
   });
   
   
    // Create the table
    table = new Table(shell, SWT.SINGLE | SWT.FULL_SELECTION);
    table.setSize(1500, 500);
    table.setHeaderVisible(true);
    table.setLinesVisible(true);
    // Create  columns
  
    for (int i = 0; i < 6; i++) 
    {
      TableColumn column = new TableColumn(table, SWT.CENTER);
      column.pack();
      column.setWidth(80);
    
      if(i==0) column.setText("Column Name");
      if(i==1) column.setText("Nullable");
      if(i==2) column.setText("Data Type");
      if(i==3) column.setText("Size");
      if(i==4) column.setText("Source");
      if(i==5)column.setText("Parameter");
    }
    
    
    TableEditor[] tablediter = new TableEditor[NUM_ROWS];
    
     for (int i = 0; i < NUM_ROWS; i++)
    {
       final TableItem item = new TableItem(table, SWT.NONE);
      tablediter[i] = new TableEditor(table);
      tablediter[i].grabHorizontal = true;
      tablediter[i].minimumHeight = 10;
      tablediter[i].minimumWidth = 80;
  }

    // Create an editor object to use for text editing
    final TableEditor editor = new TableEditor(table);
    editor.horizontalAlignment = SWT.LEFT;
    editor.grabHorizontal = true;

    // Use a mouse listener
    table.addMouseListener(new MouseAdapter()
    {
      public void mouseDown(MouseEvent event)
      {
        // Dispose any existing editor
        Control old = editor.getEditor();
        if (old != null) old.dispose();

        // Determine where the mouse was clicked
        Point pt = new Point(event.x, event.y);

        // Determine which row was selected
        final TableItem item = table.getItem(pt);
        if (item != null) 
        {
          // Determine which column was selected
          int column = -1;
          for (int i = 0, n = table.getColumnCount(); i < n; i++) 
          {
            Rectangle rect = item.getBounds(i);
            if (rect.contains(pt))
            {
              // This is the selected column
              column = i;
              break;
            }
          }
        

          
        
          
            if (column == 1) {
                // Create the dropdown and add data to it
                final CCombo combo = new CCombo(table, SWT.READ_ONLY);
                for (int i = 0, n = column_nullable.length; i < n; i++) {
                  combo.add(column_nullable[i]);
                }
               
            // Select the previously selected item from the cell
            combo.select(combo.indexOf(item.getText(column)));

            // Compute the width for the editor
            // Also, compute the column width, so that the dropdown fits
            editor.minimumWidth = combo.computeSize(80, 80).x;
            table.getColumn(column).setWidth(editor.minimumWidth);

            // Set the focus on the dropdown and set into the editor
            combo.setFocus();
            editor.setEditor(combo, item, column);

            // Add a listener to set the selected item back into the cell
            final int col = column;
            combo.addSelectionListener(new SelectionAdapter() {
              public void widgetSelected(SelectionEvent event) {
                item.setText(col, combo.getText());
                combo.dispose();
              }
            });
          } 
            
          // Column 2 holds dropdowns   
          if (column == 2)
          {
            // Create the dropdown and add data to it
            final CCombo combo = new CCombo(table, SWT.READ_ONLY);
            for (int i = 0, n = column_datatype.length; i < n; i++) 
            {
              combo.add(column_datatype[i]);
            }
                       // Select the previously selected item from the cell
            combo.select(combo.indexOf(item.getText(column)));

            // Compute the width for the editor
            // Also, compute the column width, so that the dropdown fits
            editor.minimumWidth = combo.computeSize(80, 80).x;
            table.getColumn(column).setWidth(editor.minimumWidth);

            // Set the focus on the dropdown and set into the editor
            combo.setFocus();
            editor.setEditor(combo, item, column);

            // Add a listener to set the selected item back into the cell
            final int col = column;
            combo.addSelectionListener(new SelectionAdapter() {
              public void widgetSelected(SelectionEvent event) {
                item.setText(col, combo.getText());

                combo.dispose();
              }
            });
          } 
          

            
                        if (column == 4) {
                  
                    final CCombo combo = new CCombo(table, SWT.READ_ONLY);
                    for (int i = 0, n = source.length; i < n; i++) {
                      combo.add(source[i]);
                    }
                     combo.select(combo.indexOf(item.getText(column)));
            editor.minimumWidth = combo.computeSize(80, 80).x;
            table.getColumn(column).setWidth(editor.minimumWidth);

            // Set the focus on the dropdown and set into the editor
            combo.setFocus();
            editor.setEditor(combo, item, column);

            // Add a listener to set the selected item back into the cell
            final int col = column;
            combo.addSelectionListener(new SelectionAdapter() {
              public void widgetSelected(SelectionEvent event) {
                item.setText(col, combo.getText());
                combo.dispose();
              }
            });
          } 
          
         if (column == 5) {
                // Create the dropdown and add data to it
                final CCombo combo = new CCombo(table, SWT.READ_ONLY);
                for (int i = 0, n = column_parameters.length; i < n; i++) {
                  combo.add(column_parameters[i]);
                }
               
            // Select the previously selected item from the cell
            combo.select(combo.indexOf(item.getText(column)));

            // Compute the width for the editor
            // Also, compute the column width, so that the dropdown fits
            editor.minimumWidth = combo.computeSize(80, 80).x;
            table.getColumn(column).setWidth(editor.minimumWidth);

            // Set the focus on the dropdown and set into the editor
            combo.setFocus();
            editor.setEditor(combo, item, column);

            // Add a listener to set the selected item back into the cell
            final int col = column;
            combo.addSelectionListener(new SelectionAdapter() {
              public void widgetSelected(SelectionEvent event) {
                item.setText(col, combo.getText());
                combo.dispose();
              }
            });
          } 
         
          else //if (column > 1) 
          {
            final Text text = new Text(table, SWT.NONE);
            
            
            text.setText(item.getText(column));
            
          
            text.setFocus();

           // Set the control into the editor
            editor.setEditor(text, item, column);

         d
            final int col = column;
            text.addModifyListener(new ModifyListener()
            {
              public void modifyText(ModifyEvent event)
              {
               item.setText(col, text.getText());
              }
            });
          }
        }
      }
    });
  
    
    Composite composite3= new Composite(shell,0); 
    composite3.setLayout(rw);
    dummy9=new Label(composite3,0);
	dummy9.setText("                                                     ");
	
	final Button save_btn=new Button(composite3,0);		
    save_btn.setText("  SAVE  ");
    final Button modify_btn=new Button(composite3,0);		
	modify_btn.setText(" MODIFY ");
	final Button del_btn=new Button(composite3,0);
	del_btn.setText(" DELETE ");
	 modify_btn.setEnabled(false);
	 del_btn.setEnabled(false);
	save_btn.addSelectionListener(new SelectionAdapter()
	{
		public void widgetSelected(SelectionEvent e) 
		{
			
		 try 
		 {    
			 Class.forName(driver);
		     conn = DriverManager.getConnection(url+dbName,userName,password);
			 PreparedStatement pstmt;
			 Statement st=null;
		     ResultSet rs=null;
		     String str_id = null;
		     st=conn.createStatement();
		     select_strategy_combo_val =select_strategy_combo.getText();
		     String test="select id from strategies where name='"+select_strategy_combo_val+"';";
		     System.out.println("~~~~~~~TEST:"+test);
		     rs= st.executeQuery(test);
		     System.out.println("rs "+rs);
		     while(rs.next()){
		    	 str_id= rs.getString(1);
		     }
		     System.out.println("str_id "+str_id);
			 strategy_template_name_combo_val=strategy_template_combo.getText();
			 strategy_template_name_val=strategy_template_name_txt.getText();
			 
			 TableItem[]  tItemArr=table.getItems();
			 pstmt=(PreparedStatement) conn.prepareStatement
			 ("insert into strategycsvstructure(strategy_id,strategy_name,strategy_template_name," +
		     "column_name,column_nullable,column_datatype,column_size,source, drp_down_id)" +
		     "values(?,?,?,?,?,?,?,?,?);");
			  pstmt.setString(1,str_id);
		      pstmt.setString(2,select_strategy_combo_val);
		      pstmt.setString(3,strategy_template_name_val);
		   
		      int rows=Integer.parseInt(row_no_txt.getText());
		      System.out.println("rows" +rows);
		       for(  int i=0; i < rows;i++)
		       {
		    	   
		    	
		    	   System.out.println("TEst value: "+tItemArr[i]);
		    	  columnName[i] =tItemArr[i].getText(0);
		    	 
		    	  pstmt.setString(4,columnName[i]);
		    	  System.out.println("col name" +tItemArr[i].getText(0));
		    	  
		    	  columnNullable[i] =tItemArr[i].getText(1);

		    		  pstmt.setString(5,columnNullable[i]);
		    	  System.out.println("col null" +tItemArr[i].getText(1));
		    		    	  
		    	  columnDataType[i] =tItemArr[i].getText(2);
		    	 
		    		  pstmt.setString(6,columnDataType[i]);
		    	  System.out.println("col datatype" +tItemArr[i].getText(2));
		    	  
		    	  columnSize[i] =tItemArr[i].getText(3);
		    	
		    		  pstmt.setString(7,columnSize[i]);
		    	  System.out.println("col size" +tItemArr[i].getText(3));
		    	  
		    	  columnSource[i] =tItemArr[i].getText(4);
		    	
		    	  pstmt.setString(8,columnSource[i]);
		    	  System.out.println("col src" +tItemArr[i].getText(4));
		    	  
		    	  columndrp_down_id[i] =tItemArr[i].getText(5);
		    	
		    	  pstmt.setString(9,columndrp_down_id[i]);
		    	  System.out.println("col drpid" +tItemArr[i].getText(5)); 
if(strategy_template_name_txt != null && !strategy_template_name_txt.equals("")  && row_no_txt != null && !row_no_txt.equals("")  && select_strategy_combo != null && !select_strategy_combo.equals("")  && strategy_template_combo != null && !strategy_template_combo.equals("")  && columnName[i] != null && !columnName[i].equals("")  && columnNullable[i] != null && !columnNullable[i].equals("") && columnDataType[i] != null && !columnDataType[i].equals("") && columnSize[i] != null && !columnSize[i].equals("") && columnSource[i] != null && !columnSource[i].equals("")&& columndrp_down_id[i] != null && !columndrp_down_id[i].equals(""))
{	    	  
	 pstmt.execute();	    	  
	 MessageBox messageBox = new MessageBox(shell, SWT.ICON_INFORMATION);
	 messageBox.setMessage("saved");
	 messageBox.open();
	 save_btn.setEnabled(false);
	 modify_btn.setEnabled(true);
	 del_btn.setEnabled(true);
	
	
}
else
{
	MessageBox messageBox = new MessageBox(shell, SWT.ICON_INFORMATION);
	 messageBox.setMessage("Enter correct values and retry saving");
	 messageBox.open();
}
		       } }
		  catch (Exception e2)
			  {
			  e2.printStackTrace();
			  }        
		 }	
		 
});
	
	  table.pack();

	    shell.pack();
			
}
    

[Ranganathan Kaliyur Mannar]

Anita, Welcome to the Ranch!

You have to first write your own TableModel from which you can get the number of rows and all the data. My sugeestion would be to start reading the tutorial about tables.

You have posted code of 400 lines with db code which doesn't really help. You should create a SSCCE and post the code.

[Anita Nair]

thanks..
another question is that one of my column in the table is a droprdownbox based on the value of which i want to hide /show another column.
how do i do this?