workofmanagerdate.java

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

package netbar;

import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.util.ArrayList;
import java.sql.SQLException;

public class WorkOfManagerDate {
    public WorkOfManagerDate() {
        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 WorkOfManager");
            while(rs.next()){
                array.add(rs.getString(2));
                array.add(rs.getString(3));
                array.add(rs.getString(4));
                array.add(String.valueOf(rs.getString(5)));
                array.add(String.valueOf(rs.getInt(6)));
            }
        }catch(SQLException ee){
        }
        return array;
    }

    private void jbInit() throws Exception {
    }

}