物联网课程设计-基于温湿度传感器物联网应用实时数据处理系统开发46

1、网络工程（物联网技术）课程设计报告题 目： 基于温湿度传感器物联网应用实时数据处理系统开发 院（系） 别： 数学与信息工程学院 专业： 网络工程（物联网技术） 班级 1 班 学 号： 2006099914 姓 名： 小 明 指导教师： 职称 博士 填表日期： 2012 年 5 月 11 日前 言一、选题的依据及意义依据物联网是一种新概念和新HYPERLINK /list/jishu.shtml技术，它使新一代IT技术更加充分地应用于各行各业之中。它的问世打破了过去将基础设施与IT设施分开的传统观念，将建筑物、公路、铁路和网站、网络、数据中心合为一体，是信息化和工业化融合的重要切入点。温湿度与人

2、们的生活关系密切，所以物联网在温湿度实时数据处理系统的开发将有很大的前景。意义 在我们的日常生活中无处不在，控制好温湿度可以使我们生活、生产的更好。温湿度传感器物联网应用实时数据处理系统开发可以帮我们实现对温湿度以实时数据让我们明了的知道。从而更好的控制温湿度、达到我们所需的标准。二、本课程设计内容简介1. 通过ubuntu连接传感器实验箱收集由传感器测得的实时数据存入sqlite3数据库。2. 然后通过ubuntu发送到linux、接收并用动态网页显示代表数据变化的曲线。三、要达到的目标1.可以在ubuntu上实现自动接收由传感器取得、传来的实时数据。2. 并ubuntu上能边接收边连续往l

3、inux发送从传感器取得的实时数据。3还要确保发送过的数据不会再次发送。4. Linux能接收到ubuntu发过来的实时数据并通过动态网页曲线图实时显示接收过来的数据。实 现 方 案一、开发环境1.硬件（详细介绍所涉及硬件的详细内容）Pc机、温湿度传感器、传感器实验箱、连接所需的各种线。2.软件（详细介绍所涉及软件的详细内容） MDK414（arm平台编译烧录代码软件）、KeilC51v750a_Full（C51平台编译软件）、STC手动下载（C51烧录代码软件）、R340（串口线连接USB驱动）、ubuntu操作系统、linux操作系统。3.其它二、开发内容1.项目开发详细内容（包括传感器的

4、配置、传感器烧录、数据的实时收集、实时数据的存储、实时数据的传输、实时数据在服务器端的接受及存储-TCPServer及MySql、数据库及Web服务器安装、利用JSP曲线动态显示实时数据）首先烧录整合好的温湿度传感器的代码。接着连接传感器取得数据。然后在ubuntu中编译并运行Com_Sensor程序获取传感器实验箱的数据。在Ubuntu11编译并运行senddata.c把数据发送到linux.Linux通过TCPServer服务器接收数据并存入MySQL数据库。最后将接收到的数据通过Linuxweb服务器以jsp曲线动态显示实时数据。2.网络拓扑图（包括传感器、网关、传输网络、TCPServ

5、er服务器、数据库服务器、静态及动态Web服务器、Web服务器客户端；并详细标注设备名称及IP地址等详细信息；并详细叙述网络拓扑图流程） 三、技术路线传感器数据处理（给出详细的传感器烧录代码 ）代码如下：/*/中软吉大信息技术有限公司/物联网传感技术教学实验系统/*/#include /Keil library (is used for _nop()_ operation) #include /Keil library #includeLcmdisplay.h #define FOSC 11059200#define BAUD 14400typedef union unsigned int i

6、; float f; value;/ / modul-var / enum TEMP,HUMI; #define noACK 0 #define ACK 1 /adr command r/w #define STATUS_REG_W 0 x06 /000 0011 0 #define STATUS_REG_R 0 x07 /000 0011 1 #define MEASURE_TEMP 0 x03 /000 0001 1 #define MEASURE_HUMI 0 x05 /000 0010 1 #define RESET 0 x1e /000 1111 0 sbit DATA=P22;sb

7、it SCK=P21;sbit POWER=P25;sbit flag1=P07;sbit flag2=P46;sbit flag3=P27;sbit flag4=P26; void delay(unsigned int nTimeDelay) unsigned int i; while (nTimeDelay-) for (i=0;i125;i+); void Serial_Init() TMOD = 0 x01; TR0 = 1; EA = 1; ET0 = 0; TF0 = 0; S2CON = 0 x50; /8位可变波特率 (无校验位) BRT = -(FOSC/32/BAUD);

