ITPub博客

DBConnection.javaimport java.sql.DriverManager;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;import java.sql.ResultSet;public class DBConnection{ public static void main(String args[]){ if (args.length < 3){ System.out.println("Syntax: DBConnection [url] [username] [password]"); System.exit(-1); } String urlurl = args[0]; String username = args[1]; String password =

$ORACLE_HOME/sqlplus/admin/glogin.sqldefine _editor=vi -- can set as notepad, emacs ...set serverouput on size 1000000 -- set the default buffer size as long as possiblecall dbms_java.set_output(1000000); -- redirects the Java ssytem.out to sqlplus session dbms.output bufferset trimspool onset sqlblankline onset long 5000 -- number of bytes displayed when selecting the LONG or CLOB columnsset linesize 300 pagesize 9999column plan_plus_exp format a80 -- width of the explain plan outputcolumn gl