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 by Srinivas Gorla
Page 3 of 5
How to find numbers in an array that are greater than, less than, or equal to a value in java?
You can find numbers in an array that are greater than, less than, or equal to a value as:Examplepublic class GreaterOrLess { public static void main(String args[]) { int value = 65; int[] myArray = {41, 52, 63, 74, 85, 96 }; System.out.println("Elements of the array that are equal to the given value are::"); for(int i = 0; i
Read MoreWhat is the lambda expression to convert array/List of String to array/List of Integers in java?
You can convert an array list of strings to an array list of integers as:Exampleimport java.util.ArrayList; import java.util.List; import java.util.stream.Collectors; public class LamdaExpressions { public static void main(String args[]) { ArrayList list = new ArrayList(); list.add("123"); list.add("223"); list.add("323"); list.add("334"); List listInteger = list.stream().map(s -> Integer.parseInt(s)).collect(Collectors.toList()); System.out.println(listInteger); } }Output[123, 223, 323, 334]
Read MoreWhat are the methods supported by W3C DOM?
The following are the method supported by W3C DOM −Sr.NoProperty & Description1createAttribute( name)Returns a newly-created Attr node with the specified name.Ex − document.createAttribute( name)2createComment( text)Creates and returns a new Comment node containing the specified text.Ex − document.createComment( text)3createDocumentFragment( )Creates and returns an empty DocumentFragment node.Ex − document.createDocumentFragment( )4createElement( tagName)Creates and returns a new Element node with the specified tag name.Ex − document.createElement( tagName)5createTextNode( text)Creates and returns a new Text node that contains the specified text.Ex − document.createTextNode( text)6getElementById( id)Returns the Element of this document that has the specified value for its id attribute, or null if no such Element exists ...
Read MoreHow Can MySQL GROUP BY clause behave like DISTINCT clause?
When we use the GROUP BY clause in the SELECT statement without using aggregate functions then it would behave like the DISTINCT clause. For example, we have the following table −mysql> Select * from testing; +------+---------+---------+ | id | fname | Lname | +------+---------+---------+ | 200 | Raman | Kumar | | 201 | Sahil | Bhalla | | 202 | Gaurav | NULL | | 203 | Aarav | NULL | | 204 | Harshit | Khurana | | 205 | Rahul | NULL | | 206 | ...
Read MoreIn MySQL, how we can get the total value by category in one output row?
With the help of the MySQL SUM() function, we can get the total value by category in one output row. For example in table ‘ratelist’ if we want to get the total value of category ‘price’ then we can use SUM() on price as follows −mysql> select SUM(price) as totalprice from ratelist; +------------+ | totalprice | +------------+ | 3237 | +------------+ 1 row in set (0.00 sec)The query above returns the total value of price in one output row.
Read MoreWhat happens if I will assign a value to a MySQL user variable using a statement that returns multiple rows?
In case, if we will assign a value to a user variable using a statement that returns multiple rows then the value from the last row would be saved in that user variable because user variables can save the only single value. Following the example, in which we are using data from table ‘Tender’, will exhibit it −Examplemysql> select * from Tender; +----+---------------+--------------+ | Sr | CompanyName | Tender_value | +----+---------------+--------------+ | 1 | Abc Corp. | 250.369003 | | 2 | Khaitan Corp. | 265.588989 | | 3 | Singla group. | 220.255997 ...
Read MoreIn MySQL, what is the difference between SERIAL and AUTO_INCREMENT?
In MySQL, both SERIAL and AUTO_INCREMENT are used to define a sequence as a default value for a field. But they are technically different from each other.The AUTO_INCREMENT attribute is supported by all numeric data types except for BIT and DECIMAL. There can only be one AUTO_INCREMENT field per table and the sequence generated by an AUTO_INCREMENT field in one table cannot be used in any other table. This attribute requires that a UNIQUE index exists on the field to ensure the sequence has no duplicates. The sequence would start by default from 1 and increment by 1 for every insert.Examplemysql> ...
Read MoreHow can we add FOREIGN KEY constraints to more than one fields of a MySQL table?
MySQL allows us to add a FOREIGN KEY constraint on more than one field in a table. The condition is that each Foreign Key in the child table must refer to the different parent table.ExampleSuppose we have a table ‘customer2’ which have a Primary Key constraint on the field ‘cust_unq_id’ as follows −mysql> describe customer2; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | cust_id | int(11) | YES | | NULL | | | First_name | ...
Read MoreIntegrate node.js with SAP HANA system
You can insert data into HANA database using node.js. You can also connect to SAP HANA database via JDBC driver.To connect via JDBC, you need to install JDBC driver ngdbc.jar. This driver is installed as part of SAP HANA client installation. Ngdbc.jar file is available at this location −C:\Program Files\sap\hdbclient\ on Windows platforms /usr/sap/hdbclient/ on Linux and UNIX platformsNext is to add ngdb.jar to the classpath and write a Java program to connect to a database and execute SQL command.jdbc:sap://myServer:30015/?autocommit=falseYou can also add one or more failover servers by adding additional hosts.ExampleFollowing is an example of connecting SAP HANA Server ...
Read MoreHow to build an ant file for a Java Eclipse project?
Follow the steps given below, to integrate Ant into Eclipse.Make sure that the build.xml is a part of your java project, and does not reside at a location that is external to the project.Enable Ant View by following Window > Show View > Other > Ant > Ant.Open Project Explorer, drag the build.xml into the Ant View.Your Ant view looks similar to –Clicking on the targets, build / clean / usage will run Ant with the target. Clicking "fax" will execute the default target - usage.The Ant Eclipse plugin also comes with a good editor for editing build.xml files. The ...
Read More