當前位置:名人名言大全網 - 短信平臺 - 求壹篇 外文文獻翻譯 畢設用~

求壹篇 外文文獻翻譯 畢設用~

原文:短信貓 VB SQL

(說明:本接口支持 MSSQL和Access或其它任何關系型數據庫,有1-16端口版可供選擇)

(本接口為綠色免安裝版,更便於開發及再發布)

( 1 ) 數據庫接口功能:

通過本數據庫接口,能使妳現有的系統(如OA、CRM、ERP等系統)輕松實現無線辦公功能,無論妳用的是哪種開發語言(VB\VC\VFP\asp\jsp\java\pb\delphi...),只要妳的系統能讀MS SQL 2000 或 Access數據庫即可對接!妳僅需要在指定的表中添加記錄,本接口程序就自動進行發送及接收了,所以,您不需要了解任何有關數據通信方面的知識,就可實現手機短信的收發等功能!

“0”代碼就能使妳的現在系統增加手機短信收發功能!

( 2 ) 使用步驟:

第1步:正確連接手機、短信貓(或其它短信設備)到電腦

第2步:啟動“Sms_Server.exe”,實際應用中可以讓本接口程序開機時自動運行並最小化(見設置)。

第3步:正確設置端口參數,點擊“啟動連接”按鈕(本步也可設為自動執行,見設置)

第4步:在您原有的系統中通過操作程序目錄下的的數據庫data.mdb(或SQL中的表)進行手機短信的收發,例如:要發送短信,只需在data.mdb的outbox表中添加記錄,系統就會自動發送(詳見下面說明)

簡單來說分兩步,即是:① 運行 Sms_Server.exe > ② 通過操作數據庫進行短信的收發

(詳見下面說明)

說明:A、如果使用Aceess數據庫,默認為安裝目錄下的data.mdb當

B、如果使用MS SQL數據庫,請恢復安裝目錄下的數據庫文件SmsData.bak,並修改安裝目錄下的SET.INI 文件“database”的值即可

C、當然,妳也可以按照我們的數據庫結構在其它任何的數據庫中添加相應的表,然後修改SET.INI文件的database值,以進行連接!

( 2 )接口功能簡述:

本接口是以數據庫的形式提供,在接口的安裝目錄裏有壹數據庫文件 data.mdb,裏面有五個主要的表,詳細說明如下:

(壹)、OutBox表 待發短信列表 (只需在此表中插入記錄,即可實現短信的發送)

[Mbno] 目標手機號碼,字符串,如:13632263389、1861等

[Msg] 短信內容,字符串,最高1000個漢字,有自動分割功能

[SendTime] 計劃發送的時間,日期型,如:2005-8-19 21:31:11

[Report] 是否需發送報告,數值型,Report=1時需報告,Report=0時不需報告

[ComPort] 端口號,數值型,設定發送本條信息所使用的端口號,為0(或不填)時為自動端口號

[Userrname] 預留字段,供擴展用

[ V1 ]-[ V5 ] 預留字段,供擴展用

(二)、InBox表 已收到的短信列表 (收到的短信內容會自動保存到本表中)

[Mbno] 來信的手機號碼

[Msg] 收到的短信內容

[ArriveTime] 短信收到的時間

[Comport] 收到該短信的串口號

(三)、SendedOutBox表 已發短信列表

[Mbno] 已發的手機號碼

[Msg] 已發的短信內容

[SendTime] 發送的時間

[Comport] 發送該短信所用的串口號

[Userrname] 預留字段,供擴展用,與outbox表對應

[ V1 ]-[ V5 ] 預留字段,供擴展用,與outbox表對應

(四)、Badoutbox表 發送失敗的短信列表

[Mbno] 發送失敗的的手機號碼

[Msg] 發送失敗的的短信內容

[SendTime] 發送失敗的時間

[Bad_why] 發送失敗的原因

[Userrname] 預留字段,供擴展用,與outbox表對應

[ V1 ]-[ V5 ] 預留字段,供擴展用,與outbox表對應

(五)、Report表 發送報告列表(當OutBox表中的Report=1時,才會產生發送報告)

[RpMsg] 報告的內容

[SendTime] 信息發出時間

[ArrivedTime] 對方收到(或未收到)的回應時間

[相關操作]

客戶收發信息的可通過操作該數據庫完成,舉例:

A、例如想發送信息,只需向 Outbox 表中寫入壹條記錄(包括 Msg-“內容”,Mbno—“手機號碼”,SendTime-“計劃發送的時間”,其中必填項為:Msg和Mbno),錄添加後,本接口將在規定的時間發出該手機信息(如果sendtime不填,默認為當前時間,即馬上發送)

B、如想收信息,只要讀 Inbox 表的記錄即可(系統會自動接收新信息並保存到 Inbox 表中的)

C、如果待發列表(OutBox表)中的內容成功發出,會轉存在 Sendedoutbox 表中,如果未成功發出,轉存入 Badoutbox 表中並自動記錄發送失敗的原因!

[相關設置]

A、可設置接口程序為開機時自動啟動,自動最小化

B、可設定接口程序的工作模式

C、可自動保存短信收發的運行記錄

V 4.0新增加功能:

