informix JDBC驱动及示例代码

package test; import java.net.MalformedURLException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TT01 { public static void main(String[] args) throws MalformedURLException, Exception { // TODO Auto-generated method stub String JDriver = "com.informix.jdbc.IfxDriver"; String RL="jdbc:informix-sqli://127.0.0.1:1533/testDB:INFORMIXSERVER=myserver;user=testuser;password=testpassword"; String sql="select * from testtab"; try { Class.forName(JDriver); Connection con= DriverManager.getConnection(RL); Statement st=con.createStatement(); ResultSet rs=st.executeQuery(sql); while(rs.next()){ //System.out.print(rs.getString(1)); System.out.println(rs.getString(2)); //System.out.println(rs.getString(3)); } rs.close(); st.close(); con.close(); } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } } }