Retrieve Data from Database.


import  java.sql.*;
import java.util.*;
Class insert
{
public static void main(String args[])
{
try
{
//Scanner scan=new Scanner(System.in);
//System.out.println("Enter the id:-");
//int id=scan.nextInt();
//System.out.println("Enter Ur Name:-");
//String name=scan.next();

//System.out.println("Enter Ur Address:-");
//String add=scan.next();
//System.out.println("Enter Ur Mail:-");
//String mail=scan.next();


Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/Databasename","username","password");
PreparedStatement pst=con.prepareStatement("select * from demo");
ResultSet rs=pst.executeQuery();
while(rs.next())
{
  int id = rs.getInt(1);
  String name = rs.getString(2);
  String mail = rs.getString(3);
  String address = rs.getString(4);
           
  System.out.println(id + "\t" + name +
                               "\t" + mail + "\t" + address );

}
con.close();
pst.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}

Popular posts from this blog

Simple Sign up design. Android.

Cart page design in android.

Set Date on jDateChooser and retrieve record from database.