hibernate设计数据思想和实体映射关系配置及各种复杂查询语句（2）

1.编写Dao包中的类

package com.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.util.HibernateUtil;
import com.vo.Address;
import com.vo.Consumer;

public class AddressDao {

	private static Transaction transaction;

	// 增加地址
	public void insertAddress(Address address) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.save(address);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	// 通过用户id查找地址
	public List<Address> queryAddressByCustomer_id(int customer_id) {
		Session session = HibernateUtil.getSession();

		Query query = session.createQuery(
				"select new Address(a.address_id,a.address_city,a.adress_district,a.adress_town,a.adress_street,a.consumer) from Address a where a.consumer.customer_id = "
						+ customer_id);
		List<Address> addressList = query.list();

		Query query1 = session.createQuery("from Consumer where customer_id = " + customer_id);
		List<Consumer> consumerList = query1.list();
		Consumer consumer = consumerList.get(0);
		for (Address address : addressList) {
			address.setConsumer(consumer);
		}
		HibernateUtil.closeSession();
		return addressList;
	}

	// 通过地址id删除地址
	public void deleteAddressByAddress_id(Address address) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		//session.delete("from Address a where a.address_id = " + address.getAddress_id());
		session.delete(address);
		transaction.commit();
		HibernateUtil.closeSession();
	}
	
	public void updateAddress(Address address){
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.update(address);
		transaction.commit();
		HibernateUtil.closeSession();
	}

}

package com.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.util.HibernateUtil;
import com.vo.Comments;
import com.vo.Consumer;

public class CommentsDao {

	private static Transaction transaction;

	public List<Comments> queryAllComments() {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery(
				"select new Comments(c.comments_id,c.comments_context,c.comments_time,c.comments_reply) from Comments c");
		List<Comments> commentsList = query.list();
		HibernateUtil.closeSession();
		return commentsList;
	}

	public void insertComments(Comments Comments) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.save(Comments);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public List<Comments> queryCommentsByOrderFoods_id(int orderfoods_id) {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery(
				" select new Comments(c.comments_id,c.comments_context,c.comments_time,c.comments_reply) from Comments c where c.orderfoods.orderfoods_id="
						+ orderfoods_id);
		List<Comments> commentsList = query.list();
		HibernateUtil.closeSession();
		return commentsList;
	}

	public Comments queryCommentsByComments_id(int comments_id) {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery(
				"select new Comments(c.comments_id,c.comments_context,c.comments_time,c.comments_reply) from Comments c where c.comments_id="
						+ comments_id);
		List<Comments> commentsList = query.list();
		Comments comments = commentsList.get(0);
		HibernateUtil.closeSession();
		return comments;
	}

	public void updateComments(Comments comments) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.update(comments);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public void deleteComments(Comments comments) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.delete(comments);
		transaction.commit();
		HibernateUtil.closeSession();
	}

}

package com.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.util.HibernateUtil;
import com.vo.Address;
import com.vo.Consumer;

public class ConsumerDao {

	private static Transaction transaction;
	private AddressDao addressDao = new AddressDao();

	public List<Consumer> queryAllConsumer() {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("from Consumer");
		List<Consumer> consumerList = query.list();
		HibernateUtil.closeSession();
		return consumerList;
	}

	public void insertConsumer(Consumer consumer) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.save(consumer);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public Consumer queryConsumerById(int customer_d) {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("from Consumer c where c.customer_id =" + customer_d);
		List<Consumer> consumerList = query.list();
		Consumer consumer = consumerList.get(0);
		HibernateUtil.closeSession();
		return consumer;
	}

	public void updateConsumerByEndTime(String customer_endtime, int customer_id) {
		ConsumerDao consumerDao = new ConsumerDao();
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		Consumer consumer = consumerDao.queryConsumerById(customer_id);
		consumer.setCustomer_endtime(customer_endtime);
		consumer.setCustomer_state("1");
		session.update(consumer);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public void updateConsumer(Consumer consumer) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.update(consumer);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public void deleteConsumer(Consumer consumer) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		Query query = session.createQuery(
				"select a.address_id from Address a where a.consumer.customer_id = " + consumer.getCustomer_id());
		List addressList = query.list();
		for (Object object : addressList) {
			Address address = new Address();
			address.setAddress_id((Integer) object);
			session.delete(address);
		}
		session.delete(consumer);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public Consumer queryConsumerByAddress_id(int address_id) {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery(
				"from Consumer c where c.customer_id = (select a.consumer.customer_id from Address a where a.address_id = "
						+ address_id + ")");
		List<Consumer> consumerList = query.list();
		Consumer consumer = consumerList.get(0);
		return consumer;
	}

}

package com.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.util.HibernateUtil;
import com.vo.Controller;

public class ControllerDao {

