用Java实现从Excel数据导入到Oracle数据库表中

最新推荐文章于 2024-07-09 09:12:32 发布

planetstar

最新推荐文章于 2024-07-09 09:12:32 发布

阅读量7.9k

点赞数

文章标签： oracle excel 数据库 java import exception

本文链接：https://blog.csdn.net/planetstar/article/details/749523

版权

import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class InsertData {

        public static void main(String[] args){
                Connection myConnSDB = null;
                PreparedStatement psInsertData=null;
                int InsertData=0;
                //Regist Oracle JDBC Driver
                try {
                        DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
                        myConnSDB=
                                DriverManager.getConnection(
                                        "jdbc:oracle:thin:@127.0.0.1:1521:MYDB",
                                        "user",
                                        "user");

myConnSDB.setAutoCommit(false);

                } catch (SQLException e) {
                        e.printStackTrace();
                }

                try{
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        Connection con = DriverManager.getConnection( "jdbc:odbc:Book1","","" );
                        Statement st = con.createStatement();
                        ResultSet rs = st.executeQuery( "SELECT * FROM [Sheet1$]" );
                        psInsertData=
                                                                 myConnSDB.prepareStatement(" INSERT INTO TMP_TABLE"+

" (ACTION_ID,TIMESTAMP,USERID,USERNAME,ISSUE,ACTION)"+

" VALUES "+

" (?,?,?,?,?,?) ");

                        while (rs.next()) {
                                        psInsertData.clearParameters();
                                        psInsertData.setString(1,rs.getString(1));
                                        psInsertData.setString(2,rs.getString(2));
                                        psInsertData.setString(3,rs.getString(3));
                                        psInsertData.setString(4,rs.getString(4));
                                        psInsertData.setString(5,rs.getString(5));
                                        psInsertData.setString(6,rs.getString(6));
                                        InsertData=InsertData+psInsertData.executeUpdate();

                        }
                        System.out.println(""+InsertData);
                        st.close();
                        con.close();
                }catch (Exception ex)
           {
                   System.err.print("Exception: ");
                   System.err.println(ex.getMessage());
                   ex.printStackTrace();
           } finally
                   {
                         try
                         {
                                if (psInsertData!= null)
                           {
                                psInsertData.close();
                           }
                                if (myConnSDB != null)
                           {
                                 myConnSDB.close();
                           }


                         } catch (SQLException e)
                         {
                           e.printStackTrace();
                         }
                   }
                }
        }
================