vetdao.java~7~

这是java编写宠物医院项目

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

public class VetDAO {
    public VetDAO() {
    }

    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 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;
        }

        public boolean vet_add(VetVO vo ){
            try{
                PreparedStatement stmt=JDBC.getConnection().prepareStatement(
                     "insert into vet_info values(?,?,?,?,?,default)");
             stmt.setString(1,vo.getVname());
             stmt.setString(2,vo.getVsex());
             stmt.setInt(3,vo.getVage());
             stmt.setString(4,vo.getVsp());
             stmt.setString(5,vo.getVaddress());
             int i=stmt.executeUpdate();
             stmt.close();
             if(i>0)
                 return true;
             else
                 return false;
            }catch(SQLException ex){
                ex.printStackTrace();
                return false;
            }
        }
    public static void main(String[] args){
        VetDAO dao=new VetDAO();
        Map m=dao.vetuser_name("寮