	private static Transaction transaction;

	public void insertController(Controller controller) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.save(controller);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public List<Controller> queryAllController() {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("from Controller");
		List<Controller> controllerList = query.list();
		HibernateUtil.closeSession();
		return controllerList;
	}

	public Controller queryControllerById(int controller_id) {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("from Controller c where c.controller_id=" + controller_id);
		List<Controller> controllerList = query.list();
		Controller controller = controllerList.get(0);
		HibernateUtil.closeSession();
		return controller;
	}

	public void updateController(Controller controller) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.update(controller);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public void deleteController(Controller controller) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.delete(controller);
		transaction.commit();
		HibernateUtil.closeSession();
	}

}

package com.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.util.HibernateUtil;
import com.vo.Address;
import com.vo.Consumer;
import com.vo.Food;
import com.vo.Seller;

public class FoodDao {

	private static Transaction transaction;

	public void insertFood(Food food) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.save(food);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public List<Food> queryFoodBySellerId(int seller_id) {
		Session session = HibernateUtil.getSession();

		Query query = session.createQuery(
				"select new Food(f.food_id,f.food_name,f.food_number,f.food_realprice,f.food_discountprice) from Food f where f.seller.seller_id = "
						+ seller_id);
		Query query1 = session.createQuery("from Seller where seller_id = " + seller_id);
		List<Seller> sellerList = query1.list();
		List<Food> foodList = query.list();
		Seller seller = sellerList.get(0);
		for (Food food : foodList) {
			food.setSeller(seller);
		}
		HibernateUtil.closeSession();
		return foodList;
	}

	public void updateFood(Food food) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.update(food);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public void deleteFoodByFood_id(Food food) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.delete(food);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public Food queryFoodByFood_id(int food_id) {
		Session session = HibernateUtil.getSession();
		Query query = session
				.createQuery("select new Food(f.food_id,f.food_name,f.food_number,f.food_realprice,f.food_discountprice) from Food f where f.food_id = " + food_id);
		List<Food> foodList = query.list();
		Food food = foodList.get(0);
		HibernateUtil.closeSession();
		return food;
	}
	
	

}

package com.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.util.HibernateUtil;
import com.vo.FoodType;

public class FoodTypeDao {
	private static Transaction transaction;

	public void insertFood(FoodType foodType) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.save(foodType);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public List<FoodType> queryAllFoodType() {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("from FoodType");
		List<FoodType> foodTypeList = query.list();
		HibernateUtil.closeSession();
		return foodTypeList;
	}

	public FoodType queryFoodTypeByFoodType_id(int foodtype_id) {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("from FoodType f where f.foodtype_id=" + foodtype_id);
		List<FoodType> foodTypeList = query.list();
		FoodType foodType = foodTypeList.get(0);
		HibernateUtil.closeSession();
		return foodType;
	}

	public void deleteFoodType(FoodType foodType) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.delete(foodType);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public void updateFoodType(FoodType foodType) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.update(foodType);
		transaction.commit();
		HibernateUtil.closeSession();
	}

}

package com.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.util.HibernateUtil;
import com.vo.Food;
import com.vo.OrderFoods;
import com.vo.Order_Food;

public class Order_FoodDao {

	private static Transaction transaction;

	public void insertOrder_Food(Order_Food order_food) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.save(order_food);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public List<Order_Food> queryAllOrder_Food() {
		Session session = HibernateUtil.getSession();
		Query query1 = session
				.createQuery(" select new Order_Food(o.order_food_id,o.order_food_number) from Order_Food o");
		List<Order_Food> order_foodList = query1.list();
		for (Order_Food order_Food : order_foodList) {
			Query query2 = session.createQuery(
					"from Food f where f.food_id = (select o.food.food_id from Order_Food o where o.order_food_id="
							+ order_Food.getOrder_food_id() + ")");
			Query query3 = session.createQuery(
					"from OrderFoods f where f.orderfoods_id = (select o.orderfood.orderfoods_id from Order_Food o where o.order_food_id="
							+ order_Food.getOrder_food_id() + ")");
			List<Food> foodList = query2.list();
			Food food = foodList.get(0);
			List<OrderFoods> orderFoodsList = query3.list();
			OrderFoods orderFoods = orderFoodsList.get(0);
			order_Food.setFood(food);
			order_Food.setOrderfood(orderFoods);
		}
		return order_foodList;
	}

