java1b1.txt

管理系统 管理系统

//book的ORMaping的实现：
// BookMaping.java
package edu.jlu.fuliang.library.dao.mysql;
 
import java.sql.ResultSet;
import java.sql.SQLException;
 
import edu.jlu.fuliang.library.domain.Book;
import edu.jlu.fuliang.library.jdbc.ORMaping;
 
public class BookMaping implements ORMaping{
 
       public Object mapping(ResultSet rs, Object o) {
              Book book = (Book)o;
              try {
                     book.setTitleName(rs.getString("titleName"));
                     book.setAuthor(rs.getString("author"));
                     book.setISBN(rs.getString("isbn"));
                     book.setType(rs.getInt("type"));
                     book.setItemsAvailable(rs.getInt("itemAvailable"));
              } catch (SQLException e) {
                     e.printStackTrace();
              }
              return book;
       }
 
}
////borrower的ORMaping的实现：
// BorrowerMaping.java
package edu.jlu.fuliang.library.dao.mysql;
 
import java.sql.ResultSet;
import java.sql.SQLException;
 
import edu.jlu.fuliang.library.domain.Borrower;
import edu.jlu.fuliang.library.jdbc.ORMaping;
 
public class BorrowerMaping implements ORMaping{
 
       public Object mapping(ResultSet rs, Object o) {
              Borrower borrower = (Borrower)o;
              try {
                     borrower.setLastName(rs.getString(1));
                     borrower.setFirstName(rs.getString(2));
                     borrower.setAddress(rs.getString(3));
                     borrower.setCity(rs.getString(4));
                     borrower.setZip(rs.getString(5));
                     borrower.setState(rs.getString(6));
              } catch (SQLException e) {
                     e.printStackTrace();
              }
              return borrower;
       }
 
}
//业务层：
//Service接口
// Service.java
package edu.jlu.fuliang.library.service;
 
import java.util.List;
 
import edu.jlu.fuliang.library.domain.Book;
import edu.jlu.fuliang.library.domain.Borrower;
 
public interface Service {
        public Book queryBookByTitle(String title);
        public List queryBookByAuthor(String author);
        public List queryBookByBorrowerLastName(String firstName);
        public void updateBook(Book book);
        public void insertBook(Book book);
        public void deleteBookByTile(String title);
        public Borrower queryBorrowerByLastName(String lastName);
        public void updateBorrower(Borrower borrower);
        public void insertBorrower(Borrower borrower);
        public void deleteBorrowerByLastName(String lastName);
        public void borrowBook(String borrowerLastName,String bookTitle);
        public void returnBook(String borrowerLastName,String bookTitle);
} 
//Service的具体实现
// LibraryService.java
package edu.jlu.fuliang.library.service;
 
import java.util.List;
 
import edu.jlu.fuliang.library.dao.BookDao;
import edu.jlu.fuliang.library.dao.BorrowOrReturnDao;
import edu.jlu.fuliang.library.dao.BorrowerDao;
import edu.jlu.fuliang.library.dao.DaoFactory;
import edu.jlu.fuliang.library.dao.MysqlDaoFactory;
import edu.jlu.fuliang.library.domain.Book;
import edu.jlu.fuliang.library.domain.Borrower;
 
public class LibraryService implements Service{
       
       private BookDao bookDao;
       private BorrowerDao borrowerDao;
       private BorrowOrReturnDao borrowOrReturnDao;
       
       public LibraryService(){
              DaoFactory daoFactory = new MysqlDaoFactory();
              bookDao = daoFactory.createBookDao();
              borrowerDao = daoFactory.createBorrowerDao();
              borrowOrReturnDao = daoFactory.createBorrowOrReturnDao();
       }
       
       public Book queryBookByTitle(String title) {
              return bookDao.queryByTitle(title);
       }
 
       public List queryBookByAuthor(String author) {
              return bookDao.queryByAuthor(author);
       }
 
       public List queryBookByBorrowerLastName(String firstName) {
              return bookDao.queryByBorrowerLastName(firstName);
       }
 
