5 Replies Latest reply: Oct 7, 2004 3:56 AM by PhHein RSS

    JTABLE PROBLEM

    807587
      Hi all,
      I am new to Java Swing Programming and getting the following problem.I could not able to display the table which I created.I will send my full code,Kindly correct me where I went wrong.The matter is so urgent.Please help.
      ********************
      THE CODING:
      ****************
      package examples;
      import java.awt.*;
      import java.awt.event.*;

      import javax.swing.*;
      import javax.swing.table.*;
      import javax.swing.border.*;
      import javax.swing.event.*;
      import java.sql.*;
      import java.awt.BorderLayout;
      import java.awt.Dimension;

      public class newSSAService extends JFrame
      {
           public JMenuBar menuBar;
           public JToolBar toolBar;
           public JFrame frame;
           private JLabel jLabel1;
           private JLabel jLabel2;
           private JLabel jLabel3;
           private JLabel jLabel4;
           private JLabel jLabel5;
           private JLabel jLabel6;
           private JComboBox jComboBox1;
           private JComboBox jComboBox2;
           private JComboBox jComboBox3;
           private JComboBox jComboBox4;
           private JComboBox jComboBox5;
           private JComboBox jComboBox6;
           //private JTable jTable1;
           //private JScrollPane jScrollPane1;
           public JScrollPane scrollpane;
           
           private JPanel contentPane;
           //String[] gen=new String[] {"Reload AllData","Get Latest Data","Reload Calender","Synchronise Planned Data","User Sections","Exit"};
           String[] edititems=new String[] {"Today","Current Week","Current Month","Current Quarter","Current Year","Current TimeScale"};
           char[] editshortcuts={'D','W','M','Q','Y','U'};
           //from table examples
           private boolean DEBUG=true;
           private int rows=10,cols=10;
           private String url="jdbc:odbc:sadsn";
           private Connection con=null;
           private Statement stmt;
           private JButton Read,Close;
           private String[] colnames={"Service Order","Configuration","Configuration Description","Preferred Engineer","Location","Address","City","Status"};
           private Object[][] data=new Object[rows][cols];
           public JTable table;
           //stopped here...
           public newSSAService()
           {
                super("SSA Service Scheduler");
                initializeComponent();
                this.setVisible(true);
           }

           private void initializeComponent()
           {
                jLabel1 = new JLabel();
                jLabel2 = new JLabel();
                jLabel3 = new JLabel();
                jLabel4 = new JLabel();
                jLabel5 = new JLabel();
                jLabel6 = new JLabel();
                jComboBox1 = new JComboBox();
                jComboBox2 = new JComboBox();
                jComboBox3 = new JComboBox();
                jComboBox4 = new JComboBox();
                jComboBox5 = new JComboBox();
                jComboBox6 = new JComboBox();
                frame=new JFrame();
                //Included here
                JMenuBar menuBar = new JMenuBar();
                JMenu general = new JMenu("General");
           menuBar.add(general);
           ActionListener printListener=new ActionListener()
                {
                public void actionPerformed(ActionEvent event)
                {
                     System.out.println("Menu Item ["+event.getActionCommand()+"] was pressed");
                }
                };
           JMenuItem useritem;
           JMenu NewView=new JMenu("New View");
           NewView.add(useritem=new JMenuItem("Service Order By Engineers"));
           NewView.add(useritem=new JMenuItem("Service Order By Configuration"));
           NewView.add(useritem=new JMenuItem("Activities By Engineer"));
           NewView.add(useritem=new JMenuItem("Activities By Objects"));
           NewView.add(useritem=new JMenuItem("Planned Activities By Configuration"));
           NewView.add(useritem=new JMenuItem("Planned Activities By Objects"));
           useritem.addActionListener(printListener);
           general.add(NewView);

           //general.add("New View");
           general.add("Record All Data");
           general.add("Get Latest Data");
           general.add("Record Calendar");
           general.add("Synchronise Planning Data");
           JMenuItem userset;
           JMenu User=new JMenu("User Settings");
           User.add(userset=new JMenuItem("Modify"));
           User.add(useritem=new JMenuItem("Create/Delete"));
           User.add(useritem=new JMenuItem("Save"));
           User.addActionListener(printListener);
           general.add(User);
           
           general.add("Exit");
                          
                
           JMenu actions =new JMenu("Actions");
           menuBar.add(actions);
           actions.add("Cut");
           actions.add("Copy");
           actions.add("Paste");
           actions.add("Find");
           actions.add("Interrupt");
           actions.add("Remove Interruption");
           actions.add("Appointment");
           actions.add("Remove Appointment");
           actions.add("Unassigned");
           actions.add("Release");
           actions.add("Transfer");
           
           
           JMenu view=new JMenu("View");
           menuBar.add(view);
           view.add("Service Order By Engineer");
           view.add("Service Order By Configuration");
           view.add("Activities By Engineer");
           view.add("Activities By Objects");
           view.add("Planned Activities By Configuration");
           view.add("Planned Activities By Objects");
           view.add("Activities By Order");
           
           JMenu Timescale=new JMenu("TimeScale");
           for(int i=0;i<edititems.length;i++)
           {
                JMenuItem item=new JMenuItem(edititems);
                item.setAccelerator(KeyStroke.getKeyStroke(editshortcuts[i],
                          Toolkit.getDefaultToolkit().getMenuShortcutKeyMask(),false));
                item.addActionListener(printListener);
           Timescale.add(item);
           }
           menuBar.add(Timescale);
           
           
           JMenu start=new JMenu("Start");
           menuBar.add(start);
           start.add("Create/Check/Modify Call");
           start.add("Service Order");
           start.add("Planned Activities");
           JMenuItem planningitem;
           JMenu Planning=new JMenu("Planning");
           Planning.add(planningitem=new JMenuItem("Global SRP"));
           Planning.add(planningitem=new JMenuItem("Detail SRP"));
           start.add(Planning);
           
           start.add("Calendars");
           start.add("Service Order Activities");
           start.add("Order Details");
           start.add("Activity");
           start.add("Material Requirement Lines");
           start.add("Labour Requirement Lines");
           start.add("Other Requirement Lines");
           start.add("Skills");
           start.add("DEM Browser");
           
           JMenuItem serviceitem;
           JMenu Service=new JMenu("Service Scheduler Assistant");
           Service.add(serviceitem=new JMenuItem("Global Schedule"));
           Service.add(serviceitem=new JMenuItem("Global Service Order"));
           Service.add(serviceitem=new JMenuItem("Global Activation"));
           start.add(Service);
                
           JMenu options=new JMenu("Options");
           menuBar.add(options);
           options.add("Colors");
           //options.add("Color Procedure");
           JMenuItem coloritem;
           JMenu Colorprocedure=new JMenu("Color Procedure");
           Colorprocedure.add(coloritem=new JMenuItem("Status"));
           //Colorprocedure.add(coloritem=new JMenuItem("Priority Time Scale"));
           JMenuItem subitem;
           JMenu submenu=new JMenu("Priority Time Scale");
           submenu.add(subitem=new JMenuItem("Planning Start Time"));
           submenu.add(subitem=new JMenuItem("Planning Finish Time"));
           submenu.add(subitem=new JMenuItem("Latest Finish Time"));
           submenu.add(subitem=new JMenuItem("Earliest Start Time"));
           
           Colorprocedure.add(submenu);
           options.add(Colorprocedure);     
           Colorprocedure.add(coloritem=new JMenuItem("Service Type"));
           
           options.add("Capacity Calculator");
           options.add("Tool Tips");
           options.add("Sort Unassigned View");
           options.add("Order Progress");
           options.add("OverTime Information");
           options.add("Flashing");
           
           
           JMenu help=new JMenu("Help");
           menuBar.add(help);
           help.add("Help");
           help.add("About SSA Service Scheduler");
           
           //JFrame.setDefaultLookAndFeelDecorated(true);
           setJMenuBar(menuBar);
           //frame.pack();
           //frame.setVisible(true);
           
           toolBar = new JToolBar("Formatting");
           toolBar.addSeparator();

                //Before this included new
                /*String columnNames[] = { "ColorStatus", "Flash", "Service Order","Configuration","Configuration Description"};

                // Create some data
                String dataValues[][] =
                {
                     { "blue", "flash", "ORT001" },
                     { "AVCONF", "av configuration with warrenty"}
                };
      */
                //from tableexample.java
                try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      } catch(java.lang.ClassNotFoundException e) {
      System.err.print("ClassNotFoundException: ");
      System.err.println(e.getMessage());
      }
                table=new JTable(data,colnames);
                table.setPreferredScrollableViewportSize(new Dimension(900,500));
                table.setColumnSelectionAllowed(false);
                table.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
                
                //table.setAutoResizeMode(JTable.)
                //cellSelectionEnabled(false);
                populateTable();
                //finished here..
                // OLD Create a new table instance
                
                //jTable1 = new JTable(dataValues,columnNames);..OLD//
                          
                //jScrollPane1 = new JScrollPane(table);
                //Started again copying here..
                if(DEBUG)
                {
                     table.addMouseListener(new MouseAdapter()
                     {
                          public void MouseClicked(MouseEvent e)
                          {
                               //printDebugData();
                          }
                     });
                }
                
                JLabel title=new JLabel("Unassigned Queue");
                title.setFont(new java.awt.Font("Arial",1,30));
                title.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
                add("North",title);
                
                scrollpane=new JScrollPane(table);
                add("Center",scrollpane);
                
                //JPanel buttons=new JPanel();
                //Read=new JButton("Read");
                //Close=new JButton("Close");
                //Read.addActionListener(new ActionListener() {
      // public void actionPerformed(ActionEvent evt) {
      // populateTable();
      // }
      //});
                //Close.addActionListener(new ActionListener()
                     //     {
                     //public void actionPerformed(ActionEvent evt)
                //     {
                     //     System.out.println("Thanks for using it");
                          //System.exit(0);
                          
                     //}
                //     });
                //buttons.add(Read);
                //buttons.add(Close);
                //add("South",buttons);
           }
           public void populateTable()
           {
           String query="SELECT * FROM ServiceOrder";
           javax.swing.table.TableModel model=table.getModel();
           int r=0;
           try
           {
                con=DriverManager.getConnection(url,"sa","ekb");
                stmt=con.createStatement();
                ResultSet rs=stmt.executeQuery(query);
                while((rs.next()) && (r<rows))
                {
                     Object so=rs.getObject("ServiceOrder");
                     Object co=rs.getObject("confgn");
                     Object code=rs.getObject("confgndesc");
                     Object preengr=rs.getObject("preengr");
                     Object loc=rs.getObject("Loc");
                     Object addr=rs.getObject("addr");
                     Object city=rs.getObject("city");
                     Object status=rs.getObject("status");
                     
                     
                     model.setValueAt(so,r,0);
                     model.setValueAt(co,r,1);
                     model.setValueAt(code,r,2);
                     model.setValueAt(preengr,r,3);
                     model.setValueAt(loc,r,4);
                     model.setValueAt(addr,r,5);
                     model.setValueAt(city,r,6);
                     model.setValueAt(status,r,7);
                     
                     r++;
                     
                }
                stmt.close();
                con.close();
           }catch(SQLException e)
           {
                System.err.println("SQLException"+e.getMessage());
           }
           
      //Stopped here copying....
                          
                contentPane = (JPanel)this.getContentPane();
                //jLabel1
                jLabel1.setText("ServiceCentre");
                //
                // jLabel2
                //
                jLabel2.setText("ServiceArea");
                //
                // jLabel4
                //
                jLabel3.setText("Skills");
                jLabel4.setText("AvailableType");
                //
                // jLabel5
                //
                jLabel5.setText("From Date");
                //
                // jLabel6
                //
                jLabel6.setText("To");
                //
                // jComboBox1
                //
                jComboBox1.addItem("Coimbatore");
                jComboBox1.addItem("Chennai");
                jComboBox1.addItem("Mumbai");
                jComboBox1.addItem("New Delhi");
                jComboBox1.addActionListener(new ActionListener() {
                     public void actionPerformed(ActionEvent e)
                     {
                          jComboBox1_actionPerformed(e);
                     }

                });
                //
                // jComboBox2
                //
                jComboBox2.addItem("North Zone");
                jComboBox2.addItem("South Zone");
                jComboBox2.addItem("Central Zone");
                jComboBox2.addItem("Eastern Zone");
                jComboBox2.addItem("Western Zone");
                jComboBox2.addActionListener(new ActionListener() {
                     public void actionPerformed(ActionEvent e)
                     {
                          jComboBox2_actionPerformed(e);
                     }

                });
                //
                // jComboBox3
                //
                jComboBox3.addItem("Microsoft Components");
                jComboBox3.addItem("Java Technologies");
                jComboBox3.addItem("ERP");
                jComboBox3.addItem("Others");
                jComboBox3.addActionListener(new ActionListener() {
                     public void actionPerformed(ActionEvent e)
                     {
                          jComboBox3_actionPerformed(e);
                     }

                });
                //
                // jComboBox4
                //
                jComboBox4.addItem("One");
                jComboBox4.addItem("Two");
                jComboBox4.addItem("Three");
                jComboBox4.addItem("Four");
                jComboBox4.addItem("Five");
                jComboBox4.addActionListener(new ActionListener() {
                     public void actionPerformed(ActionEvent e)
                     {
                          jComboBox4_actionPerformed(e);
                     }

                });
                //
                // jComboBox5
                //
                jComboBox5.addItem("12/11/2004");
                jComboBox5.addItem("13/11/2004");
                jComboBox5.addItem("14/11/2004");
                jComboBox5.setEditable(true);
                jComboBox5.addActionListener(new ActionListener() {
                     public void actionPerformed(ActionEvent e)
                     {
                          jComboBox5_actionPerformed(e);
                     }

                });
                //
                // jComboBox6
                //
                jComboBox6.addItem("12/12/2004");
                jComboBox6.addItem("13/12/2004");
                jComboBox6.addItem("14/12/2004");
                jComboBox6.setEditable(true);
                jComboBox6.addActionListener(new ActionListener() {
                     public void actionPerformed(ActionEvent e)
                     {
                          jComboBox6_actionPerformed(e);
                     }

                });
                //
                // jTable1
                //
                table.setModel(new DefaultTableModel(4, 4));
                //
                // jScrollPane1
                //
                scrollpane.setViewportView(table);
                //jScrollPane1.setViewportView(table);
                //
                // contentPane
                //
                contentPane.setLayout(null);
                addComponent(contentPane, jLabel1, 2,29,84,18);
                addComponent(contentPane, jLabel2, 207,33,76,18);
                addComponent(contentPane, jLabel3, 382,32,59,18);
                addComponent(contentPane, jLabel4, 2,79,85,18);
                addComponent(contentPane, jLabel5, 197,79,84,18);
                addComponent(contentPane, jLabel6, 384,80,60,18);
                addComponent(contentPane, jComboBox1, 89,32,100,22);
                addComponent(contentPane, jComboBox2, 278,32,100,22);
                addComponent(contentPane, jComboBox3, 424,30,100,22);
                addComponent(contentPane, jComboBox4, 102,76,100,22);
                addComponent(contentPane, jComboBox5, 276,79,100,22);
                addComponent(contentPane, jComboBox6, 421,78,100,22);
                //addComponent(contentPane, jScrollPane1, 33,158,504,170);
                addComponent(contentPane, scrollpane, 33,158,504,170);
                          
                this.setTitle("SSA Service Scheduler");
                this.setLocation(new Point(0, 0));
                this.setSize(new Dimension(560, 485));
           }

           /** Add Component Without a Layout Manager (Absolute Positioning) */
           private void addComponent(Container container,Component c,int x,int y,int width,int height)
           {
                c.setBounds(x,y,width,height);
                container.add(c);
           }
           private void jComboBox1_actionPerformed(ActionEvent e)
           {
                int index = jComboBox1.getSelectedIndex();
                switch(index)
                {
                     case 0: System.out.println("Area Coimbatore Selected "); break;
                     case 1: System.out.println("Area Chennai selected"); break;
                     case 2: System.out.println("Mumbai being selected"); break;
                     case 3: System.out.println("New Delhi being selected"); break;
                }
           }

           private void jComboBox2_actionPerformed(ActionEvent e)
           {
                int index = jComboBox2.getSelectedIndex();
                switch(index)
                {
                     case 0: System.out.println("North Zone Selcted "); break;
                     case 1: System.out.println("South Zone being selected"); break;
                     case 2: System.out.println("Central Zone being selected"); break;
                     case 3: System.out.println("Eastern Zone being selected"); break;
                     case 4: System.out.println("Western Zone being selected"); break;
                }
           }

           private void jComboBox3_actionPerformed(ActionEvent e)
           {
                int index = jComboBox3.getSelectedIndex();
                switch(index)
                {
                     case 0: System.out.println("Microsoft Components being selected"); break;
                     case 1: System.out.println("Java Technologies being selected"); break;
                     case 2: System.out.println("ERP Tehnologies being selected"); break;
                     case 3: System.out.println("Other's selected"); break;
                }
           }

           private void jComboBox4_actionPerformed(ActionEvent e)
           {
                int index = jComboBox4.getSelectedIndex();
                switch(index)
                {
                     case 0: System.out.println("One selected"); break;
                     case 1: System.out.println("Two selected"); break;
                     case 2: System.out.println("Three selected"); break;
                     case 3: System.out.println("Four selected"); break;
                     case 4: System.out.println("Five selected"); break;
                }
           }

           private void jComboBox5_actionPerformed(ActionEvent e)
           {
                int index = jComboBox5.getSelectedIndex();
                switch(index)
                {
                     case 0: System.out.println("12/12/2004 being selected"); break;
                     case 1: System.out.println("13/12/2004 being selected"); break;
                     case 2: System.out.println("14/12/2004 being selected"); break;
                }
           }

           private void jComboBox6_actionPerformed(ActionEvent e)
           {
                int index = jComboBox6.getSelectedIndex();
                switch(index)
                {
                     case 0: System.out.println("12/11/2004 being selected"); break;
                     case 1: System.out.println("13/11/2004 being selected"); break;
                     case 2: System.out.println("14/11/2004 being selected"); break;
                }
           }
           public static void main(String[] args)
           {
                SSAService ssa=new SSAService();
                /*JFrame.setDefaultLookAndFeelDecorated(true);
                JFrame frame=new JFrame("UnAssigned Queue Values");
                frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
                frame.setContentPane(ssa);*/
                //JFrame.setDefaultLookAndFeelDecorated(true);
                //JDialog.setDefaultLookAndFeelDecorated(true);
                //JFrame frame = new JFrame("SSA Service Scheduler");
      //frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
      //frame.setJMenuBar(ssa.menuBar);
      //frame.getContentPane( ).add(ssa.toolBar, BorderLayout.NORTH);
      //frame.getContentPane( ).add(ssa.pane, BorderLayout.CENTER);
      //frame.pack( );
      //frame.setVisible(true);
                try
                {
                     //UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
                     //UIManager.setLookAndFeel("javax.swing.plaf.metal.MetalLookAndFeel");
                     UIManager.setLookAndFeel("com.sun.java.swing.plaf.motif.MotifLookAndFeel");
                }
                catch (Exception ex)
                {
                     System.out.println("Failed loading L&F: ");
                     System.out.println(ex);
                }
           }

      }


      SORRY FOR THE BIG CODING.PLEASE HELP ME.

      Thanks in advance
      With kind Regds
      Satheesh.K
        • 1. Re: JTABLE PROBLEM
          PhHein
          When you post code, please use [code] and [/code] tags as described in Formatting Help on the message entry page. It makes it much easier to read.

          • 2. Re: JTABLE PROBLEM
            807587
            OK Sorry I will do it now.Can u help me,Please to find out the solution.
            <code>
            package examples;
            import java.awt.*;
            import java.awt.event.*;

            import javax.swing.*;
            import javax.swing.table.*;
            import javax.swing.border.*;
            import javax.swing.event.*;
            import java.sql.*;
            import java.awt.BorderLayout;
            import java.awt.Dimension;

            public class newSSAService extends JFrame
            {
                 public JMenuBar menuBar;
                 public JToolBar toolBar;
                 public JFrame frame;
                 private JLabel jLabel1;
                 private JLabel jLabel2;
                 private JLabel jLabel3;
                 private JLabel jLabel4;
                 private JLabel jLabel5;
                 private JLabel jLabel6;
                 private JComboBox jComboBox1;
                 private JComboBox jComboBox2;
                 private JComboBox jComboBox3;
                 private JComboBox jComboBox4;
                 private JComboBox jComboBox5;
                 private JComboBox jComboBox6;
                 //private JTable jTable1;
                 //private JScrollPane jScrollPane1;
                 public JScrollPane scrollpane;
                 
                 private JPanel contentPane;
                 //String[] gen=new String[] {"Reload AllData","Get Latest Data","Reload Calender","Synchronise Planned Data","User Sections","Exit"};
                 String[] edititems=new String[] {"Today","Current Week","Current Month","Current Quarter","Current Year","Current TimeScale"};
                 char[] editshortcuts={'D','W','M','Q','Y','U'};
                 //from table examples
                 private boolean DEBUG=true;
                 private int rows=10,cols=10;
                 private String url="jdbc:odbc:sadsn";
                 private Connection con=null;
                 private Statement stmt;
                 private JButton Read,Close;
                 private String[] colnames={"Service Order","Configuration","Configuration Description","Preferred Engineer","Location","Address","City","Status"};
                 private Object[][] data=new Object[rows][cols];
                 public JTable table;
                 //stopped here...
                 public newSSAService()
                 {
                      super("SSA Service Scheduler");
                      initializeComponent();
                      this.setVisible(true);
                 }

                 private void initializeComponent()
                 {
                      jLabel1 = new JLabel();
                      jLabel2 = new JLabel();
                      jLabel3 = new JLabel();
                      jLabel4 = new JLabel();
                      jLabel5 = new JLabel();
                      jLabel6 = new JLabel();
                      jComboBox1 = new JComboBox();
                      jComboBox2 = new JComboBox();
                      jComboBox3 = new JComboBox();
                      jComboBox4 = new JComboBox();
                      jComboBox5 = new JComboBox();
                      jComboBox6 = new JComboBox();
                      frame=new JFrame();
                      //Included here
                      JMenuBar menuBar = new JMenuBar();
                      JMenu general = new JMenu("General");
                 menuBar.add(general);
                 ActionListener printListener=new ActionListener()
                      {
                      public void actionPerformed(ActionEvent event)
                      {
                           System.out.println("Menu Item ["+event.getActionCommand()+"] was pressed");
                      }
                      };
                 JMenuItem useritem;
                 JMenu NewView=new JMenu("New View");
                 NewView.add(useritem=new JMenuItem("Service Order By Engineers"));
                 NewView.add(useritem=new JMenuItem("Service Order By Configuration"));
                 NewView.add(useritem=new JMenuItem("Activities By Engineer"));
                 NewView.add(useritem=new JMenuItem("Activities By Objects"));
                 NewView.add(useritem=new JMenuItem("Planned Activities By Configuration"));
                 NewView.add(useritem=new JMenuItem("Planned Activities By Objects"));
                 useritem.addActionListener(printListener);
                 general.add(NewView);

                 //general.add("New View");
                 general.add("Record All Data");
                 general.add("Get Latest Data");
                 general.add("Record Calendar");
                 general.add("Synchronise Planning Data");
                 JMenuItem userset;
                 JMenu User=new JMenu("User Settings");
                 User.add(userset=new JMenuItem("Modify"));
                 User.add(useritem=new JMenuItem("Create/Delete"));
                 User.add(useritem=new JMenuItem("Save"));
                 User.addActionListener(printListener);
                 general.add(User);
                 
                 general.add("Exit");
                                
                      
                 JMenu actions =new JMenu("Actions");
                 menuBar.add(actions);
                 actions.add("Cut");
                 actions.add("Copy");
                 actions.add("Paste");
                 actions.add("Find");
                 actions.add("Interrupt");
                 actions.add("Remove Interruption");
                 actions.add("Appointment");
                 actions.add("Remove Appointment");
                 actions.add("Unassigned");
                 actions.add("Release");
                 actions.add("Transfer");
                 
                 
                 JMenu view=new JMenu("View");
                 menuBar.add(view);
                 view.add("Service Order By Engineer");
                 view.add("Service Order By Configuration");
                 view.add("Activities By Engineer");
                 view.add("Activities By Objects");
                 view.add("Planned Activities By Configuration");
                 view.add("Planned Activities By Objects");
                 view.add("Activities By Order");
                 
                 JMenu Timescale=new JMenu("TimeScale");
                 for(int i=0;i<edititems.length;i++)
                 {
                      JMenuItem item=new JMenuItem(edititems);
                      item.setAccelerator(KeyStroke.getKeyStroke(editshortcuts[i],
                                Toolkit.getDefaultToolkit().getMenuShortcutKeyMask(),false));
                      item.addActionListener(printListener);
                 Timescale.add(item);
                 }
                 menuBar.add(Timescale);
                 
                 
                 JMenu start=new JMenu("Start");
                 menuBar.add(start);
                 start.add("Create/Check/Modify Call");
                 start.add("Service Order");
                 start.add("Planned Activities");
                 JMenuItem planningitem;
                 JMenu Planning=new JMenu("Planning");
                 Planning.add(planningitem=new JMenuItem("Global SRP"));
                 Planning.add(planningitem=new JMenuItem("Detail SRP"));
                 start.add(Planning);
                 
                 start.add("Calendars");
                 start.add("Service Order Activities");
                 start.add("Order Details");
                 start.add("Activity");
                 start.add("Material Requirement Lines");
                 start.add("Labour Requirement Lines");
                 start.add("Other Requirement Lines");
                 start.add("Skills");
                 start.add("DEM Browser");
                 
                 JMenuItem serviceitem;
                 JMenu Service=new JMenu("Service Scheduler Assistant");
                 Service.add(serviceitem=new JMenuItem("Global Schedule"));
                 Service.add(serviceitem=new JMenuItem("Global Service Order"));
                 Service.add(serviceitem=new JMenuItem("Global Activation"));
                 start.add(Service);
                      
                 JMenu options=new JMenu("Options");
                 menuBar.add(options);
                 options.add("Colors");
                 //options.add("Color Procedure");
                 JMenuItem coloritem;
                 JMenu Colorprocedure=new JMenu("Color Procedure");
                 Colorprocedure.add(coloritem=new JMenuItem("Status"));
                 //Colorprocedure.add(coloritem=new JMenuItem("Priority Time Scale"));
                 JMenuItem subitem;
                 JMenu submenu=new JMenu("Priority Time Scale");
                 submenu.add(subitem=new JMenuItem("Planning Start Time"));
                 submenu.add(subitem=new JMenuItem("Planning Finish Time"));
                 submenu.add(subitem=new JMenuItem("Latest Finish Time"));
                 submenu.add(subitem=new JMenuItem("Earliest Start Time"));
                 
                 Colorprocedure.add(submenu);
                 options.add(Colorprocedure);     
                 Colorprocedure.add(coloritem=new JMenuItem("Service Type"));
                 
                 options.add("Capacity Calculator");
                 options.add("Tool Tips");
                 options.add("Sort Unassigned View");
                 options.add("Order Progress");
                 options.add("OverTime Information");
                 options.add("Flashing");
                 
                 
                 JMenu help=new JMenu("Help");
                 menuBar.add(help);
                 help.add("Help");
                 help.add("About SSA Service Scheduler");
                 
                 //JFrame.setDefaultLookAndFeelDecorated(true);
                 setJMenuBar(menuBar);
                 //frame.pack();
                 //frame.setVisible(true);
                 
                 toolBar = new JToolBar("Formatting");
                 toolBar.addSeparator();

                      //Before this included new
                      /*String columnNames[] = { "ColorStatus", "Flash", "Service Order","Configuration","Configuration Description"};

                      // Create some data
                      String dataValues[][] =
                      {
                           { "blue", "flash", "ORT001" },
                           { "AVCONF", "av configuration with warrenty"}
                      };
            */
                      //from tableexample.java
                      try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            } catch(java.lang.ClassNotFoundException e) {
            System.err.print("ClassNotFoundException: ");
            System.err.println(e.getMessage());
            }
                      table=new JTable(data,colnames);
                      table.setPreferredScrollableViewportSize(new Dimension(900,500));
                      table.setColumnSelectionAllowed(false);
                      table.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
                      
                      //table.setAutoResizeMode(JTable.)
                      //cellSelectionEnabled(false);
                      populateTable();
                      //finished here..
                      // OLD Create a new table instance
                      
                      //jTable1 = new JTable(dataValues,columnNames);..OLD//
                                
                      //jScrollPane1 = new JScrollPane(table);
                      //Started again copying here..
                      if(DEBUG)
                      {
                           table.addMouseListener(new MouseAdapter()
                           {
                                public void MouseClicked(MouseEvent e)
                                {
                                     //printDebugData();
                                }
                           });
                      }
                      
                      JLabel title=new JLabel("Unassigned Queue");
                      title.setFont(new java.awt.Font("Arial",1,30));
                      title.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
                      add("North",title);
                      
                      scrollpane=new JScrollPane(table);
                      add("Center",scrollpane);
                      
                      //JPanel buttons=new JPanel();
                      //Read=new JButton("Read");
                      //Close=new JButton("Close");
                      //Read.addActionListener(new ActionListener() {
            // public void actionPerformed(ActionEvent evt) {
            // populateTable();
            // }
            //});
                      //Close.addActionListener(new ActionListener()
                           //     {
                           //public void actionPerformed(ActionEvent evt)
                      //     {
                           //     System.out.println("Thanks for using it");
                                //System.exit(0);
                                
                           //}
                      //     });
                      //buttons.add(Read);
                      //buttons.add(Close);
                      //add("South",buttons);
                 }
                 public void populateTable()
                 {
                 String query="SELECT * FROM ServiceOrder";
                 javax.swing.table.TableModel model=table.getModel();
                 int r=0;
                 try
                 {
                      con=DriverManager.getConnection(url,"sa","ekb");
                      stmt=con.createStatement();
                      ResultSet rs=stmt.executeQuery(query);
                      while((rs.next()) && (r<rows))
                      {
                           Object so=rs.getObject("ServiceOrder");
                           Object co=rs.getObject("confgn");
                           Object code=rs.getObject("confgndesc");
                           Object preengr=rs.getObject("preengr");
                           Object loc=rs.getObject("Loc");
                           Object addr=rs.getObject("addr");
                           Object city=rs.getObject("city");
                           Object status=rs.getObject("status");
                           
                           
                           model.setValueAt(so,r,0);
                           model.setValueAt(co,r,1);
                           model.setValueAt(code,r,2);
                           model.setValueAt(preengr,r,3);
                           model.setValueAt(loc,r,4);
                           model.setValueAt(addr,r,5);
                           model.setValueAt(city,r,6);
                           model.setValueAt(status,r,7);
                           
                           r++;
                           
                      }
                      stmt.close();
                      con.close();
                 }catch(SQLException e)
                 {
                      System.err.println("SQLException"+e.getMessage());
                 }
                 
            //Stopped here copying....
                                
                      contentPane = (JPanel)this.getContentPane();
                      //jLabel1
                      jLabel1.setText("ServiceCentre");
                      //
                      // jLabel2
                      //
                      jLabel2.setText("ServiceArea");
                      //
                      // jLabel4
                      //
                      jLabel3.setText("Skills");
                      jLabel4.setText("AvailableType");
                      //
                      // jLabel5
                      //
                      jLabel5.setText("From Date");
                      //
                      // jLabel6
                      //
                      jLabel6.setText("To");
                      //
                      // jComboBox1
                      //
                      jComboBox1.addItem("Coimbatore");
                      jComboBox1.addItem("Chennai");
                      jComboBox1.addItem("Mumbai");
                      jComboBox1.addItem("New Delhi");
                      jComboBox1.addActionListener(new ActionListener() {
                           public void actionPerformed(ActionEvent e)
                           {
                                jComboBox1_actionPerformed(e);
                           }

                      });
                      //
                      // jComboBox2
                      //
                      jComboBox2.addItem("North Zone");
                      jComboBox2.addItem("South Zone");
                      jComboBox2.addItem("Central Zone");
                      jComboBox2.addItem("Eastern Zone");
                      jComboBox2.addItem("Western Zone");
                      jComboBox2.addActionListener(new ActionListener() {
                           public void actionPerformed(ActionEvent e)
                           {
                                jComboBox2_actionPerformed(e);
                           }

                      });
                      //
                      // jComboBox3
                      //
                      jComboBox3.addItem("Microsoft Components");
                      jComboBox3.addItem("Java Technologies");
                      jComboBox3.addItem("ERP");
                      jComboBox3.addItem("Others");
                      jComboBox3.addActionListener(new ActionListener() {
                           public void actionPerformed(ActionEvent e)
                           {
                                jComboBox3_actionPerformed(e);
                           }

                      });
                      //
                      // jComboBox4
                      //
                      jComboBox4.addItem("One");
                      jComboBox4.addItem("Two");
                      jComboBox4.addItem("Three");
                      jComboBox4.addItem("Four");
                      jComboBox4.addItem("Five");
                      jComboBox4.addActionListener(new ActionListener() {
                           public void actionPerformed(ActionEvent e)
                           {
                                jComboBox4_actionPerformed(e);
                           }

                      });
                      //
                      // jComboBox5
                      //
                      jComboBox5.addItem("12/11/2004");
                      jComboBox5.addItem("13/11/2004");
                      jComboBox5.addItem("14/11/2004");
                      jComboBox5.setEditable(true);
                      jComboBox5.addActionListener(new ActionListener() {
                           public void actionPerformed(ActionEvent e)
                           {
                                jComboBox5_actionPerformed(e);
                           }

                      });
                      //
                      // jComboBox6
                      //
                      jComboBox6.addItem("12/12/2004");
                      jComboBox6.addItem("13/12/2004");
                      jComboBox6.addItem("14/12/2004");
                      jComboBox6.setEditable(true);
                      jComboBox6.addActionListener(new ActionListener() {
                           public void actionPerformed(ActionEvent e)
                           {
                                jComboBox6_actionPerformed(e);
                           }

                      });
                      //
                      // jTable1
                      //
                      table.setModel(new DefaultTableModel(4, 4));
                      //
                      // jScrollPane1
                      //
                      scrollpane.setViewportView(table);
                      //jScrollPane1.setViewportView(table);
                      //
                      // contentPane
                      //
                      contentPane.setLayout(null);
                      addComponent(contentPane, jLabel1, 2,29,84,18);
                      addComponent(contentPane, jLabel2, 207,33,76,18);
                      addComponent(contentPane, jLabel3, 382,32,59,18);
                      addComponent(contentPane, jLabel4, 2,79,85,18);
                      addComponent(contentPane, jLabel5, 197,79,84,18);
                      addComponent(contentPane, jLabel6, 384,80,60,18);
                      addComponent(contentPane, jComboBox1, 89,32,100,22);
                      addComponent(contentPane, jComboBox2, 278,32,100,22);
                      addComponent(contentPane, jComboBox3, 424,30,100,22);
                      addComponent(contentPane, jComboBox4, 102,76,100,22);
                      addComponent(contentPane, jComboBox5, 276,79,100,22);
                      addComponent(contentPane, jComboBox6, 421,78,100,22);
                      //addComponent(contentPane, jScrollPane1, 33,158,504,170);
                      addComponent(contentPane, scrollpane, 33,158,504,170);
                                
                      this.setTitle("SSA Service Scheduler");
                      this.setLocation(new Point(0, 0));
                      this.setSize(new Dimension(560, 485));
                 }

                 /** Add Component Without a Layout Manager (Absolute Positioning) */
                 private void addComponent(Container container,Component c,int x,int y,int width,int height)
                 {
                      c.setBounds(x,y,width,height);
                      container.add(c);
                 }
                 private void jComboBox1_actionPerformed(ActionEvent e)
                 {
                      int index = jComboBox1.getSelectedIndex();
                      switch(index)
                      {
                           case 0: System.out.println("Area Coimbatore Selected "); break;
                           case 1: System.out.println("Area Chennai selected"); break;
                           case 2: System.out.println("Mumbai being selected"); break;
                           case 3: System.out.println("New Delhi being selected"); break;
                      }
                 }

                 private void jComboBox2_actionPerformed(ActionEvent e)
                 {
                      int index = jComboBox2.getSelectedIndex();
                      switch(index)
                      {
                           case 0: System.out.println("North Zone Selcted "); break;
                           case 1: System.out.println("South Zone being selected"); break;
                           case 2: System.out.println("Central Zone being selected"); break;
                           case 3: System.out.println("Eastern Zone being selected"); break;
                           case 4: System.out.println("Western Zone being selected"); break;
                      }
                 }

                 private void jComboBox3_actionPerformed(ActionEvent e)
                 {
                      int index = jComboBox3.getSelectedIndex();
                      switch(index)
                      {
                           case 0: System.out.println("Microsoft Components being selected"); break;
                           case 1: System.out.println("Java Technologies being selected"); break;
                           case 2: System.out.println("ERP Tehnologies being selected"); break;
                           case 3: System.out.println("Other's selected"); break;
                      }
                 }

                 private void jComboBox4_actionPerformed(ActionEvent e)
                 {
                      int index = jComboBox4.getSelectedIndex();
                      switch(index)
                      {
                           case 0: System.out.println("One selected"); break;
                           case 1: System.out.println("Two selected"); break;
                           case 2: System.out.println("Three selected"); break;
                           case 3: System.out.println("Four selected"); break;
                           case 4: System.out.println("Five selected"); break;
                      }
                 }

                 private void jComboBox5_actionPerformed(ActionEvent e)
                 {
                      int index = jComboBox5.getSelectedIndex();
                      switch(index)
                      {
                           case 0: System.out.println("12/12/2004 being selected"); break;
                           case 1: System.out.println("13/12/2004 being selected"); break;
                           case 2: System.out.println("14/12/2004 being selected"); break;
                      }
                 }

                 private void jComboBox6_actionPerformed(ActionEvent e)
                 {
                      int index = jComboBox6.getSelectedIndex();
                      switch(index)
                      {
                           case 0: System.out.println("12/11/2004 being selected"); break;
                           case 1: System.out.println("13/11/2004 being selected"); break;
                           case 2: System.out.println("14/11/2004 being selected"); break;
                      }
                 }
                 public static void main(String[] args)
                 {
                      SSAService ssa=new SSAService();
                      /*JFrame.setDefaultLookAndFeelDecorated(true);
                      JFrame frame=new JFrame("UnAssigned Queue Values");
                      frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
                      frame.setContentPane(ssa);*/
                      //JFrame.setDefaultLookAndFeelDecorated(true);
                      //JDialog.setDefaultLookAndFeelDecorated(true);
                      //JFrame frame = new JFrame("SSA Service Scheduler");
            //frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
            //frame.setJMenuBar(ssa.menuBar);
            //frame.getContentPane( ).add(ssa.toolBar, BorderLayout.NORTH);
            //frame.getContentPane( ).add(ssa.pane, BorderLayout.CENTER);
            //frame.pack( );
            //frame.setVisible(true);
                      try
                      {
                           //UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
                           //UIManager.setLookAndFeel("javax.swing.plaf.metal.MetalLookAndFeel");
                           UIManager.setLookAndFeel("com.sun.java.swing.plaf.motif.MotifLookAndFeel");
                      }
                      catch (Exception ex)
                      {
                           System.out.println("Failed loading L&F: ");
                           System.out.println(ex);
                      }
                 }

            }
            </code>

            Please help me.
            Thanks in Advance

            • 3. Re: JTABLE PROBLEM
              PhHein
              OK, the tags are [co[i]de] and [co[i]de]!

              I've changed three lines in initializeComponent:
              getContentPane().add("North", title);  // <- HERE
              scrollpane = new JScrollPane(table);   // <- HERE
              getContentPane().add("Center", scrollpane); // <- HERE
              Note that you won't see your table unless data are inserted.
              • 4. Re: JTABLE PROBLEM
                807587
                Sir,
                I changed these codes and then tried to execute.I also have values in Database.It is not displaying.If I have the logic for table program in a seperate program it is executing.Kindly suggest me what could be the problem.Did I went wrong in adding the table.VERY URGENT

                Thanks a lot for your patience,
                • 5. Re: JTABLE PROBLEM
                  PhHein
                  Yep, in populateTable():
                  String query = "SELECT * FROM ServiceOrder";
                            DefaultTableModel model = new DefaultTableModel(colnames,0); // new Model
                            table.setModel(model); // set model
                            
                            int r = 0;
                            try {
                                 con = DriverManager.getConnection(url, "sa", "ekb");
                                 stmt = con.createStatement();
                                 ResultSet rs = stmt.executeQuery(query);
                                 while ((rs.next())) {
                                      Vector row = new Vector(); // row object
                                      row.add(rs.getObject("ServiceOrder"));
                                      row.add(rs.getObject("confgn"));
                                      row.add(rs.getObject("confgndesc"));
                                      row.add(rs.getObject("preengr"));
                                      row.add(rs.getObject("Loc"));
                                      row.add(rs.getObject("addr"));
                                      row.add(rs.getObject("city"));
                                      row.add(rs.getObject("status"));
                                      model.addRow(row); // add row to model
                                 } 
                                 model.fireTableDataChanged();  // notify of changes
                                 stmt.close();
                                 con.close();
                            } catch (SQLException e) {
                                 System.err.println("SQLException" + e.getMessage());
                            }
                  ....
                  and in initializeComponent()
                  table = new JTable();
                  But you should seriously rethink your whole design here.