	public void updateOrder_Food(Order_Food order_food) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.update(order_food);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public void deleteOrder_Food(Order_Food order_food) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.delete(order_food);
		transaction.commit();
		HibernateUtil.closeSession();
	}
}

package com.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.util.HibernateUtil;
import com.vo.OrderFoods;

public class OrderFoodsDao {

	private static Transaction transaction;

	public void insertOrderFoods(OrderFoods orderFoods) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.save(orderFoods);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public OrderFoods queryOrderFoodsByOrderFoods_id(int orderfoods_id) {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("from OrderFoods where orderfoods_id = " + orderfoods_id);
		List<OrderFoods> orderFoodsList = query.list();
		OrderFoods orderFoods = orderFoodsList.get(0);
		return orderFoods;
	}

	//通过customerId查询orderFoods
	public List<OrderFoods> queryOrderFoodsByCustomer_id(int customer_id) {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery(
				"select new OrderFoods(o.orderfoods_id,o.orderfoods_time,o.orderfoods_deliverytime,o.orderfoods_state ,o.address) from OrderFoods o where o.address.address_id = (select a.address_id from Address a where a.consumer.customer_id = " + customer_id + ")");
		List<OrderFoods> orderFoodsList = query.list();
		return orderFoodsList;
	}

}

package com.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.util.HibernateUtil;
import com.vo.Rider;

public class RiderDao {

	private static Transaction transaction;

	public List<Rider> queryAllRider() {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("from Rider");
		List<Rider> riderList = query.list();
		HibernateUtil.closeSession();
		return riderList;
	}

	public void insertRider(Rider rider) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.save(rider);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public Rider queryRiderById(int rider_id) {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("from Rider r where r.rider_id =" + rider_id);
		List<Rider> riderList = query.list();
		Rider rider = riderList.get(0);
		HibernateUtil.closeSession();
		return rider;
	}

	public void updateConsumer(Rider rider) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.update(rider);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public void deleteRider(Rider rider) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.delete(rider);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public Rider queryRiderByOrderFoods_id(int orderfoods_id) {
		Session session = HibernateUtil.getSession();
		String hql = "from Rider r where r.rider_id = (select o.rider.rider_id from OrderFoods o where o.orderfoods_id = "
				+ orderfoods_id + ")";
		Query query = session.createQuery(hql);
		List<Rider> riderList = query.list();
		Rider rider = riderList.get(0);
		HibernateUtil.closeSession();
		return rider;
	}
}

package com.dao;

import java.util.Iterator;
import java.util.List;
import java.util.Map;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.util.HibernateUtil;
import com.vo.Seller;

public class SellerDao {

	private static Transaction transaction;

	public void insertSeller(Seller seller) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.save(seller);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public List<Seller> querySeller() {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("from Seller");
		List<Seller> sellerList = query.list();
		HibernateUtil.closeSession();
		return sellerList;
	}

	// 如果正在开店就调用这个方法就变成暂停营业，如果是正在暂停营业调用这个方法就变成开店
	public void updateSellerByState(int seller_id) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		Query query = session.createQuery("from Seller s where s.seller_id=" + seller_id);
		List<Seller> sellerList = query.list();
		Seller seller = sellerList.get(0);
		if (seller.getSeller_state().equals("0")) {
			seller.setSeller_state("1");
		} else {
			seller.setSeller_state("0");
		}
		session.update(seller);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	// 注销商户
	public void updateState(int seller_id) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		Query query = session.createQuery("from Seller s where s.seller_id=" + seller_id);
		List<Seller> sellerList = query.list();
		Seller seller = sellerList.get(0);
		seller.setSeller_state("2");
		session.update(seller);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public Seller querySellerBySeller_id(int seller_id) {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("from Seller s where s.seller_id=" + seller_id);
		List<Seller> sellerList = query.list();
		Seller seller = sellerList.get(0);
		HibernateUtil.closeSession();
		return seller;
	}

