JAVA测试demo,手工编译执行 |
您所在的位置:网站首页 › java手工编译 › JAVA测试demo,手工编译执行 |
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
|
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |