hims_incomeaccount.java

基于java的一个小应用程序开发与应用

package com.account;

import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Vector;

import com.dbmanage.*;

/**
 * <p>Title:记录每日收入 </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class HIMS_IncomeAccount extends JPanel{
  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JScrollPane jScrollPane1 = new JScrollPane();
  JTable jTable1 = new JTable();
  JLabel jLabel2 = new JLabel();
//////////////
 private Vector collectList = new Vector();//汇总帐单向量
  private long CollectNo; //汇总帐单编号
  private Date OnDate ; //日期
  private double TotalBeforeTax;//不含税总金额
 private double Tax;  //税额
 private double ToTalAfterTax;//税后总额
 private String Operator; //记帐员
 private String Remark;   //备注


  public HIMS_IncomeAccount() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("SansSerif", 1, 20));
    jLabel1.setForeground(Color.black);
    jLabel1.setToolTipText("");
    jLabel1.setVerifyInputWhenFocusTarget(true);
    jLabel1.setText("宾馆每日收入汇总");
    this.setLayout(xYLayout1);
    xYLayout1.setWidth(453);
    xYLayout1.setHeight(393);
    jLabel2.setFont(new java.awt.Font("SansSerif", 1, 11));
    this.setBackground(SystemColor.info);
    jScrollPane1.getViewport().setBackground(Color.white);
    this.add(jScrollPane1,   new XYConstraints(48, 84, 341, 203));
    this.add(jLabel2, new XYConstraints(78, 332, 223, 37));
    this.add(jLabel1, new XYConstraints(133, 28, -1, -1));
    jScrollPane1.getViewport().add(jTable1, null);
/////
    Vector columnNames2 = new Vector();
    xYLayout1.setWidth(538);
    xYLayout1.setHeight(334);
    columnNames2.add("汇总帐单编号");
    columnNames2.add("日期");
    columnNames2.add("不含税总金额");
    columnNames2.add("税额");
    columnNames2.add("税后总额");
    columnNames2.add("记帐员");
    columnNames2.add("备注");

    String queryString = "select * from HIMS_DailyEarning"; //查询语句
    try {
      JDBCFile conn = new JDBCFile(); //得到一个对象
            //首先得到查询结果的信息
            ResultSet resultSet = conn.executeQuery(queryString);
            //rscount = conn.getMaxRows();
            while (resultSet.next()) {
              CollectNo = resultSet.getLong("CollectNo");
              String CollectNostr = Long.toString(CollectNo);
             OnDate = resultSet.getDate("OnDate");
             String OnDatestr=OnDate.toString();

             TotalBeforeTax=resultSet.getDouble("TotalBeforeTax");
            String  TotalBeforeTaxstr=Double.toString(TotalBeforeTax);
            Tax=resultSet.getDouble("Tax");
            String Taxstr=Double.toString(Tax);
            ToTalAfterTax=resultSet.getDouble("ToTalAfterTax");
            String ToTalAfterTaxstr=Double.toString(ToTalAfterTax);
            Operator=resultSet.getString("Operator");
            Remark = resultSet.getString("Remark");
              /*
               private Date OnDate ; //日期
               private double TotalBeforeTax;//不含税总金额
              private double Tax;  //税额
              private double ToTalAfterTax;//税后总额
              private String Operator; //记帐员
              private String Remark;   //备注*/
              /////
        Object[] data1 = {
         CollectNostr,OnDatestr,TotalBeforeTaxstr, Taxstr,ToTalAfterTaxstr, Operator, Remark,};
              Vector v2 = new Vector();
              for (int k = 0; k < data1.length; ++k) {
                v2.add(data1[k]);
              }
              collectList.add(v2);
            }
          }catch (SQLException q) {
            System.out.println(q);
          }
          JTable jTable1 = new JTable(collectList, columnNames2);
          this.add(jLabel1, new XYConstraints(250, 25, 200, 50));
          jScrollPane1.getViewport().add(jTable1, null);
          this.add(jScrollPane1, new XYConstraints(50, 80, 650, 250));

  } //end jbInit()


} //end public class