Package com.vsked.bean

Examples of com.vsked.bean.TblSmsSend


      String isNowSend=request.getParameter("rIsNowSend");     
      String sendTime=request.getParameter("sendTime");
       conn=ConnectDB.getSqlServerConnection();
       st=conn.createStatement();
      for(int i=0;i<numberArray.length;i++){
        st=new TblSmsSendDAO().add(st,new TblSmsSend(numberArray[i],sendTime,smsContent,1));
       
      }//end for i
      }catch(Exception e){
        e.printStackTrace();
      }finally{
View Full Code Here


            rs = pt.executeQuery();
            while(rs.next()) {
              if(tblSmsSendList==null){
                tblSmsSendList=new ArrayList<TblSmsSend>();
              }
              TblSmsSend tss=new TblSmsSend();
              tss.setSmsId(rs.getInt("sms_id"));
              tss.setReceiveTell(rs.getString("receivetell"));
              tss.setSendTime(rs.getString("sendtime"));
              tss.setSmsContent(rs.getString("smscontent"));
              tss.setStatus(rs.getString("status"));
              tss.setEnterTime(rs.getString("enter_time"));
              tss.setRemark(rs.getInt("remark"));
              tss.setAgentId(rs.getString("agent_id"));
              tss.setChannelId(rs.getString("channel_id"));
              tss.setCommandlibName(rs.getString("commandlib_Name"));
              tblSmsSendList.add(tss);
            }

        } catch (Exception e) {
            e.printStackTrace();
View Full Code Here

            rs = pt.executeQuery();
            while(rs.next()) {
              if(tblSmsSendList==null){
                tblSmsSendList=new ArrayList<TblSmsSend>();
              }
              TblSmsSend tss=new TblSmsSend();
              tss.setSmsId(rs.getInt("sms_id"));
              tss.setReceiveTell(rs.getString("receivetell"));
              tss.setSendTime(rs.getString("sendtime"));
              tss.setSmsContent(rs.getString("smscontent"));
              tss.setStatus(rs.getString("status"));
              tss.setEnterTime(rs.getString("enter_time"));
              tss.setRemark(rs.getInt("remark"));
              tss.setAgentId(rs.getString("agent_id"));
              tss.setChannelId(rs.getString("channel_id"));
              tss.setCommandlibName(rs.getString("commandlib_Name"));
              tblSmsSendList.add(tss);
            }

        } catch (Exception e) {
            e.printStackTrace();
View Full Code Here

            rs = pt.executeQuery();
            while(rs.next()) {
              if(tblSmsSendList==null){
                tblSmsSendList=new ArrayList<TblSmsSend>();
              }
              TblSmsSend tss=new TblSmsSend();
              tss.setSmsId(rs.getInt("sms_id"));
              tss.setReceiveTell(rs.getString("receivetell"));
              tss.setSendTime(rs.getString("sendtime"));
              tss.setSmsContent(rs.getString("smscontent"));
              tss.setStatus(rs.getString("status"));
              tss.setEnterTime(rs.getString("enter_time"));
              tss.setRemark(rs.getInt("remark"));
              tss.setAgentId(rs.getString("agent_id"));
              tss.setChannelId(rs.getString("channel_id"));
              tss.setCommandlibName(rs.getString("commandlib_Name"));
              tblSmsSendList.add(tss);
            }

        } catch (Exception e) {
            e.printStackTrace();
View Full Code Here

                    (trs.getRecContent().replace(" ", "").length()<=2?"":
                    trs.getRecContent().replace(" ", "").substring(2)));
        System.out.println("class:"+(trs.getRecContent().replace(" ", "").length()<=2?"":
          trs.getRecContent().replace(" ", "").substring(2)));
        st = new TblSmsSendDAO().add(st,
            new TblSmsSend(trs.getRecPhone(), result, 1));
        /**
         * 更新短信接收处理状态
         */
        new TblRecSmsDAO().updateIsNew(trs.getId());

View Full Code Here

                //TODO 将删除
                System.out.println(sendSmsStr);
                Connection conn=ConnectDB.getSqlServerConnection();
                Statement sta=conn.createStatement();
              
                sta=new TblSmsSendDAO().add(sta,new TblSmsSend(tr.getRecPhone(),sendSmsStr,2,tc.getCommandlibName()));
                sta.executeBatch();
                //执行成功+1
                new TbCommandlibDAO().updateSuccCount(tc.getCommandlibId());
                count++;
                sta.close();
                conn.close();
               
                }               
              }
              if(count==0){
                sendSmsStr=tc.getMsgNull();
                if(!"".equals(sendSmsStr.trim()))
                {
                Connection connn=ConnectDB.getSqlServerConnection();
                Statement stn=connn.createStatement();
                stn=new TblSmsSendDAO().add(stn,new TblSmsSend(tr.getRecPhone(),sendSmsStr,2,tc.getCommandlibName()));
                stn.executeBatch();
                 //执行成功+1
                new TbCommandlibDAO().updateSuccCount(tc.getCommandlibId());
                stn.close();
                connn.close();
                //TODO 将删除
                System.out.println(sendSmsStr);
                }
              }
              }catch(Exception e){
                e.printStackTrace();
                sendSmsStr=tc.getMsgErr();
                //TODO 将删除
                if(!"".equals(sendSmsStr.trim()))
                {
                System.out.println(sendSmsStr);
                Connection conne=ConnectDB.getSqlServerConnection();
                Statement ste=conne.createStatement();
                ste=new TblSmsSendDAO().add(ste,new TblSmsSend(tr.getRecPhone(),sendSmsStr,2,tc.getCommandlibName()));
                ste.executeBatch();
                //执行失败+1
                new TbCommandlibDAO().updateFailCount(tc.getCommandlibId());
                ste.close();
                conne.close();
                }
               
              }
             
             
            }else{
              //未知指令判定
              TbSetMsg tsm=new TbSetMsgDAO().getTbSetMsg();
              if(tsm.getIsEnable()==0){
                 Connection conne=ConnectDB.getSqlServerConnection();
                 Statement ste=conne.createStatement();
                 sendSmsStr=tsm.getMsgMemo();
                 ste=new TblSmsSendDAO().add(ste,new TblSmsSend(tr.getRecPhone(),sendSmsStr,2,"未知指令"));
                 ste.executeBatch();
                 ste.close();
                 conne.close();
                 isNewComm=true;
              }
View Full Code Here

            Connection conn=ConnectDB.getSqlServerConnection();
            Statement st=conn.createStatement();
            String sendTime="";
            SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            sendTime=sdf.format(new Date()).toString();
            st=new TblSmsSendDAO().add(st,new TblSmsSend(mts.getSjhm().trim(),sendTime,mts.getDfnr(),0));
            if(st.executeBatch().length>0)
            {
              new MessageToSentDAO().updateMessageToSentZT(mts.getMsgId());
            }
            st.close();
View Full Code Here

TOP

Related Classes of com.vsked.bean.TblSmsSend

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.