Page History
...
Code Block | ||||
---|---|---|---|---|
| ||||
CREATE OR REPLACE FUNCTION addaddress( address character varying, age integer, name character varying, sex character varying, phonenbr character varying ) RETURNS integer AS $BODY$ BEGIN INSERT INTO address ( address, age, name,sex,phonenbr) VALUES( address, age, name,sex,phonenbr); return 0; END; $BODY$ LANGUAGE plpgsql VOLATILE |
No Format |
---|
public interface AddressRepo extends CrudRepository<Address, Long>{
@Procedure
public Integer addaddress(String address,Integer age, String name, String sex, String phonenbr);
}
//SP 호출방법
addressRepo.addaddress("독도", 45, "포켓몬", "남", "010-1233-3321");
//호출로그
Hibernate:
{call addaddress(?,?,?,?,?,?)} |
more info: http://roufid.com/3-ways-to-call-a-stored-procedure-with-hibernate-jpa-2-1/
...