Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Setting a Column Value to Null To set a column value to NULL, use the SQL UPDATE statement, which allows modification of existing records in a table. The basic syntax for setting a column value to NULL is − Syntax UPDATE table_name SET column_name = NULL WHERE conditions; Where − table_name: Replace this with the name of the table you intend to update. column_name: Substitute this with the name of the column to be updated. NULL: Denotes the NULL value in SQL. ... Read More
Data architecture design consists of standards that have certain rules, policies, and data types to be collected, from where the data is collected, storage of data, arrangement of data, and then using that data for further analysis. Data plays a vital role in the successful execution of business strategy. Data architecture design It helps us to show how users view the data in the database. It describes the type of data structures used to manage data and make the processing easy. the concept of dbms depends on its architecture. It is divided into three models i.e. conceptual model, ... Read More
Sometimes there is a requirement to fill in a minimum number of characters in a form. This ensures that the user inputs the correct data into the input field. In this article, we will see how to set the Minlength validation in HTML. What is Minlength Validation? In HTML the minlength is an attribute of the input tag of the form element. It is set in the input field to ensure that the users enter at least a minimum number of characters in the form input field. For example, while setting a password for ... Read More
In Java, state of the immutable object can’t be modified after it is created but definitely reference other objects. They are very useful in multi-threading environment because multiple threads can’t change the state of the object so immutable objects are thread-safe. Immutable objects are very helpful to avoid temporal coupling and always have failure atomicity and also helpful in multiple threading. Why though? because no one can change the object right? So, it becomes thread-safe, it means it will not cause any unexpected issues when different parts of the program are trying to access that particular object. On the other ... Read More
In Java, both Applets and Servlets are the programs or applications that run in a Java environment. Applets are designed to provide interactive features that can be embedded into web pages and allow users to engage with content directly through their web browsers. On the other hand, Servlets operate on the server side, they handle requests and responses, which is most important for generating dynamic content in web applications. The main difference in both programs is that their processing is done in different environments. Difference between Applets and Servlets Some of the major differences between Applets and Servlets are as ... Read More
Java provides two ways to append strings and make them one. These two methods are namely the concat() method and + operator to join strings together, but there are some important differences between how they work. The concat() method is a bit more specific and limited, while the + operator is more flexible. So, even though they do the same thing, understanding how and when to use each one can help in writing more efficient or cleaner code in Java. Concat() Vs + operator The following are the important differences between the concat method and the + operator. ... Read More
In this program, we will create a tree structure using JTree and DefaultMutableTreeNode in Java to represent a hierarchical structure, such as a website. We will then use the getChildCount() method to retrieve and display the number of child nodes for specific nodes in the tree. The example focuses on nodes that are not root nodes and prints the count of child nodes for each. Let’s say we want the count of child nodes for node 1, which is not a root node − node1.getChildCount() Steps to get the count of child nodes of any node in JTree Following are ... Read More
In this article, we will subtract two integers and check if the result causes an overflow in Java. To check for Integer overflow, we need to check the Integer.MAX_VALUE with the subtracted integers result, Here, Integer.MAX_VALUE is the maximum value of an integer in Java. Let us see an example wherein integers are subtracted and if the result is more than Integer.MAX_VALUE, then an exception is thrown. Problem Statement Write a program in Java to subtract integers and check for overflow − Input val1 = 9898999val2 = 8784556 Output Value1: 9898999 Value2: 8784556 Subtraction Result: 1114443 Steps to subtract integers and check ... Read More
In this article, we will learn to remove path information from a filename returning only its file component using Java. The method fileCompinent() is used to remove the path information from a filename and return only its file component. This method requires a single parameter i.e. the file name and it returns the file component only of the file name. Problem Statement Write a program in Java to remove path information from a filename returning only its file component − Input "c:\JavaProgram\demo1.txt" The input is the file path. Output demo1.txt Steps to remove path information Following are the steps to remove ... Read More
In this program, we will demonstrate how to retrieve the parent directory of a file using the File class in Java. The name of the parent directory of the file or directory can be obtained using the method getParent() method using the java.io package. This method returns the parent directory path name string or null if there is no parent named. Steps to get the name of the parent directory Following are the steps to get the name of the parent directory − We will start by importing the java.io.File class. Create a ... Read More