menu2_1.java

实现一个图书管理系统的界面。要求简洁美观。可以把主要功能放在状态栏上。

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.table.*;
import java.sql.*;
public class Menu2_1 extends JFrame implements ActionListener{
	JLabel lbl1=new JLabel("借书证号");
	JLabel lbl2=new JLabel("借书证号");
	JLabel lbl3=new JLabel("书籍编号");
	JTextField txt1=new JTextField(10);
	JTextField txt2=new JTextField(10);
	JTextField txt3=new JTextField(10);
	JButton btn1=new JButton("查询");
	JButton btn2=new JButton("确定");
	JButton btn3=new JButton("取消");
	JButton btn4=new JButton("浏览");
	String col[]={"借书证号","书籍编号","借书时间","应还时间","是否以还"};
	String rows[][]=new String[5][5];
	JTable tb;
	JScrollPane jsp;
	JTabbedPane tab=new JTabbedPane();
	public Menu2_1()	//构造函数
    {
        init();
    	btn1.addActionListener(this);
    	btn2.addActionListener(this);
    	btn3.addActionListener(this);
    	btn4.addActionListener(this);
    }
	public void init()
    {
    	this.setTitle("借书");
        //-------------------Tab1-----------------------------
   		JPanel jp1=new JPanel();
   		jp1.setLayout(new GridLayout(1,3));
   		jp1.add(lbl1);jp1.add(txt1);jp1.add(btn1);
   		JPanel jp4=new JPanel();
   		jp4.add(btn4);
   		JPanel jp2=new JPanel();
   		tb=new JTable(rows,col);
    	jsp=new JScrollPane(tb);
    	jp2.add(jp1,BorderLayout.NORTH);
    	jp2.add(jsp,BorderLayout.CENTER);
    	jp2.add(jp4,BorderLayout.SOUTH);
   		
    	//-------------------Tab2-----------------------------
    	JPanel jp3=new JPanel();
    	jp3.setLayout(new GridLayout(3,2));
    	jp3.add(lbl2);jp3.add(txt2);
    	jp3.add(lbl3);jp3.add(txt3);
    	jp3.add(btn2);jp3.add(btn3);
    	
    
    	
    	//-------------------放置Tab-----------------------------
    	tab.add(jp2,"查询");tab.add(jp3,"借书");
    	this.getContentPane().add(tab);
    	
    	this.setLocation(500,200);
    	this.setSize(500,400);
    	this.setVisible(true);
    
    }
    public void actionPerformed(ActionEvent e)
    {
    	if(e.getSource()==btn1){
    		try{
    			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection con=DriverManager.getConnection("jdbc:odbc:yyp","","");
				Statement cmd=con.createStatement();
				ResultSet rs=cmd.executeQuery("select * from borrow");
				while(rs.next())
				{
					String st1=rs.getString(1);
					if(st1.equals(txt1.getText()))
					{
						JOptionPane.showMessageDialog(this,"该用户借书的书籍编号为:"+rs.getString(2)+"  应还时间为:"+
						rs.getString(4));
					}

				}
			}
						
				catch(Exception ex)
			{
				System.out.println(ex);
			}   		
		}
    	if(e.getSource()==btn2){
			try{		
    	          	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		        	Connection con=DriverManager.getConnection("jdbc:odbc:yyp","","");
		        	Statement cmd=con.createStatement();
		        	cmd.executeUpdate("insert into borrow(rId,bId) values('"+txt2.getText()+"',"+"'"+txt3.getText()+"')");	
		        	JOptionPane.showMessageDialog(this,"储存成功");		
    		}
				catch(Exception ex)
			{
				System.out.println(ex);
			}   
		}			
    	if(e.getSource()==btn3)
    		this.dispose();
    	if(e.getSource()==btn4){
    		try{
    			int flag=0;
    			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection con=DriverManager.getConnection("jdbc:odbc:yyp","","");
				Statement cmd=con.createStatement();
				ResultSet rs=cmd.executeQuery("select * from borrow");
				while(rs.next())
				{
						rows[flag][0]=rs.getString(1);
						rows[flag][1]=rs.getString(2);
						rows[flag][2]=rs.getString(3);
						rows[flag][3]=rs.getString(4);
						rows[flag][4]=rs.getString(5);
					    flag++;
					    tb.setModel(new DefaultTableModel(rows,col));
					    
				}
			}
				catch(Exception ex)
			{
				System.out.println(ex);
			}   		
			}
          }
    	 
    public static void main(String arg[]){
    	Menu2_1 frm=new Menu2_1();
    	frm.setSize(500,300);
    	frm.setVisible(true);
    }
 }