資源簡介
jar直接復制到本地java項目,示例代碼中的連接串,請根據實際情況替換。

代碼片段和文件信息
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();
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????661607??2010-04-06?19:27??informix?jdbc驅動及示例代碼\jdbc驅動\ifxjdbc-g.jar
?????文件?????604048??2010-04-06?19:27??informix?jdbc驅動及示例代碼\jdbc驅動\ifxjdbc.jar
?????文件?????112715??2010-04-06?19:27??informix?jdbc驅動及示例代碼\jdbc驅動\ifxjdbcx-g.jar
?????文件??????41405??2010-04-06?19:27??informix?jdbc驅動及示例代碼\jdbc驅動\ifxjdbcx.jar
?????文件????1128531??2010-04-06?19:27??informix?jdbc驅動及示例代碼\jdbc驅動\ifxlang.jar
?????文件?????204196??2010-04-06?19:27??informix?jdbc驅動及示例代碼\jdbc驅動\ifxlsupp.jar
?????文件?????868813??2010-04-06?19:27??informix?jdbc驅動及示例代碼\jdbc驅動\ifxsqlj-g.jar
?????文件?????782385??2010-04-06?19:27??informix?jdbc驅動及示例代碼\jdbc驅動\ifxsqlj.jar
?????文件??????49726??2010-04-06?19:27??informix?jdbc驅動及示例代碼\jdbc驅動\ifxtools-g.jar
?????文件??????46800??2010-04-06?19:27??informix?jdbc驅動及示例代碼\jdbc驅動\ifxtools.jar
?????文件???????1089??2018-09-04?13:56??informix?jdbc驅動及示例代碼\TT01.java
?????目錄??????????0??2018-09-04?14:13??informix?jdbc驅動及示例代碼\jdbc驅動
?????目錄??????????0??2018-09-04?14:15??informix?jdbc驅動及示例代碼
-----------?---------??----------?-----??----
??????????????4501315????????????????????13
評論
共有 條評論