Java ResultSet afterLast() Method with Example

Arushi
Updated on 30-Jul-2019 22:30:26

1K+ Views

When we execute certain SQL queries (SELECT query in general) they return tabular data.The java.sql.ResultSet interface represents such tabular data returned by the SQL statements.i.e. the ResultSet object holds the tabular data returned by the methods that execute the statements which quires the database (executeQuery() method of the Statement interface in general).The ResultSet object has a cursor/pointer which points to the current row. Initially this cursor is positioned before first row.The afterLast() method of the ResultSet interface moves the pointer/cursor of the current ResultSet object to next position of the last row.rs.afterLast();Let us create a table with name MyPlayers in MySQL ... Read More

Display MySQL Data Type in a Separate Column

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

151 Views

You can use INFORMATION_SCHEMA.COLUMNS for this. Let us first create a table −mysql> create table DemoTable    (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    Name varchar(20)    ); Query OK, 0 rows affected (0.73 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(Name) values('Chris'); Query OK, 1 row affected (0.25 sec) mysql> insert into DemoTable(Name) values('Robert'); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable(Name) values('Sam'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following ... Read More

Can an Interface Extend Multiple Interfaces in Java

raja
Updated on 30-Jul-2019 22:30:26

9K+ Views

Yes, we can do it. An interface can extend multiple interfaces in Java.Example:interface A {    public void test();    public void test1(); } interface B {    public void test();    public void test2(); } interface C extends A,B {    public void test3(); } class D implements C {    public void test() {       System.out.println("Testing");    }    public void test1() {       System.out.println("Testing1");    }    public void test2() {       System.out.println("Testing2");    }    public void test3() {       System.out.println("Testing3");    } } public class Main {    public static void main(String[] args) {       D d=new D();       d.test();       d.test1();       d.test2();       d.test3();    }  }Output:Testing Testing1 Testing2 Testing3

Combine FlowLayout and BoxLayout in Java

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

661 Views

To combine both the layouts, here we have created two panels −Frame f = new JFrame("Combining Layouts"); JPanel panel1 = new JPanel(); JPanel panel2 = new JPanel();Now, set the layouts accordingly −panel1.setLayout(new BoxLayout(panel1, BoxLayout.Y_AXIS)); panel2.setLayout(new FlowLayout());Then after adding components to both the panels, add them to the frame −f.add(panel1, BorderLayout.WEST); f.add(panel2, BorderLayout.CENTER);Examplepackage my; import java.awt.BorderLayout; import java.awt.Color; import java.awt.FlowLayout; import javax.swing.BoxLayout; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JPanel; import javax.swing.JTextArea; public class SwingDemo {    public static void main(String[] args) {       JFrame f = new JFrame("Combining Layouts");       JPanel panel1 = new JPanel();       ... Read More

C++ Program to Implement Johnson's Algorithm

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

1K+ Views

Here we will see the Johnson’s Algorithm to find shortest path between two vertices. The graph is given here. The shortest path between the edges is like below. This program will take the number of vertices, number of edges, and the edges with their costs.Input − Vertices: 3Edges: 5Edge with costs −1 2 82 1 121 3 223 1 62 3 4Output − The distance matrix of the graph.081210046140AlgorithmjohnsonAlgorithm(cost)Input − The cost matrix of given Graph.Output − Matrix to for shortest path between any vertex to any vertex.Begin    Create another matrix ‘A’ same as cost matrix, if there is no ... Read More

Get Doc Strings in Python

Sri
Sri
Updated on 30-Jul-2019 22:30:26

367 Views

Doc strings is the documentation string which is string literal, and it occurs in the class, module, function or method definition, and it is written as a first statement.There are two types of a Doc strings:one-line Doc stringsmulti-line Doc stringsThese are mainly used in DataScience /Machine Learning Programming.one-line Doc stringsThis type of Doc strings fit  in one line. You can write them  either using single quotes( ' ...  ') or triple quotes ('''....''') . Example 1in the following program we are declaring a doc string with in a function, and printing its contents.def square(x): '''Returns argument x is squared.''' return x**x print (square.__doc__) ... Read More

Count Distinct Values in MySQL

Rama Giri
Updated on 30-Jul-2019 22:30:26

248 Views

Let us first create a table −mysql> create table DemoTable    -> (    -> Name varchar(100),    -> Code varchar(100)    -> ); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', '0001'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values('Robert', '0002'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values('Robert', '0003'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('Chris', '0001'); Query OK, 1 row affected (0.12 sec)Display all records from the table using ... Read More

HTML DOM Input Checkbox Autofocus Property

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

197 Views

The HTML DOM Input Checkbox autofocus property returns and modify the value of autofocus attribute of an input HTML element with type=”checkbox”.SyntaxFollowing is the syntax −1. Returning autofocusobject.autofocus2. Modifying autofocusobject.autofocus = true|falseExampleLet us see an example of autofocus property − Live Demo

HTML DOM Input DateTimeLocal StepUp Method

AmitDiwan
Updated on 30-Jul-2019 22:30:26

108 Views

The HTML DOM Input DatetimeLocal stepUp() method defines the number of minutes the datetimeLocal field should increase.SyntaxFollowing is the syntax −Calling stepUp method with a number, which by default is equal to 1inputDatetimeLocalObject.stepUp(number)ExampleLet us see an example of Input DatetimeLocal stepUp method − Live Demo Input DatetimeLocal stepUp()    form {       width:70%;       margin: 0 auto;       text-align: center;    }    * {       padding: 2px;       margin:5px;    }    input[type="button"] {       border-radius: 10px;    } Datetime-Local-stepUp( ... Read More

HTML DOM KeyboardEvent Object

AmitDiwan
Updated on 30-Jul-2019 22:30:26

133 Views

The HTML DOM KeyboardEvent Object represents an event when user presses a key on keyboard.PropertiesHere, “KeyboardEvent” can have the following properties and methods −Property/MethodDescriptionaltKeyIt returns whether the "ALT" key was pressed or notcharCodeIt returns the Unicode character code of the keycodeIt returns the code of the keyctrlKeyIt returns whether the "CTRL" key was pressed or notgetModifierState()It returns true if the specified key is activated and false if inactiveisComposingIt returns whether the state of the event is composing or notkeyIt returns the key value of the key represented by the eventkeyCodeIt returns the Unicode character code of the key that triggered ... Read More

Advertisements