Java uses JDBC to connect to Oracle and MSSQL instances:
- ImportJava. SQL .*;
- Public ClassTestJDBC {
- Public Static VoidMain (String [] args ){
- Connection oracle_conn =Null;
- Statement oracle_stmt =Null;
- ResultSet oracle_rs =Null;
- Connection mssql_conn =Null;
- Statement mssql_stmt =Null;
- ResultSet mssql_rs =Null;
- Try{
- Class. forName ("Oracle. jdbc. driver. OracleDriver");
- Oracle_conn = DriverManager. getConnection ("Jdbc: oracle: thin: @ 192.168.0.215: 1521: orcl","Username","Password");
- Oracle_stmt = oracle_conn.createStatement ();
- Class. forName ("Com. microsoft. sqlserver. jdbc. SQLServerDriver");
- Mssql_conn = DriverManager. getConnection ("Jdbc: sqlserver: // 192.168.0.213: 1433; DatabaseName = VIS","Username","Password");
- Mssql_stmt = mssql_conn.createStatement ();
- Mssql_rs = mssql_stmt.executeQuery ("Select * from VideoBaseInfo");
- While(Mssql_rs.next ()){
- System. out. println ("Inserting VideoId :"+ Mssql_rs.getInt ("VideoId") +"Records ...");
- Oracle_stmt.executeUpdate ("Insert into VIDEO_BASEINFO values ("
- + Mssql_rs.getInt ("VideoId") +",'"
- + Mssql_rs.getString ("VideoName") +"','"
- + Mssql_rs.getString ("VideoVersion") +"',"
- + Mssql_rs.getInt ("VideoMp4Items") +","
- + Mssql_rs.getInt ("VideoRmvbItems") +",'"
- + Mssql_rs.getString ("VideoAliasName") +"','"
- + Mssql_rs.getString ("VideoAge") +"'"
- +")");
- }
- }Catch(ClassNotFoundException e ){
- E. printStackTrace ();
- }Catch(SQLException e ){
- E. printStackTrace ();
- }Finally{
- Try{
- If(Oracle_rs! =Null){
- Oracle_rs.close ();
- Oracle_rs =Null;
- }
- If(Oracle_stmt! =Null){
- Oracle_stmt.close ();
- Oracle_stmt =Null;
- }
- If(Oracle_conn! =Null){
- Oracle_conn.close ();
- Oracle_conn =Null;
- }
- If(Mssql_rs! =Null){
- Mssql_rs.close ();
- Mssql_rs =Null;
- }
- If(Mssql_stmt! =Null){
- Mssql_stmt.close ();
- Mssql_stmt =Null;
- }
- If(Mssql_conn! =Null){
- Mssql_conn.close ();
- Mssql_conn =Null;
- }
- }Catch(SQLException e ){
- E. printStackTrace ();
- }
- }
- }
- }