java操作oracle数据库

package com.chinacahe.logcontrast;   
  
import java.sql.Connection;   
import java.sql.DriverManager;   
import java.sql.PreparedStatement;   
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.ParseException;   
import java.text.SimpleDateFormat;   
import java.util.Date;   
import java.util.HashMap;
import java.util.Map;
  

  
public class Select {   
  
    public static void main(String[] args) throws Exception { 
        
        Connection conn = getOracleConnection();   

		PreparedStatement preparedStatement = conn.prepareStatement("select * from pub_url t where t.pub_url like 'http://storage-1.chinacache.com/ftpDown/people/%_20100104_%'");
		PreparedStatement preparedStatement2 = conn.prepareStatement("insert into pub_url(ID,CHANNEL_ID,CHANNEL_NAME,CONTENT_DATE,FILE_SIZE,LOCAL_PATH,NODE_ID,PUB_DATE,PUB_URL,UPDATE_TIME,USER_ID,USER_NAME) values(PUP_URL_SEQ.nextval,?,?,?,?,?,?,?,?,?,?,?)");
		
		ResultSet rs=preparedStatement.executeQuery();
		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
		Date CONTENT_DATE =null;
		Date PUB_DATE =null;
		Date UPDATE_TIME =null;
		while(rs.next()){
			
			String old_str=rs.getString("pub_url");
			String new_str=old_str.replaceAll("storage-1", "storage-2");

			preparedStatement2.setString(1, rs.getString("CHANNEL_ID"));
			preparedStatement2.setString(2, rs.getString("CHANNEL_NAME"));
			
			CONTENT_DATE = df.parse(rs.getString("CONTENT_DATE").substring(0,10));
			preparedStatement2.setDate(3, new java.sql.Date(CONTENT_DATE.getTime()));

			
			preparedStatement2.setString(4, rs.getString("FILE_SIZE"));
			preparedStatement2.setString(5, rs.getString("LOCAL_PATH"));
			preparedStatement2.setString(6, rs.getString("NODE_ID"));
			
			PUB_DATE = df.parse(rs.getString("PUB_DATE").substring(0,10));
			preparedStatement2.setDate(7, new java.sql.Date(PUB_DATE.getTime()));
			
			
			preparedStatement2.setString(8, new_str);
			
			UPDATE_TIME = df.parse(rs.getString("UPDATE_TIME").substring(0,10));
			preparedStatement2.setDate(9, new java.sql.Date(UPDATE_TIME.getTime()));
		
			
			preparedStatement2.setString(10, rs.getString("USER_ID"));
			preparedStatement2.setString(11, rs.getString("USER_NAME"));
			
			preparedStatement2.executeUpdate();
	
		}
		

		 
		
        
        
       rs.close();
        preparedStatement.close();
        conn.close();   
    }   
  
    public static Connection getOracleConnection() throws Exception {   
        String driver = "oracle.jdbc.driver.OracleDriver";   
        String url = "jdbc:oracle:thin:@*.*.*.*:1521:logpub";   
        String username = "***";   
        String password = "***";   
  
        Class.forName(driver); // load Oracle driver   
        Connection conn = DriverManager.getConnection(url, username, password);   
        return conn;   
    }  
  
}