baseinfoimpl.java

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

package org.xsp.po.impl;

import java.util.*;

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

public class BaseInfoImpl implements BaseInfoDAO {
    private DbFactory db = new DbFactory();
    public BaseInfoImpl() {
    }

    public List cha() {
        ArrayList list = db.executeQuery("select * from medicinaInfo",null);
        return list;
    }

    public ArrayList executeQuery(String sql, ArrayList list) {
        return null;
    }

    public int executeUpdate(String sql, ArrayList list) {
        return 0;
    }

    public UserBean query(String userName, String userPwd) {
        UserBean ub = null;
        String sql =
                "select * from UserInfo where UserName = ? and UserPwd = ? ";
        ArrayList list = new ArrayList();
        Hashtable ht = new Hashtable();
        ht.put("s", userName);
        list.add(ht);
        ht = new Hashtable();
        ht.put("s", userPwd);
        list.add(ht);
        ArrayList teamList = db.executeQuery(sql, list);
        if (teamList != null) {
            if (teamList.size() > 0) {
                ArrayList row = (ArrayList) teamList.get(0);
                ub = new UserBean();
                ub.setUserName(userName);
                ub.setUserPwd(userPwd);
                ub.setPower(row.get(3).toString());
            }
        }
        return ub;
    }

    public int insert(String userName, String userPwd) {
        String sql = "insert into UserInfo (UserName,UserPwd) values(?,?)";
        ArrayList list = new ArrayList();
        Hashtable ht = new Hashtable();
        ht.put("s", userName);
        list.add(ht);
        ht = new Hashtable();
        ht.put("s", userPwd);
        list.add(ht);
        return db.executeUpdate(sql, list);
    }

    public int insertMedicinal(String medicinalName, String medicinalaccount,
                               String medicinalNum) {
        String sql = "insert into medicinaInfo (medicinalName,medicinalaccount,medicinalNum) values(?,?,?)";
        ArrayList list = new ArrayList();
        Hashtable ht = new Hashtable();
        ht.put("s", medicinalName);
        list.add(ht);
        ht = new Hashtable();
        ht.put("s", medicinalaccount);
        list.add(ht);
        ht = new Hashtable();
        ht.put("s", medicinalNum);
        list.add(ht);
        return db.executeUpdate(sql, list);
    }

    public int insertBuyInfo(String userName, String medicinalName,
                             String medicinalNum) {
        String sql =
                "insert into UserManage (UserName,medicinalName,UserNum) values(?,?,?)";
        ArrayList list = new ArrayList();
        Hashtable ht = new Hashtable();
        ht.put("s", userName);
        list.add(ht);
        ht = new Hashtable();
        ht.put("s", medicinalName);
        list.add(ht);
        ht = new Hashtable();
        ht.put("s", medicinalNum);
        list.add(ht);
        return db.executeUpdate(sql, list);
    }
}