Advertisement
Guest User

Untitled

a guest
Nov 21st, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.74 KB | None | 0 0
  1. public boolean addDepartamentos(String nomeFac, Departamentos d) throws RemoteException {
  2.         String sql_request = "INSERT INTO DEPARTAMENTOS(NOMED,NOMEF,LOCALD) VALUES (?,?,?)" +
  3.                 "SELECT NOMEF FROM FACULDADES WHERE NOMEF=nomeFac";
  4.        
  5.         try{
  6.             PreparedStatement prepStat;
  7.             prepStat = connection.prepareStatement(sql_request);
  8.             prepStat.setString(1,d.getNome());
  9.             prepStat.setString(2, ); //o que se coloca aqui
  10.             prepStat.setString(3,d.getLocal());
  11.             prepStat.executeUpdate();
  12.  
  13.             prepStat.close();
  14.  
  15.  
  16.         }catch(SQLException se){
  17.             System.out.println(se.getMessage());
  18.             return false;
  19.         }
  20.         return true;
  21.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement