vb結(jié)合sql開發(fā)學(xué)校教務(wù)管理系統(tǒng)(專業(yè)版)
【正文】 )), con, adOpenKeyset, adLockOptimistic, adCmdText Set = rs End Sub Private Sub Command3_Click() select * from 課程信息表 where 課 程號(hào) in (select 課程號(hào) from 教學(xué)成績表 where 學(xué)號(hào) in (select 學(xué)號(hào) from 學(xué)生信息表 where 姓名 =39。, con, 1, 3, adCmdText select * from 課程信息表 , con, adOpenKeyset, adLockOptimistic, adCmdText Set = rs End Sub Private Sub Form_Load() Provider=。, con, 1, 3, adCmdText select * from 學(xué)生信息表 , con, adOpenKeyset, adLockOptimistic, adCmdText Set = rs End Sub 6 Private Sub Form_Load() Provider=。Persist Security Info=False。 39。Integrated Security=SSPI。Integrated Security=SSPI。 還了解了 怎樣創(chuàng)建 數(shù)據(jù)庫、 創(chuàng)建 表 和對(duì)表的修改插入數(shù)據(jù) 、 創(chuàng)建 視圖 以及 對(duì) 完整性的約束 的知識(shí)點(diǎn) 。 + + 39。 + + 39。 amp。Data Source=7MZZQCR4HI4IDQV Exit Function 1: MsgBox End End Function Private Sub Command1_Click() If Trim() And Trim() Then Dim rs As New Recordset select username from tb_user where username =39。Persist Security Info=False。Persist Security Info=False。)), con, adOpenKeyset, adLockOptimistic, adCmdText 12 Set = rs End Sub Private Sub Form_Load() Provider=。)) , con, adOpenKeyset, adLockOptimistic, adCmdText Set = rs End Sub Private Sub Command2_Click() select * from 教師信息表 where 教師號(hào) in (select 教師號(hào) from 教學(xué)成績表 where 課程號(hào) in (select 課程號(hào) from 課程信息表 where 課程名稱 =39。, con, 1, 3, adCmdText Set = rs End Sub Private Sub Command3_Click() (課程號(hào) ) = (院系編號(hào) ) = (學(xué)
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1