vetdao.java

这是java编写宠物医院项目

package vet;
import java.sql.*;
import java.util.*;
import jdbc.*;

public class VetDAO {
    public VetDAO() {
    }            Statement stat=null;
            ResultSet rs=null;

    public Collection vet_select(){
        ArrayList al = new ArrayList(10);
        try {
            Statement stmt1 = JDBC.getConnection().createStatement();
            ResultSet rs = stmt1.executeQuery("select * from vet_info");
            while (rs.next()) {
                VetVO tvo = new VetVO();
                tvo.setVid(rs.getInt("vetid"));
                tvo.setVname(rs.getString("vetname"));
                tvo.setVsex(rs.getString("vetsex"));
                tvo.setVage(rs.getInt("vetage"));
                tvo.setVsp(rs.getString("vetspeciality"));
                tvo.setVaddress(rs.getString("vetaddress"));
                tvo.setVtime(rs.getString("vettime"));
                al.add(tvo);
            }
            rs.close();
            stmt1.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return al;
    }


    //鏄剧ず涓嶉噸澶嶇殑涓撲笟鍚嶇О
    public Collection vet_zy(){
         ArrayList al=new ArrayList(10);
         try{
             Statement stmt1=JDBC.getConnection().createStatement();
             ResultSet rs=stmt1.executeQuery("select DISTINCT  vetspeciality from vet_info");
             while(rs.next()){
            String tvo=rs.getString(1);
             al.add(tvo);
             }
             rs.close();
             stmt1.close();
         }catch (SQLException ex) {
         ex.printStackTrace();
     }
     return al;
    }

    public Collection select_zy1(String zhuanye){
      Collection vetList = null;
      try {
          String sql="select * from vet_info where vetspeciality like'%"+zhuanye+"%'";
          stat = JDBC.getConnection().createStatement();
          rs = stat.executeQuery(sql.toString());
          if(rs.next()){
              vetList = new ArrayList();
              do {
                  VetVO vet = new VetVO();
                  vet = new VetVO();
                  vet.setVid(rs.getInt("vetid"));
                  vet.setVname(rs.getString("vetname"));
                  vet.setVsex(rs.getString("vetsex"));
                  vet.setVage(rs.getInt("vetage"));
                  vet.setVsp(rs.getString("vetspeciality"));
                  vet.setVaddress(rs.getString("vetaddress"));
                  vet.setVtime(rs.getString("vettime"));
                  vetList.add(vet);
              } 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 Map vetselect_zhuaye(String zhuanye) {
//            VetVO vet=null;
//            Statement stmt=null;
//            ResultSet rs=null;
//            Map map=null;
//            try{
//                stmt=JDBC.getConnection().createStatement();
//                String sql="select * from vet_info where vetspeciality like'%"+zhuanye+"%'";
//                rs=stmt.executeQuery(sql);
//
//                if(rs.next()){
//                    map=new HashMap();
//                    do{
//                       // int i=1;
//                        vet = new VetVO();
//                        vet.setVid(rs.getInt("vetid"));
//                        vet.setVname(rs.getString("vetname"));
//                        vet.setVsex(rs.getString("vetsex"));
//                        vet.setVage(rs.getInt("vetage"));
//                        vet.setVsp(rs.getString("vetspeciality"));
//                        vet.setVaddress(rs.getString("vetaddress"));
//                        vet.setVtime(rs.getString("vettime"));
//                        map.put(rs.getObject(1),vet);
//                    }while(rs.next());
//                }
//            }catch(SQLException ex){
//                ex.printStackTrace();
//            }finally{
//                if(rs!=null){
//                    try{
//                        rs.close();
//                    }catch(SQLException ex){
//                    }
//                    rs=null;
//                }
//                if(stmt!=null){
//                    try{
//                        stmt.close();
//                    }catch(SQLException ex2){
//                    }
//                    stmt=null;
//                }
//            }
//            return map;
//        }
//
        public Map vetuser_name(String name ){
            VetVO vetuser=null;
            Statement stmt=null;
            ResultSet rs=null;
            Map map=null;
            try{
                stmt=JDBC.getConnection().createStatement();
                String sql ="select * from vet_info where vetname like'%"+name+"%'";
                rs=stmt.executeQuery(sql);
                if(rs.next()){
                    map=new HashMap();
                    do{
                        vetuser = new VetVO();
                        vetuser.setVid(rs.getInt("vetid"));
                        vetuser.setVname(rs.getString("vetname"));
                        vetuser.setVsex(rs.getString("vetsex"));
                        vetuser.setVage(rs.getInt("vetage"));
                        vetuser.setVsp(rs.getString("vetspeciality"));
                        vetuser.setVaddress(rs.getString("vetaddress"));
                        vetuser.setVtime(rs.getString("vettime"));
                        map.put(rs.getObject(1),vetuser);
                    }while(rs.next());
                }
            }catch(SQLException ex){
                ex.printStackTrace();
            }finally{
                if(rs!=null){
                    try{
                        rs.close();
                    }catch(SQLException ex){
                    }
                    rs=null;
                }
                if(stmt!=null){
                    try{
                        stmt.close();
                    }catch(SQLException ex2){
                    }
                    stmt=null;
                }
            }
            return map;
        }

        /**
         * 閫氳繃杈撳叆鏌ヨ