數(shù)據(jù)庫(kù)編程試題

1、數(shù)據(jù)庫(kù)編程試題2009-08-10 14:13 張昆電子工業(yè)出版社我要評(píng)論(0)摘要：Java程序員面試指南第 17章常見(jiàn)的Java上機(jī)面試題，本章將經(jīng)常岀現(xiàn)的上機(jī)編程題進(jìn)行分類，希望能夠給讀者帶來(lái)幫助和啟示。本節(jié)為大家介紹數(shù)據(jù)庫(kù)編程試題。標(biāo)簽：數(shù)據(jù)庫(kù)編程ava 程序員 Java程序員面試指南Oracle幫您準(zhǔn)確洞察各個(gè)物流環(huán)節(jié)數(shù)據(jù)庫(kù)編程試題數(shù)據(jù)庫(kù)和常見(jiàn)的開(kāi)源技術(shù)是Java程序員必須掌握的基本技能，面試者一定要熟練掌握相關(guān)知識(shí)，這樣才能在面試中取得滿意的成績(jī)。面試題9根據(jù)表結(jié)構(gòu)寫(xiě)出相應(yīng)的SQL語(yǔ)句考題題干有3個(gè)表：Employee 職工(工號(hào)，姓名，性另，年齡，咅部門(mén))(num, name,

2、sex，age, departmentno )Wage工資(編號(hào)，工資金額)(No, amount)Attend出勤(工號(hào)，工資編號(hào)，出勤率 )(num, No, attendanee )請(qǐng)根據(jù)要求，編寫(xiě)相應(yīng)的SQL語(yǔ)句。(1) 寫(xiě)一個(gè)SQL語(yǔ)句，查詢工資金額為8000的職工工號(hào)和姓名。(2) 寫(xiě)一個(gè)SQL語(yǔ)句，查詢職工張三的出勤率。(3) 寫(xiě)一個(gè)SQL語(yǔ)句，查詢3次出勤率為0的職工姓名和工號(hào)。(4) 寫(xiě)一個(gè)SQL語(yǔ)句，查詢出勤率為10并且工資金額小于 2500的職工信息。參考答案(1) select eml. num , from Employee emlwhere (select coun

3、 t(*) from Atte nd where num =and No = (select No from Wage where amou nt ='8000 ');where name='張三');(2) select amount from Wage where No in (select No from Atte nd where num=(select num from Employee(3) select , from Employee eml where (select coun t(*) from Atte nd where num= and a

4、tte ndan ce=0) = 3;(4) select * from Employee emlwhere (select No from Atte nd where num= and atte ndan ce='10')=(select No from Wage where amoun t<2500 );面試題10 編寫(xiě)MySQl數(shù)據(jù)庫(kù)的JDBC連接考題題干請(qǐng)編寫(xiě)訪問(wèn)MySQl數(shù)據(jù)庫(kù)的JDBC連接代碼，查詢數(shù)據(jù)庫(kù)中user表的全部?jī)?nèi)容，并打印 出來(lái)。試題分析讀者必須掌握常見(jiàn)的數(shù)據(jù)庫(kù)訪問(wèn)內(nèi)容，包括驅(qū)動(dòng)、端口等參數(shù)。參考答案具體代碼實(shí)現(xiàn)如下：1.import2.impor

5、t3.import4.import5.import6.7.publicclassDbConn 8.privatestaticDataSource ds = null ;9.privatestaticConnection conn = null ;10.publicstaticConnection getConn_jdbc()newlnstance();11.conn = (url,username,password);12.returnconn;13. catch(Exceptione) 14."數(shù)據(jù)庫(kù)連接異常：”+ ()；15.returnnull ;16.17.18.public

6、void CloseConn() /關(guān)閉數(shù)據(jù)庫(kù)連接19.try20.();21.catch(Exceptione)22."數(shù)據(jù)庫(kù)連接關(guān)閉異常："+ ();23.24.25.publicstaticvoid main(Stringa) /測(cè)試數(shù)據(jù)庫(kù)連接26.Connection conn;27.DbConndc = new DbConn();28.conn =();29.try30.Statement stmt=();31.String strSql ="select* from32.ResultSet rs =(strSql);33.while ()34."name："+ ("name");3