	// 通过店名进行模糊查询
	public List<Seller> querySellerByConditon(String[] condition) {
		Session session = HibernateUtil.getSession();
		String hql1 = "from Seller s where ";
		String hql2 = "order by s.seller_grade desc";
		for (int i = 0; i < condition.length; i++) {
			String hqlTemp = "";
			if (i == (condition.length - 1)) {
				hqlTemp = " s.seller_name like '%" + condition[i] + "%' " + hql2;
			} else {
				hqlTemp = " s.seller_name like '%" + condition[i] + "%' or ";
			}
			hql1 = hql1 + hqlTemp;
		}
		Query query = session.createQuery(hql1);
		List<Seller> sellerList = query.list();
		HibernateUtil.closeSession();
		return sellerList;
	}

	// 通过平均价格进行查询
	// 通过评分进行查询
	// 用map进行封装就可以直接简单的进行查询
	public List<Seller> querySellerByOther(Map<String, String> other) {
		Session session = HibernateUtil.getSession();
		Iterator<String> iter = other.keySet().iterator();
		String key = "";
		String value = "";
		while (iter.hasNext()) {
			key = iter.next();
			value = other.get(key);
		}
		String hql = "from Seller order by " + key + " " + value + "";
		Query query = session.createQuery(hql);
		List<Seller> sellerList = query.list();
		return sellerList;
	}

	public void updateSeller(Seller seller) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.update(seller);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public List<Seller> querySellerByActivity_id(int activity_id) {
		Session session = HibernateUtil.getSession();
		String hql = "select s from Seller s  left join s.setActivity a where a.activity_id=" + activity_id;
		Query query = session.createQuery(hql);
		List<Seller> sellerList = query.list();
		HibernateUtil.closeSession();
		return sellerList;
	}

	public Seller querySellerByFood_id(int food_id) {
		Session session = HibernateUtil.getSession();
		String hql = "from Seller s where s.seller_id = (select f.seller.seller_id from Food f where f.food_id="
				+ food_id + ")";
		Query query = session.createQuery(hql);
		List<Seller> sellerList = query.list();
		Seller seller = sellerList.get(0);
		HibernateUtil.closeSession();
		return seller;

	}

}

package com.dao;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.util.HibernateUtil;
import com.vo.Activity;

public class ActivityDao {

	private static Transaction transaction;

	public void insertActivity(Activity activity) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.save(activity);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public List<Activity> queryActivity() {
		Session session = HibernateUtil.getSession();
		Query query = session.createQuery("select new Activity(a.activity_id,a.activity_name) from Activity a");
		List<Activity> activityList = query.list();
		HibernateUtil.closeSession();
		return activityList;
	}

	public void deleteActivity(Activity activity) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.delete(activity);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	public void updateActivity(Activity activity) {
		Session session = HibernateUtil.getSession();
		transaction = session.beginTransaction();
		session.update(activity);
		transaction.commit();
		HibernateUtil.closeSession();
	}

	//查询参加个某个活动的商家
	public Activity queryActivityByActivity_id(int activity_id) {
		Session session = HibernateUtil.getSession();
		Query query = session
				.createQuery("select new Activity(a.activity_id,a.activity_name) from Activity a where a.activity_id="
						+ activity_id);
		List<Activity> activityList = query.list();
		Activity activity = activityList.get(0);
		HibernateUtil.closeSession();
		return activity;

	}
	

}

2.编写测试类

package com.test;

import java.util.List;

import org.junit.Test;

import com.dao.ActivityDao;
import com.dao.SellerDao;
import com.vo.Activity;
import com.vo.Seller;

public class TestActivity {

	private ActivityDao activityDao = new ActivityDao();
	private SellerDao sellerDao = new SellerDao();

	@Test
	public void insertActivity() {
		Activity activity = new Activity();
		activity.setActivity_name("过年好");
		activityDao.insertActivity(activity);
	}

	@Test
	public void queryActivity() {
		List<Activity> activityList = activityDao.queryActivity();
		for (Activity activity : activityList) {
			System.out.println(activity);
		}
	}

	@Test
	public void updateActivity() {
		Seller seller1 = sellerDao.querySellerBySeller_id(1);
		Seller seller2 = sellerDao.querySellerBySeller_id(2);
		Seller seller3 = sellerDao.querySellerBySeller_id(3);

		Activity activity1 = activityDao.queryActivityByActivity_id(1);
		Activity activity2 = activityDao.queryActivityByActivity_id(2);
		System.out.println(activity2);
		activity1.getSetSeller().add(seller1);
		activity1.getSetSeller().add(seller2);
		activity2.getSetSeller().add(seller2);
		activity2.getSetSeller().add(seller3);

		activityDao.updateActivity(activity1);
		activityDao.updateActivity(activity2);

	}

}

