Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @WebMethod(operationName = "mostarNombre")
- public ArrayList<String> mostarNombre(@WebParam(name = "id") int id) {
- String nomb = "";
- ArrayList<String> list = new ArrayList<String>();
- try {
- DriverManager.registerDriver(new OracleDriver());
- Connection cn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:xxx:xxx", xxxx, xxxx);
- String query = "select * from ejemplo where id = 1";
- Statement stmt = cn.createStatement();
- ResultSet rs = stmt.executeQuery(query);
- while (rs.next()) {
- nomb = rs.getString("nombre");
- String ids = rs.getString("id");
- list.add(nomb);
- list.add(ids);
- }
- } catch (SQLException ex) {
- Logger.getLogger(Server.class.getName()).log(Level.SEVERE, null, ex);
- }
- return list;
- }
- public void consultar(View v){
- try {
- StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitNetwork().build();
- StrictMode.setThreadPolicy(policy);
- String resultadoFINAL;
- //Creacion de la Solicitud
- SoapObject request = new SoapObject(NAMESPACE, METHOD2);
- //Creacion del Envelope
- SoapSerializationEnvelope sobre = new SoapSerializationEnvelope(SoapEnvelope.VER11);
- sobre.dotNet = true;
- sobre.setOutputSoapObject(request);
- //Creacion del transporte
- HttpTransportSE transporte = new HttpTransportSE(URL);
- // Paso de parámetro
- PropertyInfo numeroEmp = new PropertyInfo();
- numeroEmp.setName("numero");
- request.addProperty(numeroEmp);
- //Llamada
- transporte.call(SOAPACTION2, sobre);
- //Resultado
- Object resultado = (Object) sobre.getResponse();
- ArrayList<String> lista = new ArrayList<String>();
- lista.add(resultado.toString());
- String a = lista.get(0);
- tvConsulta.setText(lista.get(0));
- tvEj.setText(lista.get(1));
- }catch (Exception e) {
- e.printStackTrace();
- }
- }
Add Comment
Please, Sign In to add comment