Examples of TblSmsSendDAO

      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{

Examples of com.vsked.dao.TblSmsSendDAO

                //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;
              }

Examples of com.vsked.dao.TblSmsSendDAO

            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();