学校教材管理系统

一设计目的通过课程设计，使学生能进一步稳固课堂上所学的知识，深刻把握Java技术的重要概念及其面向对象的特性，掌握软件开发的根本流程，锻炼学生应用面向对象的思想和设计方法解决实际问题的能力，培养学生合作精神和技术文档撰写能力。二设计内容〔1〕题目分析，查找资料和总体设计。〔2〕详细设计、代码编制、程序调试。系统功能要求如下：①具有用户管理和登录功能②具有教材信息的录入功能③具有数据查询、删除、修改功能④具有输出功能⑤具有统计功能〔3〕结果分析、完成课程设计说明书。三设计要求〔1〕只能使用Java语言，采用面向对象方法进行设计，要求使用结构体数组或链表编写程序，源程序要有适当的注释，是程序容易阅读。〔2〕程序的界面、逻辑功能和数据的存储尽可能的分开，至少采用文本菜单界面〔如果能采用图形菜单界面更好〕。〔3〕学生可根据自身情况酌情增加新功能〔视情况可另外加分〕。〔4〕独立完成课程设计，并完成课程设计报告，报告应记录设计的过程，尤其是分析/设计/实现过程中的决策。四设计过程1任务解析结构设计：确定系统由哪些模块组成，以及这些模块之间的相互关系。过程设计：确定每个模块的处理过程。其中，结构设计是总体设计阶段的任务，而过程设计那么是详细设计阶段的任务。2程序结构分析教材库存查询功能此模块的具体功能是查看当前教材库中所有教材的存储情况，只能查询不能有修改和删除的功能，库存的信息存放在数据库中的book表中。查询的方式有根据教材名称、教材编号两种方式进行查询。主要的功能就是显示库存信息，方便工作人员了解教材库存数量。教材出/入库查询功能此模块的具体功能是查询教材的出/入库情况，只能查询不能有修改和删除的功能，库存的信息存放在数据库中的book_list表中。查询的方式有根据教材名称、教材编号和出入库时间三种方式进行查询。主要的功能就是显示教材出库信息或者教材入库信息，方便工作人员了解教材的出入库情况。系统功能总框图教材管理系统教材管理系统身份验证库存管理教材管理教材库存查询教材出入库查询教材出入库登记新教材信息录入教材信息查询教材信息管理系统管理员一般用户3数据结构分析Admin表中保存的是用户信息，包括：用户编号、用户登录名、用户登录密码以及用户权限。如表3.1。表3.1管理员信息表字段名称数据类型长度备注ad_id文本10用户编号ad_name文本10用户登录名ad_pw文本15用户登录密码ad_dj文本5用户权限4功能实现主界面功能实现主界面是整个系统的操作的主体局部，把所有的功能和所集成的小工具都放在这个功能模块上面，所以在做的时候很细致，用一种比拟友好的界面来展示我们这次课程设计——教材管理系统，5系统测试主界面功能实现系统主界面五设计总结在这次设计过程中，表达出自己单独设计模具的能力以及综合运用知识的能力，体会了学以致用、突出自己劳动成果的喜悦心情，从中发现自己平时学习的缺乏和薄弱环节，从而加以弥补。程设计是我们专业课程知识综合应用的实践训练，是我们迈向社会，从事职业工作前一个必不少的过程．〞千里之行始于足下〞，通过这次课程设计，我深深体会到这句千古名言的真正含义．我今天认真的进行课程设计，学会脚踏实地迈开这一步，就是为明天能稳健地在社会大潮中奔跑打下坚实的根底．通过和同学之间的合作，终于把课程设计弄好，我懂得了团队写作的重要性，这对我以后工作有着非常重要的作用。参考文献[1]黄明，梁旭编著.Delphi信息系统设计实例.北京：机械工业出版社.2005年3月第二版[2]耿祥义.JAVA2实用教程.北京：清华大学出版社，2006[3]朱仲杰.JAVA2全方位学习.北京：机械工业出版社，2006[4]张思民.JAVA程序设计实践教程.北京：清华大学出版社，2006[5]汤一平.Java语言程序设计.北京：科学出版社，2006[6]刘艺.Java程序设计大学教程.北京：机械工业出版社，2006[7]耿祥义.Java课程设计.北京：清华大学出版社，2003[8]SharonZakhour.Java教程.北京：人民邮电出版社，2007附录packagecom.Jiaocai.condb;importjava.sql.*;/****@authorAdministrator*/publicclassGetStatement{//数据库连接功能publicGetStatement(){}privateConnectionconn;privateStatementst;publicStatementreturn_statement()throwsClassNotFoundException,SQLException{Class.forName("com.mysql.jdbc.Driver");//加载驱动conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/jiaocai","root","123");//获取连接st=conn.createStatement();//创立语句对象returnst;}publicvoidclose_all()throwsSQLException{st.close();conn.close();}}publicclassApplyextendsjavax.swing.JFrame{//系统登录功能publicApply(){initComponents();}/**Thismethodiscalledfromwithintheconstructorto*initializetheform.*WARNING:DoNOTmodifythiscode.Thecontentofthismethodis*alwaysregeneratedbytheFormEditor.*/@SuppressWarnings("unchecked")//<editor-folddefaultstate="collapsed"desc="GeneratedCode">privatevoidinitComponents(){jPanel1=newjavax.swing.JPanel();jTextField1=newjavax.swing.JTextField();jLabel1=newjavax.swing.JLabel();jPasswordField1=newjavax.swing.JPasswordField();jLabel2=newjavax.swing.JLabel();jLabel3=newjavax.swing.JLabel();jButton1=newjavax.swing.JButton();setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);setTitle("教材管理系统");setLocationByPlatform(true);setResizable(false);jLabel1.setFont(newjava.awt.Font("宋体",0,36));jLabel1.setText("教材管理系统登录");jLabel2.setFont(newjava.awt.Font("宋体",0,14));jLabel2.setText("用户名：");jLabel3.setFont(newjava.awt.Font("宋体",0,14));jLabel3.setText("密码：");jButton1.setText("登陆");jButton1.addMouseListener(newjava.awt.event.MouseAdapter(){publicvoidmouseClicked(java.awt.event.MouseEventevt){ad_denglu(evt);}});}publicclassMainJieMianextendsjavax.swing.JFrame{//主界面功能IntegerDJ;StringYName;/**CreatesnewformMainJieMian*/publicMainJieMian(Integerdj,Stringyname){initComponents();DJ=dj;YName=yname;if(dj!=2){jMenuItem1.setEnabled(false);jMenuItem9.setEnabled(false);jMenuItem2.setEnabled(false);}}/**Thismethodiscalledfromwithintheconstructorto*initializetheform.*WARNING:DoNOTmodifythiscode.Thecontentofthismethodis*alwaysregeneratedbytheFormEditor.*/@SuppressWarnings("unchecked")//<editor-folddefaultstate="collapsed"desc="GeneratedCode">privatevoidinitComponents(){setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);setTitle("教材管理系统");setLocationByPlatform(true);setResizable(false);jLabel1.setFont(newjava.awt.Font("宋体",0,36));jLabel1.setText("欢送使用教材管理系统");jMenu1.setText("系统管理");jMenuItem1.setText("添加用户");jMenuItem1.addActionListener(newjava.awt.event.ActionListener(){publicvoidactionPerformed(java.awt.event.ActionEventevt){addAmin(evt);}});jMenu1.add(jMenuItem1);jMenuItem9.setText("查询用户");jMenuItem9.addActionListener(newjava.awt.event.ActionListener(){publicvoidactionPerformed(java.awt.event.ActionEventevt){selectAdmin(evt);}});jMenu1.add(jMenuItem9);jMenuItem2.setText("修改/删除用户");jMenuItem2.addActionListener(newjava.awt.event.ActionListener(){publicvoidactionPerformed(java.awt.event.ActionEventevt){updateAdmin(evt);}});jMenu1.add(jMenuItem2);jMenuItem11.setText("修改密码");jMenuItem11.addActionListener(newjava.awt.event.ActionListener(){publicvoidactionPerformed(java.awt.event.ActionEventevt){xiugaimima(evt);}});jMenu1.add(jMenuItem11);jMenuItem3.setText("退出系统");jMenuItem3.addActionListener(newjava.awt.event.ActionListener(){publicvoidactionPerformed(java.awt.event.ActionEventevt){tuichu(evt);}});jMenu1.add(jMenuItem3);jMenuBar1.add(jMenu1);jMenu2.setText("教材管理");jMenuItem8.setText("添加新教材信息");jMenuItem8.addActionListener(newjava.awt.event.ActionListener(){publicvoidactionPerformed(java.awt.event.ActionEventevt){addJcInfo(evt);}});jMenu2.add(jMenuItem8);jMenuItem10.setText("查询教材信息");jMenuItem10.addActionListener(newjava.awt.event.ActionListener(){publicvoidactionPerformed(java.awt.event.ActionEventevt){selectJcInf(evt);}});jMenu2.add(jMenuItem10);jMenuItem7.setText("修改/删除教材信息");istener(){publicvoidactionPerformed(java.awt.event.ActionEventevt){updateJcInf(evt);}});jMenu2.add(jMenuItem7);jMenuBar1.add(jMenu2);jMenu5.setText("库存管理");jMenuItem6.setText("教材出/入库登记");jMenuItem6.addActionListener(newjava.awt.event.ActionListener(){publicvoidactionPerformed(java.awt.event.ActionEventevt){kucunInsert(evt);}});jMenu5.add(jMenuItem6);jMenuItem4.setText("教材出/入库查询");jMenuItem4.addActionListener(newjava.awt.event.ActionListener(){publicvoidactionPerformed(java.awt.event.ActionEventevt){kucunJlselect(evt);}});jMenu5.add(jMenuItem4);jMenuItem5.setText("教材库存查询");jMenuItem5.addActionListener(newjava.awt.event.ActionListener(){publicvoidactionPerformed(java.awt.event.ActionEventevt){kucunliang(evt);}}}publicclassAddAdimextendsjavax.swing.JPanel{//用户管理功能/**CreatesnewformAddAdim*/publicAddAdim(){initComponents();}/**Thismethodiscalledfromwithintheconstructorto*initializetheform.*WARNING:DoNOTmodifythiscode.Thecontentofthismethodis*alwaysregeneratedbytheFormEditor.*/@SuppressWarnings("unchecked")//<editor-folddefaultstate="collapsed"desc="GeneratedCode">privatevoidinitComponents()privatevoidadd_Admin(java.awt.event.ActionEventevt){//添加管理员if(jTextField1.getText().length()==0||jPasswordField1.getPassword().length==0||jPasswordField2.getPassword().length==0||jTextField2.getText().length()==0){javax.swing.JOptionPane.showMessageDialog(this,"资料不全，请完善资料","错误",javax.swing.JOptionPane.ERROR_MESSAGE);}else{Stringname="";Stringpw="";Stringpwa="";Integeryonghu;name=jTextField1.getText();pw=String.valueOf(jPasswordField1.getPassword());pwa=String.valueOf(jPasswordField2.getPassword());yonghu=Integer.valueOf(jTextField2.getText());privatevoidinitComponents(){//教材库存查询功能jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("查询教材信息"));jTable1.setModel(newjavax.swing.table.DefaultTableModel(newObject[][]{},newString[]{}));jScrollPane1.setViewportView(jTable1);jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("查询条件"));jButton1.setText("查询");jButton1.addMouseListener(newjava.awt.event.MouseAdapter(){publicvoidmouseClicked(java.awt.event.MouseEventevt){select_jcinf(evt);}});jLabel1.setText("教材编号：");jLabel2.setText("教材名称：");jLabel3.setText("出版社：");jLabel4.setText("作者：");privatevoidselect_jcinf(java.awt.event.MouseEventevt){//TODOaddyourhandlingcodehere:Stringshuhao=jTextField1.getText();Stringname=jTextField2.getText();Stringau=jTextField4.getText();Stringpub=jTextField3.getText();Select_JcInfsa=newSelect_JcInf();ResultSetrs;try{rs=sa.returnResult(shuhao,name,au,pub);DefaultTableModeldtm;Object[][]ob={};String[]st={"书号","书名","作者","出版社","单价","出版时间","库存量"};dtm=newDefaultTableModel(ob,st);for(;rs.next();){Object[]data={rs.getString("book_id"),rs.getString("book_name"),rs.getString("author"),rs.getString("publisher"),rs.getString("price"),rs.getString("publish_date"),rs.getString("quantity")};dtm.addRow(data)}rs.close();jTable1.setModel(dtm);jTextField1.setText("");jTextField2.setText("");jTextField3.setText("");jTextField4.setText("");}catch(Exceptione){e.printStackTrace();}}publicclassKucunJlselectextendsjavax.swing.JPanel{//教材出/入库查询功能/**CreatesnewformKucunJlselect*/publicKucunJlselect(){initComponents();}privatevoidinitComponents(){jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("教材出入库记录查询"));jTable1.setModel(newjavax.swing.table.DefaultTableModel(newObject[][]{},newString[]{}));jScrollPane1.setViewportView(jTable1);jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("查询条件"));jLabel1.setText("教材编号：");jButton1.setText("查询");jButton1.addMouseListener(newjava.awt.event.MouseAdapter(){publicvoidmouseClicked(java.awt.event.MouseEventevt){kucunSe(evt);}});jLabel2.setText("教材名称：");jLabel3.setText("出入库时间：");jCheckBox1.setText("出库");jCheckBox2.setText("入库");privatevoidkucunSe(java.awt.event.MouseEventevt){//TODOaddyourhandlingcodehere:Stringbianhao=jTextField1.getText();Stringname=jTextField2.getText();Stringshijian=jTextField3.getText();Stringchuru="";if(!(jCheckBox1.isSelected()&&jCheckBox2.isSelected())){if(jCheckBox1.isSelected()){churu="出库";}if(jCheckBox2.isSelected()){churu="入库";}}ChRukusa=newChRuku();ResultSetrs;try{rs=sa.returnResult(bianhao,name,shijian,churu);DefaultTableModeldtm;Object[][]ob={};String[]st={"教材编号","教材名称","出/入库","出入库数量","出入库时间"};dtm=newDefaultTableModel(ob,st);for(;rs.next();){Object[]data={rs.getString("book_id"),rs.getString("book_name"),rs.getString("in_out"),rs.getString("amount"),rs.getString("inout_date")};dtm.addRow(data);}rs.close();jTable1.setModel(dtm);jTextField1.setText("");jTextField2.setText("");jTextField3.setText("");}catch(Exceptione){e.printStackTrace();}}publicclassKucunInsertextendsjavax.swing.JPanel{//教材出/入库登记功能publicIntegerkc;privateMainJieMianmainframe;/**CreatesnewformKucunInsert*/publicKucunInsert(MainJieMianmainframe){initComponents();this.mainframe=mainframe;}privatevoidinitComponents(){jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("出入库登记"));jLabel1.setText("教材编号：");jLabel2.setText("出/入库：");jLabel3.setText("数量：");jButton1.setText("录入");jButton1.addMouseListener(newjava.awt.event.MouseAdapter(){publicvoidmouseClicked(java.awt.event.MouseEventevt){Luruku(evt);}});buttonGroup1.add(jRadioButton1);jRadioButton1.setText("出库");buttonGroup1.add(jRadioButton2);jRadioButton2.setSelected(true);jRadioButton2.setText("入库");jLabel4.setText("教材名称：");javax.swing.GroupLayoutjPanel1Layout=newjavax.swing.GroupLayout(jPanel1);jPanel1.setLayout(jPanel1Layout);jPanel1Layout.setHorizontalGroup(privatevoidLuruku(java.awt.event.MouseEventevt){//TODOaddyourhandlingcodehere:if(jTextField1.getText().length()==0||jTextField2.getText().length()==0||jTextField3.getText().length()==0){javax.swing.JOptionPane.showMessageDialog(this,"资料不全，请完善资料","错误",javax.swing.JOptionPane.ERROR_MESSAGE);}else{Integerkc=null;Stringbianhao="";Stringname="";Stringchuru="";Stringtime="";ResultSetrs;bianhao=jTextField1.getText();name=jTextField3.getText();Integershu=Integer.valueOf(jTextField2.getText());Datedate=newDate();SimpleDateFormatf=newSimpleDateFormat("yyyy-MM-dd");time=String.valueOf(f.format(date));//----------------------------------------------//查询数据库库存剩余量ResultSetks;InsertLuruss=newInsertLuru();Selectbiaobb=newSelectbiao();Insert_luruluru=newInsert_luru();//--------------------------------------------try{rs=bb.returnResult(bianhao);if(!rs.next()&&jRadioButton1.isSelected()){javax.swing.JOptionPane.showMessageDialog(this,"不存在该教材，无法出库","警告",javax.swing.JOptionPane.WARNING_MESSAGE);jTextField1.setText("");jTextField2.setText("");jTextField3.setText("");}else{GetStatementgs=newGetStatement();Stringsql="selectquantityfrombookwherebook_id='"+bianhao+"'";try{ks=gs.return_statement().executeQuery(sql);//for(;ks.next();){if(ks.next())kc=Integer.valueOf(ks.getString("quantity"));//}ks.close();}catch(Exceptione){e.printStackTrace();}if(jRadioButton1.isSelected()&&kc<shu){javax.swing.JOptionPane.showMessageDialog(this,"教材库存缺乏","警告",javax.swing.JOptionPane.WARNING_MESSAGE);jTextField3.setText("");}else{if(jRadioButton1.isSelected()){shu=-1*shu;churu="出库";}if(jRadioButton2.isSelected()){churu="入库";}rs=bb.returnResult(bianhao);if(!rs.next()){luru.inserts(bianhao,name,String.valueOf(shu));javax.swing.JOptionPane.showMessageDialog(this,"出入库记录已增加","成功",javax.swing.JOptionPane.INFORMATION_MESSAGE);if(JOptionPane.showConfirmDialog(null,"此教材为新教材，是否完善教材信息")==JOptionPane.OK_OPTION){try{//翻开修改删除教材信息界面UpdateJcInfaa=newUpdateJcInf();mainframe.setContentPane(aa);catch(Exceptione){e.printStackTrace();}}jTextField1.setText("");jTextField2.setText("");jTextField3.setText("");}else{ss.urdate_luru(bianhao,shu);javax.swing.JOptionPane.showMessageDialog(this,"信息已入库并更新了库存量，出入库记录已增加","成功",javax.swing.JOptionPane.INFORMATION_MESSAGE);}}}publicclassAddJcInfextendsjavax.swing.JPanel{//新教材录入功能privatevoidinitComponents(){jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("添加新教材信息"));jLabel1.setText("新书名称：");jLabel2.setText("作者：");jLabel3.setText("出版社：");jButton1.setText("添加");jButton1.addMouseListener(newjava.awt.event.MouseAdapter(){publicvoidmouseClicked(java.awt.event.MouseEventevt){addJcIf(evt);}});jLabel4.setText("单价：");jLabel5.setText("库存量：");jLabel6.setText("出版时间：");privatevoidaddJcIf(java.awt.event.MouseEventevt){if(jTextField1.getText().length()==0||jTextField2.getText().length()==0||jTextField3.getText().length()==0||jTextField4.getText().length()==0||jTextField5.getText().length()==0||jTextField6.getText().length()==0){javax.swing.JOptionPane.showMessageDialog(this,"资料不全，请完善资料","错误",javax.swing.JOptionPane.ERROR_MESSAGE);}else{Stringname="";Stringau="";Stringpub="";Stringtime="";Integerpr,shu;name=jTextField1.getText();au=jTextField2.getText();pub=jTextField3.getText();pr=Integer.valueOf(jTextField4.getText());time=jTextField6.getText();shu=Integer.valueOf(jTextField5.getText());//插入数据库Add_JcInfia=newAdd_JcInf();try{if(name.equals("")){javax.swing.JOptionPane.showMessageDialog(this,"教材名称不能为空","失败",javax.swing.JOptionPane.ERROR_MESSAGE);}ia.inserts(name,au,pub,pr,shu,time);javax.swing.JOptionPane.showMessageDialog(this,"增加成功","成功",javax.swing.JOptionPane.INFORMATION_MESSAGE);}catch(Exceptione){javax.swing.JOptionPane.showMessageDialog(this,"增加不成功,原因不明","错误",javax.swing.JOptionPane.ERROR_MESSAGE);e.printStackTrace();}publicclassUpdateJcInfextendsjavax.swing.JPanel{//教材信息管理功能publicUpdateJcInf()throwsException{initComponents();//查询数据库，显示出所有的用户的名称Selectjjsa=newSelectjj();ResultSetrs;rs=sa.returnResult("");for(inti=0;rs.next();i++){});jButton3.setText("删除");jButton3.addMouseListener(newjava.awt.event.MouseAdapter(){publicvoidmouseClicked(java.awt.event.MouseEventevt){delete_jcinf(evt);}});jLabel6.setText("出版时间：");if(jTextField1.getText().length()==0||jTextField2.getText().length()==0||jTextField3.getText().length()==0||jTextField4.getText().length()==0||jTextField5.getText().length()==0){javax.swing.JOptionPane.showMessageDialog(this,"资料不全，请完善资料","错误",javax.swing.JOptionPane.ERROR_MESSAGE);}//执行修改数据库的操作try{Update_JcInfald=newUpdate_JcInf();ald.alter_jcinf(iden,zuozhe,chubanshe,danjia,shuliang,cbtime);javax.swing.JOptionPane.showMessageDialog(this,"修改成功！","成功",javax.swing.JOptionPane.INFORMATION_MESSAGE);jTextField1.setText("");jTextField2.setText("");jTextField3.setText("");jTextField4.setText("");jTextField5.setText("");jComboBox1.removeAllItems();//--------------------------------------------Selectjjsa=newSelectjj();ResultSetrs;rs=sa.returnResult("");for(inti=0;rs.next();i++){jComboBox1.addItem(rs.getString("book_name"));auth.add(i,rs.getString("author"));id.add(i,rs.getString("book_id"));publish.add(i,rs.getString("publisher"));pric.add(i,rs.getString("price"));sh.add(i,rs.getString("quantity"));time.add(i,rs.getString("publish_date"));}rs.close();//-----------------------------------------------}catch(Exceptione){e.printStackTrace();}}}privatevoiddelete_jcinf(java.awt.event.MouseEventevt){//TODOaddyourhandlingcodehere:if