|
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.Locale;
public class Te {
/**
* @param args
* @throws SQLException
* @throws ClassNotFoundException
* @throws IllegalAccessException
* @throws InstantiationException
*/
public static void main(String[] args) {
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@10.194.133.16:1521:test"; //orcl为数据库的SID
String user="crm";
String password="crm";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement();
ResultSet rs = null;
String x="2006-12-28 16:38:220";
String SJTJRQ=x.substring(0, 19);
String SJRQ=x.substring(0, 19);
java.text.SimpleDateFormat sdf=new java.text.SimpleDateFormat("yyyy-MM-dd hh:mm:ss");//string 转换为Date
Date rq = sdf.parse(SJRQ); //PUBDATE为string类型
String name="哈w22spp哈";
stmt.executeUpdate("insert into test values (3232,‘"+name+"‘,TO_DATE(‘"+SJRQ+"‘ ,‘YYYY-MM-DD hh24:mi:ss‘),‘"+name+"‘)");
// stmt.executeUpdate("INSERT INTO IO_TRADE VALUES(IO_TRADE_SEQ.NEXTVAL,‘"+YJBH+"‘,‘"+SJFS_DM+"‘,‘"+YJTM+"‘,TO_DATE(‘"+D_SJRQ+"‘ ,‘YYYY-MM-DD hh24:mi:ss‘),‘"+YJZL_DM+"‘,‘"+JCBZ_DM+"‘,‘"+TDBZ_DM+"‘,‘"+SJJG_DM+"‘,‘"+JDJ_DM+"‘,‘"+ZFFS_DM+"‘,‘"+TXBH+"‘,‘"+YGBH+"‘,‘"+YHBH_DM+"‘,‘"+BZ_DM+"‘,‘"+YJZL+"‘,‘"+YJJS+"‘,‘"+BXJE_ZF+"‘,‘"+BJJE_ZF+"‘,"DSHK_ZF",‘"+BJF_ZF+"‘,‘"+BXF_ZF+"‘,‘"+YGF_ZF+"‘,‘"+BGF_ZF+"‘,‘"+GHF_ZF+"‘,‘"+DYF_ZF+"‘,‘"+HZF_ZF+"‘,‘"+HKF_ZF+"‘,‘"+CLF_ZF+"‘,‘"+BJSXF_ZF+"‘,‘"+JBTDF_ZF+"‘,‘"+DSTDF_ZF+"‘,‘"+JRTDF_ZF+"‘,‘"+QTF_ZF+"‘,‘"+JBZF_ZF+"‘,‘"+ZZF_ZF+"‘,‘"+LRJG+"‘,‘"+LRGH+"‘,‘"+LRTX+"‘,‘"+LRFS_DM+"‘,‘"+BZJE_ZF+"‘,‘"+BZF_ZF+"‘,‘"+SJRXM+"‘,‘"+CYJL+"‘,‘"+CYTDF_ZF+"‘,‘"+JDGB_DM+"‘,‘"+JDSMGM+"‘,‘"+JDJYB+"‘,‘"+SJJYB+"‘,‘"+WJF_ZF+"‘,‘"+BGBZ_DM+"‘,‘"+BZSXF_ZF+"‘,TO_DATE(‘"+D_SJTJRQ+"‘ ,‘YYYY-MM-DD hh24:mi:ss‘),‘yyyy-mm-dd hh24:mi:ss‘),‘"+SJRDZ+"‘,‘"+SJRDH+"‘,‘"+SJRYB+"‘,‘"+JJRXM+"‘,‘"+JJRDZ+"‘,‘"+JJRDH+"‘,‘"+JJRYB+"‘,‘"+YJC+"‘,‘"+YJK+"‘,‘"+YJG+"‘,‘"+HPSL+"‘,‘"+YGBGBZ_DM+"‘,‘"+YGBGWPLX_DM+"‘)");
}
catch(Exception e){
System.out.print(e.getMessage());
}
}
}
|
