how to pass sql query from inputDialogbox and find the data from database plz help me
import java.sql.*;
import javax.swing.*;
class Retrieve{
public static void main(String[] args){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
String query=JOptionPane.showInputDialog(null,"Enter query");
ResultSet rs=st.executeQuery(query);
String name="",address="";
if(rs.next()){
System.out.println("Name: "+rs.getString("name"));
System.out.println("Address: "+rs.getString("address"));
}
}
catch(Exception e){}
}
}