asd

package data;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.PreparedStatement;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.RequestScoped;
import javax.faces.event.ActionEvent;
import javax.servlet.jsp.jstl.sql.Result;
import javax.servlet.jsp.jstl.sql.ResultSupport;

@ManagedBean(name = "bazaBean")
@RequestScoped
public class Baza {
    private Result osoby = null;
    private Osoba osoba;
    private Connection conn;

    public Baza() {
        try {
            DriverManager.registerDriver(new com.ibm.db2.jcc.DB2Driver());
            conn = DriverManager.getConnection(
                    "jdbc:db2://5.10.125.192:50000/SQLDB:retrieveMessagesFromServerOnGetMessage=true;",
                    "user05433",
                    "ErbX4eSSonU4");
        } catch (Exception e) {
            int a = 10;
            int b = a+2;
            // throw;
        }
    }

    public Result getOsoby() {
        try {
            Statement stmt = conn.createStatement();
            ResultSet rset = stmt.executeQuery("SELECT * FROM USER05433.OSOBA");
            osoby = ResultSupport.toResult(rset);
            stmt.close();
        } catch (Exception e) {
        }
        return osoby;
    }

    public void saveOsoba(Osoba osoba) {
        try {
            PreparedStatement stmt = conn.prepareStatement("INSERT INTO OSOBA (IMIE, NAZWISKO, PESEL) VALUES (?,?, ?)");
            stmt.setString(1, osoba.getImie());
            stmt.setString(2, osoba.getNazwisko());
            stmt.setString(3, osoba.getPesel());
            stmt.executeUpdate();
            stmt.close();
        } catch (Exception e) {
        }
        return;
    }

    public void deleteOsoba(String pesel) {
        try {
            PreparedStatement stmt = conn.prepareStatement("DELETE FROM OSOBA WHERE PESEL = ?");
            stmt.setString(1, pesel);
            stmt.executeUpdate();
            stmt.close();
        } catch (Exception e) {
        }
        return;
    }


    public Osoba loadOsobaByPesel (String pesel1) {
        try {
        PreparedStatement stmt = conn.prepareStatement("SELECT * FROM OSOBA WHERE PESEL = ? ");
        stmt.setString(1, pesel1);
        ResultSet rset = stmt.executeQuery ();
        osoba = new Osoba() ;
        while (rset.next()) {
        osoba.setNazwisko ( rset.getString("NAZWISKO") ) ;
        osoba.setImie ( rset.getString("IMIE") ) ;
        osoba.setPesel ( rset.getString("PESEL") ) ;
        }
        stmt.close() ;
        } catch (Exception e) {}
        return osoba ;
        }

    public void updateOsoba (Osoba osoba) {
        try {
        PreparedStatement stmt = conn.prepareStatement("UPDATE OSOBA SET IMIE = ?, NAZWISKO = ?  WHERE PESEL = ?");
        stmt.setString(1, osoba.getImie());
        stmt.setString(2, osoba.getNazwisko());
        stmt.setString(3, osoba.getPesel());
        stmt.executeUpdate();
        stmt.close() ;
        } catch (Exception e) {}
        return  ;
        }
}