GBase 8s
运维管理
文章

JAVA测试demo,手工编译执行

GBase社区管理员
发表于2023-05-12 10:25:2084次浏览0个评论

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

评论已关闭