123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 |
- /*
- * Copyright 2016-2018 shardingsphere.io.
- * <p>
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- * </p>
- */
- package com.huojutech.sharding.service;
- import org.springframework.stereotype.Service;
- import com.huojutech.sharding.algorithm.IDGenerator;
- import com.huojutech.sharding.entity.Order;
- import com.huojutech.sharding.entity.OrderItem;
- import com.huojutech.sharding.repository.OrderItemRepository;
- import com.huojutech.sharding.repository.OrderRepository;
- import javax.annotation.Resource;
- import java.util.ArrayList;
- import java.util.Date;
- import java.util.List;
- @Service
- public class DemoService {
-
- @Resource
- private OrderRepository orderRepository;
-
- @Resource
- private OrderItemRepository orderItemRepository;
-
- public void demo() {
- orderRepository.createIfNotExistsTable();
- orderItemRepository.createIfNotExistsTable();
- orderRepository.truncateTable();
- orderItemRepository.truncateTable();
- List<Long> orderIds = new ArrayList<>(10);
- IDGenerator idGenerator = new IDGenerator();
-
- System.out.println("1.Insert--------------");
- for (int i = 0; i < 10; i++) {
- Order order = new Order();
- order.setUserId(i);
- order.setGmtCreate(new Date());
- order.setOrderCode("20180" + idGenerator.generateKey().toString());
-
- order.setStatus("INSERT_TEST");
- orderRepository.insert(order);
- long orderId = order.getOrderId();
- orderIds.add(orderId);
-
- // OrderItem item = new OrderItem();
- // item.setOrderId(orderId);
- // item.setUserId(i);
- // orderItemRepository.insert(item);
- }
- System.out.println(orderRepository.queryByGmtCreate());
- System.out.println(orderRepository.selectById());
- // for (Long each : orderIds) {
- // orderRepository.delete(each);
- // orderItemRepository.delete(each);
- // }
- // System.out.println(orderItemRepository.selectAll());
- // orderItemRepository.dropTable();
- // orderRepository.dropTable();
- }
- }
|