noteofmanagerdate.java

来自「网吧管理系统JAVA代码」· Java 代码 · 共 41 行

package netbar;

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

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

    //获得管理员的资料
    public ArrayList getnote(){
    ArrayList array =new ArrayList();
    SQLDate.sqldate();
    try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("select * from Manager");
    while(rs.next()){
    array.add(rs.getString(1));
    array.add(rs.getString(4));
    array.add(rs.getString(5));
    array.add(String.valueOf(rs.getInt(6)));
    array.add(rs.getString(7));
    array.add(rs.getString(8));
    }
   // for(int i=0;i<array.size();i++)
       // System.out.println(array.get(i));
    }catch(SQLException ee){
    }
    return array;
    }

    private void jbInit() throws Exception {
    }
}