balancedate.java

网吧管理系统JAVA代码

package netbar;

import java.util.*;
import java.sql.*;

public class BalanceDate {
    public BalanceDate() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    //获得卡号,余额,消费金额
    public ArrayList getdate(){
        ArrayList array=new ArrayList();
    SQLDate.sqldate();
    try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("select * from Card ");
    while(rs.next()){
        array.add(rs.getString(1));
        array.add(rs.getString(2));
        array.add(rs.getString(3));
        array.add(rs.getString(4));
        array.add(rs.getString(5));
        array.add(rs.getString(6));
        array.add(rs.getString(7));
        array.add(rs.getString(8));
    }
    }catch(SQLException ee){
    System.out.println(ee);
    }
   return array;
    }

    private void jbInit() throws Exception {
    }
}