Java VB.net-Dienstreferenz auf halbem Weg

Main.java


package main;

import data.Request;
import data.Response;

public class Main {

	public static void main(String[] args) {

		Request request = new Request();
		Response response = new Response();

		request.setFromDate("201807301201");
		request.setToDate("201809301201");
		response = request.setDB();

		for (int i = 0; i < response.date.size(); i++) {
			System.out.print(response.date.get(i) + " ");
			System.out.println(response.photo.get(i));
		}
	}
}

DbAccess.java


package db;

import java.sql.*;

import data.Response;

public class DbAccess {

	public Response dbAccess(String fromDate, String toDate)
			throws SQLException {

		Response response = new Response();

		Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521", "test", "test");
		Statement stmt = conn.createStatement();
		String sqlString = "select * from PICT where REGISTERDATE BETWEEN " + fromDate + " and " + toDate;
		ResultSet rset = stmt.executeQuery(sqlString);

		while (rset.next()) {
			String date =rset.getString(1);
			response.setDate(date);
			String photo = rset.getString(2);
			response.setPhote(photo);

		}
		rset.close();
		stmt.close();
		conn.close();

		return response;
	}
}

Request.java


package data;

import java.sql.SQLException;
import db.DbAccess;

public class Request {

	private String fromDate;
	private String toDate;

	public void setFromDate(String fromDate) {

		this.fromDate = fromDate;
	}

	public void setToDate(String toDate) {

		this.toDate = toDate;
	}

	public Response setDB() {

		Response response = new Response();
		DbAccess dbAccess = new DbAccess();

		try {

			response = dbAccess.dbAccess(fromDate, toDate);

		} catch (SQLException e) {
			System.out.println(e);
		} finally {

		}

		return response;

	}
}

Response.java


package data;

import java.util.ArrayList;

public class Response {

	public ArrayList<String> date = new ArrayList<String>();
	public ArrayList<String> photo = new ArrayList<String>();

	public void setDate(String date) {
		this.date.add(date);
	}

	public void setPhote(String photo) {
		this.photo.add(photo);
	}

}

Axis2 Tomcat stürzt ab, wenn eine Dienstreferenz auf der VB-Seite hinzugefügt wird

[WARN] triggerActionNotSupportedFault: messageContext: [MessageContext: logID=urn:uuid:] problemAction: http://schemas.xmlsoap.org/ws/2004/09/transfer/Get [WARN] triggerActionNotSupportedFault: messageContext: [MessageContext: logID=urn:uuid:] problemAction: http://schemas.xmlsoap.org/ws/2004/09/transfer/Get [ERROR] The [action] cannot be processed at the receiver.

Recommended Posts

Java VB.net-Dienstreferenz auf halbem Weg
Java8-Methodenreferenz
Java8-Methodenreferenz
JAVA Referenzmaterialien
Meine Java-Referenz
Grundlegende Datentypen und Referenztypen (Java)
Java primitive Typen, Referenztypen, unveränderlich, veränderlich
Java-Referenzmechanismus (Stack und Heap)
Java-Array-Variablen sind Referenztypen
Java als Wert übergeben und als Referenz übergeben
[Java] Referenz / Update von Active Directory
Informationen zu primitiven Java-Typen und Referenztypen
Java "Pass by Reference" Problemzusammenfassung
Java-Basisdatentypen und Referenztypen
Verwenden des Proxy-Dienstes mit Java-Crawling