package com.test;

import java.util.List;

import org.junit.Test;

import com.dao.AddressDao;
import com.dao.ConsumerDao;
import com.vo.Address;
import com.vo.Consumer;

public class TestAddress {

	private AddressDao addressDao = new AddressDao();
	private ConsumerDao consumerDao = new ConsumerDao();

	// 增加地址
	@Test
	public void insertAddress() {
		Address address = new Address();
		Consumer consumer = consumerDao.queryConsumerById(1);
		address.setAddress_city("黑龙江省");
		address.setAdress_district("哈尔滨市");
		address.setAdress_town("香坊区");
		address.setAdress_street("三大动力路15号");
		address.setConsumer(consumer);

		addressDao.insertAddress(address);
	}

	// 通过用户id查找地址
	@Test
	public void queryAddressByCustomer_id() {
		int customer_id = 1;
		List<Address> addressList = addressDao.queryAddressByCustomer_id(customer_id);
		for (Address address : addressList) {
			System.out.println(address);
		}
	}

	// 通过地址id删除地址
	@Test
	public void deleteAddressByAddress_id() {
		int address_id = 1;
		Address address = new Address();
		address.setAddress_id(address_id);
		addressDao.deleteAddressByAddress_id(address);
	}
	
	@Test
	public void updateAddress(){
		Address address = new Address();
		Consumer consumer = consumerDao.queryConsumerById(1);
		address.setAddress_city("黑龙江省");
		address.setAdress_district("哈尔滨市");
		address.setAdress_town("香坊区");
		address.setAdress_street("三大动力路16号");
		address.setConsumer(consumer);
	}

}

package com.test;

import java.util.List;

import org.junit.Test;

import com.dao.CommentsDao;
import com.dao.OrderFoodsDao;
import com.vo.Comments;
import com.vo.OrderFoods;

public class TestComments {

	private CommentsDao commentsDao = new CommentsDao();
	private OrderFoodsDao orderFoodsDao = new OrderFoodsDao();

	@Test
	public void insertComments() {
		Comments comments = new Comments();
		OrderFoods orderfoods = orderFoodsDao.queryOrderFoodsByOrderFoods_id(1);
		comments.setComments_context("very good");
		comments.setComments_time("2018-06-10 19:17:55");
		comments.setComments_reply("thanks");
		comments.setOrderfoods(orderfoods);
		commentsDao.insertComments(comments);
	}

	@Test
	public void queryAllComments() {
		List<Comments> commentsList = commentsDao.queryAllComments();
		for (Comments comments : commentsList) {
			System.out.println(comments);
		}
	}

	@Test
	public void queryCommentsByOrderFoods_id() {
		int orderfoods_id = 1;
		List<Comments> commentsLis = commentsDao.queryCommentsByOrderFoods_id(orderfoods_id);
		for (Comments comments : commentsLis) {
			System.out.println(comments);
		}
	}

	public void queryCommentsByComments_id(){
		int comments_id = 1;
		Comments comments = commentsDao.queryCommentsByComments_id(comments_id);
		System.out.println(comments);
	}
}

package com.test;

import java.util.List;

import org.junit.Test;

import com.dao.ConsumerDao;
import com.vo.Consumer;

public class TestConsumer {

	private ConsumerDao consumerDao = new ConsumerDao();

	//查找所有用户
	@Test
	public void queryAllConsumer() {
		List<Consumer> consumerList = consumerDao.queryAllConsumer();
		for (Consumer consumer : consumerList) {
			System.out.println(consumer);
		}
	}

	//增加
	@Test
	public void insertConsumer() {
		Consumer consumer = new Consumer();
		consumer.setCustomer_account("1514010624");
		consumer.setCustomer_age(18);
		consumer.setCustomer_name("谢魁星");
		consumer.setCustomer_password("123456");
		consumer.setCustomer_phone("18846420968");
		consumer.setCustomer_sex("男");
		consumer.setCustomer_starttime("2018-06-07");
		consumer.setCustomer_state("0");

		consumerDao.insertConsumer(consumer);
	}
	
	//注销
	@Test
	public void cancelConsumer(){
		String customer_endtime = "2018-06-17";
		int customer_id = 1;
		consumerDao.updateConsumerByEndTime(customer_endtime,customer_id);
	}
	
