How to display mysql database records as per clock timing?

How to display mysql database records as per clock timing?

I want to display database records as per clock timing.

View Answers

April 28, 2012 at 3:28 PM

import java.sql.*;

class RetrieveData 
{
    public static void main(String[] args) throws Exception
    {
                Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root" );
        Statement st=conn.createStatement();
        ResultSet rs=st.executeQuery("select * from data");

        while(rs.next()){
            String name=rs.getString("name");
            String address=rs.getString("address");
            String contact=rs.getString("contactNo");
            String email=rs.getString("email");

            System.out.println(name+" \t "+address+" \t "+contact+" \t "+email);
            Thread.sleep(2000);
        }
    }
}









Related Tutorials/Questions & Answers:
How to display mysql database records as per clock timing?
how to display records from database
Advertisements
display 10 records per page in jsp - JSP-Servlet
how to display image and text in single jsp page from the mysql database
retrieving newly added records from mssql database and display in a jsp
how to write a query for adding records in database
How to display data fom MySQL DataBase-table in to JSP file by submitting a value in combobox.
How to display all the Select values from the MySQL database table in where condition= In JSP?
display 1000 of records - Struts
image is display from path of mysql database
how to display data from database in jsp
MySql Databse query to fetch results from database and display it in HTML File
large nuber of records display to jsp - Development process
displaying List of records from database in a jsp using ajax, onclick it should display the results ?? its urgent can u help me
Display PHP clock with user input date and time
how to display the database values in pdf format
How to retrieve and display image from database in Java?
display database results
how to display a table from database using servlet
How to use next and previous button(or href) for database table that is retrieved from MySQL DB.
how to display data from jsp file into database
how to connect to database in php using mysql
How to display data from database in a TableView
display records with images problem - JSP-Servlet
how to import excel sheet into mysql database and save it as a table in database
code to display 20 record per page and display page 1,2,3,4 as recoerd increase - JSP-Servlet
How to display image in jsp from database using Servlet?
how to display database data in jsf page - Java Server Faces Questions
how to display values from database into table using jsp
how to display or retrive an image in jsp whose path is stored in oracle database
How to retrieve image from mysql database in JSP?
MYSQL Database
How to retrive a particular record from database in php with mysql?
How to access (MySQL)database from J2ME?
Display Records in Tree Format - JSP-Servlet
How to insert or delete records in MS access database using jsp - JSP-Servlet
how to display data into textboxes which is retrieved from the database
how to display data into textboxes which is retrieved from the database
how to display data into textboxes which is retrieved from the database
I want to display 10,000 records in a jsp page.Can I display page by page?
Mysql Find Duplicate Records
How to connect to MySql Database from Servlet?
How to Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database ?
please give me solution how to display next page after 20 records ? - JSP-Servlet
How to Create and display Reports in Java with Database connectivity - Java Beginners
ModuleNotFoundError: No module named 'timings'
Upload and display image and text records using JSP and Oracle
How to Restore The Lossed data in MYSQL database after the System is formatted
How can we create a database using PHP and mysql?
how to validate duplicate records in struts1

Ads