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
package com.fgkj.mapper.impl.ram;
 
import com.fgkj.dto.ram.Hard_dev_sms_state;
import org.apache.ibatis.annotations.Select;
 
import java.util.List;
 
public interface Hard_dev_sms_stateMapper{
 
 
    public boolean add(Object obj);
 
    public boolean update(Object obj);
 
    public boolean del(Object obj);
 
    //4.8查询所有的短信设备状态
    @Select("select num,sms_dev_ip,sms_ack_type,sms_sincard_ok,sms_mobile_net_ok," +
            "sms_sinal_value,sms_is_busy,sms_com_count,sms_money_rest,sms_com_err_count,note " +
            "from db_ram_db.tb_hard_dev_sms_state order by num ")
    public List<Hard_dev_sms_state> searchAll();
 
    public List serchByCondition(Object obj);
 
 
    /*public static void main(String[] args) {
        Hard_dev_sms_stateImpl hi=new Hard_dev_sms_stateImpl();
        Hard_dev_sms_state hs=new Hard_dev_sms_state();
        hs.setNum(1);
        *//*List<Hard_dev_sms_state> list=hi.serchByCondition(hs);
        System.out.println(list.size());
        for(Hard_dev_sms_state h:list){
            System.out.println(h);
        }*//*
        List<Hard_dev_sms_state> list=hi.searchAll();
        System.out.println(list.size());
        for(Hard_dev_sms_state h:list){
            System.out.println(h);
        }
    }*/
 
}