basepageimpl.java

管理药品的进出销量以及对销售状况的统计 Java+SQL医药进销存管理系统,可实现简单的操作

package org.xsp.po.impl;

import java.util.*;

import org.xsp.po.*;
import org.xsp.DbFactory.DbFactory;
import org.xsp.model.UserBean;

public class BasePageImpl implements BasePageDAO {
    private DbFactory db = new DbFactory();
    public ArrayList executeQuery(String sql, ArrayList list) {
        return null;
    }
    public int executeUpdate(String sql, ArrayList list) {
        return 0;
    }
    public int getMedicinalCount() {
    int count=0;
     ArrayList list =  db.executeQuery("select * from medicinaInfo",null);
     if(list!=null){
         count = list.size();
     }
     System.out.println("aaaaaaaaaaaaaaaaaaaaaaaaaaa"+count);
     return count;
    }
    public List queryMedicinal(int count) {
//        List resultlist = null;
//        UserBean ub =null;
        String sql = "select top 2 * from medicinaInfo where ID not in (select top "+count+" ID from medicinaInfo order by ID asc) order by ID asc";
        ArrayList list = db.executeQuery(sql,null);
//        if(list!= null){
//            if(list.size()>0){
//                变成循环也可一
//                ArrayList row = (ArrayList) list.get(0);
//                ub = new UserBean();
//                resultlist = new ArrayList();
//                ub.setID(Integer.parseInt(row.get(0).toString()));
//                ub.setMedicinalName(row.get(1).toString());
//                ub.setMedicinalaccount(row.get(2).toString());
//                ub.setMedicinalNum(row.get(3).toString());
//                Object o = row.get(4);
//                if(o != null){
//                    ub.setText(o.toString());
//                }else{
//                    ub.setText("");
//                }
//                resultlist.add(ub);
//            }
//        }
        return list;
    }
}