Oracle EBS暂时还只支持一维码，所以如需要二维码的打印和扫描，需要自行开发。PL/SQL还没有成熟的二维码生成类库，但Java已有很多二维码生成和解码的第三方类库（比如，QRCode，ZXing...），这里以比较简单的QRCode为例演示怎么输出和解码二维码。一个QRCode的简单例子：
涉及到的主要类库:
-
编码 lib：Qrcode_swetake.jar （官网介绍 -- http://www.swetake.com/qr/index-e.html）
-
解码 lib：qrcode.jar （官网介绍 -- http://sourceforge.jp/projects/qrcode/）
二维码图片的生成：
-
import java.awt.Color;
-
import java.awt.Graphics2D;
-
import java.awt.image.BufferedImage;
-
import java.io.File;
-
-
import javax.imageio.ImageIO;
-
-
import com.swetake.util.Qrcode;
-
-
-
-
-
public class PTIANQRCodeEncoder {
-
-
-
-
-
-
-
-
public void encoderQRCode(String content, String imgPath) {
-
try {
-
-
Qrcode qrcodeHandler = new Qrcode();
-
qrcodeHandler.setQrcodeErrorCorrect('M');
-
qrcodeHandler.setQrcodeEncodeMode('B');
-
qrcodeHandler.setQrcodeVersion(7);
-
-
System.out.println(content);
-
byte[] contentBytes = content.getBytes("gb2312");
-
-
BufferedImage bufImg = new BufferedImage(140, 140,
-
BufferedImage.TYPE_INT_RGB);
-
-
Graphics2D gs = bufImg.createGraphics();
-
-
gs.setBackground(Color.WHITE);
-
gs.clearRect(0, 0, 140, 140);
-
-
-
gs.setColor(Color.BLACK);
-
-
-
int pixoff = 2;
-
-
if (contentBytes.length > 0 && contentBytes.length < 120) {
-
boolean[][] codeOut = qrcodeHandler.calQrcode(contentBytes);
-
for (int i = 0; i < codeOut.length; i++) {
-
for (int j = 0; j < codeOut.length; j++) {
-
if (codeOut[j][i]) {
-
gs.fillRect(j * 3 + pixoff, i * 3 + pixoff, 3, 3);
-
}
-
}
-
}
-
} else {
-
System.err.println("QRCode content bytes length = "
-
+ contentBytes.length + " not in [ 0,120 ]. ");
-
}
-
-
gs.dispose();
-
bufImg.flush();
-
-
File imgFile = new File(imgPath);
-
-
-
ImageIO.write(bufImg, "png", imgFile);
-
-
} catch (Exception e) {
-
e.printStackTrace();
-
}
-
-
}
-
-
-
-
-
-
public static void main(String[] args) {
-
String imgPath = "D:/PTIAN_QRCode.png";
-
-
String content = "PTIAN Oracle EBS Repository,你好，世界";
-
-
PTIANQRCodeEncoder handler = new PTIANQRCodeEncoder();
-
handler.encoderQRCode(content, imgPath);
-
-
System.out.println("encoder QRcode success");
-
}
-
-
}
生成的图片：
解析二维码：
-
import java.awt.image.BufferedImage;
-
import java.io.File;
-
import java.io.IOException;
-
-
import javax.imageio.ImageIO;
-
-
import jp.sourceforge.qrcode.QRCodeDecoder;
-
import jp.sourceforge.qrcode.data.QRCodeImage;
-
import jp.sourceforge.qrcode.exception.DecodingFailedException;
-
-
-
public class PTIANQRCodeDecoderHandler {
-
-
-
-
-
-
-
public String decoderQRCode(String imgPath) {
-
-
-
File imageFile = new File(imgPath);
-
-
BufferedImage bufImg = null;
-
String decodedData = null;
-
try {
-
bufImg = ImageIO.read(imageFile);
-
-
QRCodeDecoder decoder = new QRCodeDecoder();
-
decodedData = new String(decoder.decode(new J2SEImage(bufImg)));
-
-
-
-
-
-
-
-
} catch (IOException e) {
-
System.out.println("Error: " + e.getMessage());
-
e.printStackTrace();
-
} catch (DecodingFailedException dfe) {
-
System.out.println("Error: " + dfe.getMessage());
-
dfe.printStackTrace();
-
}
-
return decodedData;
-
}
-
-
-
-
-
public static void main(String[] args) {
-
PTIANQRCodeDecoderHandler handler = new PTIANQRCodeDecoderHandler();
-
String imgPath = "d:/PTIAN_QRCode.png";
-
String decoderContent = handler.decoderQRCode(imgPath);
-
System.out.println("解析结果如下：");
-
System.out.println(decoderContent);
-
System.out.println("========decoder success!!!");
-
}
-
-
class J2SEImage implements QRCodeImage {
-
BufferedImage bufImg;
-
-
public J2SEImage(BufferedImage bufImg) {
-
this.bufImg = bufImg;
-
}
-
-
public int getWidth() {
-
return bufImg.getWidth();
-
}
-
-
public int getHeight() {
-
return bufImg.getHeight();
-
}
-
-
public int getPixel(int x, int y) {
-
return bufImg.getRGB(x, y);
-
}
-
-
}
-
}
Output:
解析结果如下：
PTIAN Oracle EBS Repository,你好，世界
========decoder success!!!
Oracle EBS中如何使用QRCode来打印二维码，ITPUB上已经有人通过JSP来调用QRCode做到了，最终可以在XML报表中打印，详见帖子：http://www.itpub.net/thread-1755791-1-1.html
未完...
