Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this license header, choose License Headers in Project Properties.
- * To change this template file, choose Tools | Templates
- * and open the template in the editor.
- */
- package theatre;
- import java.awt.event.ActionEvent;
- import javax.swing.JButton;
- import javax.swing.JFileChooser;
- import javax.swing.JOptionPane;
- import javax.swing.filechooser.FileFilter;
- import javax.swing.filechooser.FileNameExtensionFilter;
- import java.sql.*;
- import java.util.logging.Level;
- import java.util.logging.Logger;
- import javax.swing.JTable;
- /**
- *
- * @author KitjakarnNisit-02
- */
- public class manageMovie extends javax.swing.JFrame {
- Connection connect;
- /**
- * Creates new form manageMovie
- */
- public manageMovie() throws Exception{
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/theatre","root","");
- initComponents();
- }
- private String id,ti,ra,du,pict;
- /**
- * This method is called from within the constructor to initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is always
- * regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- bindingGroup = new org.jdesktop.beansbinding.BindingGroup();
- entityManager = java.beans.Beans.isDesignTime() ? null : javax.persistence.Persistence.createEntityManagerFactory("theatre?zeroDateTimeBehavior=convertToNullPU").createEntityManager();
- ticketQuery = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT t FROM Ticket t");
- ticketList = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : ticketQuery.getResultList();
- movieQuery = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT m FROM Movie m");
- movieList = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : movieQuery.getResultList();
- movieQuery1 = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT m FROM Movie m");
- movieList1 = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : movieQuery1.getResultList();
- jButton2 = new javax.swing.JButton();
- try {
- jButton1 =(javax.swing.JButton)java.beans.Beans.instantiate(getClass().getClassLoader(), "theatre.Admin_jButton1");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- } catch (java.io.IOException e) {
- e.printStackTrace();
- }
- IDin = new javax.swing.JTextField();
- jLabel7 = new javax.swing.JLabel();
- back = new javax.swing.JButton();
- try {
- jButton3 =(javax.swing.JButton)java.beans.Beans.instantiate(getClass().getClassLoader(), "theatre.Admin_jButton1");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- } catch (java.io.IOException e) {
- e.printStackTrace();
- }
- jLabel14 = new javax.swing.JLabel();
- IDde = new javax.swing.JTextField();
- jLabel13 = new javax.swing.JLabel();
- jLabel8 = new javax.swing.JLabel();
- jLabel15 = new javax.swing.JLabel();
- IDed1 = new javax.swing.JTextField();
- try {
- jButton4 =(javax.swing.JButton)java.beans.Beans.instantiate(getClass().getClassLoader(), "theatre.Admin_jButton1");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- } catch (java.io.IOException e) {
- e.printStackTrace();
- }
- jLabel12 = new javax.swing.JLabel();
- title = new javax.swing.JTextField();
- jLabel3 = new javax.swing.JLabel();
- duration = new javax.swing.JTextField();
- jLabel4 = new javax.swing.JLabel();
- rate = new javax.swing.JComboBox<>();
- jLabel60 = new javax.swing.JLabel();
- pic = new javax.swing.JTextField();
- picbut1 = new javax.swing.JButton();
- jLabel62 = new javax.swing.JLabel();
- jLabel6 = new javax.swing.JLabel();
- jScrollPane1 = new javax.swing.JScrollPane();
- jTable1 = new javax.swing.JTable();
- jLabel1 = new javax.swing.JLabel();
- setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
- setTitle("Manage Movie");
- setMaximumSize(new java.awt.Dimension(1280, 760));
- setMinimumSize(new java.awt.Dimension(1280, 760));
- setPreferredSize(new java.awt.Dimension(1280, 760));
- setResizable(false);
- setSize(new java.awt.Dimension(600, 800));
- getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
- jButton2.setFont(new java.awt.Font("Segoe UI", 1, 18)); // NOI18N
- jButton2.setText("Clear");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton2, new org.netbeans.lib.awtextra.AbsoluteConstraints(290, 360, -1, -1));
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton1, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 360, 70, 40));
- IDin.setFont(new java.awt.Font("Segoe UI", 0, 16)); // NOI18N
- getContentPane().add(IDin, new org.netbeans.lib.awtextra.AbsoluteConstraints(90, 220, 180, -1));
- jLabel7.setFont(new java.awt.Font("Segoe UI", 1, 36)); // NOI18N
- jLabel7.setForeground(new java.awt.Color(255, 255, 204));
- jLabel7.setText("Delete");
- getContentPane().add(jLabel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 410, -1, -1));
- back.setFont(new java.awt.Font("Segoe UI", 1, 18)); // NOI18N
- back.setText("Back");
- back.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- backActionPerformed(evt);
- }
- });
- getContentPane().add(back, new org.netbeans.lib.awtextra.AbsoluteConstraints(1190, 710, -1, -1));
- jButton3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton3ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton3, new org.netbeans.lib.awtextra.AbsoluteConstraints(280, 470, 80, 40));
- jLabel14.setFont(new java.awt.Font("Segoe UI", 1, 18)); // NOI18N
- jLabel14.setForeground(new java.awt.Color(255, 255, 204));
- jLabel14.setText("ID:");
- jLabel14.setPreferredSize(new java.awt.Dimension(24, 30));
- getContentPane().add(jLabel14, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 470, 50, -1));
- IDde.setFont(new java.awt.Font("Segoe UI", 0, 16)); // NOI18N
- IDde.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- IDdeActionPerformed(evt);
- }
- });
- getContentPane().add(IDde, new org.netbeans.lib.awtextra.AbsoluteConstraints(90, 470, 180, -1));
- jLabel13.setFont(new java.awt.Font("Segoe UI", 1, 18)); // NOI18N
- jLabel13.setForeground(new java.awt.Color(255, 255, 204));
- jLabel13.setText("ID:");
- jLabel13.setPreferredSize(new java.awt.Dimension(24, 30));
- getContentPane().add(jLabel13, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 220, 50, -1));
- jLabel8.setFont(new java.awt.Font("Segoe UI", 1, 36)); // NOI18N
- jLabel8.setForeground(new java.awt.Color(255, 255, 204));
- jLabel8.setText("Edit");
- getContentPane().add(jLabel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 560, -1, -1));
- jLabel15.setFont(new java.awt.Font("Segoe UI", 1, 18)); // NOI18N
- jLabel15.setForeground(new java.awt.Color(255, 255, 204));
- jLabel15.setText("ID:");
- jLabel15.setPreferredSize(new java.awt.Dimension(24, 30));
- getContentPane().add(jLabel15, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 620, 50, -1));
- IDed1.setFont(new java.awt.Font("Segoe UI", 0, 16)); // NOI18N
- IDed1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- IDed1ActionPerformed(evt);
- }
- });
- getContentPane().add(IDed1, new org.netbeans.lib.awtextra.AbsoluteConstraints(90, 620, 180, -1));
- jButton4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton4ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton4, new org.netbeans.lib.awtextra.AbsoluteConstraints(280, 620, 80, 40));
- jLabel12.setFont(new java.awt.Font("Segoe UI", 1, 18)); // NOI18N
- jLabel12.setForeground(new java.awt.Color(255, 255, 204));
- jLabel12.setText("Title:");
- jLabel12.setPreferredSize(new java.awt.Dimension(24, 30));
- getContentPane().add(jLabel12, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 260, 50, -1));
- title.setFont(new java.awt.Font("Segoe UI", 0, 16)); // NOI18N
- getContentPane().add(title, new org.netbeans.lib.awtextra.AbsoluteConstraints(90, 260, 420, -1));
- jLabel3.setFont(new java.awt.Font("Segoe UI", 1, 18)); // NOI18N
- jLabel3.setForeground(new java.awt.Color(255, 255, 204));
- jLabel3.setText("Duration:");
- jLabel3.setPreferredSize(new java.awt.Dimension(45, 30));
- getContentPane().add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 300, 90, -1));
- duration.setFont(new java.awt.Font("Segoe UI", 0, 16)); // NOI18N
- duration.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- durationActionPerformed(evt);
- }
- });
- getContentPane().add(duration, new org.netbeans.lib.awtextra.AbsoluteConstraints(130, 300, 100, -1));
- jLabel4.setFont(new java.awt.Font("Segoe UI", 1, 18)); // NOI18N
- jLabel4.setForeground(new java.awt.Color(255, 255, 204));
- jLabel4.setText("Rate:");
- jLabel4.setPreferredSize(new java.awt.Dimension(27, 30));
- getContentPane().add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(290, 220, 80, -1));
- rate.setFont(new java.awt.Font("Segoe UI", 0, 16)); // NOI18N
- rate.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "G", "PG", "PG-13", "R", "NC-17" }));
- rate.setPreferredSize(new java.awt.Dimension(56, 30));
- rate.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- rateActionPerformed(evt);
- }
- });
- getContentPane().add(rate, new org.netbeans.lib.awtextra.AbsoluteConstraints(350, 220, 160, -1));
- jLabel60.setFont(new java.awt.Font("Segoe UI", 1, 18)); // NOI18N
- jLabel60.setForeground(new java.awt.Color(255, 255, 204));
- jLabel60.setText("Add Picture:");
- getContentPane().add(jLabel60, new org.netbeans.lib.awtextra.AbsoluteConstraints(260, 300, -1, -1));
- pic.setEditable(false);
- pic.setFont(new java.awt.Font("Segoe UI", 0, 16)); // NOI18N
- pic.setText("No Attached File ...");
- getContentPane().add(pic, new org.netbeans.lib.awtextra.AbsoluteConstraints(370, 300, 140, 30));
- picbut1.setFont(new java.awt.Font("Segoe UI", 1, 18)); // NOI18N
- picbut1.setText("...");
- picbut1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- picbut1ActionPerformed(evt);
- }
- });
- getContentPane().add(picbut1, new org.netbeans.lib.awtextra.AbsoluteConstraints(510, 299, -1, -1));
- jLabel62.setFont(new java.awt.Font("Segoe UI", 1, 16)); // NOI18N
- jLabel62.setForeground(new java.awt.Color(255, 255, 204));
- jLabel62.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
- jLabel62.setText("(Please use 223*315 pixcel)");
- getContentPane().add(jLabel62, new org.netbeans.lib.awtextra.AbsoluteConstraints(360, 330, -1, 20));
- jLabel6.setFont(new java.awt.Font("Segoe UI", 1, 36)); // NOI18N
- jLabel6.setForeground(new java.awt.Color(255, 255, 204));
- jLabel6.setText("Insert");
- getContentPane().add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 160, -1, -1));
- org.jdesktop.swingbinding.JTableBinding jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, movieList1, jTable1);
- org.jdesktop.swingbinding.JTableBinding.ColumnBinding columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${id}"));
- columnBinding.setColumnName("Id");
- columnBinding.setColumnClass(Integer.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${title}"));
- columnBinding.setColumnName("Title");
- columnBinding.setColumnClass(String.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${duration}"));
- columnBinding.setColumnName("Duration");
- columnBinding.setColumnClass(String.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${rate}"));
- columnBinding.setColumnName("Rate");
- columnBinding.setColumnClass(String.class);
- bindingGroup.addBinding(jTableBinding);
- jTableBinding.bind();
- jScrollPane1.setViewportView(jTable1);
- getContentPane().add(jScrollPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(590, 140, -1, -1));
- jLabel1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/theatre/managemovie.png"))); // NOI18N
- jLabel1.setText("jLabel1");
- getContentPane().add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(-10, 10, -1, -1));
- bindingGroup.bind();
- pack();
- setLocationRelativeTo(null);
- }// </editor-fold>
- private void backActionPerformed(java.awt.event.ActionEvent evt) {
- this.dispose();
- }
- private void durationActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void rateActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- public String addPic(){
- String s = null;
- JFileChooser fileopen = new JFileChooser();
- FileFilter filter = new FileNameExtensionFilter("Picture file", "png", "jpg","jpeg","tif","gif");
- fileopen.addChoosableFileFilter(filter);
- int ret = fileopen.showDialog(null, "Choose file");
- if (ret == JFileChooser.APPROVE_OPTION)
- s = fileopen.getSelectedFile().toString();
- return s;
- }
- private void picbut1ActionPerformed(java.awt.event.ActionEvent evt) {
- pic.setText(addPic());
- pict=pic.getText();
- }
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- try {
- id=IDin.getText();
- du=duration.getText();
- ra=(String)rate.getSelectedItem();
- ti=title.getText();
- Statement ins = connect.createStatement();
- ins.executeUpdate("INSERT INTO `movie` (`id`, `title`, `duration`, `rate`) VALUES (' "+id+" ', '"+ti+"', ' "+du+" ', ' "+ra+" ')");
- connect.close();
- this.dispose();
- manageMovie g = new manageMovie();
- g.setVisible(true);
- System.out.println(id);
- } catch (SQLException ex) {
- System.out.println("แอด id ซ้ำไม่ได้");
- } catch (Exception ex) {
- Logger.getLogger(manageMovie.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- title.setText(null);
- duration.setText(null);
- rate.setSelectedIndex(0);
- IDin.setText(null);
- pic.setText("No Attached File ...");
- }
- public void actionPerformed(ActionEvent e) {
- int n = JOptionPane.showConfirmDialog(null,
- "I really like my book",
- "Question (application-modal dialog)",
- JOptionPane.YES_NO_OPTION,
- JOptionPane.QUESTION_MESSAGE);
- }
- private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
- try {
- String id = IDde.getText();
- int n = JOptionPane.showConfirmDialog(null,
- ("Delete!! "+id),
- "Delete",
- JOptionPane.YES_NO_OPTION,
- JOptionPane.QUESTION_MESSAGE);
- Statement ins = connect.createStatement();
- ins.executeUpdate("DELETE FROM `movie` WHERE id = '"+id+"' ");
- connect.close();
- this.dispose();
- manageMovie g = new manageMovie();
- g.setVisible(true);
- } catch (SQLException ex) {
- System.out.println("หา id บ่ป้ะเจ้า");
- } catch (Exception ex) {
- Logger.getLogger(manageMovie.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
- try {
- String id = IDed1.getText();
- System.out.println(id);
- PreparedStatement ps = connect.prepareStatement(" SELECT * FROM `movie` WHERE id = '"+id+"' ");
- ResultSet result = ps.executeQuery();
- result.next();
- if(!result.getString("title").equals("")){
- EditMovie g = new EditMovie(id,connect,this);
- g.dispose();
- g.setVisible(true);
- }
- ps.close();
- } catch (Exception ex) {
- System.out.println("หาไม่เจอเจ้า");
- }
- }
- private void IDed1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void IDdeActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- /* Set the Nimbus look and feel */
- //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
- /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
- * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
- */
- try {
- for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
- if ("Nimbus".equals(info.getName())) {
- javax.swing.UIManager.setLookAndFeel(info.getClassName());
- break;
- }
- }
- } catch (ClassNotFoundException ex) {
- java.util.logging.Logger.getLogger(manageMovie.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (InstantiationException ex) {
- java.util.logging.Logger.getLogger(manageMovie.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (IllegalAccessException ex) {
- java.util.logging.Logger.getLogger(manageMovie.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (javax.swing.UnsupportedLookAndFeelException ex) {
- java.util.logging.Logger.getLogger(manageMovie.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- }
- //</editor-fold>
- /* Create and display the form */
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- try {
- new manageMovie().setVisible(true);
- } catch (Exception ex) {
- Logger.getLogger(manageMovie.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JTextField IDde;
- private javax.swing.JTextField IDed1;
- private javax.swing.JTextField IDin;
- private javax.swing.JButton back;
- private javax.swing.JTextField duration;
- private javax.persistence.EntityManager entityManager;
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton2;
- public javax.swing.JButton jButton3;
- public javax.swing.JButton jButton4;
- private javax.swing.JLabel jLabel1;
- private javax.swing.JLabel jLabel12;
- private javax.swing.JLabel jLabel13;
- private javax.swing.JLabel jLabel14;
- private javax.swing.JLabel jLabel15;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JLabel jLabel6;
- private javax.swing.JLabel jLabel60;
- private javax.swing.JLabel jLabel62;
- private javax.swing.JLabel jLabel7;
- private javax.swing.JLabel jLabel8;
- private javax.swing.JScrollPane jScrollPane1;
- private javax.swing.JTable jTable1;
- private java.util.List<theatre.Movie> movieList;
- private java.util.List<theatre.Movie> movieList1;
- private javax.persistence.Query movieQuery;
- private javax.persistence.Query movieQuery1;
- private javax.swing.JTextField pic;
- private javax.swing.JButton picbut1;
- private javax.swing.JComboBox<String> rate;
- private java.util.List<theatre.Ticket> ticketList;
- private javax.persistence.Query ticketQuery;
- private javax.swing.JTextField title;
- private org.jdesktop.beansbinding.BindingGroup bindingGroup;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement