 "Main
memory databases are faster than disk-optimized databases, as the internal
optimization algorithms are simpler and execute fewer CPU instructions.
Accessing data in memory provides faster and more predictable performance
than disk. In applications, where response time is critical, such as telecommunications
network equipment that operatesemergency systems, main memory databases are often used"
- Sanjay Mehta
CEO of MAIA Intelligence |
Connection con = DriverManager.getConnection
( "jdbc:myDriver:wombat", "myLogin","myPassword");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM Table1");
while (rs.next()) {
int x = rs.getInt("a");
String s = rs.getString("b");
float f = rs.getFloat("c");
}
This short code fragment instantiates a DriverManager object to
connect to a database driver and log into the database, instantiates a Statement
object that carries your SQL language query to the database; instantiates a ResultSet
object that retrieves the results of your query, and executes a simple while
loop, which retrieves and displays those results. java.sql
and javax.sql. Both packages are included in the Java SE and
Java EE platforms.DriverManager class defines objects which can connect
Java applications to a JDBC driver. DriverManager has
traditionally been the backbone of the JDBC architecture. javax.naming and
javax.sql let you use a DataSource object registered
with a Java Naming and Directory Interface™ (JNDI) naming service
to establish a connection with a data source. You can use either connecting
mechanism, but using a DataSource object is recommended
whenever possible.
CREATE TABLE t1 (c1 INT PRIMARY KEY NOT NULL, c2 BLOB(5M));
PreparedStatement pstmt = conn.prepareStatement ("INSERT
INTO t1 VALUES (?,?)");
pstmt.setInt (1, 100);
File fBlob = new File (
"image1.gif" );
FileInputStream is = new FileInputStream ( fBlob
);
pstmt.setBinaryStream (2, is, (int) fBlob.length() );
pstmt.execute
();
...
Statement stmt =
conn.createStatement ();
ResultSet rs= stmt.executeQuery("SELECT * FROM
t1");
while(rs.next()) {
int val1 = rs.getInt(1);
InputStream val2 =
rs.getBinaryStream(2);
...
} rs.close(); 
RtechIndia->technology ahead
rtechindia
|
"Main
memory databases are faster than disk-optimized databases, as the internal
optimization algorithms are simpler and execute fewer CPU instructions.
Accessing data in memory provides faster and more predictable performance
than disk. In applications, where response time is critical, such as telecommunications
network equipment that operates emergency systems, main memory databases are often used"
- Sanjay Mehta
CEO of MAIA Intelligence |
Connection con = DriverManager.getConnection
( "jdbc:myDriver:wombat", "myLogin","myPassword");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM Table1");
while (rs.next()) {
int x = rs.getInt("a");
String s = rs.getString("b");
float f = rs.getFloat("c");
}
This short code fragment instantiates a DriverManager object to
connect to a database driver and log into the database, instantiates a Statement
object that carries your SQL language query to the database; instantiates a ResultSet
object that retrieves the results of your query, and executes a simple while
loop, which retrieves and displays those results. java.sql
and javax.sql. Both packages are included in the Java SE and
Java EE platforms.DriverManager class defines objects which can connect
Java applications to a JDBC driver. DriverManager has
traditionally been the backbone of the JDBC architecture. javax.naming and
javax.sql let you use a DataSource object registered
with a Java Naming and Directory Interface™ (JNDI) naming service
to establish a connection with a data source. You can use either connecting
mechanism, but using a DataSource object is recommended
whenever possible.CREATE TABLE t1 (c1 INT PRIMARY KEY NOT NULL, c2 BLOB(5M));
PreparedStatement pstmt = conn.prepareStatement ("INSERT
INTO t1 VALUES (?,?)");
pstmt.setInt (1, 100);
File fBlob = new File (
"image1.gif" );
FileInputStream is = new FileInputStream ( fBlob
);
pstmt.setBinaryStream (2, is, (int) fBlob.length() );
pstmt.execute
();
...
Statement stmt =
conn.createStatement ();
ResultSet rs= stmt.executeQuery("SELECT * FROM
t1");
while(rs.next()) {
int val1 = rs.getInt(1);
InputStream val2 =
rs.getBinaryStream(2);
...
} rs.close(); 
