File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "get column value in a database" Watch "get column value in a database" New topic

get column value in a database

Kevin Ng

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?
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

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.....
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

a good place to start is the java tutorial - JDBC trail
I agree. Here's the link:
subject: get column value in a database
It's not a secret anymore!