基于java+swing的药品管理系统(java+swing+Gui+mysql)
功能介绍：用户管理、药品库存管理、进销管理、营销管理、药品购入、药品售出、药市信息
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
}
/**
* 刷新表格数据
*/
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();
}
/**
* 过滤查找员工
*/
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);
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++;
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("尾页");
* @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("") ) {
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);
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," 进销管理 ");
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);
}
/**
* 刷新表格数据
*/
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));
}
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[]{});
}
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) {
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) {
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);
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());
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();
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();
}
}
}
}
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);
}
}
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));
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);
}
};
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(){
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");// 背景图片
}
} 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);
/**
* 过滤查找员工
*
* @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[] {});
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("尾页");
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 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);
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," 营销信息 ");
1129
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
