list.java

用eclipse编写的图书管理系统

package client;

import java.awt.Color;
import java.awt.Font;
import java.awt.Rectangle;
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.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.ScrollPaneConstants;
import javax.swing.WindowConstants;
import com.swtdesigner.SwingResourceManager;

import sever.db.ConnectionDB;

public class List extends JFrame{

	private JFrame frame;
	ResultSet rs;//
	ImageIcon image=new ImageIcon("E:\\image\\6.JPG");
	ImageIcon image2=new ImageIcon("E:\\image\\7.JPG");
	ImageIcon image3=new ImageIcon("E:\\image\\fouth.JPG");
	//JScrollPane jScrollPane1 = new JScrollPane();//


	/**
	 * Launch the application
	 * @param args
	 */
//	public static void main(String args[]) {
//		try {
//			List window = new List();
//			window.setVisible(true);
//		} catch (Exception e) {
//			e.printStackTrace();
//		}
//	}

	/**
	 * Create the application
	 */
	public List() {
		new JFrame();
		getContentPane().setLayout(null);
		setBounds(190, 135, 680, 375);
		setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
    	final JScrollPane scrollPane = new JScrollPane();
    	scrollPane.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
    	scrollPane.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
		scrollPane.setBounds(10, 10, 650, 260);
		getContentPane().add(scrollPane);
		

		final JButton button = new JButton();
		button.setFont(new Font("@黑体", Font.PLAIN, 14));
		button.setText("确 认");
		button.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				
				ConnectionDB connectiondb=new ConnectionDB();
				try{
					Vector row=new Vector();
	                String sql="select * from BookInfo";
					rs=connectiondb.queryData(sql);
				    ResultSetMetaData rsm=rs.getMetaData();
				    int count=rsm.getColumnCount();
				    
				    

				    while(rs.next()){
				    	Vector cell=new Vector();
				    	cell.addElement(rs.getString(1));
				    	cell.addElement(rs.getString(2));
				    	cell.addElement(rs.getString(3));
				    	cell.addElement(rs.getInt(4));
				    	cell.addElement(rs.getInt(5));
				    	cell.addElement(rs.getInt(6));
				    	cell.addElement(rs.getString(7));
				    	cell.addElement(rs.getString(8));
				    	row.addElement(cell);
				    	
				    }
				    
		               String h[]={"书名","作者","类别","编号","价格","数量","是否损坏","入库时间" };
		               Vector hh=new Vector();
		                hh.addElement("书名");
		                hh.addElement("作者");
		                hh.addElement("类别");
		                hh.addElement("编号");
		                hh.addElement("价格");
		                hh.addElement("数量");
		                hh.addElement("是否损坏");
		                hh.addElement("入库时间");

		        		final JTable table = new JTable(row,hh);
		        		scrollPane.setViewportView(table);
		        		connectiondb.con.close();
				    
				}catch(SQLException b){
					System.out.println("数据库连接失败");
				}
			}
		});
		button.setBounds(148, 300, 101, 25);
		getContentPane().add(button);

		final JButton button_1 = new JButton();
		button_1.setFont(new Font("@黑体", Font.PLAIN, 14));
		button_1.setText("取 消");
		button_1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				dispose();
			}
		});
		button_1.setBounds(395, 300, 101, 25);
		getContentPane().add(button_1);
		getContentPane().setBackground(new Color(224, 235, 237));
		setIconImage(SwingResourceManager.getImage(List.class, "/LOGO.jpg"));

	
	}
		
	}