Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
In this program, we will connect to a MySQL database and insert a null value into a table using Java's JDBC API. We will use the PreparedStatement class along with the setNull() method to achieve this. After the value is inserted, you can check the table to see how the null value is reflected. Steps to insert null value into a MySQL database Following are the steps to insert null value into a MySQL database − Establish a connection to the MySQL database using the DriverManager.getConnection() method. Define the SQL query that ... Read More
In this article, we will understand how to interchange elements of first and last in a matrix across columns in Java. The matrix has a row and column arrangement of its elements. A matrix with m rows and n columns can be called as m × n matrix. Individual entries in the matrix are called elements and can be represented by a[i][j] which suggests that the element a is present in the ith row and jth column. Problem Statement Write a Java program to interchange elements of first and last in a matrix across columns. Input The matrix is defined as: ... Read More
A year has 12 months which are named January, February, March, April, May, June, July, August, September, October, November, December. These are the complete names of the months and there are multiple ways to represent them like short format, complete format, MM or 2 integers format. In this article, we are going to see how to display names of months of calendar year in short format with the help of Java. There are numerous ways to do so and are as follows − Using a String Array ... Read More
In this article, we will learn how to select all the items in a JList in Java. The program creates a simple graphical user interface with a list of sports. It uses the setSelectionInterval() method to select all items in the list. This ensures that from the first item to the last item in the list, everything is selected when the program runs. Problem Statement Write a Java program to select all the items in a JList. Below is the demonstration of the same − Input sports[]= {"Football", "Fencing", "Cricket", "Squash", "Hockey", "Rugby"} Output Steps to select all ... Read More
In recent years, deep learning has moved from research labs to the heart of mainstream business applications. It powers everything from personalized recommendations on Netflix to self-driving cars. However, just because it’s popular doesn’t mean it’s always the right choice for your project. Deciding when to use deep learning and when to consider other options is crucial for achieving both efficiency and success. This guide will help you determine whether deep learning is a good fit for your next project. W to choose Deep Learning for your project depends on many factors listed below: 1. The Nature of Your Data ... Read More
To group Pandas data frame, we use groupby(). To sort grouped data frames in ascending or descending order, use sort_values(). The size() method is used to get the data frame size. Steps Involved The steps included in sorting the panda's data frame by its group size are as follows. Importing the panda's library and Creating a Pandas dataframe. Grouping the columns by using the groupby() function and sorting the ... Read More
To calculate the length of a Linked list, we traverse the list, counting each node until we reach the end, where the next node is None. Suppose, we have a singly linked list, we have to find its length. The linked list has fields next and val. So, if the input is like [2 -> 4 -> 5 -> 7 -> 8 -> 9 -> 3], then the output will be 7. The two commonly used methods to find the length of a linked list are as follows - ... Read More
In Python, whenever we try to read or write files we don’t need to import any library as it’s handled natively. The open() function opens a file and returns a file object. The file objects contain methods and attributes which latter can be used to retrieve information or manipulate the file you opened. File Operations The file is a named location on the disk to store related information, as the file is having some name and location, it is stored in the hard disk. In Python, file operation is performed in the following order - ... Read More
When it is required to find the maximum element in a tuple list (i.e. list of tuples), the 'max' method and the 'operator. itemgetter()' method can be used. The itemgetter fetches a specific item from its operand. The 'max()' method gives the maximum value present in an iterable that is passed as an argument to it. Some of the common methods to find the maximum element in a tuple list are as follows. 'itemgetter()' function: Used for retrieving items from an iterable object such as a ... Read More
Depending on the flexibility and complexity required, we can split a string on multiple delimiters in several ways such as using Python's re.split() method, which is a combination of various string methods. Some of the commonly used approaches to split strings on multiple delimiters. str.replace() and str.split() re.split() Method translate() ... Read More