       public void updateBook(Book book) {
              bookDao.updateBook(book);
       }
 
       public void insertBook(Book book) {
              bookDao.insertBook(book);
       }
 
       public void deleteBookByTile(String title) {
              bookDao.deleteBookByTile(title);
       }
 
       public Borrower queryBorrowerByLastName(String lastName) {
              return borrowerDao.queryByLastName(lastName);
       }
 
       public void updateBorrower(Borrower borrower) {
              borrowerDao.updateBorrower(borrower);
       }
 
       public void insertBorrower(Borrower borrower) {
              borrowerDao.insertBorrower(borrower);
       }
 
       public void deleteBorrowerByLastName(String lastName) {
              borrowerDao.deleteBorrowerByLastName(lastName);
       }
 
       public void borrowBook(String borrowerLastName, String bookTitle) {
              borrowOrReturnDao.borrowBook(borrowerLastName,bookTitle);
       }
 
       public void returnBook(String borrowerLastName, String bookTitle) {
              borrowOrReturnDao.returnBook(borrowerLastName,bookTitle);
       }
}
//view层：
//主界面：
package edu.jlu.fuliang.library.view;
 
import java.awt.Color;
import java.awt.Graphics;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
 
import javax.swing.JFrame;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JPanel;
 
public class LibraryMainFrame extends JFrame{
       private JPanel myPanel = new MyPanel();
       private JMenu functionMenu,infoMenu,maintenanceMenu;
       private JMenuItem lendMenuItem,returnMenuItem;
       private JMenuItem titleMenuItem,borrowerMenuItem,browseAllMenuItem;
       private JMenuItem insertBookMenuItem,updateBookMenuItem;
       private JMenuItem insertBorrowerMenuItem,updateBorrowerMenuItem;
       
       public LibraryMainFrame(){
              functionMenu = new JMenu("Function");
              infoMenu = new JMenu("Inforation");
              maintenanceMenu = new JMenu("Maintenance");
              
              lendMenuItem = new JMenuItem("Lend items...");
              returnMenuItem = new JMenuItem("Return items...");
              functionMenu.add(lendMenuItem);
              functionMenu.add(returnMenuItem);
              
              titleMenuItem = new JMenuItem("Search book...");
              borrowerMenuItem = new JMenuItem("Search Borrower...");
              browseAllMenuItem = new JMenuItem("Browse All...");
              infoMenu.add(titleMenuItem);
              infoMenu.add(borrowerMenuItem);
              infoMenu.add(browseAllMenuItem);
              
              insertBookMenuItem = new JMenuItem("Insert Title...");
              updateBookMenuItem = new JMenuItem("Update Item...");
              insertBorrowerMenuItem = new JMenuItem("Insert Borrower...");
              updateBorrowerMenuItem = new JMenuItem("Update Borrower...");
              maintenanceMenu.add(insertBookMenuItem);
              maintenanceMenu.add(updateBookMenuItem);
              maintenanceMenu.add(insertBorrowerMenuItem);
              maintenanceMenu.add(updateBorrowerMenuItem);
           
              JMenuBar menuBar = new JMenuBar();
              menuBar.add(functionMenu);
              menuBar.add(infoMenu);
              menuBar.add(maintenanceMenu);
              
              setJMenuBar(menuBar);
              add(myPanel);
              setSize(300,300);
              setVisible(true);
              
              lendMenuItem.addActionListener(new ActionListener(){
                     public void actionPerformed(ActionEvent e) {
                            new BorrowDialog(LibraryMainFrame.this,"Lend book",true);
                     }
              });
              returnMenuItem.addActionListener(new ActionListener(){
                     public void actionPerformed(ActionEvent e) {
                            new ReturnDialog(LibraryMainFrame.this,"Return book",true);
                     }
              });
              titleMenuItem.addActionListener(new ActionListener(){
                     public void actionPerformed(ActionEvent e) {
                            new SearchBookDialog(LibraryMainFrame.this,"Search book",true);
                     }
              });
              borrowerMenuItem.addActionListener(new ActionListener(){
                     public void actionPerformed(ActionEvent e) {
                            new BorrowerInformationDialog(LibraryMainFrame.this,"Borrower Information",true);
                     }
              });
              browseAllMenuItem.addActionListener(new ActionListener(){
                     public void actionPerformed(ActionEvent e) {
                            
                     }
              });
              insertBookMenuItem.addActionListener(new ActionListener(){
                     public void actionPerformed(ActionEvent e) {
                            new InsertBookDialog(LibraryMainFrame.this,"Insert book dialog",true);
                     }
              });
              updateBookMenuItem.addActionListener(new ActionListener(){
                     public void actionPerformed(ActionEvent e) {
                            new UpdateBookDialog(LibraryMainFrame.this,"Update book dialog",true);
                     }
              });
              insertBorrowerMenuItem.addActionListener(new ActionListener(){
                     public void actionPerformed(ActionEvent e) {
                            new InsertBorrowerDialog(LibraryMainFrame.this,"Insert borrower dialog",true);
                     }
              });
              updateBorrowerMenuItem.addActionListener(new ActionListener(){
                     public void actionPerformed(ActionEvent e) {
                            new UpdateBorrowerDialog(LibraryMainFrame.this,"Update borrower dialog",true);
                     }
              });
       }
       
