Guest User

Untitled

a guest
Nov 21st, 2018
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.00 KB | None | 0 0
  1. @WebMethod(operationName = "mostarNombre")
  2. public ArrayList<String> mostarNombre(@WebParam(name = "id") int id) {
  3. String nomb = "";
  4. ArrayList<String> list = new ArrayList<String>();
  5. try {
  6. DriverManager.registerDriver(new OracleDriver());
  7. Connection cn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:xxx:xxx", xxxx, xxxx);
  8.  
  9. String query = "select * from ejemplo where id = 1";
  10. Statement stmt = cn.createStatement();
  11. ResultSet rs = stmt.executeQuery(query);
  12.  
  13. while (rs.next()) {
  14. nomb = rs.getString("nombre");
  15. String ids = rs.getString("id");
  16.  
  17. list.add(nomb);
  18. list.add(ids);
  19. }
  20.  
  21. } catch (SQLException ex) {
  22. Logger.getLogger(Server.class.getName()).log(Level.SEVERE, null, ex);
  23. }
  24.  
  25. return list;
  26. }
  27.  
  28. public void consultar(View v){
  29. try {
  30. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitNetwork().build();
  31.  
  32. StrictMode.setThreadPolicy(policy);
  33.  
  34. String resultadoFINAL;
  35.  
  36. //Creacion de la Solicitud
  37. SoapObject request = new SoapObject(NAMESPACE, METHOD2);
  38.  
  39. //Creacion del Envelope
  40. SoapSerializationEnvelope sobre = new SoapSerializationEnvelope(SoapEnvelope.VER11);
  41. sobre.dotNet = true;
  42. sobre.setOutputSoapObject(request);
  43.  
  44. //Creacion del transporte
  45. HttpTransportSE transporte = new HttpTransportSE(URL);
  46.  
  47. // Paso de parámetro
  48. PropertyInfo numeroEmp = new PropertyInfo();
  49. numeroEmp.setName("numero");
  50. request.addProperty(numeroEmp);
  51.  
  52. //Llamada
  53. transporte.call(SOAPACTION2, sobre);
  54.  
  55. //Resultado
  56. Object resultado = (Object) sobre.getResponse();
  57. ArrayList<String> lista = new ArrayList<String>();
  58. lista.add(resultado.toString());
  59. String a = lista.get(0);
  60.  
  61. tvConsulta.setText(lista.get(0));
  62. tvEj.setText(lista.get(1));
  63.  
  64. }catch (Exception e) {
  65. e.printStackTrace();
  66. }
  67. }
Add Comment
Please, Sign In to add comment