petdao.java~12~

这是java编写宠物医院项目

package pet;
import java.util.*;
import java.sql.*;
import jdbc.JDBC;
public class PetDAO {
    public PetDAO() {
    }

    public Collection pet_info(){
        ArrayList al=new ArrayList(10);
        try{
            Statement stmt=JDBC.getConnection().createStatement();
            ResultSet rs=stmt.executeQuery("select * from pet_info");
            while(rs.next()){
               PetVO vo=new PetVO();
               vo.setPid(rs.getInt("petid"));
               vo.setPname(rs.getString("petname"));
               vo.setPhid(rs.getInt("holderid"));
               vo.setPkind(rs.getString("petkind"));
               vo.setPsex(rs.getString("petsex"));
               vo.setPtime(rs.getString("pettime"));
               al.add(vo);
            }
            rs.close();
            stmt.close();
        }catch(SQLException ex){
            ex.printStackTrace();
        }
        return al;
    }

    public Collection holder_pet(){
        ArrayList al=new ArrayList();
        try{
            Statement stmt=JDBC.getConnection().createStatement();
            ResultSet rs=stmt.executeQuery("select * from VIEW_pet_holdrer");
            while(rs.next()){
               PetVO vo=new PetVO();
               vo.setPid(rs.getInt("petid"));
               vo.setPhid(rs.getInt("holderid"));
               vo.setHname(rs.getString("holdername"));
               vo.setPname(rs.getString("petname"));
               vo.setPkind(rs.getString("petkind"));
               vo.setPsex(rs.getString("petsex"));
               vo.setPtime(rs.getString("pettime"));
               al.add(vo);
            }
            rs.close();
            stmt.close();
        }catch(SQLException ex){
            ex.printStackTrace();
        }
        return al;
    }
    public Collection pet_name(String name){
       Collection vetList = null;
       Statement stat=null;
       ResultSet rs=null;
       try {
           String sql="select * from VIEW_pet_holdrer where petname  like '%"+name+"%'";
           stat = JDBC.getConnection().createStatement();
           rs = stat.executeQuery(sql);
           if(rs.next()){
               vetList = new ArrayList();
               do {
                   PetVO vo = new PetVO();
                   vo.setPid(rs.getInt("petid"));
                   vo.setPhid(rs.getInt("holderid"));
                   vo.setHname(rs.getString("holdername"));
                   vo.setPname(rs.getString("petname"));
                   vo.setPkind(rs.getString("petkind"));
                   vo.setPsex(rs.getString("petsex"));
                   vo.setPtime(rs.getString("pettime"));
                   vetList.add(vo);
               } while (rs.next());
           }
       } catch (SQLException ex) {
           ex.printStackTrace();
       }
       finally{
           if(rs != null){
               try {
                   rs.close();
               } catch (SQLException ex1) {
               }
               rs = null;
           }
           if(stat != null){
               try {
                   stat.close();
               } catch (SQLException ex2) {
               }
               stat = null;
           }
       }
       return vetList;
   }


//   public PetVO pet_name(String name){
//       PetVO vo=null;
//       Statement stmt=null;
//       ResultSet rs=null;
//       try{
//           stmt=JDBC.getConnection().createStatement();
//           String sql="select * from VIEW_pet_holdrer where petname  like '%"+name+"%'";
//           rs=stmt.executeQuery(sql);
//           if(rs.next()){
//               vo=new PetVO();
//               vo.setPid(rs.getInt("petid"));
//               vo.setHname(rs.getString("holdername"));
//               vo.setPhid(rs.getInt("holderid"));
//               vo.setPname(rs.getString("petname"));
//               vo.setPkind(rs.getString("petkind"));
//               vo.setPsex(rs.getString("petsex"));
//               vo.setPtime(rs.getString("pettime"));
//           }
//       }catch(SQLException ex){
//           ex.printStackTrace();
//       }finally{
//           if(rs!=null){
//               try{
//                   rs.close();
//               }catch(SQLException ex1){
//               }
//               rs=null;
//           }
//           if(stmt!=null){
//               try{
//                   stmt.close();
//               }catch(SQLException ex2){
//               }
//                stmt=null;
//           }
//       }
//       return vo;
//   }

   public PetVO pet_king(String kind){
       PetVO vo=null;
       Statement stmt=null;
       ResultSet rs=null;
      try{
          stmt=JDBC.getConnection().createStatement();
          String sql="select * from VIEW_pet_holdrer where petkind like '%"+kind+"%'";
          rs=stmt.executeQuery(sql);
          if(rs.next()){
              vo=new PetVO();
              vo.setPid(rs.getInt("petid"));
              vo.setHname(rs.getString("holdername"));
              vo.setPhid(rs.getInt("holderid"));
              vo.setPname(rs.getString("petname"));
              vo.setPkind(rs.getString("petkind"));
              vo.setPsex(rs.getString("petsex"));
               vo.setPtime(rs.getString("pettime"));
          }
      }catch(SQLException ex){
          ex.printStackTrace();
      }finally{
          if(rs!=null){
              try{
                  rs.close();
              }catch(SQLException ex1){
              }
              rs=null;
          }
          if(stmt!=null){
              try{
                  stmt.close();
              }catch(SQLException es2){
              }
              stmt=null;
          }
      }
      return vo;
   }
   public boolean pet_add(PetVO vo){
       try{
           String sql="insert into pet_info values (?,?,?,?,default)";
          PreparedStatement stmt=JDBC.getConnection().prepareStatement(sql);
          stmt.setInt(1,vo.getPhid());
          stmt.setString(2,vo.getPname());
          stmt.setString(3,vo.getPkind());
          stmt.setString(4,vo.getPsex());
          int i=stmt.executeUpdate();
          stmt.close();
          if(i>0)
              return true;
          else
              return false;
       }catch(SQLException ex){
           ex.printStackTrace();
           return false;
       }
   }

   public PetVO pet_update (int petid,int id,String name, String kind ,String sex){
       PetVO vo=null;
       Statement stmt =null;
       ResultSet rs=null;
       try{
           stmt =JDBC.getConnection().createStatement();
           String sql="update pet_info set holderid='"+id+"',petname='"+name+"',petkind='"+kind +"',petage='"+sex+"' where petid='"+petid+"'";
           rs=stmt.executeQuery(sql);
           if(rs.next()){
               vo=new PetVO();
               vo.setPid(rs.getInt("petid"));
               vo.setPhid(rs.getInt("holderid"));
               vo.setPname(rs.getString("petname"));
               vo.setPkind(rs.getString("petkind"));
               vo.setPsex(rs.getString("petsex"));
           }
       }catch(SQLException ex){
           ex.printStackTrace();
       }finally{
           if(rs!=null){
               try{
                   rs.close();
               }catch(SQLException ex1){
               }
               rs=null;
           }
           if(stmt!=null){
               try{
                   stmt.close();
               }catch(SQLException ex2){
               }
               stmt=null;
           }
       }
       return vo;
   }
   public static void main(String[] args){
       System.out.println("sdfgdfsgdfg.........");
       PetDAO dao=new PetDAO();
//       PetVO vo=new PetVO();
//           System.out.println();
           Collection c = dao.holder_pet();
           Iterator it = c.iterator();
           while(it.hasNext()){
               System.out.println(it.next().toString());
           }

    }
}

//////////]