Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
Java program to add period to LocalDate
In this program, we will learn to add a specific period to a date using Java’s LocalDate class. By using Java's Period class, we can specify an amount of time (such as months and days) and then add this period to a LocalDate. The program demonstrates how to set a period and apply it to a given date to get a new, updated date. Steps to add Period to LocalDate Following are the steps to add Period to LocalDate − Import LocalDate and Period from java.time package to work with dates and periods. ...
Read MoreJava – MySQL connection with ipAddress
In this article, we will learn how to connect a Java application to a MySQL database hosted on a specific IP address. By specifying the IP address in the connection URL, we can directly connect to the database even if it’s on a different machine. We’ll use the DriverManager.getConnection() method to initiate the connection. Steps to connect a MySQL database via IP Address Following are the steps to connect a MySQL database via IP Address − Import Connection and DriverManager classes from the java.sql package to enable database connectivity. Create a String ...
Read MoreJava DatabaseMetaData supportsGroupBy() method with example
In this article, we will learn how to check whether a database supports the SQL GROUP BY clause using JDBC in Java. The GROUP BY clause is used to organize identical data into groups in SQL queries, typically following the WHERE clause and preceding the ORDER BY clause. With JDBC, we can determine whether the underlying database supports this clause using the supportsGroupBy() method of the DatabaseMetaData interface. Problem StatementGiven a MySQL database, write a Java program that connects to the database and checks if the database supports the SQL GROUP BY clause.Input Database connection URL, username, and ...
Read MoreJava DatabaseMetaData getMaxStatements() method with example.
In this article, we will learn how to retrieve the maximum number of open statements allowed by a database using the DatabaseMetaData interface in Java. The getMaxStatements() method of the DatabaseMetaData interface is used to find out the maximum number of open statements (objects) that the underlying database allows at one time. This method returns an integer value, representing the maximum number of statements that are allowed to be open at a time. If this value is 0 it indicates that there is no limit or, the limit is unknown. Problem StatementGiven a connection to a database, write a ...
Read MoreDifference between npm i and npm ci in Node.js
Dealing with Node.js, using npm (Node Package Manager), is important for creating and installing the necessary packages for the project. While most developers know what happens when running npm install or npm i, the npm ci often appears in discussions about continuous integration and continuous delivery pipelines alongside reproducible build processes. This article is about the distinction between "npm i" and "npm ci", the situations in which one should be used over the other, and how each is employed. What is npm i (or npm install)? The "npm i" is actually an abbreviation for npm install, which is the main ...
Read MoreJava DataBaseMetaData getMaxCatalogNameLength() method with example.
In this article, we will learn how to retrieve the maximum number of characters allowed in a catalog name using the getMaxCatalogNameLength() method in Java. This method belongs to the DatabaseMetaData interface, which provides comprehensive information about the database, including its structure and capabilities. The method is useful for understanding the limitations imposed by the underlying database in terms of catalog name length. Problem StatementGiven a connection to a database, write a Java program to retrieve and display the maximum number of characters that the database allows for catalog names using the getMaxCatalogNameLength() method.Input A MySQL database connection URL, ...
Read MoreDifference Between Generative AI and Machine Learning
The disciplines of Artificial Intelligence (AI) and Machine Learning (ML) have gained a lot of traction in recent times which has resulted in the discussions around them on which many times, the lines are thin. Out of the many sub-areas that comprise the field of AI, Generative AI, and Machine Learning can be distinctively recognized because of their functionalities and uses. For anyone working with technology, in the corporate world, or in academia, understanding the differences between the two is vital in all these fields. What is Machine Learning? Machine Learning is a subfield of AI where researchers and developers ...
Read MoreLength of longest balanced parentheses prefix using Java
In this article we will explore how we can find the length of longest balanced parentheses prefix using java , first we will understand the problem with some examples then we learn two different approaches to find it. Problem Statement Here, we will be given a string with parentheses and we need to find the length of balanced parentheses set from the string i.e. for every open parentheses "(" if there is a close parentheses ")", then we call it balanced. Prefix defines the first balanced set from the string, let the parenthesis set '(())()' we consider only '(())' Input ...
Read MoreHow to Convert JSON to CSV File in JavaScript?
JavaScript Object Notation or JSON is recognized widely for data interchange while exporting and importing modular result data is done through CSV (Comma-Separated Values). It is quite common to convert JSON to any other format for reporting purposes or to integrate with different systems. In this article, we will explore different ways to transform JSON data into CSV format in JavaScript, incorporating its code, examples, and clarifications of its principles. Understanding JSON and CSV Formats JSON: JSON represents data as an array of objects, with each object containing key-value pairs. ...
Read MoreHow to setup 404 page in react routing?
Creating a 404 page is essential for any website to handle cases where a URL does not exist or may have been modified. To set up a 404 page in React, we’ll create a component to display whenever a 404 error occurs. Here’s how you can set up a PageNotFound component in React with react-router-dom. Prerequisites NPM & Node.js React React Router Approach for Setting Up a 404 Page in React Routing Adding a 404 page is crucial for improving the user experience by ...
Read More