JDBC连接Informix IDS

　　Informix 的JDBC驱动是type 4的方式
1)环境说明
OS: Windows XP
Informix: IDS V10.00.TC1
JDBC: Informix JDBC Embedded SQLJ V2.20JC2

2)JDBC配置
安装完Informix JDBC后把ifxjdbc.jar路径加到CLASSPATH环境变量中，比如CLASSPATH=C:\ifxjava_home\lib\ifxjdbc.jar;....

在安装完后的目录中有doc目录，里面有详细的文档说明。
还有demo目录，里面有可以参考的源代码

3)DEMO代码
下面的源代码，是参考了<INFORMIX OIJ TOINFORMIX JDBC DRIVER MIGRATION GUIDE>(\doc\release\oij_jdbc_migration.html)
通过Java使用JDBC连接IDS V10.0

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();
      }
    }
   }
}