|
|
|
package com.mycompany.blooddonorswebservice; |
|
|
|
import java.sql.*; |
|
import java.util.ArrayList; |
|
import java.util.List; |
|
import javax.ws.rs.core.Response; |
|
|
|
public class DataService { |
|
Connection conn; |
|
public void connect(){ |
|
try{ |
|
Class.forName("com.mysql.jdbc.Driver"); |
|
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/kanbagisi","root",""); |
|
}catch(Exception e){ |
|
System.out.println("hata"+e.getMessage()); |
|
} |
|
} |
|
public List<Data> getAllDonors(){ |
|
connect(); |
|
List<Data> donors=new ArrayList<>(); |
|
try{ |
|
PreparedStatement ps=conn.prepareStatement("Select isim,soyisim,eposta,adres from bilgiler"); |
|
ResultSet rs=ps.executeQuery(); |
|
while(rs.next()){ |
|
Data b=new Data(); |
|
b.setIsim(rs.getString("isim")); |
|
b.setSoyisim(rs.getString("soyisim")); |
|
b.setEposta(rs.getString("eposta")); |
|
b.setAdres(rs.getString("adres")); |
|
donors.add(b); |
|
} |
|
}catch(Exception e){ |
|
System.out.println("hata"+e.getMessage()); |
|
} |
|
return donors; |
|
} |
|
public List<Data> getDonorsByCountry(String country){ |
|
connect(); |
|
int i=1; |
|
|
|
List<Data> donors2=new ArrayList<>(); |
|
try{ |
|
PreparedStatement ps=conn.prepareStatement("Select isim,soyisim,eposta,adres from bilgiler where adres like %?%"); |
|
ps.setString(1,country); |
|
ResultSet rs=ps.executeQuery(); |
|
while(rs.next()){ |
|
Data co=new Data(); |
|
co.setIsim(rs.getString("isim")); |
|
co.setSoyisim(rs.getString("soyisim")); |
|
co.setEposta(rs.getString("eposta")); |
|
co.setAdres(rs.getString("adres")); |
|
donors2.add(co); |
|
} |
|
|
|
}catch(Exception e){ |
|
System.out.println("hata"+e.getMessage()); |
|
} |
|
return donors2; |
|
} |
|
//------------ |
|
public List<Data> getDonorsByBloodGroup(String bloodGroup){ |
|
connect(); |
|
|
|
List<Data> donors3=new ArrayList<>(); |
|
try{ |
|
PreparedStatement ps=conn.prepareStatement("Select isim,soyisim,eposta,adres from bilgiler where kangrubu like %?%"); |
|
ps.setString(1,bloodGroup); |
|
ResultSet rs=ps.executeQuery(); |
|
while(rs.next()){ |
|
Data blo=new Data(); |
|
blo.setIsim(rs.getString("isim")); |
|
blo.setSoyisim(rs.getString("soyisim")); |
|
blo.setEposta(rs.getString("eposta")); |
|
blo.setAdres(rs.getString("adres")); |
|
donors3.add(blo); |
|
} |
|
}catch(Exception e){ |
|
// |
|
} |
|
return donors3; |
|
} |
|
public List<Data> getDonorsByCountryAndBloodGroup(String country,String bloodgroup){ |
|
connect(); |
|
|
|
List<Data> donors4=new ArrayList<>(); |
|
try{ |
|
PreparedStatement ps=conn.prepareStatement("Select isim,soyisim,eposta,adres from bilgiler where kangrubu like %?% and adres like %?%"); |
|
ps.setString(1,bloodgroup); |
|
ps.setString(2,country); |
|
ResultSet rs=ps.executeQuery(); |
|
while(rs.next()){ |
|
Data tw=new Data(); |
|
tw.setIsim(rs.getString("isim")); |
|
tw.setSoyisim(rs.getString("soyisim")); |
|
tw.setEposta(rs.getString("eposta")); |
|
tw.setAdres(rs.getString("adres")); |
|
donors4.add(tw); |
|
} |
|
}catch(Exception e){ |
|
// System.out.println("hata"+e.getMessage()); |
|
} |
|
return donors4; |
|
} |
|
public Response addDonor(Data data){ |
|
connect(); |
|
try{ |
|
PreparedStatement ps=conn.prepareStatement("insert into bilgiler(isim,soyisim,eposta,telefon" |
|
+ ",adres,kangrubu,sifre) values(?,?,?,?,?,?,?)"); |
|
ps.setString(1,data.getIsim()); |
|
ps.setString(2,data.getSoyisim()); |
|
ps.setString(3,data.getEposta()); |
|
ps.setString(4,data.getTelefon()); |
|
ps.setString(5,data.getAdres()); |
|
ps.setString(6,data.getKangrubu()); |
|
ps.setString(7,data.getSifre()); |
|
ps.executeUpdate(); |
|
return Response.ok("Başarılı").build(); |
|
}catch(Exception e){ |
|
System.out.println("hata"+e.getMessage()); |
|
} |
|
return Response.status(Response.Status.NOT_IMPLEMENTED).build(); |
|
} |
|
} |