inf_m.java

超市购物系统用于给用户提供购物的选择空间

package windows;

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

public class Inf_m {
	private JFrame inf_m;
    private Object[][] rowData2 = new Object[1][4]; 
    private DefaultTableModel tm2;
    private JTable table2;
    private JScrollPane sp2;
    private Object[] columnNames2 = {"会员号","姓名","积分","消费总额"};
    private Dimension screen_s=Toolkit.getDefaultToolkit().getScreenSize();
    
    public Inf_m(String mid) {                  //构造函数
      inf_m=new JFrame();
      inf_m.setTitle("会员信息");
      inf_m.setSize(new Dimension(300,150));
      tm2= new DefaultTableModel(columnNames2,0);
      table2=new JTable(tm2);
      sp2=new JScrollPane(table2);
      inf_m.add(sp2);
      inf_m.setDefaultCloseOperation (JFrame.DISPOSE_ON_CLOSE);    
      Dimension inf_m_s=inf_m.getSize();
      if(inf_m_s.height>screen_s.height){
   	    inf_m_s.height=screen_s.height;
      }
      if(inf_m_s.width>screen_s.width){
   	    inf_m_s.width=screen_s.width;
      }
      inf_m.setLocation((screen_s.width-inf_m_s.width)/2,(screen_s.height-inf_m_s.height)/2); 
      try{
    	  String sql3="select Mname,Mmark,Mmoney from members where Mid="+Integer.parseInt(mid);
          Statement stmt = Conn.getConnection().createStatement();
          ResultSet rs=stmt.executeQuery(sql3);
          rs.next();
          rowData2[0][0]=mid;
	      rowData2[0][1]= rs.getString("Mname");
	      rowData2[0][2]= rs.getString("Mmark");
	      rowData2[0][3]= rs.getString("Mmoney");
	      tm2.addRow(rowData2[0]);
          stmt.executeUpdate(sql3);
          rs.close();
          stmt.close();
       }catch(Exception e1){
                e1.getStackTrace();
        }
      inf_m.setVisible(true);  
   }
}