update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
package com.fgkj.services;
 
import com.fgkj.dto.Batt_param_low;
import com.fgkj.dto.ServiceModel;
import com.fgkj.mapper.impl.Batt_param_lowMapper;
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 java.util.List;
 
import javax.annotation.Resource;
@Service
public class Batt_param_lowService {
 
    ServiceModel model = new ServiceModel();
 
    @Resource
    private Batt_param_lowMapper mapper;;
    @Autowired
    DataSourceTransactionManager dataSourceTransactionManager;
    @Autowired
    TransactionDefinition transactionDefinition;
    
    public ServiceModel add(Object obj) {
        Boolean bl=mapper.add(obj);
        if(bl){
            model.setCode(1);
            model.setMsg("添加成功!");
        }
        else{
            model.setMsg("添加失败!");
        }
        return model;
        
    }
    public ServiceModel update(List<Batt_param_low> list) {
        ServiceModel model = new ServiceModel();
        TransactionStatus transactionStatus = dataSourceTransactionManager.getTransaction(transactionDefinition);
        Boolean bl = true;
        for (int i = 0; i < list.size(); i++) {
            if (!(mapper.update(list.get(i)) > 0)) {
                bl = false;
            }
        }
        if (bl) {
            dataSourceTransactionManager.commit(transactionStatus);
            model.setCode(1);
            model.setMsg("修改成功!");
        } else {
            dataSourceTransactionManager.rollback(transactionStatus);
            model.setMsg("修改失败!");
        }
        return model;
    }
    
    
    
    public ServiceModel delete(Object obj) {
        Boolean bl=mapper.del(obj);
        if(bl){
            model.setCode(1);
            model.setMsg("删除成功!");
        }
        else{
            model.setMsg("删除失败!");
        }
        return model;    
    }
    public ServiceModel serchByCondition(Object obj) {
        List<Batt_param_low> list = mapper.serchByCondition(obj);
//        for (Batt_param_low u : list) {
//            System.out.println(u);
//        }
 
        if (list != null && list.size() > 0) {
            model.setCode(1);
            model.setData(list);
        }else{
            model.setMsg("查询失败!");
        }
        return model;
    }
    //根据low_type，low_nametype查阈值
    public ServiceModel serchByLow(Object obj) {
        List<Batt_param_low> list = mapper.serchByLow(obj);
        /*for (Batt_param_low u : list) {
            System.out.println(u);
        }*/
        if (list != null && list.size() > 0) {
            model.setCode(1);
            model.setData(list);
        }else{
            model.setMsg("查询失败!");
        }
        return model;
    }
    
    public ServiceModel searchAll(){
        ServiceModel model = new ServiceModel();
        List<Batt_param_low> list=mapper.searchAll();
        //System.out.println(list);
        if(list!=null && list.size()>0){
            model.setCode(1);
            model.setData(list);
        }        
        return model;
    }
    public static void main(String[] args) {
        //new Batt_param_lowService().searchAll();
        Batt_param_low b=new Batt_param_low();
        b.setNum(2);
        new Batt_param_lowService().serchByCondition(b);
    }
}