Boa tarde pessoal..
Tenho o codigo abaixo no eclipse... ja pedi para compilar e compilou na boa..
Problema:
Sou iniciante em java e quero rodar esse aplicação direto no eclipse passando os parametros que preciso passar .. como faço para que o prompt pedindo os parametros apareca pra mim na tela. Quando eu dou um run na aplicação somente e mensagem "Usage:
java InsertEmps
Valew.
import java.io.*;
import java.sql.*;
import oracle.jdbc.driver.*;
import oracle.xml.sql.*;
import oracle.sql.*;
public class InsertEmps {
/* YOU'LL have to change these connection properties */
static String conStr = "jdbc:oracle:thin:@190.1.1.5:1521:9i_utf8";
public static void main(String args[])
throws SQLException, FileNotFoundException, IOException {
if (args.length != 3) {
System.out.println("\nUsage:\n java InsertEmps <username> <password> <filename>\n");
System.exit(0);
}
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection(conStr, args[0], args[1]);
conn.setAutoCommit(false);
String sql =
"begin insert into tmp_clob(theclob) " +
"values (empty_clob()) return theclob,id into ?,?; end;";
OracleCallableStatement ocs = (OracleCallableStatement)conn.prepareCall(sql);
ocs.registerOutParameter(1, OracleTypes.CLOB);
ocs.registerOutParameter(2, OracleTypes.NUMBER);
ocs.executeUpdate();
oracle.sql.NUMBER clobId = ocs.getNUMBER(2);
InputStream is = new FileInputStream(args[2]);
OutputStream os = (ocs.getCLOB(1)).getAsciiOutputStream();
byte[] buf = new byte[1024];
int length;
while ((length = is.read(buf, 0, 1024)) != -1) {
os.write(buf, 0, length);
}
is.close();
os.close();
ocs.close();
OracleCallableStatement ocs2 =
(OracleCallableStatement)conn.prepareCall("begin ? := insert_xml_emps(?, ?); end;");
ocs2.registerOutParameter(1, OracleTypes.NUMBER);
ocs2.setString(2,"EMP");
ocs2.setNUMBER(3, clobId);
try {
ocs2.execute();
System.out.println("Inserted " + (ocs2.getNUMBER(1)).longValue() + " records.");
} catch (Exception e) {
e.printStackTrace();
}
ocs2.close();
conn.commit();
conn.close();
}
}