vetimpl.java

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

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

import com.pet.vet.model.DAO.*;
import com.pet.vet.model.DTO.*;
import java.sql.*;
import com.pet.util.DBCon;
import java.util.ArrayList;

public class vetimpl implements VetDao {
    public vetimpl() {
    }

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

    /**
     * getvetbean
     * 兽医注册的方法
     * @param Vname String
     * @param Vpassword String
     * @param Vquestion String
     * @param Vanswer String
     * @param Vemail String
     * @param Vsex String
     * @param Vaddress String
     * @param Vtruename String
     * @param Vphone String
     * @param Vspecialty String
     * @return VetBean
     * @todo Implement this com.pet.vet.model.DAO.VetDao method
     */
    public VetBean getvetbean(String Vname, String Vpassword, String Vquestion,
                              String Vanswer, String Vemail, String Vsex,
                              String Vaddress, String Vtruename, String Vphone,
                              String Vspecialty) {
        VetBean vetbean = new VetBean();
        //拼写sql语句
        String sqlstr = "insert into vets(vname,vpassword,vquestion,vanswer,vemail,vsex,vphone,vtruename,vaddress,Vspecialty,Vstate) values('" +
                        Vname + "','" +
                        Vpassword + "','" + Vquestion + "','" + Vanswer + "','" +
                        Vemail + "','" + Vsex + "','" + Vaddress +
                        "','" + Vtruename + "','" + Vphone + "','" + Vspecialty +
                        "',1)";
        try {
            db.updateResult(sqlstr);
            vetbean.setVname(Vname);
            vetbean.setVquestion(Vquestion);
            vetbean.setVanswer(Vanswer);
            vetbean.setVemail(Vemail);
            vetbean.setVsex(Vsex);
            vetbean.setVaddress(Vaddress);
            vetbean.setVtruename(Vtruename);
            vetbean.setVphone(Vphone);
            vetbean.setVspecialty(Vspecialty);
            db.closeConn();
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }

        return vetbean;
    }

    /**
     * 判断兽医登陆的方法
     * @param name String
     * @param password String
     * @return VetBean
     */

    public VetBean customer(String name, String password) {
        VetBean vetbean = new VetBean();
        String querySql = "select * from vets where";
        if (name != null && !name.equals("") && password != null &&
            !password.equals("")) {
            querySql += "  Vname ='" + name + "' and vpassword ='" +
                    password + "'";
        }

        try {
            rs = db.querySQL(querySql);
            while (rs.next()) {
                vetbean.setVID(rs.getInt("VID"));
                vetbean.setVname(rs.getString("Vname"));
                vetbean.setVstate(rs.getString("Vstate"));
            }
            db.closeConn();
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        return vetbean;
    }

    /**
     * 通过兽医ID查询兽医信息
     * @param VID int
     * @return VetBean
     */

    public VetBean getvet(int VID) {
        VetBean vetbean = new VetBean();
        try {
            rs = db.querySQL("select * from vets where vid = " + VID);
            rs.next();
            vetbean.setVID(VID);
            vetbean.setVname(rs.getString("Vname"));
            vetbean.setVquestion(rs.getString("Vquestion"));
            vetbean.setVanswer(rs.getString("Vanswer"));
            vetbean.setVemail(rs.getString("Vemail"));
            vetbean.setVsex(rs.getString("Vsex"));
            vetbean.setVaddress(rs.getString("Vaddress"));
            vetbean.setVtruename(rs.getString("Vtruename"));
            vetbean.setVphone(rs.getString("Vphone"));
            vetbean.setVspecialty(rs.getString("Vspecialty"));
            db.closeConn();
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return vetbean;
    }

    /**
     * 获得所有的兽医的信息
     * @return ArrayList
     */
    public ArrayList allvet() {
        ArrayList arrayList = new ArrayList();
        try {

            rs = db.querySQL("select * from vets ");
            while(rs.next()){
                VetBean vetbean = new VetBean();
                vetbean.setVID(rs.getInt("VID"));
                vetbean.setVname(rs.getString("Vname"));
//            vetbean.setVquestion(rs.getString("Vquestion"));
//            vetbean.setVanswer(rs.getString("Vanswer"));
//            vetbean.setVemail(rs.getString("Vemail"));
//            vetbean.setVsex(rs.getString("Vsex"));
//            vetbean.setVaddress(rs.getString("Vaddress"));
//            vetbean.setVtruename(rs.getString("Vtruename"));
//            vetbean.setVphone(rs.getString("Vphone"));
//            vetbean.setVspecialty(rs.getString("Vspecialty"));
                arrayList.add(vetbean);
            }
            db.closeConn();
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }

        return arrayList;
    }

    /**
     * 填写病历的方法
     * @param CID int
     * @param CPID int
     * @param CVID int
     * @param CUID int
     * @param Ctime String
     * @param Cill String
     * @param Cmethod String
     * @return CasesBean
     */

    public CasesBean ill(int CPID, int CVID, int CUID,
                         String Cill, String Cmethod) {
        CasesBean casesBean = new CasesBean();
        String strsql ="insert cases(CPID,CVID,CUID,Ctime,Cill,Cmethod) values("+CPID+","+CVID+","+CUID+",getdate(),'"+Cill+"','"+Cmethod+"')";
        try {
            db.updateResult(strsql);
            casesBean.setCPID(CPID);
            casesBean.setCVID(CVID);
            casesBean.setCUID(CUID);
            //casesBean.setCtime(Ctime);
            casesBean.setCill(Cill);
            casesBean.setCmethod(Cmethod);
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return casesBean;
    }

}