tidybookorreaderframe.java

图书管理系统：用户管理

			if((returnrow=table.getSelectedRows()).length!=0){
					for(int i=0;i<returnrow.length;i++){
						if(result[returnrow[i]][0]!=null){
							g++;
						}
					}
					if(g!=0){
						int sel=JOptionPane.showConfirmDialog(this,"确定删除这"+g+message,"确认对话框",JOptionPane.YES_NO_OPTION);
						if(sel==JOptionPane.YES_OPTION){
							int count=0;
							for(int i=0;i<table.getSelectedRowCount();i++){
								if(result[returnrow[i]][0]!=null){
									String temp="'"+result[returnrow[i]][0].toString()+"'";
									String del="DELETE FROM "+tablename+" WHERE "+rowname+" = "+temp;
									String queue="SELECT * FROM Lend_Book WHERE "+rowname+" = "+temp;
									ResultSet rs;
									try{
										rs=sql.executeQuery(queue);
										if(rs.next()){
											JOptionPane.showMessageDialog(this,warn,"警告对话框",JOptionPane.WARNING_MESSAGE);
											continue;
										}
										int d=sql.executeUpdate(del);
										if(d==1){
											count++;
											for(int j=0;j<q;j++){
												result[returnrow[i]][j]=null;
											}
										}
									}
									catch(SQLException e2){
										JOptionPane.showMessageDialog(this,"计算机已与服务器断开");
									}
								}
							}
							table.repaint();
							audiourl=getClass().getResource("/sound/Declare.wav");
							if(audiourl!=null){
								audio=Applet.newAudioClip(audiourl);
								audio.play();
							}
							JOptionPane.showMessageDialog(this,"成功删除"+count+message);
							progress.setValue(progress.getValue()-count);progress.setString("查询到"+(progress.getValue()-count)+message);
						}
					}
					else{
						if(bookread){
							JOptionPane.showMessageDialog(this,"请选择要删除的书本");
						}
						else{
							JOptionPane.showMessageDialog(this,"请选择要删除的读者");
						}
					}
				}
				else{
					if(bookread){
						JOptionPane.showMessageDialog(this,"请选择要删除的书本");
					}
					else{
						JOptionPane.showMessageDialog(this,"请选择要删除的读者");
					}
				}
		}
		else if(e.getSource()==changebutton||e.getSource()==changemenu){
			if(bookread){
				if(purview.equals("Common")||purview.equals("Borrow")){
					JOptionPane.showMessageDialog(this,"你没有权限使用修改图书信息功能!","警告对话框",JOptionPane.WARNING_MESSAGE);
					return;
				}
			}
			else{
				if(purview.equals("Common")||purview.equals("Book")){
					JOptionPane.showMessageDialog(this,"你没有权限使用修改读者信息功能!","警告对话框",JOptionPane.WARNING_MESSAGE);
					return;
				}
			}
			if(table.getSelectedRowCount()==1&&result[table.getSelectedRow()][0]!=null){
				if(bookread){
					new AddOrChangeBookFrame("修改图书",con,true,result,table);
				}
				else{
					new AddOrChangeReaderFrame("修改读者信息",false,con,result,table);
				}
			}
			else{
				if(bookread){
					JOptionPane.showMessageDialog(this,"请选择一本书进行修改!","警告对话框",JOptionPane.WARNING_MESSAGE);
				}
				else{
					JOptionPane.showMessageDialog(this,"请选择一个读者进行修改!","警告对话框",JOptionPane.WARNING_MESSAGE);
				}
				}
		}
		else{
			printjob=tool.getPrintJob(this,"OK",null);
			if(printjob!=null){
				graphics=printjob.getGraphics();
				table.paint(graphics);
				graphics.dispose();
				printjob.end();
			}
			else{
				JOptionPane.showMessageDialog(this,"没有可以使用的打印机");
			}
		}
	}
	public void itemStateChanged(ItemEvent e){
		for(int i=0;i<z;i++){
			if(e.getItemSelectable()==radio[i]){
				n=i;
			}
		}
		if(e.getItemSelectable()==darkbox){
			dark=!dark;
		}
	}
	//向数据库查询信息函数
	private void search(String queue){
		try{
			progress.setValue(0);progress.setString("查询到"+0+message);
			int m=0;
			ResultSet rs=sql.executeQuery(queue);
			resettable();
			while(rs.next()){
				if(m==result.length){
					container.remove(scroll);
					Object[][] temp=result;
					result=new Object[m*2][q];
					table=new JTable(result,columnName);
					table.addMouseListener(pl);
					scroll=new JScrollPane(table);
					container.add(scroll);
					scroll.setBounds(0,80,600,180);
					validate();
					for(int i=0;i<temp.length;i++){
						for(int j=0;j<temp[i].length;j++){
							result[i][j]=temp[i][j];
						}
					}
				}
				for(int i=0;i<5;i++){
					result[m][i]=rs.getString(i+1);
				}
				if(bookread){
					result[m][5]=new Double(rs.getDouble(6));
					result[m][6]=new Integer(rs.getInt(7));
					result[m][7]=new Integer(rs.getInt(8));
					result[m][8]=new Integer(rs.getInt(9));
				}
				else{
					result[m][5]=rs.getString(6);
					result[m][6]=rs.getString(7);
					result[m][7]=new Integer(rs.getInt(8));
				}
				m++;
				progress.setValue(m);progress.setString("查询到"+m+message);
			}
			table.repaint();
			audiourl=getClass().getResource("/sound/Search.wav");
			if(audiourl!=null){
				audio=Applet.newAudioClip(audiourl);
				audio.play();
			}
		}
		catch(SQLException e1){
			JOptionPane.showMessageDialog(this,"已与服务器断开");
		}
	}
	//对列表重新赋值
	private void resettable(){
		for(int i=0;i<result.length;i++){
			for(int j=0;j<q;j++){
				result[i][j]=null;
			}
		}
	}
	//对列表重新赋值
	private void resetbooktable(){
		for(int i=0;i<bookresult.length;i++){
			for(int j=0;j<bookresult[i].length;j++){
				bookresult[i][j]=null;
			}
		}
	}
	//查看读者所借书线程
	class MyThread extends Thread{
		public void run(){
			int selectrow=-1;
			while(true){
				String readerID;
				if(table.getSelectedRowCount()==1&&(readerID=(String)result[table.getSelectedRow()][0])!=null){
					int b=table.getSelectedRow();
					if(b!=selectrow||(b==selectrow&&button)){
						audiourl=getClass().getResource("/sound/Click.wav");
						if(audiourl!=null){
							audio=Applet.newAudioClip(audiourl);
							audio.play();
						}
						int m=0;
					    ResultSet rs;
					    String queue="SELECT * FROM Book_Info,Lend_Book WHERE ReaderCardID = "+readerID+" AND Book_Info.BookID = Lend_Book.BookID";
					    resetbooktable();
						try{
							rs=sql.executeQuery(queue);
							while(rs.next()){
								if(m==bookresult.length){
									Object[][] temp=bookresult;
									container.remove(bookscroll);
									bookresult=new Object[temp.length*2][8];
									booktable=new JTable(bookresult,bookcolumn);
									bookscroll=new JScrollPane(booktable);
									container.add(bookscroll);
									bookscroll.setBounds(0,280,600,160);
									validate();
									for(int i=0;i<temp.length;i++){
										for(int j=0;j<temp[i].length;j++){
											bookresult[i][j]=temp[i][j];
										}
									}
								}
								for(int i=0;i<5;i++){
									bookresult[m][i]=rs.getString(i+1);
								}
								bookresult[m][5]=new Double(rs.getDouble(6));
								bookresult[m][6]=new Integer(rs.getInt(7));
								bookresult[m][7]=new Integer(rs.getInt(8));
								m++;
							}
							booktable.repaint();
							progress2.setValue(m);progress2.setString("借"+m+"本书!");
							button=false;
							selectrow=b;
						}
						catch(SQLException e2){
						}
					}	
			    }
				else{
					progress2.setValue(0);progress2.setString("请选择要查询的读者");
				}
				try{
					Thread.sleep(100);
				}
				catch(InterruptedException e2){
					
				}
			}
		}
	}
	
}