基于java+mysql的Swing+MySQL药品管理系统(java+swing+gui+mysql)

基于java+mysql的Swing+MySQL药品管理系统(java+swing+gui+mysql)

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

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

功能说明

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

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

系统主页：

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

---