8、/设置独立波特率发生器的重载初值 AUXR = 0 x14; /独立波特率发生器工作在1T模式 /IE2 = 0 x01; /使能串口2中断void IO_Init(void)P2M1=P2M1&0 xdf;P2M0=P2M0&0 xdf;P0M1=P0M1&0 x7f;P0M0=P0M0&0 x7f;P4M1=P4M1&0 xbf;P4M0=P4M0&0 xbf;P2M1=P2M1&0 x3f;P2M0=P2M0&0 x3f;P4SW=P4SW|0 x40;void Power_Identify(void)while(1)if(POWER=0)delay(4000);LcmPrintf(请给

9、传感器模块上电!n);else break;void Module_Identify(unsigned int xuhao)unsigned int abc=0;if(flag4=1)abc=abc+1;abc=abc1;if(flag3=1)abc=abc+1;abc=abc1;if(flag2=1)abc=abc+1;abc=abc0;i/=2) /shift bit for masking if (i & value) DATA=1; /masking value with i , write to SENSI-BUS else DATA=0; _nop_(); /observe set

10、up time SCK=1; /clk for SENSI-BUS _nop_();_nop_();_nop_(); /pulswith approx. 5 us SCK=0; _nop_(); /observe hold time DATA=1; /release DATA-line _nop_(); /observe setup time SCK=1; /clk #9 for ack error=DATA; /check ack (DATA will be pulled down by SHT11) SCK=0; return error; /error=1 in case of no a

11、cknowledge / char s_read_byte(unsigned char ack) / / reads a byte form the Sensibus and gives an acknowledge in case of ack=1 unsigned char i,val=0; DATA=1; /release DATA-line for (i=0 x80;i0;i/=2) /shift bit for masking SCK=1; /clk for SENSI-BUS if (DATA) val=(val | i); /read bit SCK=0; DATA=!ack;

12、/in case of ack=1 pull down DATA-Line _nop_(); /observe setup time SCK=1; /clk #9 for ack _nop_();_nop_();_nop_(); /pulswith approx. 5 us SCK=0; _nop_(); /observe hold time DATA=1; /release DATA-line return val; / void s_transstart(void) / / generates a transmission start / _ _ / DATA: |_| / _ _ / S

13、CK : _| |_| |_ DATA=1; SCK=0; /Initial state _nop_(); SCK=1; _nop_(); DATA=0; _nop_(); SCK=0; _nop_();_nop_();_nop_(); SCK=1; _nop_(); DATA=1; _nop_(); SCK=0; / void s_connectionreset(void) / / communication reset: DATA-line=1 and at least 9 SCK cycles followed by transstart / _ _ / DATA: |_| / _ _

14、_ _ _ _ _ _ _ _ _ / SCK : _| |_| |_| |_| |_| |_| |_| |_| |_| |_| |_| |_ unsigned char i; DATA=1; SCK=0; /Initial state for(i=0;i=1 in case of no response form the sensor / char s_measure(unsigned char *p_value, unsigned char *p_checksum, unsigned char mode) / / makes a measurement (humidity/temperat

15、ure) with checksum unsigned char error=0; unsigned int i; s_transstart(); /transmission start switch(mode) /send command to sensor case TEMP : error+=s_write_byte(MEASURE_TEMP); break; case HUMI : error+=s_write_byte(MEASURE_HUMI); break; default : break; for (i=0;i100)rh_true=100; /cut if the value

16、 is outside of if(rh_true0.1)rh_true=0.1; /the physical possible range *p_temperature=t_C; /return temperature C *p_humidity=rh_true; /return humidity%RH / float calc_dewpoint(float h,float t) / / calculates dew point / input: humidity %RH, temperature C / output: dew point C float k,dew_point ; k =

17、 (log10(h)-2)/0.4343 + (17.62*t)/(243.12+t); dew_point = 243.12*k/(17.62-k); return dew_point; / void main() / / sample program that shows how to use SHT11 functions / 1. connection reset / 2. measure humidity ticks(12 bit) and temperature ticks(14 bit) / 3. calculate humidity %RH and temperature C

18、/ 4. calculate dew point C / 5. print temperature, humidity, dew point value humi_val,temp_val; float dew_point; unsigned char error,checksum; unsigned int i; Serial_Init();IO_Init();Power_Identify();Module_Identify(3); s_connectionreset(); while(1) error=0; error+=s_measure(unsigned char*) &humi_va

19、l.i,&checksum,HUMI); /measure humidity error+=s_measure(unsigned char*) &temp_val.i,&checksum,TEMP); /measure temperature if(error!=0) s_connectionreset(); /in case of an error: connection reset else humi_val.f=(float)humi_val.i; /converts integer to float temp_val.f=(float)temp_val.i; /converts int

