Page History
...
- https://spring.io/blog/2011/02/10/getting-started-with-spring-data-jpa/
- https://docs.spring.io/spring-data/jpa/docs/1.5.0.RELEASE/reference/html/jpa.repositories.html
데이터 입력
스토어 프로시져 이용
| Code Block | ||||
|---|---|---|---|---|
| ||||
CREATE OR REPLACE FUNCTION addaddress(
address character varying,
age integer,
name character varying,
sex character varying,
phonenbr character varying,
OUT res int)
RETURNS integer AS $BODY$
DECLARE
address_id int;
BEGIN
-- insert address
INSERT INTO address ( address, age, name,sex,phonenbr) VALUES( address, age, name,sex,phonenbr);
SELECT nextval('address_id') INTO res;
--set res = address_id;
END;
$BODY$
LANGUAGE plpgsql VOLATILE |