Posts
FOR %%? IN (file_to_be_queried) DO (
ECHO File Name Only : %%~n?
ECHO File Extension : %%~x?
ECHO Name in 8.3 notation : %%~sn?
ECHO File Attributes : %%~a?
ECHO Located on Drive : %%~d?
ECHO File Size : %%~z?
ECHO Last-Modified Date : %%~t?
ECHO Parent Folder : %%~dp?
ECHO Fully Qualified Path : %%~f?
ECHO FQP in 8.3 notation : %%~sf?
ECHO Location in the PATH : %%~dp$PATH:?
)
public class Parent {
public static String getClassName() {
return new Object() {
}.getClass().getEnclosingClass().getName();
}
public static void main(String[] args) {
System.out.println(getClassName());
}
}
import java.lang.reflect.InvocationHandler;
import java.lang.reflect.Method;
import java.lang.reflect.Proxy;
import java.util.Date;
public class MathObj implements IMath {
@Override
public double sum(Number... value) {
double sum = 0;
for (int i = 0; i < value.length; i++) {
System.out.print(value[i]);
if (i < value.length - 1)
System.out.print(" + ");
sum += value[i].doubleValue();
}
System.out.printf(" = %f%n", sum);
return sum;
}
public static void main(String[] args) throws ClassNotFoundException {
// 建立代理物件
Object deleagate = Proxy.newProxyInstance(
ObjectHandler.class.getClassLoader(),
new Class[] { IMath.class },
new ObjectHandler(new MathObj())
);
// 利用代理執行
double sum = ((IMath) deleagate).sum(1, 2, 3, 4, 5, 6, 7);
System.out.printf("Invoke result: %f%n", sum);
}
}
// 定義代理程式
class ObjectHandler implements InvocationHandler {
// 原始物件
Object o;
public ObjectHandler(Object o) {
this.o = o;
}
@Override
public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
// 委派代理呼叫方法時, 要處理的動作
System.out.println("Start at " + new Date());
Object result = method.invoke(o, args);
System.out.println("End at " + new Date());
return result;
}
}
// 定義介面
interface IMath {
double sum(Number... value);
}
@echo off
SET file=mes.log
SET filename=mes
for /f %%a in ('dir /b /a-d %file%') do (
if %%~na==%filename% GOTO :FileFound
)
GOTO :FileNotFound
:FileFound
ECHO FILE FOUND
GOTO :BatchEnd
:FileNotFound
ECHO FILE NOT FOUND
:BatchEnd
ECHO END
DECLARE and SET Varibales
DECLARE @Mojo int SET @Mojo = 1 SELECT @Mojo = Column FROM Table WHERE id=1IF / ELSE IF / ELSE Statement IF @Mojo < 1
BEGIN
PRINT 'Mojo Is less than 1'
END
ELSE IF @Mojo = 1
BEGIN
PRINT 'Mojo Is 1'
END
ELSE
BEGIN
PRINT 'Mojo greater than 1'
END
CASE Statement
SELECT Day = CASE WHEN (DateAdded IS NULL) THEN 'Unknown' WHEN (DateDiff(day, DateAdded, getdate()) = 0) THEN 'Today' WHEN (DateDiff(day, DateAdded, getdate()) = 1) THEN 'Yesterday' WHEN (DateDiff(day, DateAdded, getdate()) = -1) THEN 'Tomorrow' ELSE DATENAME(dw , DateAdded) END FROM TableAdd A Column ALTER TABLE YourTableName ADD [ColumnName] [int] NULL;Rename a Column EXEC sp_rename 'TableName.OldColName', 'NewColName','COLUMN';Rename a Table EXEC sp_rename 'OldTableName', 'NewTableName';Add a Foreign Key ALTER TABLE Products WITH CHECK ADD CONSTRAINT [FK_Prod_Man] FOREIGN KEY(ManufacturerID) REFERENCES Manufacturers (ID);Add a NULL Constraint ALTER TABLE TableName ALTER COLUMN ColumnName int NOT NULL;Set Default Value for Column ALTER TABLE TableName ADD CONSTRAINT DF_TableName_ColumnName DEFAULT 0 FOR ColumnName;Create an Index CREATE INDEX IX_Index_Name ON Table(Columns)Check Constraint ALTER TABLE TableName ADD CONSTRAINT CK_CheckName CHECK (ColumnValue > 1)DROP a Column ALTER TABLE TableName DROP COLUMN ColumnName; |
Single Line Comments
SET @mojo = 1 --THIS IS A COMMENTMulti-Line Comments /* This is a comment that can span multiple lines */Try / Catch Statements BEGIN TRY -- try / catch requires SQLServer 2005 -- run your code here END TRY BEGIN CATCH PRINT 'Error Number: ' + str(error_number()) PRINT 'Line Number: ' + str(error_line()) PRINT error_message() -- handle error condition END CATCHWhile Loop DECLARE @i int SET @i = 0 WHILE (@i < 10) BEGIN SET @i = @i + 1 PRINT @i IF (@i >= 10) BREAK ELSE CONTINUE ENDCREATE a Table CREATE TABLE TheNameOfYourTable ( ID INT NOT NULL IDENTITY(1,1), DateAdded DATETIME DEFAULT(getdate()) NOT NULL, Description VARCHAR(100) NULL, IsGood BIT DEFAULT(0) NOT NULL, TotalPrice MONEY NOT NULL, CategoryID int NOT NULL REFERENCES Categories(ID), PRIMARY KEY (ID) );User Defined Function CREATE FUNCTION dbo.DoStuff(@ID int) RETURNS int AS BEGIN DECLARE @result int IF @ID = 0 BEGIN RETURN 0 END SELECT @result = COUNT(*) FROM table WHERE ID = @ID RETURN @result END GO SELECT dbo.DoStuff(0) |
ConversionPattern參數的格式含義
格式名 含義
%c 輸出日誌資訊所屬的類的全名
%d 輸出日誌時間點的日期或時間，默認格式為ISO8601，也可以在其後指定格式，比如：%d{yyy-MM-dd HH:mm:ss }，輸出類似：2002-10-18- 22：10：28
%f 輸出日誌資訊所屬的類的類名
%l 輸出日誌事件的發生位置，即輸出日誌資訊的語句處於它所在的類的第幾行
%m 輸出代碼中指定的資訊，如log(message)中的message
%n 輸出一個回車換行符，Windows平臺為“rn”，Unix平臺為“n”
%p 輸出優先順序，即DEBUG，INFO，WARN，ERROR，FATAL。如果是調用debug()輸出的，則為DEBUG，依此類推
%r 輸出自應用啟動到輸出該日誌資訊所耗費的毫秒數
%t 輸出產生該日誌事件的線程名
Level : OFF、FATAL、ERROR、WARN、INFO、DEBUG、ALL
Class.forName(jdbc_driver);
Properties prop = new Properties();
prop.setProperty("user", user);
prop.setProperty("password", password);
// 解決使用 ojdbc14.jar 連某些版本的資料庫，若使用 getObject() 來取得 DATE TYPE 欄位資料時，會有取不到時間的問題
prop.setProperty("oracle.jdbc.V8Compatible", "true");
Connection conn = DriverManager.getConnection(url, prop);
import java.io.File;
import java.io.UnsupportedEncodingException;
import java.util.Date;
import java.util.Properties;
import javax.activation.DataHandler;
import javax.activation.FileDataSource;
import javax.mail.Message;
import javax.mail.MessagingException;
import javax.mail.PasswordAuthentication;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeBodyPart;
import javax.mail.internet.MimeMessage;
import javax.mail.internet.MimeMultipart;
import javax.mail.internet.MimeUtility;
public class JavaMailSample {
static String smtpHost = "smtp.bruce.com.tw";
static int smtpPort = 25;
static String[] from = new String[] { "bruce@bruce.com.tw", "Bruce Tasi" };
static String to = "nanashi@bruce.com.tw";
static String account = "account";
static String password = "password";
static String subject = "信件主旨";
static String contentType = "text/html;charset=utf-8";
static String body = "<html><body><h1 style=\"color:blue;\">Mail test</h1><img src=\"cid:image01\" /></body></html>";
static Message getMessage(Session session) throws MessagingException, UnsupportedEncodingException {
Message msg = new MimeMessage(session);
// 寄件者
msg.setFrom(new InternetAddress(from[0], from[1]));
// msg.setFrom(new InternetAddress(String.format("\"%s\"<%s>", from[1], from[0])));
// 收件者
InternetAddress[] address = InternetAddress.parse(to, false);
msg.setRecipients(Message.RecipientType.TO, address);
// 主旨 (需編碼)
msg.setSubject(MimeUtility.encodeText(subject, "utf-8", "B"));
// 寄件時間
msg.setSentDate(new Date());
// 附件
File file = new File("write.png");
if (file.exists()) {
// 內文
MimeBodyPart contentBody = new MimeBodyPart();
// 內容與格式
contentBody.setContent(body, contentType);
// 附件
MimeBodyPart attachment = new MimeBodyPart();
FileDataSource fds = new FileDataSource(file.getName());
attachment.setDataHandler(new DataHandler(fds));
// 附件名稱 (需編碼)
attachment.setFileName(MimeUtility.encodeText(fds.getName(), "utf-8", "B"));
// 附件代號, 用於顯示郵件內文
attachment.setHeader("Content-ID", "<image01>");
// 組成郵件
MimeMultipart mp = new MimeMultipart();
// 內容顯示附件圖片時, 必須設定為related
mp.setSubType("related");
mp.addBodyPart(contentBody);
mp.addBodyPart(attachment);
msg.setContent(mp);
} else {
// 若沒有檔案時，就直接存郵件內容
msg.setContent(body, contentType);
}
return msg;
}
static void sendMail1() throws MessagingException, UnsupportedEncodingException {
// 建立工作階段
Session session = Session.getDefaultInstance(new Properties(), null);
// 開啟除錯模式
session.setDebug(true);
Message msg = getMessage(session);
Transport transport = session.getTransport("smtp");
transport.connect(smtpHost, smtpPort, account, password);
transport.sendMessage(msg, msg.getAllRecipients());
transport.close();
}
static void sendMail2() throws UnsupportedEncodingException, MessagingException {
Properties props = new Properties();
props.put("mail.smtp.host", smtpHost);
props.put("mail.smtp.port", smtpPort);
props.put("mail.smtp.auth", "true");
// props.put("mail.smtp.socketFactory.port", smtpPort);
// props.put("mail.smtp.socketFactory.class", "javax.net.ssl.SSLSocketFactory");
Session session = Session.getDefaultInstance(props, new javax.mail.Authenticator() {
protected PasswordAuthentication getPasswordAuthentication() {
return new PasswordAuthentication(account, password);
}
});
session.setDebug(true);
Message msg = getMessage(session);
Transport.send(msg);
}
}
JavaMail
import java.io.FileInputStream;
import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.net.URL;
import java.net.URLClassLoader;
import java.util.jar.JarEntry;
import java.util.jar.JarInputStream;
public class ClassLoaderSample {
public static void main(String[] args) throws Exception {
String jarFile = "C:/workspace/bruce.lib/Blib.jar";
URLClassLoader dynamicLoader = URLClassLoader.newInstance(new URL[] { new URL("file", null, jarFile) }, ClassLoaderTest.class.getClassLoader());
// List content
JarInputStream jis = new JarInputStream(new FileInputStream(jarFile));
JarEntry entry = null;
while ((entry = jis.getNextJarEntry()) != null) {
String name = entry.getName();
System.out.println(name);
}
System.out.println("=====");
// Inovke method
Class objClass = Class.forName("aaa.bbb.PrintTable", true, dynamicLoader);
Object obj = objClass.newInstance();
Method objMethod = objClass.getDeclaredMethod("print");
objMethod.invoke(obj);
// Field value
Field objField = objClass.getDeclaredField("tableName");
System.out.println(objField.get(obj));
// Change field value
objField.set(obj, "myTable");
}
}