April 05
Prof. Ismael H. F. Santos
- ismael@tecgraf.puc-rio.br
2
Criar uma stored procedure
Connection db =
DriverManager.getConnection(url,user,pass);
Statement st =
db.createStatement();
int ok =
st.executeUpdate("create function "+
"verifica
(varchar,varchar) "+
"returns
boolean as "+
"'select
count(nome)=1 from senhas "+
" where nome =
$1 and senha = $2;' "+
"language
'sql'");
System.out.println("ok.");
st.close();
db.close();