实习项目笔记第一周

完成数据中台的基本接口

records的service层

package com.baidu.eopqadc.service;

import com.baidu.eopqadc.model.Records;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class RecordsService {

    @Autowired
    private JdbcTemplate jdbcTemplate;
    
    //根据人名查找数据
    public List<Records> getRecordsByPerson(String person) throws Exception {
        String sql = "SELECT * FROM records where person = ? and deleted = 0";
        List<Records> recordsList = jdbcTemplate.query(sql, new Records(), person);
        for (Records records : recordsList) {
            System.out.println(records);
        }
        return recordsList;
    }
   //根据id删除数据
    public int delRecordsById(String id) throws Exception {
        String sql = "update records set deleted = 1  where id = ?";
        int result = jdbcTemplate.update(sql, id);
        return result;
    }


}

datacapability的service层

package com.baidu.eopqadc.service;

import com.baidu.eopqadc.model.DataCapability;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

import java.time.LocalDateTime;
import java.util.List;

import static java.time.LocalDateTime.now;


@Service
public class DataCapabilityService {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    @Autowired
    private RequestService requestservice;
    
      //查找所有数据
    public List<DataCapability> getAllDataCapability() throws Exception {
        String sql = "SELECT *  FROM datacapability where deleted != 1 ";
        List<DataCapability> dataCapabilityList = jdbcTemplate.query(sql, new DataCapability());
        for (DataCapability dataCapability : dataCapabilityList) {
            System.out.println(dataCapability);
        }
        return dataCapabilityList;
    }

    //根据id删除数据
    public int delDataCapabilityById(String id) {
        String sql = "update  datacapability set deleted = 1  where id = ?";
        int result = jdbcTemplate.update(sql, id);
        return result;


    }
    
    //增加数据
    public int addDataCapability(DataCapability s) {
        String sql = "insert into datacapability(id, name, createPerson, createTime, host, " +
                "port, api, param, isRoot, apiMethod, deleted) values(?,?,?,?,?,?,?,?,?,?,?)";

        int frag = jdbcTemplate.update(sql, s.getId(), s.getName(), s.getCreatePerson(),
                s.getCreateTime(), s.getHost(), s.getPort(), s.getApi(),
                s.getParam(), s.getIsRoot(), s.getApiMethod(), s.getDeleted());
        return frag;
    }
    
    //执行数据能力
    public String getDataCapabilityById(String id) throws Exception