testdb.java

JSP+Struts+Hibernate进行网络开发的一个实例

package cn.com.zzb.eshopping.hibernateTest;

import java.util.HashSet;
//import java.util.Iterator;
import java.util.List;
import java.util.ListIterator;
import java.util.Set;

import cn.com.zzb.eshopping.model.Kind;
import cn.com.zzb.eshopping.model.Product;
import cn.com.zzb.eshopping.model.ProductFactory;
import cn.com.zzb.eshopping.model.User;
import cn.com.zzb.eshopping.model.UserFactory;
import cn.com.zzb.eshopping.model.sql.SqlProduct;
import cn.com.zzb.eshopping.model.sql.SqlProductFactory;
import cn.com.zzb.eshopping.model.sql.SqlUser;
import cn.com.zzb.eshopping.model.sql.SqlUserFactory;

//import java.util.Date;
//import java.util.Iterator;
//import cn.com.zzb.eshopping.model.*;
//import cn.com.zzb.eshopping.model.User;
//import cn.com.zzb.eshopping.model.UserFactory;
//import cn.com.zzb.eshopping.model.sql.*;
public class TestDB {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

		/*long lasttime = (new Date()).getTime();
		System.out.println(lasttime);
		  User user = new SqlUser();
	      user.setUserid("test4");
	      user.setPassword("123456");
	      user.setName("王小国4");
	      user.setLasttime(lasttime);
	      user.setRemark("very good");
		 //UserFactory uFactory = new SqlUserFactory();
		
		//ht.insertUser(user);  
		//Iterator iterator = ht.listUsers().iterator();//uFactory.ListUsers();
		//while(iterator.hasNext())
		//{
		//	user = (User)iterator.next();
		//	System.out.println(user.getName());
		//}*/
		//HibernateTest ht = new HibernateTest();
		  //ht.add();
		 Product product = new SqlProduct();
		 User user = new SqlUser();
		 Set set = new HashSet();
		 
		 ProductFactory pFactory = new SqlProductFactory();
		 List list = pFactory.listProducts();	 
		 if(!list.isEmpty())
		 {
			 ListIterator iterator =list.listIterator();
			 while(iterator.hasNext())
			 {
				 Object[] row = (Object[])iterator.next();
				 product = (Product)row[0];
				 String kind_name = (String)row[1];
				 Kind kind = (Kind)product.getKind();
				 System.out.println("产品名称："+product.getName()+"  产品类别："+kind_name);
				 
			 }
          }
		    
		 UserFactory uFactory = new SqlUserFactory();
		 List list1 = uFactory.listMyProducts(1);
		 if(!list1.isEmpty())
		 {
			 ListIterator iterator = list1.listIterator();
			 while(iterator.hasNext())
			 {
				 Object[] rows = (Object[])iterator.next();
				 user = (User)rows[0];
				 product = (Product)rows[1];
				 //int num = ((Integer)rows[2]).intValue();
				 //System.out.println(num);
				 //Iterator iterator2 = user.getProducts().iterator();
				// while(iterator2.hasNext())
				// {
					// product = (Product)iterator2.next();
					 System.out.println("用户："+user.getName()+"  商品："+product.getName());
				 //}
			 }
		 }
		 // user = uFactory.ListUser("tom");
		 // System.out.println(user.getName());
		 
		 int num = uFactory.countProduct(1,2);
		 System.out.println(num);
	}

}