Advertisement
Guest User

Untitled

a guest
Aug 19th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. public void actionPerFormed(java.awt.event.ActionEvent e){
  2. Class.Forname("oracle.jdbc.driver.OracleDriver");
  3. Connection con= DriverManager.get.Connection("jdbc:oracle:thin:@127.0.0.1:1521:XE","hr","10g");
  4. String sql= "select *from employees where employee_id=?");
  5. try{
  6. PreparedStatement stmt = con.prepareStatment (sql);
  7. stmt.setInt(1,Interger.parseInt(getTxtCodigo().get Txt ()));
  8. ResultSet rs=stmt.execute.query();
  9. if(rs.next()){
  10. TxtSobrenome.setText(rs.getString("last_name");
  11. TxtEmail.setText(rs.getString("E-mail");
  12. TxtData.setText(rs.getString("hire_date");
  13. TxtFuncao.setText(rs.getString("job_id"));
  14. }else{
  15. JOptionPane.show.Message.Dialog(null,"Funcionário Não Localizado");
  16. } catch(SQLException e1){
  17. JOptionPane.showMessageDialog(null,"Problemas na Pesquisa");
  18. e1.printStackTrace();
  19. }
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement