本文整理汇总了C++中dbclose函数的典型用法代码示例。如果您正苦于以下问题:C++ dbclose函数的具体用法?C++ dbclose怎么用?C++ dbclose使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了dbclose函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C++代码示例。
示例1: malloc
profesor *consultar_docente(long docente_id) {
profesor *p = NULL;
char sql[512];
int num = 0;
PGconn *conexion = NULL;
PGresult *resultado = NULL;
if (docente_id > 0) {
p = (profesor *) malloc(sizeof (profesor));
p->docente_id = docente_id;
p->aprobacion = 0.0;
p->promedio = 0.0;
p->reprobacion = 0.0;
p->stddev = 0.0;
// Busco Reprobados
memset(sql, 0, sizeof (sql));
sprintf(sql, "SELECT AVG(asignaturas_cursadas.nota) FROM cursos INNER JOIN asignaturas_cursadas ON cursos.curso_id=asignaturas_cursadas.curso_id WHERE cursos.docente_id = '%ld' AND asignaturas_cursadas.nota < 4 GROUP BY cursos.docente_id", docente_id);
conexion = dbconnect(SERVIDOR, PUERTO, NOMBREDB, USUARIODB, PASSDB);
if (conexion != NULL) {
resultado = dbquery(conexion, sql);
num = dbnumrows(resultado);
if (num > 0) {
p->reprobacion = getDouble(dbresult(resultado, 0, 0));
dbfree(resultado);
}
dbclose(conexion);
}
// Busco Aprobados
memset(sql, 0, sizeof (sql));
sprintf(sql, "SELECT AVG(asignaturas_cursadas.nota) FROM cursos INNER JOIN asignaturas_cursadas ON cursos.curso_id=asignaturas_cursadas.curso_id WHERE cursos.docente_id = '%ld' AND asignaturas_cursadas.nota >= 4 GROUP BY cursos.docente_id", docente_id);
conexion = dbconnect(SERVIDOR, PUERTO, NOMBREDB, USUARIODB, PASSDB);
if (conexion != NULL) {
resultado = dbquery(conexion, sql);
num = dbnumrows(resultado);
if (num > 0) {
p->aprobacion = getDouble(dbresult(resultado, 0, 0));
dbfree(resultado);
}
dbclose(conexion);
}
// Busco Promedio
memset(sql, 0, sizeof (sql));
sprintf(sql, "SELECT AVG(asignaturas_cursadas.nota) AS promedio, STDDEV(asignaturas_cursadas.nota) FROM cursos INNER JOIN asignaturas_cursadas ON cursos.curso_id=asignaturas_cursadas.curso_id WHERE cursos.docente_id = '%ld' GROUP BY cursos.docente_id ORDER BY promedio DESC", docente_id);
conexion = dbconnect(SERVIDOR, PUERTO, NOMBREDB, USUARIODB, PASSDB);
if (conexion != NULL) {
resultado = dbquery(conexion, sql);
num = dbnumrows(resultado);
if (num > 0) {
p->promedio = getDouble(dbresult(resultado, 0, 0));
p->stddev = getDouble(dbresult(resultado, 0, 1));
dbfree(resultado);
}
dbclose(conexion);
}
}
return p;
}
开发者ID:sebasalazar,项目名称:C,代码行数:60,代码来源:tareas.c
示例2: memset
ranking_profesor *ranking_docentes(int semestre, int anio, long *tamano) {
ranking_profesor *ranking = NULL;
char sql[512];
int i = 0;
int num = 0;
PGconn *conexion = NULL;
PGresult *resultado = NULL;
if (semestre > 0 && anio > 0) {
memset(sql, 0, sizeof (sql));
sprintf(sql, "SELECT cursos.docente_id, AVG(asignaturas_cursadas.nota) AS promedio, STDDEV(asignaturas_cursadas.nota) FROM cursos INNER JOIN asignaturas_cursadas ON cursos.curso_id=asignaturas_cursadas.curso_id WHERE cursos.semestre='%d' AND cursos.anio='%d' GROUP BY cursos.docente_id ORDER BY promedio DESC", semestre, anio);
conexion = dbconnect(SERVIDOR, PUERTO, NOMBREDB, USUARIODB, PASSDB);
if (conexion != NULL) {
resultado = dbquery(conexion, sql);
num = dbnumrows(resultado);
if (num > 0) {
ranking = (ranking_profesor *) malloc(num * sizeof (ranking_profesor));
for (i = 0; i < num; i++) {
ranking[i].lugar = i + 1;
ranking[i].docente_id = getLong(dbresult(resultado, i, 0));
ranking[i].nota = getDouble(dbresult(resultado, i, 1));
ranking[i].stddev = getDouble(dbresult(resultado, i, 2));
ranking[i].semestre = semestre;
ranking[i].anio = anio;
}
dbfree(resultado);
}
dbclose(conexion);
}
}
*tamano = num;
return ranking;
}
开发者ID:sebasalazar,项目名称:C,代码行数:34,代码来源:tareas.c
示例3: getVentasAnuales
ventas_anuales* getVentasAnuales(int* cantidades_ventas) {
ventas_anuales* ventas = NULL;
int i = 0;
int num = 0;
PGconn *conexion = NULL;
PGresult *resultado = NULL;
conexion = dbconnect(SERVIDOR, PUERTO, NOMBREDB, USUARIODB, PASSDB);
if (conexion != NULL) {
resultado = dbquery(conexion, "SELECT tienda, SUM(monto) FROM ventas GROUP BY tienda");
num = dbnumrows(resultado);
if (num > 0) {
ventas = (ventas_anuales *) malloc(num * sizeof (ventas_anuales));
for (i = 0; i < num; i++) {
ventas[i].tienda = getString(dbresult(resultado, i, 0));
ventas[i].monto = getLong(dbresult(resultado, i, 1));
}
dbfree(resultado);
}
dbclose(conexion);
}
*cantidades_ventas = num;
return ventas;
}
开发者ID:sebasalazar,项目名称:C,代码行数:26,代码来源:tareas.c
示例4: usage
void
usage(void)
{
g_fprintf(stderr, _("Usage: amfetchdump [options] [-o configoption]* config hostname [diskname [datestamp [level [hostname [diskname [datestamp [level ... ]]]]]]]\n\n"));
g_fprintf(stderr, _("Goes and grabs a dump from tape, moving tapes around and assembling parts as\n"));
g_fprintf(stderr, _("necessary. Files are restored to the current directory, unless otherwise\nspecified.\n\n"));
g_fprintf(stderr, _(" -p Pipe exactly *one* complete dumpfile to stdout, instead of to disk.\n"));
g_fprintf(stderr, _(" -h Output the amanda header to same output as the image.\n"));
g_fprintf(stderr, _(" --header-fd <fd> Output the amanda header to the numbered file descriptor.\n"));
g_fprintf(stderr, _(" --header-file <filename> Output the amanda header to the filename.\n"));
g_fprintf(stderr, _(" -O <output dir> Restore files to this directory.\n"));
g_fprintf(stderr, _(" -d <device> Force restoration from a particular tape device.\n"));
g_fprintf(stderr, _(" -c Compress output, fastest method available.\n"));
g_fprintf(stderr, _(" -C Compress output, best filesize method available.\n"));
g_fprintf(stderr, _(" -l Leave dumps (un)compressed, whichever way they were originally on tape.\n"));
g_fprintf(stderr, _(" -a Assume all tapes are available via changer, do not prompt for initial load.\n"));
g_fprintf(stderr, _(" -i <dst_file> Search through tapes and write out an inventory while we\n restore. Useful only if normal logs are unavailable.\n"));
g_fprintf(stderr, _(" -w Wait to put split dumps together until all chunks have been restored.\n"));
g_fprintf(stderr, _(" -n Do not reassemble split dumpfiles.\n"));
g_fprintf(stderr, _(" -k Skip the rewind/label read when reading a new tape.\n"));
g_fprintf(stderr, _(" -s Do not use fast forward to skip files we won't restore. Use only if fsf\n causes your tapes to skip too far.\n"));
g_fprintf(stderr, _(" -b <blocksize> Force a particular block size (default is 32kb).\n"));
dbclose();
exit(1);
}
开发者ID:TonyChiang,项目名称:amanda,代码行数:25,代码来源:amfetchdump.c
示例5: getVentasHorarias
ventas_horarias* getVentasHorarias(int* cantidades_ventas) {
ventas_horarias* ventas = NULL;
int i = 0;
int num = 0;
PGconn *conexion = NULL;
PGresult *resultado = NULL;
conexion = dbconnect(SERVIDOR, PUERTO, NOMBREDB, USUARIODB, PASSDB);
if (conexion != NULL) {
resultado = dbquery(conexion, "SELECT DISTINCT ON (tienda) tienda, EXTRACT(hour FROM fecha) AS hora,SUM(monto) AS total FROM ventas GROUP BY tienda, hora ORDER BY tienda, SUM(monto) DESC");
num = dbnumrows(resultado);
if (num > 0) {
ventas = (ventas_horarias *) malloc(num * sizeof (ventas_horarias));
for (i = 0; i < num; i++) {
ventas[i].tienda = getString(dbresult(resultado, i, 0));
ventas[i].hora = getInt(dbresult(resultado, i, 1));
ventas[i].monto = getLong(dbresult(resultado, i, 2));
}
dbfree(resultado);
}
dbclose(conexion);
}
*cantidades_ventas = num;
return ventas;
}
开发者ID:sebasalazar,项目名称:C,代码行数:27,代码来源:tareas.c
示例6: save_pid_to_db
int save_pid_to_db(int id,char* pd)
{
char szUsername[32] = "sa";
char szPassword[32]= "1qazxsw2*";
char szDBName[32] = "ids_db";
char szServer[32] = "10.2.10.201";
char sqlquery[1024]={0};
snprintf(sqlquery,1024,"update ids_policy_event set pid='%s' where id='%d'",pd,id);
dbinit();
LOGINREC *loginrec = dblogin();
DBSETLUSER(loginrec, szUsername);
DBSETLPWD(loginrec, szPassword);
DBPROCESS *dbprocess = dbopen(loginrec, szServer);
if(dbprocess == FAIL)
{
LOG_INFO(" Conect MS SQL SERVER fail ");
return -1;
}
if(dbuse(dbprocess, szDBName) == FAIL)
{
LOG_INFO(" Open database name fail");
return -1;
}
dbcmd(dbprocess,sqlquery);
if(dbsqlexec(dbprocess) == FAIL)
{
LOG_INFO("task.cpp dbsqlexec error!!!");
}
dbclose(dbprocess);
return 0;
}
开发者ID:crspecter,项目名称:multiprocess_nmap,代码行数:31,代码来源:task.cpp
示例7: Logout
// one arg - logout
static v8::Handle<Value> Logout(const Arguments& args) {
v8::HandleScope scope;
REQ_DBCONN_ARG(0);
dbfreebuf(dbconn);
dbclose(dbconn);
return v8::Undefined();
}
开发者ID:18liuyuan,项目名称:node-freetds,代码行数:8,代码来源:node_freetds.cpp
示例8: odbNewFile
pascal boolean odbNewFile (hdlfilenum fnum) {
/*
4.1b5 dmb: new routine. minimal db creation. does not leave it open
*/
tyversion2cancoonrecord info;
dbaddress adr = nildbaddress;
boolean fl;
setemptystring (bserror);
if (!dbnew (fnum))
return (false);
clearbytes (&info, sizeof (info));
info.versionnumber = conditionalshortswap (cancoonversionnumber);
fl = dbassign (&adr, sizeof (info), &info);
if (fl) {
dbsetview (cancoonview, adr);
dbclose ();
}
cancoonglobals = nil; /*if they've been set, they're out of date*/
dbdispose ();
return (fl);
} /*odbNewFile*/
开发者ID:pombredanne,项目名称:Frontier,代码行数:34,代码来源:odbengine.c
示例9: getVentasMensuales
ventas_mensuales* getVentasMensuales(char* tienda, int* cantidades_ventas) {
ventas_mensuales* ventas = NULL;
int i = 0;
int num = 0;
PGconn *conexion = NULL;
PGresult *resultado = NULL;
char sql[513];
if (tienda != NULL) {
conexion = dbconnect(SERVIDOR, PUERTO, NOMBREDB, USUARIODB, PASSDB);
if (conexion != NULL) {
memset(sql, 0, sizeof (sql));
snprintf(sql, 512, "SELECT tienda, EXTRACT(month FROM fecha) AS mes,SUM(monto) AS total FROM ventas WHERE tienda = '%s' GROUP BY tienda, mes ORDER BY mes", tienda);
resultado = dbquery(conexion, sql);
num = dbnumrows(resultado);
if (num > 0) {
ventas = (ventas_mensuales *) malloc(num * sizeof (ventas_mensuales));
for (i = 0; i < num; i++) {
ventas[i].tienda = getString(dbresult(resultado, i, 0));
ventas[i].mes = getInt(dbresult(resultado, i, 1));
ventas[i].monto = getLong(dbresult(resultado, i, 2));
}
dbfree(resultado);
}
dbclose(conexion);
}
}
*cantidades_ventas = num;
return ventas;
}
开发者ID:sebasalazar,项目名称:C,代码行数:31,代码来源:tareas.c
示例10: Thread_Exit
int Thread_Exit(int id)
{
if (Conexion[id].nAbierta)
//PQfinish(Conexion[id].dbconn);//Descomentar cuando este implementado
dbfreebuf(Conexion[id].dbconn);
dbclose(Conexion[id].dbconn);
dbexit();
}
开发者ID:CM0R31R4,项目名称:motor_desarrollo,代码行数:8,代码来源:BaseDatosMSSQL_mensajes.c
示例11: cleanup
QTDSResult::~QTDSResult()
{
cleanup();
if (d->dbproc)
dbclose(d->dbproc);
errs()->remove(d->dbproc);
delete d;
}
开发者ID:Suneal,项目名称:qt,代码行数:8,代码来源:qsql_tds.cpp
示例12: syb_terminate_order
int syb_terminate_order (int no_des)
{
if (descriptor[no_des] != NULL && no_des != PRIVATE_DESCRIPTOR)
{
dbclose (descriptor[no_des]);
descriptor[no_des] = NULL;
}
return 0;
}
开发者ID:jocelyn,项目名称:EiffelStudio,代码行数:9,代码来源:sybase.c
示例13: rb_tinytds_close
static VALUE rb_tinytds_close(VALUE self) {
GET_CLIENT_WRAPPER(self);
if (cwrap->client && !cwrap->closed) {
dbclose(cwrap->client);
cwrap->closed = 1;
cwrap->userdata->closed = 1;
}
return Qtrue;
}
开发者ID:calonso-conabio,项目名称:tiny_tds,代码行数:9,代码来源:client.c
示例14: dbclose
Connector::~Connector()
{
#ifdef MSSQL
dbclose(conn_ptr);
dbloginfree(login_rec);
#elif WATCHLIST_MYSQL
mysql_close(&mysqlID);
#endif
}
开发者ID:20083017,项目名称:mysql_connector,代码行数:10,代码来源:Connector.cpp
示例15: sql_close
/*************************************************************************
*
* Function: sql_close
*
* Purpose: database specific close. Closes an open database
* connection
*
*************************************************************************/
static int sql_close(SQLSOCK *sqlsocket, UNUSED SQL_CONFIG *config)
{
rlm_sql_freetds_sock *freetds_sock = sqlsocket->conn;
if (freetds_sock && freetds_sock->dbproc){
dbclose(freetds_sock->dbproc);
freetds_sock->dbproc = NULL;
}
return 0;
}
开发者ID:FabioPedretti,项目名称:freeradius-server,代码行数:19,代码来源:rlm_sql_freetds.c
示例16: main
int
main(int argc, char *argv[])
{
LOGINREC *login;
DBPROCESS *dbproc;
int ret_code;
int num_cols;
int num_res;
set_malloc_options();
read_login_info(argc, argv);
printf("Starting %s\n", argv[0]);
dbinit();
dberrhandle(syb_err_handler);
dbmsghandle(syb_msg_handler);
printf("About to logon\n");
login = dblogin();
DBSETLPWD(login, PASSWORD);
DBSETLUSER(login, USER);
DBSETLAPP(login, "t0012");
dbproc = dbopen(login, SERVER);
if (strlen(DATABASE)) {
dbuse(dbproc, DATABASE);
}
dbloginfree(login);
printf("After logon\n");
/* select */
sql_cmd(dbproc);
dbsqlexec(dbproc);
num_res = 0;
while ((ret_code = dbresults(dbproc)) == SUCCEED) {
num_cols = dbnumcols(dbproc);
printf("Result %d has %d columns\n", num_res, num_cols);
if (!(num_res % 2) && num_cols)
set_failed();
while(dbnextrow(dbproc) != NO_MORE_ROWS) {};
num_res++;
}
if (ret_code == FAIL)
set_failed();
dbclose(dbproc);
dbexit();
printf("%s %s\n", __FILE__, (failed ? "failed!" : "OK"));
return failed ? 1 : 0;
}
开发者ID:FreeTDS,项目名称:freetds,代码行数:54,代码来源:empty_rowsets.c
示例17: rb_tinytds_client_free
static void rb_tinytds_client_free(void *ptr) {
tinytds_client_wrapper *cwrap = (tinytds_client_wrapper *)ptr;
if (cwrap->login)
dbloginfree(cwrap->login);
if (cwrap->client && !cwrap->closed) {
dbclose(cwrap->client);
cwrap->closed = 1;
cwrap->userdata->closed = 1;
}
xfree(cwrap->userdata);
xfree(ptr);
}
开发者ID:calonso-conabio,项目名称:tiny_tds,代码行数:12,代码来源:client.c
示例18: main
int
main(int argc, char **argv)
{
BCPPARAMDATA params;
DBPROCESS *dbsrc;
DBPROCESS *dbtarget;
setlocale(LC_ALL, "");
memset(¶ms, '\0', sizeof(params));
if (process_parameters(argc, argv, ¶ms) == FALSE) {
pusage();
return 1;
}
if (login_to_databases(¶ms, &dbsrc, &dbtarget) == FALSE)
return 1;
if (params.cflag) {
if (create_target_table(params.src.dbobject, params.owner, params.dest.dbobject, dbsrc, dbtarget) == FALSE) {
printf("datacopy: could not create target table %s.%s . terminating\n", params.owner, params.dest.dbobject);
dbclose(dbsrc);
dbclose(dbtarget);
return 1;
}
}
if (check_table_structures(params.src.dbobject, params.dest.dbobject, dbsrc, dbtarget) == FALSE) {
printf("datacopy: table structures do not match. terminating\n");
dbclose(dbsrc);
dbclose(dbtarget);
return 1;
}
if (transfer_data(params, dbsrc, dbtarget) == FALSE) {
printf("datacopy: table copy failed.\n");
printf(" the data may have been partially copied into the target database \n");
dbclose(dbsrc);
dbclose(dbtarget);
return 1;
}
dbclose(dbsrc);
dbclose(dbtarget);
return 0;
}
开发者ID:msabramo,项目名称:freetds,代码行数:50,代码来源:datacopy.c
示例19: dbd_freetds_check_conn
static apr_status_t dbd_freetds_check_conn(apr_pool_t *pool,
apr_dbd_t *handle)
{
if (dbdead(handle->proc)) {
/* try again */
dbclose(handle->proc);
handle->proc = freetds_open(handle->pool, handle->params, NULL);
if (!handle->proc || dbdead(handle->proc)) {
return APR_EGENERAL;
}
}
/* clear it, in case this is called in error handling */
dbcancel(handle->proc);
return APR_SUCCESS;
}
开发者ID:cmjonze,项目名称:apr,代码行数:15,代码来源:apr_dbd_freetds.c
示例20: ngx_dbd_freetds_close
static void
ngx_dbd_freetds_close(ngx_dbd_t *dbd)
{
RETCODE rc;
ngx_dbd_freetds_ctx_t *ctx;
ngx_log_debug0(NGX_LOG_DEBUG_MYSQL, dbd->log, 0, "dbd freetds close");
ctx = dbd->ctx;
rc = dbcanquery(ctx->db);
/* TODO: rc */
dbclose(ctx->db);
}
开发者ID:chenbk85,项目名称:ngx_dbd_module,代码行数:16,代码来源:ngx_dbd_freetds.c
注:本文中的dbclose函数示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论