lookupborrow.java

用eclipse编写的图书管理系统

package client;

import java.awt.Color;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.ScrollPaneConstants;
import javax.swing.WindowConstants;

import sever.db.ConnectionDB;

public class LookUpBorrow extends JFrame {

	private JTable table;
	ResultSet r;
	ImageIcon image=new ImageIcon("E:\\image\\6.JPG");
	ImageIcon image1=new ImageIcon("E:\\image\\7.JPG");
	/**
	 * Launch the application
	 * @param args
	 */
//	public static void main(String args[]) {
//		try {
//			LookUpBorrow frame = new LookUpBorrow();
//			frame.setVisible(true);
//		} catch (Exception e) {
//			e.printStackTrace();
//		}
//	}

	/**
	 * Create the frame
	 */
	public LookUpBorrow() {
		super();
		getContentPane().setLayout(null);
		getContentPane().setBackground(new Color(224, 235, 237));
		setBounds(100, 100, 493, 344);
		setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
		
		final JScrollPane scrollPane = new JScrollPane();
		scrollPane.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
		scrollPane.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
		scrollPane.setBounds(39, 21, 414, 223);
		getContentPane().add(scrollPane);


		final JButton button = new JButton();
		button.setText("确 认");
		button.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				
				try {
					ConnectionDB co=new ConnectionDB();
					String sql="select *from BorrowInfo";
					r=co.queryData(sql);
					ResultSetMetaData rsm=r.getMetaData();
					
					int count=rsm.getColumnCount();
					Vector row=new Vector();
					
					
					while(r.next()){
						Vector cell=new Vector();
						
						cell.addElement(r.getString(1));
						cell.addElement(r.getInt(2));
						cell.addElement(r.getString(3));
						cell.addElement(r.getString(4));
						
						row.addElement(cell);
					}
					String [] h={"书名","书编号","借阅人","借阅时间"};
					Vector hh=new Vector();
					hh.addElement("书名");
					hh.addElement("书编号");
					hh.addElement("借阅人");
					hh.addElement("借阅时间");
					



					table = new JTable(row,hh);
					scrollPane.setViewportView(table);
					table.setEnabled(false);
					
				} catch (SQLException e1) {
					e1.printStackTrace();
				}
				
				
			}
		});
		button.setFont(new Font("@黑体", Font.PLAIN, 14));
		button.setBounds(90, 273, 101, 25);
		getContentPane().add(button);

		final JButton button_1 = new JButton();
		button_1.setText("取 消");
		button_1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				dispose();
			}
		});
		button_1.setFont(new Font("@黑体", Font.PLAIN, 14));
		button_1.setBounds(293, 273, 101, 25);
		getContentPane().add(button_1);
	}

}