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.
RandomAccessFile raf = new RandomAccessFile(f, ???r???);for (???) { raf.seek(pos); byte b = raf.readByte();} Despite its name, the java.io.RandomAccessFile class is not very convenient for accessing files in a random-access manner,
Cloning is the easiest way of copying a class. With this, however, you also have all properties being passed on to the cloned class, which probably is a security hassle.
Use the KeyPress event to check for the keys pressed. See below for an example: private void textFirstName_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e) { if ( !( char.IsLetter(e.KeyChar) ) ) { e.Handled
Collection.removeIf is a very powerful method that acts on a condition. In the code sample below, there is a list which has few elements in it and the condition is
Sometimes when doing a search for data between date ranges, some of the data is omitted because the search doesn’t include the whole last day’s values. Here is a small
These two selectors often confuse beginners. In CSS, the difference between them is that the class is represented by a dot “.”, while ID is represented by a hash “#”.
Angular’s ngPattern allows you to validate input using a pattern. See below for an easy example of how to validate an e-mail address using the ng-pattern.
Most of the time, you probably want to understand the flow to solve certain problems. Java provides an easy approach to knowing the current stack. Code snippet: public class DumpStack{
We use string.format to format the data written to the console using the console.write or console.writeline commands. However, it isn’t indented well to make it readable. C# allows you to
There are times that you need to access information from the previous row or next row from the current row. Here is a small trick that makes use of a
Private static final Log log = LogFactory.getLog(MyClass.class); It is a good idea to store the log instance in a static final variable, because: No problems with serializable classes Initialization cost
Java has an API called BigInteger and it is easily able to identify if the number under consideration is a prime number or not. Code snippet: import java.math.BigInteger;public class ProbablePrime{
Devart introduced a significant update of dbForge tools for MySQL with cutting-edge connectivity and compatibility options and a new, more secure than ever, activation procedure. Devart, a Czech software vendor of database tools and data connectivity solutions, has rolled out greatly improved, crisp and clean dbForge tools for MySQL after the recent grand update of dbForge Studio for MySQL. All the tools have been packed with the powerful connectivity and compatibility options which enable users to work with a greater number of databases and database engines. In addition, an activation mechanism has received an extreme makeover to ensure the maximum possible security and reliability of the tools. Here is a closer look at what???s new in dbForge tools for MySQL: 1) Connectivity and Compatibility. dbForge tools for MySQL now support the following  databases and cloud services:MariaDB 10.1MariaDB 10.2NDBCLUSTERGoogle Cloud PlatformAlibaba Cloud 2) Trial Product Activation. The new activation process that traditionally comes after a 30-day trial period is more secure and reliable than ever before. It protects users against potential piracy and ensures that they are using an authentic product that can be trusted with their business data. 3) New Look and Feel. Among other updates, Devart redesigned the interface of MySQL tools to give them a cleaner look and feel. 4) Other Improvements include Compliance with the Federal Information Processing Standard. Onwards to more tidbits about what’s been changed with this release, please visit the following History pages:dbForge Schema Compare for MySQLdbForge Data Compare for MySQLdbForge Data Generator for MySQLdbForge Query Builder for MySQL To see the full list of updates implemented in dbForge Studio for MySQL v.7.4, please visit: https://www.devart.com/dbforge/mysql/studio/. About DevartDevart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects. For additional information about Devart, visit https://www.devart.com/.
Often, we see ambiguity in accessing database objects as they exist in multiple databases and schemas. One easy way is to fully qualify the database objects, so that there is
You may want to know if your timezone supports Daylight Saving Time programmatically. This can be easily determined with the code below: Listing 1. Sample Code import java.util.TimeZone;public class DaylightSavingsTime{
You may need to check address fields (for example) for a NULL value or an empty string (the value looks null, but simply contains an empty string – which is
To embed interactive content, such as a sound, a movie or an swf file, into your site, you need to use this HTML tag. Upload the wav (or the desired
class SuperClass{ public static void main(String args) { //do Nothing }}class MyClass extends SuperClass{ public static void main(String args[]) { //do Nothing }}public class NewClass { public static void main(String
class SuperClass{ public static void main(String args) { //do Nothing }}class MyClass extends SuperClass{ public static void main(String args[]) { //do Nothing }}public class NewClass { public static void main(String
MySQL provides a function DATEDIFF?that takes two arguments, first date and the second date. The function computes the difference between them and returns a positive result if the first date
MySQL’s Show Tables?command lists out the tables in the current database. Just execute the command with no parameters. SHOW TABLES
Getting the inserted identity is quite easy in SQL. All you have to do is the following: SELECT IDENT_CURRENT(‘MyTable’)
String name = …String attribute = …String xml = “”+””+ name +””+”; Many beginners are tempted to create an XML file like the one listed above using String operations because
Memory leaks don’t have to be hard/scary/tedious problems to solve if you follow the three simple steps mentioned below: Step 1: Capture baseline heap dump You need to capture heap
Certain aspects of your code may want to perform certain activities in a loop and wait infinitely for a command. However, the “while(true)” command is an easier way to achieve
Devart introduced a significant update of dbForge Studio for MySQL with a bunch of new unique features, including support for Google Sheets, new schema comparison and synchronization engine, and much more. Devart, a Czech software vendor of database tools and data connectivity solutions, has released a significantly improved version of its universal MySQL and MariaDB GUI tool, dbForge Studio for MySQL v.7.4. The most outstanding and notable updates implemented in dbForge Studio for MySQL are:  1) Support for Google Sheets for easy migration of table data between MySQL tables and Google Spreadsheets. The feature is incorporated into handy Data Export / Import Wizard, and the only thing users should do now is to specify the URL/ID of a Google Spreadsheets table. 2) Improved SQL document management with Execution notifications and Transaction Reminder as well as highlighting of the current code line. 3) Enhanced Code Completion with dozens of new variables and functions supported (Percona Server variables, MySQL Server variables, variables for MariaDB Server, etc.) 4) Both, schema/data comparison and synchronization wizards feature a new progress window with the list of processes taking place and specification of time elapsed. A brand new schema comparison and synchronization engine is implemented as well. 5) Now, dbForge Studio for MySQL allows copying databases seamlessly through the command-line interface and alerts users about the result of database copying. dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database administration, development, and management. The IDE allows you to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface, and much more. To see the full list of updates implemented in dbForge Studio for MySQL v.7.4, please visit: https://www.devart.com/dbforge/mysql/studio/. About DevartDevart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.For additional information about Devart, visit https://www.devart.com/.
STATISTICS IO?and STATISTICS TIME?show the amount of time spent on a query and the reads and writes of the query in question. This is good to know for quick performance
This method creates a PDF file and returns the binary PDF data as a byte array. This particular line of code supposes that the resulting file is small and fits
The System.Web.HttpBroswerCapabilities?has an important property called “Crawler” that enables us to handle requests from crawlers. Please check out the example below: Var isCrawler = ((System.Web.Configuration.HttpCapabilitiesBase)Request.Browser).Crawler;
Connecting to a MySQL database from the command prompt can be very easy: [root@mypc]#mysql -S /opt/db/mysql//mysql.sock -uroot -prootPassword Here, we are trying to connect to the MySQL database Installed in
