Select_db

package test_database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Select_db {

     public static void main(String []arg)
     {

        Connection con;
        PreparedStatement ps;
        ResultSet rs;

        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            con=DriverManager.getConnection("jdbc:mysql://localhost/test","root","");
            System.out.println("Database Connected");

            //Update query
            ps=con.prepareStatement("select * from test_db where Name=?");
            ps.setString(1, "Previnkumar");
            rs=ps.executeQuery();
            while(rs.next())
            {
                System.out.println(rs.getString(1));
                System.out.println(rs.getString(2));
                System.out.println(rs.getInt(3));
            }


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

    }
}