基于java+swing+mysql眼镜店管理系统

package glasses; import javax.swing.*; import javax.swing.table.DefaultTableModel; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.util.List; public class MainFrame extends JFrame { JLabel jLabel = new JLabel("请输入眼镜名称"); JTextField jtextField = new JTextField(); JButton selBtn = new JButton("查询"); JButton addBtn = new JButton("添加"); JButton modBtn = new JButton("修改"); JButton delBtn = new JButton("删除"); DefaultTableModel model = new DefaultTableModel();//新建列表 JTable jTable = new JTable(model); JScrollPane jScrollPane = new JScrollPane(jTable,20,30); GlassesDao salaryDao = new GlassesDao(); MainFrame frame = this; public void btnAlistener(){//按钮监听 selBtn.addActionListener(new ActionListener() {//查询按钮监听事件 @Override public void actionPerformed(ActionEvent e) { String text = jtextField.getText();//获取查询框中的内容 List<Glasses> list; if (text.equals("")){ list = salaryDao.findAll();//查询所有信息，返回眼镜信息。 }else{ list = salaryDao.selectName(text);//根据眼镜名称，查询信息 } Object [][] objectes = new Object[list.size()][6]; for (int i = 0; i < list.size(); i++) { objectes[i][0] = list.get(i).id; objectes[i][1] = list.get(i).name; objectes[i][2] = list.get(i).type; objectes[i][3] = list.get(i).price; objectes[i][4] = list.get(i).num; objectes[i][5] = list.get(i).note; } Object [][] data1 = objectes; Object [] table = {"编号","眼镜名称","眼镜类型","价格","库存","备注"}; model.setDataVector(data1,table);//将数据填充列表中 } }); //添加按钮监听事件 addBtn.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { new addFrame(frame); } }); //修改按钮监听事件 modBtn.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { int i = jTable.getSelectedRow(); if(i>=0) { int index1 = jTable.getSelectedRow();//获取选中的行 int id = (Integer) jTable.getValueAt(index1, 0); String name = (String) jTable.getValueAt(i, 1); String dep = (String) jTable.getValueAt(i, 2); String position = (String) jTable.getValueAt(i, 3); String salary = (String) jTable.getValueAt(i, 4); String sentdate = (String) jTable.getValueAt(i, 5); System.out.print(id); updateFrame modFrame= new updateFrame(frame);//新建修改页面 modFrame.jTextField0.setText(id+"");//将数据填充修改页面 modFrame.jTextField1.setText(name); modFrame.jTextField2.setText(dep); modFrame.jTextField3.setText(position); modFrame.jTextField4.setText(salary); modFrame.jTextField5.setText(sentdate); }else { JOptionPane.showMessageDialog(null,"请选择要修改的记录"); } } }); //删除按钮监听事件 delBtn.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { int i = jTable.getSelectedRow(); if(i>=0) { int index1 = jTable.getSelectedRow();//获取选中的行 int id = (Integer) jTable.getValueAt(index1, 0); System.out.print(id); int j = salaryDao.Del(id);//根据id删除数据 if(j>0) { JOptionPane.showMessageDialog(null,"删除记录成功"); setJSP(); } }else { JOptionPane.showMessageDialog(null,"请选择要删除的记录"); } } }); } public void setSizeCpn(){ jLabel.setBounds(100,20,200,100); jtextField.setBounds(315,50,200,40); selBtn.setBounds(530,50,80,40); addBtn.setBounds(250,500,80,40); modBtn.setBounds(350,500,80,40); delBtn.setBounds(450,500,80,40); jScrollPane.setBounds(40,120,700,380); } public void setJSP(){ Object [][] data = getTdata(); Object [] table = {"编号","眼镜名称","眼镜类型","价格","库存","备注"}; model.setDataVector(data,table); } //获取所有数据 public Object[][] getTdata(){ List<Glasses> list = salaryDao.findAll(); Object [][] objects = new Object[list.size()][6]; for (int i = 0; i < list.size(); i++) { objects[i][0] = list.get(i).id; objects[i][1] = list.get(i).name; objects[i][2] = list.get(i).type; objects[i][3] = list.get(i).price; objects[i][4] = list.get(i).num; objects[i][5] = list.get(i).note; } return objects; } public void addCpn(){ add(jLabel); add(jtextField); add(selBtn); add(addBtn); add(modBtn); add(delBtn); add(jScrollPane); } public void setFont(){ Font font = new Font("黑体",Font.BOLD,25); jLabel.setFont(font); Font font1 = new Font("黑体",Font.BOLD,20); selBtn.setFont(font1); addBtn.setFont(font1); modBtn.setFont(font1); delBtn.setFont(font1); } public void login(){ setFont(); setSizeCpn(); addCpn(); setJSP(); btnAlistener(); } public MainFrame() { setLayout(null); login(); setTitle("眼镜店管理系统"); setSize(800,600); setLocationRelativeTo(null); setVisible(true); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } public static void main(String[] args) { new MainFrame(); } }