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)
Java Asp PHP .Net XML C/C++ CGI VB Jsp J2ee J2se J2me EJB Servlet Tomcat Resin Struts Weblogic Eclipse ANT GUI JMS Web servise IDEA Webphere Hibernate Spring Jboss Applet Swing Socket Javamail Perl Ajax P2P 安全 模式 框架 测试 开源 游戏
Windows XP Windows 2000 Windows 2003 Windows Me Windows 9.x Linux UNIX 注册表 操作系统 服务器 应用服务器
