Sqlserver 测试项目

server.port=8088

# sqlserver数据库基础配置
spring.datasource.url=jdbc:sqlserver://39.101.137.10:1433;databasename=test_db
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.username=SA
spring.datasource.password=cdfGroup511

# 日志配置(输出SQL语句)
logging.level.com.xiaoshi.test.mapper = debug

@Mapper
public interface TestMapper {
    String test_table = "test";

    @Select(
            "SELECT * FROM " + test_table
    )
    List<TestEntity> getTestList();
    
    @Select(
            "SELECT * FROM " + test_table + " WHERE guid = #{guid}"
    )
    TestEntity getTestByGuid(@Param("guid") String guid);

    @Insert(
        "INSERT INTO test ( guid, name, age, sex, money, sign_date, sign_datetime, sign_time, [desc] ) " +
                "VALUES " +
                "(#{guid},#{name},#{age},#{sex},#{money},#{sign_date},#{sign_datetime},#{sign_time},#{desc})"
    )
    int insertTest(TestEntity testEntity);
}

public interface TestService {
    List<TestEntity> getTestList();
    int insertTest(TestEntity testEntity);
    TestEntity getTestByGuid(String guid);
}

@Service
public class TestServiceImp implements TestService {
    @Resource
    TestMapper testMapper;

    @Override
    public List<TestEntity> getTestList() {
        return testMapper.getTestList();
    }
    
    @Override
    public int insertTest(TestEntity testEntity) {
        return testMapper.insertTest(testEntity);
    }

    @Override
    public TestEntity getTestByGuid(String guid) {
        // 写逻辑
        TestEntity testByGuid = testMapper.getTestByGuid(guid);
        testByGuid.setDesc("大笨蛋");
        return testByGuid;
    }
}

@RestController
@RequestMapping("/test")
public class TestController {
    @Autowired
    TestService testService;

    @GetMapping(value = "/getTestList")
    public List<TestEntity> getTestList(){
        return testService.getTestList();
    }
    
    @PostMapping(value = "/insertTest")
    int insertTest(@RequestBody TestEntity testEntity){
        return testService.insertTest(testEntity);
    }

    @GetMapping(value="getTestByGuid")
    TestEntity getTestByGuid(@RequestParam(value = "guid") String guid){
        return testService.getTestByGuid(guid);
    }
}