SQL/PLUS创建JAVA SOURCE的问题,&符号提示输入内容

今天碰到在Oracle中要建立Java source的时候，java中用到很多 & 符号，SQLPlus提示输入变量值。

在网上也没有看到什么合适的内容，翻阅Oracle SQL*Plus User’s Guide and Reference 看到了

set define on|off

set scan on|off

实验了一下，set scan off 就可以关掉这个& 变量提示，但是在文件结尾的时候不要用 set scan on，否则还是会提示。

下面的是JAVA MD5加密的类，是从apache中提取出来的

set define off SET SCAN off create or replace and compile java source named "my/encoder" as package my; import java.security.MessageDigest; import java.security.NoSuchAlgorithmException; public class Encoder { public static byte[] encodeBase64(byte[] binaryData, boolean isChunked) { byte[] CHUNK_SEPARATOR = "/r/n".getBytes(); int EIGHTBIT = 8; int TWENTYFOURBITGROUP = 24; int CHUNK_SIZE = 76; int SIGN = -128; int LOOKUPLENGTH = 64; byte PAD = (byte) '='; int SIXTEENBIT = 16; byte[] lookUpBase64Alphabet = new byte[LOOKUPLENGTH]; for (int i = 0; i <= 25; i++) { lookUpBase64Alphabet[i] = (byte) ('A' + i); } for (int i = 26, j = 0; i <= 51; i++, j++) { lookUpBase64Alphabet[i] = (byte) ('a' + j); } for (int i = 52, j = 0; i <= 61; i++, j++) { lookUpBase64Alphabet[i] = (byte) ('0' + j); } lookUpBase64Alphabet[62] = (byte) '+'; lookUpBase64Alphabet[63] = (byte) '/'; int lengthDataBits = binaryData.length * EIGHTBIT; int fewerThan24bits = lengthDataBits % TWENTYFOURBITGROUP; int numberTriplets = lengthDataBits / TWENTYFOURBITGROUP; byte encodedData[] = null; int encodedDataLength = 0; int nbrChunks = 0; if (fewerThan24bits != 0) { encodedDataLength = (numberTriplets + 1) * 4; } else { encodedDataLength = numberTriplets * 4; } if (isChunked) { nbrChunks = (CHUNK_SEPARATOR.length == 0 ? 0 : (int) Math .ceil((float) encodedDataLength / CHUNK_SIZE)); encodedDataLength += nbrChunks * CHUNK_SEPARATOR.length; } encodedData = new byte[encodedDataLength]; byte k = 0, l = 0, b1 = 0, b2 = 0, b3 = 0; int encodedIndex = 0; int dataIndex = 0; int i = 0; int nextSeparatorIndex = CHUNK_SIZE; int chunksSoFar = 0; for (i = 0; i < numberTriplets; i++) { dataIndex = i * 3; b1 = binaryData[dataIndex]; b2 = binaryData[dataIndex + 1]; b3 = binaryData[dataIndex + 2]; l = (byte) (b2 & 0x0f); k = (byte) (b1 & 0x03); byte val1 = ((b1 & SIGN) == 0) ? (byte) (b1 >> 2) : (byte) ((b1) >> 2 ^ 0xc0); byte val2 = ((b2 & SIGN) == 0) ? (byte) (b2 >> 4) : (byte) ((b2) >> 4 ^ 0xf0); byte val3 = ((b3 & SIGN) == 0) ? (byte) (b3 >> 6) : (byte) ((b3) >> 6 ^ 0xfc); encodedData[encodedIndex] = lookUpBase64Alphabet[val1]; encodedData[encodedIndex + 1] = lookUpBase64Alphabet[val2 | (k << 4)]; encodedData[encodedIndex + 2] = lookUpBase64Alphabet[(l << 2) | val3]; encodedData[encodedIndex + 3] = lookUpBase64Alphabet[b3 & 0x3f]; encodedIndex += 4; if (isChunked) { if (encodedIndex == nextSeparatorIndex) { System.arraycopy(CHUNK_SEPARATOR, 0, encodedData, encodedIndex, CHUNK_SEPARATOR.length); chunksSoFar++; nextSeparatorIndex = (CHUNK_SIZE * (chunksSoFar + 1)) + (chunksSoFar * CHUNK_SEPARATOR.length); encodedIndex += CHUNK_SEPARATOR.length; } } } dataIndex = i * 3; if (fewerThan24bits == EIGHTBIT) { b1 = binaryData[dataIndex]; k = (byte) (b1 & 0x03); byte val1 = ((b1 & SIGN) == 0) ? (byte) (b1 >> 2) : (byte) ((b1) >> 2 ^ 0xc0); encodedData[encodedIndex] = lookUpBase64Alphabet[val1]; encodedData[encodedIndex + 1] = lookUpBase64Alphabet[k << 4]; encodedData[encodedIndex + 2] = PAD; encodedData[encodedIndex + 3] = PAD; } else if (fewerThan24bits == SIXTEENBIT) { b1 = binaryData[dataIndex]; b2 = binaryData[dataIndex + 1]; l = (byte) (b2 & 0x0f); k = (byte) (b1 & 0x03); byte val1 = ((b1 & SIGN) == 0) ? (byte) (b1 >> 2) : (byte) ((b1) >> 2 ^ 0xc0); byte val2 = ((b2 & SIGN) == 0) ? (byte) (b2 >> 4) : (byte) ((b2) >> 4 ^ 0xf0); encodedData[encodedIndex] = lookUpBase64Alphabet[val1]; encodedData[encodedIndex + 1] = lookUpBase64Alphabet[val2 | (k << 4)]; encodedData[encodedIndex + 2] = lookUpBase64Alphabet[l << 2]; encodedData[encodedIndex + 3] = PAD; } if (isChunked) { if (chunksSoFar < nbrChunks) { System.arraycopy(CHUNK_SEPARATOR, 0, encodedData, encodedDataLength - CHUNK_SEPARATOR.length, CHUNK_SEPARATOR.length); } } return encodedData; } protected String mergePasswordAndSalt(String password, Object salt, boolean strict) { if(password == null) password = ""; if(strict && salt != null && (salt.toString().lastIndexOf("{") != -1 || salt.toString().lastIndexOf("}") != -1)) throw new IllegalArgumentException("Cannot use { or } in salt.toString()"); if(salt == null || "".equals(salt)) return password; else return password + "{" + salt.toString() + "}"; } protected final MessageDigest getMessageDigest() throws IllegalArgumentException { try{ MessageDigest ret = MessageDigest.getInstance("MD5"); return ret; }catch(NoSuchAlgorithmException e){ throw new IllegalArgumentException("No such algorithm [ MD5 ]"); } } /*加密方法*/ public static String encodePassword(String rawPass) { Encoder e = new Encoder(); String saltedPass = e.mergePasswordAndSalt(rawPass, null, false); MessageDigest messageDigest = e.getMessageDigest(); byte digest[] = messageDigest.digest(saltedPass.getBytes()); return new String(encodeBase64(digest, false)); } private static int strToInt(String strHex) { int iValue = 0; try { iValue = Integer.parseInt(strHex, 16); } catch (Exception e) { } return iValue; } } / exit /