saled_log.java

来自「java编写小型超市管理系统+数据库.用于小型超市简单的货品进存销」· Java 代码 · 共 78 行

package com.wish;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.sql.*;
import java.awt.BorderLayout;
import java.awt.event.*;

//销售记录
public class saled_log extends JFrame implements ActionListener{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JTable table=null;
	DefaultTableModel dtm=new DefaultTableModel();
	JScrollPane jsp=null;
	JButton btnOk=new JButton("OK");
	
	saled_log()
	{
		setLayout(new BorderLayout());
		inTable();
		jsp=new JScrollPane(table);
		inDtm();
		
		btnOk.addActionListener(this);
		this.add(jsp,BorderLayout.CENTER);
		this.add(btnOk,BorderLayout.SOUTH);
		this.setSize(400,300);
		setsonframe.set(this);
	}
		
	private void inTable()
	{
		table=new JTable(dtm);
		dtm.addColumn("销售员：");
		dtm.addColumn("会员ID：");
		dtm.addColumn("消费日期：");
		dtm.addColumn("消费金额：");
	}
	private void inDtm()
	{
		DefaultTableModel dtm=new DefaultTableModel();
		dtm.addColumn("销售员：");
		dtm.addColumn("会员ID：");
		dtm.addColumn("消费日期：");
		dtm.addColumn("消费金额：");
	
		Connection cn=ConnectionDB.getCon();
		Statement st=null;
		ResultSet rs=null;
		
		try {
			st=cn.createStatement();
			rs=st.executeQuery("select * from saled_log");
			while(rs.next())
			{
				String data[]=new String[4];
				data[0]=rs.getString("sale_man");
				data[1]=rs.getString("user_id");
				data[2]=rs.getString("pay_time");
				data[3]=rs.getString("pay_money");
				dtm.addRow(data);
			}table.setModel(dtm);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==btnOk)
		{
			this.dispose();
		}
	}
}