[Link]@yahoo.
com Naresh i Technologies
JDBC part-4
Advanced Data Types:
1) BLOB 2) CLOB
1) BLOB:
BLOB stands for Binary Large OBject
It is used to store/retrieve large amount of binary data as a single entity in/from
database.
It supports text, image, graphics, animation, audio, video, .. etc.,
BLOB is mapped into [Link] interface in Java language.
2) CLOB:
CLOB stands for Character Large OBject
It is used to store/retrieve large amount of character data as a single entity
in/from database.
It supports text only.
CLOB is mapped into [Link] interface in Java language.
BLOB Example:
import [Link].*;
import [Link].*;
class BlobDemo
{
public static void main(String args[])
{
try{
Java By Venkatesh Mansani [Link]@[Link]
[Link]@[Link] Naresh i Technologies
[Link]("[Link]");
Connection
con=[Link]("jdbc:oracle:thin:@localhost:1521:xe","syste
m","manager");
PreparedStatement pstmt=[Link]("insert into images values(?,
?)");
[Link](1, args[0]);
FileInputStream fis=new FileInputStream(args[1]);
[Link](2, fis, [Link]());
[Link]();
[Link]("One Image Inserted Successfully");
}catch(Exception e)
{
[Link](e);
}
}
}
Rowsets:
A rowset is an object that encapsulates set of rows from database.
Rowset is generated based on sql query.
Whenever rowset is generated then rowset pointer or cursor points to before first
record.
There are 5 rowsets:
1) JdbcRowSet
2) CachedRowSet
Java By Venkatesh Mansani [Link]@[Link]
[Link]@[Link] Naresh i Technologies
3) WebRowSet
4) FilteredRowSet
5) JoinRowSet
The above rowsets are interfaces in [Link] package.
The differences between ResultSet & Rowsets:
ResultSet Rowsets
1) It is a non serializable object. 1) All rowsets are serializable objects.
2) It is a connected object. 2) JdbcRowSet is a connected object and
remaining rowsets are disconnected
objects.
3) It is not a javabean. 3) All rowsets are javabeans.
4) In order to get ResultSet we need 4) In order to get RowSet we need only
Connection interface, DriverManager RowSet implementation class.
class & Statement interface.
Serialization:
A serialization is a process of converting object into a series of bits.
In Java, object must be serializable to do the following operations:
1) Writing an object to a file.
2) Reading an object from file.
3) Writing an object to a network.
4) Reading an object from network.
Class must implements [Link] interface to make serializable object.
[Link] interface is a marker interface, tag interface or empty interface
because it does not contain members.
Java By Venkatesh Mansani [Link]@[Link]
[Link]@[Link] Naresh i Technologies
Connected Object:
Connected object means the object always being connected to a database.
Java Bean:
A Java bean is a reusable software component.
A Java class is said to be java bean if it follows the following rules:
1) Class must be public
2) Class must implements [Link] interface
3) Class must be under package.
4) Class must contain one public default constructor.
5) All instance variables must be private(Instance variables are called properties).
6) Each & every property must contain setter & getter methods.
7) All setter & getter methods must be public.
Example:
package demo;
import [Link].*;
public class MessageBean implements Serializable
{
private String message;
public void setMessage(String message)
{
[Link]=message;
}
public String getMessage()
{
Java By Venkatesh Mansani [Link]@[Link]
[Link]@[Link] Naresh i Technologies
return message;
}
}
The above all rowsets are interfaces in [Link] package.
The above all rowset interfaces are implemented by database vendors.
Oracle corporation implemented the above rowset interfaces in
the following classes:
1) OracleJDBCRowSet
2) OracleCachedRowSet
3) OracleWebRowSet
4) OracleFilteredRowSet
5) OracleJoinRowSet
The above classes are in [Link] package.
[Link] package in ojdbc6_g.jar file in oracle database.
JdbcRowSet is a connected rowset where as CachedRowSet is a disconnected
rowset.
WebRowSet is same as CachedRowSet and additionally it allows to write
WebRowSet data to xml file.
FilteredRowSet is same as CachedRowSet and additionally it allows filtering
operations on RowSet data.
JoinRowSet is same as CachedRowSet and additionally it allows to join two or
more rowsets data.
JdbcRowSet Example:
import [Link].*;
import [Link].*;
Java By Venkatesh Mansani [Link]@[Link]
[Link]@[Link] Naresh i Technologies
import [Link].*;
class JRSDemo
{
public static void main(String args[])
{
try{
JdbcRowSet jrs=new OracleJDBCRowSet();
[Link]("jdbc:oracle:thin:@localhost:1521:xe");
[Link]("system");
[Link]("manager");
[Link]("select * from student");
[Link]();
while([Link]())
{
[Link]([Link]("rollno")+"\t");
[Link]([Link]("name")+"\t");
[Link]([Link]("marks"));
}
}catch(Exception e)
{
[Link](e);
}
}
}
Java By Venkatesh Mansani [Link]@[Link]
[Link]@[Link] Naresh i Technologies
CachedRowSet Example:
import [Link].*;
import [Link].*;
import [Link].*;
class CRSDemo
{
public static void main(String args[])
{
try{
CachedRowSet crs=new OracleCachedRowSet();
[Link]("jdbc:oracle:thin:@localhost:1521:xe");
[Link]("system");
[Link]("manager");
[Link]("select * from student");
[Link]();
while([Link]())
{
[Link]([Link]("rollno")+"\t");
[Link]([Link]("name")+"\t");
[Link]([Link]("marks"));
}
}catch(Exception e)
{
[Link](e);
Java By Venkatesh Mansani [Link]@[Link]
[Link]@[Link] Naresh i Technologies
}
}
}
WebRowSet Example:
import [Link].*;
import [Link].*;
import [Link].*;
class WRSDemo
{
public static void main(String args[])
{
try{
WebRowSet wrs=new OracleWebRowSet();
[Link]("jdbc:oracle:thin:@localhost:1521:xe");
[Link]("system");
[Link]("manager");
[Link]("select * from student");
[Link]();
FileOutputStream fos=new FileOutputStream("[Link]");
[Link](fos);
}catch(Exception e)
{ [Link](e);
}
} }
Java By Venkatesh Mansani [Link]@[Link]
