User guide

// You need to import the java.sql package to use JDBC
import java.sql.*;
// We import java.io to be able to read from the command line
import java.io.*;
class my_app
{
static BufferedReader in;
public static void main(String args[])
throws SQLException, IOException, Exception
{
String driverConStr = "jdbc:rdbThin://555.1.14.91:1888/";
in = new BufferedReader(new InputStreamReader(System.in));
Class.forName ("oracle.rdb.jdbc.rdbThin.Driver");
{
// Prompt the user for connect information
System.out.println(
"Please enter information to test connection"+
" to the database");
String user;
String password;
String database;
user = readEntry("user: ");
int slash_index = user.indexOf('/');
if (slash_index != -1)
password = user.substring(slash_index + 1);
user = user.substring(0, slash_index);
}
else
password = readEntry("password: ");
database = readEntry("database: ");
System.out.print("Connecting to the database...");
System.out.flush();
System.out.println("Connecting...");
Connection conn = DriverManager.getConnection(
driverConStr + database, user, password);
System.out.println("connected.");
// Create a statement
Statement stmt = conn.createStatement();
// Do the SQL "Hello World" thing
ResultSet rset = stmt.executeQuery(
"select 'Hello World' from rdb$database");
while (rset.next())
System.out.println(rset.getString(1));
// close the result set, the statement and connect
rset.close();
stmt.close();
conn.close();
}
151