VB个人理财管理系统(流程图+论文+源程序) 第6页
  table.setAutoResizeMode(table.AUTO_RESIZE_ALL_COLUMNS);
    table.setCellSelectionEnabled(true);
    scroll=new JScrollPane(table);
    scroll.setBounds(21,10,6,50);
   
    f.add(scroll);
 //----------------------------------------------------------------------------
  try{
   Class.forName(driver);
   con = DriverManager.getConnection(url,"sa",null);
   sta = con.createStatement();
      rs=sta.executeQuery("USE "+basename+"的个人理财数据库 select * from 信用卡收入支出表 where 日期 between '"+date1+"' and '"+date2+"'");
      vector.removeAllElements();
      tm.fireTableStructureChanged();
   
      while(rs.next()){
       Vector vector1=new Vector();
       vector1.addElement(rs.getDate("日期"));
       vector1.addElement(rs.getString("项目"));
       vector1.addElement(rs.getDouble("金额"));
       vector1.addElement(rs.getString("收入/支出"));
       vector1.addElement(rs.getString("是否贷款"));
       vector1.addElement(rs.getDate("还款日期"));
       vector.addElement(vector1);
     }  
  }catch(SQLException ex){
     ex.printStackTrace();
  }catch(Exception ex){
     ex.printStackTrace();
  }
  finally{
     try{
     }catch(Exception ex){
      ex.printStackTrace();
     }
    }
 }
 public void close(){
  try{
   if(con!= null)
    con.close();
   con=null;  
  }catch(Exception e){
   e.printStackTrace();
  }
信用卡收入/支出情况：
}
import java.sql.*;
import java.awt.*;
import java.awt.event.*;

import javax.swing.*;
import javax.swing.table.*;

import java.io.*;
import java.util.*;
public class selioC extends JFrame{
 JFrame f=new JFrame("信用卡收入/支出情况");
  Connection con;
  Statement  sta;
  ResultSet  rs;
  String driver= "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  String url= "jdbc:microsoft:sqlserver://localhost:1433";
  String title[]={"日期 "," 项目"," 金额 "," 收入/支出 "," 是否贷款 "," 还款日期 "};
  Vector vector=new Vector();
  AbstractTableModel tm;
  JTable table;
  JScrollPane scroll;
  JButton btl;
  TextField input1;
  String inout;
  String basename;
  public selioC(String bn)
  {
   super("信用卡表收入/支出查询");
   setLayout(new FlowLayout());
        basename=bn;
        btl=new JButton("确定");
        btl.addActionListener(new java.awt.event.ActionListener(){
      public void actionPerformed(ActionEvent e){sel();
      dispose();}
  }); 
        JLabel l=new JLabel("查询收入/支出");
   input1=new TextField(4);
   add(l);
      add(input1);
         add("South", btl);
    
     
      pack();
       setSize(650,100);
       setVisible(true);

  }
  public void sel()
   {
    initTable();
    init();
   }
 public void init(){
  
     f.setSize(500,500);
     f.setLayout(new FlowLayout());
     f.setVisible(true);
  }
 public void initTable(){
    
  inout=input1.getText();
 //---------------------------------------------------------------------------
   tm=new AbstractTableModel(){
       public int getColumnCount(){
      return title.length;
    }
    public int getRowCount(){
       return vector.size();
    }
    public Object getValueAt(int row,int column){
       if(!vector.isEmpty()){
        return ((Vector) vector.elementAt(row)).elementAt(column);
       }else{
        return null;
       }
    }
    public void setValueAt(Object value,int row,int column){    
    }
    public String getColumnName(int column){
       return title[column];
    }
    //public Class getColumnClass(int c){
    //   return getValueAt(0,c).getClass();

上一页  [1] [2] [3] [4] [5] [6] [7] 下一页