- 论坛徽章:
- 0
|
cgi代码:
#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>
int main()
{
sqlite3 *pdb=NULL;
sqlite3_stmt *stmt;
char *szErrMsg=0;
int rc,i;
rc=sqlite3_open("/home/dyh/date.db",&pdb);
if(rc)
{
fprintf(stderr,"can't open database: %s",sqlite3_errmsg(pdb));
sqlite3_close(pdb);
return -1;
}
printf("Content-type:text/html\n\n");
printf("<html>\n<head>\n<Meta http-equiv=\"Refresh\" Content=\"1;\"><title>test</title></head>\n<body>\n");
printf("<h1 align=\"center\">dongtai</h1>\n");
printf("<table border=\"1\" align=\"center\">\n");
printf("<tr>\n");
printf("<th>id</th><th>dev</th><th>wendu</th><th>time</th>\n");
printf("</tr>\n");
char sql[512];
//char *sql="select *from wsd where id=(select max(id)from wsd where dnum=1)";
int j=1;
for(;j<=3;j++)
{
sprintf(sql,"select *from wsd where id=(select max(id)from wsd where dnum=%d)",j);
sqlite3_prepare(pdb,sql,-1,&stmt,0);
//sqlite3_bind_int(stmt,kk,i);
//sqlite3_bind_int(stmt,1,i);
/*
rc=sqlite3_column_count(stmt);
for(i=0;i<rc;i++)
{
printf("%s\t",sqlite3_column_name(stmt,i));
}
printf("\n");
*/ printf("<tr>\n");
while(sqlite3_step(stmt)==SQLITE_ROW)
{
printf("<td>%d</td>",sqlite3_column_int(stmt,0));
printf("<td>%d</td>",sqlite3_column_int(stmt,1));
printf("<td>%.1f</td>",sqlite3_column_double(stmt,2));
printf("<td>%s</td>\n",sqlite3_column_text(stmt,3));
/*
for(i=0;i<rc-1;i++)
{
printf("%d\t",sqlite3_column_int(stmt,i));
}
printf("%s\n",sqlite3_column_text(stmt,i));
//sqlite3_reset(stmt);
*/
}
printf("</tr>\n");
}
printf("</table>\n</body>\n</html>");
sqlite3_finalize(stmt);
sqlite3_close(pdb);
return 0;
}
|
|