SELECT NAME FROM sys.tables WHERE NAME LIKE '%arap%'
SELECT t.NAME AS 'TableName', c.NAME AS 'ColumnName' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.NAME LIKE '%apply%' ORDER BY t.NAME, c.NAME;
package albert.practice.designPattern.builder; public class User { private String firstName; private String lastName; private String email; public String getFirstName() { return firstName; } public String getLastName() { return lastName; } public String getEmail() { return email; } private User(UserBuilder builder) { this.firstName = builder.firstName; this.lastName = builder.lastName; this.email = builder.email; } @Override public String toString() { return "User [firstName=" + firstName + ", lastName=" + lastName + ", email=" + email + "]"; } public static class UserBuilder { private String firstName; private String lastName; private String email; public UserBuilder firstName(String firstName) { this.firstName = firstName; return this; } public UserBuilder lastName(String lastName) { this.lastName = lastName; return this; } public UserBuilder email(String email) { this.email = email; return this; } public User build() { User user = new User(this); return user; } } }
package albert.practice.designPattern.builder; import lombok.Builder; import lombok.Getter; import lombok.ToString; /* * The @Builder annotation produces complex builder APIs for your classes. * @Builder lets you automatically produce the code required to have your class be instantiable with code such as: * Person.builder().name("Adam Savage").city("San Francisco").job("Mythbusters").job("Unchained Reaction").build(); */ @Builder @Getter @ToString public class User2 { private String firstName; private String lastName; private String email; }
package albert.practice.designPattern.builder; import static org.junit.Assert.assertNotNull; import org.junit.Test; import lombok.extern.slf4j.Slf4j; @Slf4j public class UserTest { @Test public void testUser() { User user = new User.UserBuilder().firstName("Albert").lastName("Kuo") .email("test@gmail.com").build(); log.debug("user = " + user.toString()); assertNotNull(user); } @Test public void testUser2() { User2 user2 = new User2.User2Builder().firstName("Albert").lastName("Kuo") .email("test@gmail.com").build(); log.debug("user2 = " + user2.toString()); assertNotNull(user2); } }
<dependencies> <!-- lombok --> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.16.8</version> <scope>provided</scope> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>1.7.21</version> </dependency> <!-- logback --> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-core</artifactId> <version>1.1.7</version> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-classic</artifactId> <version>1.1.7</version> </dependency> </dependencies>
1 2 3 4 5 | <dependency> <groupId>commons-io</groupId> <artifactId>commons-io</artifactId> <version>2.5</version> </dependency> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | /** * 找出某個日期以前的檔案. * * @param directory 找出某個目錄下的檔案 * @param days 找出數天前 (如 -20) * @param includeSubdir 是否包含子目錄 (true / false) * @return List of File */ public static List<File> getFilesBeforeXDays(File directory, int days, Boolean includeSubdir) { Calendar cal = Calendar.getInstance(); cal.setTime(new Date()); cal.add(Calendar.DATE, days); cal.set(Calendar.HOUR, 0); cal.set(Calendar.MINUTE, 0); cal.set(Calendar.SECOND, 0); cal.set(Calendar.MILLISECOND, 0); cal.set(Calendar.HOUR_OF_DAY, 0); Date date = cal.getTime(); IOFileFilter ageFileFilter = FileFilterUtils.ageFileFilter(date); IOFileFilter subDirFilter = includeSubdir ? FileFilterUtils.trueFileFilter() : FileFilterUtils.falseFileFilter(); Collection<File> fileCollection = org.apache.commons.io.FileUtils.listFiles(directory, ageFileFilter, subDirFilter); if(CollectionUtils.isEmpty(fileCollection)){ log.info("Cannot find any log files before " + new SimpleDateFormat("yyyy/MM/dd HH:mm:ss.SSS").format(date)); } else{ log.info("Find " + fileCollection.size() + " log file(s)."); } return new ArrayList<File>(fileCollection); } |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 | package albert.practice.http; import java.io.IOException; import org.apache.commons.httpclient.DefaultHttpMethodRetryHandler; import org.apache.commons.httpclient.HostConfiguration; import org.apache.commons.httpclient.HttpClient; import org.apache.commons.httpclient.HttpStatus; import org.apache.commons.httpclient.methods.GetMethod; import org.apache.commons.httpclient.params.HttpMethodParams; import org.apache.commons.io.IOUtils; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import com.google.common.base.Charsets; import com.google.common.base.Strings; public class HttpSmsClient { private final static Logger logger = LoggerFactory.getLogger(HttpSmsClient.class); public static String getResponse(String url) throws IOException { String responseString = ""; HttpClient client = new HttpClient(); GetMethod method = new GetMethod(url); method.getParams().setParameter(HttpMethodParams.RETRY_HANDLER, new DefaultHttpMethodRetryHandler(3, false)); int statusCode; try { statusCode = client.executeMethod(method); if (HttpStatus.SC_OK == statusCode) { responseString = IOUtils.toString(method.getResponseBodyAsStream(), Charsets.UTF_8); } } catch (IOException e) { throw e; } finally { method.releaseConnection(); } logger.info("responseString = " + responseString); return responseString; } } |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | package albert.practice.http; import java.io.IOException; import org.apache.commons.httpclient.DefaultHttpMethodRetryHandler; import org.apache.commons.httpclient.HostConfiguration; import org.apache.commons.httpclient.HttpClient; import org.apache.commons.httpclient.HttpStatus; import org.apache.commons.httpclient.methods.GetMethod; import org.apache.commons.httpclient.params.HttpMethodParams; import org.apache.commons.io.IOUtils; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import com.google.common.base.Charsets; import com.google.common.base.Strings; public class HttpSmsClient { private final static Logger logger = LoggerFactory.getLogger(HttpSmsClient.class); public static String getResponse(String url, String proxy, String port) throws IOException { String responseString = ""; HttpClient client = new HttpClient(); HostConfiguration hostConfiguration = client.getHostConfiguration(); hostConfiguration.setProxy(proxy, Integer.valueOf(port)); client.setHostConfiguration(hostConfiguration); GetMethod method = new GetMethod(url); method.getParams().setParameter(HttpMethodParams.RETRY_HANDLER, new DefaultHttpMethodRetryHandler(3, false)); int statusCode; try { statusCode = client.executeMethod(method); if (HttpStatus.SC_OK == statusCode) { responseString = IOUtils.toString(method.getResponseBodyAsStream(), Charsets.UTF_8); } } catch (IOException e) { throw e; } finally { method.releaseConnection(); } logger.info("responseString = " + responseString); return responseString; } } |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <dependencies> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-classic</artifactId> <version>1.1.7</version> </dependency> <!-- https://mvnrepository.com/artifact/commons-httpclient/commons-httpclient --> <dependency> <groupId>commons-httpclient</groupId> <artifactId>commons-httpclient</artifactId> <version>3.1</version> </dependency> <!-- https://mvnrepository.com/artifact/commons-io/commons-io --> <dependency> <groupId>commons-io</groupId> <artifactId>commons-io</artifactId> <version>2.5</version> </dependency> <dependency> <groupId>com.google.guava</groupId> <artifactId>guava</artifactId> <version>20.0</version> </dependency> </dependencies> |
