[Javaclient-cvs] javaclient/samples/client/ejb CustomerBrowseControllerBean.java,1.1,1.2

[Dave S. <rim...@us...>]

Update of /cvsroot/javaclient/javaclient/samples/client/ejb
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11348/samples/client/ejb

Modified Files:
	CustomerBrowseControllerBean.java 
Log Message:
Getting closer. Looks like the problem is that there is no model info at all


Index: CustomerBrowseControllerBean.java
===================================================================
RCS file: /cvsroot/javaclient/javaclient/samples/client/ejb/CustomerBrowseControllerBean.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** CustomerBrowseControllerBean.java	27 Jul 2004 15:20:16 -0000	1.1
--- CustomerBrowseControllerBean.java	4 Aug 2004 15:27:19 -0000	1.2
***************
*** 2,9 ****
--- 2,18 ----
  
  import net.sourceforge.javaclient.server.jboss.JCServerController;
+ import net.sourceforge.javaclient.model.ListModel;
  import javax.ejb.SessionBean;
  import javax.ejb.SessionContext;
  
+ import javax.naming.InitialContext;
+ import javax.sql.DataSource;
+ import java.sql.ResultSet;
+ import java.sql.Connection;
+ import java.sql.Statement;
+ 
  
+ import client.model.CustomerBrowseModel;
+ import client.model.CustomerItem;
  /**
    @ejb:bean
***************
*** 26,29 ****
--- 35,69 ----
    {
    }
+   /**
+     @ejb:interface-method view-type="remote"
+   */
+   public void load()
+   {
+ 		try
+ 		{
+ 			ListModel model = ((CustomerBrowseModel)getModel()).getCustomerItemList();
+ 			InitialContext ctx = new InitialContext();		
+ 			DataSource s = (DataSource)ctx.lookup("java:/DefaultDS");
+ 			Connection c = s.getConnection();
+ 			Statement st = c.createStatement();
+       ResultSet rs = st.executeQuery("select customer_num,customer_name,address_1,city,country from customer");
+ 			while(rs.next())
+ 			{
+ 				CustomerItem m = (CustomerItem)model.newModel();
+ 				m.setCustomer_num(rs.getString(1));
+ 				m.setName(rs.getString(2));
+ 				m.setAddress_1(rs.getString(3));
+ 				m.setCity(rs.getString(4));
+ 				m.setCountry(rs.getString(5));
+ 				m.setCustomerItemPK(m.getCustomer_num());
+ 			}
+ 			rs.close();
+ 			c.close();
+ 		}
+ 			catch(Exception e)
+ 			{
+ 				e.printStackTrace();
+ 			}
+   }
  
     /**