package gui;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
//import javax.swing.JOptionPane;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;

import model.Conn;

import java.sql.Connection;


public class Admingui extends JFrame implements ActionListener{

	/**
	 * 
	 */
	 static final long serialVersionUID = 1L;
	 private int i,j;
	 private int rowno,colno;
	 private JTable jt;
	 private JScrollPane js;
	 private ResultSet rs;
	 private Statement sta;
	 private  Object[][] info;
	 private String [] names;
	 private Connection conn;
	 private JButton jb1,jb2;
	 private JPanel jp1,jp2,jp3,jpa,jpb,jpc,jp4,jp5,jp6,jp7,jp8,jp9,jp10,jp11,jp12,jp13,jp14;
	 private JLabel jl1,jl2,jl22,jl3,jl33,jl4,jl44,jl5,jl55,jl6,jl7;
	 private JTextField jtf;
    
	public Admingui() throws ClassNotFoundException, SQLException {
		
		conn=new Conn().getConnection();
		jp1=new JPanel();
		jp2=new JPanel();
		jp3=new JPanel(new BorderLayout());
		jpa=new JPanel();
		jpb=new JPanel();
		jpc=new JPanel();
		jp4=new JPanel();
		jp5=new JPanel();
		jp6=new JPanel();
		jp7=new JPanel();
		jp8=new JPanel();
		jp9=new JPanel(new BorderLayout());
		jp10=new JPanel(new BorderLayout());
		jp11=new JPanel(new BorderLayout());
		jp12=new JPanel(new BorderLayout());
		jp13=new JPanel(new BorderLayout());
		jp14=new JPanel(new BorderLayout());
		
		jl1=new JLabel("用戶信息:");
		jl2=new JLabel("		股民編號:");
		jl22=new JLabel("");
		jl3=new JLabel("		股民姓名:");
		jl33=new JLabel("");
		jl4=new JLabel("		股民佘額:");
		jl44=new JLabel("");
		jl5=new JLabel("		身份證號: ");
		jl55=new JLabel("");
		jl6=new JLabel("交易股票:");
		jl7=new JLabel("請在此輸入交易股票的手數(shù)(1手=100股):");
		
		jtf=new JTextField(10);
		jb1=new JButton("買入");
		jb2=new JButton("拋出");
		jb1.addActionListener(this);
		jb2.addActionListener(this);
		
		jpa.add(jl1);
		
		jpb.add(jl2);
		jpb.add(jl22);
		jpc.add(jl3);
		jpc.add(jl33);
		jp9.add("North",jpb);
		jp9.add("South",jpc);
		
		jp4.add(jl4);
		jp4.add(jl44);
		jp5.add(jl5);
		jp5.add(jl55);
		jp10.add("North",jp4);
		jp10.add("South",jp5);
		
		jp11.add("North",jp9);
		jp11.add("South",jp10);
		
		jp6.add(jl6);
		jp7.add(jl7);
		jp7.add(jtf);
		jp8.add(jb1);
		jp8.add(jb2);
		jp12.add("North",jp6);
		jp12.add("Center",jp7);
		jp12.add("South",jp8);
		
		jp13.add("North",jpa);
		jp13.add("West",jp11);
		jp13.add("South",jp12);
		jp13.setBackground(Color.blue);
		
	}
	public void showinfomation() throws Exception
	{
		 sta=conn.createStatement();
		 String sqlstr1="select count(*) from stock";  //取得數(shù)據(jù)表的記錄數(shù)和字段數(shù)
		  rs=sta.executeQuery(sqlstr1);
		  rs.next(); 
		  rowno=rs.getInt(1);
		  String sqlstr2="select * from stock";
		  rs=sta.executeQuery(sqlstr2);
		  ResultSetMetaData rsmd=rs.getMetaData();
		  colno=rsmd.getColumnCount();
		  
		  String[] names=new String[colno];    
		  for (i=1;i<=colno;i++)
			  names[i-1]=rsmd.getColumnName(i);
		  info=new Object[rowno][];
		  i=0;
		  while (rs.next())
		  {
		   info[i]=new Object[colno];
		   for (j=1;j<=colno;j++)
		   {
		    info[i][j-1]=rs.getObject(j);
		   }
		   i++;
		  }
		  jt=new JTable(info,names);
			js=new JScrollPane(jt);
			jt.setBackground(Color.green);
			jt.setPreferredScrollableViewportSize(new Dimension(550,300));
			
			
			
			jp2.add(js);
			jp3.add("South",jp2);
			jp3.add("North",jp13);
			jp1.add(jp3);
			
			jp14.add("West",jp1);
			this.getContentPane().add(jp14);
			this.setVisible(true);
			this.pack();
			
			
			this.setTitle("歡迎光臨我的股票交易系統(tǒng)");
			this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
			this.setResizable(false);
	}

	public void actionPerformed(ActionEvent e) {
		
		if(e.getSource().equals(jb1)){
			
		}
		if (e.getSource().equals(jb2)){
			
		}
	}
	public static void main(String []args){
		try {
			new Admingui().showinfomation();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}