package goods;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;

public class InsertData extends JFrame implements ActionListener {
	// 窗体初始化,添加各个控件
	JLabel jlabel1, jlabel2, jlabel3;
	JTextField jtf1, jtf2, jtf3;
	JButton jb1, jb2, jb3, jb4;

	public InsertData() {
		jlabel1 = new JLabel("商品号:");
		jlabel1.setBounds(20, 20, 70, 30);
		jlabel2 = new JLabel("商品名:");
		jlabel2.setBounds(20, 60, 70, 30);
		jlabel3 = new JLabel("商品价:");
		jlabel3.setBounds(20, 100, 70, 30);
		jtf1 = new JTextField();
		jtf1.setBounds(100, 20, 150, 30);
		jtf2 = new JTextField();
		jtf2.setBounds(100, 60, 150, 30);
		jtf3 = new JTextField();
		jtf3.setBounds(100, 100, 150, 30);
		jb1 = new JButton("增加");
		jb1.setBounds(20, 150, 60, 30);
		jb1.addActionListener(this);
		jb2 = new JButton("删除");
		jb2.setBounds(90, 150, 60, 30);
		jb2.addActionListener(this);
		jb3 = new JButton("修改");
		jb3.setBounds(160, 150, 60, 30);
		jb3.addActionListener(this);
		jb4 = new JButton("查询");
		jb4.setBounds(230, 150, 60, 30);
		jb4.addActionListener(this);
		add(jlabel1);
		add(jlabel2);
		add(jlabel3);
		add(jtf1);
		add(jtf2);
		add(jtf3);
		add(jb1);
		add(jb2);
		add(jb3);
		add(jb4);
		setTitle("商品信息管理");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setLayout(null);
		setBounds(50, 50, 400, 300);
		setResizable(false);
		setVisible(true);
	}

	public void actionPerformed(ActionEvent e) {
		if (e.getActionCommand().equals("增加")) {
			PreparedStatement stat = null;
			Connection conn = new JdbcConnection().dbConnection();
			String sql = "insert into shop(id,name,price)values(?,?,?)";
			// 每个"?"代表一个占位符,在执行之前要一一设置各占位符的内容
			try {
				stat = conn.prepareStatement(sql);
				stat.setString(1, jtf1.getText());
				stat.setString(2, jtf2.getText());
				stat.setDouble(3, Double.valueOf(jtf3.getText()).doubleValue());
				stat.executeUpdate();
				JOptionPane.showMessageDialog(this, "增加了一条记录");
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
		}
		if (e.getActionCommand().equals("修改")) {
			PreparedStatement stat = null;
			Connection conn = new JdbcConnection().dbConnection();
			String sql2 = "update shop set name = ?,price = ? where id = ?";
			try {
				stat = conn.prepareStatement(sql2);
				stat.setString(1, jtf2.getText());
				stat.setDouble(2, Double.valueOf(jtf3.getText()).doubleValue());
				stat.setString(3, jtf1.getText());
				stat.executeUpdate();
				JOptionPane.showMessageDialog(this, "修改一条记录");
			} catch (SQLException e3) {
				e3.printStackTrace();
			}
		}
		if (e.getActionCommand().equals("删除")) {
			PreparedStatement stat = null;
			Connection conn = new JdbcConnection().dbConnection();
			String sql1 = "delete from shop where id=?";
			try {
				stat = conn.prepareStatement(sql1);
				stat.setString(1, jtf1.getText());
				stat.executeUpdate();
				JOptionPane.showMessageDialog(this, "删除了一条记录");
			} catch (SQLException e2) {
				e2.printStackTrace();
			}
		}
		String str1 = jtf1.getText();
		try {
			long i = Long.valueOf(str1).longValue();
		} catch (Exception ex) {
			JOptionPane.showMessageDialog(this, "信息不能为空或输入格式错误");
			return;
		}
		
	}

}