Skip to main content

Posts

Showing posts from April, 2015

MySql Revision Tour

A database is a computer based record keeping system. generally a database is defined as a collection of data for a specific organization. DBMS is a program that control creation, maintenance and use of a database. DBMS centrally stores the data that can be shared and accessed as common resource by all  DB users. The advantages offered by a DBMS are as follows. Reduces data redundancy. Reduces data inconsistency. offers data sharing. can be used for enforcing data standards. Provides effective data security. Maintains data integrity. Different Data Models. Relational Data Model- data is organised as tables . the tables are called as relations and each row in a table represent relation among a set of values. Network Data Model- this model is different from relational model, as data relationship is represented  as records that are connected as links.a record is collection of attributes each having a data value and link represents association betwee...

JDBC Connectivity and More!!

JDBC  defines a universal interface for accessing various relational databases. The main function of JDBC API( java database connectivity application programming interface) is to provide methods for developer to prepare and send SQL statements to database server and fetch the results in database independent manner. it involes the following steps- establish a DB connection. send SQL statement to the DB server. fetch the result from server and process as required. classes used in java for DB connectivity. the DriverManager class. the Connection class. the Statement class. the ResultSet class. Configuring MySql Connector for java connectivity. to connect your java program to MySql server- the first requirement is  to install MySql Connector/J driver. the driver may downloaded from http://dev.mysql.com/downloads. goto netbeans->tools->libraries and add the mysql connector/j  .jar you just downloaded using add jar folder button. to establi...