【正文】 an. Lou held a joint interview with 27 media, including China Daily, the first in a series of interviews entitled Chinese Media Along the Silk Road. The interviews will be in Shaanxi and Gansu provinces and the Xinjiang Uygur autonomous region, as well as Kazakhstan, Uzbekistan and Turkey. The media group held the first interview on Wednesday morning in Xi39。s public security bureau shows some 100 foreign visitors enjoyed the 72hour policy by the end of March, most of them from the United States, the United Kingdom and Germany. Chengdu also reported robust growth in its overall tourist industry last year. Official statistics show that it received some 150 million tourists last year, an increase of 28 percent from 2021. Around million came from abroad, an increase of 12 percent. Total revenue from touris m surpassed 133 billion yuan ($). During his visit to Kazakhstan in September, Chinese President Xi Jinping proposed that China and Central Asia join hands to build a Silk Road economic belt to boost cooperation. The idea has been widely echoed in Central Asian countries, being an encouraging blueprint for Chinese areas along the Silk Road that has linked Asia and Europe for more than 2,000 years. In the next three weeks, China Daily reporters will travel through the belt in China and in Kazakhstan, Uzbekistan and Turkey. They will show the progress and expectations of the countries, businesses and peoples on the route. Shaanxi the start of the ancient Silk Road has positioned itself as the new starting point for the development of the Silk Road Economic Belt, which will strengthen China39。s ancient indigenous religion, while Du jiang yan is considered to be the oldest functioning watercontrol project in the world. Chengdu ranked third in tourist facilities, management and services among 60 Chinese cities in a customer satisfaction survey released last year. But, Li added that efforts are still needed to develop more touris m products, improve English services and provide accurate translation of traffic signs and scenic billboards. Zhao Yun, chairwoman of British Chamber of Commerce Southwest China, told China Daily that his colleagues found the policy very convenient. A British client once flew here and stayed for just one day to check her ordered goods, she said. Zhao was born in Shanxi province, but she has lived in Chengdu for more than 10 years. My life was like a running race moving from place to place. I also lived in Beijing and Shanghai before, she said. But Chengdu is a place that you never want to leave once settling down. It is now my second hometown, she said. If the environment is further improved, the city will attract more people to visit and live, with the 72hour visafree policy and pelling conditions in transportation, culture, climate and cuisine, he said. Foreigners also gave positive feedback on the policy. A spokesman from Dell Inc said the pany has a global hub of operation in Chengdu, so the threeday visa has an immediate and positive influence on the pany39。s level of internationalization. The policy will also bring direct economic revenue, Li said. Chengdu has many cultural legacies and is also a paradise for panda lovers with the world39。 圖 2“修改記錄”窗體運(yùn)行界 Private Sub Command1_Click() ‘ 聲明一個(gè)字符串變量 Dim strSQL AS String ‘ 第一步：拼寫 Update語(yǔ)句 strSQL=“ Update 職工工資表 Set 工資數(shù) =“ +Text3+” Where 職工編號(hào) =‘ “ ++” ’ And 工資項(xiàng)編號(hào) =‘ “ ++” ’” ‘ 第二步：執(zhí)行 Update語(yǔ)句 strSQL End Sub Visafree policy brings Chengdu biz, tourism boost. Making national headlines several times, Chengdu39。進(jìn)入界面后，用戶首先選擇職工編號(hào)（ Combo1）、工資項(xiàng)編號(hào) (Combo2)，職工姓名 (Text1)和工資項(xiàng)名稱 (Text2)從數(shù)據(jù)庫(kù)中自動(dòng)讀入；然后，用戶修改對(duì)應(yīng)的工資數(shù)（ Text3），點(diǎn)擊“確認(rèn)”按鈕后，將結(jié)果更新到學(xué)生成績(jī)表中。請(qǐng)補(bǔ)充完成下列程序代碼。 圖 2“增加記錄”窗體運(yùn)行界面 Private Sub Command1_Click() ‘ 聲明一個(gè)記錄集對(duì)象 Dim ADOrs As New Recordset ‘ 將記錄集對(duì)象與已 建立的數(shù)據(jù)庫(kù)聯(lián)接對(duì)象 ADO 綁定 =ADO 第一步：在課程表 Courses 中查詢是否存在關(guān)鍵字相同的記錄 strSQL=“ Select CNo From courses Where Cno=‘” + Text1 + “’” StrSQL ‘ 第二步：如果記錄已經(jīng)存在，則退出程序 If Not Then MsgBox “ 記錄已存在，不能繼續(xù)增加 ” Exit Sub End If ‘ 第三步：將結(jié)果插入到課程表 Courses中 strSQL = “ Insert Into courses(Cno,CName) Values(‘” +Text1+“’ ,‘” +Text2+“’ )” strSQL （本小點(diǎn) 6 分） End Sub 接第五大題第 2 小題，現(xiàn)要求開(kāi) 發(fā)物資管理信息系統(tǒng)， 物資臺(tái)帳錄入功能的界面如圖 1 所示，其中 Text1 為物資編號(hào)、 Text2為物資名稱、 Text3 為物資單價(jià)。進(jìn)入界面后，用戶輸入所有數(shù)據(jù)，點(diǎn)擊“確認(rèn)”按鈕，將結(jié)果插入到課程表 courses中。請(qǐng)補(bǔ)充完成下列程序代碼。 圖 1“增加記錄”窗體運(yùn)行界面 Private Sub Command1_Click() ‘ 聲明一個(gè)記錄集對(duì)象 Dim ADOrs As New Recordset ‘ 將記錄集對(duì)象與已建立的數(shù)據(jù)庫(kù)聯(lián)接對(duì)象 ADO 綁定 =ADO ‘ 第一步：在學(xué)生成績(jī)表中查詢是否存在關(guān)鍵字相同的記錄 strSQL=“ Select * From 學(xué)生成績(jī)表 Where 學(xué)號(hào) =‘ ”++“ ’ And 課程號(hào) =‘ ” ++“ ’ ” StrSQL ‘ 第二步：如果關(guān)鍵字重復(fù)，則退出程序 If Not Then （本小點(diǎn) 3 分） MsgBox “ 記錄已存在，不能繼續(xù)增加 ” Exit Sub End If ‘ 第三步：將結(jié)果 插入到學(xué)生成績(jī)表中 StrSQL=“ Insert Into 學(xué)生成績(jī)表 (學(xué)號(hào) ,課程號(hào) ,成績(jī) ) Values(‘” ++“ ’ ,‘” ++“ ’ , ”+Str(Val())+“ )” StrSQL End Sub 設(shè)學(xué)生成績(jī)表的結(jié)構(gòu)為 （學(xué)號(hào)、課程號(hào)、成績(jī)），程序運(yùn)行界面如圖 1 所示。進(jìn)入界面后， 用戶首先選擇學(xué)號(hào)（ Combo1）、課程號(hào) (Combo2)，姓名 (Text1)和課程名 (Text2)從數(shù)據(jù)庫(kù)中自動(dòng)讀入；然后，用戶輸入對(duì)應(yīng)的成績(jī)（ Text3），點(diǎn)擊“確認(rèn)”按鈕后，將結(jié)果插入到學(xué)生成績(jī)表中。 如果要達(dá)到如圖 1所示的查詢結(jié)果，請(qǐng)寫出對(duì)應(yīng)的 SQL查詢語(yǔ)句。 Cno 是該表主鍵，字符型（長(zhǎng)度 10）。 ．利用 SQL語(yǔ)句進(jìn)行查詢 在上題基 礎(chǔ)上，假設(shè)還存在工資數(shù)據(jù)表 C，包括職工編號(hào) CNo，基本工資 Cn 等字段。 TNo是主鍵，請(qǐng)用 SQL 語(yǔ)句創(chuàng)建該數(shù)據(jù)表 T。 ．用 SQL語(yǔ)句創(chuàng)建簡(jiǎn)單數(shù)據(jù)表 設(shè) 有職工數(shù)據(jù)表 T， 包括職工編號(hào) TNo，姓名 TN，出生年月日 TD等字段。該數(shù)據(jù)表與物資臺(tái)賬數(shù)據(jù)表 T 之間存在外鍵約束，即物資臺(tái)賬數(shù)據(jù)表 T 中不存在的記錄不能夠出現(xiàn)在該表中。 Cn 為數(shù)值型（兩位小數(shù)）。 CREATE TABLE T ( TNo CHAR(20) PRIMARY KEY, TN CHAR(20), TD Money )。 圖 1 要求的顯示結(jié)果 SELECT ,Sname,Cname,mark FROM students,courses,marks WHERE = and = and =‘ 2021001’ ．用 SQL語(yǔ)句創(chuàng)建簡(jiǎn)單數(shù)據(jù)表 設(shè)某數(shù)據(jù)庫(kù)中的 物資臺(tái)賬數(shù)據(jù)表 T，包括物資編號(hào) TNo、物資名稱 TN、物資單價(jià) TD 等字段； TNo和 TN 為字符型（長(zhǎng)度 20）， TD為數(shù)值型（帶小數(shù)）。課程表 Courses 包括