解析：教你快速掌握JDBC连接Informix IDS

OS: Windows XP

Informix: IDS V10.00.TC1

JDBC: Informix JDBC Embedded SQLJ V2.20JC2

import java.sql.*;

import java.util.*;

public class ifx_con

{

public static void main(String[] args)

{

Connection conn;

String url = "jdbc:informix-sqli://IBM-HENRY:
1526/sample:informixserver=
ol_henry;user=henry;password=happyday";

System.out.println("Informix JDBC connect test."); 

try

{

// Load the Informix JDBC Driver

//DriverManager.registerDriver((Driver) Class.forName

("com.informix.jdbc.IfxDriver").newInstance());

Class.forName("com.informix.jdbc.IfxDriver");

//Create and open a server/database connection

conn = DriverManager.getConnection(url); 

System.out.println("JDBC driver name: " 
+ conn.getMetaData().getDriverName());

//Queries that return more than one row

Statement query = null;

ResultSet rs = null;

String st = new String();

try

{

query = conn.createStatement();

rs = query.executeQuery("select * from customer");

while (rs.next())

{

System.out.println(rs.getString(2));

}

rs.close();

query.close();

}

catch (SQLException exce)

{

System.out.println("Caught: " + exce.getErrorCode());

}

conn.close(); 

}

catch (ClassNotFoundException drvEx)

{

System.err.println("Could not load JDBC driver");

System.out.println("Exception: " + drvEx);

drvEx.printStackTrace();

}

catch(SQLException sqlEx)

{

while(sqlEx != null)

{

System.err.println("SQLException information");

System.err.println("Error msg: " + sqlEx.getMessage());

System.err.println("SQLSTATE: " + sqlEx.getSQLState());

System.err.println("Error code: " + sqlEx.getErrorCode());

sqlEx.printStackTrace();

sqlEx=sqlEx.getNextException();

}

}

}

}