DbTech - Share - SoSe 23

create table Student (
  MatrNr integer not null,
  Name varchar2(10) not null,
  Vorname varchar2(10) not null,
  primary key (MatrNr)
);

insert into Student(MatrNr, Name, Vorname) values (50101, 'Svenson', 'Sven');
insert into Student(MatrNr, Name, Vorname) values (50102, 'Clausen', 'Claus');
insert into Student(MatrNr, Name, Vorname) values (50103, 'Jensen', 'Jens');
insert into Student(MatrNr, Name, Vorname) values (50104, 'Hansen', 'Hans');

No DATA FOUND Folie 11

Selbstdefinierte Ausnahmen mit Fehlernummer verbinden 15

delete from student;

declare 
  v_input varchar(10) := '=3';
  v_result integer;
begin
  v_result := regexp_substr(v_input, '=(.*)',1,1,'i',1);
  dbms_output.put_line(v_result);
end;

declare 

  v_input varchar(10) := '=3';

  v_result integer;

begin

  v_result := regexp_substr(v_input, '=(.*)',1,1,'i',1);

  dbms_output.put_line(v_result);

end;

Domain-Klasse

package de.htwberlin.krankenhaus;

public class Patient {
private Integer id;
private String name;

public Patient() {
}

public Patient(Integer id, String name) {
this.id = id;
this.name = name;
}

public Integer getId() {
return id;
}

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

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

@Override
public String toString() {
return "Patient [id=" + id + ", name=" + name + "]";
}

}

Tabelle

create table patient (

pid integer not null primary key,

name varchar2(100)

);

Interface

package de.htwberlin.krankenhaus;

import java.sql.Connection;

public interface IKrankenhausService {
void setConnection(Connection connection);
void speicherePatient(Patient patient);
}