       private class MyPanel extends JPanel{
              public void paint(Graphics g){
                     g.setColor(Color.green);
                     g.drawString("Welcome to Library System!",40,40);
              }
       }
       public static void main(String []args){
              LibraryMainFrame mainFrame = new LibraryMainFrame();
              mainFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
       }
} 
package edu.jlu.fuliang.library.view;
 
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
 
import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
 
import edu.jlu.fuliang.library.controller.InsertBorrowerController;
import edu.jlu.fuliang.library.domain.Borrower;
 
public class InsertBorrowerDialog extends JDialog{
       JTextField lastNameField;
       JTextField firstNameField;
       JTextField addressField;
       JTextField cityField;
       JTextField zipField;
       JTextField stateField;
       JButton addButton,exitButton;
       
       public InsertBorrowerDialog(JFrame f,String s,boolean b){
              JPanel panel = new JPanel();
              panel.setLayout(new GridLayout(7,2));
              panel.add(new JLabel("Last Name:"));
              lastNameField = new JTextField(10);
              panel.add(lastNameField);
              
              firstNameField = new JTextField(10);
              panel.add(new JLabel("First Name:"));
              panel.add(firstNameField);
              
              
              addressField = new JTextField(10);
              panel.add(new JLabel("Address:"));
              panel.add(addressField);
              
              cityField = new JTextField(10);
              panel.add(new JLabel("City:"));
              panel.add(cityField);
              
              zipField = new JTextField(5);
              panel.add(new JLabel("Zip:"));
              panel.add(zipField);
              
              stateField = new JTextField(5);
              panel.add(new JLabel("State:"));
              panel.add(stateField);
              
              addButton = new JButton("Add");
              exitButton = new JButton("Exit");
              panel.add(addButton);
              panel.add(exitButton);
              add(panel);
              
              this.setSize(200,200);
              this.setVisible(true);
              
              addButton.addActionListener(new ActionListener(){
                     public void actionPerformed(ActionEvent e) {
                            Borrower borrower = new Borrower();
                            borrower.setLastName(lastNameField.getText());
                            borrower.setFirstName(firstNameField.getText());
                            borrower.setAddress(addressField.getText());
                            borrower.setCity(cityField.getText());
                            borrower.setZip(zipField.getText());
                            borrower.setState(stateField.getText());
                            InsertBorrowerController controller = new InsertBorrowerController();
                            controller.execute(borrower);
                     }
              });
              exitButton.addActionListener(new ActionListener(){
                     public void actionPerformed(ActionEvent e) {
                            InsertBorrowerDialog.this.setVisible(false);