Java项目:药品管理系统(java+swing+Gui+mysql)

最新推荐文章于 2024-07-09 14:44:04 发布

beyondwild

最新推荐文章于 2024-07-09 14:44:04 发布

阅读量1.3k

点赞数 5

分类专栏： Java毕业设计项目实战篇文章标签： java mysql swing Gui

本文链接：https://blog.csdn.net/yuyecsdn/article/details/122403360

版权

Java毕业设计项目实战篇专栏收录该内容

916 篇文章 716 订阅

订阅专栏

源码获取：博客首页 "资源" 里下载！

功能介绍：用户管理、药品库存管理、进销管理、营销管理、药品购入、药品售出、药市信息

系统主页：

@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("药品管理系统");
 
 

  this.setSize( 900, 500);
  setResizable(false);
  setLocationRelativeTo(null);
  layoutUI();
  this.setVisible(true);
 }
 
 private void layoutUI(){

  //对象实例化
  JTabbedPane tab = new JTabbedPane(JTabbedPane.TOP); 
  //容器
  Container container = this.getLayeredPane();
  //对象化面板
  JPanel combop = new JPanel(){
		public void paintComponent(Graphics g) {
			super.paintComponent(g);
			ImageIcon icon=new ImageIcon("E:\\图片册\\pu.jpg");
			g.drawImage(icon.getImage(), 0, 0, null);
		}
	};
  JPanel p1 = new EmployeeManagerView();
  JPanel p2 = new Medicine();
  JPanel p3 = new MarketView();
  JPanel p4 = new MarketMessage();
  JPanel p5 = new JPanel(){
		public void paintComponent(Graphics g) {
			super.paintComponent(g);
			ImageIcon icon=new ImageIcon("E:\\图片册\\pu.jpg");
			g.drawImage(icon.getImage(), 0, 0, null);
		}
	};
	p5.add(new JButton("药品信息百科"));
	textfield=new JTextField(10);
	p5.add(textfield);
	select=new JButton("浏览");
	p5.add(select);
	select.addActionListener(this);
	p5.add(btnOk=new JButton("确定"));
	btnOk.addActionListener(this);
 
 

  tab.add(p1,"        用户管理         ");
  tab.add(p2,"       药品库存管理    ");
  tab.add(p3,"        进销管理         ");
  tab.add(p4,"       营销信息         ");
//  tab.add(p5,"       问答园地         ");
  tab.setBackground(Color.green);
  tab.setFont(new Font("Dialog",1,17));
  JLabel JL = new JLabel("药品管理系统");
  combop.add(JL);
  JL.setFont(new Font("Dialog",1,23));
  JL.setBackground(Color.green);
  container.setLayout(new BorderLayout());
  container.setBackground(Color.cyan);
  container.add(combop,BorderLayout.NORTH);
  container.add(tab,BorderLayout.CENTER);
  
 }

public void actionPerformed(ActionEvent e){
	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();
		jsp=new JScrollPane(area);
		jsp.getViewport().setBackground(Color.green);
		area.setBackground(Color.cyan);
		area.setOpaque(false);
		//area.setLineWrap(true);
		//area.setWrapStyleWord(true);
		f.add(jsp);
		
		try{
			readFile(area);
		}catch(Exception ex){
			
		}
	}
}
private void readFile(JTextPane area)throws Exception{
	
	if(file !=null){
		FileReader fr=new FileReader(file);
		BufferedReader br=new BufferedReader(new InputStreamReader(new FileInputStream(file),"GBK"));
		try{
			
			while (br.ready()){
				area.setText(area.getText()+br.readLine()+"\r\n");
			}
		}finally{
			br.close();
			fr.close();
		}
	}
}
}

登录服务类：

public class LoginView extends JFrame implements ComponentListener{

	private JPanel centerJpanel;
	private JTextField userName;
	private JPasswordField password;
	private JLabel label1;
	private JLabel label2;
	private JPanel southJpanel;
	private JButton loginBtn;
	private JButton regiestBtn;
	
