public ShowSale(){
    JFrame my=new JFrame(); 
    JLabel lb=new JLabel("                                总销售额:");
    JPanel p=new JPanel();
    JTextField tf=new JTextField();
        Object ob[][];
        Object name[]={"编号","连锁店","商品代号","单价","数量","总价"};
        DefaultTableModel dtm;
        JTable table;
        setLocation(0,50);
try{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         Connection con = DriverManager.getConnection("jdbc:odbc:MyOdbc","","");
         Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
         ResultSet rs=stmt.executeQuery("select * from [Sheet1$] where 编号<>'0';");
          rs.last();
          int lastNumber=rs.getRow();
          ob=new Object[lastNumber][6];
          int i=0;
          String t,o;
          float total=0;
          rs.beforeFirst();
        while(rs.next()){
            ob[i][0]=rs.getLong(1);
            ob[i][1]=rs.getString(2);
            ob[i][2]=rs.getString(3);
            ob[i][3]=rs.getString(4);
            ob[i][4]=rs.getInt(5);
            ob[i][5]=rs.getFloat(6);
            total+=rs.getFloat(6);
            i++; 
            }
            o=Float.toString(total);            //将总价转换为STRING
        dtm=new DefaultTableModel(ob,name);
         table=new JTable(dtm);
         table.setFont(new Font("黑体",Font.BOLD,16));
         JScrollPane jt=new JScrollPane();
         setLayout(new BorderLayout());
         jt.setViewportView(table);
         add(jt,BorderLayout.CENTER);
         tf.setText(""+o);
         p.setLayout(new GridLayout(1,4,5,5));
         lb.setFont(new Font("黑体",Font.BOLD,16));
         tf.setFont(new Font("黑体",Font.BOLD,16));         p.add(lb);
         p.add(tf);
         add(p,BorderLayout.SOUTH);
         setTitle("所有销售记录");
         setSize(850,500);
         setVisible(true);        
          con.close();      
         }
         catch(Exception e){
          e.printStackTrace(); 
         }}}
//大致如何实现,在哪个地方要增加什么算法,求高手指点