book_master_info.java

it is basic library management

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;

public class book_master_info extends JPanel implements book_master_info_Interface, book_master_tab_Interface, book_master_Interface{
     public Connection connection;
     public int confirm;
        
    public book_master_info() {    	
	
	
	String url = "jdbc:odbc:lib";
 		
 		
 		try {
 			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 			connection = DriverManager.getConnection(url);
 		}
 		catch(ClassNotFoundException cnfex)  {
 			System.err.println("Failed to load driver");
 			cnfex.printStackTrace();
 			System.exit(1);
 		}
 		catch(SQLException sqlex){
 			System.err.println("unable to connect");
 			sqlex.printStackTrace();
 		}
	
	
	isbn_text.addKeyListener(new KeyAdapter() {
    public void keyTyped(KeyEvent e) {
    	char c = e.getKeyChar();      
      		if (!((Character.isDigit(c) || (c == KeyEvent.VK_BACK_SPACE) || (c == KeyEvent.VK_DELETE)))) {
        	JOptionPane.showMessageDialog(null, "Please enter a numerical value");
        	getToolkit().beep();
        	e.consume();
      		}
    		}
  		});
	
	
	class_text.addKeyListener(new KeyAdapter() {
    public void keyTyped(KeyEvent e) {
    	char c = e.getKeyChar();      
      		if (!((Character.isDigit(c) || (c == KeyEvent.VK_BACK_SPACE) || (c == KeyEvent.VK_DELETE)))) {
        	JOptionPane.showMessageDialog(null, "Please enter a numerical value");
        	getToolkit().beep();
        	e.consume();
      		}
    		}
  		});
	

	year_text.addKeyListener(new KeyAdapter() {
    public void keyTyped(KeyEvent e) {
    	char c = e.getKeyChar();      
      		if (!((Character.isDigit(c) || (c == KeyEvent.VK_BACK_SPACE) || (c == KeyEvent.VK_DELETE)))) {
        	JOptionPane.showMessageDialog(null, "Please enter a numerical value");
        	getToolkit().beep();
        	e.consume();
      		}
    		}
  		});
	
	
	pages_text.addKeyListener(new KeyAdapter() {
    public void keyTyped(KeyEvent e) {
    	char c = e.getKeyChar();      
      		if (!((Character.isDigit(c) || (c == KeyEvent.VK_BACK_SPACE) || (c == KeyEvent.VK_DELETE)))) {
        	JOptionPane.showMessageDialog(null, "Please enter a numerical value");
        	getToolkit().beep();
        	e.consume();
      		}
    		}
  		});
	
	
	
	
	book_master.setFont (new Font ("Impact", Font.PLAIN, 16));
	book_no_text.setText("BK-");
			
	book_no_text.addFocusListener(new MyActionListener()
		{
			public void focusLost(FocusEvent e)
			{
			try
			{
				Statement statement = connection.createStatement();
					String query1 = "SELECT * FROM Item " + 
 								"WHERE item_id = '" + 
 								book_no_text.getText() +"'";
					
					ResultSet rs1 = statement.executeQuery(query1);
					try
					{
			            	rs1.next();
			            	//book_no_text.setText(rs1.getString(1));
			            	book_title_text.setText(rs1.getString(2));
			 				year_text.setText(rs1.getString(6));
			 				authorsArea.setText(rs1.getString(5));
			 				subjectArea.setText(rs1.getString(7));
			 				location_text.setText(rs1.getString(4));
			 				type_combo.setSelectedItem(rs1.getString(3));			 					
			 		}
					catch (SQLException sqlex)
					{
					//	JOptionPane.showMessageDialog(null, "Yeah here");
					//sqlex.printStackTrace();	
					}
						
					String query = "SELECT * FROM book_detail " + 
 								"WHERE item_id = '" + 
 								book_no_text.getText() +"'";
					
					ResultSet rs = statement.executeQuery(query);
					try
					{
							rs.next();
							//book_no_text.setText(rs1.getString(1));
			            	type_combo.setSelectedItem(rs.getString(3));
			            	category_combo.setSelectedItem(rs.getString(4));
			            	isbn_text.setText(rs.getString(2));
			            	publisher_text.setText(rs.getString(6));
			            	pages_text.setText(rs.getString(7));
			             	class_text.setText(rs.getString(5));
			            	
			            	int confirm = JOptionPane.showConfirmDialog(null, "This record Exists, would you like to update it?", "CONFIRM", JOptionPane.YES_NO_OPTION);
			 				
			 				if(confirm == JOptionPane.NO_OPTION)
			 				{
			 				save.setEnabled(false);
			 				delete.setEnabled(true);
			            	book_no_text.setEditable(false);
			            	book_title_text.setEditable(false);
 							isbn_text.setEditable(false);
			 				class_text.setEditable(false);
			 				publisher_text.setEditable(false);
			 				year_text.setEditable(false);
			 				pages_text.setEditable(false);
			 				authorsArea.setEditable(false);
			 				subjectArea.setEditable(false);
			 				location_text.setEditable(false);	
							}
					
							else
			 				{
			 				save.setEnabled(false);
			 				update.setEnabled(true);
			 				delete.setEnabled(true);
            				}
											 										
								statement.close(); 
			 				
					}
					
					
					catch (SQLException sqlex)
					{
					JOptionPane.showMessageDialog(null,"sqlex");
					//sqlex.printStackTrace();	
					}
				}
				catch (SQLException sqlex)
					{
						JOptionPane.showMessageDialog(null,"sqlex");
					//sqlex.printStackTrace();
					}
								
					}
					});
					
	text.setLayout(new GridBagLayout());
	GridBagConstraints gbc = new GridBagConstraints();
		
    gbc.gridy = 0;
    gbc.gridx = 0;
    text.add(book_master, gbc);
    
    gbc.gridy = 1;
    text.add(book_no, gbc);
    gbc.gridy = 2;
    text.add(book_title, gbc);
    gbc.gridy = 3;
    text.add(book_type, gbc);
    gbc.gridy = 4;
    text.add(book_cat, gbc);
    gbc.gridy = 1;
    gbc.gridx = 1;
    text.add(book_no_text, gbc);
    gbc.gridy = 2;
    text.add(book_title_text, gbc);
    gbc.gridy = 3;
    text.add(type_combo, gbc);
    gbc.gridy = 4;
    text.add(category_combo, gbc);
    
    gbc.gridy = 1;
    gbc.gridx = 3;
    text.add(isbn, gbc);
    gbc.gridy = 2;
    text.add(class_no, gbc);
    gbc.gridy = 3;
    text.add(publisher, gbc);
    gbc.gridy = 4;
    text.add(yer, gbc);
    gbc.gridy = 5;
    text.add(pages, gbc);
    
    gbc.gridy = 1;
    gbc.gridx = 4;
    text.add(isbn_text, gbc);
    gbc.gridy = 2;
    text.add(class_text, gbc);
    gbc.gridy = 3;
    text.add(publisher_text, gbc);
    gbc.gridy = 4;
    text.add(year_text, gbc);
    gbc.gridy = 5;
    text.add(pages_text, gbc);
    
    add(text);
    setBackground(Color.blue);
    
	    
    
    }
    
    }