readerlist.java

图书馆系统

import java.awt.BorderLayout;
import javax.swing.JPanel;
import java.awt.GraphicsConfiguration;
import java.awt.HeadlessException;

import javax.swing.JFrame;
import javax.swing.JButton;
import java.awt.Rectangle;
import java.awt.Point;
import java.awt.Dimension;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.sql.*;

import javax.swing.table.*;

import java.util.*;

public class readerList extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JButton jButtonSearch = null;

	private JLabel jLabel = null;

	private JTextField jTextFieldusername = null;

	private JScrollPane jScrollPane = null;

	private JTable jTable = null;
	
	ResultSet rs;
	DBManager db=new DBManager();	
	Vector rowData=new Vector(),tempvector;  //  @jve:decl-index=0:
	Vector columnNames=new Vector();  //  @jve:decl-index=0:		
    DefaultTableModel defaultmodel = new DefaultTableModel(rowData,columnNames);
    public void dvec(){
    	columnNames.addElement("用户名");
    	columnNames.addElement("权限");   	
    	
    }    

	public readerList() throws HeadlessException {
		// TODO 自动生成构造函数存根
		super();
		initialize();
	}

	public readerList(GraphicsConfiguration arg0) {
		super(arg0);
		// TODO 自动生成构造函数存根
		initialize();
	}

	public readerList(String arg0) throws HeadlessException {
		super(arg0);
		// TODO 自动生成构造函数存根
		initialize();
	}

	public readerList(String arg0, GraphicsConfiguration arg1) {
		super(arg0, arg1);
		// TODO 自动生成构造函数存根
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(496, 513);
		this.setContentPane(getJContentPane());
		this.setTitle("用户查询");
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel = new JLabel();
			jLabel.setText("用户名");
			jLabel.setSize(new Dimension(65, 20));
			jLabel.setLocation(new Point(20, 15));
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(getJButtonSearch(), null);
			jContentPane.add(jLabel, null);
			jContentPane.add(getJTextFieldusername(), null);
			jContentPane.add(getJScrollPane(), null);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jButtonSearch	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButtonSearch() {
		if (jButtonSearch == null) {
			jButtonSearch = new JButton();
			jButtonSearch.setLocation(new Point(309, 15));
			jButtonSearch.setText("查询");
			jButtonSearch.setSize(new Dimension(70, 20));
			jButtonSearch.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					String strSQL;
					if(jTextFieldusername.getText().trim().equals("")){
						strSQL="select * from alluser";
					}
					else
						strSQL="select * from alluser where Username='"+jTextFieldusername.getText().trim()+"'";
//					执行数据库查询操作
					System.out.println(strSQL);
					rs=db.getResult(strSQL);
					boolean isexist=false;
					try{
						isexist=rs.first();
					}
					catch(SQLException ex1){
						JOptionPane.showMessageDialog(null, "ex1.toString"+ex1.toString(), "错误", JOptionPane.ERROR_MESSAGE);
						return;
					}
					//若书目不存在
					if(!isexist){
						JOptionPane.showMessageDialog(null, "无记录", "错误", JOptionPane.ERROR_MESSAGE);
						return;
					}
					else{
						//先清空集中对象
						//tempvector.clear();
						//清空defaultmodel
						for(int n=defaultmodel.getRowCount()-1;n>=0;n--)
							defaultmodel.removeRow(n);
						try{
							//移动光标到零的位置
							rs.beforeFirst();
							while(rs.next()){
								tempvector=new Vector(1,1);
								tempvector.add(rs.getString("Username"));
								tempvector.add(rs.getString("aPower"));								
								defaultmodel.addRow(tempvector);
							}
						}
						catch(SQLException ex){
							JOptionPane.showMessageDialog(null, "发生错误", "错误", JOptionPane.ERROR_MESSAGE);
							return;
						}
					}
				}
			});
		}
		return jButtonSearch;
	}

	/**
	 * This method initializes jTextFieldusername	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldusername() {
		if (jTextFieldusername == null) {
			jTextFieldusername = new JTextField();
			jTextFieldusername.setLocation(new Point(99, 15));
			jTextFieldusername.setSize(new Dimension(170, 20));
		}
		return jTextFieldusername;
	}

	/**
	 * This method initializes jScrollPane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setBounds(new Rectangle(20, 45, 453, 421));
			jScrollPane.setViewportView(getJTable());
		}
		return jScrollPane;
	}

	/**
	 * This method initializes jTable	
	 * 	
	 * @return javax.swing.JTable	
	 */
	private JTable getJTable() {
		if (jTable == null) {
			dvec();
			jTable = new JTable(defaultmodel);
		}
		return jTable;
	}

}  //  @jve:decl-index=0:visual-constraint="10,10"