图书管理系统java版

package book; import java.sql.*; //确认窗口 import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.io.*; import java.awt.event.*; import javax.swing.table.*; class bor_mana implements ActionListener { String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver"; String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=图书管理;encrypt=false"; String userName="sa"; String userPwd="123123"; Connection con; Statement stmt; ResultSet rs; JFrame f=new JFrame("借阅管理"); String[] names; int i,j,RowNum,ColNum; Object[][] info; JTable table; JButton b=new JButton("同意"); JButton b2=new JButton("拒绝"); String id; bor_mana(){ try{ Class.forName(driverName); con=DriverManager.getConnection(dbURL, userName, userPwd); stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select count(*) from 借阅表"); rs.next(); RowNum=rs.getInt(1); rs=stmt.executeQuery("select * from 借阅表"); ResultSetMetaData rsmd=rs.getMetaData(); ColNum=rsmd.getColumnCount(); names=new String[ColNum]; //构造JTable for (i=1;i<=ColNum;i++) names[i-1]=rsmd.getColumnName(i); info=new Object[RowNum][]; i=0; while (rs.next()) { info[i]=new Object[ColNum]; for (j=1;j<=ColNum;j++) { info[i][j-1]=rs.getObject(j); } i++; } DefaultTableModel model = new DefaultTableModel(info,names); table=new JTable(model); table.setPreferredScrollableViewportSize(new Dimension(400,50)); b.addActionListener(this); b2.addActionListener(this); Panel panel=new Panel(); panel.add(b); panel.add(b2); f.add(panel,BorderLayout.SOUTH); //table.addMouseListener(this); f.getContentPane().add(new JScrollPane(table)); f.setSize(400, 300); f.setVisible(true); f.setResizable(false); f.setLocationRelativeTo(null); //只关闭当前窗口 f.addWindowListener(new WindowAdapter() { public void windowClosing(WindowEvent e) { f.dispose(); } }); rs.close(); stmt.close(); con.close(); } catch(Exception e) { System.out.println(e.getMessage()); } } public void actionPerformed(ActionEvent e) { try{ Class.forName(driverName); con=DriverManager.getConnection(dbURL, userName, userPwd); stmt=con.createStatement(); int i=table.getSelectedRow(); String book_name=table.getValueAt(i,0).toString(); String name=table.getValueAt(i,2).toString(); id=table.getValueAt(i,3).toString(); String numb= table.getValueAt(i,1).toString(); int number3=Integer.parseInt(numb); //删除记录 if(e.getActionCommand().equals("同意")) { int result = JOptionPane.showConfirmDialog(f, "同意"+name+"借阅"+book_name+"吗"); if(result==JOptionPane.OK_OPTION) { number3--; String sql2="delete from 借阅表 where 借书人姓名='"+name+"' and 书籍名称='"+book_name+"'"; stmt.execute(sql2); sql2="update 借阅表 set 剩余数量="+number3+"where 书籍名称='"+book_name+"'"; stmt.execute(sql2); sql2="update 图书 set 数量="+number3+"where 图书名称='"+book_name+"'"; stmt.execute(sql2); String sql="insert into 成功借阅信息 values('"+book_name+"','"+name+"','"+id+"',getdate(),null)"; stmt.execute(sql); //显示删除后数据库记录 ResultSet rs=stmt.executeQuery("select * from 借阅表"); DefaultTableModel tableModel= (DefaultTableModel)table.getModel(); tableModel.setRowCount(0); while (rs.next()) { String[] arr=new String[4]; arr[0]=rs.getString("书籍名称"); int num=(int)rs.getInt(2); arr[1]=String.valueOf(num); arr[2]=rs.getString("借书人姓名"); arr[3]=rs.getString("用户名"); tableModel.addRow(arr); } table.invalidate(); } } if(e.getActionCommand().equals("拒绝")) { int result2 = JOptionPane.showConfirmDialog(f, "拒绝"+name+"借阅"+book_name+"吗"); if(result2==JOptionPane.OK_OPTION) { String sql2="delete from 借阅表 where 借书人姓名='"+name+"' and 书籍名称='"+book_name+"'"; stmt.executeUpdate(sql2); String sql="insert into 失败借阅信息 values('"+book_name+"','"+name+"','"+id+"')"; stmt.execute(sql); //显示删除后数据库记录 ResultSet rs=stmt.executeQuery("select * from 借阅表"); DefaultTableModel tableModel= (DefaultTableModel)table.getModel(); tableModel.setRowCount(0); while (rs.next()) { String[] arr=new String[4]; arr[0]=rs.getString("书籍名称"); arr[1]=rs.getString("剩余数量"); arr[2]=rs.getString("借书人姓名"); arr[3]=rs.getString("用户名"); tableModel.addRow(arr); } table.invalidate(); } } // rs.close(); stmt.close(); con.close(); } catch(Exception ex) { System.out.println(ex.getMessage()); } } }