	//修改用户信息
	@Test
	public void updateConsumer(){
		Consumer consumer = new Consumer();
		consumer.setCustomer_id(1);
		consumer.setCustomer_account("1514010624");
		consumer.setCustomer_age(20);
		consumer.setCustomer_name("谢魁星");
		consumer.setCustomer_password("123456");
		consumer.setCustomer_phone("18846420968");
		consumer.setCustomer_sex("男");
		consumer.setCustomer_starttime("2018-06-07");
		consumer.setCustomer_state("0");
		consumerDao.updateConsumer(consumer);
	}
	
	@Test
	public void deleteConsumer(){
		Consumer consumer =  new Consumer();
		consumer.setCustomer_id(1);
		consumerDao.deleteConsumer(consumer);
		
	}
	
	@Test
	public void queryConsumerByAddress_id(){
		int address_id = 1;
		Consumer consumer = consumerDao.queryConsumerByAddress_id(address_id);
		System.out.println(consumer);
	}

}

package com.test;

import java.util.List;

import org.junit.Test;

import com.dao.ControllerDao;
import com.vo.Controller;

public class TestController {

	private ControllerDao controllerDao = new ControllerDao();

	@Test
	public void insertController() {
		Controller controller = new Controller();
		controller.setController_password("123456");
		controller.setController_power("0");
		controllerDao.insertController(controller);
	}

	@Test
	public void queryAllController() {
		List<Controller> controllerList = controllerDao.queryAllController();
		for (Controller controller : controllerList) {
			System.out.println(controller);
		}
	}

	@Test
	public void queryControllerById() {
		int controller_id = 1;
		Controller controller = controllerDao.queryControllerById(controller_id);
		System.out.println(controller);
	}

	@Test
	public void updateControllerById() {
		Controller controller = new Controller(1, "56478", "0");
		controllerDao.updateController(controller);
	}

	@Test
	public void deleteController() {
		Controller controller = new Controller();
		controller.setController_id(1);
		controllerDao.deleteController(controller);
	}

}

package com.test;

import java.util.List;

import org.junit.Test;

import com.dao.FoodDao;
import com.dao.SellerDao;
import com.vo.Food;
import com.vo.Seller;

public class TestFood {

	private SellerDao sellerDao = new SellerDao();
	private FoodDao foodDao = new FoodDao();

	@Test
	public void insertFood() {
		Seller seller = sellerDao.querySellerBySeller_id(1);
		Food food = new Food();
		food.setFood_name("鲜奶水果捞");
		food.setFood_number(10);
		food.setFood_realprice(33.9);
		food.setFood_discountprice(15.9);
		food.setSeller(seller);
		foodDao.insertFood(food);
	}

	@Test
	public void queryFoodBySeller_id() {
		int seller_id = 1;
		List<Food> foodList = foodDao.queryFoodBySellerId(seller_id);
		for (Food food : foodList) {
			System.out.println(food);
		}
	}

	@Test
	public void updateFood() {
		Seller seller = sellerDao.querySellerBySeller_id(1);
		Food food = new Food();
		food.setFood_id(1);
		food.setFood_name("鲜奶水果捞");
		food.setFood_number(10);
		food.setFood_realprice(33.9);
		food.setFood_discountprice(15.9);
		food.setSeller(seller);
		foodDao.updateFood(food);
	}

	@Test
	public void deleteFoodByFoodId() {
		Food food = new Food();
		food.setFood_id(1);
		foodDao.deleteFoodByFood_id(food);
	}

	@Test
	public void queryFoodByFood_id() {
		int food_id = 1;
		Food food = foodDao.queryFoodByFood_id(food_id);
		System.out.println(food);
	}

}

package com.test;

import java.util.List;

import org.junit.Test;

import com.dao.FoodDao;
import com.dao.FoodTypeDao;
import com.vo.Food;
import com.vo.FoodType;

public class TestFoodType {

	private FoodTypeDao foodTypeDao = new FoodTypeDao();
	private FoodDao foodDao = new FoodDao();

	@Test
	public void insertFoodType() {
		FoodType foodType = new FoodType();
		foodType.setFoodType_name("美食");
		foodTypeDao.insertFood(foodType);
	}

	@Test
	public void queryFoodType() {
		List<FoodType> foodTypeList = foodTypeDao.queryAllFoodType();
		for (FoodType foodType : foodTypeList) {
			System.out.println(foodType);
		}
	}

