Select level location from dual connect by level <= (select nvl(max(location), 0) from pt_dltgls where dp_lot_id='C9J04031' and gls_status='S') minus select distinct location from pt_dltgls t where dp_lot_id='C9J04031' and gls_status='S'
Imports Microsoft.VisualBasic
Imports System.Data.OleDb
Imports System.Data
Public Class Table
Private _name As String
Private _delSql As ArrayList
Private _dtDel As DataTable
Private _dsQry As DataSet
Public Sub New(ByVal name As String)
'constructor
Me._name = name
Me._delSql = New ArrayList()
End Sub
Public ReadOnly Property Name() As String
Get
Return _name
End Get
End Property
Public Property DataTable() As DataTable
Get
Return _dtDel
End Get
Set(ByVal value As DataTable)
_dtDel = value
End Set
End Property
Public Sub putDelSql(ByVal sSql As String)
If Not sSql Is Nothing Then
_delSql.Add(sSql)
End If
End Sub
Public Function getDelSql() As ArrayList
Return _delSql
End Function
Public Function getDelSql(ByVal i As Integer) As String
If i <= _delSql.Count - 1 Then
Return _delSql(i)
End If
Return Nothing
End Function
Public Property DataSetQry() As DataSet
Get
Return _dsQry
End Get
Set(ByVal value As DataSet)
_dsQry = value
End Set
End Property
End Class
<%@ page language="java" contentType="text/html; charset=BIG5"
pageEncoding="BIG5" import="java.util.*;"%>
<%
String gender = request.getParameter("gender");
String name = request.getParameter("name");
out.println((gender.equalsIgnoreCase("male")?"Mr.":"Mrs.") + " " + name);
out.println("Hello world! This message is posted by Server.");
%>
| jQuery DOM Operation | |
|---|---|
original |
DOMtoXML.javaA12345 1 B12345 2 Iden123 李昭慶 d1 c1 1 1 1 d2 c2 2 2 2 d3 c3 3 3 3
/**
* Object output XML format by DOM.
*/
package com.iden.Dom;
import java.io.*;
import java.util.ArrayList;
import javax.xml.parsers.*;
import javax.xml.transform.*;
import javax.xml.transform.stream.*;
import javax.xml.transform.dom.DOMSource;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
public class DOMtoXML {
DOMtoXML(){}
public static void main(String[] args) {
DOMtoXML jt = new DOMtoXML();
Lot lot = new Lot("A12345", "1", "B12345", "2", "Iden123", "李昭慶");
lot.putGlass("d1", "c1", "1", "1", "1");
lot.putGlass("d2", "c2", "2", "2", "2");
lot.putGlass("d3", "c3", "3", "3", "3");
String xml = lot.genObjectToXML();
System.out.println(xml); //print the xml string
}
private String encoding(String s){
try {
return new String(s.getBytes(), "UTF-8"); //"ISO-8859-1"
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
return null;
}
}
class Lot {
DocumentBuilderFactory f;
DocumentBuilder b;
Document doc;
private String lotId1;
private String glsQty1;
private String lotId2;
private String glsQty2;
private String userId;
private String userName;
private ArrayList glasses;
Lot(String lotId1, String glsQty1, String lotId2, String glsQty2, String userId, String userName) {
this.glasses = new ArrayList();
this.lotId1 = lotId1;
this.glsQty1 = glsQty1;
this.lotId2 = lotId2;
this.glsQty2 = glsQty2;
this.userId = userId;
this.userName = userName;
f = DocumentBuilderFactory.newInstance();
try {
b = f.newDocumentBuilder();
} catch (ParserConfigurationException e) {
e.printStackTrace();
}
doc = b.newDocument();
}
public String genObjectToXML(){
try {
/*
* XML output format:
*/
Element root = doc.createElement(this.getClass().getSimpleName());
doc.appendChild(root);
Element e;
e = doc.createElement("lotId1");
root.appendChild(e);
e.appendChild(doc.createTextNode(this.lotId1));
e = doc.createElement("glsQty1");
root.appendChild(e);
e.appendChild(doc.createTextNode(this.glsQty1));
e = doc.createElement("lotId2");
root.appendChild(e);
e.appendChild(doc.createTextNode(this.lotId2));
e = doc.createElement("glsQty2");
root.appendChild(e);
e.appendChild(doc.createTextNode(this.glsQty2));
e = doc.createElement("userId");
root.appendChild(e);
e.appendChild(doc.createTextNode(this.userId));
e = doc.createElement("userName");
root.appendChild(e);
e.appendChild(doc.createTextNode(this.userName));
Element g, dpLot, cutLot, gId, location, orgLocation;
for(int i=0;i<glasses.size();i++){
Glass objG = (Glass)glasses.get(i);
g = doc.createElement("glass");
root.appendChild(g);
dpLot = doc.createElement("dpLotId");
g.appendChild(dpLot);
dpLot.appendChild(doc.createTextNode(objG.getDpLotId()));
cutLot = doc.createElement("cutLotId");
g.appendChild(cutLot);
cutLot.appendChild(doc.createTextNode(objG.getCutLotId()));
gId = doc.createElement("glsId");
g.appendChild(gId);
gId.appendChild(doc.createTextNode(objG.getGlsId()));
location = doc.createElement("location");
g.appendChild(location);
location.appendChild(doc.createTextNode(objG.getLocation()));
orgLocation = doc.createElement("orgLocation");
g.appendChild(orgLocation);
orgLocation.appendChild(doc.createTextNode(objG.getOrgLocation()));
}
TransformerFactory tf = TransformerFactory.newInstance();
Transformer m = tf.newTransformer();
DOMSource source = new DOMSource(doc);
ByteArrayOutputStream byte1 = new ByteArrayOutputStream();
StreamResult result = new StreamResult(byte1);
System.out.println("Encoding: " + m.getOutputProperty(OutputKeys.ENCODING));
m.setOutputProperty(OutputKeys.ENCODING, "BIG5");
m.transform(source, result);
return byte1.toString();
} catch (TransformerConfigurationException e) {
e.printStackTrace();
} catch (TransformerException e) {
e.printStackTrace();
}
return null;
}
public void putGlass(String dpLotId, String cutLotId, String glsId, String location, String orgLocation) {
if (dpLotId != null && cutLotId != null && glsId != null && location != null && orgLocation != null) {
Glass g = new Glass();
g.setDpLotId(dpLotId);
g.setCutLotId(cutLotId);
g.setGlsId(glsId);
g.setLocation(location);
g.setOrgLocation(orgLocation);
glasses.add(g);
}
}
class Glass {
private String dpLotId;
private String cutLotId;
private String glsId;
private String location;
private String orgLocation;
public String getGlsId() {
return glsId;
}
public void setGlsId(String glsId) {
this.glsId = glsId;
}
public String getLocation() {
return location;
}
public void setLocation(String location) {
this.location = location;
}
public String getDpLotId() {
return dpLotId;
}
public void setDpLotId(String dpLotId) {
this.dpLotId = dpLotId;
}
public String getCutLotId() {
return cutLotId;
}
public void setCutLotId(String cutLotId) {
this.cutLotId = cutLotId;
}
public String getOrgLocation() {
return orgLocation;
}
public void setOrgLocation(String orgLocation) {
this.orgLocation = orgLocation;
}
}
}
/*
* Log.java with encode
* for logging
*
* Created on 2009年10月16日
*
* @author Iden
*
****<< Modification Note >>
* Date PTS/PBR/PCR Label Editor Description
* ========== =============== ========== ========== ============================================================
* 2009/10/16 0.0.0.1 Iden create
*/
package com.iden.util;
import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.io.Writer;
import java.nio.charset.Charset;
import java.nio.charset.CharsetEncoder;
import java.text.SimpleDateFormat;
public class Log {
private String filePath = ""; //directory path of Log
private String filePrefix = ""; //prefix name of log file
private String fileSubName = ""; //subname of log file
String curWorkingDir = System.getProperty("user.dir"); //User working directory
private String breakLine="\n";
private Object encoding;
private String encodingStr;
public Log(String path) {
this(path, "log", "UTF-8");
}
public Log(String path, String subname, Object encoding) {
this(path, "Log", subname, encoding);
}
public Log(String path, String prefix, String subname, Object encoding) {
if(encoding ==null)
new Exception("encoding is empth");
filePath = path;
filePrefix = prefix;
fileSubName = subname;
this.encoding = encoding;
}
/**
* Output the log file
* @param str
*/
public void write(String str) {
OutputStream stream = null;
Writer writer = null;
SimpleDateFormat formatter = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
try {
String folder = generateDirectory();
File file = new File(folder + filePrefix + "_" + getCurrYYYYMMDD() + "." + fileSubName);
StringBuffer sb = new StringBuffer("");
sb.append("[" + formatter.format(new java.util.Date()) + "] [start]" + breakLine)
.append(str)
.append(breakLine + "[end]" + breakLine);
stream = new FileOutputStream(file, true);
if (encoding instanceof Charset) {
writer = new OutputStreamWriter(stream, (Charset)encoding);
} else if (encoding instanceof CharsetEncoder) {
writer = new OutputStreamWriter(stream, (CharsetEncoder)encoding);
} else {
writer = new OutputStreamWriter(stream, (String)encoding);
}
OutputStreamWriter osw =(OutputStreamWriter)writer;
encodingStr = osw.getEncoding();
osw = null;
writer.write(sb.toString());
writer.flush();
writer.close();
} catch (java.io.FileNotFoundException efnf) {
writeException("FileNotFoundException at open log file: " + efnf.getMessage());
} catch (java.io.IOException exio) {
writeException("IOException at write log file: " + exio.getMessage());
} catch (java.lang.Exception e) {
writeException("Exception at write log file: " + e.getMessage());
} finally {
writer = null;
}
}
/**
* Output the log file with default encoding
* @param str
*/
public void writeDefaultEncode(String str) {
java.io.FileWriter fw = null;
SimpleDateFormat formatter = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
try {
String folder = generateDirectory();
fw = new java.io.FileWriter(folder + filePrefix + "_"
+ getCurrYYYYMMDD() + "." + fileSubName, true);
fw.write("[" + formatter.format(new java.util.Date()) + "] " + breakLine + "[start]" + breakLine);
fw.write(str);
fw.write(breakLine + "[end]" + breakLine);
fw.flush();
fw.close();
} catch (java.io.FileNotFoundException efnf) {
writeException("FileNotFoundException at open log file: " + efnf.getMessage());
} catch (java.io.IOException exio) {
writeException("IOException at write log file: " + exio.getMessage());
} catch (java.lang.Exception e) {
writeException("Exception at write log file: " + e.getMessage());
} finally {
fw = null;
}
}
/**
* Get the encoding string
*/
public String getEncoding(){
if(encodingStr != null)
return encodingStr;
return null;
}
/**
* Generate directory path
* @return
*/
private String generateDirectory() {
String folder = defineDirectoryName(filePath);
java.io.File file = new java.io.File(folder);
file.mkdirs();
return folder;
}
/**
* Define the directory path of Log. format is path\YYYY\MM
* @param path
* @return current directory path
*/
private String defineDirectoryName(String path) {
java.util.Calendar cal = java.util.Calendar.getInstance(java.util.Locale.TAIWAN);
String folder = path;
folder = folder + "\\" + String.valueOf(cal.get(java.util.Calendar.YEAR));
if (String.valueOf((cal.get(java.util.Calendar.MONTH) + 1)).length() == 1) {
folder = folder + "\\0" + String.valueOf((cal.get(java.util.Calendar.MONTH) + 1));
} else {
folder = folder + "\\" + String.valueOf((cal.get(java.util.Calendar.MONTH) + 1));
}
folder = folder + "\\";
return folder;
}
/**
* Get the current date. format is YYYYMMDD
* @return String of YYYYMMDD
*/
private String getCurrYYYYMMDD() {
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd"); //yyyy/MM/dd HH:mm:ss
return formatter.format(new java.util.Date());
}
/**
* Output Exception message from this object
* @param msg
*/
private void writeException(String msg){
new Log(this.curWorkingDir).write(msg);
}
}
package com.iden.util;
import java.io.PrintWriter;
import java.io.StringWriter;
import java.io.Writer;
public class HandleException {
/**
* Return StackTrace information
* @param throwObj
* @return
*/
private static String getStackTrace(Throwable throwObj) {
final Writer result = new StringWriter();
final PrintWriter printWriter = new PrintWriter(result);
throwObj.printStackTrace(printWriter);
return result.toString();
}
/**
* Return custom StackTrace information
* @param throwObj
* @return
*/
private static String getCuctomStackTrace(Throwable throwObj) {
final StringBuilder result = new StringBuilder("HandleException.getCuctomStackTrace(): ");
result.append(throwObj.toString());
final String NEW_LINE = System.getProperty("line.separator");
result.append(NEW_LINE);
for (StackTraceElement element : throwObj.getStackTrace()) {
result.append(element);
result.append(NEW_LINE);
}
return result.toString();
}
public static void main(String[] args){
try{
throw new NullPointerException("Iden test");
//throw new AlreadyBoundException("Iden test");
}catch(Exception e){
if(e instanceof java.lang.NullPointerException){
System.out.println(getStackTrace(e));
System.out.println(getCuctomStackTrace(e));
}
}
}
}
package com.iden.resource;
import java.util.Properties;
public class PropertyLoader {
private Properties prop = null;
private Boolean isSet;
PropertyLoader() {
prop = new Properties();
try {
prop.load(getClass().getResourceAsStream("/EIF.properties"));
} catch (Exception e) {
e.printStackTrace();
}
if (new String(
prop.getProperty("PropertyLoaderTest.isSet") != null ? prop
.getProperty("PropertyLoaderTest.isSet") : "").trim()
.equalsIgnoreCase("1"))
isSet = true;
else
isSet = false;
}
public static void main(String[] args){
PropertyLoader loader = new PropertyLoader();
System.out.println("PropertyLoaderTest.isSet=" + loader.isSet);
}
}
# 1 or 0 / 1:short data model: update data when start time, end time, shift time 0:every data update model PropertyLoaderTest.isSet=1
'TextBox limit character digits user input
Public Sub limitTextBoxDigits(ByRef obj As System.Windows.Forms.TextBox, ByVal digits As Integer)
obj.CharacterCasing = Windows.Forms.CharacterCasing.Upper
If obj.SelectedText <> "" Then
Dim selIdx As Integer = obj.SelectionStart
obj.Text = obj.Text.Remove(obj.SelectionStart, obj.SelectionLength)
obj.Select(selIdx, 1)
End If
If obj.Text.Length >= digits Then obj.Text = obj.Text.Remove(digits - 1, 1) : obj.Select(digits - 1, 1)
End Sub