javac.main.java_执行javac main.java 没有 插入效果 ，不知道为什么。。。

前面导入省略。。。publicclassmain{publicstaticfinalStringDATE_TODAY="yyyyMMdd";publicstaticfinalStringDATE_TODAY_2="yyyyMMddHHmmss";publicstaticvoidmain(String[]args){try...

前面导入省略。。。

public class main {

public static final String DATE_TODAY = "yyyyMMdd";

public static final String DATE_TODAY_2 = "yyyyMMddHHmmss";

public static void main(String[] args) {

try {

//delete the data of the table!

deleteData();

/******* sqlload ******/

String strcmdBegin = "cmd /c sqlldr userid=system/ch123@orcl control=PHL_PUJTKX.ctl data=PHL_PUJTKX_4200_U_01_20111211_A_00_001.dat";

Process process=Runtime

.getRuntime()

.exec(strcmdBegin);

//insert the time!

insertOprTime();

} catch (MalformedURLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static void deleteData() {

Connection conn = null;

PreparedStatement st = null;

String url = "jdbc:oracle:thin:@172.16.254.187:1521:orcl" ;

String username = "system" ;

String password = "ch123" ;

String sql = "delete from PHL_PUJTKX ";

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection(url , username , password ) ;

st = conn.prepareStatement(sql);

st.executeQuery();

}catch(Exception e){

e.printStackTrace();

} finally {

try {

if(st!=null) st.close();

if(conn!=null) conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public static void insertOprTime() {

Connection conn2 = null;

PreparedStatement st2 = null;

String yestday = getYestday();

String dayToday=getNowTime();

String url = "jdbc:oracle:thin:@172.16.254.187:1521:orcl" ;

String username = "system" ;

String password = "ch123" ;

String sql2 = "update PHL_PUJTKX set DOWNLOADTIME = '"+dayToday+"' where DOWNLOADTIME is null ";

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

conn2 = DriverManager.getConnection(url , username , password ) ;

st2 = conn2.prepareStatement(sql2);

st2.executeQuery();

}catch(Exception e){

e.printStackTrace();

} finally {

try {

if(st2!=null) st2.close();

if(conn2!=null) conn2.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public static String getYestday(){

SimpleDateFormat df = new SimpleDateFormat (DATE_TODAY);

Calendar c = Calendar.getInstance();

c.add(Calendar.DAY_OF_YEAR, -1);

return df.format(c.getTime());

}

public static String getNowTime(){

SimpleDateFormat df = new SimpleDateFormat (DATE_TODAY_2);

Calendar c = Calendar.getInstance();

c.add(Calendar.DAY_OF_YEAR,0);

return df.format(c.getTime());

}

}

第一次执行 javac main.java 没有插入效果，第二次执行 javac main.java 才有效果,但是插入的数据不是插入到当前对应的表字段中，一直不知道为什么。。。请高手解决！

展开