public String getItemID()
    {
        String gen = "select count(*) as 'field' from item";
   
        int n1=0;
      
        
        ResultSet count1 = db1.executeSQLQuery(gen);
        
        try
        {
            if(count1.next())
            {
                n1 += Integer.parseInt(count1.getString("field"));
            }
        }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null, e.getMessage(),"METROPOLITAN ENGINEERING (PVT) LTD", 1);
        }
        
        
        //this.jTextField1.setText("Gen"+Integer.toString(n1));
        
        return Integer.toString(n1);
    }