oracle操作记要下，以后用到方便查找

oracle操作记录下，以后用到方便查找
1、oracle处理clob字段：
    PreparedStatement ps = null;
    Reader clobOpticalPower = new StringReader("...");
    ps.setCharacterStream(9, clobPosition, length());
2、批处理
    con.setAutoCommit(false);
     for (int i = 0; i < eventlist.size(); i++)
     {
        ps.setInt(8, i);
        ps.addBatch();
      }
      ps.executeBatch();
      con.commit();
3、时间戳
      SimpleDateFormat simpleDate = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
      Calendar cal = Calendar.getInstance();
      cal.setTime(simpleDate.parse(eventInfo.getTestTime()));
      java.sql.Timestamp ts = new java.sql.Timestamp(cal.getTime().getTime());
      ps.setTimestamp(1, ts);
4、sqlserver和oracle连接数据库
   Class.forName("net.sourceforge.jtds.jdbc.Driver");
   con = DriverManager.getConnection("jdbc:jtds:sqlserver://ip:端口/UEP4X", "uep4x", "U_TYWG_2008");
            // Class.forName("oracle.jdbc.driver.OracleDriver");
            // con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL", "system", "system");