基于java+swing的药品管理系统(java+swing+Gui+mysql)

基于java+swing的药品管理系统(java+swing+Gui+mysql)
功能介绍：用户管理、药品库存管理、进销管理、营销管理、药品购入、药品售出、药市信息

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

	}
	public void getFilter() {
		String username = filterUsernameJTexfd.getText().trim();
		String isAdmin = isAdminJTexfd.getText().trim();
		dtm.setNumRows(0);
		try {
			datas = getFliterEmployeesByDb(username, isAdmin);
			for (int i = 0; i < datas.size(); i++) {
				dtm.addRow(datas.get(i));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	

			@Override
			public void actionPerformed(ActionEvent e) {
				
				try {
					doLogin();
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
			}
		});
		bgPanel.add(southJpanel,BorderLayout.SOUTH);
	}
	
	@SuppressWarnings("deprecation")
	private void doLogin() throws SQLException{
		String username = userName.getText().trim();
		String password = this.password.getText().trim();
		
		
		String sql = "select * from EmployeeInfo "
				+ "where eid=? and password=? and isAdmin=1";
	

		});
		
		loginBtn = new JButton("登录");
		loginBtn.setBackground(Color.lightGray);
		loginBtn.setSize(100, 60);
		southJpanel.add(loginBtn);
		loginBtn.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				
				try {
					doLogin();
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
			}
		});
		bgPanel.add(southJpanel,BorderLayout.SOUTH);
	}
	
	@SuppressWarnings("deprecation")

	if (e.getSource()==select){
		int intRetVal=fc.showOpenDialog(this);
		if(intRetVal==JFileChooser.APPROVE_OPTION){
		file=fc.getSelectedFile();	
		textfield.setText(file.getPath());
		}
	}
	if(e.getSource()==btnOk){
		JFrame f=new JFrame();
		f.setSize(500, 370);
		f.setLocationRelativeTo(null);
		f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		f.setVisible(true);
		area=new JTextPane();

		String sql = "delete from EmployeeInfo where eid='"+eid+"';";
		boolean result = new SqlHelper().update(sql, new String[]{});
		if (result) {
			refreshJTable(currntPage + 1, pageSize);
		}else{
			JOptionPane.showConfirmDialog(null, "删除失败!","提示",JOptionPane.WARNING_MESSAGE);
			
		}
	
	}
	class PageClick implements ActionListener {
		@Override
		public void actionPerformed(ActionEvent e) {

				comfirmDelete();
			}
		});
       updateButton.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				int selectIndex = empJtable.getSelectedRow();
				if(selectIndex == -1){
					JOptionPane.showConfirmDialog(null, "请先选中一行","提示",JOptionPane.WARNING_MESSAGE);
					
				}else{
					Object[] row = datas.get(selectIndex);
					String eid = (String) row[0];
					
					new UpdateEmployeeView(eid, EmployeeManagerView.this);
				}

	 */
	@SuppressWarnings("serial")
	public void buildUi(){
		bgPanel = new JPanel(){
			public void paintComponent(Graphics g) {  
		        super.paintComponent(g);  
		        ImageIcon icon;  
			    Image img; 
				icon = new ImageIcon("E:\\图片册\\lvu.jpg");// 背景图片 
				img = icon.getImage();
		       
		        g.drawImage(img, 0, 0,this.getWidth(), this.getHeight(), this);  
		    } 
		};
		
		

			} else if (button.equals(nextButton)) {
				if (currntPage < pageCount-1) {
					currntPage++;
				}
			} else if (button.equals(lastButton)) {
				if (currntPage < pageCount-1) {
					currntPage = pageCount;
				}
			}
			refreshJTable(currntPage * pageSize, pageSize);
		}
	}
系统主页：
@SuppressWarnings("serial")
public class SystemMainView extends JFrame implements ActionListener{
JButton button,btnOk,select;
JScrollPane jsp;
JTextPane area=new JTextPane();
JTextField textfield;
JFileChooser fc=new JFileChooser();
File file=null;
ImageIcon imageIcon=new ImageIcon("E:\\图片册\\lan.jpg");
 public SystemMainView(){
 setTitle("药品管理系统");

	}
	public void componentResized(ComponentEvent e) {
		System.out.println(getWidth()+"X"+ getHeight());
		
		ImageIcon background = new ImageIcon("E:\\图片册\\lvu.jpg");// 背景图片 
		JLabel label = new JLabel(background);// 把背景图片显示在一个标签里面  
		  // 把标签的大小位置设置为图片刚好填充整个面板  
		  label.setBounds(0, 0, getWidth(),  
				  getHeight());  
		  JPanel imagePanel = (JPanel) getContentPane();  
		  imagePanel.setOpaque(false);  
		  // 内容窗格默认的布局管理器为BorderLayout  
		  getLayeredPane().add(label, new Integer(Integer.MIN_VALUE));
	}
	@Override
	public void componentMoved(ComponentEvent e) {
		
	}
	public void componentShown(ComponentEvent e) {

		bottomAllJpane.add(bottomJpanel, BorderLayout.SOUTH);
		
		add(bottomAllJpane, BorderLayout.SOUTH);
		
		newButton.addActionListener(new ActionListener() {
			@Override
			public void actionPerformed(ActionEvent e) {
				AddEmployeeView aev = new AddEmployeeView(EmployeeManagerView.this);
			}
		});
		deleteButton.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
//				deleteEmployee();
				comfirmDelete();

	private JTable empJtable = new JTable(dtm);
	private JScrollPane centerJscrollPane = new JScrollPane(empJtable);
	private JPanel bottomAllJpane = new JPanel();
	private JPanel bottonPageJpanel = new JPanel(){
		public void paintComponent(Graphics g) {  
	        super.paintComponent(g);  
	        ImageIcon icon;  
		    Image img; 
			icon = new ImageIcon("E:\\图片册\\pu.jpg");// 背景图片 
			img = icon.getImage();
	        g.drawImage(img, 0, 0,this.getWidth(), this.getHeight(), this);
	        } 
	};
	private JButton firstButton, lastButton, preButton, nextButton;
	private JLabel pageInfoLagel;

				}
									
			}
		});
		topJpanel.add(filterUserNameJLable);
		filterUserNameJLable.setFont(new Font("Dialog",1,13));
		topJpanel.add(filterUsernameJTexfd);
		topJpanel.add(isAdminJLabel);
		isAdminJLabel.setFont(new Font("Dialog",1,13));
		topJpanel.add(isAdminJTexfd);
		topJpanel.add(searchBtn);
		searchBtn.setFont(new Font("Dialog",1,13));
		searchBtn.setBackground(Color.green);
		add(topJpanel, BorderLayout.NORTH);
		searchBtn.addActionListener(new ActionListener() {
			@Override
			public void actionPerformed(ActionEvent e) {
				getFilter();
			}
		});
	
	pageCount = dataSum  / pageSize;
	if (dataSum % pageSize >0) {
		pageCount ++;
	}
	refreshJTable(currntPage + 1, pageSize);
}