电子科技大学综合课程设计__图书管理系统

package ui; import bean.Book; import util.LogUtil; import util.MsgUtil; import util.MysqlUtil; import util.excelUtils.ExcelUtil; import util.excelUtils.MyFileFilter; import view.BookItemView; import javax.swing.*; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.io.File; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; /** * Created by Admin on 2016/7/2. */ public class AdminManage extends BaseUi implements ActionListener { private JButton btnAdd ; private JButton btnBack; private int currentPage=1; private int allPages =0; protected JLabel title=new JLabel("书号 书名 位置 " + " 作者 借书人 " + " 预约人 " + " "); /** * 使用这个来存放所有查询的结果 */ private List<Book>books ; /** * 存方当前的书 */ private Book currentBook=null; /** * 当前页面的itemshitu */ private List<Book> currentPageBooks; private List<BookItemView> itemsViews=new ArrayList<BookItemView>(10); /** * 左边的控件 */ private JLabel lb_id; private JLabel lb_name ; private JLabel lb_position; private JLabel lb_auther; private JTextField id; private JTextField name; private JTextField position; private JTextField auther; private JButton btnDelete; private JButton btnImport; /** * 右上fragment */ private JButton search=new JButton("搜索"); private JTextField content=new JTextField(10); private JComboBox combox=null; /** * 导航控件 */ private JButton btnFore; private JLabel showPage; private JButton btnNext; public AdminManage(){ //leftFragment.setBackground(Color.MAGENTA); //rightFragment.setBackground(Color.BLACK); initWidget(); initAddPanel(); initRightTopFragment(); initRightBottomFragment(); } public void initWidget(){ btnFore=new JButton("<<"); btnNext=new JButton(">>"); showPage=new JLabel(currentPage+"/"+allPages); navigationFragment.add(btnFore); navigationFragment.add(showPage); navigationFragment.add(btnNext); btnFore.addActionListener(this); btnNext.addActionListener(this); search.addActionListener(this); titleView.add(title); } public void initAddPanel(){ btnBack=new JButton("退出"); lb_id=new JLabel("图书号"); lb_name=new JLabel("图书名"); lb_position=new JLabel("位置"); lb_auther=new JLabel("作者"); btnDelete=new JButton("删除"); id=new JTextField(10); name=new JTextField(10); position=new JTextField(10); auther=new JTextField(10); btnAdd=new JButton("添加图书"); btnImport=new JButton("导入excel"); leftFragment.setLayout(new GridLayout(10,1)); leftFragment.add(lb_id); leftFragment.add(id); leftFragment.add(lb_name); leftFragment.add(name); leftFragment.add(lb_position); leftFragment.add(position); leftFragment.add(lb_auther); leftFragment.add(auther); leftFragment.add(new JPanel()); leftFragment.add(new JPanel()); leftFragment.add(new JPanel()); leftFragment.add(btnAdd); leftFragment.add(new JPanel()); leftFragment.add(new JPanel()); leftFragment.add(new JPanel()); leftFragment.add(new JPanel()); leftFragment.add(new JPanel()); leftFragment.add(btnImport); leftFragment.add(btnBack); leftFragment.add(btnDelete); leftFragment.setBorder(BorderFactory.createRaisedBevelBorder()); btnAdd.addActionListener(this); btnBack.addActionListener(this); btnDelete.addActionListener(this); btnImport.addActionListener(this); } public void initRightTopFragment(){ /** * 初始化combox * */ combox=new JComboBox(); //定义Object二维数组,用于初始化下拉框,参数依次为图标,显示文本,提示文本 String str[]={"按照书号","按照书名","按照作者"}; for (int i = 0; i < str.length; i++) { combox.addItem(str[i]); } rightTopFragment.add(search); rightTopFragment.add(content); rightTopFragment.add(combox); } public void initRightBottomFragment(){ rightBottomFrament.setBorder(BorderFactory.createRaisedBevelBorder()); rightBottomFrament.setVisible(true); rightBottomFrament.setLayout(new GridLayout(10,0)); refreshListInfo(1,""); refreshView(); } /** * 只有在数据库查询进行的时候才会调用 * 所以这可以将currentPage设置成 1 * @param choose * @param info */ public void refreshListInfo(int choose,String info) { currentPage=1 ; // 更新数据之前先对list进行重置 books=null; info.trim(); ResultSet resultSet; switch(choose) { case 1://全部查找 //得到所有的学生以及每一页的学生 resultSet=MysqlUtil.queryAllBooks(); books=MysqlUtil.convertBooksFromResultSet(resultSet); System.out.println("all student number:"+books.size()); break; case 2://按照书号 resultSet=MysqlUtil.queryBookById(info); books=MysqlUtil.convertBooksFromResultSet(resultSet); System.out.println("by id count:"+books.size()); break; case 3://按照书名 resultSet=MysqlUtil.queryBookByName(info); books=MysqlUtil.convertBooksFromResultSet(resultSet); System.out.println("by name count:"+books.size()); break; case 4://按照作者 resultSet=MysqlUtil.queryBookByAuther(info); books=MysqlUtil.convertBooksFromResultSet(resultSet); System.out.println("by auther count :"+books.size()); break; } currentPageBooks=getPageBook(); allPages=books.size()/10; if(books.size()%10!=0){ allPages+=1; } if(allPages==0){ allPages=1; } LogUtil.showInfo("***************after refreshLsit************"); LogUtil.showInfo("books :size "+books.size()); LogUtil.showInfo("current page index :"+currentPage); LogUtil.showInfo("current page count:"+currentPageBooks.size()); LogUtil.showInfo("--------------------------------------------"); } /** * 刷新界面：需要刷新的有 * 主要的显示界面 * 下面的那个label显示当前页面的和总工多少页的额 * * 需要更新的数据 * allPage ; * currentPage * list: books * list: pageBooks * */ public void refreshView(){ rightBottomFrament.removeAll(); rightBottomFrament.setVisible(true); //将每个書制作成一个单独的视图，显示在rightFragment中 rightBottomFrament.setLayout(new GridLayout(10,0)); itemsViews.clear(); for(int i=0;i<10;i++){ if(i<currentPageBooks.size()){ BookItemView itemView=new BookItemView(currentPageBooks.get(i)); rightBottomFrament.add(itemView); itemsViews.add(itemView); }else{ rightBottomFrament.add(new JPanel()); } } showPage.setText(currentPage