wants to configure next and previous buttons for database entry !

[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 

   








 

[Paul Sturrock]

What is your question?


(And why are you using the JDBC-ODBC bridge?)

[akash shrimali]

PLEASE EXECUTE THE CODE ONES !!










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 !!!

[Paul Sturrock]

Ok, we're getting closer to a question. What do you mean by "MY NEXT BUTTON AND PREVIOUS BUTTONS ARE NOT WORKING"?

(NB: I now understand why you are using the JDBC-ODBC bridge).

[akash shrimali]

sir , like if we click on the next button , the button must go to next record on the database and should display the next records by making ID as primary key




!!!



id ==1
!
!!!
!!!



on next click

id [ 2]
!
!
!!



etc

[Paul Sturrock]

I think I understand what you are trying to do, but I'm going to have to display my continuing ignorance as to what your question actually is. What is not working? How is it not working? Do you have a stack trace or error message you are working with?

[akash shrimali]

sir my select query for next button ( > ) is not retrieving data from database known as student(). as i want this while clicking on this button it must move to next records !!!

[akash shrimali]

this is the image of the database

[Paul Sturrock]

Your select statement:

SELECT ID FROM StudentRecords

selects everything form the table studentrecords. Are there any records in that table? Once you've selected these records you thrown the data away. Is this what you intended to do?

(Your code is quite difficult to follow. Have you considered refactoring in to something more manageable? )

[akash shrimali]

Paul Sturrock wrote:Your select statement:

SELECT ID FROM StudentRecords

selects everything form the table studentrecords. Are there any records in that table? Once you've selected these records you thrown the data away. Is this what you intended top do?

(Your code is quite difficult to follow. Have you considered refactoring in to something more manageable? )

sir here ID is the primary key

[Paul Sturrock]

I guessed as much. How is that pertinent?