【正文】 seIf(signe = 1 Or mytemp = 1)Then con1 = ”delete from airlineinfo where 航線編號=39?！?+ + ”39。“ con = ”insert into airlineinfo values(39?！?+ ano + ”39。,39?！?+ dc + ”39。,39。“ + ac + ”39。,39。“ + dd + ”39。,39。“ + dt + ”39。,39?！?+ at + ”39。,39?！?+ pno + ”39。,39?！?+ cp + ”39。,39?！?+ cap + ”39。,39。“ + fp + ”39。,39?！?+ am + ”39。)“ Try (con1)Catch ex As Exception ()End Try Try (con)If(mytemp = 0)Then MsgBox(”添加成功！“)End If If(mytemp = 1)Then MsgBox(”修改成功！“)End If Catch ex As Exception ()End Try = ”“ = ”“ = ”“ = ”“ = ”“ = ”“ = ”“ = ”“ = ”“ = ”“ = ”“ End If End Sub Private Sub Button2_Click(ByVal sender As , ByVal e As )Handles ()End Sub Private Sub GroupBox1_Enter(ByVal sender As , ByVal e As )Handles End Sub End Class 添加用戶代碼：Public Class 添加用戶Inherits Region ” Windows 窗體設(shè)計(jì)器生成的代碼“ Public Sub New()()39。該調(diào)用是Windows 窗體設(shè)計(jì)器所必需的。InitializeComponent()39。在InitializeComponent()調(diào)用之后添加任何初始化End Sub 39。窗體重寫dispose 以清理組件列表。Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)If disposing Then If Not(ponents Is Nothing)Then ()End If End If (disposing)End Sub39。Windows 窗體設(shè)計(jì)器所必需的Private ponents As 39。注意: 以下過程是Windows 窗體設(shè)計(jì)器所必需的39?？梢允褂肳indows 窗體設(shè)計(jì)器修改此過程。39。不要使用代碼編輯器修改它。Friend WithEvents Label1 As Friend WithEvents Label2 As Friend WithEvents Label3 As Friend WithEvents Label4 As Friend WithEvents TextBox1 As Friend WithEvents TextBox2 As Friend WithEvents TextBox3 As Friend WithEvents TextBox4 As Friend WithEvents Button1 As Friend WithEvents Button2 As Private Sub InitializeComponent()Dim resources As = New (GetType(添加用戶)) = New = New = New = New = New = New = New = New = New = New ()39。Label139。 = New (”宋體“, !, , , CType(134, Byte)) = New (55, 33) = ”Label1“ = New (100, 23) = 0 = ”用戶名“ 39。39。Label2 = New (”宋體“, !, , , CType(134, Byte)) = New (55, 84) = ”Label2“ = New (100, 23) = 1 = ”姓名“ 39。Label3 = New (”宋體“, !, , , CType(134, Byte)) = New (55, 121) = ”Label3“ = New (100, 23) = 2 = ”新密碼“ 39。Label4 = New (”宋體“, !, , , CType(134, Byte)) = New (55, 168) = ”Label4“ = New (100, 23) = 3 = ”確認(rèn)密碼“ 39。TextBox1 = New (224, 32) = ”TextBox1“ = New (100, 21) = 4 39。TextBox2 = New (224, 72) = ”TextBox2“ = New (100, 21) = 5 39。TextBox3 = New (224, 120) = ”TextBox3“ = (42) = New (100, 21) = 6 39。TextBox4 = New (224, 168) = ”TextBox4“ = (42) = New (100, 21) = 739。39。Button1 39。 = New (”宋體“, !, , , CType(134, Byte)) = New (48, 208) = ”Button1“ = New (88, 40) = 8 = ”確定“ 39。Button2 = New (”宋體“, !, , , CType(134, Byte)) = New (240, 208) = ”Button2“ = New (88, 40) = 9 = ”取消“ 39。添加用戶 39。 = New (6, 14) = New (392, 270)()()()()()()()()()() = CType((”$“), ) = ”添加用戶“ = = ”添加用戶“ (False)()End Sub End Region Private Sub Button1_Click(ByVal sender As , ByVal e As )Handles ()Dim con As String Dim user, name As String Dim pw1, pw2 As String Dim ds As DataSet Dim signe As Integer = 1 user = name = pw1 = pw2 = con = ”select * from users where id=39?！?+ + ”39?！?ds = (con)Try If((0). 0)Then = (0).Rows(0)If (”id“) ”“ Then MsgBox(”已存在用戶！“)()()()()()signe = 0 End If End If Catch ex As Exception ()End Try If( )Then (”密碼不一致，請重新確認(rèn)“, ”提示“)()()()signe = 0 End If If Trim()= ”“ Then MsgBox(”用戶名不能為空！“)Exit Sub ()ElseIf(signe = 1)Then con = ”insert into users values(39?！?+ user + ”39。,39?！?+ pw2 + ”39。,39?！?+ name + ”39。,39。null39。)“ (con)MsgBox(”添加成功！)End If End Sub Private Sub Button2_Click(ByVal sender As , ByVal e As )Handles ()End Sub Private Sub 添加用戶_Load(ByVal sender As , ByVal e As )Handles ct = 0 End SubEnd Class第二篇：航空售票管理系統(tǒng)include include include include include define N 100 using namespace std。typedef struct node//定義信息結(jié)構(gòu)體 {char num[10]。// 航班號int hour。//起飛時(shí)間小時(shí)int minitues。//起飛時(shí)間分鐘char start[10]。//起始char end[10]。//終點(diǎn)float prize。//經(jīng)濟(jì)艙票價(jià)int last。//剩余座位 }FLIGHT。typedef struct Order//訂單信息 {char name[10]。//乘客姓名char num[10]。//航班號int count。//訂票數(shù)量 }Order。class flight//定義類 {private: FLIGHT stu[N]。//每個(gè)元素對應(yīng)一條信息Order psg[N]。//訂單int len。//航班總數(shù)int lenp。//訂票者總數(shù) public:flight()。~flight()。void input()。//錄入信息void show()。//瀏覽void sall()。//售票void back()。//退票void search()。// 信息查詢void search2()。// 信息查詢（起點(diǎn)終點(diǎn)）char menu()。//菜單}。flight stud。char filename[]=“”。flight::flight(){}//構(gòu)造函數(shù) flight::~flight(){}//析構(gòu)函數(shù)bool CheckTime(int h1,int m1,int h2,int m2)//判斷兩個(gè)時(shí)間前后{ if(h1return true。else if(h1==h2){if(m1return true。elsereturn false。} elsereturn false。} void flight::show()//瀏覽 {system(“cls”)。//清屏cout所有航班信息如下：”起飛時(shí)間起點(diǎn)終點(diǎn)經(jīng)濟(jì)艙票價(jià)剩余座位備注”for(int i=0。iprintf(“%10s%:%%10s%10s%%10d”,stu[i].num,stu[i].hour,stu[i].minitues,stu[i].start,stu[i].end,stu[i].prize,stu[i].last)。time_t t。struct tm *tm。t=time(NULL)。//獲取當(dāng)前系統(tǒng)時(shí)間tm=localtime(amp。t)。if(CheckTime([i].hour,[i].minitues,tmtm_hour,tmtm_min)==true)//如果起飛時(shí)間在當(dāng)前時(shí)間之前 輸出此次航班已發(fā)出coutelsecout} coutvoid flight::back()//退票 {char name[20]。char s[20]。system(“cls”)。//清屏couts。for(int i=0。iif(strcmp([i].num,s)==0)break。//存在 結(jié)束循環(huán)if(i==)//這二者相等說明查找完所有信息也沒找到輸入信息，說明輸入航班編號不存在{coutsystem(“pause”)。//任意鍵繼續(xù)return。}time_t t。struct tm *tm。t=time(NULL)。//獲取當(dāng)前系統(tǒng)時(shí)間tm=localtime(amp。t)。if(CheckTime([i].hour,[i].minitues,tmtm_hour,tmtm_min)==true){coutsystem(“pause”)。//任意鍵繼續(xù)return。} int j=i。coutname。for(i=0。iif(strcmp([i].name,name)==0 amp。amp。 strcmp([i].num,s)==0)//查詢這個(gè)名字是否相同{[j].last+=[i].count。//退票[i]=[]。///刪除這個(gè)訂單。//訂單數(shù)減一coutsystem(“pause”)。//任意鍵繼續(xù)return。} } coutsystem(“pause”)。//任意鍵繼續(xù)}void flight::sall()//售票 {char s[20]。system(“cls”)。//清屏couts。for(int i=0。iif(strcmp([i].num,s)==0)break。//存在 結(jié)束循環(huán)if(i==)//這二者相等說明查找完所有信息也沒找到輸入信息，說明輸入航班編號不存在{coutsystem(“pause”)。//任意鍵繼續(xù)return。}if([i].last{coutsystem(“pause”)。//任意鍵繼續(xù)return。}time_t t。struct tm *tm。t=time(NULL)。//獲取當(dāng)前系統(tǒng)時(shí)間tm=localtime(amp。t)。if(CheckTime([i].hour,[i].minitues,tmtm_hour,tmtm_min)==true){coutsystem(“pause”)。//任意鍵繼續(xù)return。}int j=i。i=。strcpy([i].num,[i].num)。cout[i].count。while([i].count[i].last){coutcin[i].count。} cout[i].name。[j].last=[i].count。//剩余票數(shù)++。coutvoid flight::input()//錄入信息 {system(“cls”)。//清屏for(int i=。i{coutcin[i].num。coutchar ch。cin[i].hourch[i].minitues。coutcin[i].start。coutcin[i].end。coutcin[i].prize。coutcin[i].last。++。//個(gè)數(shù)加1coutwhile(1){cinch。if(ch==39。y39。 || ch==39。Y39。 || ch==39。n39。 || ch==39。N39。)break。elsecout}if(ch==39。n39。 || ch==39。N39。)break。} }void flight::search()// 信息查詢 {char s[20]。system(“cls”)。//清屏couts。for(int i=0。iif(strcmp([i].num,s)==0)break。//存在 結(jié)束循環(huán)if(i==)//這二者相等說明查找完所有信息也沒找到輸入信息，說明輸入航班編號不存在{coutsystem(“pause”)。//任意鍵繼續(xù)return。}cout查詢結(jié)果如下：”起飛時(shí)間起點(diǎn)終點(diǎn)經(jīng)濟(jì)艙票價(jià)剩余座位備注”printf(“%10s%:%%10s%10s%%10d”,stu[i].num,stu[i].hour,stu[i].minitues,stu[i].start,stu[i].end,stu[i].prize,stu[i].last)。time_t t。struct tm *tm。t=time(NULL)。//獲取當(dāng)前系統(tǒng)時(shí)間tm=localtime(amp。t)。if(CheckTime([i].hour,[i].minitues,tmtm_hour,tmtm_min)==true)//如果起飛時(shí)間在當(dāng)前時(shí)間之前 輸出此次航班已發(fā)出coutelsecoutcoutvoid flight::search2()// 信息查詢（按線路）{char s1[20],s2[20]。system(“cls”)。//清屏couts1。couts2。for(int i=0。iif(strcmp([i].start,s1)==0 amp。amp。 strcmp([i].end,s2)==0)break。//存在 結(jié)束循環(huán)if(i==)//這二者相等說明查找完所有信息也沒找到輸入信息，說明輸入航班編號不存在{coutsystem(“pause”)。//任意鍵繼續(xù)return。}cout查詢結(jié)果如下：”起飛時(shí)間起點(diǎn)終點(diǎn)經(jīng)濟(jì)艙票價(jià)剩余座位備注”for(i=0。iif(strcmp([i].start,s1)==0 amp。amp。 strcmp([i].end,s2)==0){printf(“%10s%:%%10s%10s%%10d”,stu[i].num,stu[i].hour,stu[i].minitues,stu[i].start,stu[i].end,stu[i].prize,stu[i].last)。time_t t。struct tm *tm。t=time(NULL)。//獲取當(dāng)前系統(tǒng)時(shí)間tm=localtime(amp。t)。if(CheckTime([i].hour,[i].minitues,tmtm_hour,tm