第一篇：學(xué)生信息管理系統(tǒng)源代碼
學(xué)生信息管理系統(tǒng)源代碼
import java.io.*;
class StuInfo {
public String name;
public int number;
public String sex;
public String age;
public String bir;
public String email;
public String addr;
public String tel;
public String getName(){
return name;
}
public void setName(String name){
this.name = name;
}
public int getNumber(){
return number;
}
public void setNumber(int number){
this.number = number;
}
public String getSex(){
return sex;
}
public void setSex(String sex){
this.sex = sex;
}
public String getAge(){
return age;
}
public void setAge(String age){
this.age = age;
}
public String getBir(){
return bir;
}
public void setBir(String bir){
this.bir = bir;
}
public String getEmail(){
return email;
} public void setEmail(String email){
this.email = email;} public String getAddr(){
return addr;} public void setAddr(String addr){
this.addr = addr;} public String getTel(){
return tel;} public void setTel(String tel){
this.tel = tel;} } public class Student { private static PrintStream out = System.out;private static String filename = “Stu.txt”;private static int total = 0;private static int rt = 0;//recyle length private StuInfo[] stuInfos;private StuInfo[] recycle;BufferedReader buf = new BufferedReader(new InputStreamReader(System.in));//創(chuàng)建緩沖流
public Student(){
stuInfos = new StuInfo[11];
}
public void 信息錄入(){
BufferedReader buf = new BufferedReader(new InputStreamReader(System.in));
try{
System.out.print(“n請輸入學(xué)生信息（以0結(jié)束）n”);
System.out.print(“學(xué)號：n”);
StuInfo stu = new StuInfo();
stu.setNumber(Integer.parseInt(buf.readLine()));
while(stu.getNumber()!=0){
System.out.print(“姓名：nn”);
stu.setName(buf.readLine());
System.out.print(“性別：nn”);
stu.setSex(buf.readLine());
System.out.print(“年齡：nn”);
stu.setAge(buf.readLine());
System.out.print(“生日：nn”);
stu.setBir(buf.readLine());
System.out.print(“郵箱：nn”);
stu.setEmail(buf.readLine());
System.out.print(“地址：nn”);
stu.setAddr(buf.readLine());
System.out.print(“電話：nn”);
stu.setTel(buf.readLine());
//添加其他輸入信息
stuInfos[total]=stu;
total++;
stu = new StuInfo();
System.out.print(“n請輸入下一個學(xué)生信息（以0結(jié)束）n”);
System.out.print(“姓名：n”);
stu.setName(buf.readLine());
}
}catch(Exception e){
out.print(e);
}
} public void 保存數(shù)據(jù)(){ try{
FileWriter fwr=new FileWriter(filename);
BufferedWriter fw = new BufferedWriter(fwr);
fw.write(total+“rn”);
for(int k=0;k fw.write(stuInfos[k].getNumber()+“rn”); fw.write(stuInfos[k].getName()+“rn”); fw.write(stuInfos[k].getSex()+“rn”); fw.write(stuInfos[k].getAge()+“rn”); fw.write(stuInfos[k].getBir()+“rn”); fw.write(stuInfos[k].getEmail()+“rn”); fw.write(stuInfos[k].getAddr()+“rn”); fw.write(stuInfos[k].getTel()+“rn”); } fw.write(rt+“rn”); for(int k=0;k fw.write(recycle[k].getNumber()+“rn”); fw.write(recycle[k].getName()+“rn”); fw.write(recycle[k].getSex()+“rn”); } fw.write(recycle[k].getAge()+“rn”);fw.write(recycle[k].getBir()+“rn”);fw.write(recycle[k].getEmail()+“rn”);fw.write(recycle[k].getAddr()+“rn”);fw.write(recycle[k].getTel()+“rn”); } fw.flush(); fw.close(); fwr.close(); System.out.println(“n已保存數(shù)據(jù)！”);}catch(Exception e){ out.print(e);} public void 讀取數(shù)據(jù)(){ try{ FileReader fr = new FileReader(filename); BufferedReader bfr = new BufferedReader(fr); String buff = bfr.readLine(); if(buff!= null){ total = Integer.parseInt(buff); }else{ total = 0; } StuInfo stu; for(int i=0;i stu = new StuInfo(); stu.setNumber(Integer.parseInt(bfr.readLine())); stu.setName(bfr.readLine()); stu.setSex(bfr.readLine()); stu.setAge(bfr.readLine()); stu.setBir(bfr.readLine()); stu.setEmail(bfr.readLine()); stu.setAddr(bfr.readLine()); stu.setTel(bfr.readLine()); stuInfos[i]=stu; } buff = bfr.readLine(); if(buff!= null){ rt = Integer.parseInt(buff); }else{ rt = 0; } for(int i=0;i stu = new StuInfo();stu.setNumber(Integer.parseInt(bfr.readLine()));stu.setName(bfr.readLine());stu.setSex(bfr.readLine());stu.setAge(bfr.readLine());stu.setBir(bfr.readLine());stu.setEmail(bfr.readLine());stu.setAddr(bfr.readLine());stu.setTel(bfr.readLine()); //補(bǔ)全 } recycle[i]=stu; } // bfr.flush(); bfr.close(); fr.close(); System.out.println(“讀取成功”);}catch(Exception e){ out.print(e);} public void 顯示學(xué)生(StuInfo[] stus,int length){ try{ out.println(“----------”);for(int i=0;i out.println(“學(xué)號：”+stus[i].getNumber()); out.println(“姓名：”+stus[i].getName()); out.println(“性別：”+stus[i].getSex()); out.println(“年齡：”+stus[i].getAge()); out.println(“生日：”+stus[i].getBir()); out.println(“郵箱：”+stus[i].getEmail()); out.println(“地址：”+stus[i].getAddr()); out.println(“電話：”+stus[i].getTel());//輸出其他內(nèi)容.....out.println(“----------”); } System.out.println(“請按任意鍵繼續(xù)”); buf.read();// } }catch(Exception e){ out.print(e);} public void 姓名查詢(String name){ StuInfo[] result = new StuInfo[11];int r = 0;for(int i=0;i if(stuInfos[i].getName().equals(name)){ result[r]=stuInfos[i]; r++; } } if(r==0){ System.out.print(“查找不到該學(xué)生！”);//提示找不到學(xué)生 return;}else{ 顯示學(xué)生(result, r);} } public void 學(xué)號查詢(String number){ StuInfo[] result = new StuInfo[11];int r = 0;for(int i=0;i if(Integer.toString(stuInfos[i].getNumber()).equals(number)){ result[r]=stuInfos[i]; r++;//補(bǔ)全 } } if(r==0){ System.out.print(“查找不到該學(xué)生！”);//提示找不到學(xué)生 }else{ 顯示學(xué)生(result, r);} } public void 查找菜單(){//全字匹配 int choice;try{ do{ System.out.println(“查找界面”);// System.out.println(“1：按姓名查詢”); System.out.println(“2：按學(xué)號查詢”); System.out.println(“0：返回上級”); BufferedReader buf = new BufferedReader(new InputStreamReader(System.in)); choice = Integer.parseInt(buf.readLine()); switch(choice){ case 1: System.out.println(“請輸入姓名”);//獲得輸入的姓名 String name = buf.readLine(); 姓名查詢(name);break;case 2: System.out.println(“請輸入學(xué)號”);String number = buf.readLine();學(xué)號查詢(number);//獲得輸入的學(xué)號 break; default: System.out.println(“對不起，出現(xiàn)異常！”); //異常：7 } }while(choice!=0); }catch(Exception e){ out.print(e); } } public boolean 修改學(xué)生(int number){ boolean flag = false; try{ for(int i=0;i if(stuInfos[i].getNumber()==number){ BufferedReader buf = new BufferedReader(new InputStreamReader(System.in)); StuInfo stu = new StuInfo(); System.out.print(“n請輸入學(xué)生信息n”); System.out.print(“姓名：nn”); stu.setName(buf.readLine()); System.out.print(“性別：nn”); stu.setSex(buf.readLine()); System.out.print(“年齡：nn”); stu.setAge(buf.readLine()); System.out.print(“生日：nn”); stu.setBir(buf.readLine()); System.out.print(“郵箱：nn”); stu.setEmail(buf.readLine()); break; } } }catch(Exception e){ out.print(e); } return flag;} System.out.print(“地址：nn”);stu.setAddr(buf.readLine()); System.out.print(“電話：nn”);stu.setTel(buf.readLine());stu.setNumber(number);stuInfos[i]=stu; System.out.print(“修改完成啦！”);//提示修改完成 public boolean 刪除學(xué)生(int number){ boolean flag = false; } for(int i=0;i if(rt==0){ recycle = new StuInfo[101]; } recycle[rt]=stuInfos[i]; for(;i stuInfos[i]=stuInfos[i+1]; } total--; flag=true; break;} } return flag; public void 刪除頁面(){ System.out.print(“刪除頁面”);//請輸入要刪除的學(xué)號 try{ int choice; BufferedReader buf = new BufferedReader(new InputStreamReader(System.in)); System.out.println(“1：學(xué)生信息修改”); System.out.println(“2：學(xué)生信息刪除”); System.out.println(“請輸入您的選擇（1--2）”); //...choice = Integer.parseInt(buf.readLine()); switch(choice){ case 1: System.out.println(“請輸入要修改的學(xué)號：”);choice = Integer.parseInt(buf.readLine()); 修改學(xué)生(choice); break;case 2: System.out.println(“請輸入要刪除的學(xué)號：”);choice = Integer.parseInt(buf.readLine()); 刪除學(xué)生(choice);break;//補(bǔ)充 } /*if(刪除學(xué)生(choice)){ System.out.print(“刪除成功！”);//刪除成功 }else{ System.out.print(“刪除失??！”);//刪除失敗 }*/ }catch(Exception e){ out.print(e);} } public void showMenu(){ try{ int choice; do{ System.out.println(“學(xué)生管理系統(tǒng)主菜單界面”); System.out.println(“1：學(xué)生信息錄入”); System.out.println(“2：學(xué)生信息瀏覽”); System.out.println(“3：學(xué)生信息查詢”); System.out.println(“4：學(xué)生修改與刪除”); System.out.println(“5：學(xué)生信息保存”); System.out.println(“6：學(xué)生信息讀取”); System.out.println(“0：退出系統(tǒng)”); System.out.println(“請輸入您的選擇（0--6）”); BufferedReader buf = new BufferedReader(new InputStreamReader(System.in)); choice = Integer.parseInt(buf.readLine()); switch(choice){ case 1: 信息錄入();// break; case 2: //補(bǔ)全方法調(diào)用 顯示學(xué)生(stuInfos, total); break; case 3: 查找菜單(); break; case 4: 刪除頁面(); break; case 5: 保存數(shù)據(jù)(); break; case 6: 讀取數(shù)據(jù)(); break; default: System.out.print(“出現(xiàn)異常！”); } }while(choice!=0); }catch(Exception e){ System.out.println(e); } // TODO 自動生成的方法存根 } public static void main(String[] args){ Student student = new Student(); student.showMenu(); } } //異常：7 #include intnum; /*定義一個職工信息的結(jié)構(gòu)體*/ char name[20]; /*定義一個職工信息的結(jié)構(gòu)體*/ char sex[10]; //用字符串存放職工的性別數(shù)據(jù) char birth[20];//用字符串存放職工的出生年月數(shù)據(jù) char deta[20];//用字符串存放職工的工作年月數(shù)據(jù) char education[20];//用字符串存放職工的學(xué)歷數(shù)據(jù) double salary; //用字符串存放職工的性別數(shù)據(jù) char work[30];//用字符串存放職工的職務(wù)數(shù)據(jù) char addr[20];//用字符串存放職工的地址數(shù)據(jù) char tel[20];//用字符串存放職工的電話數(shù)據(jù) }worker[100];//用結(jié)構(gòu)體數(shù)組存放職工的所有信息 void menu(); void input(); void save(); void read(); void display(); void add(); void search(); voidsearch_education(); voidsearch_num(); void del(); void modify(); void main() { char s; system(“color 3f”); printf(“nn”); printf(“ t┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓n”); printf(“ t┃**********************************************************┃n”); printf(“ t┃***┏━━━━━━━━━━━━━━━━━━━━━━━━┓***┃n”); printf(“ t┃***┃************************************************┃***┃n”); printf(“ t┃***┃*** ****┃***┃n”); printf(“ t┃***┃*** 歡迎使用職工信息管理系統(tǒng) ****┃***┃n”); printf(“ t┃***┃*** ****┃***┃n”); printf(“ t┃***┃*** ****┃***┃n”); printf(“ t┃***┃*** 制作人吳青伶 ****┃***┃n”); printf(“ t┃***┃*** ****┃***┃n”); printf(“ t┃***┃*** 2013.12.28 ****┃***┃n”); printf(“ t┃***┃*** ****┃***┃n”); printf(“ t┃***┃************************************************┃***┃n”); printf(“ t┃***┗━━━━━━━━━━━━━━━━━━━━━━━━┛***┃n”); printf(“ t┃**********************************************************┃n”);printf(“ t┗━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┛n”);do { menu();printf(“Do you want to continue?(y/n)”); s=getchar();}while(s=='Y'||s=='y');} void menu()/*菜單函數(shù)*/ { int b;printf(“t n”);printf(“t n”);printf(“t n”);printf(“t n”);printf(“t n”);printf(“t 請選擇 n”);printf(“t ------------------------------n”);printf(“t || || n”);printf(“t || 1.職工信息錄入 || n”);printf(“t || 2.職工信息瀏覽 || n”);printf(“t || 3.職工信息添加 || n”);printf(“t || 4.職工信息查詢 || n”);printf(“t || 5.職工信息刪除 || n”);printf(“t || 6.職工信息修改 || n”);printf(“t || 0.退出 || n”);printf(“tn”);printf(“n 輸入你的選擇項(0~6):n”); scanf(“%d”,&b); switch(b) { case 1 : //職工信息錄入、保存 input(); save(); getchar(); break; case 2 ://讀入職工信息并顯示 read(); display(); getchar();break; case 3 : //添加職工信息 add();getchar();break; case 4 : //查詢職工信息 search();getchar();break; case 5 : //讀入職工信息并實現(xiàn)職工信息刪除功能 read(); del(); getchar(); break; case 6 : //讀入職工信息并修改職工信息 read();modify();getchar();break; case 0 : exit(0);//退出 default:break;} } void input() //錄入職工信息 { inti,flag,j;printf(“輸入職工個數(shù)(默認(rèn)個數(shù)為2)：”);scanf(“%d”,&N);fflush(stdin);//清除緩存 for(i=0;i { loop: printf(“職工號:”);scanf(“%d”,&worker[i].num);fflush(stdin);flag=1;if(worker[N].num<0) printf(“請輸入正整數(shù)：n”);else for(j=0;j { if(worker[i].num==worker[j].num) { flag=0; printf(“ 工號重復(fù)，請重新輸入!n”); goto loop; } } printf(“姓名:”);scanf(“%s”,worker[i].name);fflush(stdin);printf(“性別:”);scanf(“ %s”,worker[i].sex);fflush(stdin);printf(“出生年月:”);scanf(“%d”,&worker[i].birth);fflush(stdin);printf(“工作年月:”);scanf(“%lf”,&worker[i].deta);fflush(stdin);printf(“請輸入學(xué)歷(中專=zz，大專＝dz，本科＝bk，研究生＝y(tǒng)js):n”);scanf(“%s”,worker[i].education);fflush(stdin);printf(“工資:”);scanf(“%lf”,worker[i].salary);fflush(stdin);printf(“職務(wù):”);scanf(“%s”,worker[i].work);fflush(stdin);printf(“住址:”);scanf(“%s”,worker[i].addr);fflush(stdin);printf(“電話:”);scanf(“%s”,worker[i].tel);fflush(stdin); } printf(“n創(chuàng)建完畢!n”);} void save() //保存函數(shù) { FILE *fp;int i; if((fp=fopen(“worker.txt”,“wb”))==NULL)//以只寫方式打開一個二進(jìn)制文件 { printf(“ncannot open filen”); exit(0);} for(i=0;i void read() //讀入函數(shù) { FILE *fp;int i=0; if((fp=fopen(“worker.txt”,“rb”))==NULL)//以只讀方式為輸出打開磁盤文件中的一個二進(jìn)制文件 { printf(“ncannot open filen”); exit(0);} do{ fread(&worker[i],sizeof(struct worker),1,fp);//從worker.txt文件向內(nèi)存讀入數(shù)據(jù)（二進(jìn)制） i++;}while(!feof(fp));fclose(fp); N=i-1;} void display() //信息瀏覽函數(shù) { int i;for(i=0;i { printf(“職工號:%dn”,worker[i].num);printf(“姓名:%sn”,worker[i].name);printf(“性別:%sn”,worker[i].sex);printf(“出生年月:%dn”,worker[i].birth);printf(“工作年月:%dn”,worker[i].deta);printf(“學(xué)歷:%sn”,worker[i].education);printf(“工資:%lfn”,worker[i].salary);printf(“職務(wù):%dn”,worker[i].work);printf(“住址:%sn”,worker[i].addr);printf(“電話:%sn”,worker[i].tel); } } void add() //添加函數(shù) { FILE *fp;int i;struct worker p;double t;printf(“n請輸入新增加職工的信息:n”); printf(“請輸入職工號:n”); scanf(“%d”,&p.num); for(i=0;i { while(worker[i].num==p.num) { printf(“ 工號重復(fù)，請重新輸入!n”); scanf(“%d”,&p.num); } } printf(“請輸入姓名:n”);scanf(“%s”,p.name);printf(“請輸入性別:n”);scanf(“%s”,p.sex);printf(“請輸入出生年月:n”);scanf(“%d”,&p.birth);printf(“請輸入工作年月:n”);scanf(“%d”,&p.deta);printf(“請輸入學(xué)歷(中專=zz，大專=dz，本科=bk，=yjs：):n”);scanf(“%s”,p.education);printf(“請輸入工資:n”);scanf(“%lf”,&t);p.salary=t;printf(“請輸入職務(wù):n”);scanf(“%s”,p.work);printf(“請輸入住址:n”);scanf(“%s”,p.addr);printf(“請輸入電話:n”);scanf(“%s”,p.tel);printf(“n添加完畢!n”); if((fp=fopen(“worker.txt”,“ab”))==NULL)//以追加方式打開一個二進(jìn)制文件尾部 { printf(“ncannot open filen”);exit(0); } fwrite(&p,sizeof(struct worker),1,fp);fclose(fp);} void search() //查詢函數(shù) { int c;do { puts(“nsearch by=>n1.學(xué)歷2.職工號3.取消并返回”);printf(“Which you needed?:n”);scanf(“%d”,&c); 研究生if(c>3||c<1) { puts(“nchoiceerror!please again!”);getchar();//此語句用于接受在執(zhí)行上一句時最后輸出的回車符 } } while(c>3||c<1); { switch(c) { case 1:search_education();break;case 2:search_num();break;case 3:menu();break; } } } void search_education() //按學(xué)歷查詢函數(shù) { inti,flag=0;char s[10];printf(“n請輸入你要查詢的學(xué)歷:n”);scanf(“%s”,s);for(i=0;i { if(strcmp(s,worker[i].education)==0) { printf(“職工號:%dn”,worker[i].num); printf(“姓名:%sn”,worker[i].name); printf(“性別:%sn”,worker[i].sex); printf(“出生年月:%dn”,worker[i].birth); printf(“工作年月:%dn”,worker[i].deta); printf(“學(xué)歷(中專=zz，大專＝dz，yjs):%sn”,worker[i].education);printf(“工資:%lfn”,worker[i].salary);printf(“職務(wù):%lfn”,worker[i].work); printf(“住址:%sn”,worker[i].addr); printf(“電話:%sn”,worker[i].tel);flag++; } } if(flag==0) printf(“n對不起沒有找到!n”);getchar();} void search_num() //按工號查詢函數(shù) { inti,s,flag=0;printf(“n輸入要查詢的職工號!:n”);scanf(“%d”,&s); 本科＝bk，研究生＝for(i=0;i { if(s==worker[i].num) { printf(“職工號:%dn”,worker[i].num); printf(“姓名:%sn”,worker[i].name); printf(“性別:%sn”,worker[i].sex); printf(“出生年月:%dn”,worker[i].birth); printf(“工作年月:%dn”,worker[i].deta); printf(“學(xué)歷(中專=zz，大專＝dz，本科＝bk，研究生＝y(tǒng)js):%sn”,worker[i].education); printf(“工資:%lfn”,worker[i].salary);printf(“職務(wù):%lfn”,worker[i].work); printf(“住址:%sn”,worker[i].addr); printf(“電話:%sn”,worker[i].tel); flag++; } } if(flag==0)printf(“n對不起沒有找到!please”); getchar();} void del() //刪除函數(shù) { inti,j;FILE *fp;char name[20];char c;if((fp=fopen(“worker.txt”,“wb”))==NULL)//以只寫方式打開一個二進(jìn)制文件 { printf(“ncannot open filen”);exit(0); } printf(“請輸入要刪除的職工的姓名:”);scanf(“%s”,name);for(i=0;i if(strcmp(name,worker[i].name)==0)//判斷輸入的姓名和原來的姓名是否相同 { printf(“找到該職工,是否刪除?(y/n)”); fflush(stdin); scanf(“%c”,&c); if(c =='Y'||c=='y') { for(j=i;j worker[j]=worker[j+1]; printf(“刪除成功!n”); //break; } } } if(i>=N){ printf(“沒有找到該職工!n ”); return;} else { N=N-1; for(i=0;i if(fwrite(&worker[i],sizeof(struct worker),1,fp)!=1) { printf(“ncannot save filen”);getchar(); } fclose(fp);} } void modify() //修改函數(shù) { struct worker p;FILE *fp;inti,n;double t;printf(“n輸入要修改的職工號:n”);scanf(“%d”,&n); for(i=0;i if(n==worker[i].num) { printf(“找到該職工的信息(任意鍵繼續(xù))！”); printf(“n請輸入職工的信息！n”); printf(“請輸入姓名:n”);scanf(“%s”,p.name); printf(“請輸入性別:n”);scanf(“%s”,p.sex); printf(“請輸入出身年月:n”);scanf(“%d”,&p.birth);printf(“請輸入工作年月:n”);scanf(“%lf”,&p.deta); printf(“請輸入學(xué)歷(中專=zz，大專＝dz，yjs):n”);scanf(“%s”,p.education);printf(“請輸入工資:n”);scanf(“%lf”,&t); p.salary=t;printf(“請輸入職務(wù):n”);scanf(“%s”,p.work); printf(“請輸入住址:n”);scanf(“%s”,p.addr); 本科＝bk，研究生＝ } printf(“請輸入電話:n”);scanf(“%s”,p.tel);p.num=n; if((fp=fopen(“worker.txt”,“r+”))==NULL)//以讀寫的方式將修改的信息寫入磁盤文件 { printf(“ncannot open filen”); exit(0); } fseek(fp,i*sizeof(struct worker),0);//將位置指針移到i*sizeof(struct worker)個字節(jié)處 fwrite(&p,sizeof(struct worker),1,fp); fclose(fp); printf(“修改成功!n”); break;} } if(i>=N)printf(“n未找到該職工!n”); VB學(xué)生信息管理系統(tǒng)及源代碼 Option Explicit '標(biāo)識是否能關(guān)閉 Dim mbClose As Boolean '標(biāo)識當(dāng)前要顯示的照片的文件 Dim mstrFileName As String Private Sub Form_Load() On Error Resume Next If frmMain.mnUserType = 1 Then '學(xué)生用戶 fraSeek.Enabled = False fraBrowse.Enabled = False cmdAdd.Enabled = False cmdDelete.Enabled = False txtSerial.Enabled = False dcbClass.Enabled = False grdScan.Enabled = False If Not(DataEnv.rsStudent.EOF And DataEnv.rsStudent.BOF)Then Dim Temp As String Temp = “name = ” & “'” & frmMain.msUserName & “'” DataEnv.rsStudent.MoveFirst DataEnv.rsStudent.Find Temp '刷新所綁定的控件 Call RefreshBinding End If Exit Sub Else fraSeek.Enabled = True fraBrowse.Enabled = True cmdAdd.Enabled = True cmdDelete.Enabled = True txtSerial.Enabled = True dcbClass.Enabled = True grdScan.Enabled = True End If Dim rsDep As New ADODB.Recordset, rsClass As New ADODB.Recordset Set rsDep = DataEnv.rsDepartment Set rsClass = DataEnv.rsClass rsDep.Open '從Department表中讀取數(shù)據(jù)，填充cboDep組合框到中 cboDep.Clear cboDep.AddItem “全部” '將各個系的id號作為ItemData附加到組合框中 cboDep.ItemData(0)= 0 While Not rsDep.EOF cboDep.AddItem rsDep(“Name”) cboDep.ItemData(cboDep.ListCount1) ChunkAry = blobColumn.GetChunk(Fragment) Put FileNumber, , ChunkAry '寫入文件 End If ReDim ChunkAry(ChunkSize-1) '為數(shù)據(jù)塊重新開辟空間 For lngI = 1 To Chunks '循環(huán)讀出所有塊 ChunkAry = blobColumn.GetChunk(ChunkSize) '在數(shù)據(jù)庫中連續(xù)讀數(shù)據(jù)塊 Put FileNumber, , ChunkAry() '將數(shù)據(jù)塊寫入文件中 Next lngI Close FileNumber ReadImage = strFileName Exit Function errHander: ReadImage = “" End Function Private Sub imgPhoto_Click()End '關(guān)閉文件 Sub Option Explicit '表示當(dāng)前的用戶類型：0---管理員類型的用戶;1---學(xué)生類型的用戶 Public mnUserType As Integer '表示當(dāng)前登錄的用戶名 Public msUserName As String Private Sub MDIForm_Load() '根據(jù)不同的用戶類型，使相應(yīng)的菜單項可見 Select Case mnUserType Case 0: '以管理員身份登錄 mnuFind.Visible = True tlbMain.Buttons.Item(3).Visible = True tlbMain.Buttons.Item(4).Visible = True Exit Sub Case 1: '以學(xué)生身份登錄，只能查詢自己的信息 mnuFind.Visible = False '“信息查詢”菜單不可見 tlbMain.Buttons.Item(3).Visible = False '“信息查詢”按鈕不可見 tlbMain.Buttons.Item(4).Visible = False '第二個分隔條不可見 Exit Sub End Select End Sub Private Sub MDIForm_QueryUnload(Cancel As Integer, UnloadMode As Integer) If MsgBox(”真的要對出本系統(tǒng)嗎？“, vbQuestion + vbYesNo + vbDefaultButton2, ”退出“)= vbNo Then Cancel = 1 End If End Sub Private Sub mnuAbout_Click() Load frmSplash frmSplash.mbAbout = True frmSplash.Show vbModal End Sub Private Sub mnuArr_Click() frmMain.Arrange(3) '設(shè)置主窗體中所有最小化MDI子窗體圖標(biāo)重排 End Sub Private Sub mnuCas_Click() frmMain.Arrange(0) '設(shè)置主窗體中所有非最小化MDI子窗體層疊顯示 End Sub Private Sub mnuExit_Click() Unload Me End Sub Private Sub mnuFind_Click() frmFind.Show End Sub Private Sub mnuHori_Click() frmMain.Arrange(1) '設(shè)置主窗體中所有非最小化MDI子窗體水平平鋪 End Sub Private Sub mnuLog_Click() If MsgBox(”若重新登錄，所有窗體都將關(guān)閉！“ & vbCrLf & ” 是否重新登錄？“, _ vbQuestion + vbYesNo + vbDefaultButton2, ”重新登錄“)= vbYes Then Unload Me frmLogin.Show End If End Sub Private Sub mnuStudent_Click() Load frmStudent frmStudent.Show End Sub Private Sub mnuVer_Click() frmMain.Arrange(2) '設(shè)置主窗體中所有非最小化MDI子窗體垂直平鋪 End Sub Private Sub tlbMain_ButtonClick(ByVal Button As MSComctlLib.Button) Select Case Button.Key Case ”Student“ mnuStudent_Click Exit Sub Case ”Find“ mnuFind_Click Exit Sub Case ”Login“ mnuLog_Click Exit Sub Case ”Exit“ mnuExit_Click Exit Sub End Select End SubOption Explicit '表示當(dāng)前用戶登錄所選擇的身份，即用戶類型, 0-表示教務(wù)管理人員；1-表示學(xué)生 Dim mnUserType As Integer Private Sub cmdCancel_Click() Unload Me End Sub Private Sub cmdOK_Click() '取得用戶輸入的用戶名和密碼 Dim user As String, pwd As String user = Trim(txtUser) pwd = Trim(txtPwd) '根據(jù)不同的身份，選擇不同的表用以查詢 Dim r As New ADODB.Recordset Set r = DataEnv.rssqlSeek Dim strSQL As String Select Case mnUserType Case 0: '若身份為管理員 strSQL = ”select * from 系統(tǒng)人員表 where name='“ & user & ”' and pwd='“ & pwd & ”'“ Case 1: '若身份為學(xué)生 strSQL = ”select * from 學(xué)生信息表 where name='“ & user & ”' and serial='“ & pwd & ”'“ End Select On Error Resume Next '查詢DataEnv.rssqlSeek的狀態(tài)，如果已經(jīng)打開，則先關(guān)閉 If r.State = adStateOpen Then r.Close r.Open strSQL '根據(jù)strSQL的內(nèi)容刷新DataEnv.rssqlSeek '用戶密碼錯誤的次數(shù)，如果錯誤次數(shù)超過3次，則退出系統(tǒng) Static nTryCount As Integer If r.EOF Then '登錄失敗 MsgBox ”對不起，無此用戶或者密碼不正確！請重新輸入！“, vbCritical, ”錯誤“ txtUser.SetFocus txtUser.SelStart = 0 txtUser.SelLength = Len(txtUser) nTryCount = nTryCount + 1 If nTryCount >= 3 Then MsgBox ”您無權(quán)操作本系統(tǒng)！“, vbCritical, ”錯誤“ Unload Me End If Else '登陸成功 '顯示MDI窗體, 并將用戶類型和用戶名傳到MDI窗體中的mnUserType, msUserName中 With frmMain .mnUserType = mnUserType .msUserName = user End With Load frmMain frmMain.Show Unload Me End If End Sub Private Sub Form_Load() optUserType(0).Value = True End Sub Private Sub optUserType_Click(Index As Integer) mnUserType = Index End Sub Explicit Private Sub Command1_Click() Dim strCon1 As String Dim strCon2 As String On Error GoTo myerr If Trim(Text1.Text)= ”“ Or Trim(Text2.Text)= ”“ Then If MsgBox(”請輸入查詢條件！“, vbInformation, ”提示“)Then GoTo myerr End If Select Case Trim(Combo1.Text) Case ”學(xué)號“ strCon1 = ”Serial“ Case ”姓名“ strCon1 = ”Name“ Case ”班級“ strCon1 = ”Class“ Option Case ”生日“ strCon1 = ”Birthday“ Case ”性別“ strCon1 = ”Sex“ Case ”家庭地址“ strCon1 = ”Address“ Case ”電話“ strCon1 = ”Tel“ End Select Select Case Trim(Combo4.Text) Case ”學(xué)號“ strCon2 = ”Serial“ Case ”姓名“ strCon2 = ”Name“ Case ”班級“ strCon2 = ”Class“ Case ”生日“ strCon2 = ”Birthday“ Case ”性別“ strCon2 = ”Sex“ Case ”家庭地址“ strCon1 = ”Address“ Case ”電話“ strCon2 = ”Tel“ End Select DataEnv.rsStudent.Close DataEnv.rsStudent.Open ”select * from 學(xué)生信息表 where “ & _ strCon1 & Trim(Combo2.Text)& ” '“ & Trim(Text1.Text)_ & ”'“ & ” “ & Trim(Combo3.Text)& ” “ & strCon2 & _ Trim(Combo5.Text)& ”'“ & Trim(Text2.Text)& ”'“ dgdCX.DataMember = ”“ dgdCX.Refresh DataEnv.rsStudent.Requery dgdCX.DataMember = ”Student“ dgdCX.Refresh myerr: End Sub Private Sub Command3_Click() Unload Me End Sub Private Sub dgdCX_Click() End Sub Private Sub Form_Load() '添加Combo1的子項作為查詢標(biāo)準(zhǔn) Combo1.AddItem(”學(xué)號“) Combo1.AddItem(”姓名“) Combo1.AddItem(”班級“) Combo1.AddItem(”生日“) Combo1.AddItem(”性別“) Combo1.AddItem(”家庭地址“) Combo1.AddItem(”電話“) Combo1.ListIndex = 0 '添加Combo2的子項作為關(guān)系符 Combo2.AddItem(”=“) Combo2.AddItem(”>“) Combo2.AddItem(”>=“) Combo2.AddItem(”<“) Combo2.AddItem(”<=“) Combo2.AddItem(”<>“) Combo2.ListIndex = 0 '添加Combo3的子項作為邏輯連接符 Combo3.AddItem(”And“) Combo3.AddItem(”O(jiān)r“) Combo3.ListIndex = 0 '添加Combo4的子項作為第二種查詢標(biāo)準(zhǔn) Combo4.AddItem(”學(xué)號“) Combo4.AddItem(”姓名“) Combo4.AddItem(”班級“) Combo4.AddItem(”生日“) Combo4.AddItem(”性別“) Combo4.AddItem(”家庭地址“) Combo4.AddItem(”電話“) Combo4.ListIndex = 0 '添加Combo5的子項作為第二種關(guān)系符 Combo5.AddItem(”=“) Combo5.AddItem(”>“) Combo5.AddItem(”>=“) Combo5.AddItem(”<“) Combo5.AddItem(”<=“) Combo5.AddItem(”<>") Combo5.ListIndex = 0 End Sub Private Sub Form_Unload(Cancel As Integer) frmMain.Enabled = True frmMain.Show End Sub 教職工信息管理系統(tǒng)源碼 #include #define maxsize 100 fstream iofile;//文件指針 class Time //時間類 { public: int year; int month; int day;}; class Telem //個人信息 { public: char name[20]; char sex[10]; Time birthtime;//組合Time類 char num[20]; char wage[20]; Time worktime; int year; char department[20]; friend istream& operator>>(istream& input,Telem& T); friend ostream& operator<<(ostream& output,Telem& T); friend int operator-(Time & t1,Time & t2);}; class People:virtual public Telem //雇員類 { public: People(); virtual void AddF()=0;//添加 virtual void Addall()=0; virtual void Add()=0; virtual void Display();//輸出數(shù)組的內(nèi)容 virtual void Displaypart(char p[]); virtual void Findname(char n[]); virtual void Findyear(int); virtual void Del(char n[])=0; virtual void Del(int);protected: Telem data[maxsize]; Time now; int length;}; class Teacher:virtual public People //派生虛基類 { public: virtual void AddF(); virtual void Addall(); virtual void Add(); virtual void Display(); virtual void Del(int i); virtual void Del(char n[]);}; class worker:virtual public People //派生虛基類 { public: virtual void AddF(); virtual void Addall(); virtual void Add(); virtual void Display(); virtual void Del(int i); virtual void Del(char n[]);}; People::People()//系統(tǒng)自動生成的構(gòu)造函數(shù) { length=0; now.year=2010; now.month=7; now.day=6;} void People::Display()//引用 { int i; for(i=0;i cout< void People::Displaypart(char p[])//引用數(shù)組 { int i,c; for(i=0;i if(strcmp(data[i].wage,p)==0) { cout<<“輸出選擇姓名1 性別2 編號3 工資4 出生日期5 工作時間6 年齡7 系別8 退出選擇9”< while(cin>>c) { switch(c) { case 1: cout<<“姓名:”< case 2: cout<<“性別:”< case 3: cout<<“編號:”< case 4: cout<<“工資:”< case 5: cout<<“出生日期:”< case 6: cout<<“工作時間:”< case 7: cout<<“年齡:”< case 8: cout<<“系別:”< case 9: goto loop; default:cout<<“操作錯誤......”< } } loop:; } } void People::Findname(char n[])//引用 { int i; for(i=0;i if(strcmp(data[i].name,n)==0)//對象引用 cout< void People::Findyear(int y){ int i; for(i=0;i if(data[i].year==y) cout< void People::Del(int i){ int j; if(i<1||i>length) cout<<“不存在第”< for(j=i;j data[j-1]=data[j]; length--;} void worker::AddF(){ int flag=0; iofile.open(“worker_information.txt”,ios::in|ios::binary);//文件的打開與關(guān)閉 while(iofile.seekg(ios::cur)) { iofile.seekg(length*sizeof(data[length]),ios::beg); iofile.read((char*)&data[length],sizeof(data[length]));//文件的隨機(jī)訪問 length++; if(length==maxsize) { flag=1; goto loop; } } People::Del(length); cout<<“添加人員信息成功......”< loop: if(1==flag) cout<<“人員信息儲存空間已滿......”< iofile.close();} void worker::Addall(){ char ans; int flag=0; iofile.open(“worker_information.txt”,ios::out|ios::binary); do { cin>>data[length]; data[length].year=now-data[length].birthtime; iofile.write((char*)&data[length],sizeof(data[length])); cout<<“添加人員信息成功......”< length++; if(length==maxsize) { flag=1; goto loop; } cout<<“contine(Y|N)?”; cin>>ans; }while('y'==ans||'Y'==ans);loop: if(1==flag) cout<<“人員信息儲存空間已滿......”< iofile.close();} void worker::Add(){ int flag=0; iofile.open(“worker_information.txt”,ios::app|ios::out|ios::binary); if(length==maxsize) { flag=1; goto loop; } cin>>data[length]; data[length].year=now-data[length].birthtime; iofile.write((char*)&data[length],sizeof(data[length])); cout<<“添加人員信息成功......”< length++; loop: if(1==flag) cout<<“人員信息儲存空間已滿......”< iofile.close();} void worker::Display(){ cout<<“ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆工人信息 ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆”< if(0==length) cout<<“無......”< int i; for(i=0;i cout< int i,j,k; for(i=0;i if(strcmp(data[i].name,n)==0){ k=i+1;break;} if(k<1) cout<<“不存在姓名”< for(j=k;j data[j-1]=data[j]; length--; cout<<“刪除人員信息成功......”< void worker::Del(int i){ int j; if(i<1||i>length) cout<<“不存在第”< for(j=i;j data[j-1]=data[j]; length--; cout<<“刪除成功......”< } void Teacher::AddF(){ int flag=0; iofile.open(“Teacher_information.txt”,ios::in|ios::binary); while(iofile.seekg(sizeof(data[length]),ios::cur)) { if(iofile.seekg(length*sizeof(data[length]),ios::beg)) iofile.read((char*)&data[length],sizeof(data[length])); else break; length++; if(length==maxsize) { flag=1; goto loop; } } People::Del(length); cout<<“添加人員信息成功......”< if(1==flag) cout<<“人員信息儲存空間已滿......”< iofile.close();} void Teacher::Addall(){ char ans; int flag=0; iofile.open(“Teacher_information.txt”,ios::in|ios::out|ios::binary); do { cin>>data[length]; data[length].year=now-data[length].birthtime; iofile.write((char*)&data[length],sizeof(data[length])); cout<<“添加人員信息成功......”< length++; if(length==maxsize) { flag=1; goto loop; } cout<<“contine(Y|N)?”; cin>>ans; }while('y'==ans||'Y'==ans);loop: if(1==flag) cout<<“人員信息儲存空間已滿......”< iofile.close();} void Teacher::Add(){ int flag=0; iofile.open(“Teacher_information.txt”,ios::app|ios::out|ios::binary); if(length==maxsize) { flag=1; goto loop; } cin>>data[length]; data[length].year=now-data[length].birthtime; iofile.write((char*)&data[length],sizeof(data[length])); cout<<“添加人員信息成功......”< length++;loop: if(1==flag) cout<<“人員信息儲存空間已滿......”< iofile.close();} void Teacher::Display(){ cout<<“ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆教師信息 ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆”< if(0==length) cout<<“無......”< int i; for(i=0;i cout< void Teacher::Del(char n[]){ int i,j,k; for(i=0;i if(strcmp(data[i].name,n)==0) { k=i+1;break; } if(k<1)cout<<“不存在姓名”< for(j=k;j data[j-1]=data[j]; length--; cout<<“刪除人員信息成功......”< void Teacher::Del(int i){ int j; if(i<1||i>length) cout<<“不存在第”< for(j=i;j data[j-1]=data[j]; length--; cout<<“刪除成功......”< istream& operator>>(istream& input,Telem& T){ int y,m,d; cout<<“請輸入姓名(以*結(jié)尾):”< input.getline(T.name,20,'*'); cout<<“請輸入性別(以*結(jié)尾 男或女):”< input.getline(T.sex,10,'*'); cout<<“編號(以*結(jié)尾):”< input.getline(T.num,20,'*'); cout<<“工資(以*結(jié)尾):”< input.getline(T.wage,20,'*'); cout<<“請輸入出生日期:”< input>>y>>m>>d; T.birthtime.year=(y>=1900&&y<=2100)?y:1900; T.birthtime.month=(m>=1&&m<=12)?m:1; T.birthtime.day=(d>=1&&d<=31)?d:1; cout<<“請輸入系別(以*結(jié)尾):”< input.getline(T.department,20,'*'); cout<<“參加工作時間:”< input>>y>>m>>d; T.worktime.year=(y>=1900&&y<=2100)?y:1900; T.worktime.month=(m>=1&&m<=12)?m:1; T.worktime.day=(d>=1&&d<=31)?d:1; return input;} ostream& operator<<(ostream& output,Telem& T){ cout<<“姓名：”; output< cout<<“性別：”; output< cout<<“編號：”; output< cout<<“工資：”; output< cout<<“出生日期：”; output< cout<<“系別：”; output< cout<<“參加工作時間:”; output< cout<<“年齡：”; output< return output;} int operator-(Time & t1,Time & t2){ return t1.year-t2.year;} void Showmenu(){ cout< cout<<“ 歡 迎 進(jìn) 入 教 職 工 信 息 管 理 系 統(tǒng)”< cout<<“ 2010 年7月7日發(fā)布”<<“ 版權(quán)所有： swa”< cout<<“ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★人員信息管理系統(tǒng)★ ☆ ★ ☆ ★ ☆ ★ ☆ ★”< cout<<“ ★ 1-從鍵盤錄入全部人員記錄 ☆ ”< cout<<“ ☆ 2-增加一位人員記錄 ★”< cout<<“ ★ 3-顯示全部人員記錄 ☆”< cout<<“ ☆ 4-按系別輸出人員信息（可選）★ ”< cout<<“ ★ 5-按姓名或年齡檢索所有信息☆ ”< cout<<“ ☆ 6-顯示菜單目錄 ★ ”< cout<<“ ★ 7-結(jié)束程序運行 ☆ ”< cout<<“ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆”< int main(){ Teacher tea; worker stu; People *pt=&tea; People *ps=&stu; int c=0,k=0,l=0,i=0; char nam[20],part[20];Showmenu(); for(;;) { cout<<“請根據(jù)菜單執(zhí)行相應(yīng)操作: ”; cin>>c; switch(c) { case 1: { cout<<“ ★ ☆ ★ ☆ ★ ☆ ★錄入全部人員記錄 ★ ☆ ★ ☆ ★ ☆ ★”< cout<<“ ★ ☆ ★ ☆ ★從鍵盤輸入教師信息 ☆ ★ ☆ ★ ☆”< pt->Addall(); cout<<“ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆從鍵盤輸入工人信息 ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆”< ps->Addall(); break; } case 2: { cout<<“ ★ ☆ ★ ☆ ★ ☆ ★ ☆從鍵盤增加一位人員記錄 ★ ☆ ★ ☆ ★ ☆ ★ ☆”< cout<<“ ★ ☆ ★ ☆ ★ ☆ ★ ☆教師操作請按1 工人操作請按2 ★ ☆ ★ ☆ ★ ☆ ★ ☆”< cin>>k; if(1==k) pt->Add(); else if(2==k) ps->Add(); else cout<<“操作錯誤...”< break; } case 3: { cout<<“ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆顯示全部人員記錄 ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆”< pt->Display(); ps->Display(); break; } case 4: { cout<<“ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆按部門輸出人員信息（可選）★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆”< cout<<“ ★ ☆ ★ ☆ ★ ☆教師操作請按1 工人操作請按2 ★ ☆ ★ ☆ ★ ☆”< cin>>k; if(1==k) { cout<<“請輸入要輸出人員的系別(以*結(jié)尾)：”< pt->Displaypart(part); } else if(2==k) { cout<<“請輸入要輸出人員的系別(以*結(jié)尾)：”< ps->Displaypart(part); } else cout<<“操作錯誤......”< break; } case 5: { cout<<“ ★ ☆ ★ ☆ ★ ☆ ★按姓名或年齡檢索所有信息 ★ ☆ ★ ☆ ★ ☆ ★”< cout<<“ ★ ☆ ★ ☆ ★ ☆ ★按姓名查找1 按年齡查找2 ★ ☆ ★ ☆ ★ ☆ ★”< cin>>k; if(1==k) { cout<<“按姓名查找1 按年齡查找2”< if(1==l) { cout<<“請輸入要查找人員的姓名(以*結(jié)尾)：”< pt->Findname(nam); } else if(2==l) { cout<<“請輸入要查找人的年齡：”< pt->Findyear(i); } else cout<<“操作錯誤......”< } else if(2==k) { cout<<“按姓名查找1 按年齡查找2”< if(1==l) { cout<<“請輸入要查找人員的姓名(以*結(jié)尾)：”< ps->Findname(nam); } else if(2==l) { cout<<“請輸入要查找人的年齡：”< ps->Findyear(i); } else cout<<“操作錯誤......”< } else cout<<“操作錯誤......”< break; } case 6: { cout<<“ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆顯示菜單目錄 ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆”< Showmenu(); break; } case 7: { cout<<“ ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆結(jié)束程序運行 ★ ☆ ★ ☆ ★ ☆ ★ ☆ ★ ☆”< exit(0); } default:cout<<“操作錯誤......”< } } return 0;}第二篇：職工信息管理系統(tǒng)源代碼
第三篇：VB學(xué)生信息管理系統(tǒng)及源代碼
第四篇：C++課程設(shè)計 教職工信息管理系統(tǒng)源代碼