hospitaldao.java~35~

这是java编写宠物医院项目

package hospital;

import java.util.Collection;
import java.sql.*;
import java.sql.ResultSet;
import java.util.*;
import java.sql.SQLException;
import jdbc.JDBC;
import java.sql.PreparedStatement;

public class HospitalDAO {
    public HospitalDAO() {
    }
    public Collection hospital_info(){
        ArrayList al=new ArrayList(10);
        try{
            Statement stmt=JDBC.getConnection().createStatement();
            ResultSet rs=stmt.executeQuery("select * from VIEW_holder_vet_pet_iness");
            while (rs.next()){
                HospitalVO vo=new HospitalVO();
                vo.setId(rs.getInt(1));
                vo.setVid(rs.getInt(2));
                vo.setVname(rs.getString(3));
                vo.setHid(rs.getInt(4));
                vo.setHname(rs.getString(5));
                vo.setPid(rs.getInt(6));
                vo.setPname(rs.getString(7));
                vo.setHospital(rs.getString(8));
                vo.setTime(rs.getString(9));
                al.add(vo);
            }
            rs.close();
            stmt.close();
        }catch(SQLException ex){
            ex.printStackTrace();
        }
        return al;
    }

    public Collection hospital_pet_name(String name){
        HospitalVO vo=null;
        Collection caseNameList = null;
        Statement stmt=null;
        ResultSet rs=null;
        try{
            stmt=JDBC.getConnection().createStatement();
            String sql="select * from VIEW_holder_vet_pet_iness where petname like'%"+name+"%' ";
            rs=stmt.executeQuery(sql);
            if(rs.next()){
                caseNameList = new ArrayList();
                do{
                    vo = new HospitalVO();
                    vo.setId(rs.getInt(1));
                    vo.setVid(rs.getInt(2));
                    vo.setVname(rs.getString(3));
                    vo.setHid(rs.getInt(4));
                    vo.setHname(rs.getString(5));
                    vo.setPid(rs.getInt(6));
                    vo.setPname(rs.getString(7));
                    vo.setHospital(rs.getString(8));
                    vo.setTime(rs.getString(9));
                    caseNameList.add(vo);
                }while(rs.next());
            }
        }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 caseNameList;
    }
    ///
//    public Collection holder_name(String name){
//       Collection caseNameList = null;
//       Statement stat = null;
//       ResultSet rs = null;
//       try {
//           String sql = "select * from holder_info where holdername like'%" + name +"%'";
//           stat = JDBC.getConnection().createStatement();
//           rs = stat.executeQuery(sql);
//           if(rs.next()){
//               caseNameList = new ArrayList();
//               do{
//                   HolderVO vo = new HolderVO();
//                   vo.setId(rs.getInt(1));
//                   vo.setName(rs.getString(2));
//                   vo.setSex(rs.getString(3));
//                   vo.setAge(rs.getInt(4));
//                   vo.setAddress(rs.getString(5));
//                   vo.setTime(rs.getString(6));
//                   caseNameList.add(vo);
//               }while(rs.next());
//           }
//
//
//    //
//
    public boolean hospital_add(HospitalVO  vo){
        try{
        String sql="insert into pet_iness values (?,?,?,default)";
        PreparedStatement stmt=JDBC.getConnection().prepareStatement(sql);
        stmt.setInt(1,vo.getVid());
        stmt.setInt(2,vo.getPid());
        stmt.setString(3,vo.getHospital());
        int i=stmt.executeUpdate();
        stmt.close();
        if(i>0)
            return true;
        else
            return false;
        }catch(SQLException ex){
            ex.printStackTrace();
            return false;
        }
    }
    public boolean hosp_update(HospitalVO vo){
      try{
         String sql="update pet_iness set vetid=?,petid=?,iness=? where pet_ailid='?";
         PreparedStatement stmt=JDBC.getConnection().prepareStatement(sql);
         stmt.setInt(1,vo.getVid());
         stmt.setInt(2,vo.getPid());
         stmt.setString(3,vo.getHospital());
         stmt.setInt(4,vo.getId());
         int i=stmt.executeUpdate();
//          if(rs.next()){
//              vo=new HospitalVO();
//              vo.setId(rs.getInt(1));
//              vo.setVid(rs.getInt(2));
//              vo.setPid(rs.getInt(3));
//              vo.setHospital(rs.getString(4));
//          }
         if(i>0)
             return true;
         else
             return false;
         }catch(SQLException ex){
             ex.printStackTrace();
             return false;
         }
    }

    public static void main(String[] args){
    System.out.println("sdfgdfsgdfg.........");
    HospitalDAO dao=new HospitalDAO();
//    Collection  c=dao.hospital_pet_name("姹