	@Test
	public void deleteFoodType() {
		FoodType foodType = new FoodType();
		foodType.setFoodtype_id(3);
		foodTypeDao.deleteFoodType(foodType);
	}

	@Test
	public void updateFoodType() {
		FoodType foodType = new FoodType();
		foodType.setFoodtype_id(2);
		foodType.setFoodType_name("小吃");
		foodTypeDao.updateFoodType(foodType);
	}

	@Test
	public void updateFoodTypeByFood() {
		Food food1 = foodDao.queryFoodByFood_id(1);
		Food food2 = foodDao.queryFoodByFood_id(2);
		FoodType foodType1 = foodTypeDao.queryFoodTypeByFoodType_id(1);
		System.out.println(foodType1);
		foodType1.getSetFood().add(food1);
		foodType1.getSetFood().add(food2);
		
		foodTypeDao.updateFoodType(foodType1);
	}
}

package com.test;

import java.util.List;

import org.junit.Test;

import com.dao.FoodDao;
import com.dao.OrderFoodsDao;
import com.dao.Order_FoodDao;
import com.vo.Food;
import com.vo.OrderFoods;
import com.vo.Order_Food;

public class TestOrder_Food {

	private Order_FoodDao order_foodDao = new Order_FoodDao();
	private OrderFoodsDao orderFoodDao = new OrderFoodsDao();
	private FoodDao foodDao = new FoodDao();

	@Test
	public void insertOrder_Food() {
		Food food = foodDao.queryFoodByFood_id(1);
		OrderFoods orderFoods = orderFoodDao.queryOrderFoodsByOrderFoods_id(1);
		Order_Food order_food = new Order_Food();
		order_food.setFood(food);
		order_food.setOrderfood(orderFoods);
		order_food.setOrder_food_number(1);
		order_foodDao.insertOrder_Food(order_food);
	}

	@Test
	public void queryAllOrder_Food() {
		List<Order_Food> order_foodList = order_foodDao.queryAllOrder_Food();
		for (Order_Food order_Food : order_foodList) {
			System.out.println(order_Food);
		}
	}

}

package com.test;

import java.util.List;

import org.junit.Test;

import com.dao.AddressDao;
import com.dao.OrderFoodsDao;
import com.dao.RiderDao;
import com.vo.Address;
import com.vo.OrderFoods;
import com.vo.Rider;

public class TestOrderFoods {

	private OrderFoodsDao orderFoodsDao = new OrderFoodsDao();
	private AddressDao addressDao = new AddressDao();
	private RiderDao riderDao = new RiderDao();

	@Test
	public void insertOrderFoods() {
		OrderFoods orderFoods = new OrderFoods();
		Address address = new Address();
		Rider rider = new Rider();
		orderFoods.setOrderfoods_time("2018-06-01 12:00:12");
		orderFoods.setOrderfoods_deliverytime("2018-06-01 12:30:12");
		orderFoods.setOrderfoods_state("1");
		address = addressDao.queryAddressByCustomer_id(1).get(0);
		rider = riderDao.queryRiderById(1);
		orderFoods.setAddress(address);
		orderFoods.setRider(rider);
		orderFoodsDao.insertOrderFoods(orderFoods);
	}

	@Test
	public void queryOrderFoodsByOrderFoods_id() {
		int orderfoods_id = 1;
		OrderFoods orderFoods = orderFoodsDao.queryOrderFoodsByOrderFoods_id(orderfoods_id);
		System.out.println(orderFoods);
	}

	@Test
	public void queryOrderFoodsByCustomer_id() {
		int customer_id = 1;
		List<OrderFoods> orderFoodsList = orderFoodsDao.queryOrderFoodsByCustomer_id(customer_id);
		for (OrderFoods orderFoods : orderFoodsList) {
			System.out.println(orderFoods);
		}
	}

}

package com.test;

import java.util.List;

import org.junit.Test;

import com.dao.RiderDao;
import com.vo.Rider;

public class TestRider {

	private RiderDao riderDao = new RiderDao();

	@Test
	public void insertRider() {
		Rider rider = new Rider();
		rider.setRider_address("黑龙江省哈尔滨市道里区12号");
		rider.setRider_entertime("2017-10-10");
		rider.setRider_idcard("371322199511202211");
		rider.setRider_leavetime(" ");
		rider.setRider_name("王五");
		rider.setRider_phone("18846420001");
		rider.setRider_state("1");
		rider.setRider_wages(1888.00);
		riderDao.insertRider(rider);
	}

