Code Record

語法如下 String.format("%010d", 1234)

語法: UPDATE `tableA` SET `tableA`.code = (   SELECT `tableB`.code   FROM `tableB`   WHERE `tableA`.id = `tableB`.id ) 不懂可提問:) REF http://stackoverflow.com/questions/14618703/update-query-using-subquery-in-sql-server

需要在pom.xml裡面加上下面這段否則會無法執行     <build>         <plugins>             <plugin>                 <groupId>org.apache.maven.plugins</groupId>                 <artifactId>maven-jar-plugin</artifactId>                 <version>2.5</version>                 <configuration>                     <archive>                         <manifest>                             <addClasspath>true</addClasspath>                                 ...

本範例利用org.apache.commons.net.ftp.FTPClient做檔案上傳 程式不多說 看註解吧。 JAR download / maven Repository http://mvnrepository.com/artifact/commons-net/commons-net/3.3 code: package smple.ftpfile; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import org.apache.commons.net.ftp.FTPClient; import org.apache.commons.net.ftp.FTPReply; /**  *  * @author nani12a  */ public class FtpUpload {     static public FTPClient ftp = null;     //server path     static public String server = "XXX.XXX.XXX.XXX";     //account     static public String account = "account";     //password     static public String password = "password";     /**      *      * @param serverFoder FTP上傳路徑 ex.web/files      * @param filePath 檔案實體路徑 ex D:\\sample.xlsx      * @param fileName 檔案名稱 ...

僅供參考  $(document).get(0).oncontextmenu = function() {         return false;  };

         <!-- mysql JDBC driver -->         <dependency>             <groupId>mysql</groupId>             <artifactId>mysql-connector-java</artifactId>             <version>5.1.32</version>         </dependency>         <!-- mariadb JDBC driver -->         <dependency>             <groupId>org.mariadb.jdbc</groupId>             <artifactId>mariadb-java-client</artifactId>             <version>1.1.7</version>             <scope>provided</scope>         </dependency>         <!--JavaScript Object Notation...

參考: Proxool JAVA 初始化 網路上多用XML的設定方式 在此為使用java去使用connection pool Sample code: -------------------------------------------------------------------------------------------- package com.mycompany.test; import java.sql.DriverManager; import java.sql.SQLException; import java.util.Properties; import java.util.logging.Level; import java.util.logging.Logger; import org.logicalcobwebs.proxool.ProxoolException; import org.logicalcobwebs.proxool.ProxoolFacade; /**  * @version 1.0  * @author chou7658  *  */ public class Connection {     static java.sql.Connection con = null;     /**      * 類別初始化 將connection 在一開始載入類別時便建立相關的connection pool      */     static {         try {             Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");             Properties info =...