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 crashes when adding service reference on VB side
[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