基于JavaWeb的电影售票系统

package SonView; import java.awt.EventQueue; import java.awt.Font; import java.awt.Toolkit; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.sql.SQLException; import java.util.List; import javax.swing.GroupLayout; import javax.swing.GroupLayout.Alignment; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.LayoutStyle.ComponentPlacement; import javax.swing.table.DefaultTableModel; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.BeanListHandler; import Pojo.Book; import Pojo.Mybook; import SonBooks.UpdateBook; import tools.JDBCUtils; import tools.ListTableModel; import java.awt.Color; import javax.swing.JScrollBar; import javax.swing.JToggleButton; import javax.swing.JList; import javax.swing.JScrollPane; public class Books { public JFrame frame; protected static JTable table; private JButton button_1; private JLabel label; private JTextField textField; private JButton button_2; /** * Launch the application. */ public static void main(String[] args) { EventQueue.invokeLater(new Runnable() { public void run() { try { Books window = new Books(); window.frame.setVisible(true); } catch (Exception e) { e.printStackTrace(); } try { QueryAll(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }); } /** * Create the application. */ public Books() { initialize(); } /** * Initialize the contents of the frame. */ private void initialize() { frame = new JFrame(); frame.setResizable(false); frame.setLocationRelativeTo(null); frame.setTitle("书籍借阅系统"); frame.setIconImage(Toolkit.getDefaultToolkit().getImage("C:\\Users\\Xu\\eclipse-workspace\\Library\\book.jpg")); frame.setBounds(100, 100, 933, 464); frame.setLocationRelativeTo(null); table = new JTable(); table.setBounds(14, 92, 869, 247); JButton button = new JButton("捐赠书籍"); button.setFont(new Font("华文楷体", Font.PLAIN, 20)); button.setBounds(360, 352, 175, 64); button.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { SonBooks.Add.main(null); } }); button.setBackground(new Color(255, 228, 225)); button_1 = new JButton("借阅书籍"); button_1.setFont(new Font("华文楷体", Font.PLAIN, 20)); button_1.setBounds(14, 352, 175, 64); button_1.setBackground(new Color(255, 228, 225)); button_1.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { try { QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource()); int row = table.getSelectedRow(); Book book = getSortByTableRow(row); int I = qr.update("DELETE FROM books WHERE GoodsCode=?",book.getGoodsCode()); int r = qr.update("INSERT INTO mybook VALUES(?,?,?,?)",book.getGoodsCode(),book.getGoodsName(),book.getPrice(),book.getStock()); List<Book> books = qr.query("SELECT * FROM books ", new BeanListHandler<Book>(Book.class)); setTableModel(books); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } }); label = new JLabel("书籍名称："); label.setBounds(180, 13, 107, 34); label.setFont(new Font("宋体", Font.PLAIN, 20)); textField = new JTextField(); textField.setBounds(301, 20, 216, 24); textField.setColumns(10); JButton btnNewButton = new JButton("查询书籍"); btnNewButton.setFont(new Font("华文楷体", Font.PLAIN, 20)); btnNewButton.setBounds(568, 15, 151, 34); btnNewButton.setBackground(new Color(255, 228, 225)); btnNewButton.addMouseListener(new MouseAdapter() { @Override public void mouseClicked(MouseEvent e) { QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource()); try { String bookname = textField.getText().trim(); if(bookname.isEmpty()) { List<Book> books = qr.query("SELECT * FROM books ", new BeanListHandler<Book>(Book.class)); setTableModel(books); } else { List<Book> books = qr.query("SELECT * FROM books WHERE goodsName LIKE '%"+bookname+"%'", new BeanListHandler<Book>(Book.class)); setTableModel(books); } textField.setText(null); } catch (SQLException e1) { e1.printStackTrace(); } } }); button_2 = new JButton("返回"); button_2.setFont(new Font("华文楷体", Font.PLAIN, 20)); button_2.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { } }); button_2.setBounds(708, 352, 175, 64); button_2.setBackground(new Color(255, 228, 225)); button_2.addMouseListener(new MouseAdapter() { @Override public void mouseClicked(MouseEvent e) { frame.setVisible(false); } }); JButton btnNewButton_1 = new JButton("书籍ID"); btnNewButton_1.setFont(new Font("华文新魏", Font.PLAIN, 18)); btnNewButton_1.setBounds(14, 65, 216, 27); frame.getContentPane().setLayout(null); frame.getContentPane().add(btnNewButton_1); frame.getContentPane().add(label); frame.getContentPane().add(textField); frame.getContentPane().add(btnNewButton); frame.getContentPane().add(table); frame.getContentPane().add(button_1); frame.getContentPane().add(button); frame.getContentPane().add(button_2); JButton btnNewButton_1_1 = new JButton("书籍名称"); btnNewButton_1_1.setFont(new Font("华文新魏", Font.PLAIN, 18)); btnNewButton_1_1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { } }); btnNewButton_1_1.setBounds(231, 65, 216, 27); frame.getContentPane().add(btnNewButton_1_1); JButton btnNewButton_1_2 = new JButton("书籍价格"); btnNewButton_1_2.setFont(new Font("华文新魏", Font.PLAIN, 18)); btnNewButton_1_2.setBounds(446, 65, 216, 27); frame.getContentPane().add(btnNewButton_1_2); JButton btnNewButton_1_3 = new JButton("书籍数量"); btnNewButton_1_3.setFont(new Font("华文新魏", Font.PLAIN, 18)); btnNewButton_1_3.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { } }); btnNewButton_1_3.setBounds(661, 65, 222, 27); frame.getContentPane().add(btnNewButton_1_3); } protected static void setTableModel(List<Book> sortList) { String[] colNames = new String[] {"书籍ID", "书籍名称", "价格", "数量"}; String[] propNames = new String[] {"goodsCode", "goodsName", "price", "stock"}; if(sortList == null || sortList.size() == 0) { table.setModel(new DefaultTableModel(new Object[][] { {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null} },colNames)); table.setEnabled(false); return; } try { table.setModel(new ListTableModel<Book>(sortList, Book.class, colNames, propNames)); table.setEnabled(true); } catch (Exception e) { e.printStackTrace(); } } protected Book getSortByTableRow(int row) { return ((ListTableModel<Book>)table.getModel()).getInstance(row); } public static void QueryAll() throws SQLException { QueryRunner qr = new QueryRunner(JD