#include
#include
#include
#include
#include
#include?
#include
#define?BAUDRATE?B9600
#define?MODEMDEVICE?“/dev/ttyUSB2“

int?execsql（char*?sqldata）
{

sqlite3?*db=NULL;

char?*zErrMsg?=?0;
?

int?rc;

//打開指定的數據庫文件如果不存在將創建一個同名的數據庫文件

rc?=?sqlite3_open（“tygfz.db“?&db）;

if（?rc?）
{

fprintf（stderr?“Can‘t?open?database:?%s\n“?sqlite3_errmsg（db））;

sqlite3_close（db）;

exit（1）;

}
?
sqlite3_exec（dbsqldata0?0?&zErrMsg）;

sqlite3_close（db）;?//關閉數據庫

return?0;

}

int?main（）
{
	int?fdc=0c1=0ress1[2];
	struct?termios?oldtionewtio;
	char?buf[380]sqldata[380];
	printf（“stat---\n“）;
	fd=open（MODEMDEVICEO_RDWR|O_NOCTTY）;
	if（fd<0）
	{
		perror（MODEMDEVICE）;
		exit（1）;
	}
	printf（“open/dev/ttyUSB2---\n“）;
	tcgetattr（fd&oldtio）;
	bzero（&newtiosizeof（newtio））;
	newtio.c_cflag=BAUDRATE|CS8|CLOCAL|CREAD;
	newtio.c_iflag=IGNPAR;
	newtio.c_oflag=0;
	newtio.c_lflag=ICANON;
	tcflush（fdTCIFLUSH）;
	//cfsetispeed（&newtioBAUDRATE）;
???	//cfsetospeed（&newtioBAUDRATE）;
	tcsetattr（fdTCSANOW&newtio）;
	printf（“reading---\n“）;
	
	while（1）
	{?	?
		res=read（fdbuf380）;
		if（res!=0）
		{
		/*if（buf[0]==‘t‘）
		{
		int?seconds=?time（（time_t*）NULL）;
		s1[0]=seconds;
		write（fds11）;
		}
		else
		{?
		*/
		buf[res]=0;
		printf（“res=%d?vuf=%s\n“resbuf）;
		if（buf[0]==‘@‘）?break;
		/*?for（c1;c1		{	?
		sqldata[c1]=buf[c1];
		}*/
		?strncpy（sqldatabuf380）;
		//sqldata[res-1]=‘\0‘;
		printf（“sqldata=%s\n“sqldata）;?
		execsql（sqldata）;
		}
		//}	
	}	
	printf（“close---\n“）;
	
	close（fd）;
	tcsetattr（fdTCSANOW&oldtio）;
	return?0;
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

????.......??????9098??2009-07-02?17:09??chuankou\receive

????.......??????1691??2009-07-02?17:20??chuankou\receive.c

????.......??????1692??2009-07-02?17:08??chuankou\receive.c~

????.......??????8126??2009-06-01?13:42??chuankou\send

????.......??????1375??2009-06-01?13:40??chuankou\send.c

????.......???????544??2009-05-30?12:25??chuankou\sqlexe.c

????.......?????19456??2009-07-02?17:45??chuankou\tygfz.db

????.......?????????0??2009-06-07?12:11??qgprs\3

????.......?????13408??2009-07-02?17:35??qgprs\gprs

????.......?????11184??2009-06-07?10:33??qgprs\jj

????.......???????195??2009-06-07?10:04??qgprs\Makefile

????.......???????189??2009-06-07?10:02??qgprs\Makefile~

????.......????????91??2009-06-02?23:55??qgprs\q2403a.c

????.......?????????0??2009-06-02?23:48??qgprs\q2403a.h

????.......??????5420??2009-07-02?17:34??qgprs\q_gprs.c

????.......??????5434??2009-07-02?17:18??qgprs\q_gprs.c~

????.......??????2668??2004-12-06?05:43??qgprs\serial.c

????.......???????794??2004-12-06?05:43??qgprs\serial.h

????.......??????2048??2009-07-02?17:39??qgprs\tygfz.db

?????目錄??????????0??2009-07-02?17:51??chuankou

?????目錄??????????0??2009-07-02?17:39??qgprs

-----------?---------??----------?-----??----

????????????????83413????????????????????21