update userInf.byCondition

whycrzh

2021-01-23 d1491636bcc06c9bb23b4955c3d8d0bfe7749e6d

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
package com.fgkj.services;
 
import com.fgkj.dto.ServiceModel;
import com.fgkj.dto.User_Chart;
import com.fgkj.dto.User_inf;
import com.fgkj.mapper.impl.User_ChartMapper;
import org.springframework.stereotype.Service;
 
import javax.annotation.Resource;
import java.io.File;
import java.util.List;
@Service
public class User_ChartService {
 
    ServiceModel model = new ServiceModel();
 
    @Resource
    private User_ChartMapper mapper;;
    
    //添加图标
    public ServiceModel add(Object obj){
        Boolean bl=mapper.add(obj);
        if(bl){
            model.setCode(1);
            model.setMsg("添加成功!");
        }else{
            model.setCode(0);
            model.setMsg("添加失败!");
        }
        return model;
    }
    //修改图标信息
    public ServiceModel update(Object obj){
        Boolean bl=mapper.update(obj);
        if(bl){
            model.setCode(1);
            model.setMsg("添加成功!");
        }else{
            model.setCode(0);
            model.setMsg("添加失败!");
        }
        return model;
    }
    //删除图标
    public ServiceModel del(User_Chart obj){
        Boolean bl=mapper.del(obj)>0;
        if(bl){
            model.setCode(1);
            model.setMsg("删除成功!");
        }else{
            model.setCode(0);
            model.setMsg("删除失败!");
        }
        return model;
    }
    //查询所有图标
    public ServiceModel searchAll(){
        ServiceModel model = new ServiceModel();
        List list=mapper.searchAll();
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setMsg("查询成功!");
            model.setData(list);
        }else{
            User_Chart uchart=new User_Chart();
            uchart.setChart_file("whyc");//默认武汉源畅图表
            model.setCode(0);
            model.setData(list);
            model.setMsg("查询失败!");
        }
        return model;
    }
    //根据用户id查图表
    public ServiceModel serchByCondition(User_inf obj){
        ServiceModel model = new ServiceModel();
        List list=mapper.serchByCondition(obj);
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setMsg("查询成功!");
            model.setData(list);
        }else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }
    
    //根据chartfile和列名查具体的图片
    public ServiceModel serchByInfo(User_Chart obj){
        ServiceModel model = new ServiceModel();
        List list=mapper.serchByInfo(obj);//TODO java.lang.NoSuchMethodException: java.sql.Blob.<init>()
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setMsg("查询成功!");
            model.setData(list);
        }else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }
    public static void main(String[] args) {
         User_ChartService us=new User_ChartService();
        User_Chart uchart=new User_Chart();
        uchart.setChart_file("gjdw");
        uchart.setChart_logo(new File("D://GitWorkSpace/tieta/fuguang/WebRoot/images/tieta/logo.png"));
        us.update(uchart);
    }
}