package windows;

import odbc.*;
import java.awt.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;

public class Inf_g {
	private JFrame inf_g;
	private Object[][] rowData1 = new Object[1][6];
	private DefaultTableModel tm1;
	private JTable table1;
	private JScrollPane sp1;
	private Object[] columnNames1 = {"商品號","商品名","產地","單價","庫存量","銷售量"};
	private Dimension screen_s=Toolkit.getDefaultToolkit().getScreenSize();
	private Dimension inf_g_s;
    
    public Inf_g() {                                //構造函數
      inf_g=new JFrame();
      inf_g.setSize(new Dimension(450,200));
      inf_g.setTitle("商品信息");
      tm1= new DefaultTableModel(columnNames1,0);   
      table1=new JTable(tm1);
      sp1=new JScrollPane(table1);
      inf_g.add(sp1);
      inf_g.setDefaultCloseOperation (JFrame.DISPOSE_ON_CLOSE); 
      inf_g_s=inf_g.getSize();
      if(inf_g_s.height>screen_s.height){
   	      inf_g_s.height=screen_s.height;
      }
      if(inf_g_s.width>screen_s.width){
   	    inf_g_s.width=screen_s.width;
      }
      inf_g.setLocation((screen_s.width-inf_g_s.width)/2,(screen_s.height-inf_g_s.height)/2);
	  try {
	       String sql2="select * from goods"; 
	       Statement stmt = Conn.getConnection().createStatement();
	       ResultSet rs=stmt.executeQuery(sql2);
	       while(rs.next())
	          {rowData1[0][0]= rs.getString("Gid");
			   rowData1[0][1]= rs.getString("Gname");
			   rowData1[0][2]= rs.getString("Gaddress");
			   rowData1[0][3]= rs.getString("Gprice");
			   rowData1[0][4]= rs.getString("Gstore");
			   rowData1[0][5]= rs.getString("Gsell");
			   tm1.addRow(rowData1[0]);			   
	          }   //while
	       stmt.executeUpdate(sql2);	   
	       rs.close();
           stmt.close();
	  }catch(SQLException e1){
	       e1.getStackTrace();
	  }
     inf_g.setVisible(true);   
  }

}