關於無人值守方式的說明

所謂的無人值守,即是可以先同時連接多個短信貓(如8個),但開始時只啟用其中部分(如其中2臺),當這兩臺短信貓因為欠費或其它原因而連續發送失敗到指定的條數時(如20 條),自動啟動其它的短信貓進行發送,實現壹定意義上的無人值守!

關於端口限定發送數的說明

可以針對每個端口,設定該端口允許的最大發送短信量,超過該數量時,自動停止該端口發送。

V 5.0 新增功能

1、采用新的線程技術,在保證發送穩定性及速度的前提下,減少了系統資源的占用,壹般發短信時CPU僅占用 3 % 左右。

譯文:SMS cat VB SQL

(note: this interface MSSQL support and Access or any other relational database, have 1-16 ports edition options),

(this is green, more facilitate free installation and then released)

(1) database interface functions:

Through this database interface, can make your existing systems (e.g., OA system, CRM, ERP) easy wireless office function, whether you use what language (VB \ VC development \ \ \ \ JSP VFP asp pb, Delphi Java \...). The system can, as long as you read the MS SQL 2000 or Access database can butt! You only need to add in designated tables records, the program will automatically send interface and receive, so you don't need to know anything about data communication of knowledge, can realize the function such as send SMS messages!

"0" code can make you now send SMS increased system function.

(2) use steps:

Step 1: correct connection phone, SMS messages cat (or other equipment) to the computer

Step 2: start ", "Sms_Server exe. In actual application program interface allows the boot automatically run and minimization (see).

Step 3: set correctly, click the "start port parameters connected" button (this step is set to automatically, can see Settings)

Step 4: in your original system through the procedures of the directory database data. The table (or SQL MDB) receive SMS, for example: to send SMS, only the data in the table, MDB outbox add records, the system will automatically send (see below)

In simple terms, which is divided into two steps: (1) > 2) Sms_Server running through the operation exe. Send messages database

(see below)

Description: A, if use Aceess database, the default installation directory data. MDB when

B, if use MS SQL database, please restore installation directory database files, and modify the SmsData bak. Under the installation directory database "SET. INI files can be of value

C, of course, you can also according to our database structure in any other database table, then add the corresponding modification of the database files. SET to connect!

(2) interface function briefly:

This interface is provided in the form of database, and the installation directory interface in a database file data, there are five.mdb. The main table, details are as follows:

(a), OutBox table ready in the message list (just insert table, can send SMS),

[Mbno] target mobile phone number, string, such as: 13632263389, 1861, etc

[text], Msg, top 1,000 character string, an automatic segmentation function

[SendTime] plans to send time, date type, such as: 2005-8-19 21:31:11

[about] whether to send Report, numeric, about 1 = = 0, should Report about the Report

[ComPort] socket, numeric, setting this information sent by use of port, 0 (or not) for automatic filling the slogan

[aside], Userrname for extended use. Field

[[V5]] - V1 set for expansion in fields

(2), has received the message InBox watch list (received messages will be saved to this),

[Mbno letter] the mobile phone number

[Msg] received messages

[ArriveTime] message received

[Comport] received this message of serial number

(3), SendedOutBox table has hair message list

[Mbno] have cell phone number

Msg] [the message content already

[SendTime] send time

Send this message Comport] [the serial number

[aside], Userrname field, and extended use outbox corresponding

[[V5]] - V1 set for expansion, and field with outbox corresponding

(4), send SMS Badoutbox table failed

[Mbno] send failure of mobile phone number

Msg] [the messages sent failure

[SendTime] failure time send

[Bad_why] send failure

[aside], Userrname field, and extended use outbox corresponding

[[V5]] - V1 set for expansion, and field with outbox corresponding

(5), watch list (Report about the table when OutBox about = 1, will produce send Report)

[RpMsg] the content of the report

[a]]. SendTime information

[ArrivedTime] person received (or not) received response time

[related operation]

Customers can receive information through the database, operation, for example:

A, such as wants to send information, just to write A record Outbox table (including Msg - "content", Mbno - "mobile phone number", SendTime - "plans to send time", which should Mbno) for: Msg and record after adding the interface in specified time will send the information SendTime (if not fill, default for the current time and send), i.e.

B, if want to collect information, read the record can watch Inbox (system will automatically receive a new information and save to watch the Inbox

C, if ready list (list) of content OutBox success will turn out there, Sendedoutbox list, if not success, turn into Badoutbox list and record automatically send the reason for failure!

[associated Settings]

A, can install interface program for boot automatically activated, automatic minimization

B, the program can be set interface work mode

C, can automatically save text receiving running record

V: new increasing function 4.0

The way of explanation about the unattended.

The so-called unattended, which can be connected to and multiple SMS (8) like cat, but only the beginning of opening part (such as 2), when the two messages cat because owe or other reason for failure to send a number (such as 20), automatic start to send text messages to other cats, a sense of unattended!

The limited number of sending about that port.

For each port, can set the maximum allowable port, more than the quantity of sending messages, automatically stop when the number of the port.

V 5.0 new function

1 and adopting new technology, in order to ensure thread send stability and speed, under the premise of reduced system resource, general text only when the CPU occupies around 3 percent.