menu1_1.java

来自「实现一个图书管理系统的界面。要求简洁美观。可以把主要功能放在状态栏上。」· Java 代码 · 共 178 行

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.table.*;
import java.sql.*;
public class Menu1_1 extends JFrame implements ActionListener{
	JLabel lbl1=new JLabel(" 书名");
	JLabel lbl2=new JLabel("     作者");
	JLabel lbl3=new JLabel(" 分类名");
	JLabel lbl4=new JLabel("     排架号");
	JLabel lbl5=new JLabel(" 出版社");
	JLabel lbl6=new JLabel("     出版日期");
	JLabel lbl7=new JLabel(" 入库日期");
	JLabel lbl8=new JLabel("     价格");
	JLabel lbl9=new JLabel("简介");
	JTextField txt1=new JTextField(5);
	JTextField txt2=new JTextField(5);
	JTextField txt3=new JTextField(5);
	JTextField txt4=new JTextField(5); 
	JTextField txt5=new JTextField(5);
	JTextField txt6=new JTextField(5);
	JTextField txt7=new JTextField(40);
	JTextField txt8=new JTextField(5);
	JComboBox cmb1=new JComboBox();
	JComboBox cmb2=new JComboBox();
	JButton btn1=new JButton("添加");
	JButton btn2=new JButton("退出");
	JButton btn3=new JButton("查找");
	JButton btn4=new JButton("浏览");
	JButton btn5=new JButton("退出");
	String col[]={"书名","作者","分类名","排架号","出版社","出版日期","入库时间","价格","简介"};
	String rows[][]=new String[9][9];
	JTable tb;
	JScrollPane jsp;
	JTabbedPane tab=new JTabbedPane();

    public Menu1_1()	//构造函数
    {
        init();
    	btn1.addActionListener(this);
    	btn2.addActionListener(this);
    	btn3.addActionListener(this);
    	btn4.addActionListener(this);
        btn5.addActionListener(this);
    }
    public void init()
    {
    	this.setTitle("图书入库");
        //-------------------Tab1-----------------------------
   		JPanel jp1=new JPanel();
   		JPanel jp4=new JPanel();
   		JPanel jp5=new JPanel();
   		jp5.setLayout(new BorderLayout());
   		jp1.setLayout(new GridLayout(4,4));
   	    cmb1.addItem("计算机");cmb1.addItem("数学");cmb1.addItem("外语");
	    cmb2.addItem("A-001");cmb2.addItem("A-002");cmb2.addItem("A-003"); 		
   		
   		jp1.add(lbl1);jp1.add(txt1);jp1.add(lbl2);jp1.add(txt2);
   		jp1.add(lbl3);jp1.add(cmb1);jp1.add(lbl4);jp1.add(cmb2);
   		jp1.add(lbl5);jp1.add(txt3);jp1.add(lbl6);jp1.add(txt4);
   		jp1.add(lbl7);jp1.add(txt5);jp1.add(lbl8);jp1.add(txt6);
   		jp4.add(lbl9);jp4.add(txt7);
   		jp5.add(jp1,BorderLayout.CENTER);
   		jp5.add(jp4,BorderLayout.SOUTH);
   		
   		JPanel jp2=new JPanel();
    	jp2.add(btn1);jp2.add(btn2);
    	
    	JPanel jp3=new JPanel();
    	jp3.setLayout(new BorderLayout());
    	jp3.add(jp5,BorderLayout.CENTER);
    	jp3.add(jp2,BorderLayout.SOUTH);
    	
    	//-------------------Tab2-----------------------------
    	
    	JPanel jp6=new JPanel();
    	JPanel jp7=new JPanel();
    	
    	jp6.add(txt8);
    	jp6.add(btn3);
    	jp7.add(btn4);
    	jp7.add(btn5);
      	tb=new JTable(rows,col);
    	jsp=new JScrollPane(tb);

    	JPanel jp8=new JPanel();
    	jp8.setLayout(new BorderLayout());
    	jp8.add(jsp,BorderLayout.CENTER);
    	jp8.add(jp7,BorderLayout.SOUTH);
    	jp8.add(jp6,BorderLayout.NORTH);
    	
    	//-------------------放置Tab-----------------------------
    	tab.add(jp3,"注册");tab.add(jp8,"改查删");
    	this.getContentPane().add(tab);
    	
    	this.setLocation(200,200);
    	this.setSize(500,300);
    	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();
			cmd.executeUpdate("insert into book(bName,bAuthor,bTypeId,bDeskId,regTime,pubName,pubTime,bPrice,bCon) values('"
			+txt1.getText()+"','"+txt2.getText()+"',"+1+","+1+",'"
			+txt4.getText()+"','"+txt3.getText()+"','"+txt5.getText()+"','"+txt6.getText()+"','"+txt7.getText()+"')");	
			JOptionPane.showMessageDialog(this,"储存成功");		
        	}
				catch(Exception ex)
			{
				System.out.println(ex);
			}   	
		}				
    	if(e.getSource()==btn2)
    		this.dispose();
    	if(e.getSource()==btn3){
    		try{
    			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection con=DriverManager.getConnection("jdbc:odbc:yyp","","");
				Statement cmd=con.createStatement();
				ResultSet rs=cmd.executeQuery("select * from book");
				while(rs.next())
				{
					String st1=rs.getString(2);
					if(st1.equals(txt4.getText()))
					{
						
						JOptionPane.showMessageDialog(this,"书名:"+rs.getString(1)+"作者:"+rs.getString(2)+
						"分类名:"+rs.getString(3)+"排架号:"+rs.getString(4)+"出版社:"+rs.getString(5)+
						"出版日期:"+rs.getString(6)+"入库时间:"+rs.getString(7)+"价格:"+rs.getString(8)+"简介:"+rs.getString(9));
					}
				}
			}			
				catch(Exception ex)
			{
				System.out.println(ex);
			}   		
		}
    	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 bName,bAuthor,bTypeId,bDeskId,regTime,pubName,pubTime,bPrice,bCon from book");
				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);
						rows[flag][5]=rs.getString(6);
						rows[flag][6]=rs.getString(7);
						rows[flag][7]=rs.getString(8);
						rows[flag][8]=rs.getString(9);
					    flag++;
					    tb.setModel(new DefaultTableModel(rows,col)); 
				}
			}
				catch(Exception ex)
			{
				System.out.println(ex);
			}   		
			}	
    	if(e.getSource()==btn5)
    		this.dispose();
    }
    public static void main(String arg[]){
    	Menu1_1 frm=new Menu1_1();
    	frm.setSize(500,300);
    	frm.setVisible(true);
    }
 }