department_ui.java

桌面销售管理系统 JDBC的基本应用

import javax.swing.JPanel;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import javax.swing.JScrollPane;
import javax.swing.JLabel;
import javax.swing.JButton;
import javax.swing.JTextField;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.sql.SQLException;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import dal.Department;
import javax.swing.BorderFactory;
import java.awt.BorderLayout;
public class Department_UI extends JPanel
{
	String id;
	String[] columns={"编号","名称","备注"};
	DefaultTableModel model=new DefaultTableModel(columns,0);//声明表格模型对象
	JTable table=new JTable(model);//声明表格对象
	
	JLabel l1=new JLabel("部门名称:");
	JLabel l2=new JLabel("备        注:");
	JLabel l3=new JLabel("要删除的部门为:");
	JLabel l4=new JLabel("请输入部门名称:");
	JTextField txt_name=new JTextField(12);
	JTextField txt_name1=new JTextField(12);
	JTextField txt_remark=new JTextField(12);
	JTextField txt_key=new JTextField(12);
	JButton b1=new JButton("添加新部门");
	JButton b2=new JButton("修改选中部门");
	JButton b3=new JButton("删除所选部门");
	JButton b4=new JButton("查询部门");
	Department_UI()
	{
		bind("");//调用bind()方法绑定数据
		JScrollPane p_top=new JScrollPane(table);//整个窗口上边面板
		JPanel p_bottom=new JPanel();//整个窗口下边面板
		this.setLayout(new GridLayout(2,1));
		this.add(p_top);
		this.add(p_bottom);
		JPanel p1=new JPanel(new GridLayout(3,1));//下边左边一部分
		JPanel p2=new JPanel(new GridLayout(2,1));//下边右边一部分
		p1.setBorder(BorderFactory.createTitledBorder("添加和修改部门"));
		p2.setBorder(BorderFactory.createTitledBorder("删除和查询部门"));
		p_bottom.setLayout(new GridLayout(1,2));
		p_bottom.add(p1);
		p_bottom.add(p2);
		JPanel p1_1=new JPanel();
		JPanel p1_2=new JPanel();
		JPanel p1_3=new JPanel();
		p1.add(p1_1);
		p1.add(p1_2);
		p1.add(p1_3);
		p1_1.add(l1);
		p1_1.add(txt_name);
		p1_2.add(l2);
		p1_2.add(txt_remark);
		p1_3.add(b1);
		p1_3.add(b2);
		//p2面板准备东西
		JPanel p2_1=new JPanel();
		JPanel p2_2=new JPanel();
		JPanel p2_3=new JPanel();
		p2.add(p2_1);
		p2.add(p2_2);
		p2_1.add(l3);
		p2_1.add(txt_name1);
		p2_1.add(b3);
		p2_2.add(l4);
		p2_2.add(txt_key);
		p2_2.add(b4);
		//添加事件
		b1.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				String name=txt_name.getText();
				String remark=txt_remark.getText();
				if(Department.add(name,remark))
				{
					JOptionPane.showMessageDialog(null,"恭喜你，添加成功！");
					bind("");
					txt_name.setText("");
					txt_remark.setText("");
				}
				else
				{
					JOptionPane.showMessageDialog(null,"不好意思，由于网络繁忙，请稍候再试...");
				}
			}	
		});
		b2.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				String name=txt_name.getText();
				String remark=txt_remark.getText();
				if(Department.update(Integer.parseInt(id),name,remark))
				{
					JOptionPane.showMessageDialog(null,"恭喜你，修改成功！");
					bind("");
					txt_name.setText("");
					txt_remark.setText("");
				}
				else
				{
					JOptionPane.showMessageDialog(null,"不好意思，由于网络繁忙，请稍候再试...");
				}
			}	
		});
		b3.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				if(Department.delete(Integer.parseInt(id)))
				{
					JOptionPane.showMessageDialog(null,"恭喜你，删除成功！");
					bind("");
					txt_name1.setText("");
				}
				else
				{
					JOptionPane.showMessageDialog(null,"不好意思，由于网络繁忙，请稍候再试...");
				}
			}	
		});
		b4.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				String strWhere=" where D_name like '%"+txt_key.getText()+"%'";
				bind(strWhere);
			}	
		});
		table.addMouseListener(new MouseAdapter(){
			public void mouseClicked(MouseEvent e)
			{
				int i=table.getSelectedRow();
				id=model.getValueAt(i,0).toString();
				String name=model.getValueAt(i,1).toString();
				String remark=model.getValueAt(i,2).toString();
				txt_name.setText(name);
				txt_name1.setText(name);
				txt_remark.setText(remark);
			}	
		});
	}
	public void bind(String strWhere)
	{
		model.setRowCount(0);
		ResultSet rs=Department.list(strWhere);
		
		try
		{
			while(rs.next())
			{
				String id=rs.getString("D_id");
				String name=rs.getString("D_name");
				String remark=rs.getString("D_remark");
				String[] d={id,name,remark};
				model.addRow(d);
			}
		}
		catch(SQLException e)
		{
			System.out.println (e);
		}
	}
}