	private JPanel bgPanel;
	public LoginView() {
		setTitle("登录");
//		
		buildUi();
		
		setSize(380, 400);
		setLocationRelativeTo(null);
		setResizable(false);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setVisible(true);
	}
	

	
	/**
	 * 初使化界面
	 */
	@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);  
		    } 
		};
		
		
		add(bgPanel);
		bgPanel.setLayout(new BorderLayout(20,20));
		
		//实例化中间容器
		
		centerJpanel = 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);
		        } 
		};
		//实例化用户名密码控件
		label1=new JLabel("用户：");
		label1.setFont(new Font("Dialog",1,15));
		userName = new JTextField(24);
		label2=new JLabel("密码：");
		label2.setFont(new Font("Dialog",1,15));
		password = new JPasswordField(24);
		
		//添加用户名密码控件到 中间容器中
		centerJpanel.add(label1);
		centerJpanel.add(userName);
		centerJpanel.add(label2);
		centerJpanel.add(password);
		centerJpanel.setBackground(null);
		//实列化欢迎字，并添加到根容器的北边
		
		JLabel label3 = new JLabel("药品管理系统");
		label3.setHorizontalAlignment(JLabel.CENTER);
		label3.setFont(new Font("Dialog",1,20));
		label3.setForeground(Color.green);
		label3.setBackground(Color.white);
		bgPanel.add(label3,BorderLayout.NORTH);
		//添加中间容器到根容器的中间
		bgPanel.add(centerJpanel,BorderLayout.CENTER);
		
		
		southJpanel = new JPanel();
		southJpanel.setBackground(Color.white);
		regiestBtn = new JButton("注册");
		regiestBtn.setBackground(Color.lightGray);
		regiestBtn.setSize(100, 60);
		southJpanel.add(regiestBtn);
		southJpanel.setBackground(Color.white);
		regiestBtn.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				new RegiestView();
				
			}
		});
		
		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")
	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";
	
		SqlHelper sqlHelper = new SqlHelper();
		ResultSet result = sqlHelper.
				query(sql, new String[]{username,password});
		if (result.next()) {
			//登录成功
			new SystemMainView();
			dispose();
		}else{
			JOptionPane.showConfirmDialog(null, "您不是管理员    无法登陆！","提示",JOptionPane.WARNING_MESSAGE);
			
		}
	
	}
	
	public static void main(String[] args) {
		new LoginView();
	}
	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) {
		
	}

	@Override
	public void componentHidden(ComponentEvent e) {
		
	}
	

}

员工管理控制层：

public class EmployeeManagerView extends JPanel {

	private DefaultTableModel dtm = new DefaultTableModel();
	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;
	private JPanel bottomJpanel = new JPanel(){
		public void paintComponent(Graphics g) {  
	        super.paintComponent(g);  
	        ImageIcon icon;  
		    Image img; 
			icon = new ImageIcon("E:\\图片册\\puu.jpg");// 背景图片 
			img = icon.getImage();
	        g.drawImage(img, 0, 0,this.getWidth(), this.getHeight(), this);
	        } 
	};
	private JButton newButton, updateButton, deleteButton;
	
	private JPanel topJpanel = 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 JLabel filterUserNameJLable = new JLabel("员工id/员工姓名");
	private JTextField filterUsernameJTexfd = new JTextField(12);
	private JLabel isAdminJLabel = new JLabel("身份（管理员/普通员工）");
	
	private JTextField isAdminJTexfd = new JTextField(12);

	private JButton searchBtn = new JButton("查找");
	
	private ArrayList<Object[]> datas = null;
	int pageSize = 3; // 每页显示条数
	int dataSum = 0; // 总的数据条数
	int pageCount = 0; // 总页数
	int currntPage = 0; // 当前页数

