数据库系统概论课程设计报告

数据库课程设计报告

COURSE CHAR(5)PRIMARY KEY, COURSENAME CHAR(20), DEPARTMENT CHAR(20), NURCCREDITS CHAR(5) );

INSERT INTO COURSES

VALUES('450','Western Civilization','History','3'); INSERT INTO COURSES

VALUES('730','Calculus Iv','Math','4'); INSERT INTO COURSES

VALUES('290','English Composition','English','3'); INSERT INTO COURSES

VALUES('480','Compiler Writing','Computer Science','3'); CREATE TABLE SECTION (

SECTION CHAR(5),

TEACHER CHAR(5)PRIMARY KEY, COURSE CHAR(5),

NUMSTUDENTS CHAR (5) );

INSERT INTO SECTION VALUES('1','303','450','2'); INSERT INTO SECTION VALUES('1','290','730','6'); INSERT INTO SECTION VALUES('1','430','290','3'); INSERT INTO SECTION VALUES('1','180','480','3'); INSERT INTO SECTION VALUES('2','560','450','2'); INSERT INTO SECTION VALUES('2','784','480','2'); CREATE TABLE ENROLLS (

COURSE CHAR(5), SECTION CHAR(5), STUDENT CHAR(5), GRADE CHAR(5)

PRIMARY KEY(COURSE,STUDENT) );

INSERT INTO ENROLLS VALUES('730','1','148','3'); INSERT INTO ENROLLS VALUES('450','2','210','3');

5

数据库课程设计报告

INSERT INTO ENROLLS VALUES('730','1','210','1'); INSERT INTO ENROLLS VALUES('290','1','298','3'); INSERT INTO ENROLLS VALUES('480','2','298','3'); INSERT INTO ENROLLS VALUES('730','1','348','2'); INSERT INTO ENROLLS VALUES('290','1','349','4'); INSERT INTO ENROLLS VALUES('480','1','358','4'); INSERT INTO ENROLLS VALUES('480','1','410','2'); INSERT INTO ENROLLS VALUES('450','1','473','2'); INSERT INTO ENROLLS VALUES('730','1','473','3'); INSERT INTO ENROLLS VALUES('480','2','473','0'); INSERT INTO ENROLLS VALUES('290','1','548','2'); INSERT INTO ENROLLS VALUES('730','1','558','3'); INSERT INTO ENROLLS VALUES('730','1','649','4'); INSERT INTO ENROLLS VALUES('480','1','649','4'); INSERT INTO ENROLLS VALUES('450','1','654','4'); INSERT INTO ENROLLS VALUES('450','2','548','1'); C++代码：

// ks.cpp : 定义控制台应用程序的入口点。 //

#include \

int _tmain(int argc, _TCHAR* argv[]) {

return 0; }

#include #include #include

#include // This is the the main include for ODBC Core functions.

6

数据库课程设计报告

#include // This is the include for applications using the Microsoft SQL Extensions

#include // This file defines the types used in ODBC

#include // This is the unicode include for ODBC Core functions

#include // This is the application include file for the SQL Server driver specific defines.

#include #include #include using namespace std;

#define STUDENT_LEN 5

#define STUDENTNAME_LEN 20 #define ADDRESS_LEN 50 #define ZIP_LEN 40 #define CITY_LEN 10 #define STATE_LEN 10 #define SEX_LEN 10

#define TEACHER_LEN 5

#define TEACHERNAME_LEN 10 #define PHONE_LEN 10 #define SALARY_LEN 10 #define COURSE_LEN 5

#define COURSENAME_LEN 20 #define DEPARTMENT_LEN 20 #define NURCCREDITS_LEN 5 #define SECTION_LEN 5

#define NUMSTUDENTS_LEN 5 #define GRADE_LEN 5 void back(){} int main() { /*Step 1 定义句柄括和变量*/

SQLHENV dinghenv; //环境句柄括 SQLHDBC dinghdbc; //连接句柄括 SQLHSTMT dinghstmt; //语句句柄括 SQLRETURN ret; SQLCHAR

STUDENT[STUDENT_LEN],STUDENTNAME[STUDENTNAME_LEN],ADDRESS[ADDRESS_LEN],ZIP[ZIP_LEN],CITY[CITY_LEN],

STATE[STATE_LEN],SEX[SEX_LEN],TEACHER[TEACHER_LEN],TEACHERNAME[TEACHERNAME_LEN],PHONE[PHONE_LEN],

SALARY[SALARY_LEN],COURSE[COURSE_LEN],COURSENAME[COURSENAME_

7

数据库课程设计报告

LEN],DEPARTMENT[DEPARTMENT_LEN],

NURCCREDITS[NURCCREDITS_LEN],SECTION[SECTION_LEN],NUMSTUDENTS[NUMSTUDENTS_LEN],GRADE[GRADE_LEN];

SQLINTEGER

cbSTUDENT=SQL_NTS,cbSTUDENTNAME=SQL_NTS,cbADDRESS=SQL_NTS,cbZIP=SQL_NTS,cbCITY=SQL_NTS,

cbSTATE=SQL_NTS,cbSEX=SQL_NTS,cbTEACHER=SQL_NTS,cbTEACHERNAME=SQL_NTS,cbPHONE=SQL_NTS,

cbSALARY=SQL_NTS,cbCOURSE=SQL_NTS,cbCOURSENAME=SQL_NTS,cbDEPARTMENT=SQL_NTS,

cbNURCCREDITS=SQL_NTS,cbSECTION=SQL_NTS,cbNUMSTUDENTS=SQL_NTS,cbGRADE=SQL_NTS;

int w,x,y,m,n;

/*Step 2 初始化环境3*/

loop: ret=SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&dinghenv); ret=SQLSetEnvAttr(dinghenv,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC3,0);

/*Step 3 建立连接*/

ret=SQLAllocHandle(SQL_HANDLE_DBC,dinghenv,&dinghdbc);

ret=SQLConnect(dinghdbc,(SQLWCHAR*)(_T(\R*)(_T(\

if(!SQL_SUCCEEDED(ret)) return -1;

/*Step 4 初始化语句句柄括*/

ret=SQLAllocHandle(SQL_HANDLE_STMT,dinghdbc,&dinghstmt);

ret=SQLSetStmtAttr(dinghstmt,SQL_ATTR_ROW_BIND_TYPE,(SQLPOINTER)SQL_BIND_BY_COLUMN,SQL_IS_INTEGER);

/*Step 5 执行语句*/

cout<<\教务管理的应用系统+++++++++++++++++++++++++++\

cout<<\输入需要操作的学号：\ cout<<\、学生管理\ cout<<\、教师管理\ cout<<\、信息查询\ cout<<\、退出\ cin>>w; switch(w) {

case 1:w=1; {

8