2024年數(shù)據(jù)庫實驗報告

《數(shù)據(jù)庫原理》試驗匯報題目：試驗六:ODBC/JDBC數(shù)據(jù)庫編程學號姓名班級曰期xxxxxxxxxxxx.10.29試驗內(nèi)容、環(huán)節(jié)以及成果1. ODBC配置以及程序調(diào)試：（50分）(1) 配置一種ODBC數(shù)據(jù)源，規(guī)定數(shù)據(jù)源名稱：student，其中包括s(學生信息)表。1.用系統(tǒng)工具配置ODBC，點擊“添加”：2.出現(xiàn)如下對話框，選中SQLSever，點擊完畢3.在出現(xiàn)的對話框中設置屬性，如圖，點擊下一步，點擊下一步後出現(xiàn)如下，更改默認數(shù)據(jù)庫，點擊下一步。4.在出現(xiàn)的對話框中點擊測試連接後出現(xiàn)測試成功的對話框，點擊確定退出ODEC數(shù)據(jù)源管理器。(2) 閱讀并運行試驗給出的例子程序，理解ODBC編程，規(guī)定簡樸寫出自已對這段程序的理解或者流程圖，并且請給出程序運行成果示例圖。定義句柄，變量初始化環(huán)境建立連接初始化語句句柄執(zhí)行語句成果集中處理輸出，釋放句柄成果如下實例運行成果如下：2. 參照給出的ODBC編程示例，使用ODBC技術(shù)，編寫一種簡樸的程序，包括對數(shù)據(jù)庫SPJ的連接，查詢，插入，修改和刪除。（50分）插入：查詢：修改：刪除：代碼：#include"stdafx.h"#include<Windows.h>#include<iostream>#include<sql.h>#include<sqlext.h>#include<sqltypes.h>#include<string>#include<cstdio>usingnamespacestd;intmain(){ SQLHENVhenv; //環(huán)境句柄 SQLHDBChdbc; //連接句柄 SQLHSTMThstmt;//語句句柄 charsql_order[100]; SQLRETURNret; SQLCHARsno[50],sname[50],ssex[50],sbirth[50],sdept[50]; SQLINTEGERcbsno=SQL_NTS,cbsname=SQL_NTS,cbssex=SQL_NTS,cbsbirth=SQL_NTS,cbsdept=SQL_NTS; ret=SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&henv); ret=SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC3,0); ret=SQLAllocHandle(SQL_HANDLE_DBC,henv,&hdbc); ret=SQLConnect(hdbc,(SQLCHAR*)"student",SQL_NTS,(SQLCHAR*)"sa",SQL_NTS,(SQLCHAR*)"123",SQL_NTS); if(!SQL_SUCCEEDED(ret)) return-1; ret=SQLAllocHandle(SQL_HANDLE_STMT,hdbc,&hstmt); intdemo; while(1) { cout<<"1.insert "<<"2.select"<<"3.delete"<<"4.update"<<"0.exit"<<endl; cin>>demo; if(demo==0) { break; } elseif(demo==3) { cout<<"輸入刪除語句"<<endl; getchar(); gets_s(sql_order); ret=SQLExecDirect(hstmt,(SQLCHAR*)sql_order,SQL_NTS); if(ret==SQL_SUCCESS||ret==SQL_SUCCESS_WITH_INFO) { cout<<"刪除成功"<<endl; } SQLFreeHandle(SQL_HANDLE_STMT,hstmt); } elseif(demo==4) { cout<<"輸入更新語句"<<endl; getchar(); gets_s(sql_order); ret=SQLExecDirect(hstmt,(SQLCHAR*)sql_order,SQL_NTS); if(ret==SQL_SUCCESS||ret==SQL_SUCCESS_WITH_INFO) { cout<<"刪除成功"<<endl; } SQLFreeHandle(SQL_HANDLE_STMT,hstmt); } elseif(demo==2) { printf("輸入SQL查詢語句\n"); getchar(); gets_s(sql_order); ret=SQLExecDirect(hstmt,(SQLCHAR*)sql_order,SQL_NTS); if(ret==SQL_SUCCESS||ret==SQL_SUCCESS_WITH_INFO) { ret=SQLBindCol(hstmt,1,SQL_C_CHAR,sno,50,0); ret=SQLBindCol(hstmt,2,SQL_C_CHAR,sname,50,0); ret=SQLBindCol(hstmt,3,SQL_C_CHAR,ssex,50,0); ret=SQLBindCol(hstmt,4,SQL_C_CHAR,sbirth,50,0); ret=SQLBindCol(hstmt,5,SQL_C_CHAR,sdept,50,0); } while(ret=SQLFetch(hstmt)!=SQL_NO_DATA_FOUND) { printf("%s%s%s%s%s\n",sno,sname,ssex,sbirth,sdept); } SQLFreeHandle(SQL_HANDLE_STMT,hstmt); } else { printf("依次輸入插入的學號，姓名，性別，生曰，學院\n"); scanf("%s%s%s%s%s",sno,sname,ssex,sbirth,sdept); ret=SQLPrepare(hstmt,(SQLCHAR*)"insertintoSvalues(?,?,?,?,?)",SQL_NTS); if(ret==SQL_SUCCESS||ret==SQL_SUCCESS_WITH_INFO) { ret=SQLBindParameter(hstmt,1,SQL_PARAM_INPUT,SQL_C_CHAR,SQL_CHAR,50,0,sno,0,&cbsno); ret=SQLBindParameter(hstmt,2,SQL_PARAM_INPUT,SQL_C_CHAR,SQL_CHAR,50,0,sname,0,&cbsname); ret=SQLBindParameter(hstmt,3,SQL_PARAM_INPUT,SQL_C_CHAR,SQL_CHAR,50,0,ssex,0,&cbssex); ret=SQLBindParameter(hstmt,4,SQL_PARAM_INPUT,SQL_C_CHAR,SQL_CHAR,50,0,sbirth,0,&cbsbirth); ret=SQLBindParameter(hstmt,5,SQL_PARAM_INPUT,SQL_C_CHAR,SQL_CHAR,50,0,sdept,0,&cbs