package com.aptech.dao;
import java.util.ArrayList;
import com.aptech.entity.PetBean;
import com.aptech.entity.FarrierBean;
import com.aptech.entity.UserBean;
import java.util.List;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class FarrierDAO extends BaseJdbcDAO implements ImFarrier {
public List searchFarrierSpecialties() {
// TODO Auto-generated method stub
ArrayList list = new ArrayList();
PreparedStatement pstmt = null;
String strsql = "select id ,name from specialties";
try
{
pstmt = super.openConn().prepareStatement(strsql);
ResultSet rs = pstmt.executeQuery();
while(rs.next())
{
FarrierBean farrierbean = new FarrierBean();
farrierbean.setId(rs.getInt(1));
farrierbean.setSpecialties(rs.getString(2));
list.add(farrierbean);
}
}catch(Exception ex)
{
ex.printStackTrace();
}
return list;
}
public int addFarrierInfo(FarrierBean farrier)
{
int count = 0;
PreparedStatement pstmt = null;
String strsql = "insert into vets values(?)";
try
{
pstmt = super.openConn().prepareStatement(strsql);
pstmt.setString(1, farrier.getName());
count = pstmt.executeUpdate();
int id= 0 ;
pstmt.close();
super.closeAll(pstmt);
String strid = "select max(id) from vets";
pstmt = super.openConn().prepareStatement(strid);
ResultSet rs = pstmt.executeQuery();
if(rs.next())
{
id = rs.getInt(1);
}
rs.close();
pstmt.close();
super.closeAll(pstmt,rs);
String strsql1 = "insert into vet_specialties values(?,?)";
pstmt = super.openConn().prepareStatement(strsql1);
pstmt.setInt(1, id);
pstmt.setInt(2, farrier.getId());
count = pstmt.executeUpdate();
}catch(Exception ex)
{
ex.printStackTrace();
}
finally
{
super.closeAll(pstmt);
}
return count;
}
public List getFarrierInfo(FarrierBean farrier,int start,int total)
{
List list = new ArrayList();
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "select vets.id,specialties.id, vets.name,specialties.name from vets,specialties,vet_specialties where vets.id=vet_specialties.vet_id and vet_specialties.specialty_id = specialties.id ";
String name = farrier.getName();
String specialy = farrier.getSpecialties();
if(null!=name && !"".equals(name) && null!=specialy && !"".equals(specialy))
{
sql += " and vets.name like '%"+name+"%' and specialties.name like '%"+specialy+"%'";
}
else if(null!=name && !"".equals(name))
{
sql += " and vets.name like '%"+name+"%'";
}
else if(null!=specialy && !"".equals(specialy))
{
sql +=" and specialties.name like '%"+specialy+"%'";
}
try
{
pstmt = super.openConn().prepareStatement(sql);
rs = pstmt.executeQuery();
int index = 0 ;
int size =0 ;
while(rs.next() && size<10)
{
if(index<start)
{
index ++;
continue;
}
FarrierBean farrierbean = new FarrierBean();
farrierbean.setId(rs.getInt(1));
farrierbean.setSpencitly(rs.getInt(2));
farrierbean.setName(rs.getString(3));
farrierbean.setSpecialties(rs.getString(4));
list.add(farrierbean);
farrierbean = null;
size++;
}
}catch(Exception ex)
{
ex.printStackTrace();
}
finally
{
super.closeAll(pstmt, rs);
}
return list;
}
public int getFarrierCount(FarrierBean farrier)
{
int count = 0;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "select count(*) from vets,specialties,vet_specialties where vets.id=vet_specialties.vet_id and vet_specialties.specialty_id = specialties.id ";
String name = farrier.getName();
String specialy = farrier.getSpecialties();
if(null!=name && !"".equals(name) && null!=specialy && !"".equals(specialy))
{
sql += " and vets.name like '%"+name+"%' and specialties.name like '%"+specialy+"%'";
}
else if(null!=name && !"".equals(name))
{
sql += " and vets.name like '%"+name+"%'";
}
else if(null!=specialy && !"".equals(specialy))
{
sql +=" and specialties.name like '%"+specialy+"%'";
}
try
{
pstmt = super.openConn().prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next())
{
count = rs.getInt(1);
}
}catch(Exception ex)
{
ex.printStackTrace();
}
finally
{
super.closeAll(pstmt, rs);
}
return count;
}
public int updateFarrier(FarrierBean farrier)
{
int count = 0 ;
int specilyId = 0;
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
String sql = "select id from specialties where name='"+farrier.getSpecialties().trim()+"'";
try
{
pstmt = super.openConn().prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next())
{
specilyId= rs.getInt(1);
}
super.closeAll(pstmt, rs);
stmt = super.openConn().createStatement();
stmt.addBatch("update vets set name='"+farrier.getName().trim()+"' where id="+farrier.getId()+"");
stmt.addBatch("update vet_specialties set specialty_id="+specilyId+" where specialty_id="+farrier.getSpencitly()+" and vet_id="+farrier.getId()+"");
stmt.executeBatch();
count = 1;
}catch(Exception ex)
{
ex.printStackTrace();
}
finally
{
super.closeAll(stmt);
}
return count;
}
public int deleteFarrier(int farrierId)
{
Statement stmt = null;
int count = 0 ;
try
{
stmt = super.openConn().createStatement();
stmt.addBatch("delete from vet_specialties where vet_id="+farrierId+"");
stmt.addBatch("delete from vets where id="+farrierId+"");
stmt.executeBatch();
count = 1;
}catch(Exception ex)
{
ex.printStackTrace();
}
finally
{
super.closeAll(stmt);
}
return count;
}
public List getFarrierName()
{
List list = new ArrayList();
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "select distinct name from vets";
try
{
pstmt = super.openConn().prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next())
{
list.add(rs.getString(1));
}
}catch(Exception ex)
{
ex.printStackTrace();
}
finally
{
super.closeAll(pstmt, rs);
}
return list;
}
public List getCaseInfo(FarrierBean farrier,int start)
{
List list = new ArrayList();
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "select visits.id, pets.Name ,visits.visit_date,visits.[description] from pets,visits where pets.id = visits.id ";
if(farrier.getName()!=null && !"".equals(farrier.getName()) && null !=farrier.getMaxdate() && !"".equals(farrier.getMaxdate()))
{
sql+=" and pets.Name like '%"+farrier.getName()+"%' and visits.visit_date between '"+farrier.getVistidate()+"' and '"+farrier.getMaxdate()+"'";
}
else if(farrier.getName()!=null && !"".equals(farrier.getName()))
{
sql += " and pets.Name like '%"+farrier.getName()+"%'";
}
else if( null !=farrier.getMaxdate() && !"".equals(farrier.getMaxdate()))
{
sql += " and visits.visit_date between '"+farrier.getVistidate()+"' and '"+farrier.getMaxdate()+"'";
}
sql += " order by update_date desc ";
try
{
pstmt = super.openConn().prepareStatement(sql);
rs = pstmt.executeQuery();
int index = 0 ;
int total = 0 ;
while(rs.next() && total<10)
{
if(index<start)
{
index++;
continue;
}
farrier = new FarrierBean();
farrier.setId(rs.getInt(1));
farrier.setName(rs.getString(2));
farrier.
S2结业项目宠物诊所
需积分: 15 7 浏览量
2008-09-30
09:24:41
上传
评论
收藏 2.96MB RAR 举报
S2结业项目宠物诊所 （353个子文件） 
top3.bmp 593KB top2.bmp 558KB top1.bmp 518KB top.bmp 422KB left.bmp 261KB
PetDAO.class 10KB FarrierDAO.class 10KB UserDAO.class 9KB ScrapDAO.class 7KB EmployeeDAO.class 6KB pageTest_jsp.class 5KB FarrierAction.class 4KB pageTest_jsp.class 4KB Page.class 4KB Page.class 4KB Page.class 4KB OwnerCityServlet.class 4KB Page1.class 4KB UserLogin.class 4KB EmployeeNameServlet.class 3KB FarrierNameServlet.class 3KB PetOwnerServlet.class 3KB petNameServlet.class 3KB MessageDAO.class 3KB AddScrapAction.class 3KB VerifyServlet.class 3KB EpetOwnerAction.class 3KB PetService.class 3KB PetOwnerHandleAction.class 3KB ImageUtils.class 3KB FarrierHandleAction.class 2KB FarrierSearchAction.class 2KB EmployeeAction.class 2KB PetAllInfoAction.class 2KB EpetAction.class 2KB EmployeeSearch.class 2KB PageTestServlet.class 2KB PageTestServlet.class 2KB OwnerPetInfoAction.class 2KB PetOwnerSearchAction.class 2KB FarrierBizImpl.class 2KB ScrapBizImpl.class 2KB EmployeeHandle.class 2KB PetBizImpl.class 2KB MessageHandleAction.class 2KB PetHairdressing.class 2KB HandleDisplayPage.class 2KB PetFeedAction.class 2KB PetTalkAction.class 2KB CureAction.class 2KB UserBizImpl.class 2KB BaseJdbcDAO.class 2KB StringUtils.class 2KB EmployeeBizImpl.class 2KB PetBean.class 2KB PetShow.class 2KB UserService.class 2KB FarrierBean.class 2KB PetHandleAction.class 2KB UpdateUserAction.class 2KB MessageAction.class 2KB PetEditAction.class 2KB OwnerUpdateAction.class 2KB UserPetBean.class 1KB EmployeeBean.class 1KB UserBean.class 1KB PetDeleteAction.class 1KB ScrapAction.class 1KB LogoutAction.class 1KB FarrierAddAction.class 1KB PetSearchAction.class 1KB PetAddAction.class 1KB EpetOwner.class 1KB PetUpdateAction.class 1KB CharValidate.class 1KB NameService.class 1KB UserEmployeeForm.class 1KB EmployeeForm.class 1KB PetCaseForm.class 1KB FarrierForm.class 1KB EpetOwnerForm.class 1KB UserForm.class 1KB ScrapForm.class 1KB EpetCaseAction.class 1KB PetForm.class 1KB PetNameAction.class 1KB EpetCaseSearchAction.class 1016B PetOwnerAddAction.class 1004B EmployeeAddAction.class 1004B EpetCaseAddAction.class 1003B MessageBizImpl.class 992B MessageBean.class 917B PetCaseBean.class 767B ExendString.class 755B ImFarrierBiz.class 649B ImFarrier.class 643B ImPetBiz.class 639B ImPet.class 638B ImScrapBiz.class 621B ImEmployeeBiz.class 618B共 353 条
- 1
- 2
- 3
- 4
资源评论
