shopimpl.java~33~

JBuilder 2006 +SQL Server2000 +JavaBean+JSP开发的宠物医院管理系统

package com.pet.shop.model.DAO.impl;

import java.util.*;
import java.sql.*;
import com.pet.shop.model.DAO.*;
import com.pet.util.DBCon;
import com.pet.shop.model.DTO.GoodsBean;
import com.pet.shop.model.DTO.OrdersBean;
import com.pet.shop.model.DTO.BuysBean;

public class Shopimpl implements ShopDao {
    public Shopimpl() {
    }

    ResultSet rs = null;
    DBCon db = new DBCon();

    /**
     * allGoods
     * 显示所有的商品的信息
     * @return ArrayList
     * @todo Implement this com.pet.shop.model.DAO.ShopDao method
     */
    public ArrayList allGoods(int num) {
        ArrayList arrayList = new ArrayList();
        String strsql =
                "select top 5 * from goods where gid not in (select top " + num +
                " gid from goods order by gid desc) order by gid desc";
        try {
            rs = db.querySQL(strsql);
            while (rs.next()) {
                GoodsBean goods = new GoodsBean();
                goods.setGID(rs.getInt("GID"));
                goods.setGname(rs.getString("Gname"));
                goods.setCprice(rs.getFloat("Gprice"));
                goods.setClink(rs.getString("Glink"));
                goods.setCintro(rs.getString("Gintro"));
                arrayList.add(goods);
            }
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return arrayList;
    }

    /**
     *
     * @param VID int
     * @return String
     */
    public String allGoodsNum() {
        String count = "";
        try {
            ResultSet rs1 = db.querySQL(
                    "select  count(*) from goods");
            while (rs1.next()) {
                count = rs1.getString(1);
            }
        } catch (Exception ex1) {
            ex1.printStackTrace();
        }

        return count;
    }

    /**
     *
     * @param GID int
     * @return GoodsBean
     */

    public GoodsBean shopGoods(int GID) {
        GoodsBean goods = new GoodsBean();
        try {
            rs = db.querySQL("select * from goods where gid=" + GID);
            rs.next();
            goods.setGID(GID);
            goods.setGname(rs.getString("Gname"));
            goods.setCprice(rs.getFloat("Gprice"));
            goods.setCintro(rs.getString("Gintro"));
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return goods;
    }

    /**
     *
     * @param buyGID int
     * @param buynum int
     * @param buymark String
     * @return int
     */

    public int addbuy(int buyGID, int buynum, String buymark) {
        int i = 0;
        String strsql = "insert buys(buyGID,buynum,buymark)values(" + buyGID +
                        "," + buynum + ",'" + buymark + "')";
        try {
            i = db.updateResult(strsql);
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return i;
    }

    public OrdersBean intorder(String Obuymark, float Omoney, String Otruename,
                               String Oaddress, String Ophone, String Omail) {
        OrdersBean ob = new OrdersBean();
        String strsql =
                "insert orders(Obuymark,Omoney,Otime,Otruename,Oaddress,Ophone,Omail)values('" +
                Obuymark + "'," + Omoney + ",getdate(),'" + Otruename + "','" +
                Oaddress + "','" + Ophone + "','" + Omail + "')";
        try {
            db.updateResult(strsql);
            ob.setObuymark(Obuymark);
            ob.setOmoney(Omoney);
            ob.setOtruename(Otruename);
            ob.setOaddress(Oaddress);
            ob.setOphone(Ophone);
            ob.setOmail(Omail);
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return ob;
    }

    //分页查询语句
    /*select  top 5 emp_id,fname,minit,lname,job_id,job_lvl,pub_id,hire_date
     from employee where emp_id not in(select top 5 emp_id from employee order by emp_id desc)
     order by emp_id desc
     */


    public OrdersBean seeorders(String Obuymark) {
        OrdersBean ob = new OrdersBean();
        String strsql =
                "select * from orders where Obuymark ='" + Obuymark + "'";
        try {
            rs = db.querySQL(strsql);
            while (rs.next()) {
                ob.setOID(rs.getInt("oid"));
                ob.setObuymark(Obuymark);
                ob.setOmoney(rs.getFloat("Omoney"));
                ob.setOtime(rs.getString("otime"));
                ob.setOtruename(rs.getString("Otruename"));
                ob.setOaddress(rs.getString("Oaddress"));
                ob.setOphone(rs.getString("Ophone"));
                ob.setOmail(rs.getString("Omail"));
            }
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }

        return ob;
    }

    public ArrayList seebuy(String Obuymark) {
        ArrayList al = new ArrayList();
        String strsql =
                "select gname,Gprice,buynum from buys,goods where buyGID=GID and buymark ='" +
                Obuymark + "'";
        try {
            rs = db.querySQL(strsql);
            while (rs.next()) {
                GoodsBean goods = new GoodsBean();
                goods.setGname(rs.getString("Gname"));
                goods.setCprice(rs.getFloat("Gprice"));
                goods.setNum(rs.getInt("buynum"));
                al.add(goods);
            }
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return al;
    }

    /**
     *
     * @param gname String
     * @param cprice float
     * @param clink String
     * @param cintro String
     * @return GoodsBean
     */

    public GoodsBean addGoods(String gname, float cprice, String clink,
                              String cintro) {
        GoodsBean goods = new GoodsBean();
        String strsql = "insert goods(Gname,Gprice,Glink,Gintro)vaules('" +
                        gname + "'," + cprice + ",'" + clink + "','" + cintro +
                        "')";
        db.updateResult(strsql);
        return goods;
    }

}