Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void actionPerFormed(java.awt.event.ActionEvent e){
- Class.Forname("oracle.jdbc.driver.OracleDriver");
- Connection con= DriverManager.get.Connection("jdbc:oracle:thin:@127.0.0.1:1521:XE","hr","10g");
- String sql= "select *from employees where employee_id=?");
- try{
- PreparedStatement stmt = con.prepareStatment (sql);
- stmt.setInt(1,Interger.parseInt(getTxtCodigo().get Txt ()));
- ResultSet rs=stmt.execute.query();
- if(rs.next()){
- TxtSobrenome.setText(rs.getString("last_name");
- TxtEmail.setText(rs.getString("E-mail");
- TxtData.setText(rs.getString("hire_date");
- TxtFuncao.setText(rs.getString("job_id"));
- }else{
- JOptionPane.show.Message.Dialog(null,"Funcionário Não Localizado");
- } catch(SQLException e1){
- JOptionPane.showMessageDialog(null,"Problemas na Pesquisa");
- e1.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement