Java Connect Informix DB example

(1)   Import ifxjdbc.jar 

 

(2) import java.sql.*;

(3) 注意連線字串

(4) 範例程式

package hhh;

import java.sql.*;

public class hahah {

public static void main(String[] args) {

    // TODO Auto-generated method stub

    Connection conn = null;

    Statement statement = null;

    ResultSet resultSet = null;

    

    String dbURL = "jdbc:informix-sqli://Host:port/database name:informixserver=servername;"
                                    +  "DB_LOCALE=zh_tw.big5;user=帳號;password=密碼;";

                   

    try {

    //測試連線

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

System.out.println("Driver OK");

conn =DriverManager.getConnection(dbURL);

System.out.println("connection OK");

Statement query = null;

ResultSet rs = null;

try

{

query = conn.createStatement();

rs = query.executeQuery("SELECT * FROM TableName WHERE 條件= 'xxx'");

while (rs.next())

{

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

}

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

    }

    }

}

}