classofspecialties.java

基于mvc的宠物管理系统。servlet+jsp

package com.richard.dao;

import java.util.*;

import com.richard.dto.*;
import com.richard.dao.*;
import java.util.*;
import java.io.*;
import java.sql.*;

public class ClassOfSpecialties implements InterfaceOfSpecialties {

    DBOperate objDBOperate=new DBOperate();

    public ClassOfSpecialties() {
    }

    /**
     * specialtiesAdd
     *
     * @param objSpecialties Specialties
     * @todo Implement this com.richard.dao.InterfaceOfSpecialties method
     */
    public void specialtiesAdd(Specialties objSpecialties) {
    }

    /**
     * specialtiesDelete
     *
     * @param objSpecialties Specialties
     * @todo Implement this com.richard.dao.InterfaceOfSpecialties method
     */
    public void specialtiesDelete(Specialties objSpecialties) {
    }

    /**
     * specialtiesQuery
     *
     * @param objSpecialties Specialties
     * @return Specialties
     * @todo Implement this com.richard.dao.InterfaceOfSpecialties method
     */
    public Specialties specialtiesQuery(Specialties objSpecialties) {
        return null;
    }

    /**
     * specialtiesQueryAll
     *
     * @return ArrayList
     * @todo Implement this com.richard.dao.InterfaceOfSpecialties method
     */
    public ArrayList specialtiesQueryAll() {
        ArrayList objArrayList=new ArrayList();
        String sqlCommand="select * from specialties";
        try {
            ResultSet rs=objDBOperate.getResultSet("petclinic",sqlCommand);
            while(rs.next())
            {
                Specialties objSpeciaties=new Specialties();
                objSpeciaties.setId(rs.getInt(1));
                objSpeciaties.setName(rs.getString(2));
                objArrayList.add(objSpeciaties);
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
        return objArrayList;
    }

    /**
     * specialtiesUpdate
     *
     * @param objSpecialties Specialties
     * @todo Implement this com.richard.dao.InterfaceOfSpecialties method
     */
    public void specialtiesUpdate(Specialties objSpecialties) {
    }

    /**
     * vetsQueryOfspecialties
     *
     * @param objSpecialties Specialties
     * @return ArrayList
     * @todo Implement this com.richard.dao.InterfaceOfSpecialties method
     */
    public ArrayList vetsQueryOfspecialties(Specialties objSpecialties) {
        return null;
    }

    public int nameForId(Specialties objSpecialties)
    {
        String name=objSpecialties.getName();
   int id=0;
   String sqlCommand="select id from specialties where name='"+name+"'";
   try {
       ResultSet rs=objDBOperate.getResultSet("petclinic",sqlCommand);
       while(rs.next())
       {
           id=rs.getInt(1);
       }

   } catch (Exception ex) {
       System.out.println(ex.getMessage());
   }
   return id;

    }
}