package com.example.server.mysql.service;
|
|
import com.example.client.entity.RenException;
|
import com.example.client.service.BaseService;
|
import com.example.server.mysql.dao.SysMysqlDao;
|
import com.example.server.mysql.model.ColumnsTemp;
|
import com.example.server.mysql.model.SysMysql;
|
import org.apache.commons.io.input.ReversedLinesFileReader;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.stereotype.Service;
|
|
import javax.servlet.ServletOutputStream;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.BufferedOutputStream;
|
import java.io.File;
|
import java.io.IOException;
|
import java.util.ArrayList;
|
import java.util.Collections;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.stream.Collectors;
|
|
|
@Service
|
public class SysMysqlService extends BaseService<SysMysqlDao, SysMysql> {
|
|
|
public SysMysql check(String sql) {
|
try {
|
SysMysql sysMysql = new SysMysql();
|
List<Map<String, Object>> data = baseDao.check(sql);
|
List<ColumnsTemp> tableColumns = new ArrayList<>();
|
|
for (Map<String, Object> map : data) {
|
ColumnsTemp obj = null;
|
for (Map.Entry<String, Object> entry : map.entrySet()) {
|
obj = new ColumnsTemp();
|
obj.setProp(entry.getKey());
|
obj.setLabel(entry.getKey());
|
tableColumns.add(obj);
|
}
|
break;
|
}
|
sysMysql.setTableColumns(tableColumns);
|
sysMysql.setTableData(data);
|
return sysMysql;
|
} catch (Exception e) {
|
e.printStackTrace();
|
throw new RenException(String.valueOf(e));
|
}
|
|
|
}
|
|
public void execute(String sql) {
|
try {
|
baseDao.execute(sql);
|
} catch (Exception e) {
|
e.printStackTrace();
|
throw new RenException(String.valueOf(e));
|
}
|
}
|
}
|
