title: How to insert List <Products> into database
body: <p>I am new to Java. I have created a generic list of Products type ,how can I add it into the database. The list contains objects of Products, and columns in the database are fields of Products class. Even if I separate the list by listvariable.get(0) and so on, I get the object, not the values inside that objects.</p>
  
  <p>UPDATE :  Inserted using for loop and getting fields for each objects. Is there any  better way</p>
  
  <pre><code>import java.util.*;
  public class Products {
  
      public static List &lt;Products&gt; li  = new ArrayList&lt;Products&gt; ();
  
      static 
      {
          Products o = new Products (1,"Milky Way",12.0,7);   // Static because  
          Products o1 = new Products (2,"Dairy Milk",50.0,17); // these entries 
          Products o2 = new Products (3,"Borunville",70.0,27);  // are mandatory
          Products o3 = new Products (4,"Lindt",1022.0,107);
          li.add(o);
          li.add(o1);
          li.add(o2);
          li.add(o3);
      }
      int ItemCode;
      String ItemName;
      double UnitPrice;
      int AvailableCount; 
      public int v=3;
  
      Products()
      {}
  
      Products (int x,String y, double c, int d)
      {
          ItemCode=x;
          ItemName=y;
          UnitPrice=c;
          AvailableCount=d;
  
      }
      public String toString ()       
      {
  
          return (  ItemName+" "+ ItemCode +" "+ UnitPrice + " "+ AvailableCount);
      }
      void addProduct()
      {
          li.add(this);
      }
  
      public List &lt;Products&gt; initProducts()       
  
      {                   return li;
      }
  
  }
  
  import java.sql.PreparedStatement;
  import java.sql.ResultSet;
  import java.util.Iterator;
  
  
  public class Shopowner {
  
  
  
      public static void main (String ...args)
  
      { 
  
          Products o = new Products(6,"Eclairs",12.33,5);
          o.addProduct();
  
      System.out.println(new Products().initProducts());
  
  
  
      try
      {
          Connectivity.establishConnection(); // static method for db url and drivers
  
           for (int i =0;i&lt;4;i++)
      {
          Products x=Products.li.get(i);
  
          String name=x.ItemName;
          int id= x.ItemCode;
          int count =x.AvailableCount;
          double price = x.UnitPrice;
          PreparedStatement stm = Connectivity.con.prepareStatement("insert into Products_tbl values (?,?,?,?)");
          stm.setInt(1, id);
          stm.setString(2, name);
          stm.setDouble(3,price);
      stm.setInt(4, count);
      stm.executeUpdate();
      }
  
  
  
      }
      catch(Exception e)
      {e.printStackTrace();}  
  
      //System.out.println(new Products().li);
  
  
      }
  }
  </code></pre>