Witam,
jestem trochę świeży w javie więc proszę Was o pomoc.
Mam taki problem mam 3 rzeczy - połączenie do bazy przez sterowniki DB2 , zapytanie sql które wyciąga dane ale potrzebuje te dane zamienić na wykres słupowy i nie moge sobie z tym poradzić.
Dane do logowania są poprawne tylko je usunąłem.
package wykres2;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.time.LocalDateTime;
public class DB2 {
public static Connection connectionDB2;
public DB2() {
if (connectionDB2 == null) {
connect();
} else {
System.out.println(LocalDateTime.now() + " : " + "Already connected to DB2 database");
}
}
// connect database Tomcat
// connect database
public void connect() {
final String DATABASE_DRIVER = "com.ibm.db2.jcc.DB2Driver";
//final String DB2SERVER = "";
final String DB2SERVER = "";
final String URL = "jdbc:db2://" + DB2SERVER + "/NDT";
final String USERID = "";
final String PASSWORD = "";
try {
// Load the Connector/J driver
Class.forName(DATABASE_DRIVER);
// Establish connection to DB2
connectionDB2 = DriverManager.getConnection(URL, USERID, PASSWORD);
System.out.println(LocalDateTime.now() + " : " + "Connected to local DB2 database");
} catch (ClassNotFoundException | SQLException e) {
System.out.println("Connected to local DB2 database failed");
e.printStackTrace();
}
}
// disconnect database
public static void disconnect() {
if (connectionDB2 != null) {
try {
connectionDB2.close();
connectionDB2 = null;
System.out.println(LocalDateTime.now() + " : " + "Connection to DB2 closed");
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public void deleteTable(String table) {
String queryDel = " delete " + table;
Statement stmt = null;
try {
System.out.println(LocalDateTime.now() + " : " + "Deleting table " + table + " in given NDT database");
connectionDB2.setAutoCommit(true);
stmt = connectionDB2.createStatement();
stmt.executeUpdate(queryDel);
} catch (Exception e) {
e.printStackTrace();
System.err.println("Error by deleting " + table + " table in NDT database");
} finally {
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
drugi...
package wykres2;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class XMLDOCSDao extends DB2 {
public void selectData(int since) {
String selectQuery = ("SELECT TRKONZ, TRFIRM, TRZUNR, TRKENN, TRFKEY, TRDTA, TRTIA, TRVSTS, TRDTV, TRTIV, PCQTY, PSQTY, FSTAPN, LSTAPN"
+ " FROM XMLDOCS where TRDTA> "+ since +" order by trdta, trtia");
Statement stmt= null;
try {
stmt = connectionDB2.createStatement();
ResultSet rs = stmt.executeQuery(selectQuery);
System.out.println("data \t\t time \t\t qty");
while(rs.next()) {
int data = rs.getInt("TRDTA");
int czas = rs.getInt("TRTIA");
int pcs = rs.getInt("PCQTY");
System.out.print(data + "\t");
System.out.print(czas + "\t");
System.out.println("\t" + pcs );
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
disconnect();
}
// int data; // trdta;
// int czas; // trtia;
// int ilosc; // psqty;
}
}
i trzeci
package wykres2;
public class ShowData1 {
public static void main(String[] args) {
XMLDOCSDao xmldocsdao = new XMLDOCSDao();
xmldocsdao.selectData(20190501);
}
}
proszę o podpowiedź jak się za to zabrać.