import java.awt.BorderLayout;
import java.awt.EventQueue;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JTextField;
import javax.swing.JLabel;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;

public class addhero extends JFrame {

	private JPanel contentPane;
	private JTextField []textField=new JTextField[6];
	//private JTextField textField_1;
	//private JTextField textField_2;
	//Field textField_3;
	//private JTextField textField_4;
	//private JTextField textField_5;

	JFrame tt;
	public addhero() {
		setTitle("增加英雄");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(50, 50, 1000, 701);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);
		getContentPane().setLayout(null);
		
		
		for(int i=0;i<6;i++)
			textField[i] = new JTextField();
		textField[0].setBounds(93, 24, 220, 37);
		contentPane.add(textField[0]);
		textField[0].setColumns(10);
		
		System.out.println("sadas");
		//textField[1] = new JTextField();
		textField[1].setColumns(10);
		textField[1].setBounds(93, 91, 220, 37);
		contentPane.add(textField[1]);
		
		//textField[2]= new JTextField();
		textField[2].setColumns(10);
		textField[2].setBounds(93, 158, 220, 37);
		contentPane.add(textField[2]);
		
		//textField[3] = new JTextField();
		textField[3].setColumns(10);
		textField[3].setBounds(93, 222, 220, 37);
		contentPane.add(textField[3]);
		
		//textField[4] = new JTextField();
		textField[4].setColumns(10);
		textField[4].setBounds(93, 283, 220, 37);
		contentPane.add(textField[4]);
		
		//textField[5] = new JTextField();
		textField[5].setColumns(10);
		textField[5].setBounds(93, 349, 220, 37);
		contentPane.add(textField[5]);
		
		
		for(int i=0;i<6;i++)
			textField[i].addActionListener(new addlistener2());
		
		JLabel label = new JLabel("\u6B66\u5C06\u540D");
		label.setFont(new Font("长城行楷体", Font.PLAIN, 21));
		label.setBounds(10, 24, 73, 37);
		contentPane.add(label);
		
		JLabel label_1 = new JLabel("\u5B57");
		label_1.setFont(new Font("长城行楷体", Font.PLAIN, 21));
		label_1.setBounds(10, 91, 73, 37);
		contentPane.add(label_1);
		
		JLabel label_2 = new JLabel("\u6B66\u529B");
		label_2.setFont(new Font("长城行楷体", Font.PLAIN, 21));
		label_2.setBounds(10, 158, 73, 37);
		contentPane.add(label_2);
		
		JLabel label_3 = new JLabel("\u667A\u529B");
		label_3.setFont(new Font("长城行楷体", Font.PLAIN, 21));
		label_3.setBounds(10, 222, 73, 37);
		contentPane.add(label_3);
		
		JLabel label_4 = new JLabel("\u54C1\u5FB7");
		label_4.setFont(new Font("长城行楷体", Font.PLAIN, 21));
		label_4.setBounds(10, 283, 73, 37);
		contentPane.add(label_4);
		
		JLabel label_5 = new JLabel("\u6B66\u5668");
		label_5.setFont(new Font("长城行楷体", Font.PLAIN, 21));
		label_5.setBounds(10, 349, 73, 37);
		contentPane.add(label_5);
	}
	class addlistener2 implements ActionListener
	{
		public void actionPerformed(ActionEvent e)
		{ 
			try{
			
			 String []s=new String[6];
			 for(int i=0;i<6;i++)
			 {
				 s[i]=new String();
				 s[i]=textField[i].getText();	
			 }
		
			String temps=new String();
			temps="insert into hero values(null,'"+s[0]+"','"+s[1]+"',"+s[2]+","+s[3]+","+s[4]+",'"+s[5]+"',null,null)";
			
			System.out.println(temps);
			ResultSet res=start.statement.executeQuery(temps);
			 tt=new JFrame();
			tt.setBounds(100, 100, 500, 80);
			JButton ta = new JButton("恭喜！武将"+s[0]+"添加成功！ 点击返回");
			tt.add(ta);
			tt.setVisible(true);
			ta.addActionListener(new backlistener());
			}catch(SQLException ss  )
			{
				textField[0].setText("error!");
			}
		}
	}
	class backlistener implements ActionListener
	{
		public void actionPerformed(ActionEvent e)
		{ 
			addhero.this.setVisible(false);
			tt.setVisible(false);
			dba  f8=new dba();
			f8.setVisible(true);
		}
	}
}