package leoniak_bartek_jsp;

import java.sql.*;

public class leoniak_bartek {
	private String nr_ewidencyjny;
	private String gatunek;
	private String dlugosc;
	private String waga_kg;
	private Date data_polowu;
	private boolean drapiezna;
	private String opis;
	private Connection myConn;
	private String akcja;
	private int rowId;
	

	
	
	public void setAkcja(String akcja) {
		this.akcja = akcja;		
		connDB();
		switch(akcja) {
		case "first":
			try{
				rowId=1;
				Statement stmt = myConn.createStatement();
				ResultSet rs = stmt.executeQuery("SELECT * from ryby");
				if(rs.next()){
					setNr_ewidencyjny(rs.getString(1));
					setGatunek(rs.getString(2));
					setDlugosc(rs.getString(3));
					setWaga_kg(rs.getString(4));
					//setData_polowu(rs.getDate(5));
					setOpis(rs.getString(6));
					setDrapiezna(rs.getBoolean(7));
				}
			}
			catch (Exception e){
				e.printStackTrace();
			}
			break;
		case "prev":
			try{
				if(rowId != 1){
					rowId -=1;
				}
				Statement stmt = myConn.createStatement();
				ResultSet rs = stmt.executeQuery("SELECT * from ryby");
				int i = 1;
				while(rs.next()){
					if(i == rowId){
						setNr_ewidencyjny(rs.getString(1));
						setGatunek(rs.getString(2));
						setDlugosc(rs.getString(3));
						setWaga_kg(rs.getString(4));
						//setData_polowu(rs.getDate(5));
						setOpis(rs.getString(6));
						setDrapiezna(rs.getBoolean(7));
						break;
					}
					i++;
				}
			}
			catch (Exception e){
				e.printStackTrace();
			}
			break;
		case "next":
			try{
				rowId += 1;
				Statement stmt = myConn.createStatement();
				ResultSet rs = stmt.executeQuery("SELECT * from ryby");
				int i = 1;
				boolean flag = false;
				while(rs.next()){
					if(i == rowId){
						setNr_ewidencyjny(rs.getString(1));
						setGatunek(rs.getString(2));
						setDlugosc(rs.getString(3));
						setWaga_kg(rs.getString(4));
						//setData_polowu(rs.getDate(5));
						setOpis(rs.getString(6));
						setDrapiezna(rs.getBoolean(7));
						flag = true;
						break;
					}
					i++;
				}
				if(flag == false){
					rowId--;
				}
			}
			catch (Exception e){
				e.printStackTrace();
			}
			break;
		case "last":
			try{
				Statement stmt = myConn.createStatement();
				ResultSet rs = stmt.executeQuery("SELECT * from ryby");
				int i = 0;
				while(rs.next()){
					i++;
				}
				rowId = i;	
				Statement stmt2 = myConn.createStatement();
				ResultSet rs2 = stmt2.executeQuery("SELECT * from ryby");
				int j = 1;
				while(rs2.next()){
					if(rowId == j){
						setNr_ewidencyjny(rs2.getString(1));
						setGatunek(rs2.getString(2));
						setDlugosc(rs2.getString(3));
						setWaga_kg(rs2.getString(4));
						//setData_polowu(rs2.getDate(5));
						setOpis(rs2.getString(6));
						setDrapiezna(rs2.getBoolean(7));
						break;
					}
					j++;
				}	
			}
			catch(Exception e){
				e.printStackTrace();
			}
			break;
		case "update":
			try{
				Statement stmt = myConn.createStatement();
				String stmtStr = "UPDATE ryby SET "+
						"nr_ewidencyjny = '" + getNr_ewidencyjny() + "', "
						+ "gatunek = '" + getGatunek() + "', "
						+ "dlugosc = '" + getDlugosc() + "', "
						+ "waga_kg = " + getWaga_kg() + ", "
						+ "data_polowu = " + getData_polowu() + ", "
						+ "drapiezna = " + getDrapiezna()  + "', "
						+ "opis = '" + getOpis() + " WHERE nr_ewidencyjny = '" + getNr_ewidencyjny() + "'";
				stmt.executeUpdate(stmtStr);
			}
			catch(Exception e){
				e.printStackTrace();
			}
			break;
		case "delete":
			try{
				Statement stmt = myConn.createStatement();
				String stmtStr = "DELETE from ryby WHERE nr_ewidencyjny = '" + getNr_ewidencyjny() + "'";
				stmt.executeUpdate(stmtStr);
				
				Statement stmt1 = myConn.createStatement();
				ResultSet rs = stmt1.executeQuery("SELECT * from ryby");
				int i = 1;
				boolean flag = false;
				while(rs.next()){
					if(i == rowId){
						setNr_ewidencyjny(rs.getString(1));
						setGatunek(rs.getString(2));
						setDlugosc(rs.getString(3));
						setWaga_kg(rs.getString(4));
						//setData_polowu(rs.getDate(5));
						setDrapiezna(rs.getBoolean(6));
						setOpis(rs.getString(7));
						flag = true;
						break;
					}
					i++;
				}
				if(flag == false){
					rowId--;
					setAkcja("last");
				}
				
			}
			catch(Exception e){
				e.printStackTrace();
			}
			break;
		default:
			break;
		}
		discDB();
	}

	
	
	public void connDB() {		
		try {
			Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
			System.out.println("driver OK");
			myConn = DriverManager.getConnection("jdbc:derby:leoniak_bartek");
			System.out.println("baza OK");	
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public void discDB() {
		try {
			myConn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public void setNr_ewidencyjny(String nr_ewidencyjny) {
		this.nr_ewidencyjny = nr_ewidencyjny;
	}
	
	public void setGatunek(String gatunek) {
		this.gatunek = gatunek;
	}
	
	public void setDlugosc(String dlugosc) {
		this.dlugosc = dlugosc;
	}
	
	public void setWaga_kg(String waga_kg) {
		this.waga_kg = waga_kg;
	}
	
	public void setData_polowu(Date data_polowu) {
		this.data_polowu = data_polowu;
	}
	
	public void setDrapiezna(boolean drapiezna) {
		this.drapiezna = drapiezna;
	}
	
	public void setOpis(String opis) {
		this.opis = opis;
	}
	

	
	public String getNr_ewidencyjny() {
		return nr_ewidencyjny;
	}
	
	
	public String getGatunek() {
		return gatunek;
	}
	
	public String getDlugosc() {
		return dlugosc;
	}
	
	public String getWaga_kg() {
		return waga_kg;
	}
	
	public Date getData_polowu() {
		return data_polowu;
	}
	
	public boolean getDrapiezna(){
		return drapiezna;
	}
	
	public String getOpis() {
		return opis;
	}
	
}