spring整合sharding-jdbc实现分库分表

com.sharding.mapper; import com.sharding.pojo.vo.Order; import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import java.util.List; public interface OrderMapper { @Insert( "insert into t_order values(#{item.id},#{item.amount},#{item.name},#{item.userId})" ) public void insert(@Param("item" ) Order order); @Select( "select " + " id,amount,name,user_id as ‘userId‘ from t_order where name=#{name}" ) public List<Order> getOrderByName(String name); }

 package   com.sharding;

  import   org.mybatis.spring.annotation.MapperScan;
  import   org.springframework.boot.SpringApplication;
  import   org.springframework.boot.autoconfigure.SpringBootApplication;
  import   org.springframework.context.annotation.ImportResource;

@SpringBootApplication
@ImportResource( "classpath*:sharding-jdbc.xml" )
@MapperScan( "com.sharding.mapper" )
  public   class   ShardingTest {

      public   static   void   main(String[] args) {
        SpringApplication.run(ShardingTest.  class  );
    }
} 

 package   com.sharding.test;

  import   com.sharding.mapper.OrderMapper;
  import   com.sharding.pojo.vo.Order;
  import   org.junit.Test;
  import   org.junit.runner.RunWith;
  import   org.springframework.beans.factory.annotation.Autowired;
  import   org.springframework.boot.test.context.SpringBootTest;
  import   org.springframework.test.context.junit4.SpringRunner;

  import   java.util.List;

@RunWith(SpringRunner.  class  )
@SpringBootTest
  public   class   AppTest {

    @Autowired
      private   OrderMapper orderMapper;

    @Test
      public   void   testInsert(){

      Order order  =  new   Order();
      order.setId( 10 );
      order.setUserId( 20 );
      order.setAmount( 200 );
      order.setName( "Test" );
      orderMapper.insert(order);
    }

    @Test
      public   void   testQuery(){
        List <Order> test = orderMapper.getOrderByName("Test" );
        System.out.println( "查询结果：" +  test);
    }
} 

 

　　

 

spring整合sharding-jdbc实现分库分表

标签：use   sharp   space   his   mybatis   HERE   tin   engine   ati   

查看更多关于spring整合sharding-jdbc实现分库分表的详细内容...