JAVA测试demo,手工编译执行
GBase社区管理员import java.sql.*;
public class DBTest {
public static void main(String[] args) throws Exception {
test();
}
public static void test(){
String URL = "jdbc:informix-sqli://XXXXX:XXXXX/XXXX:INFORMIXSERVER=XXXX;DB_LOCALE=zh_CN.utf8;CLIENT_LOCALE=zh_CN.utf8;NEWCODESET=UTF8,utf8,57372;IFX_LOCK_MODE_WAIT=100;";
String USER = "informix";
String PASSWORD ="xxxxx";
String sql1 = "select seq_fileinfo.nextval from sysmaster:sysdual ";
try {
Class.forName("com.informix.jdbc.IfxDriver");
Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
Statement stmt = conn.createStatement();
//1.加载驱动程序
double a = System.currentTimeMillis();
System.out.println("开始:");
double b = System.currentTimeMillis();
ResultSet rs = stmt.executeQuery(sql1);
while(rs.next()){
System.out.println(rs.getString(1));
}
System.out.println("结束1:"+(System.currentTimeMillis()-b));
/*PreparedStatement pst = conn.prepareStatement(sql2);
pst.setString(1,"4101");
double c = System.currentTimeMillis();
pst.executeQuery();
System.out.println("结束2:"+(System.currentTimeMillis()-c));*/
}catch (Exception e){
e.printStackTrace();
}
}
}
#编译JAVA
javac -cp .:ifxjdbc.jar ./DBTest.java
#手工执行编译后的JAVA程序
java -cp .:ifxjdbc.jar DBTest
热门帖子
- 12025-12-01浏览数:182759
- 22023-05-09浏览数:25052
- 42023-09-25浏览数:18521
- 52020-05-11浏览数:17526