java学生信息管理系统.docx
《java学生信息管理系统.docx》由会员分享,可在线阅读,更多相关《java学生信息管理系统.docx(29页珍藏版)》请在冰点文库上搜索。
![java学生信息管理系统.docx](https://file1.bingdoc.com/fileroot1/2023-6/8/50d8d467-e638-4632-a34b-0716b43cb52d/50d8d467-e638-4632-a34b-0716b43cb52d1.gif)
java学生信息管理系统
9、实验结果及测试:
图1主界面
通过6个选项可以实现:
对学生信息的添加,删除,修改,分页显示功能。
图2录入学生信息
图2显示了对学生信息的添加以及对异常的处理。
图3修改学生信息
图3是对学生信息的修改以及对异常的处理。
图4查找学生信息
图4是查找学生的信息:
分为按学号和姓名查找,以及对异常的处理。
图5显示学生信息
图5是对数据库里的全部学生信息的分页显示。
图6数据库stuinformation表结构
10、程序清单:
Student类:
packageimut.cstd.j09_2.shiyan2;
publicclassStudent{
privateintid;
privateStringstunumber;
privateStringstuname;
privateStringstusex;
privateStringstuclass;
privateStringstumajor;
privateStringstucollege;
publicStudent(){
id=0;stunumber=null;stuname=null;stusex=null;stuclass=null;stumajor=null;stucollege=null;
}
publicStudent(intid,Stringstunumber,Stringstuname,Stringstusex,Stringstuclass,Stringstumajor,Stringstucollege){
this.id=id;this.stunumber=stunumber;
this.stuname=stuname;
this.stusex=stusex;
this.stuclass=stuclass;
this.stucollege=stucollege;
}
publicintgetId(){
returnid;
}
publicStringgetStunumber(){
returnstunumber;
}
publicStringgetStuname(){
returnstuname;
}
publicStringgetStusex(){
returnstusex;
}
publicStringgetStuclass(){
returnstuclass;
}
publicStringgetStumajor(){
returnstumajor;
}
publicStringgetStucollege(){
returnstucollege;
}
publicvoidsetId(intid){
this.id=id;
}
publicvoidsetStunumber(Stringstunumber){
this.stunumber=stunumber;
}
publicvoidsetStuname(Stringstuname){
this.stuname=stuname;
}
publicvoidsetStusex(Stringstusex){
this.stusex=stusex;
}
publicvoidSetStuclass(Stringstuclass){
this.stuclass=stuclass;
}
publicvoidSetStumajor(Stringstumajor){
this.stumajor=stumajor;
}
publicvoidSetStucollege(Stringstucollege){
this.stucollege=stucollege;
}
publicbooleanequals(Objects){
if(s==null)returnfalse;
if(!
(sinstanceofStudent))returnfalse;
Studenttemp=(Student)s;
if((id==temp.id)&&(stunumber.equals(temp.stunumber))&&(stuname.equals(temp.stuname))&&(stusex.equals(temp.stusex))&&(stuclass.equals(temp.stuclass))&&(stumajor.equals(temp.stumajor))&&(stucollege.equals(temp.stumajor)))returntrue;
elsereturnfalse;
}
publicStringtoString(){
Stringtemp=null;
temp="ID号\t"+"学号\t"+"姓名\t"+"性别\t"+"班级\t"+"专业\t"+"学院\n"+getId()+"\t"+getStunumber()+""+getStuname()+"\t"+getStusex()+"\t"+getStuclass()+"\t"+getStumajor()+"\t"+getStucollege();
returntemp;
}
}
Keyboard类:
packageimut.cstd.j09_2.shiyan2;
importjava.io.*;
publicclassKeyboard{
publicstaticintInputMenu(){
intoption=0;
BufferedReaderin=newBufferedReader(newInputStreamReader(System.in));
try{
option=Integer.parseInt(in.readLine());
}catch(IOExceptione){
e.printStackTrace();
}catch(NumberFormatExceptione){
System.out.println("请输入正确的功能选项");
}
returnoption;
}
publicstaticStringInputString(){
BufferedReaderin=newBufferedReader(newInputStreamReader(System.in));
Stringtemp=null;
try{
temp=in.readLine();
}catch(IOExceptione){
e.getMessage();
}
returntemp;
}
publicstaticintInputInt(){
inttemp=0;
BufferedReaderin=newBufferedReader(newInputStreamReader(System.in));
try{
temp=Integer.parseInt(in.readLine());
}catch(IOExceptione){
e.printStackTrace();
}catch(NumberFormatExceptione){
System.out.println("请输入Id号");
}
returntemp;
}
}
MyException类:
packageimut.cstd.j09_2.shiyan2;
publicclassMyExceptionextendsException{
/**
*
*/
privatestaticfinallongserialVersionUID=1L;
Stringmessage;
publicMyException(StringErrMessage){
message=ErrMessage;
}
publicStringgetMessage(){
returnmessage;
}
}
SQLOperate类:
packageimut.cstd.j09_2.shiyan2;
importjava.sql.DriverManager;
importjava.sql.Connection;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.SQLException;
publicclassSQLOperate{
privatestaticStudents;
publicstaticConnectiongetconnect(){
StringDBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
StringDBURL="jdbc:
sqlserver:
//localhost:
1433;databaseName=stuinformation";
Connectioncon=null;
try{
Class.forName(DBDRIVER);
con=DriverManager.getConnection(DBURL,"sa","zty");
}catch(ClassNotFoundExceptione){
System.err.println("ClassNotFoundException:
"+e.getMessage());
System.exit
(1);
}catch(SQLExceptione){
System.err.println("SQLException:
"+e.getMessage());
}
returncon;
}
publicstaticvoidAddStuInfo(){
PreparedStatementsql=null;
Connectioncon=null;
s=newStudent();
con=getconnect();
booleanflag=false;
do{
System.out.println("请输入Id号:
");
s.setId(Keyboard.InputInt());
if(Check(s.getId())==true){
System.out.println("已有Id为"+s.getId()+"的学生,请重新输入!
");
flag=true;
}
elsebreak;
}while(flag);
do{
System.out.println("请输入学号:
");
s.setStunumber(Keyboard.InputString());
if(Check(s.getId())==true){
System.out.println("已有学号为"+s.getStunumber()+"的学生,请重新输入!
");
flag=true;
}
elsebreak;
}while(flag);
System.out.println("请输入姓名:
");
s.setStuname(Keyboard.InputString());
System.out.println("请输入性别:
");
s.setStusex(Keyboard.InputString());
System.out.println("请输入班级:
");
s.SetStuclass(Keyboard.InputString());
System.out.println("请输入专业:
");
s.SetStumajor(Keyboard.InputString());
System.out.println("请输入学院:
");
s.SetStucollege(Keyboard.InputString());
try{
sql=con.prepareStatement("insertintostuinfo"+"values(?
?
?
?
?
?
?
)");
sql.setInt(1,s.getId());
sql.setString(2,s.getStunumber());
sql.setString(3,s.getStuname());
sql.setString(4,s.getStusex());
sql.setString(5,s.getStuclass());
sql.setString(6,s.getStumajor());
sql.setString(7,s.getStucollege());
if(sql.executeUpdate()!
=1)
thrownewMyException("添加错误!
");
System.out.println("信息添加成功!
");
}catch(SQLExceptione){
System.out.println(e.getMessage());
}catch(MyExceptione){
System.out.println(e.getMessage());
}
Finally(sql,con);
System.out.println("你添加的学生信息是:
");
System.out.println(s);
}
publicstaticvoidNameSeekStuInfo(){
PreparedStatementsql=null;
Connectioncon=null;
ResultSetrs=null;
Stringname=null;
booleanflag=true;
try{
System.out.println("请输入要查找学生的姓名:
");
name=Keyboard.InputString();
if(Check(name)==false){
thrownewMyException("没有姓名是"+name+"的学生!
");
}
}catch(MyExceptione){
System.out.println(e.getMessage());
flag=false;
}
if(flag){
try{
con=getconnect();
sql=con.prepareStatement("select*fromstuinfowherestuname='"+name+"'");
rs=sql.executeQuery();
System.out.println("ID号\t"+"学号\t"+"姓名\t"+"性别\t"+"班级\t"+"专业\t"+"学院");
while(rs.next()){
System.out.print(rs.getInt("id")+"\t");
System.out.print(rs.getString("stunumber")+"");
System.out.print(rs.getString("stuname")+"");
System.out.print(rs.getString("stusex")+"\t");
System.out.print(rs.getString("stuclass"));
System.out.print(rs.getString("stumajor"));
System.out.println(rs.getString("stucollege"));
}
}catch(SQLExceptione){
System.err.println("SQLException"+e.getMessage());
}finally{
if(rs!
=null){
try{
rs.close();
}catch(SQLExceptione){}
}
Finally(sql,con);
}
}
}
publicstaticvoidNumberSeekStuInfo(){
PreparedStatementsql=null;
Connectioncon=null;
ResultSetrs=null;
Stringnumber=null;
booleanflag=true;
try{
System.out.println("请输入要查找学生的学号:
");
number=Keyboard.InputString();
if(Check(number)==false){
thrownewMyException("没有学号为"+number+"的学生!
");
}
}catch(MyExceptione){
System.out.println(e.getMessage());
flag=false;
}
if(flag){
try{
con=getconnect();
sql=con.prepareStatement("select*fromstuinfowherestunumber='"+number+"'");
rs=sql.executeQuery();
System.out.println("ID号\t"+"学号\t"+"姓名\t"+"性别\t"+"班级\t"+"专业\t"+"学院");
while(rs.next()){
System.out.print(rs.getInt("id")+"\t");
System.out.print(rs.getString("stunumber")+"");
System.out.print(rs.getString("stuname")+"");
System.out.print(rs.getString("stusex")+"\t");
System.out.print(rs.getString("stuclass"));
System.out.print(rs.getString("stumajor"));
System.out.println(rs.getString("stucollege"));
}
}catch(SQLExceptione){
System.err.println("SQLException"+e.getMessage());
}finally{
if(rs!
=null){
try{
rs.close();
}catch(SQLExceptione){}
}
Finally(sql,con);
}
}
}
publicstaticvoidNumberDeleteStuInfo(){
PreparedStatementsql=null;
Connectioncon=null;
booleanflag=false;
Stringnumber=null;
do{
System.out.println("请输要删除学生的学号:
");
number=Keyboard.InputString();
if(Check(number)==false){
System.out.println("没有学号为"+number+"的学生,请重新输入!
");
flag=true;
}
elsebreak;
}while(flag);
try{
con=getconnect();
sql=con.prepareStatement("deletefromstuinfowherestunumber='"+number+"'");
if(sql.executeUpdate()!
=1)
thrownewMyException("删除错误!
");
System.out.println("信息删除成功!
");
}catch(SQLExceptione){
System.err.println("SQLException"+e.getMessage());
}catch(MyExceptione){
System.out.println(e.getMessage());
}
Finally(sql,con);
}
publicstaticvoidIdDeleteStuInfo(){
PreparedStatementsql=null;
Connectioncon=null;
booleanflag=false;
intid=0;
do{
System.out.println("请输要删除学生的ID号:
");
id=Keyboard.InputInt();
if(Check(id)==false){
System.out.println("没有Id号为"+id+"的学生,请重新输入!
");
flag=true;