update databaseBackup#

whycrzg

2021-02-02 028d5568c2e8c8f649b1f395d76826944cd5f1a9

update databaseBackup#

 src/main/java/com/fgkj/controller/Database_backupController.java

@@ -23,9 +23,10 @@
    @Resource
    private Database_backupService service;


    //根据数据库名和表名修改备份数据库的使能(多笔记录)
    @PutMapping("pro")
    @ApiOperation(notes = "",value="数据库名和表名修改备份数据库的使能(多笔记录)")
    @ApiOperation(notes = "[{ \"database_name\": \"web_site\", \"table_name\": \"tb_batt_discharge\", \"backup_en\": 1 }]",value="数据库名和表名修改备份数据库的使能(多笔记录)")
    public ServiceModel updatePro(@RequestBody List<Database_backup> list) {
        ServiceModel model=new ServiceModel();
        /*if(json!=null&&json.length()>0){
@@ -65,11 +66,12 @@
    }

    //根据数据库名查询所有的表
    @GetMapping("allTable")
    @PostMapping("allTable")
    @ApiOperation(notes = "",value="数据库名查询所有的表")
    public ServiceModel searchAllTable(@RequestBody Database_backup baseup) {
        // Database_backup baseup=getGson().fromJson(json, Database_backup.class);
        ServiceModel model=service.searchAllTable(baseup);
    public ServiceModel searchAllTable(@RequestParam String database_name) {
        Database_backup baseup = new Database_backup();
        baseup.setDatabase_name(database_name);
        ServiceModel model = service.searchAllTable(baseup);

        return model;
    }

 src/main/java/com/fgkj/services/Database_backupService.java

@@ -5,7 +5,11 @@
import com.fgkj.dto.ServiceModelOnce;
import com.fgkj.mapper.impl.Database_backupMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.stereotype.Service;
import org.springframework.transaction.TransactionDefinition;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@@ -17,14 +21,31 @@

    @Resource
    private Database_backupMapper mapper;;
    @Autowired
    DataSourceTransactionManager dataSourceTransactionManager;
    @Autowired
    TransactionDefinition transactionDefinition;
    
    //根据数据库名和表名修改备份数据库的使能(多笔记录)
    public ServiceModel updatePro(List<Database_backup> obj) {
        boolean bl=mapper.updatePro(obj)>0;
        if(bl){
        ServiceModel model = new ServiceModel();
        TransactionStatus transactionStatus = dataSourceTransactionManager.getTransaction(transactionDefinition);
        boolean bl = true;
        try {
            bl = mapper.updatePro(obj) > 0;
        } catch (Exception e) {
            e.printStackTrace();
            dataSourceTransactionManager.rollback(transactionStatus);
            model.setCode(0);
            model.setMsg("修改失败!");
            return model;
        }
        if (bl) {
            dataSourceTransactionManager.commit(transactionStatus);
            model.setCode(1);
            model.setMsg("修改成功!");
        }else{
        } else {
            dataSourceTransactionManager.rollback(transactionStatus);
            model.setCode(0);
            model.setMsg("修改失败!");
        }
@@ -32,11 +53,12 @@
    }
    //根据数据库名和表名修改备份数据库的使能(一键修改)
    public ServiceModel updateProAll() {
        boolean bl=mapper.updateProAll()>0;
        if(bl){
        ServiceModel model = new ServiceModel();
        boolean bl = mapper.updateProAll() > 0;
        if (bl) {
            model.setCode(1);
            model.setMsg("修改成功!");
        }else{
        } else {
            model.setCode(0);
            model.setMsg("修改失败!");
        }
@@ -47,6 +69,7 @@
    
    //查询所有数据库备份信息
    public ServiceModel searchAll() {
        ServiceModel model = new ServiceModel();
        List list=mapper.searchAll();
        if(list!=null&&list.size()>0){
            model.setData(list);
@@ -61,6 +84,7 @@
    
    //查询数据库备份表中所有的数据库
    public ServiceModel searchAllDatabase() {
        ServiceModel model = new ServiceModel();
        List list=mapper.searchAllDatabase();
        if(list!=null&&list.size()>0){
            model.setData(list);
@@ -75,6 +99,7 @@

    //根据数据库名查询所有的表
    public ServiceModel searchAllTable(Database_backup obj) {
        ServiceModel model = new ServiceModel();
        List list=mapper.searchAllTable(obj);
        if(list!=null&&list.size()>0){
            model.setData(list);
@@ -89,17 +114,16 @@
    //查询个数
    public ServiceModelOnce searchNum() {
        ServiceModelOnce model = new ServiceModelOnce();
        Database_backup baseup=new Database_backup();
        Database_backup baseup = new Database_backup();
        //总数
        baseup.setNum(0);
        int sum=mapper.searchNum(baseup);
        int sum = mapper.searchNum(baseup);
        //处于备份的数目
        baseup.setNum(1);
        int baseup_num=mapper.searchNum(baseup);
        //TODO perry
         model.setSum(sum);
         model.setNewsum(baseup_num);
         model.setCode(1);
        int baseup_num = mapper.searchNum(baseup);
        model.setSum(sum);
        model.setNewsum(baseup_num);
        model.setCode(1);
        return model;
    }
}