unable to run select query in frame

[akash shrimali]

 import java.awt.event.*;
import java.awt.*;
import java.sql.*;
import java.io.*;


public class student extends Frame implements WindowListener,ActionListener,ItemListener

{


 private Frame f;
 private Button ADD, DELETE, UPDATE, CANCEL,bg,start,last,left,right,Edit,report;
 TextField id,fname,lname,age;
 private Label l0,l1,l2,l3,l4,l5,l6,l7;
 TextArea address;
 Checkbox x,y;
static String p,q;








 public student()
{


  f = new Frame("STUDENT MANAGEMENT SYSTEM");
  ADD = new Button("ADD");
ADD.setFont(new Font("Wide Latin", Font.BOLD,12));
  DELETE = new Button("DELETE");
DELETE.setFont(new Font("Wide Latin", Font.BOLD,12));
  UPDATE = new Button("UPDATE");
UPDATE.setFont(new Font("Wide Latin", Font.BOLD,12));
  CANCEL = new Button("CANCEL");
CANCEL.setFont(new Font("Wide Latin", Font.BOLD,12));
  left=new Button("<");
left.setFont(new Font("Wide Latin", Font.BOLD,18));
  right=new Button(">");
right.setFont(new Font("Wide Latin", Font.BOLD,18));
  start=new Button("<<<");
start.setFont(new Font("Wide Latin", Font.BOLD,18));
  last=new Button(">>>");
last.setFont(new Font("Wide Latin", Font.BOLD,18));
  Edit=new Button("EDIT");
Edit.setFont(new Font("Wide Latin", Font.BOLD,12));
  report=new Button("REPORT");
report.setFont(new Font("Wide Latin", Font.BOLD,12));


  l0=new Label("ID");
l0.setFont(new Font("Wide Latin", Font.BOLD,18));	
  l1=new Label("First Name");
l1.setFont(new Font("Wide Latin", Font.BOLD,18));
  l2=new Label("Last Name");
l2.setFont(new Font("Wide Latin", Font.BOLD,18));
  l3=new Label("Age");
l3.setFont(new Font("Wide Latin", Font.BOLD,18));
  l4=new Label("Address");
l4.setFont(new Font("Wide Latin", Font.BOLD,18));
  l5=new Label("Gender");
l5.setFont(new Font("Wide Latin", Font.BOLD,18));
  l6=new Label("Blood Group");
l6.setFont(new Font("Wide Latin", Font.BOLD,18));
  l7=new Label("DOB[dd/mm/yy]");
l7.setFont(new Font("Wide Latin", Font.BOLD,18));




  id=new TextField("",2);
id.setEnabled(true);
  fname=new TextField("",10);

  lname=new TextField("",10);

  age=new TextField("",8);

  address=new TextArea("",5,10);






ADD.addActionListener(this);
add(ADD);
DELETE.addActionListener(this);
add(DELETE);
left.addActionListener(this);
add(left);
right.addActionListener(this);
add(right);
start.addActionListener(this);
add(start);
last.addActionListener(this);
add(last);




    
}
    



