DBC (Java Database Connectivity) is developed by Sun Java for the purpose of
connecting java applications with a variety of relation database systems like
MySQL or Oracle.
On the other hand, ODBC (open database connectivity) is a system developed
by Microsoft to connect Microsoft based programming application (like visual
basic) with a variety of relation databases.
ResultSet
A ResultSet object represents the output table of data resulted from a SELECT query ... The data in a ResultSet object is organized in rows and columns.
Differenc ebetween executUpdate() and executeQuery()
executeUpdate() method of statement class is used to update the database with the values as argument
executeQuery() method is used when we simply want to retrieve data from a table without modifying the contents of the table.
Give example as well.
q) Explain the purpose of following methods:
a) next()
b)getModel()
c)getRowcount()
d)removeRow()
e)getConnection
f)forName()
connecting java applications with a variety of relation database systems like
MySQL or Oracle.
On the other hand, ODBC (open database connectivity) is a system developed
by Microsoft to connect Microsoft based programming application (like visual
basic) with a variety of relation databases.
ResultSet
A ResultSet object represents the output table of data resulted from a SELECT query ... The data in a ResultSet object is organized in rows and columns.
Differenc ebetween executUpdate() and executeQuery()
executeUpdate() method of statement class is used to update the database with the values as argument
executeQuery() method is used when we simply want to retrieve data from a table without modifying the contents of the table.
Give example as well.
q) Explain the purpose of following methods:
a) next()
b)getModel()
c)getRowcount()
d)removeRow()
e)getConnection
f)forName()
No comments:
Post a Comment