Advanced Java Programming with Database Application downloads free book

Snap shot

Every organization has a pool of resources that it must manage effectively to achieve its objectives.
Although their rule differs all resources human, financial and material share a common
characteristic.
The organization that fails to treat data or information as resource and to manage it effectively will
be handicapped in how it manages its, manpower, material and financial resources. In order to
satisfy the information requirements of management, the data should be stored in an organized
form.
What is a Database?
A brief definition might be: THE INFORMATION, HELD OVER A PERIOD OF TIME, IN
COMPUTER - READABLE FORM.
Typical examples of information stored for some practical purpose are: Information collected for
the sake of making a statistical analysis, e.g. the national census. Operational and administrative
information required for running an organization or a commercial concern this will take the form
of stock records, personnel records, customer records . . . etc.

DBMS Standardization

Early computer applications were based on existing clerical methods and stored information was
partitioned in much the same way as manual files. But the computer's processing speed gave a
potential for RELATING data from different sources to produce valuable management
information, provided that some standardization could be imposed over departmental boundaries.
The idea emerged of the integrated database as a central resource. Data is captured as close as
possible to its point of origin and transmitted to the database, then extracted by anyone within the
organization who requires it. However many provisos have become attached to this idea in
practice, it still provides possibly the strongest motivation for the introduction of a DBMS in large
organizations. The idea is that any piece of information is entered and stored just once, eliminating
duplications of effort and the possibility of inconsistency between different departmental records.
Data redundancy has to be removed at the most possible
Here is the revised version of Selecting Row using the column number
import java.sql.*;
import java.io.*;
class SelectRow
{
public static void main(String[] args)
{
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection
("jdbc:odbc:oraodbc","scott","tiger");
Statement stmt = con.createStatement();
rs = stmt.executeQuery("select * from CUSTOMERS");
System.out.println("CUST_NUM" + "\tCOMPANY" +
"\t\tCUST_REP" + "\tCREDIT_LIMIT");
while(rs.next())
{
int no=rs.getInt(1);
String company=rs.getString(2);
int rep=rs.getInt(3);
double credit=rs.getDouble(4);
System.out.println(no+"\t\t"+company+"\t"+rep+"\t\t"+credit);
}
stmt.close();
con.close();
System.out.println("Records successfully selected");
}catch(Exception e)
{
e.printStackTrace();
}
}
}


                                       DOWNLOADS THIS IMPORT JAVA DATABASE BOOK CLICK HERE