第一
package com.yunjisuan;
import java.awt.EventQueue;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.table.DefaultTableModel;
import com.conn.SqlTest;
import com.conn.shops;
import javax.swing.JButton;
import javax.swing.JDialog;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.ArrayList;
import java.awt.event.ActionEvent;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JScrollPane;
import java.awt.BorderLayout;
import java.awt.FlowLayout;
import javax.swing.JTable;
import javax.swing.SwingConstants;
public class first extends JFrame {
private JPanel contentPane;
private JTextField textField;
private JTable table;
private Object[][]data;
private String [] head= {"goodId","goodName","num","price"};
DefaultTableModel model=new DefaultTableModel(data,head);
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
first frame = new first();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* Create the frame.
*/
public first() {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 853, 519);
contentPane = new JPanel();
setContentPane(contentPane);
contentPane.setLayout(new BorderLayout(0, 0));
JPanel panel = new JPanel();
contentPane.add(panel, BorderLayout.NORTH);
panel.setLayout(new FlowLayout(FlowLayout.CENTER, 5, 5));
JLabel lblNewLabel = new JLabel("商品名稱");
panel.add(lblNewLabel);
textField = new JTextField();
panel.add(textField);
textField.setColumns(10);
JButton btnNewButton = new JButton("查詢");
btnNewButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
SqlTest sqlTest=new SqlTest();
try {
ArrayList
