Menu
Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.
See how to use this function in C# to discover how many more days are left in a given countdown. DateTime startDate = DateTime.Now;DateTime endDate = DateTime.Now.AddDays(-1);TimeSpan t = startDate
MySQL supports AUTO_INCREMENT column types where the value of a particular column can be auto incremented as, and when, the records are inserted. Many instances would need the last value
The query below uses TOP to select the TOP 3 students: TOPSELECT TOP 3 *FROM Students; The code below uses LIMIT to only show three records: SELECT StudentName, StudentPercentageFROM StudentsLIMIT
StringWriter is similar to StringBuffer, which can collect a host of string values and work with the data. We will explore writing a porting of a given string. Code sample:
In Java, we can divide two positive integers and round up as follows: int result = (x + y – 1) / y Example: (4/3 = 1.33 and we want
Please see below for an example of how to convert a date time to ISO 8601 format. string isoFormatDateString = dateTimeObject.ToUniversalTime().ToString(“s”) + “Z”;
MySQL has abundant functions that support a multitude of application needs. Here, we shall use some Calendar functionality to find in which week a given date belongs. Samples: Considering the
Repository queries can be executed asynchronously using @Async annotation. The result can be a Future, CompletableFuture and ListenableFuture. The method will return immediately upon invocation: @asyncFuture findByName(String name);@asyncCompletableFuture findByName(String name);@asyncListenableFuture
There are many instances in which you might repeatedly use some functionality. It would be handy if you were allowed to create a function that could be used as, and
Avoid prefixing your Stored Procedure names with sp_. SQL Server first checks in the master database even when the Schema name is provided.
Avoid prefixing your Stored Procedure names with sp_. SQL Server first checks in the master database even when the Schema name is provided. ? Visit the DevX Tip Bank ?
A proof of concept can be seen below: @GetMapping(“…”)public MappingJacksonValue fooMethod(…) throws JsonProcessingException { List foos = …; MappingJacksonValue wrapper = new MappingJacksonValue(fooa); … return wrapper;}
Symbolic links are a useful entity, with which you can introduce some kind of encapsulation. The Symbolic link can be created in a secure environment (ex: DMZ) where users can
Explore how to convert a string to a byte array. String stringToBeConverted = ” ? ” ;int stringLength = stringToBeConverted.Length;byte[] bytes = new byte[stringLength / 2];for (int counter = 0;
When we need access to a Hibernate Session, we have to unwrap it from the current EntityManager via the unwrap() method as follows: // Spring and Java EE EntityManager em
Avoid using NOT IN whilst comparing nullable columns. Use NOT EXISTS instead. When NOT IN is used in a query, SQL Server compares each result to null (even if no
Avoid using NOT IN whilst comparing nullable columns. Use NOT EXISTS instead. When NOT IN is used in a query, SQL Server compares each result to null (even if no
At times, when you want to compute the result of a mathematical formula, you can use MySQL to do the task. It is a great tool for this. Here are
See below for a short function that validates a given IP address: public static Boolean ValidateIP(string inputIP){var ipParts = inputIP.Split(‘.’);return Int32.Parse(ipParts [0]) < 256 &&Int32.Parse(ipParts [1]) < 256&Int32.Parse(ipParts [2]) <
Please understand that this USER named SRIDHAR is created without a password and is also dangerous. CREATE USER SRIDHAR Alternatively, you can use the code below to create with a
When a repository interface should not be instantiated at runtime, it should be marked with @NoRepositoryBean annotation as follows: @NoRepositoryBeaninterface BaseRepository extends Repository { // CRUD methods that will not
It is best to avoid using the * operator in your queries, use explicit column names instead. SQL Server scans through all column names and replaces the * operator with
It is best to avoid using the * operator in your queries, use explicit column names instead. SQL Server scans through all column names and replaces the * operator with
Here is how to split a concatenated string with a delimiter and remove empty entries. public static void Test() { string concatenatedString = “,ONE,,TWO,,,THREE,,”; char[] charSeparator = new char[] {‘,’};
NULL is a unique value. It represents a value that is not defined and that is not really equal to BLANK (”). While using it in queries, we need to
When you create a new HTML element, you may want to keep its reference and later add a few more properties to it in the script. Just store it in
First, add the following dependency to your project (Maven): com.fasterxml.jackson.datatype jackson-datatype-hibernate5 ${jackson.version} Further, add the following bean: @Beanpublic Module datatypeHibernateModule() { return new Hibernate5Module();}
In order to improve your queries’ performance, you should always include the owner or schema name of an object by including its prefix before an object. Otherwise, the SQL Server
In order to improve your queries’ performance, you should always include the owner or schema name of an object by including its prefix before an object. Otherwise, the SQL Server
Finding the MIME type of a file is useful when you want to perform certain actions. PS: I have placed a file named nature.jpg in the folder /home/sridhar before executing
