Praktyki - Dzien 03

package service;

import dao.PatientDAO;
import java.util.List;
import javax.jws.WebService;
import javax.jws.WebMethod;
import javax.jws.WebParam;
import model.Patient;

@WebService(serviceName = "patient")
public class app
{
    @WebMethod(operationName = "add")
    public String add(@WebParam(name = "patient") Patient patient)
    {
        PatientDAO patientDAO = new PatientDAO();
        patientDAO.savePatient(patient);
        return "Patient added";
    }
    @WebMethod(operationName = "showAll")
    public List<Patient> showAll()
    {
        PatientDAO patientDAO = new PatientDAO();
        List<Patient> patientList = patientDAO.getPatientList();
        return patientList;
    }
    @WebMethod(operationName = "showOne")
    public Patient showOne(@WebParam(name = "id") long id)
    {
        Patient patient = new Patient();
        PatientDAO patientDAO = new PatientDAO();
        patient = patientDAO.getPatientById(id);
        return patient;
    }
}






package dao;

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;
import model.Patient;
import tool.DBTool;

public class PatientDAO implements IPatientDAO
{
    private Patient parse(ResultSet resultSet) throws SQLException
    {
        Patient patient = new Patient();
        patient.setFirstName(resultSet.getString("FNAME"));
        patient.setMiddleName(resultSet.getString("MNAME"));
        patient.setLastName(resultSet.getString("LNAME"));

        Calendar calendar = Calendar.getInstance();
        calendar.setTime(resultSet.getDate("DOB"));
        patient.setDateOfBirth(calendar);

        patient.setCity(resultSet.getString("CITY"));
        patient.setZipCode(resultSet.getString("ZIP_CODE"));
        patient.setPhone(resultSet.getString("PHONE"));
        patient.setAddress(resultSet.getString("ADDRESS"));
        patient.setBirthCity(resultSet.getString("BIRTH_CITY"));
        patient.setMrn(resultSet.getString("MRN"));
        patient.setId(resultSet.getInt("ID"));
        patient.setSex(resultSet.getString("SEX"));
        patient.setNationality(resultSet.getString("NATIONALITY"));
        patient.setIsDisabled(resultSet.getString("IS_DISABLED"));
        patient.setRace(resultSet.getString("RACE"));
        return patient;
    }
    @Override
    public Patient getPatientById(long id)
    {
        Connection connection = null;
        ResultSet resultSet = null;
        PreparedStatement statement = null;

        Patient patient = new Patient();
        String query = "SELECT * FROM P2_PATIENT p WHERE p.ID = ?";

        try
        {
            DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
            connection = DBTool.startConnection();
            statement = connection.prepareStatement(query);
            statement.setLong(1, id);
            resultSet = statement.executeQuery();
            while(resultSet.next())
            {
                patient = parse(resultSet);
            }
        }
        catch(SQLException exception)
        {
            exception.printStackTrace();
        }
        finally
        {
            try
            {
                statement.close();
                resultSet.close();
                connection.close();
            }
            catch(SQLException exception)
            {
                exception.printStackTrace();
            }
        }
        return patient;
    }
    @Override
    public List<Patient> getPatientList()
    {
        List<Patient> patientList = new ArrayList();

       Connection connection = null;
        ResultSet resultSet = null;
        PreparedStatement statement = null;

        Patient patient = new Patient();
        String query = "SELECT * FROM P2_PATIENT";

        try
        {
            connection = DBTool.startConnection();
            statement = connection.prepareStatement(query);
            resultSet = statement.executeQuery();
            while(resultSet.next())
            {
                patient = new Patient();
                patient = parse(resultSet);
                patientList.add(patient);
            }
        }
        catch(SQLException exception)
        {
            exception.printStackTrace();
        }
        finally
        {
            try
            {
                statement.close();
                resultSet.close();
                connection.close();
            }
            catch(SQLException exception)
            {
                exception.printStackTrace();
            }
        }
        return patientList;
    }
    @Override
    public boolean savePatient(Patient patient)
    {
        boolean  checker = true;
        Connection connection = null;
        PreparedStatement statement = null;

        String query = "INSERT INTO P2_PATIENT VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        try
        {
            connection = DBTool.startConnection();
            statement = connection.prepareStatement(query);
            statement.setString(1, patient.getFirstName());
            statement.setString(2, patient.getMiddleName());
            statement.setString(3, patient.getLastName());

            statement.setDate(4, new Date(patient.getDateOfBirth().getTimeInMillis()));

            statement.setString(5, patient.getCity());
            statement.setString(6, patient.getZipCode());
            statement.setString(7, patient.getPhone());
            statement.setString(8, patient.getAddress());
            statement.setString(9, patient.getBirthCity());
            statement.setString(10, patient.getMrn());
            statement.setLong(11, patient.getId());
            statement.setString(12, patient.getSex());
            statement.setString(13, patient.getNationality());
            statement.setString(14, patient.getIsDisabled());
            statement.setString(15, patient.getRace());
            statement.executeQuery();
            connection.commit();
        }
        catch(SQLException exception)
        {
            exception.printStackTrace();
            checker = false;
        }
        finally
        {
            try
            {
                statement.close();
                 connection.close();
            }
            catch(SQLException exception)
            {
                exception.printStackTrace();
            }
        }
        return checker;
    }
}





package dao;

import java.util.List;
import model.Patient;

public interface IPatientDAO
{
    public Patient getPatientById(long id);

    public List<Patient> getPatientList() ;

    public boolean savePatient(Patient patient);
}






package tool;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBTool
{
    public static Connection startConnection() throws SQLException
    {
        Connection connection = null;

        String port = "1521";
        String address = "iws2";
        String login = "PRAKTYKI";
        String password = "PRAKTYKI";
        String schema = "oraiws.softsystem.pl";

        DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
        connection = DriverManager.getConnection("jdbc:oracle:thin:"+login+"/"+password+"@"+address+":"+port+"/"+schema);

        return connection;
    }
}







package model;

import java.util.Calendar;

public class Patient
{
    private String firstName;
    private String middleName;
    private String lastName;
    private Calendar dateOfBirth;
    private String city;
    private String zipCode;
    private String phone;
    private String address;
    private String birthCity;
    private String mrn;
    private long id;
    private String sex;
    private String nationality;
    private String isDisabled;
    private String race;

    public String getFirstName() {
        return firstName;
    }

    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }

    public String getMiddleName() {
        return middleName;
    }

    public void setMiddleName(String middleName) {
        this.middleName = middleName;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public Calendar getDateOfBirth() {
        return dateOfBirth;
    }

    public void setDateOfBirth(Calendar dateOfBirth) {
        this.dateOfBirth = dateOfBirth;
    }

    public String getCity() {
        return city;
    }

    public void setCity(String city) {
        this.city = city;
    }

    public String getZipCode() {
        return zipCode;
    }

    public void setZipCode(String zipCode) {
        this.zipCode = zipCode;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getBirthCity() {
        return birthCity;
    }

    public void setBirthCity(String birthCity) {
        this.birthCity = birthCity;
    }

    public String getMrn() {
        return mrn;
    }

    public void setMrn(String mrn) {
        this.mrn = mrn;
    }

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getNationality() {
        return nationality;
    }

    public void setNationality(String nationality) {
        this.nationality = nationality;
    }

    public String getIsDisabled() {
        return isDisabled;
    }

    public void setIsDisabled(String isDisabled) {
        this.isDisabled = isDisabled;
    }

    public String getRace() {
        return race;
    }

    public void setRace(String race) {
        this.race = race;
    }

}