jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes get column value in a database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "get column value in a database" Watch "get column value in a database" New topic
Author

get column value in a database

Kevin Ng
Greenhorn

Joined: Aug 31, 2003
Posts: 23
Dear all members,
Normally we get data/value from database by writting a sql statement, right? How about without writing the sql statement, can i get the data?
For an example, when i run the application a JFrame with the JTable will popup if the database date equal current date...
Without using sql statement which means using DB.FIELD but there were errors when compiling...why?
Any code can show to mehow to apply without sql queries?
THANK YOU SO MUCH.....
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
SQL is the Query Language of each modern relational database.
There are certain technologies/frameworks like JDO, iBatis, Hibernate
to wrap the SQL statements and make the handling object oriented. But basiclly every database access is done with SQL. There is no other way to access the db except to read the data files.
Kevin Ng
Greenhorn

Joined: Aug 31, 2003
Posts: 23
Dear Oliver Refle,
So can you show me how to code this. When the application execute, in the mainpage a popup JFrame contains a JTable with the entire records in a database if database column equals to current date else the JFrame will not popup.....
Thanks....
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

a good place to start is the java tutorial - JDBC trail
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: get column value in a database