Monday, October 24, 2011

Java: Oracle connection

import java.util.*;
import java.sql.*;
import java.math.*;

public class dataSourceClass {
public static InputStream getStream(Hashtable hashtable) throws SQLException {

Enumeration hashEnum = hashtable.keys();

while (hashEnum.hasMoreElements()) {
String hashKey = (String) hashEnum.nextElement();
String hashValue = (String) hashtable.get(hashKey);

Load the driver. This is an example of using the Oracle thin driver.
Make sure to use the correct path to the actual driver being used.

DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

// Connect to the database

Connection connection = DriverManager.getConnection ("YourConnectionStringGoesHere");
/* An Oracle connection might look something like:

Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@Name:1521:orcl", "UserID", "Passwd");

// Create a new statement
Statement newStatement = connection.createStatement ();

This sample statement assumes that the database has a table named
"Employees" with columns "First_Name" and "Last_Name"

ResultSet resultSet = newStatement.executeQuery ("select First_Name, Last_Name from Employees");

StringBuffer buffer = new StringBuffer();

//since a movieClip is required to display each row of data, we specify "clip" in the datasource.

buffer.append("clip, First_Name, Last_Name\n");

while ( ()) {
While printing the values out, we will add the name of the movieClip that will be used to display the data.
For this example, we would have a movieClip in our template called "myClip." This movieClip would contain the
text variables {First_Name} and {Last_Name}.

buffer.append("myClip, " + resultSet.getString(1) + "\n");


InputStream inputStream = new ByteArrayInputStream(buffer.toString().getBytes());

return inputStream;


Post a Comment