Main Features of JDBC

Krantik Chavan
Updated on 30-Jul-2019 22:30:25

4K+ Views

Following are the new features of JDBC:Makes JDBC calls: While using JDBC Java applications can make JDBC calls these calls submit SQL statements to the driver which in turn accesses the data from the database.Portability: JDBC provides wide level portability.Using JDBC you can request any type of queries from the database.You can use JDBC with different Java applications such like Java Applets, Java Servlets, Java Server Pages (JSPs). Enterprise JavaBeans (EJBs). To communicate with database.JDBC provides support for advanced datatypes such as BLOB, CLOB etc.Using JDBC you can set save points for database and layer you can rollback to desired ... Read More

Get Current Wi-Fi MAC Address in Android

Nitya Raut
Updated on 30-Jul-2019 22:30:25

2K+ Views

This example demonstrate about How to get current Wi-Fi mac address in android.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 to res/layout/activity_main.xml. In the above code, we have taken text view to show WIFI mac address.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.net.wifi.WifiInfo; import android.net.wifi.WifiManager; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v7.app.AppCompatActivity; import android.widget.TextView; public class MainActivity extends AppCompatActivity { TextView textView; ... Read More

LocalDateTime getNano Method in Java

karthikeya Boyini
Updated on 30-Jul-2019 22:30:25

125 Views

The nanosecond of second for a particular LocalDateTime can be obtained using the getNano() method in the LocalDateTime class in Java. This method requires no parameters and it returns the nanosecond of second in the range of 0 to 999, 999, 999.A program that demonstrates this is given as follows −Example Live Demoimport java.time.*; public class Demo {    public static void main(String[] args) {       LocalDateTime ldt = LocalDateTime.parse("2019-02-18T23:15:30.53");       System.out.println("The LocalDateTime is: " + ldt);       System.out.println("The nanosecond is: " + ldt.getNano());    } }OutputThe LocalDateTime is: 2019-02-18T23:15:30.530 The nanosecond is: 530000000Now let ... Read More

DoubleStream Builder Build Method in Java

George John
Updated on 30-Jul-2019 22:30:25

133 Views

The build() method of the DoubleStream.Builder class builds the stream. It transitions this builder to the built state.The syntax is as followsDoubleStream build()To use the DoubleStream.Builder class in Java, import the following packageimport java.util.stream.DoubleStream;The following is an example to implement DoubleStream.Builder build() method in Java:Example Live Demoimport java.util.stream.DoubleStream; public class Demo {    public static void main(String[] args) {       DoubleStream.Builder builder = DoubleStream.builder();       builder.add(34.5);       builder.add(87.1);       builder.add(35.6);       builder.add(66.1);       builder.add(36.8);       builder.add(77.4);       builder.add(88.2);       builder.add(68.9);       builder.build().forEach(System.out::println);    } }Output34.5 87.1 35.6 66.1 36.8 77.4 88.2 68.9

Connect to an SQLite Database Using a JDBC Program

Jennifer Nicholas
Updated on 30-Jul-2019 22:30:25

2K+ Views

A. SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. It is a database, which is zero-configured, which means like other databases you do not need to configure it in your system.SQLite engine is not a standalone process like other databases, you can link it statically or dynamically as per your requirement with your application. SQLite accesses its storage files directly.The URL to connect with SQLite database is jdbc:sqlite:test.db and, the driver class name to connect to it is org.sqlite.JDBC.Before you proceed with the example:Download latest version of sqlite-jdbc-(VERSION).jar from sqlite-jdbcrepository.Add downloaded jar file ... Read More

Use take() in Android PriorityBlockingQueue

Jennifer Nicholas
Updated on 30-Jul-2019 22:30:25

183 Views

Before getting into the example, we should know what PriorityBlockingQueue is. It is an unbounded queue and follows the same order as a priority queue. The main usage of priority blocking queue is, it going to handle out of memory error.This example demonstrates about How to use take() in android PriorityBlockingQueueStep 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 to res/layout/activity_main.xml.     In the above code, we have taken a text view to show PriorityBlockingQueue ... Read More

Insert Data from One MySQL Table to Another and Set Column Value

Nishtha Thakur
Updated on 30-Jul-2019 22:30:25

386 Views

Let us first create a table. Following is the query −mysql> create table insertOneToAnotherTable    -> (    -> Value int    -> ); Query OK, 0 rows affected (0.60 sec)Following is the query to insert some records in the table using insert command −mysql> insert into insertOneToAnotherTable values(100); Query OK, 1 row affected (0.08 sec) mysql> insert into insertOneToAnotherTable values(200); Query OK, 1 row affected (0.15 sec) mysql> insert into insertOneToAnotherTable values(300); Query OK, 1 row affected (0.13 sec) mysql> insert into insertOneToAnotherTable values(400); Query OK, 1 row affected (0.15 sec) mysql> insert into insertOneToAnotherTable ... Read More

C++ Struct vs Class

Smita Kapse
Updated on 30-Jul-2019 22:30:25

431 Views

In C++ the structure and class are basically same. But there are some minor differences. These differences are like below.The class members are private by default, but members of structures are public. Let us see these two codes to see the differences.Example#include using namespace std; class my_class {    int x = 10; }; int main() {    my_class my_ob;    cout

C++ Program to Implement Disjoint Set Data Structure

Smita Kapse
Updated on 30-Jul-2019 22:30:25

3K+ Views

Disjoint set is basically as group of sets where no item can be in more than one set. It supports union and find operation on subsets.Find(): It is used to find in which subset a particular element is in and returns the representative of that particular set.Union(): It merges two different subsets into a single subset and representative of one set becomes representative of other.Functions and pseudocodesBegin    Assume k is the element    makeset(k):       k.parent = k.    Find(x):    If k.parent == k       return k.    else    return Find(k.parent)    Union ... Read More

Sort Certain Values to the Top in MySQL

Samual Sam
Updated on 30-Jul-2019 22:30:25

266 Views

You need to use ORDER BY clause to sort. The syntax is as follows −SELECT *FROM yourTableName ORDER BY yourColumnName='yourValue' DESC, yourIdColumnName;To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table SortCertainValues    -> (    -> Id int NOT NULL AUTO_INCREMENT,    -> Name varchar(20),    -> CountryName varchar(10),    -> PRIMARY KEY(Id)    -> ); Query OK, 0 rows affected (1.36 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into SortCertainValues(Name, CountryName) values('Adam', 'US'); Query OK, 1 row ... Read More

Advertisements