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
Wait state generation in 8085 Microprocessor
The memory and the peripheral chips present today are very fast for a 8085 processor working at 3 MHz of frequency. So we do not need wait states. If we use 8085AH-2 which works at 5 MHz frequency, there we need to insert one wait state, between T2 and T3.To D-type positive edge-triggered flip flops are used by the circuit with an active low Reset inputs. At the beginning of T1, the Address Latch Enable goes very high and causes Q1 to go high. Since Q1 and D2 are connected, D2 remains very high throughout T1. The positive edge of ...
Read MoreWhat are the disadvantages of ODBC drivers?
Beside its advantages, ODBC has several drawbacks. Following are the main drawbacks of ODBC.Keeps on changing: ODBC is provided by Microsoft and like other Microsoft products it keeps evolving and the companies using ODBC should keep up with it. In addition to this, you need to pay to use ODBC SDK 8 and later versions.Usage of JNI libraries: Though ODBC solves vendor dependency problems by providing common API to interact with all the databases, at the end of the day ODBC is also a native API therefore, you need to use JNI in your Java applications which is not suggestable.Uncertain: ...
Read MoreWhat is Parameterized Batch Update in JDBC? Explain with an example?
Grouping a set of INSERT or, UPDATE or, DELETE commands (those produce update count value) and execute them at once this mechanism is known as a batch update.If you pass quires with parameters using batch update it is known as a parameterized batch update.Generally, to perform batch updates you need to add all the required statements using the addBatch() method and execute them using the executeBatch() method as://Creating a Statement object Statement stmt = con.createStatement(); //Setting auto-commit false con.setAutoCommit(false); //Adding the statements to batch stmt.addBatch("INSERT INTO Sales VALUES ('KeyBoard', 'Amith', 'January', 1000, 'Hyderabad')"); stmt.addBatch("INSERT INTO Sales VALUES ('Earphones', 'SUMITH', 'March', ...
Read MoreIntStream mapToObj() method in Java
The mapToObj() method in the IntStream class returns an object-valued Stream consisting of the results of applying the given function to the elements of this stream.The syntax is as follows. StreammapToObj(IntFunction
Read MoreC++ Program to Construct Transitive Closure Using Warshall's Algorithm
If a directed graph is given, determine if a vertex j is reachable from another vertex i for all vertex pairs (i, j) in the given graph. Reachable mean that there is a path from vertex i to j. This reach-ability matrix is called transitive closure of a graph. Warshall algorithm is commonly used to find the Transitive Closure of a given graph G. Here is a C++ program to implement this algorithm.AlgorithmBegin 1.Take maximum number of nodes as input. 2.For Label the nodes as a, b, c ….. 3.To check if there any edge present between ...
Read MoreHow to insert rows into a ResultSet in JDBC?
You can retrieve the contents of a table as a ResultSet and, insert a new row to it directly. To do so, first of all, you need to make sure your ResultSet is updatable.The moveToInsertRow() method of the ResultSet interface navigates the cursor to the position where you need to insert the next record. Therefore, move the cursor to the appropriate position to insert a row using this method.The updateXXX() methods of the ResultSet interface allows you to insert/update values into the ResultSet object.Add values to the new row using these methods for example if you need to insert an ...
Read MoreHow to call a stored procedure that returns output parameters, using JDBC program?
A. Stored procedures are sub routines, segment of SQL statements which are stored in SQL catalog. All the applications that can access Relational databases (Java, Python, PHP etc.), can access stored procedures.Stored procedures contain IN and OUT parameters or both. They may return result sets in case you use SELECT statements. Stored procedures can return multiple result sets.You can call a stored procedure using the following syntax:CALL procedure_name (input_parameter1, input_parameter2, input_parameter3)JDBC provides a standard stored procedure SQL escape syntax using which you can procedures in all RDBMSsTo call a stored procedure using a JDBC program you need to:Register the driver: ...
Read MoreCan we GROUP BY one column and select all data in MySQL?
Yes, you can use group_concat() for this. Let us first create a table −mysql> create table groupByOneSelectAll -> ( -> StudentDetails varchar(100), -> StudentName varchar(100) -> ); Query OK, 0 rows affected (0.91 sec)Following is the query to insert some records in the table using insert command −mysql> insert into groupByOneSelectAll values('StudentFirstName', 'John'); Query OK, 1 row affected (0.14 sec) mysql> insert into groupByOneSelectAll values('StudentFirstName', 'Chris'); Query OK, 1 row affected (0.21 sec) mysql> insert into groupByOneSelectAll values('StudentFirstName', 'Robert'); Query OK, 1 row affected (0.65 sec) mysql> insert into groupByOneSelectAll values('StudentFirstName', 'Bob'); Query ...
Read MoreHow to get first N characters from a MySQL column?
Use SUBSTRING() to get first N characters from a MySQL column. Let us first create a table −mysql>create table DemoTable ( Information text ); Query OK, 0 rows affected (2.63 sec)Insert records in the table using insert command −mysql>insert into DemoTable values('MySQL is a structured query language'); Query OK, 1 row affected (0.13 sec)Following is the query to display all records from the table using select statement −mysql>select *from DemoTable;This will produce the following output −+--------------------------------------+ | Information | +--------------------------------------+ | MySQL is a structured query ...
Read MoreHow does the tech industry manipulate its customers?
Did you know all the articles you read about the reviews of a particular product: about its pros, cons, and ratings from some popular, so-called "authentic and genuine" tech blogs are actually, just paid ones?In fact, because of these people, the articles with the original product review are pushed to the very end of the priority line by the big tech companies, that can’t seem to get enough affirmation to their success. In some cases, there is no place left for constructive criticism. As you know, criticism also plays an important part in the improvement of technology and its impact on the consumer. ...
Read More