server.cpp

使用socket 通訊協定透過PROC存取 oracle database

/* server.c */
#include <stdio.h>
#include <sys/socket.h>
#include <netinet/in.h>
#include <arpa/inet.h>
#include <netdb.h>
#include <string.h>
#include <stdlib.h>
#include "sqlca.h"


//compile method锛? 
//1. use oracle proc compile
//proc parse=none iname=server.cpp
//2. use gcc compile exe file
//gcc -g -o server server.c -I $ORACLE_HOME/precomp/public/ -L $ORACLE_HOME/lib/ -lclntsh
int port = 8000;
void sql_error(char *);
void insertdata(char []);

int main(void)

{

  struct sockaddr_in    sin;

  struct sockaddr_in    pin;

  int           mysock;

  int           tempsock;

  int           addrsize;

  char  str[100],str1[20],str2[20],str3[100];

  char  buf[100],buf1[100];

  int           i, len1, len2;

  float c;

  /* 寤虹?socket */

  mysock = socket(AF_INET, SOCK_STREAM, 0);

  if (mysock == -1) {

    perror("call to socket");

    exit(1);

  }

  /* 寤虹?IPv4浣嶅? */

  bzero(&sin, sizeof(sin));

  sin.sin_family = AF_INET;

  sin.sin_addr.s_addr = htonl(INADDR_ANY);

  sin.sin_port = htons(port);

  /* ?绲恠ocket */

  if (bind(mysock, (struct sockaddr *)&sin, sizeof(sin)) == -1) {

    perror("call to bind");

    exit(1);

  }

  /* ?捐伣 client绔?*/

  if (listen(mysock, 20) == -1) {

    perror("call to listen");

    exit(1);

  }

  printf("Accepting connections ...\n");

  while(1) {

    /* ?ュ?client绔