Hi Friend,

Try the following code:

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class Form extends JFrame
{
JButton ADD;
JPanel panel;
JLabel label1;
final JTextField text1;
Form()
{
label1 = new JLabel();
label1.setText("Gender:");
text1 = new JTextField(20);

ADD=new JButton("Count");
panel=new JPanel(new GridLayout(2,2));
panel.add(label1);
panel.add(text1);

panel.add(ADD);

add(panel,BorderLayout.CENTER);
setTitle("FORM");

ADD.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
String value1=text1.getText();

Connection con = null;
String url = "jdbc:mysql://192.168.10.112:3306/";;
String db = "mydata";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try{
String i="";

Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
Statement st = con.createStatement();
ResultSet rs=st.executeQuery("SELECT count(id_sales) from userlist where gender='"+value1+"'");
while(rs.next()){
i=rs.getString("count(id_sales)");
System.out.println(i);
JOptionPane.showMessageDialog(null,"Count is: "+i);
}

st.close();

con.close();
}
catch(Exception e){
System.out.println(e);
}
}
});
}
}
class RetrieveCount
{
public static void main(String arg[])
{
try
{
Form frame=new Form();
frame.setSize(300,100);
frame.setVisible(true);
}
catch(Exception e)
{}
}
}
Thanks