bookmatainframe.java

本系统的设计模拟一般学校特别是高校的图书借阅管理内容

					nextButton.setText("下一");
					nextButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							nextPressed();
							//TODO add your code for nextButton.actionPerformed
						}
					});
				}
				{
					lastButton = new JButton();
					jPanel2.add(lastButton);
					lastButton.setText("最后");
					lastButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							lastPressed();
							//TODO add your code for lastButton.actionPerformed
						}
					});
				}
				{
					skimButton = new JButton();
					jPanel2.add(skimButton);
					skimButton.setText("浏览");
					skimButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							skimPressed();
							//TODO add your code for skimButton.actionPerformed
						}
					});
				}
				{
					addButton = new JButton();
					jPanel2.add(addButton);
					addButton.setText("添加");
					addButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							addPressed();
							//TODO add your code for addButton.actionPerformed
						}
					});
				}
				{
					modifyButton = new JButton();
					jPanel2.add(modifyButton);
					modifyButton.setText("修改");
					modifyButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							modifyPressed();
							//TODO add your code for modifyButton.actionPerformed
						}
					});
				}
				{
					deleteButton = new JButton();
					jPanel2.add(deleteButton);
					deleteButton.setText("删除");
					deleteButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							delPressed();
							//TODO add your code for deleteButton.actionPerformed
						}
					});
				}
				{
					refreshButton = new JButton();
					jPanel2.add(refreshButton);
					refreshButton.setText("刷新");
					refreshButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							refreshPressed();
							//TODO add your code for refreshButton.actionPerformed
						}
					});
				}
				{
					closeButton = new JButton();
					jPanel2.add(closeButton);
					closeButton.setText("关闭");
					closeButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							closePressed();
							//TODO add your code for closeButton.actionPerformed
						}
					});
				}
			}
			load();
			setValue();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	void load( ){
		try{			
			Connection conn = bridge.getConnection( );
			manage.setStatement( conn );
			sqlCommand = "select COUNT(*)as count from book where status=\'可借\'";
			rs = manage.executeQuery( sqlCommand );
			if(!rs.next())
				available = 0;
			else
				available = rs.getInt("count");
			sqlCommand = "select COUNT(*)as count from book ";
			rs = manage.executeQuery( sqlCommand );
			int temp;
			if(!rs.next())
				temp = 0;
			else
				temp = rs.getInt("count");
			out = temp - available;
			sqlCommand = "select * from book";
			MySQL ms=new MySQL("sa","","book",null);
			rs=ms.search();
			//rs = manage.executeQuery( sqlCommand );
			rs.next();
						
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
			JOptionPane.showMessageDialog(null,ex.toString(),"错误",JOptionPane.WARNING_MESSAGE);
		}	
	}
	
	void setValue(){
		//填充数据
		try{
			idText.setText( rs.getString(1) );
			nameText.setText( rs.getString( 2 ) );
			statusText.setSelectedItem( rs.getString( 3 ) );
			pressText.setText( rs.getString(4) );
			yearText.setText( rs.getString(5) );
			avaiLabel.setText( String.valueOf(available) );
			outLabel.setText( String.valueOf( out ) );
		}
		catch(Exception ex)
		{
			JOptionPane.showMessageDialog(null,ex.toString(),"错误",JOptionPane.WARNING_MESSAGE);
		}	
	}
	
	private void firstPressed( ){
		try{
			rs.first();
			setValue();
		}
		catch(SQLException ex)
		{
			JOptionPane.showMessageDialog(null,ex.toString(),"错误",JOptionPane.WARNING_MESSAGE);
			ex.printStackTrace();
		}	
	}
	
	private void prePressed( ){
		try{
			rs.previous();
			setValue();
		}
		catch(SQLException ex)
		{
			JOptionPane.showMessageDialog(null,ex.toString(),"错误",JOptionPane.WARNING_MESSAGE);
			ex.printStackTrace();
		}	
	}
	
	private void nextPressed( ){
		try{
			rs.next();
			setValue();
		}
		catch(SQLException ex)
		{
			JOptionPane.showMessageDialog(null,ex.toString(),"错误",JOptionPane.WARNING_MESSAGE);
			ex.printStackTrace();
		}	
	}
	
	private void lastPressed( ){
		try{
			rs.last();
			setValue();
		}
		catch(Exception ex)
		{
			JOptionPane.showMessageDialog(null,ex.toString(),"错误",JOptionPane.ERROR_MESSAGE);
			ex.printStackTrace();
		}	
	}
	
	private void skimPressed( ){
		try{
			ResultSet r,temp;
			sqlCommand = "select * from book where book_name =\'"+nameText.getText()+"\'";
			r = manage.executeQuery( sqlCommand );
			r.next();			
			load();
			temp = rs;
			rs = r;
			setValue();
			rs = temp;
		}
		catch(Exception ex)
		{
			JOptionPane.showMessageDialog(null,ex.toString(),"错误",JOptionPane.ERROR_MESSAGE);
			ex.printStackTrace();
		}	
	}
	
	private void addPressed( ){
	//	try{
	//		ResultSet r;
	//		sqlCommand ="select * from book where book_id =\'"+idText.getText()+"\'";
	//		MySQL ms=new MySQL("sa","",null,sqlCommand);
	//		r=ms.search();
			//r = manage.executeQuery( sqlCommand );
	//		System.out.println("test");
			if(true){
				System.out.println("test");
				sqlCommand = "Insert into book(book_id,book_name,status,press,byear)"+
					"values(\'"+idText.getText()+"\',\'"+nameText.getText()+"\',\'"+(String)statusText.getSelectedItem()+
					"\',\'"+pressText.getText()+"\',\'"+yearText.getText()+"\')";
				System.out.println(sqlCommand);
				MySQL ms2=new MySQL("sa","",null,sqlCommand);
				int i=ms2.input();				
				//manage.executeInsert(sqlCommand);
				System.out.println(sqlCommand);
				if(i!=-1){
					JOptionPane.showMessageDialog(null,"记录添加成功！","恭喜",JOptionPane.INFORMATION_MESSAGE);
				}
			}
			else
				JOptionPane.showMessageDialog(null,"记录已存在！","错误",JOptionPane.ERROR_MESSAGE);
			load();
			setValue();
	//	}
	//	catch(SQLException ex)
	//	{
	//		JOptionPane.showMessageDialog(null,"tianjiacuowu","错误",JOptionPane.ERROR_MESSAGE);
	//		ex.printStackTrace();
	//	}	
	}
	
	private void modifyPressed( ){
		try{
			ResultSet r;
			sqlCommand = "select * from book where book_id =\'"+idText.getText()+"\'";
			MySQL ms=new MySQL("sa","",null,sqlCommand);
			r=ms.search();
			//r = manage.executeQuery( sqlCommand );
			if( !r.next() ){
				JOptionPane.showMessageDialog(null,"记录不存在！","错误",JOptionPane.ERROR_MESSAGE);
			}
			else{
				sqlCommand = "update book set book_name =\'"+nameText.getText()+"\',status =\'"+(String)statusText.getSelectedItem()+
					"\',press = \'"+pressText.getText()+"\',year = \'"+yearText.getText()+"\' where book_id=\'"+idText.getText()+"\'";
				MySQL ms2=new MySQL("sa","",null,sqlCommand);
				ms2.input();
				//r=ms.search();
				//manage.executeUpdate( sqlCommand );
				JOptionPane.showMessageDialog(null,"记录修改成功！","恭喜",JOptionPane.INFORMATION_MESSAGE);
				load();
			}
		}
		catch(SQLException ex)
		{
			JOptionPane.showMessageDialog(null,ex.toString(),"错误",JOptionPane.WARNING_MESSAGE);
			ex.printStackTrace();
		}	
	}
	
	private void delPressed( ){
		try{
			Object[] options = { "确定", "放弃" };
			JOptionPane pane = new JOptionPane("确定删除？", 
					JOptionPane.DEFAULT_OPTION, JOptionPane.WARNING_MESSAGE,
					null, options, options[0]);
			//JOptionPane.showOptionDialog(null, );

			pane.setVisible(true);
			
			if( !pane.getValue().equals("确定")){
				sqlCommand = "delete from book where book_id =\'"+idText.getText()+"\'";
				manage.executeDelete( sqlCommand );
				JOptionPane.showMessageDialog(null,"记录删除成功！","恭喜",JOptionPane.INFORMATION_MESSAGE);
				load();
				setValue();
			}			
		}
		catch(Exception ex)
		{
			JOptionPane.showMessageDialog(null,ex.toString(),"错误",JOptionPane.WARNING_MESSAGE);
			ex.printStackTrace();
		}	
	}
	
	private void refreshPressed( ){
			load();	
			setValue();
	}
	
	private void closePressed( ){
		this.setVisible(false);
	}
	
	/**
	* Auto-generated method for setting the popup menu for a component
	*/
	private void setComponentPopupMenu(
		final java.awt.Component parent,
		final javax.swing.JPopupMenu menu) {
		parent.addMouseListener(new java.awt.event.MouseAdapter() {
			public void mousePressed(java.awt.event.MouseEvent e) {
				if (e.isPopupTrigger())
					menu.show(parent, e.getX(), e.getY());
			}
			public void mouseReleased(java.awt.event.MouseEvent e) {
				if (e.isPopupTrigger())
					menu.show(parent, e.getX(), e.getY());
			}
		});
	}

}