public static String getCategoryID(String CategoryName){
        try {

            ResultSet rs=DB.myConnection().createStatement().executeQuery("select* from category where CategoryName='"+CategoryName+"'");
            while(rs.next()){
                category_id=rs.getString(1);                
            }

        } catch (ClassNotFoundException e) {
            JOptionPane.showMessageDialog(null, "Error @ LoadCategoryID  class not found exception");
        }catch(SQLException e2){
            JOptionPane.showMessageDialog(null, "Error @ LoadCategoryID  SQL exception");
        }
        return category_id;
    }