JDBC实现学生管理系统
本文实例为大家分享了JDBC实现学生管理系统的具体代码,供大家参考,具体内容如下
1、学生类
packagemanage; importjava.util.Date; /** *@authorfanxf *@since2018/4/2717:01 */ publicclassStudent{ privateintid; privateintage; privateStringsex; privateStringname; privateDatedateCreated; publicintgetId(){ returnid; } publicvoidsetId(intid){ this.id=id; } publicintgetAge(){ returnage; } publicvoidsetAge(intage){ this.age=age; } publicStringgetSex(){ returnsex; } publicvoidsetSex(Stringsex){ this.sex=sex; } publicStringgetName(){ returnname; } publicvoidsetName(Stringname){ this.name=name; } publicDategetDateCreated(){ returndateCreated; } publicvoidsetDateCreated(DatedateCreated){ this.dateCreated=dateCreated; } publicStudent(){ } publicStudent(intage,Stringsex,Stringname){ this.age=age; this.sex=sex; this.name=name; } publicStudent(intid,intage,Stringsex,Stringname){ this.id=id; this.age=age; this.sex=sex; this.name=name; } @Override publicStringtoString(){ return"Student{"+ "id="+id+ ",age="+age+ ",sex='"+sex+'\''+ ",name='"+name+'\''+ ",dateCreated="+dateCreated+ '}'; } }
2、jdbc工具类
packagemanage; importjava.io.IOException; importjava.sql.*; importjava.util.Properties; /** *@authorfanxf *@since2018/4/2711:06 */ //数据库的工具类 publicclassJdbcUtils{ privatestaticStringdriver=""; privatestaticStringurl=""; privatestaticStringuser=""; privatestaticStringpassword=""; static{ Propertiesp=newProperties(); try{ p.load(Thread.currentThread().getContextClassLoader().getResourceAsStream("db.properties")); }catch(IOExceptione){ e.printStackTrace(); } driver=p.getProperty("driver"); url=p.getProperty("url"); user=p.getProperty("user"); password=p.getProperty("password"); try{ Class.forName(driver); }catch(ClassNotFoundExceptione){ e.printStackTrace(); } } publicstaticConnectiongetConnection(){ try{ returnDriverManager.getConnection(url,user,password); }catch(SQLExceptione){ e.printStackTrace(); } returnnull; } //释放的时候要从小到大释放 //Connection->Statement-->Resultset publicstaticvoidrelease(ResultSetrs,Statementstmt,Connectionconn){ if(rs!=null){ try{ rs.close(); }catch(SQLExceptione){ e.printStackTrace(); } } if(stmt!=null){ try{ stmt.close(); }catch(SQLExceptione){ e.printStackTrace(); } } if(conn!=null){ try{ conn.close(); }catch(SQLExceptione){ e.printStackTrace(); } } } }
3、代码
packagemanage; importjava.sql.Connection; importjava.sql.PreparedStatement; importjava.sql.ResultSet; importjava.sql.SQLException; importjava.util.Scanner; /** *@authorfanxf *@since2018/4/2717:06 */ publicclassManageSystem{ privatestaticConnectionconn=null; privatestaticPreparedStatementps=null; privatestaticResultSetrs=null; /** *添加学生数据 * *@paramstudent *@return */ publicstaticintaddStudent(Studentstudent){ conn=JdbcUtils.getConnection(); intresult=0; try{ ps=conn.prepareStatement("INSERTINTOstudent(age,sex,`name`,dateCreated)VALUES(?,?,?,now())"); ps.setInt(1,student.getAge());//设置第一个参数 ps.setString(2,student.getSex());//设置第二个参数 ps.setString(3,student.getName());//设置第三个参数 result=ps.executeUpdate(); }catch(SQLExceptione){ e.printStackTrace(); }finally{ JdbcUtils.release(null,ps,conn);//关闭连接 } returnresult; } publicvoidadd(){ Scannerscan=newScanner(System.in); System.out.println("请输入学生年龄"); intage=scan.nextInt(); System.out.println("请输入学生性别"); Stringsex=scan.next(); System.out.println("请输入学生姓名"); Stringname=scan.next(); Students=newStudent(age,sex,name); intflag=addStudent(s); if(flag>0){ System.out.println("添加成功"); }else{ System.out.println("添加失败"); } } /** *修改 * *@paramstudent *@return */ publicstaticintupdateStudent(Studentstudent){ conn=JdbcUtils.getConnection(); intresult=0; try{ ps=conn.prepareStatement("UPDATEstudentSETage=?,sex=?,`name`=?WHEREid=?"); ps.setInt(1,student.getAge());//设置第一个参数 ps.setString(2,student.getSex());//设置第二个参数 ps.setString(3,student.getName());//设置第三个参数 ps.setInt(4,student.getId()); result=ps.executeUpdate(); }catch(SQLExceptione){ e.printStackTrace(); }finally{ JdbcUtils.release(null,ps,conn);//关闭连接 } returnresult; } publicvoidupdate(){ Scannerscan=newScanner(System.in); System.out.println("请输入学生id"); intid=scan.nextInt(); System.out.println("请输入学生年龄"); intage=scan.nextInt(); System.out.println("请输入学生性别"); Stringsex=scan.next(); System.out.println("请输入学生姓名"); Stringname=scan.next(); Students=newStudent(id,age,sex,name); intflag=updateStudent(s); if(flag>0){ System.out.println("更新成功"); }else{ System.out.println("更新失败"); } } /** *删除 * *@paramid *@return */ publicstaticintdeleteStudent(intid){ conn=JdbcUtils.getConnection(); intresult=0; try{ ps=conn.prepareStatement("DELETEFROMstudentWHEREid=?"); ps.setInt(1,id);//设置第一个参数 result=ps.executeUpdate(); }catch(SQLExceptione){ e.printStackTrace(); }finally{ JdbcUtils.release(null,ps,conn);//关闭连接 } returnresult; } publicvoiddelete(){ Scannerscan=newScanner(System.in); System.out.println("请输入学生id"); intid=scan.nextInt(); intflag=deleteStudent(id); if(flag>0){ System.out.println("删除成功"); }else{ System.out.println("删除失败"); } } publicstaticvoidmain(String[]args){ System.out.println("************欢迎进入学生管理系统*************"); ManageSystemms=newManageSystem(); booleanb=true; while(b){ System.out.println("你想进行以下哪项操作"); System.out.println("1、添加学生2、更新学生数据3、学生信息查询4、删除学生0、退出"); Scannerscan=newScanner(System.in); inti=scan.nextInt(); switch(i){ case1: ms.add(); break; case2: ms.update(); break; case3: System.out.println(); break; case4: ms.delete(); break; default: System.out.println("没有该操作选项,请重新来过!"); main(args); break; } } } }
4、properties数据库文件自己配置
数据库字段根据学生类建立!
更多学习资料请关注专题《管理系统开发》。
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持毛票票。