    public void windowOpened(WindowEvent e){}	
    public void windowClosing(WindowEvent e){System.exit(0);}
    public void windowClosed(WindowEvent e){}
    public void windowIconified(WindowEvent e){}
    public void windowDeiconified(WindowEvent e){}
    public void windowActivated(WindowEvent e){}
    public void windowDeactivated(WindowEvent e){}





public void itemStateChanged(ItemEvent obj)
{

if(obj.getItemSelectable()==x)
{
p=x.getLabel();
System.out.println(p);
}
else if(obj.getItemSelectable()==y)
{
q=y.getLabel();
System.out.println(q);
}

}






public void actionPerformed(ActionEvent ef)


{




String choose=ef.getActionCommand();

if(choose.equals("ADD"))
{

add();

//student grid = new student();
//grid.launchFrame();

}




else if(choose.equals("DELETE"))
{
delete();
student grid = new student();
grid.launchFrame();
}





else if(choose.equals(">"))

{
//right side

select();
student grid =new student();
grid.launchFrame();

}


else if(choose.equals("<"))
{

//left side
//select1();
student grid=new student();
grid.launchFrame();


}

else if(choose.equals(">>>"))
{

//end of the records
//select2();
student grid=new student();
grid.launchFrame();


}



else if(choose.equals("<<<"))
{

//start of the records
//select3();
student grid=new student();
grid.launchFrame();

}




}//end of action command



  


public void add() 
{

 try
    {

      // Step 1 Load the drivers
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           System.out.println("Drivers loaded successfully");



	  
          //Step 2 Establish a jdbc connection to the database
          String url = "jdbc:odbc:student";
          Connection connection = DriverManager.getConnection(url);
	  System.out.println("Connection established successfully");
	
          


	

          // insert data using SQL Query 
          String str,str1,str2,str3,str4,str5,ID; 
	  ID=id.getText();      
          str=fname.getText();
          str1=lname.getText();
          str2=age.getText();
          str3=address.getText();  
	//str4=p;
	System.out.println(p);
	  

	 
	    
	
	

          String qs = "insert into StudentRecords values ('"+ID+"','"+str+"','"+str1+"','"+str2+"','"+str3+"','"+p+"')";


            //Step 3 Creating JDBC Statements & executing the query
	    Statement stmt = connection.createStatement(); 
            stmt.executeUpdate(qs);
	    System.out.println("Insertion is complete");




	    //Step 4 Closing the Connection and Statement Object
	    stmt.close();
	    connection.close();

         }
		
	


  catch(Exception a)
  {
	System.out.println(a.getMessage());
  }

        

          

}//end of add query









public void delete() 
{

 try
    {

      // Step 1 Load the drivers
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           System.out.println("Drivers loaded successfully");



	  
          //Step 2 Establish a jdbc connection to the database
         String url = "jdbc:odbc:student";
         Connection connection = DriverManager.getConnection(url);
	 System.out.println("Connection established successfully");
	
          


	

          // delete data using SQL Query 
	
	String studentid=id.getText();   
	System.out.println(studentid);

        String qs="delete from StudentRecords where ID=studentid";
	

           

	 //Step 3 Creating JDBC Statements & executing the query
	 Statement stmt = connection.createStatement(); 
         stmt.executeUpdate(qs);
	 System.out.println("deletion is complete"); 
	 




	 //Step 4 Closing the Connection and Statement Object
	 stmt.close();
	 connection.close();

    }
		
	


  catch(Exception a)
  {
	System.out.println(a.getMessage());
  }

        

          

}





public void select()

{
     try {
        
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           System.out.println("Drivers loaded successfully");


       
      	    String url = "jdbc:odbc:student";
            Connection con = DriverManager.getConnection(url);
	    System.out.println("Connection established successfully");





           
	     
         
            //Creating JDBC Statements
			
            Statement select = con.createStatement();
            
            //Executing the Query
		
	     
	
	    ResultSet result = select.executeQuery("SELECT ID FROM StudentRecords");
           
           



  	  


             //Closing the Connection and Statement Object    
		
		select.close();
		con.close();
		
	} //try closed
		  catch (Exception e)
		 
		  { 
			
		  }
            
          
           
        
}







