Arushi has Published 199 Answers

Java DatabaseMetaData getDriverName() method with example

Arushi
Arushi
Published on 09-May-2019 15:01:06
The getDriverName() method of the DatabaseMetaData interface returns the name of the JDBC driver used.To get the name of the JDBC driver used to connect with the database.Make sure your database is up and running.Register the driver using the registerDriver() method of the DriverManager class. Pass an object of the ... Read More

Java DatabaseMetaData getDriverMinorVersion() method with example

Arushi
Arushi
Published on 09-May-2019 14:58:57
The getDriverMinorVersion() method of the DatabaseMetaData interface returns the minor version of the JDBC driver used.To get the minor version of the JDBC driver used to connect with the database −Make sure your database is up and running.Register the driver using the registerDriver() method of the DriverManager class. Pass an ... Read More

Java DatabaseMetaData getDefaultTransactionIsolation() method with example

Arushi
Arushi
Published on 09-May-2019 14:56:32
In a database system where more than one transaction is being executed simultaneously and in parallel, the property of isolation states that all the transactions will be carried out and executed as if it is the only transaction in the system. No transaction will affect the existence of any other ... Read More

Java DatabaseMetaData getColumns() method with example

Arushi
Arushi
Published on 09-May-2019 14:53:33
This method retrieves the description of the columns of a table. It accepts 4 parameters −catalog - A string parameter representing the name (or, name pattern) of the catalog (database in general) in which the table (that contains the columns of which you need to retrieve the description about) exists. ... Read More

Java DatabaseMetaData getDatabaseMajorVersion() method with example

Arushi
Arushi
Published on 09-May-2019 14:45:13
The getDatabaseMajorVersion() method of the DatabaseMetaData interface returns the major version of the underlying database in integer format.To get major version of the underlying database −Make sure your database is up and running.Register the driver using the registerDriver() method of the DriverManager class. Pass an object of the driver class ... Read More

How to reorder the columns of a table in JDBC?

Arushi
Arushi
Published on 09-May-2019 14:24:46
You can reorder the columns of a table in MySQL database using the ALTER TABLE command.SyntaxALTER TABLE table_name MODIFY column_name datatype AFTER another_columnAssume we have a table named dispatches_data in the database with 7 columns namely ProductName, CustomerName, DispatchDate, DeliveryTime, Price, Location and, ID with description as −//Retrieving the Time object ... Read More

Java sql.Date valueOf() method with example

Arushi
Arushi
Published on 09-May-2019 14:06:08
The valueOf() method of the java.sql.Date class accepts a String value representing a date in JDBC escape format (yyyy-mm-dd) and convertsthe given String value into Date object.Date date = Date.valueOf("date_string");ExampleLet us create a table with name dispatches in MySQL database using CREATE statement as follows −CREATE TABLE dispatches(    ProductName ... Read More

Java sql.Date setTime() method with example.

Arushi
Arushi
Published on 09-May-2019 14:00:30
The setTime() method of the java.util.Date class accepts a variable of long type, representing the number of milliseconds from the epoch time (January 1, 1970 00:00:00.000 GMT) to the required time, and sets the specified time value to the current Date object.//Setting time date.setTime(time_value_in_long);ExampleLet us create a table with name ... Read More

Python Container Datatypes

Arushi
Arushi
Published on 08-May-2019 17:47:35
Among Python’s built-in types, list, tuple and dict are known as container data types. The collection module provides some more specialized alternatives to built-in types by improvising them.CounterThe Counter class is subclassed from built-in dict class. Object of Count class is a key-value pair. Key is an element in sequence ... Read More

Common string operations in Python

Arushi
Arushi
Published on 08-May-2019 17:41:05
The string module in Python’s standard library provides following useful constants, classes and a helper function called capwords()Constantsascii_lettersThe concatenation of lowercase and uppercase constants.ascii_lowercaseThe lowercase letters 'abcdefghijklmnopqrstuvwxyz'ascii_uppercaseThe uppercase letters 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'digitsThe string '0123456789'.hexdigitsThe string '0123456789abcdefABCDEF'.octdigitsThe string '01234567'.punctuationString of ASCII characters which are considered punctuation characters.printableString of ASCII characters digits, ascii_letters, punctuation, ... Read More
Previous 1 2 3 4 5 6 7 8 ... 20 Next
Advertisements