java2informix源代码

package src; import com.informix.jdbc.*; import java.sql.*; public class db { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub try { Class.forName("com.informix.jdbc.IfxDriver").newInstance(); } catch (ClassNotFoundException e) { System.err .println("Oops! Can't find class com.informix.jdbc.IfxDriver"); System.exit(1); } catch (Exception e) { } String url = "jdbc:informix-sqli://192.168.0.3:9088/test:INFORMIXSERVER=ol_ids_1150_1;user=administrator;password="; // myDB为数据库名 try { Connection conn = DriverManager.getConnection(url); Statement stm = conn.createStatement(); /* 获取帐户基本信息 */ String sql_basicInfo = "select * from test "; System.out.println("sql_basicInfo=" + sql_basicInfo); ResultSet rset = stm.executeQuery(sql_basicInfo); ResultSetMetaData rsmd = rset.getMetaData(); if (rset.next()) { String server_id = rset.getString(1); System.out.println("server_id=" + server_id); } } catch (SQLException e) { System.err.println("Darn! A SQL error: " + e.getMessage()); } } }