	@Test
	public void queryAllRider() {
		List<Rider> riderList = riderDao.queryAllRider();
		for (Rider rider : riderList) {
			System.out.println(rider);
		}
	}

	@Test
	public void queryRiderByRider_id() {
		Rider rider = riderDao.queryRiderById(1);
		System.out.println(rider);
	}

	@Test
	public void queryRiderByOrderFoods_id() {
		int orderfoods_id = 1;
		Rider rider = riderDao.queryRiderByOrderFoods_id(orderfoods_id);
		System.out.println(rider);
	}

}

package com.test;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import org.junit.Test;

import com.dao.SellerDao;
import com.vo.Seller;

public class TestSeller {

	private SellerDao sellerDao = new SellerDao();

	@Test
	public void insertSeller() {
		Seller seller = new Seller();
		seller.setSeller_name("香坊水果捞店5");
		seller.setSeller_address("黑龙江省哈尔滨市香坊区三大动力路554号");
		seller.setSeller_phone("18846420000");
		seller.setSeller_avgprice(0);
		seller.setSeller_grade(4.5);
		seller.setSeller_state("1");
		sellerDao.insertSeller(seller);
	}

	@Test
	public void querySeller() {
		List<Seller> sellerList = sellerDao.querySeller();
		for (Seller seller : sellerList) {
			System.out.println(seller);
		}
	}

	@Test
	public void exchageState() {
		sellerDao.updateSellerByState(1);
	}

	@Test
	public void exchageStateTo2() {
		sellerDao.updateSellerByState(1);
	}

	@Test
	public void querySellerBySeller_id() {
		Seller seller = sellerDao.querySellerBySeller_id(1);
		System.out.println(seller);
	}

	// 模糊查询
	@Test
	public void querySellerByCondition() {
		String condition = "水捞";
		String[] conditions = condition.split("");
		List<Seller> sellerList = sellerDao.querySellerByConditon(conditions);
		for (Seller seller : sellerList) {
			System.out.println(seller);
		}
	}

	@Test
	public void updateSeller() {
		Seller seller = new Seller();
		seller.setSeller_id(1);
		seller.setSeller_name("香坊水果捞店7");
		seller.setSeller_address("黑龙江省哈尔滨市香坊区三大动力路554号");
		seller.setSeller_phone("18846420000");
		seller.setSeller_avgprice(0);
		seller.setSeller_grade(4.5);
		seller.setSeller_state("1");
	}

	@Test
	public void querySellerByActivity_id() {
		int activity_id = 1;
		List<Seller> sellerList = sellerDao.querySellerByActivity_id(activity_id);
		for (Seller seller : sellerList) {
			System.out.println(seller);
		}
	}

	@Test
	public void querySellerByFood_id() {
		int food_id = 1;
		Seller seller = sellerDao.querySellerByFood_id(food_id);
		System.out.println(seller);
	}

	// map进行封装进行查询
	@Test
	public void querySellerByMap() {
		Map<String, String> avgPriceMap1 = new HashMap<String, String>();
		Map<String, String> avgPriceMap2 = new HashMap<String, String>();
		Map<String, String> gradeMap1 = new HashMap<String, String>();
		Map<String, String> gradeMap2 = new HashMap<String, String>();
		avgPriceMap1.put("seller_avgprice", "asc");
		avgPriceMap2.put("seller_avgprice", "desc");
		gradeMap1.put("seller_grade", "asc");
		gradeMap2.put("seller_grade", "desc");
		List<Seller> sellerList = new ArrayList<Seller>();
		sellerList = sellerDao.querySellerByOther(avgPriceMap1);
		System.out.println("平均价格升序排序");
		for (Seller seller : sellerList) {
			System.out.println(seller);
		}
		sellerList = sellerDao.querySellerByOther(avgPriceMap2);
		System.out.println("平均价格降序排序");
		for (Seller seller : sellerList) {
			System.out.println(seller);
		}
		sellerList = sellerDao.querySellerByOther(gradeMap1);
		System.out.println("综合评分升序排序");
		for (Seller seller : sellerList) {
			System.out.println(seller);
		}
		sellerList = sellerDao.querySellerByOther(gradeMap2);
		System.out.println("综合评分升序排序");
		for (Seller seller : sellerList) {
			System.out.println(seller);
		}
	}

}