20、eger to float calc_sth11(&humi_val.f,&temp_val.f); /calculate humidity, temperature dew_point=calc_dewpoint(humi_val.f,temp_val.f); /calculate dew point Power_Identify();LcmDisplaySHT10(humi_val.f,temp_val.f);/LcmPrintf(温度:%5.1f 湿度:%5.1f 露点:%3.1fn, temp_val.f,humi_val.f,dew_point);/temp ：温度/for (i=0

21、;i40000;i+);/延迟/LcmPrintf(, humi_val.f);/humi:湿度/for (i=0;i40000;i+);/延迟/LcmPrintf(, dew_point);/dewpoint:露点（点在此温度时，空气饱和并产生露珠） /wait approx. 0.8s to avoid heating up SHTxx for (i=0;i50000;i+); /(be sure that the compiler doesnt eliminate this line!) / Lcmdisplay.c:#include Lcmdisplay.htypedef enum L

22、CMPRTF = 0, / 字符串打印 / 1 磁感应及环境光传感器模块 LCMHALL, / 霍尔接近开关 LCMREED, / 干簧管 LCMMETAL, / 金属接近开关 LCMLUX, / 环境光强度 LCMLDR, / 光敏电阻 / 2 震动及mems麦克传感器模块 LCMSHOCKDS, / 双珠单向 LCMSHOCKDD, / 双珠双向 LCMSHOCKSPRING, / 弹簧 LCMSHOCK, / 全向震动 LCMMIC, / MEMS麦克风 / 3 测距测障类及温湿度类传感器模块 LCMIR, / 红外对管测距 LCMIRSWITCH, / 红外接近开关 LCMULTR,

23、/ 超声波测距 LCMTEMP, / 温度/ DS18b20 LCMSHT10, / 温湿度传感器SHT10 LCMHUMI, / 湿度/SHT10 LCMNTC, / 热敏电阻 / 4 操作控制类及加速传感器模块 LCMACC, / 三轴加速度 LCMJOYSTICK, / 摇杆电位器 LCMENCODER, / 编码开关 / 5 称重传感器模块 LCMWEIGHT, / 称重 / 6 粉尘传感器模块 LCMDUST, / 粉尘 / 7 红外测温及颜色传感器模块（增强型模块） LCMBODYTEMP, / 红外测体温 LCMCOLOR, / 颜色 / 8 磁阻陀螺仪及气压传感器模块（增强型模

24、块） LCMRELUCTANCE, / 三轴磁阻 LCMANGRATE, / 三轴角速率陀螺仪 LCMPRESSURE, / 气压 / 9 二氧化碳传传感器模块（扩展型模块） LCMCO2, / 二氧化碳 / 10 气体流量传感器模块（扩展型模块） LCMFLOW, / 气体流量 LCMINIT / 初始值 flag_t;void swap(char *cp)unsigned char temp;temp=cp3;cp3=cp0;cp0=temp;temp=cp2;cp2=cp1;cp1=temp;void sendc (unsigned char chr)/发送一个字符 S2BUF = ch