	public EmployeeManagerView() {
		setLayout(new BorderLayout());
		add(centerJscrollPane, BorderLayout.CENTER);
		dtm.addColumn("员工id");
		dtm.addColumn("名称");
		dtm.addColumn("姓别");
		dtm.addColumn("入职日期");
		dtm.addColumn("年龄");
		dtm.addColumn("是否管理");
		try {
			dataSum = getDataCount();
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		
		bottomAllJpane.setLayout(new BorderLayout());
		bottomAllJpane.setPreferredSize(new Dimension(900,240));
		bottomAllJpane.add(bottonPageJpanel, BorderLayout.CENTER);

		firstButton = new JButton("首页");
		firstButton.setBackground(Color.green);
		lastButton = new JButton("尾页");
		lastButton.setBackground(Color.green);
		preButton = new JButton("上一页");
		preButton.setBackground(Color.green);
		nextButton = new JButton("下一页");
		nextButton.setBackground(Color.green);
		pageInfoLagel = new JLabel(" ");
		pageInfoLagel.setOpaque(true);
		pageInfoLagel.setFont(new Font("Dialog",1,18));
		
		bottonPageJpanel.add(firstButton);
		bottonPageJpanel.add(preButton);
		bottonPageJpanel.add(nextButton);
		bottonPageJpanel.add(lastButton);
		bottonPageJpanel.add(pageInfoLagel);
		firstButton.addActionListener(new PageClick());
		lastButton.addActionListener(new PageClick());
		preButton.addActionListener(new PageClick());
		nextButton.addActionListener(new PageClick());
		//refreshJTable();

		newButton = new JButton("新增用户");
		newButton.setBackground(Color.green);
		newButton.setFont(new Font("Dialog",1,15));
		updateButton = new JButton("修改用户");
		updateButton.setBackground(Color.green);
		updateButton.setFont(new Font("Dialog",1,15));
		deleteButton = new JButton("删除用户");
		deleteButton.setBackground(Color.green);
		deleteButton.setFont(new Font("Dialog",1,15));
		bottomJpanel.add(newButton);
		bottomJpanel.add(updateButton);
		bottomJpanel.add(deleteButton);
		bottomJpanel.setPreferredSize(new Dimension(900,80));
		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();
			}
		});
       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);
				}
									
			}
		});

		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);

}
	/**
	 * 查找所有员工
	 * 
	 * @return
	 * @throws SQLException
	 */
	private ArrayList<Object[]> getEmployeesByDb(int begin, int size) throws SQLException {
		ArrayList<Object[]> employeeslist = new ArrayList<Object[]>();
		// 查询sql语句
		String sql = "select * from EmployeeInfo limit " + begin + "," + size + "";
		// 查询数据
		ResultSet result = new SqlHelper().query(sql, new String[] {});
		if (result != null) {
			while (result.next()) {
				Object rows[] = new Object[6];
				rows[0] = result.getString(1);
				rows[1] = result.getString(3);
				rows[2] = result.getString(4).equals("0") ? "女" : "男";
				rows[3] = result.getString(5);
				rows[4] = result.getString(6);
				rows[5] = result.getString(7).equals("0") ? "普通员工" : "管理员";
				employeeslist.add(rows);
			}

		} else {
			JOptionPane.showConfirmDialog(null, "没有查询到员工", "提示", JOptionPane.WARNING_MESSAGE);

		}
		return employeeslist;
	}
	private int getDataCount() throws SQLException {
		int count = 0;
		String sql = "select count(*) as count from EmployeeInfo";
		// 查询数据
		ResultSet result = new SqlHelper().query(sql, new String[] {});
		if (result != null && result.next()) {
				count = result.getInt(1);

		}
		return count;
	}

	@SuppressWarnings("unused")
	private void printPageInfo(){
		String pageInfo = "当前页数"+(currntPage+1) +"  /"+" 总页数   "+pageCount;
		pageInfoLagel.setText(pageInfo);
	}
	
	/**
	 * 刷新表格数据
	 */
	public void refreshJTable(int begin, int size) {
		dtm.setNumRows(0);
		try {
			datas = getEmployeesByDb(begin, size);
			for (int i = 0; i < datas.size(); i++) {
				dtm.addRow(datas.get(i));
			}

		} catch (SQLException e) {
			e.printStackTrace();
		}
      printPageInfo();
	}

	/**
	 * 过滤查找员工
	 * 
	 * @return
	 * @throws SQLException
	 */
	private ArrayList<Object[]> getFliterEmployeesByDb(String username, String isAdmin) throws SQLException {
		ArrayList<Object[]> employeeslist = new ArrayList<Object[]>();
		// 查询sql语句
		String sql = "select * from EmployeeInfo where (eid like '%" + username + "%'  or  ename like '%" + username
				+ "%') ";
		// 查询数据
		ResultSet result = null;
		if (isAdmin == null || isAdmin.equals("") ) {
			sql += ";";
			result = new SqlHelper().query(sql, new String[] {});
	} else {

			sql += " and isAdmin = '" + isAdmin + "';";
			result = new SqlHelper().query(sql, new String[] {});
		}

		if (result != null) {
			while (result.next()) {
				Object rows[] = new Object[6];
				rows[0] = result.getString(1);
				rows[1] = result.getString(3);
				rows[2] = result.getString(4).equals("0") ? "女" : "男";
				rows[3] = result.getString(5);
				rows[4] = result.getString(6);
				rows[5] = result.getString(7).equals("0") ? "普通员工" : "管理员";
				employeeslist.add(rows);
			}

		} else {
			JOptionPane.showConfirmDialog(null, "没有查询到员工", "提示", JOptionPane.WARNING_MESSAGE);

		}
		return employeeslist;
	}

	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();
		}
	}
	
	private void comfirmDelete(){
		int i = JOptionPane.showConfirmDialog(null, "您确认要删除吗？",
				"提示",JOptionPane.OK_CANCEL_OPTION);
		if(i == 0){
			deleteEmployee();
		}
	}
	
	
	/**
	 * 删除员工
	 */
	private void deleteEmployee(){
		int selectIndex = empJtable.getSelectedRow();
		
		if(selectIndex == -1){
			JOptionPane.showConfirmDialog(null, "请先选中一行","提示",JOptionPane.WARNING_MESSAGE);
			
		}else{
			Object[] row = datas.get(selectIndex);
			String eid = (String) row[0];
			deleteEmployeeById(eid);
		}
			
	}
	
	private void deleteEmployeeById(String eid){
		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) {
			JButton button = (JButton) e.getSource();
			if (button.equals(firstButton)) {
				if (currntPage != 0) {
					currntPage = 0;
				}
			} else if (button.equals(preButton)) {
				if (currntPage > 0) {
					currntPage--;
				}
			} 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);

		}
	}

}

源码获取：博客首页 "资源" 里下载！

beyondwild

关注

5
点赞
踩
23

收藏

觉得还不错? 一键收藏
打赏
8
评论
Java项目:药品管理系统(java+swing+Gui+mysql)

源码获取：博客首页 "资源" 里下载！功能介绍：用户管理、药品库存管理、进销管理、营销管理、药品购入、药品售出、药市信息系统主页：@SuppressWarnings("serial")public class SystemMainView extends JFrame implements ActionListener{JButton button,btnOk,select;JScrollPane jsp;JTextPane area=new JTextPa...
复制链接

扫一扫