Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 ;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement