// 客户增加事件处理Zengjia1.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Zengjia1) {new Kehutianjia(table1);}}});// 客户删除事件处理Shanchu1.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Shanchu1) {int i = 0;i = table1.getSelectedRow();if (i < 0) {JOptionPane.showMessageDialog(null, "请选择表数据后再执行此操作!","系统提示", JOptionPane.WARNING_MESSAGE);} else {String NO = (String) table1.getValueAt(i, 0);int n = JOptionPane.showConfirmDialog(null, "确认删除吗?","确认删除框", JOptionPane.YES_NO_OPTION);if (n == JOptionPane.YES_OPTION) {String sqlStr = null;sqlStr = "DELETE FROM jj2 WHERE id='" + NO+ "'";new JdbcAdapter().AdapterObject(sqlStr);table1.setModel(new JdbcAdapter().buildTablekehu());JOptionPane.showMessageDialog(null, "删除客户信息成功","系统提示", JOptionPane.INFORMATION_MESSAGE);} else {if (n == JOptionPane.NO_OPTION) {return;}}}}}});// 客户修改事件处理Xiugai1.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Xiugai1) {int i = table1.getSelectedRow();if (i < 0) {JOptionPane.showMessageDialog(null, "请选择表数据后再执行此操作!","系统提示", JOptionPane.WARNING_MESSAGE);} else {new KeHuXiuGai(i, table1);}}}});// 客户查找事件处理Chaxun1.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Chaxun1) {String sql = "SELECT * FROM jj2 WHERE id= '" + ChaxunText.getText() + "'";con = CommonJdbc.getCon();table1.setModel(new JdbcAdapter().buildTablekehu(sql));table1(table1);}}});// 汽车增加事件处理Zengjia2.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Zengjia2) {new CheliangZengJia(table2);}}});// 汽车删除事件处理Shanchu2.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Shanchu2) {int i = 0;i = table2.getSelectedRow();if (i < 0) {JOptionPane.showMessageDialog(null, "请选择表数据后再执行此操作!","系统提示", JOptionPane.WARNING_MESSAGE);} else {String NO = (String) table2.getValueAt(i, 0);int n = JOptionPane.showConfirmDialog(null, "确认删除吗?","确认删除框", JOptionPane.YES_NO_OPTION);if (n == JOptionPane.YES_OPTION) {String sqlStr = null;sqlStr = "DELETE FROM jj3 WHERE id='" + NO+ "'";new JdbcAdapter().AdapterObject(sqlStr);table2.setModel(new JdbcAdapter().buildTablecheliang());JOptionPane.showMessageDialog(null, "删除汽车信息成功","系统提示", JOptionPane.INFORMATION_MESSAGE);} else {if (n == JOptionPane.NO_OPTION) {return;}}}}}});// 汽车修改事件处理Xiugai2.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Xiugai2) {int i = table2.getSelectedRow();if (i < 0) {JOptionPane.showMessageDialog(null, "请选择表数据后再执行此操作!","系统提示", JOptionPane.WARNING_MESSAGE);} else {new CheliangXiuGai(i, table2);}}}});// 汽车查找事件处理Chaxun2.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Chaxun2) {String sql = "SELECT * FROM jj3 WHERE id= '" + ChaxunText2.getText() + "'";con = CommonJdbc.getCon();table2.setModel(new JdbcAdapter().buildTablecheliang(sql));table2(table2);}}});// 管理员增加事件处理Zengjia3.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Zengjia3) {new Guanliyuantianjia(table3);}}});// 管理员删除事件处理Shanchu3.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Shanchu3) {int i = 0;i = table3.getSelectedRow();if (i < 0) {JOptionPane.showMessageDialog(null, "请选择表数据后再执行此操作!","系统提示", JOptionPane.WARNING_MESSAGE);} else {String NO = (String) table3.getValueAt(i, 0);int n = JOptionPane.showConfirmDialog(null, "确认删除吗?","确认删除框", JOptionPane.YES_NO_OPTION);if (n == JOptionPane.YES_OPTION) {String sqlStr = null;sqlStr = "DELETE FROM jj4 WHERE id='" + NO+ "'";new JdbcAdapter().AdapterObject(sqlStr);table3.setModel(new JdbcAdapter().buildTableguanliyuan());JOptionPane.showMessageDialog(null, "删除商品信息成功","系统提示", JOptionPane.INFORMATION_MESSAGE);} else {if (n == JOptionPane.NO_OPTION) {return;}}}}}});// 管理员修改事件处理Xiugai3.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Xiugai3) {int i = table3.getSelectedRow();if (i < 0) {JOptionPane.showMessageDialog(null, "请选择表数据后再执行此操作!","系统提示", JOptionPane.WARNING_MESSAGE);} else {new CheliangXiuGai(i, table3);}}}});// 管理员查找事件处理Chaxun3.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {if (e.getSource() == Chaxun3) {String sql = "SELECT * FROM jj4 WHERE id= '" + ChaxunText3.getText() + "'";con = CommonJdbc.getCon();table3.setModel(new JdbcAdapter().buildTableguanliyuan(sql));table3(table3);}}});// 系统退出frame.addWindowListener(new WindowAdapter() {public void windowClosing(WindowEvent arg0) {System.exit(0);}});pan1.add(scr1);pan2.add(scr2);pan3.add(scr3);cont.add(tab);tab.setBounds(0, 0, 80, 700);frame.setSize(980, 700);frame.setLocation(200, 30);frame.setVisible(true);frame.setResizable(false); // 禁止改变窗体大小}// 客户资料表格public void table1(JTable table1) {table1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);TableColumnModel cm = table1.getColumnModel(); // 表格的列模型TableColumn column = cm.getColumn(0); // 得到第i个列对象TableColumn column1 = cm.getColumn(1);TableColumn column2 = cm.getColumn(2);TableColumn column3 = cm.getColumn(3);TableColumn column4 = cm.getColumn(4);TableColumn column5 = cm.getColumn(5);column.setPreferredWidth(80); // 将此列的首选宽度设置为 preferredWidth。如果// preferredWidth// 超出最小或最大宽度,则将其调整为合适的界限值。column1.setPreferredWidth(100);column2.setPreferredWidth(150);column3.setPreferredWidth(150);column4.setPreferredWidth(150);column5.setPreferredWidth(100);table1.getTableHeader().setReorderingAllowed(false); // 设置表的列不可拖动}// 汽车信息表格public void table2(JTable table2) {table2.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);TableColumnModel cm = table2.getColumnModel(); // 表格的列模型TableColumn column = cm.getColumn(0); // 得到第i个列对象TableColumn column1 = cm.getColumn(1);TableColumn column2 = cm.getColumn(2);TableColumn column3 = cm.getColumn(3);TableColumn column4 = cm.getColumn(4);TableColumn column5 = cm.getColumn(5);column.setPreferredWidth(80); // 将此列的首选宽度设置为 preferredWidth。如果// preferredWidth// 超出最小或最大宽度,则将其调整为合适的界限值。column1.setPreferredWidth(100);column2.setPreferredWidth(100);column3.setPreferredWidth(100);column4.setPreferredWidth(100);column5.setPreferredWidth(150);table2.getTableHeader().setReorderingAllowed(false); // 设置表的列不可拖动}// 管理员信息表格public void table3(JTable table3) {table3.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);TableColumnModel cm = table3.getColumnModel(); // 表格的列模型TableColumn column = cm.getColumn(0); // 得到第i个列对象TableColumn column1 = cm.getColumn(1);TableColumn column2 = cm.getColumn(2);TableColumn column3 = cm.getColumn(3);TableColumn column4 = cm.getColumn(4);TableColumn column5 = cm.getColumn(5);column.setPreferredWidth(80); // 将此列的首选宽度设置为 preferredWidth。如果// preferredWidth// 超出最小或最大宽度,则将其调整为合适的界限值。column1.setPreferredWidth(100);column2.setPreferredWidth(100);column3.setPreferredWidth(100);column4.setPreferredWidth(100);column5.setPreferredWidth(100);table3.getTableHeader().setReorderingAllowed(false); // 设置表的列不可拖动}// 设置Timer 1000ms实现一次动作 实际是一个线程 自动获取系统事件private void setTimer(JTextField time) {final JTextField varTime = time;Timer timeAction = new Timer(1000, new ActionListener() {public void actionPerformed(ActionEvent e) {long timemillis = System.currentTimeMillis();// 转换日期显示格式SimpleDateFormat df = new SimpleDateFormat(" yyyy-MM-dd HH:mm:ss ");varTime.setText(df.format(new Date(timemillis)));}});timeAction.start();}static {try {UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());} catch (Exception e) {e.printStackTrace();}}public static void main(String args[]) {new zhuchuangti();}}
添加回答
举报
0/150
提交
取消