Skip to main content

Help problems with database, query and Date

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

Hi, i'm new of java, and i need help to write my application.
I follow this tutorial http://www.netbeans.org/kb/60/ide-gui-db-prev.html 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.
tarbo
Offline
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 java.net community, but I could be wrong.