25、r; while(!(S2CON & 0 x02); S2CON &= 0 x02; unsigned char recvc (void)unsigned char chr;while(!(S2CON & 0 x01); S2CON &= 0 x01; chr = S2BUF;return chr;static void packetLcm(flag_t flag, char *data1, int length) sendc(0 x7e); sendc(0 xff); sendc(0 x06);/改成6 sendc(flag); while(length-) switch (*data1)

26、case 0 x7e: sendc(0 x7d); sendc(0 x5e); case 0 x7d: sendc(0 x7d); sendc(0 x5e); default: sendc(*data1); data1+; sendc(0 x00); sendc(0 x00);sendc(0 x7e); / 等待显示完成 /recvc();/ 字符串打印到液晶void LcmPrintf(char *fmt, .) va_list ap; va_start(ap,fmt); vsprintf(data1, fmt, ap);va_end(ap); packetLcm(LCMPRTF, data

27、1, strlen(data1);/ 1 磁感应及环境光传感器模块/LCMHALL, / 霍尔接近开关/ 霍尔传感器，有磁铁靠近TRUE，离开FALSEvoid LcmDisplayHall(bool v) conv_t conv;conv.b = v;swap(conv.c); packetLcm(LCMHALL, conv.c, 4);/LCMREED, / 干簧管/ 干簧管，有磁铁靠近TRUE，离开FALSEvoid LcmDisplayReed(bool v) conv_t conv;conv.b = v;swap(conv.c); packetLcm(LCMREED, conv.c,

28、 4);/LCMMETAL, / 金属接近开关/ 金属传感器，有金属靠近TRUE，离开FALSEvoid LcmDisplayMetal(bool v) conv_t conv;conv.b = v;swap(conv.c); packetLcm(LCMMETAL, conv.c, 4);/LCMLUX, / 环境光强度/ 环境光强度，Luxvoid LcmDisplayLux(float v) conv_t conv; conv.f = v;swap(conv.c); packetLcm(LCMLUX, conv.c, 4);/LCMLDR, / 光敏电阻/ 光敏电阻，千欧void LcmD

29、isplayLDR(float v) conv_t conv; conv.f = v;swap(conv.c); packetLcm(LCMLDR, conv.c, 4);/ 2 震动及mems麦克传感器模块/LCMSHOCKDS, / 双珠单向void LcmDisplayShockDS(bool v) conv_t conv;conv.b = v; packetLcm(LCMSHOCKDS, conv.c, sizeof(v);/LCMSHOCKDD, / 双珠双向void LcmDisplayShockDD(bool vl, bool vr) conv_t conv; if (vl &

30、vr) conv.uc = 0 xff; else if (vl & !vr) conv.uc = 0 xf0; else if (!vl & vr) conv.uc = 0 x0f; else conv.uc = 0 x00; packetLcm(LCMSHOCKDD, conv.c, sizeof(unsigned char);/LCMSHOCKSPRING, / 弹簧void LcmDisplayShockSpring(bool v) conv_t conv;conv.b = v; packetLcm(LCMSHOCKSPRING, conv.c, sizeof(v);/LCMSHOCK

31、, / 全向震动/ 全向震动void LcmDisplayShock(bool v) conv_t conv;conv.b = v; packetLcm(LCMSHOCK, conv.c, sizeof(v);/LCMMIC, / MEMS麦克风void LcmDisplayMIC(float v) conv_t conv; conv.f = v;swap(conv.c); packetLcm(LCMMIC, conv.c, 4);/ 3 测距测障类及温湿度类传感器模块/LCMIR, / 红外对管/ 红外对管电压，单位Vvoid LcmDisplayIR(float v) conv_t con

32、v;conv.f = v;swap(conv.c); packetLcm(LCMIR, conv.c, 4);/LCMIRSWITCH, / 红外接近开关void LcmDisplayIRSwitch(bool v) conv_t conv;conv.b = v; packetLcm(LCMIRSWITCH, conv.c, sizeof(v);/LCMULTR, / 超声波测距/ 超声波测距，单位厘米void LcmDisplayUltr(float v) conv_t conv;conv.f = v;swap(conv.c); packetLcm(LCMULTR, conv.c, 4);/

33、LCMTEMP, / 温度/ DS18b20/ 温度，摄氏度void LcmDisplayTemp(float v) conv_t conv;conv.f = v;swap(conv.c); packetLcm(LCMTEMP, conv.c, 4);/LCMSHT10, / 温湿度传感器SHT10/ 温湿度传感器SHT10/ 参数 t:温度/ h:湿度void LcmDisplaySHT10(float t, float h) conv_t conv; conv.f = t;swap(conv.c); memcpy(data1+0, conv.c, 4); conv.f = h;swap(c

34、onv.c); memcpy(data1+4, conv.c, 4); packetLcm(LCMSHT10, data1, 8);/LCMHUMI, / 湿度/SHT10/ 相对湿度，百分比void LcmDisplayHumi(float v) conv_t conv; conv.f = v;swap(conv.c); packetLcm(LCMHUMI, conv.c, 4);/LCMNTC, / 热敏电阻void LcmDisplayNTC(float v) conv_t conv; conv.f = v;swap(conv.c); packetLcm(LCMNTC, conv.c,

35、4);/ 4 操作控制类及加速传感器模块/LCMACC, / 三轴加速度/ 三维加速度，单位gvoid LcmDisplayAcc(float x, float y, float z) conv_t conv; conv.f = x;swap(conv.c); memcpy(data1+0, conv.c, 4); conv.f = y;swap(conv.c); memcpy(data1+4, conv.c, 4); conv.f = z;swap(conv.c); memcpy(data1+8, conv.c, 4); packetLcm(LCMACC, data1, 12);/LCMJO

36、YSTICK, / 摇杆电位器/ 摇杆电位器，12位AD值void LcmDisplayJoystick(unsigned int x, unsigned int y) conv_t conv; conv.ui = x;swap(conv.c); memcpy(data1+0, conv.c, 4); conv.ui = y;swap(conv.c); memcpy(data1+4, conv.c, 4); packetLcm(LCMJOYSTICK, data1, 8);/LCMENCODER, / 编码开关/ 编码开关void LcmDisplayEncoder(encd_t v) con

37、v_t conv; conv.en = v;swap(conv.c); memcpy(data1+0, conv.c, 4); packetLcm(LCMENCODER, data1, 4);/ 5 称重传感器模块/LCMWEIGHT, / 称重/ 称重传感器，单位克void LcmDisplayWeight(float v) conv_t conv;conv.f = v;swap(conv.c); packetLcm(LCMWEIGHT, conv.c, 4);/ 6 粉尘传感器模块/LCMDUST, / 粉尘/ 粉尘，单位粒子数void LcmDisplayDust(float v) co

38、nv_t conv;conv.f = v;swap(conv.c); packetLcm(LCMDUST, conv.c, 4);/ 7 红外测温及颜色传感器模块（增强型模块）/LCMBODYTEMP, / 红外测体温/ 体温，摄氏度void LcmDisplayBodyTemp(float v) conv_t conv; conv.f = v;swap(conv.c); packetLcm(LCMBODYTEMP, conv.c, 4);/LCMCOLOR, / 颜色/ 颜色，RGB 各8位void LcmDisplayColor(unsigned char r, unsigned char

39、 g, unsigned char b) conv_t conv; conv.uc = r; memcpy(data1+0, conv.c, 1); conv.uc = g; memcpy(data1+1, conv.c, 1); conv.uc = b; memcpy(data1+2, conv.c, 1); packetLcm(LCMCOLOR, data1, 3);/ 8 磁阻陀螺仪及气压传感器模块（增强型模块）/LCMRELUCTANCE, / 三轴磁阻/ 磁阻void LcmDisplayReluctance(float angle, float x, float y, float

40、z) conv_t conv; conv.f = angle;swap(conv.c); memcpy(data1+0, conv.c, 4); conv.f = x;swap(conv.c); memcpy(data1+4, conv.c, 4); conv.f = y;swap(conv.c); memcpy(data1+8, conv.c, 4); conv.f = z;swap(conv.c); memcpy(data1+12, conv.c, 4); packetLcm(LCMRELUCTANCE, data1, 16);/LCMANGRATE, / 三轴角速率陀螺仪/ 三轴角速率v

41、oid LcmDisplayAngRate(float x, float y, float z) conv_t conv; conv.f = x;swap(conv.c); memcpy(data1+0, conv.c, 4); conv.f = y;swap(conv.c); memcpy(data1+4, conv.c, 4); conv.f = z;swap(conv.c); memcpy(data1+8, conv.c, 4); packetLcm(LCMANGRATE, data1, 12);/LCMPRESSURE, / 气压/ 气压传感器MS5607/ 参数 P:温度/ t:气压

42、void LcmDisplayPressure(float p, float t) conv_t conv; conv.f = p;swap(conv.c); memcpy(data1+0, conv.c, 4); conv.f = t;swap(conv.c); memcpy(data1+4, conv.c, 4); packetLcm(LCMPRESSURE, data1, 8);/ 9 二氧化碳传传感器模块（扩展型模块）/LCMCO2, / 二氧化碳void LcmDisplayCO2(float v) conv_t conv; conv.f = v;swap(conv.c); pack

43、etLcm(LCMCO2, conv.c, 4);/ 10 气体流量传感器模块（扩展型模块）/LCMFLOW, / 气体流量/ 气体流量，单位SLPMvoid LcmDisplayFlow(float v) conv_t conv;conv.f = v;swap(conv.c); packetLcm(LCMFLOW, conv.c, 4);传感器烧录（给出传感器烧录代码的编译及烧录过程、是否遇到问题及如何解决）(1)利用keil2软件，打开目录“D:传感器实验箱资料传感器实验箱程序资料C51完成部分程序完成部分程序”中的SHT10.Uv2文件。(2) 双击打开左侧的“wenshi.c”文件，根

44、据提示完成部分程序。(3) 按下F7键，即编译此程序，在工具软件下面的显示区域中，如果有“0 error(s)”字样，表示此程序编译已经成功。(4) 把编译好的程序重新烧写到单片机中。(5) 按下母板卡上的Sensors键并打开传感器电源。(6) 观察效果。(7) 依次关闭传感器电源、单片机电源、母板卡电源。实时数据收集环境（画出详细的传感器、C51或ARM板、传感器实验箱嵌入式电脑及Ubuntu网关间的连接示意图，并详细介绍各部分的主要功能）温湿度传感器：检测环境的温湿度。C51平台：通过平台里面烧录的代码对传感器取得的数据进行解析并转换为数值。显示器：显示测的的温湿度的具体数值。Sqlit

45、e3数据库：存储温湿度的数值。实时数据收集编程实现（给出从传感器实验箱获取实时数据的所有源代码，给出启动程序收集数据的步骤、遇到的问题及采取的措施）#include #include #include #include #include #include #include #include #include /#include Analysis_Net.h#include Analysis_Sensor.h#includetypedef struct int fd; PAR;void thread_com( void * param ) PAR * local = param; char bu

46、ff1024;/sqlite3int retval; sqlite3 *handle;retval = sqlite3_open(Seninfo.db,&handle);if(retval) printf(Database connection failedn); return -1; printf(Connection successfuln);printf(Connection successfuln); char *sql; sql = CREATE TABLE IF NOT EXISTS Sdata (id int,datetime datetime ,Temperature floa

47、t,Humidity float,flag int default 0); sqlite3_exec(handle,sql,0,0,0);/sqlite3 while ( 1 ) memset( buff, 0, sizeof( buff ) ); int nread = read( local-fd, buff, 1024 ); printf( size of nread = %dn, nread ); if ( nread != 0 ) / GetNWData( &buff );GetSData( &buff,handle ); sleep( 2 ); sqlite3_close(hand

48、le);int set_opt( int fd, int nSpeed, int nBits, char nEvent, int nStop ) /设置打开的端口 struct termios newtio; struct termios oldtio; if ( tcgetattr( fd, &oldtio ) != 0 ) perror( Save Old Serial ); return -1; bzero( &newtio, sizeof( newtio ) ); newtio.c_cflag |= CLOCAL | CREAD; newtio.c_cflag &= CSIZE; sw

49、itch ( nBits ) case 7: newtio.c_cflag |= CS7; break; case 8: newtio.c_cflag |= CS8; break; default: break; switch ( nEvent ) case O: case o: newtio.c_cflag |= PARENB; newtio.c_cflag |= PARENB; break; case e: case E: newtio.c_iflag |= ( INPCK | ISTRIP ); newtio.c_cflag |= PARENB; newtio.c_cflag &= PA

50、RODD; break; case n: case N: newtio.c_cflag &= PARENB; break; switch ( nSpeed ) case 2400: cfsetispeed( &newtio, B2400 ); cfsetospeed( &newtio, B2400 ); break; case 4800: cfsetispeed( &newtio, B4800 ); cfsetospeed( &newtio, B4800 ); break; case 9600: cfsetispeed( &newtio, B9600 ); cfsetospeed( &newt

51、io, B9600 ); break; case 115200: cfsetispeed( &newtio, B115200 ); cfsetospeed( &newtio, B115200 ); break; default: cfsetispeed( &newtio, B9600 ); cfsetospeed( &newtio, B9600 ); break; if ( nStop = 1 ) newtio.c_cflag &= CSTOPB; else if ( nStop = 2 ) newtio.c_cflag |= CSTOPB; newtio.c_ccVMIN = 0; newt

52、io.c_ccVTIME = 0; tcflush( fd, TCIFLUSH ); if ( tcsetattr( fd, TCSANOW, &newtio ) != 0 ) perror( com set error ); return -1; printf( set donen );void open_port( int * fd ) /打开端口 char num100; char COMNum100 = /dev/tty; printf( please input COM num: ); gets( num ); strcat( COMNum, num ); *fd = open( C

53、OMNum, O_RDWR | O_NOCTTY | O_NDELAY ); if ( *fd = -1 ) perror( Can not Open Serial Port ); return( -1 ); else printf( Open Successn ); if ( fcntl( *fd, F_SETFL, 0 ) 0 ) printf( fcntl failed!n ); else printf( fcntl = %dn, fcntl( *fd, F_SETFL, 0 ) ); printf( fd-open = %dn, *fd );int main() int fd; int

54、 i; char buff100; int quit = 0; int res; pthread_t id; PAR param; count=0; memset( buff, 0, sizeof( buff ) ); open_port( &fd ); if ( fd 0 ) perror( open com error ); return -1; i = set_opt( fd, 115200, 8, N, 1 ); if ( i 0 ) perror( set opt error ); return -1; param.fd = fd; res = pthread_create( &id

55、, NULL, thread_com, (void *)¶m ); while ( quit = 0 ) scanf( %d, &quit ); fflush( stdin ); close( fd ); return 0;输入指令ls /dev/ | grep tty。应该可以找到ttyUSB接口./Com_Sensor出现please input COM num:接着输入USB接口号。问题：对代码各个模块的具体用途不了解。实时数据存储（如何安装及使用Sqlite3，给出存储实时数据的Sqlite3数据表格的详细的数据列及数据类型）安装步骤：aptitude updateaptitu

56、de install libsqlite3-devaptitude install sqlite3数据类型CREATE TABLE Sdata (id int,datetime datetime ,Temperature float,Humidity float,flag int default 0);+| Field | Type | Null | Key | Default | Extra |+| id | int | NO | | | | | dateTime | varchar(50) | NO | | | | |Temperature | float | NO | | | | Hum

57、idity | float | NO | | | | | flag | int(11) | YES | | 0 | | +实时数据发送（说明如何实现自动连续发送实时数据、说明如何保证已经成功发送的数据不能再次发送、给出实时数据发送的源代码；是否遇到问题及如何解决）发送源代码：#include #include #include #include #include #include #include #include #include#define BUFSIZE 1024/* * error - wrapper for perror*/void error(char *msg) perror(

58、msg); exit(0);char* MyStrcat(char *a,char *b) int i=0;char *p=a,*q=b,*c,*cc;while(*p+)i+;while(*q+)i+;p=a;q=b;i+;c=(char*)malloc(i*sizeof(char);cc=c;while(*p)*cc+=*p+;while(*q)*cc+=*q+;*cc=0;return c;int main(int argc, char *argv) int sockfd, portno, n; struct sockaddr_in serveraddr; struct hostent

59、*server; char *hostname; char bufBUFSIZE; int retval,retval2; int q_cnt = 5,q_size = 150,ind = 0; char *queries = malloc(sizeof(char) * q_cnt * q_size); sqlite3_stmt *stmt; sqlite3 *handle;char *d;char sentstr1024;char whitespace=$;char endofline=#;char endofsentstr=n; char *sql; if (argc != 3) fpri

60、ntf(stderr,usage: %s n, argv0);exit(0); hostname = argv1; portno = atoi(argv2); sockfd = socket(AF_INET, SOCK_STREAM, 0); if (sockfd h_addr, (char *)&serveraddr.sin_addr.s_addr, server-h_length); serveraddr.sin_port = htons(portno); if (connect(sockfd, &serveraddr, sizeof(serveraddr) 0) error(ERROR