Pro * C simple sample code

The following code connects to the database and then performs some operations

The name of my database table is ym_test. There are only two fields, int type I, and char * type

Dbop. PC File

1. # Include <stdio. h>
2. # Include <stdlib. h>
3. # Include <string. h>
4. # Include "dbop. H"
6. Exec SQL begin declare section;
7. SQL _context CTX;
8. Exec SQL end declare section;
10. Exec SQL include sqlca;
12. Void sqlerror ();
14. Int conndb (char * sdbconnstr)
15. {
16. Exec SQL begin declare section;
17. Char sconnsql [256];
18. Exec SQL end declare section;
20. Memset (sconnsql, 0, sizeof (sconnsql ));
21. Snprintf (sconnsql, sizeof (sconnsql), "% s", sdbconnstr );
23. Exec SQL context allocate: CTX;
24. Exec SQL context use: CTX;
25. Exec SQL CONNECT: sconnsql;
27. Return sqlca. sqlcode;
28. }
30. Int releasedb ()
31. {
32. Exec SQL commit release;
33. Return 0;
34. }
36. Int readdb (INT number)
37. {
38. Exec SQL begin declare section;
39. Int num;
40. Char name [20];
41. Exec SQL end declare section;
43. Num = number;
44. Exec SQL select Str
45. Into: Name
46. From ym_test
47. Where I =: num;
48. Printf ("/n % s/n", name );
50. Return 0;
51. }
53. Int writedb (INT number, char * names)
54. {
55. Exec SQL begin declare section;
56. Int num;
57. Char name [20];
58. Exec SQL end declare section;
60. Num = number;
61. Strcpy (name, names );
63. Exec SQL insert
64. Into ym_test (
65. I,
66. Str
67. ) Values (
68. : Num,
69. : Name
70. );
72. Return 0;
73. }
75. Int deletedb (INT number)
76. {
77. Exec SQL begin declare section;
78. Int num;
79. Exec SQL end declare section;
81. Num = number;
82. Exec SQL Delete from ym_test
83. Where I =: num;
85. Return 0;
86. }
88. Void sqlerror ()
89. {
90. Exec SQL whenever sqlerror continue;
91. Printf ("/noracle error detected:/N ");
93. Printf ("% d/N", sqlca. sqlcode );
94. Printf ("/n % s/n", sqlca. sqlerrm. sqlerrmc );
96. /* Roll back the transaction */
97. Exec SQL rollback release;
99. Exit (1 );
100. }

The main. cpp file code is as follows:

1. # Include <stdio. h>
2. # Include <stdlib. h>
3. # Include <string. h>
4. # Include "dbop. H"
6. Int main (INT argc, char * argv [])
7. {
8. Conndb (user01/user001 @ testdb );
9. Readdb (2 );
10. Readdb (1 );
11. Writedb (22, "mengge ");
12. Readdb (22 );
13. Deletedb (2 );
14. Releasedb ();
15. Return 0;
16. }

 

The compilation script is:

1. #! /Bin/sh
3. Proc code = CPP ltype = none INAME = dbop. PC oname = dbop. cpp
4. G ++-g-wall-C dbop. cpp
5. G ++-g-wall-C main. cpp
6. G ++-g-wall-L $ ORACLE_HOME/lib-l clntsh main. O dbop. O-o main
8. # Deleting intermediate files
9. Rm-F dbop. O dbop. cpp main. o