java代码部分
public class Test { /**
* @param args
*/
public static void main(String[] args) {
Connection myConnSDB = null;
//qidong Oracle JDBC Driver
try {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
myConnSDB = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.46.225:1521:ORCL", "NM", "NM"); myConnSDB.setAutoCommit(true); } catch (SQLException e) {
e.printStackTrace();
} try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:TestData", "",
"");
Statement st = conn.createStatement();
//congwenjianzhongqudeshuju
ResultSet rs = st.executeQuery("SELECT * FROM [InsertAction$]");
CallableStatement csInsertData = conn.prepareCall("{ call INSERTDEPT(?,?,?)}");
while (rs.next()) {
csInsertData.setString(1, rs.getString(1));
csInsertData.setString(2, rs.getString(2));
csInsertData.setString(3, rs.getString(3));
csInsertData.execute();
}
System.out.println("a");
st.close();
conn.close();
} catch (Exception ex) {
System.err.println("Exception: ");
ex.printStackTrace();
} finally {
try {
if (myConnSDB != null) {
myConnSDB.close();
} } catch (SQLException e) {
e.printStackTrace();
}
}
}
}
Oracle存储过程部分
CREATE OR REPLACE PROCEDURE insertDEPT(v_deptno in dept.deptno%TYPE,v_dname in dept.dname%TYPE,v_loc in dept.loc%TYPE)
AS
empno_remaining EXCEPTION;
PRAGMA EXCEPTION_INIT(empno_remaining, -1);
BEGIN
INSERT INTO dept(deptno,dname,loc)
VALUES(v_deptno, v_dname, v_loc);
DBMS_OUTPUT.PUT_LINE('insert success');
EXCEPTION
WHEN empno_remaining THEN
DBMS_OUTPUT.PUT_LINE('cuowu');
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLCODE||'---'||SQLERRM);
END InsertDEPT;现在无法把获得的数据写入到数据库中,请高人指点
public class Test { /**
* @param args
*/
public static void main(String[] args) {
Connection myConnSDB = null;
//qidong Oracle JDBC Driver
try {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
myConnSDB = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.46.225:1521:ORCL", "NM", "NM"); myConnSDB.setAutoCommit(true); } catch (SQLException e) {
e.printStackTrace();
} try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:TestData", "",
"");
Statement st = conn.createStatement();
//congwenjianzhongqudeshuju
ResultSet rs = st.executeQuery("SELECT * FROM [InsertAction$]");
CallableStatement csInsertData = conn.prepareCall("{ call INSERTDEPT(?,?,?)}");
while (rs.next()) {
csInsertData.setString(1, rs.getString(1));
csInsertData.setString(2, rs.getString(2));
csInsertData.setString(3, rs.getString(3));
csInsertData.execute();
}
System.out.println("a");
st.close();
conn.close();
} catch (Exception ex) {
System.err.println("Exception: ");
ex.printStackTrace();
} finally {
try {
if (myConnSDB != null) {
myConnSDB.close();
} } catch (SQLException e) {
e.printStackTrace();
}
}
}
}
Oracle存储过程部分
CREATE OR REPLACE PROCEDURE insertDEPT(v_deptno in dept.deptno%TYPE,v_dname in dept.dname%TYPE,v_loc in dept.loc%TYPE)
AS
empno_remaining EXCEPTION;
PRAGMA EXCEPTION_INIT(empno_remaining, -1);
BEGIN
INSERT INTO dept(deptno,dname,loc)
VALUES(v_deptno, v_dname, v_loc);
DBMS_OUTPUT.PUT_LINE('insert success');
EXCEPTION
WHEN empno_remaining THEN
DBMS_OUTPUT.PUT_LINE('cuowu');
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLCODE||'---'||SQLERRM);
END InsertDEPT;现在无法把获得的数据写入到数据库中,请高人指点
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货