MySQL table export with column names and a date column. How can I solve this?

Question

So far I have managed a CSV export with 5 columns, time, customer, employee, service and description.
But I'm not sure is this the right code for the time export.

while(rs.next()) {
sb.append(rs.getDate("date"));
sb.append(";");
sb.append(rs.getTime("time"));
sb.append(";");

I tried this code to export the date column, but it doesn't work.

I hope you can help me.

Thank you.

BR Olivia
https://code.sololearn.com/cAXM4GW7SFTQ/?ref=app

Answer 1

I recommend you to use following statements to retrieve date column,
Date date = resultset.getDate("");

Answer 2

while(rs.next()) {
Date date = rs.getDate("datum");
sb.append(date); sb.append(";"); sb.append(rs.getTime("zeit")); sb.append(";"); sb.append(rs.getString("kunde")); sb.append(";"); sb.append(rs.getString("dienstleistung")); sb.append(";"); sb.append(rs.getString("beschreibung")); sb.append(";"); sb.append(rs.getString("mitarbeiter")); sb.append("\r\n"); }
For date class we have to include import java.util.*;

Answer 3

Use drivermanager class to get connection

Answer 4

Please try,
Date date = resultset.getDate("");

Answer 5

Did you learn the time API?
Here is a simple example to help you get going with your task.

https://code.sololearn.com/cMdQw5y7VJUE/?ref=app

Answer 6

Avinesh thank you a lot for this code. :)

Answer 7

Hi akshay harshora, thank you for your help. :)
The connection it works, only the column names and the date column it doesn't work.

Answer 8

akshay harshora I tried it at this position:

while(rs.next()) {
Date date = rs.getDate("");
....

but I received an error like: Date cannot be solved to a type. Which Import I have to do? Import 'Date' (sun.util.calendar.BaseCalendar) or (sun.util.calendar.LocalGregorianCalendar) or (java.util) or (java.sql)

Answer 9

Hi Avinesh no until now not.

Answer 10

many thanks akshay harshora :), now I don't have errors, but the csv file is empty. The csv file it works, without the date codes.🙈