hospitaldao.java~13~

来自「这是java编写宠物医院项目」· JAVA~13~ 代码 · 共 113 行

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 HospitalVO hospital_pet_name(String name){
        HospitalVO vo=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()){
                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));
            }
        }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 boolean hospital_add(HospitalVO  vo){
        try{
        String sql="insert into pet_iness valuse(?,?,?,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 static void main(String[] args){
    System.out.println("sdfgdfsgdfg.........");
    HospitalDAO dao=new HospitalDAO();
    HospitalVO  vo=new HospitalVO();
    vo.setVid(3);
    vo.setPid(3);
    vo.setHospital("鎰熷啋");
    if(dao.hospital_add(vo))
        System.out.println("ok....");
    else
        System.out.println("no....");

  }
}