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 Ankith Reddy
Page 55 of 73
8085 program to find bit differences between two binary patterns.
Here we will see how to find the bit differences of two binary patterns using 8085.Problem StatementTwo binary patterns are stored in locations 8030H and 8031H. Load them in registers A and B. Find out the bit positions where bits are differing and put these location numbers at locations starting from 8050H on words. (Bits are differing at those locations where 0 in A and 1 in B)DiscussionTo solve this problem, we are taking the numbers into A and B. Then initialize the C as counter with 08H, and the register L will keep tract the bit position, where A ...
Read MoreOrder By date ASC in MySQL?
You can use STR_TO_DATE() function. Let us first create a table −mysql> create table DemoTable ( AdmissionDate varchar(200) ); Query OK, 0 rows affected (1.19 sec)Insert records in the table using insert command −mysql> insert into DemoTable values('12-01-2019'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('14-12-2016'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('26-04-2018'); Query OK, 1 row affected (0.34 sec) mysql> insert into DemoTable values('31-05-2013'); Query OK, 1 row affected (0.30 sec)Display all records from the table using select statement −mysql> select * from DemoTable;This will produce the ...
Read MoreHow to disable only the horizontal scrollbar in Java?
To disable only the horizontal scrollbar in Java, use the JScrollPane.HORIZONTAL_SCROLLBAR_NEVER. Let’s say you created a Box with some button components. Now, create a JScrollPane −JScrollPane scrollPane = new JScrollPane();Set the Viewport view as Box −scrollPane.setViewportView(box);Now, disable the horizontal scrollbar −scrollPane.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_NEVER);The following is an example to disable only the horizontal scrollbar −Examplepackage my; import java.awt.BorderLayout; import java.awt.Dimension; import javax.swing.Box; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JScrollPane; public class SwingDemo { public static void main(String args[]) { JFrame frame = new JFrame("Demo"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); JButton button1 = new JButton("Tutorials"); JButton ...
Read MoreOrder by selected record in MySQL?
You can use a CASE statement for this. Let us first create a table −mysql> create table DemoTable ( Number int ); Query OK, 0 rows affected (0.71 sec)Insert records in the table using insert command −mysql> insert into DemoTable values(490); Query OK, 1 row affected (0.35 sec) mysql> insert into DemoTable values(310); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(540); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(123); Query OK, 1 row affected (0.60 sec) mysql> insert into DemoTable values(1230); Query OK, 1 row affected (0.15 sec) mysql> ...
Read More8085 program to perform ON/OFF desired output LEDs connected at the output port B.
Here we will see how to interface PORT IC with 8085.Problem StatementON/OFF desired output LEDs connected at the output port B.DiscussionHere we will see how to On/Off LEDs at port B. We are using 8255 IC for ports. The J1 and J2 connectors to connect the 8085 and 8255. The connector pin descriptions are given below. For controlling pin, we have to set the control word, that will be used in the program.Pin no. on J1/J28255 PinFunction113PC4212PC5316PC2417PC3514PC0615PC1724PB6825PB7922PB41023PB51120PB21221PB31318PB01419PB11538PA61637PA71740PA41839PA5192PA2201PA3214PA0223PA12311PC62410PC72526+5V267GND Group A and B will operate in mode 0.Using port A as input port and port B as output port. The operation mode of ...
Read MoreGet MAX and MIN values along with their row id in MySQL?
You can use aggregate function MAX() and MIN() for this.Let us first create a table −mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Number1 int, Number2 int ); Query OK, 0 rows affected (0.89 sec)Insert records in the table using insert command −mysql> insert into DemoTable(Number1, Number2) values(67, 45); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable(Number1, Number2) values(90, 40); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable(Number1, Number2) values(80, 43); Query OK, 1 row affected (0.48 sec)Display all records from the table using select ...
Read More8085 program to unpack 16-bit BCD, and store consecutive locations
Here we will see we can take 16-bit BCD data from memory and unpack it, then store into memory using 8085.Problem StatementWrite 8085 program to take 16-bit BCD number from memory then store each digit by unpacking into different locations.DiscussionTo solve this problem, we will create one subroutine, that can unpack 1-byte BCD number and store into memory, then we will use that subroutine for two times to store 16-bit data. The subroutine will cut the numbers by masking upper nibble and lower nibble, and store into memory.Input1234 in the DE register pairFlow Diagram ProgramAddressHEX CodesLabelsMnemonicsCommentsF00031, 00, FC LXI SP, FC00Initialize stack ...
Read More8085 program to take all numbers whose D7 and D1 are 0
Here we will see how we can take all numbers whose D7 and D1 bits are 0, using 8085.Problem StatementWrite 8085 program to take all numbers from an array whose D7 and D1 bits are 0. Numbers are stored from 8001, and the array size is stored at 8000. Store the result from 9000 onwards.DiscussionTo solve this problem, we will AND the number by 82H (1000 0010). If the result is 0, then the number is acceptable. If the bit position D7 and D1 are 0, then only the result will be 0.InputAddressData……80000A8001E98002D38003618004AD80052A80061F80075D8008A68009A9800A35…… Flow Diagram ProgramAddressHEX CodesLabelsMnemonicsCommentsF00021, 00, 80 LXI H, 8000Load the ...
Read MoreGet distinct values and count them in MySQL
To get distinct values and count them, you can use GROUP BY clause.The syntax is as followsselect yourColumnName, count(*) as anyAliasName from yourTableName group by yourColumnName;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table GroupByAndCountDemo -> ( -> ClientId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> ClientName varchar(100) -> ); Query OK, 0 rows affected (0.64 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into GroupByAndCountDemo(ClientName) values('John'); Query OK, 1 row affected (0.18 sec) mysql> insert ...
Read MoreHow to convert HASHMAP to JSON using GSON in Android?
GSON is java library, It is used to convert OBJECT to JSON and JSON to Object. Internally it going to work based on serialization and deserialization.This example demonstrates how to convert HASHAMP to JSON using GSON library.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code in build.gradle.apply plugin: 'com.android.application' android { compileSdkVersion 28 defaultConfig { applicationId "com.example.andy.myapplication" minSdkVersion 15 targetSdkVersion 28 versionCode ...
Read More