selectreader.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.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.ScrollPaneConstants;
import javax.swing.WindowConstants;
import com.swtdesigner.SwingResourceManager;

import sever.business.iface.ILibrarianInfoIface;
import sever.business.iface.IReaderIface;
import sever.business.impl.IlibrarianInfoImpl;
import sever.business.impl.ReaderImpl;
import sever.dao.BorrowInfoDAO;
import sever.dao.ReaderInfoDAO;
import sever.entity.BookInfo;
import sever.entity.ReaderInfo;

public class SelectReader extends JFrame {

	/**
	 * Launch the application
	 * @param args
	 */
	
	ImageIcon img=new ImageIcon("E:\\image\\1.JPG");
	ImageIcon img1=new ImageIcon("E:\\image\\2.JPG");
	ImageIcon img2=new ImageIcon("E:\\image\\4.JPG");
	ImageIcon img3=new ImageIcon("E:\\image\\1.JPG");
//	public static void main(String args[]) {
//		try {
//			SelectReader frame = new SelectReader();
//			frame.setVisible(true);
//		} catch (Exception e) {
//			e.printStackTrace();
//		}
//	}

	/**
	 * Create the frame
	 */
	public SelectReader() {
		super();
		setIconImage(SwingResourceManager.getImage(SelectReader.class, "/LOGO.jpg"));
		getContentPane().setBackground(new Color(224, 235, 237));
		getContentPane().setLayout(null);
		setBounds(190, 135, 426,325);
		setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
		setTitle("读者查询");

		final JLabel label = new JLabel();
		label.setFont(new Font("@黑体", Font.PLAIN, 14));
		label.setText("按姓名：");
		label.setBounds(24, 31, 56, 28);
		getContentPane().add(label);

		final JTextField textField = new JTextField();
		textField.setBounds(86, 35, 147, 21);
		getContentPane().add(textField);

		final JLabel label_1 = new JLabel();
		label_1.setFont(new Font("@黑体", Font.PLAIN, 14));
		label_1.setText("按编号：");
		label_1.setBounds(24, 76, 56, 21);
		getContentPane().add(label_1);

		final JTextField textField_1 = new JTextField();
		textField_1.setBounds(86, 76, 147, 21);
		getContentPane().add(textField_1);
		
		final JScrollPane scrollPane1 = new JScrollPane();
		scrollPane1.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
		scrollPane1.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
		scrollPane1.setBounds(32, 156, 364, 79);
		getContentPane().add(scrollPane1);

		final JButton button = new JButton();
		button.setFont(new Font("@黑体", Font.PLAIN, 14));
		button.setText("确认");
		button.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				if(textField.getText().length()==0){
					JOptionPane.showMessageDialog(null,"请输入编号");
				}
				
				else{
				
				try {
                   
              
                  ReaderInfo reader=new ReaderInfo();
                  reader.setReaderName(textField.getText().trim());
                 ReaderInfoDAO bif = new ReaderInfoDAO();
                  
                 IReaderIface face=new ReaderImpl();
                  
                 ResultSet rs=face.ReaderName(reader);
               ResultSetMetaData rsm=rs.getMetaData();
                 int count=rsm.getColumnCount();
                  Vector row=new Vector();
					
					while(rs.next()){
						Vector cell=new Vector();
						cell.addElement(rs.getString(1));
						cell.addElement(rs.getInt(2));
						cell.addElement(rs.getInt(3));
						cell.addElement(rs.getString(4));
						cell.addElement(rs.getString(5));
						cell.addElement(rs.getString(6));
						cell.addElement(rs.getString(7));
						cell.addElement(rs.getString(8));
						cell.addElement(rs.getInt(9));
						row.addElement(cell);
						
						String []h={"姓名","编号","年龄","职业","性别","地址","电话","Email/QQ","余额"};
						
						Vector hh=new Vector();
						hh.addElement("姓名");
						hh.addElement("编号");
						hh.addElement("年龄");
						hh.addElement("职业");
						hh.addElement("性别");
						hh.addElement("地址");
						hh.addElement("电话");
						hh.addElement("Email/QQ");
						hh.addElement("余额");
						



						final JTable table = new JTable(row,hh);
						scrollPane1.setViewportView(table);
						table.setEnabled(false);

					}
				} catch (SQLException e1) {
			
					e1.printStackTrace();
				}
				}
			}
		});
		button.setBounds(273, 33, 73, 25);
		getContentPane().add(button);
		
		final JScrollPane scrollPane = new JScrollPane();
		scrollPane.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
		scrollPane.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
		scrollPane.setBounds(32, 156, 364, 79);
		getContentPane().add(scrollPane);

		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) {
				if(textField_1.getText().length()==0){
					JOptionPane.showMessageDialog(null,"请输入读者名");
				}
				else{
				try{
					ReaderInfo reader=new ReaderInfo();
					reader.setReaderId(Integer.parseInt(textField_1.getText().trim()));
					ReaderInfoDAO bif = new ReaderInfoDAO();
	                  
	                 IReaderIface face=new ReaderImpl();
	                  
	                 ResultSet rs=face.ReadNuber(reader);
	               ResultSetMetaData rsm=rs.getMetaData();
	                 int count=rsm.getColumnCount();
	                  Vector row=new Vector();
						
						while(rs.next()){
							Vector cell=new Vector();
							cell.addElement(rs.getString(1));
							cell.addElement(rs.getInt(2));
							cell.addElement(rs.getInt(3));
							cell.addElement(rs.getString(4));
							cell.addElement(rs.getString(5));
							cell.addElement(rs.getString(6));
							cell.addElement(rs.getString(7));
							cell.addElement(rs.getString(8));
							cell.addElement(rs.getInt(9));
							row.addElement(cell);
							
							String []h={"姓名","编号","年龄","职业","性别","地址","电话","Email/QQ","余额"};
							
							Vector hh=new Vector();
							hh.addElement("姓名");
							hh.addElement("编号");
							hh.addElement("年龄");
							hh.addElement("职业");
							hh.addElement("性别");
							hh.addElement("地址");
							hh.addElement("电话");
							hh.addElement("Email/QQ");
							hh.addElement("余额");
							



							final JTable table = new JTable(row,hh);
							scrollPane.setViewportView(table);
					

						}
					} catch (SQLException e1) {
						
						e1.printStackTrace();
					}
				}
				}
				
				
			
		});
		button_1.setBounds(273, 74, 73, 25);
		getContentPane().add(button_1);

		final JLabel label_2 = new JLabel();
		label_2.setFont(new Font("@黑体", Font.PLAIN, 14));
		label_2.setText("查询结果");
		label_2.setBounds(24, 116, 66, 21);
		getContentPane().add(label_2);

		final JButton button_2 = new JButton();
		button_2.setFont(new Font("@黑体", Font.PLAIN, 14));
		button_2.setText("重置");
		button_2.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				textField_1.setText("");
				textField.setText("");
				
				
			}
		});
		button_2.setBounds(86, 241, 66, 25);
		getContentPane().add(button_2);

		final JButton button_3 = new JButton();
		button_3.setFont(new Font("@黑体", Font.PLAIN, 14));
		button_3.setText("退出");
		button_3.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				dispose();
			}
		});
		button_3.setBounds(273, 241, 66, 25);
		getContentPane().add(button_3);
		
	}

}