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);
}
}
}