ORACLE连库

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());
   
  }

  
  
 }

}