paginationdemo.java

一个用java开发的具有搜索功能的图书管理系统

package library;

import javax.swing.SwingUtilities;
import java.awt.BorderLayout;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

import javax.swing.JPanel;
import javax.swing.JFrame;
import javax.swing.JButton;

public class PaginationDemo extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JButton jButton = null;

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setText("show");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					MySQL mysql;
					try {
						mysql = new MySQL("jdbc:mysql://localhost/mysql","root","");
						ResultSet rs=mysql.getResultSet("select count(*) rowCount from bulletin;");
						Pagination page=new Pagination();
						rs.next();
						page.setRowCount(rs.getInt("rowCount"));
						page.setRecordsPerPage(12);
						page.setCurrentPage(1);
						rs=mysql.getResultSet("select * from bulletin limit "+(page.getBeginRow()-1)+","+page.getRecordCount()+";");
						System.out.println(page.getRowCount());
						System.out.println(page.getPageCount());
						ResultSetMetaData resultSetMetaData=rs.getMetaData();
						int columnCount=resultSetMetaData.getColumnCount();                    //得到字段数
						while(rs!=null&&rs.next())
						{
							for(int j=0;j<columnCount;j++)
							{
								System.out.print(rs.getString(j+1)+"\t");
							}
							System.out.println();
						}
//						while(bulletinRS.next())
//						{
//							System.out.println(bulletinRS.getString("title"));
//						}
						mysql.closeMySQL();
					} catch (ClassNotFoundException e2) {
						// TODO 自动生成 catch 块
						e2.printStackTrace();
					} catch (SQLException e2) {
						// TODO 自动生成 catch 块
						e2.printStackTrace();
					} catch (Exception ex) {
						// TODO 自动生成 catch 块
						ex.printStackTrace();
					}
				}
			});
		}
		return jButton;
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		SwingUtilities.invokeLater(new Runnable() {
			public void run() {
				PaginationDemo thisClass = new PaginationDemo();
				thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
				thisClass.setVisible(true);
			}
		});
	}

	/**
	 * This is the default constructor
	 */
	public PaginationDemo() {
		super();
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(300, 200);
		this.setContentPane(getJContentPane());
		this.setTitle("JFrame");
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(new BorderLayout());
			jContentPane.add(getJButton(), BorderLayout.SOUTH);
		}
		return jContentPane;
	}

}