Guest User

Untitled

a guest
Nov 18th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.46 KB | None | 0 0
  1. /*
  2. * To change this license header, choose License Headers in Project Properties.
  3. * To change this template file, choose Tools | Templates
  4. * and open the template in the editor.
  5. */
  6. package aerolinea;
  7.  
  8. import aerolinea.Ventanas.Pasajero;
  9. import java.sql.*;
  10. import javax.swing.JOptionPane;
  11.  
  12. /**
  13. *Cliente
  14. * @author others
  15. * se crea el cliente
  16. */
  17. public class Cliente {
  18. public String nombre;
  19. public int cedula;
  20. public int telefono;
  21. public String correo;
  22. /**
  23. * Datos ´personales del cliente
  24. * @param nombre Nombre del cliente
  25. * @param cedula cedukla del cliente
  26. * @param telefono telefono del cliente
  27. * @param correo correo del cliente
  28. */
  29. public Cliente(String nombre, int cedula, int telefono, String correo) {
  30. this.nombre = nombre;
  31. this.cedula = cedula;
  32. this.telefono = telefono;
  33. this.correo = correo;
  34. }
  35.  
  36. public Cliente() {
  37. }
  38.  
  39. /**
  40. * Se imprime los datos del cliente
  41. */
  42. public void p(){
  43. System.out.println(this.nombre);
  44. System.out.println(this.cedula);
  45. System.out.println(this.telefono);
  46. System.out.println(this.correo);
  47. }
  48.  
  49. public void registro(){
  50. Pasajero pa = new Pasajero();
  51. try {
  52. Connection cn = DriverManager.getConnection("jdbc:mysql://localhost/proyectoavion", "root", "");
  53. PreparedStatement pst = cn.prepareStatement("insert into pasajeros values (?,?,?,?)");
  54. pst.setString(1, pa.campoNombre.getText());
  55. pst.setString(2, pa.campoID.getText());
  56. pst.setString(3, pa.campoTel.getText());
  57. pst.setString(4,pa.campoEmail.getText());
  58. pst.executeUpdate();
  59. pa.campoNombre.setText("");
  60. pa.campoID.setText("");
  61. pa.campoTel.setText("");
  62. pa.campoEmail.setText("");
  63.  
  64. pa.si.setText("Registrado");
  65.  
  66. } catch (SQLException ex) {
  67. System.out.println(ex.getMessage());
  68. }
  69. }
  70. public void buscar (){
  71. Pasajero pa = new Pasajero();
  72. try{
  73. Connection cn = DriverManager.getConnection("jdbc:mysql://localhost/proyectoavion", "root","");
  74. PreparedStatement pst = cn.prepareStatement("select * from pasajeros where Cedula = ?");
  75. pst.setString(1, pa.campoBuscar.getText());
  76. ResultSet re = pst.executeQuery();
  77. if(re.next()){
  78. pa.campoNombre.setText(re.getString("Nombre"));
  79. pa.campoID.setText(re.getString("Cedula"));
  80. pa.campoTel.setText(re.getString("Telefono"));
  81. pa.campoEmail.setText(re.getString("Correo"));
  82. }
  83. else{
  84. JOptionPane.showMessageDialog(null,"No se encuentra registrado!!");
  85. }
  86.  
  87. }
  88. catch(SQLException e){
  89. System.out.println(e.getMessage());
  90.  
  91. }
  92.  
  93. }
  94. public void modificar (){
  95. Pasajero pa = new Pasajero();
  96. try{
  97. String si= pa.campoBuscar.getText();
  98. Connection cn = DriverManager.getConnection("jdbc:mysql://localhost/proyectoavion", "root","");
  99. PreparedStatement pst = cn.prepareStatement("update pasajeros set Nombre=?, Telefono = ?, correo = ? where Cedula="+si);
  100.  
  101. pst.setString(1,pa.campoNombre.getText().trim());
  102. pst.setString(2, pa.campoTel.getText().trim());
  103. pst.setString(3, pa.campoEmail.getText().trim());
  104. pst.executeUpdate();
  105. pa.campoNombre.setText("");
  106. pa.campoTel.setText("");
  107. pa.campoEmail.setText("");
  108. pa.campoBuscar.setText("");
  109. pa.campoID.setText("");
  110. pa.si.setText("Modificado");
  111.  
  112. }
  113. catch(SQLException e){
  114. System.out.println(e.getMessage());
  115.  
  116. }
  117.  
  118. }
  119. public void eliminar (){
  120. Pasajero pa = new Pasajero();
  121. try{
  122. Connection cn = DriverManager.getConnection("jdbc:mysql://localhost/proyectoavion", "root","");
  123. PreparedStatement pst = cn.prepareStatement("delete from pasajeros where Cedula = ?");
  124. pst.setString(1,pa.campoBuscar.getText().trim());
  125. pst.executeUpdate();
  126. pa.campoNombre.setText("");
  127. pa.campoID.setText("");
  128. pa.campoTel.setText("");
  129. pa.campoEmail.setText("");
  130.  
  131. pa.si.setText("Eliminado");
  132.  
  133. }
  134. catch(SQLException e){
  135. System.out.println(e.getMessage());
  136.  
  137. }
  138. }
  139.  
  140.  
  141. }
Add Comment
Please, Sign In to add comment