Skip to main content

Help problems with database, query and Date

1 reply [Last post]
Joined: 2007-06-18

Hi, i'm new of java, and i need help to write my application.
I follow this tutorial to make my first database application. So it work, but when i change data type in Date format i can't manage it. When i left-clik on database and use the execution command to write sql commands he work well, do insertions and selects, and the date form is dd/MM/yyyy (i want this format date). But when i put on the UI (autogenerate) i can't insert new dates (wrong date format), and the dates insert by a query are in this format Thu Oct 07 00:00:00 CEST 1999.

The second quest is about sql query where i have to write the queries?

This is an application that have to work in a single pc for a small database (only one table), is that the right road?

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Joined: 2006-12-18

For the second question, I suggest you take a look at the [i]java.sql[/i] package, in particular the classes Driver, Connection, and Statement. Googling should get you a quick few tutorials on their use, should you still need them afterwards.

The first question sounds like something for the NetBeans community rather than the community, but I could be wrong.