Page 113 - IP
P. 113

String query= "SELECT  * from sal where month='"+month+"';";


                                  ResultSet rs= stmt.executeQuery(query);


                                  while(rs.next())

                                  {


                                   String eno= rs.getString("eno");


                                    String basic= rs.getString("basic");


                                     String red = rs.getString("reductions");

                                  String inc = rs.getString("incentive");


                                   String sal = rs.getString("salary");


                        model.addRow(new Object[] {eno,basic,red,inc,sal});

                                  }


                   }





                   catch(Exception e)

                   {


                       JOptionPane.showMessageDialog(this,e.getMessage());


                   }
   108   109   110   111   112   113   114   115   116   117   118