 public void launchFrame() 


{

   f.setSize(350,600);
   f.setLocation(500,10);
   f.setResizable(false);
  
   f.setBackground(Color.pink);
   f.setForeground(Color.blue);
	
   f.addWindowListener(this);
   f.setLayout (new GridLayout(9,2));
  
	
	f.add(l0);
	f.add(id);
	

	f.add(l1);
	f.add(fname);


	f.add(l2);
	f.add(lname);


	f.add(l3);
	f.add(age);


	f.add(l4);
	f.add(address);


	f.add(l5);
	Panel p = new Panel();
	p.setLayout(new GridLayout(1, 1));  

	CheckboxGroup cg1=new CheckboxGroup();

  	x=new Checkbox("MALE", cg1, true);
   	y=new Checkbox("FEMALE", cg1, false);
	p.add(x);
	p.add(y);
	

	x.addItemListener(this);
	y.addItemListener(this);
	f.add(p);

	 


	f.add(l6);
	Panel p1 = new Panel();
	p1.setLayout(new GridLayout(2, 2, 2, 2));  
	CheckboxGroup cg2=new CheckboxGroup();
	p1.add(new Checkbox("Group A", cg2, true));
   	p1.add(new Checkbox("Group B", cg2, false));
	p1.add(new Checkbox("Group AB", cg2, false));
   	p1.add(new Checkbox("Group O", cg2, false));
	
	f.add(p1);
        



	f.add(l7);
	Panel p2 = new Panel();
	p2.setLayout(new GridLayout(1, 3)); 
        p2.setSize(150,30);
 	List lst = new List(1, false);
 	lst.add("1");
	lst.add("2");
	lst.add("3");
	lst.add("4");
 	lst.add("5");
 	lst.add("6");
 	lst.add("7");
 	lst.add("8");
 	lst.add("9");
	 lst.add("10");
	lst.add("11");
	lst.add("12");
	lst.add("13");
	lst.add("14");
	lst.add("15");
	lst.add("16");
	lst.add("17");
	lst.add("18");
	lst.add("19");
	lst.add("20");
	lst.add("21");
	lst.add("22");
	lst.add("23");
	lst.add("24");
	lst.add("25");
	lst.add("26");
	lst.add("27");
	lst.add("28");
	lst.add("29");

	lst.add("30");
	lst.add("31");

 	p2.add(lst);
	
	List lst2 = new List(2, false);
 	lst2.add("jan");
	lst2.add("feb");
	lst2.add("mar");
	lst2.add("apr");
 	lst2.add("may");
 	lst2.add("June");
 	lst2.add("july");
 	lst2.add("aug");
 	lst2.add("sep");
	lst2.add("oct");
	lst2.add("Nov");
	lst2.add("Dec");
	 
 	p2.add(lst2);
	
	List lst3 = new List(2, false);
 	lst3.add("1986");
	lst3.add("1987");
	lst3.add("1988");
	lst3.add("1989");
 	lst3.add("1990");
 	lst3.add("1991");
 	lst3.add("1992");
 	lst3.add("1993");
 	lst3.add("1994");
	lst3.add("1995");
 	p2.add(lst3);
 
	f.add(p2);


	Panel p3= new Panel();
	p3.setLayout(null); 
	
   	p3.add(ADD);
   	p3.add(DELETE);
   	
	p3.add(Edit);
	p3.add(left);
	
	p3.add(start);
	

        f.add(p3);

       Panel p4= new Panel();
 f.add(p4);
	p4.setLayout(null); 
        p4.add(UPDATE);
   	p4.add(CANCEL);
	p4.add(right);
	p4.add(last);
	p4.add(report);
ADD.setBounds(10,42,50,20);
DELETE.setBounds(62,42,55,20);
UPDATE.setBounds(10,42,50,20);
CANCEL.setBounds(62,42,50,20);
Edit.setBounds(119,42,50,20);
start.setBounds(10,20,75,20);
left.setBounds(87,20,75,20);
right.setBounds(10,20,75,20);
last.setBounds(87,20,75,20);
report.setBounds(114,42,50,20);

	
	

	
 	f.setVisible(true);
} 



  
public static void main(String[] args)  
	
{
  student grid = new student();
  grid.launchFrame();
      
}//main closure










	
     
      
   
}//class closed 

   








   

[akash shrimali]

want to run the frame without using swing !!!

[Matthew Brown]

What exactly is the question? What is happening, and how is that different to what you're expecting?

[akash shrimali]

sir i have to design a frame which will take student records in the particular fields , now those records will be stored in database MS access using sql query , what exactly happening is there are 9 buttons in the frame

5 buttons - add , cancel , update, delete and edit

4 buttons for -- previous, next , start and last

MY ADD QUERY ON ADD BUTTON which takes the data from the user is working properly i.e it is taking the data in student table

MY DELETE QUERY ON DELETE BUTTON which delete the particular record of the selected ID number is not working

MY NEXT BUTTON AND PREVIOUS BUTTONS ARE NOT WORKING IN WHICH I HAVE TOGGLE BETWEEN THE RECORDS USING SELECT QUERY ARE ALSO NOT WORKING !!!

[akash shrimali]

PLEASE EXECUTE THIS CODE !

[Matthew Brown]

akash shrimali wrote:PLEASE EXECUTE THIS CODE !

That's not really possible, because we don't have the database.

I notice you've asked this in another thread as well. It's best to keep the discussion in one place, so it might as well be there.

[Campbell Ritchie]

Matthew Brown wrote:

akash shrimali wrote: . . . I notice you've asked this in another thread as well. It's best to keep the discussion in one place, so it might as well be there.

Agree. Closing thread.