product_ui.java

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

import javax.swing.JPanel;
import javax.swing.JLabel;
import javax.swing.JButton;
import javax.swing.JTextField;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import javax.swing.BorderFactory;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.GridLayout;
import dal.Product;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Product_UI extends JPanel
{
	String id="";
	String[] columns={"商品编号","商品名称","商品单价","商品描述"};
	DefaultTableModel dtm=new DefaultTableModel(columns,0);
	JTable table=new JTable(dtm);
	JLabel l1=new JLabel("商品名称:");
	JLabel l2=new JLabel("商品价格:");
	JLabel l3=new JLabel("商品描述:");
	JLabel l4=new JLabel("你将要删除的商品为:");
	JLabel l5=new JLabel("请输入关键字:");
	JTextField txt_name=new JTextField(12);
	JTextField txt_price=new JTextField(12);
	JTextField txt_remark=new JTextField(12);
	JTextField txt_name1=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("查询商品");
	Product_UI()
	{
		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(4,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();
		JPanel p1_4=new JPanel();
		p1.add(p1_1);
		p1.add(p1_2);
		p1.add(p1_3);
		p1.add(p1_4);
		p1_1.add(l1);
		p1_1.add(txt_name);
		p1_2.add(l2);
		p1_2.add(txt_price);
		p1_3.add(l3);
		p1_3.add(txt_remark);
		p1_4.add(b1);
		p1_4.add(b2);
		JPanel p2_1=new JPanel();
		JPanel p2_2=new JPanel();
		p2.add(p2_1);
		p2.add(p2_2);
		p2_1.add(l4);
		p2_1.add(txt_name1);
		p2_1.add(b3);
		p2_2.add(l5);
		p2_2.add(txt_key);
		p2_2.add(b4);
		table.addMouseListener(new MouseAdapter(){
			public void mouseClicked(MouseEvent e)
			{
				int i=table.getSelectedRow();
				id=table.getValueAt(i,0).toString();
				String name=table.getValueAt(i,1).toString();
				String price=table.getValueAt(i,2).toString();
				String remark=table.getValueAt(i,3).toString();
				txt_name.setText(name);
				txt_name1.setText(name);
				txt_price.setText(price);
				txt_remark.setText(remark);
			}
		});
		b1.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				model.Product m=getProductModel();
				if(Product.add(m))
				{
					JOptionPane.showMessageDialog(null,"恭喜你，添加成功！");
					bind("");
				}
				else
				{
					JOptionPane.showMessageDialog(null,"不好意思，由于网络繁忙，请稍候再试...");
				}
			}	
		});
		b2.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				model.Product m=getProductModel();
				if(Product.update(m))
				{
					JOptionPane.showMessageDialog(null,"恭喜您，修改成功！");
					bind("");
				}
				else
				{
					JOptionPane.showMessageDialog(null,"不好意思，由于网络繁忙，请稍候再试...");
				}
			}	
		});
		b3.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				if(Product.delete(Integer.parseInt(id)))
				{
					JOptionPane.showMessageDialog(null,"恭喜你，删除成功！");
					bind("");
				}
				else
				{
					JOptionPane.showMessageDialog(null,"不好意思，由于网络繁忙，请稍候再试...");
				}
			}	
		});
		b4.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				String strWhere=" where P_name like '%"+txt_key.getText().trim()+"'";
				bind(strWhere);
			}	
		});
		bind("");
	}
	public void bind(String strWhere)
	{
		dtm.setRowCount(0);
		ResultSet rs=null;
		try
		{
			rs=Product.list(strWhere);
			while(rs.next())
			{
				String id=rs.getString("P_id");
				String name=rs.getString("P_name");
				String price=rs.getString("P_price");
				String remark=rs.getString("P_remark");
				String[] p={id,name,price,remark};
				dtm.addRow(p);
			}
		}
		catch(SQLException e)
		{
			System.out.println (e);
		}
	}
	public 	model.Product getProductModel()
	{
		model.Product m=new model.Product();
		if(!id.equals(""))
		{
			m.P_id=Integer.parseInt(id);
		}
		m.P_name=txt_name.getText();
		m.P_price=Double.parseDouble(txt_price.getText().trim());
		m.P_remark=txt_remark.getText();
		return m;
	}
}