[Java] TDengine时序数据库时间戳(timestamp)字段插入数据的实现方法

1
2
3
4
5

@Data
public class Daily {
    private String collect_time;
    private String id;
}

1
2
3
4
5
6

@Mapper
public interface DailyMapper extends BaseMapper<Daily> {
    @Insert("insert into #{table_name} (collect_time) " +
            "values(#{timestamp})")
    public int insertDaily(Daily daily,String table_name,long timestamp);
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22

@RestController
public class DailyController {
    @Autowired
    private DailyMapper dailyMapper;

    @PostMapping("/dailyInsert")
    public String save(@RequestBody Daily daily) {
        // 解决时间戳问题
        String collect_time=daily.getCollect_time();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        Date date = sdf.parse(collect_time);
        long timestamp = date.getTime();
        // 向时序数据表插入数据
        int i= pavRollMapper.insertDaily(daily,"table1",timestamp);
        // 返回插入结果
        if(i>0){
            return "插入成功";
        }else {
            return "插入失败";
        }
    }
}