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 Employees;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.sql.ResultSet;
- import javax.swing.JOptionPane;
- import javax.swing.JTable;
- import javax.swing.table.DefaultTableModel;
- import net.proteanit.sql.DbUtils;
- /**
- *
- * @author Jocke
- */
- public class JFrame1 extends javax.swing.JFrame {
- Connection con;
- Statement stmt;
- ResultSet rs;
- private String RadNr = null;
- private int row;
- int catchInt = 0;
- public JFrame1() {
- initComponents();
- DoConnect();
- uppdateraArende();
- }
- public void uppdateraArende()
- {
- try
- {
- Connection con = DriverManager.getConnection("jdbc:derby://localhost:1527/ArendeBase","APP","APP");
- String query = "SELECT * FROM arende";
- PreparedStatement pst = con.prepareStatement(query);
- ResultSet rs = pst.executeQuery();
- jTable1.setModel(DbUtils.resultSetToTableModel(rs));
- pst.close();
- rs.close();
- }
- catch(Exception e){
- e.printStackTrace();
- }
- }
- public void DoConnect( )
- {
- try
- {
- //CONNECT TO THE DATABASE
- String host = "jdbc:derby://localhost:1527/ArendeBase";
- String uName = "APP";
- String uPass= "APP";
- Connection con = DriverManager.getConnection(host, uName, uPass);
- //EXECUTE SOME SQL AND LOAD THE RECORDS INTO THE RESULTSET
- stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
- String sql = "SELECT * FROM arende";
- rs = stmt.executeQuery(sql);
- rs.next();
- }
- catch ( SQLException err )
- {
- JOptionPane.showMessageDialog(JFrame1.this, err.getMessage());
- }
- }
- /**
- * 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();
- ArendeBasePUEntityManager = java.beans.Beans.isDesignTime() ? null : javax.persistence.Persistence.createEntityManagerFactory("ArendeBasePU").createEntityManager();
- arendeQuery = java.beans.Beans.isDesignTime() ? null : ArendeBasePUEntityManager.createQuery("SELECT a FROM Arende a");
- arendeList = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : arendeQuery.getResultList();
- arendeQuery1 = java.beans.Beans.isDesignTime() ? null : ArendeBasePUEntityManager.createQuery("SELECT a FROM Arende a");
- arendeList1 = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : arendeQuery1.getResultList();
- jPanel1 = new javax.swing.JPanel();
- textLedare = new javax.swing.JTextField();
- textKategori = new javax.swing.JTextField();
- textRegDatum = new javax.swing.JTextField();
- textBudTid = new javax.swing.JTextField();
- textBeskrivning = new javax.swing.JTextField();
- textStatus = new javax.swing.JTextField();
- jLabel1 = new javax.swing.JLabel();
- jLabel2 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jLabel4 = new javax.swing.JLabel();
- jLabel5 = new javax.swing.JLabel();
- jLabel6 = new javax.swing.JLabel();
- btnUppdatera = new javax.swing.JButton();
- btnSkapa = new javax.swing.JButton();
- btnTaBort = new javax.swing.JButton();
- jScrollPane1 = new javax.swing.JScrollPane();
- jTable1 = new javax.swing.JTable();
- textRegTid = new javax.swing.JTextField();
- jLabel7 = new javax.swing.JLabel();
- jLabel8 = new javax.swing.JLabel();
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- jLabel1.setText("Processledare*");
- jLabel2.setText("Kategori*");
- jLabel3.setText("Beskrivning*");
- jLabel4.setText("RegDatum(YYYY-MM-DD)*");
- jLabel5.setText("Budgetterad tid*");
- jLabel6.setText("Status");
- btnUppdatera.setText("Ändra ärende");
- btnUppdatera.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- btnUppdateraActionPerformed(evt);
- }
- });
- btnSkapa.setText("Skapa ärende");
- btnSkapa.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- btnSkapaActionPerformed(evt);
- }
- });
- btnTaBort.setText("Ta bort");
- btnTaBort.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- btnTaBortActionPerformed(evt);
- }
- });
- org.jdesktop.swingbinding.JTableBinding jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, arendeList, jTable1);
- org.jdesktop.swingbinding.JTableBinding.ColumnBinding columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${arendenr}"));
- columnBinding.setColumnName("Arendenr");
- columnBinding.setColumnClass(Integer.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${processledare}"));
- columnBinding.setColumnName("Processledare");
- columnBinding.setColumnClass(String.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${kategori}"));
- columnBinding.setColumnName("Kategori");
- columnBinding.setColumnClass(String.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${regdatum}"));
- columnBinding.setColumnName("Regdatum");
- columnBinding.setColumnClass(java.util.Date.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${budgetteradtid}"));
- columnBinding.setColumnName("Budgetteradtid");
- columnBinding.setColumnClass(String.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${beskrivning}"));
- columnBinding.setColumnName("Beskrivning");
- columnBinding.setColumnClass(String.class);
- columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${status}"));
- columnBinding.setColumnName("Status");
- columnBinding.setColumnClass(String.class);
- bindingGroup.addBinding(jTableBinding);
- jTableBinding.bind();
- jScrollPane1.setViewportView(jTable1);
- jLabel7.setText("Registrerad tid");
- jLabel8.setText("* Textfält som måste vara ifyllda");
- javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
- jPanel1.setLayout(jPanel1Layout);
- jPanel1Layout.setHorizontalGroup(
- jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
- .addContainerGap()
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 583, Short.MAX_VALUE)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jLabel1)
- .addComponent(jLabel2, javax.swing.GroupLayout.Alignment.TRAILING)
- .addComponent(jLabel3, javax.swing.GroupLayout.Alignment.TRAILING))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
- .addComponent(textBeskrivning, javax.swing.GroupLayout.DEFAULT_SIZE, 61, Short.MAX_VALUE)
- .addComponent(textKategori)
- .addComponent(textLedare))
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
- .addComponent(jLabel5)
- .addComponent(jLabel4)
- .addComponent(jLabel6))
- .addGap(18, 18, 18)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
- .addComponent(textBudTid)
- .addComponent(textRegDatum, javax.swing.GroupLayout.DEFAULT_SIZE, 85, Short.MAX_VALUE)
- .addComponent(textStatus))
- .addGap(18, 18, 18)
- .addComponent(jLabel7)
- .addGap(18, 18, 18)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(textRegTid)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(btnSkapa)
- .addComponent(btnUppdatera))
- .addGap(0, 0, Short.MAX_VALUE))))
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGap(45, 45, 45)
- .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 226, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(0, 0, Short.MAX_VALUE)))))
- .addGap(18, 18, 18)
- .addComponent(btnTaBort)
- .addGap(74, 74, 74))
- );
- jPanel1Layout.setVerticalGroup(
- jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGap(33, 33, 33)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel1)
- .addComponent(textLedare, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGap(33, 33, 33)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel2)
- .addComponent(textKategori, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGap(33, 33, 33)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel3)
- .addComponent(textBeskrivning, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(jLabel6)
- .addComponent(textStatus, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(btnSkapa)))
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel4)
- .addComponent(textRegDatum, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(textRegTid, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(jLabel7))
- .addGap(32, 32, 32)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(textBudTid, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(jLabel5)
- .addComponent(btnUppdatera))))
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGap(161, 161, 161)
- .addComponent(btnTaBort)
- .addContainerGap(167, Short.MAX_VALUE))
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGap(11, 11, 11)
- .addComponent(jLabel8)
- .addGap(11, 11, 11)
- .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
- .addContainerGap())))
- );
- javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
- getContentPane().setLayout(layout);
- layout.setHorizontalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- );
- bindingGroup.bind();
- pack();
- }// </editor-fold>
- private void btnUppdateraActionPerformed(java.awt.event.ActionEvent evt) {
- int row = jTable1.getSelectedRow();
- String catchString = (jTable1.getModel().getValueAt(row, 0).toString());
- catchInt = Integer.parseInt(catchString);
- String ledare = textLedare.getText( );
- String kategori = textKategori.getText( );
- String regdatum = textRegDatum.getText( );
- String budgetteradtid = textBudTid.getText( );
- String beskrivning = textBeskrivning.getText( );
- String status = textStatus.getText( );
- String regtid = textRegTid.getText( );
- try
- {
- String host = "jdbc:derby://localhost:1527/ArendeBase";
- String uName = "APP";
- String uPass= "APP";
- Connection con = DriverManager.getConnection(host, uName, uPass);
- //EXECUTE SOME SQL AND LOAD THE RECORDS INTO THE RESULTSET
- stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
- String sqlUpdate = "UPDATE arende SET processledare ='"+ ledare +"', kategori ='"+ kategori +"', regdatum ='"+ regdatum +"', budgetteradtid ='"+ budgetteradtid +"', beskrivning ='"+ beskrivning +"', status ='"+ status +"', registreradtid ='"+ regtid +"' WHERE arendenr="+ catchInt +"";
- stmt.executeUpdate(sqlUpdate);
- JOptionPane.showMessageDialog(JFrame1.this, "Updated");
- }
- catch (SQLException err)
- {
- System.out.println(err.getMessage() );
- }
- uppdateraArende();
- }
- private void btnSkapaActionPerformed(java.awt.event.ActionEvent evt) {
- String ledare = textLedare.getText( );
- String kategori = textKategori.getText( );
- String regdatum = textRegDatum.getText( );
- String budgetteradtid = textBudTid.getText( );
- String beskrivning = textBeskrivning.getText( );
- String status = textStatus.getText( );
- String regtid = textRegTid.getText( );
- try
- {
- rs.moveToInsertRow( );
- rs.updateString( "processledare", ledare);
- rs.updateString( "kategori", kategori );
- rs.updateString( "regdatum", regdatum );
- rs.updateString( "budgetteradtid", budgetteradtid );
- rs.updateString( "beskrivning", beskrivning );
- rs.updateString( "status", status );
- rs.updateString( "registreradtid", regtid );
- rs.insertRow( );
- while ( rs.next( ) ) {
- int id_arendenummer = rs.getInt("arendenr");
- String arendenummer = Integer.toString(id_arendenummer);
- ledare = rs.getString("processledare");
- kategori = rs.getString("kategori");
- regdatum = rs.getString("regdatum");
- budgetteradtid = rs.getString("budgetteradtid");
- beskrivning = rs.getString("beskrivning");
- status = rs.getString("status");
- regtid = rs.getString("registreradtid");
- }
- stmt.close( );
- rs.close( );
- }
- catch(SQLException err)
- {
- System.out.println(err.getMessage());
- }
- JOptionPane.showMessageDialog(JFrame1.this, "Ärende skapat");
- uppdateraArende();
- }
- private void btnTaBortActionPerformed(java.awt.event.ActionEvent evt) {
- int row = jTable1.getSelectedRow();
- String catchString = (jTable1.getModel().getValueAt(row, 0).toString());
- int catchInt = Integer.parseInt(catchString);
- try
- {
- String host = "jdbc:derby://localhost:1527/ArendeBase";
- String uName = "APP";
- String uPass= "APP";
- Connection con = DriverManager.getConnection(host, uName, uPass);
- //EXECUTE SOME SQL AND LOAD THE RECORDS INTO THE RESULTSET
- stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
- String sqlUpdate = "DELETE FROM arende WHERE arendenr="+ catchInt +"";
- stmt.executeUpdate(sqlUpdate);
- JOptionPane.showMessageDialog(JFrame1.this, "Deleted");
- }
- catch (SQLException err)
- {
- System.out.println(err.getMessage() );
- }
- uppdateraArende();
- }
- /**
- * @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(JFrame1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (InstantiationException ex) {
- java.util.logging.Logger.getLogger(JFrame1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (IllegalAccessException ex) {
- java.util.logging.Logger.getLogger(JFrame1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (javax.swing.UnsupportedLookAndFeelException ex) {
- java.util.logging.Logger.getLogger(JFrame1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- }
- //</editor-fold>
- //</editor-fold>
- /* Create and display the form */
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new JFrame1().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.persistence.EntityManager ArendeBasePUEntityManager;
- private java.util.List<Employees.Arende> arendeList;
- private java.util.List<Employees.Arende> arendeList1;
- private javax.persistence.Query arendeQuery;
- private javax.persistence.Query arendeQuery1;
- private javax.swing.JButton btnSkapa;
- private javax.swing.JButton btnTaBort;
- private javax.swing.JButton btnUppdatera;
- private javax.swing.JLabel jLabel1;
- private javax.swing.JLabel jLabel2;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JLabel jLabel5;
- private javax.swing.JLabel jLabel6;
- private javax.swing.JLabel jLabel7;
- private javax.swing.JLabel jLabel8;
- private javax.swing.JPanel jPanel1;
- private javax.swing.JScrollPane jScrollPane1;
- private javax.swing.JTable jTable1;
- private javax.swing.JTextField textBeskrivning;
- private javax.swing.JTextField textBudTid;
- private javax.swing.JTextField textKategori;
- private javax.swing.JTextField textLedare;
- private javax.swing.JTextField textRegDatum;
- private javax.swing.JTextField textRegTid;
- private javax.swing.JTextField textStatus;
- private org.jdesktop.beansbinding.BindingGroup bindingGroup;
- // End of variables declaration
- /**
- * @return the RadNr
- */
- public String getRadNr() {
- return RadNr;
- }
- /**
- * @param RadNr the RadNr to set
- */
- public void setRadNr(String RadNr) {
- this.RadNr = RadNr;
- }
- /**
- * @return the row
- */
- public int getRow() {
- return row;
- }
- /**
- * @param row the row to set
- */
- public void setRow(int row) {
- this.row = row;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement