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 db;
- import com.mysql.jdbc.Connection;
- import com.mysql.jdbc.Statement;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.logging.Level;
- import java.util.logging.Logger;
- import javax.swing.UIManager;
- /**
- *
- * @author qasko
- */
- public final class MyFrame extends javax.swing.JFrame {
- String driver = "com.mysql.jdbc.Driver";
- Connection con = null;
- Statement stmt = null;
- ResultSet rs = null;
- String userName = "root";
- String password = "";
- String URL = "jdbc:mysql://localhost/mydb";
- int pocetRiadkov = 0;
- String createString = "CREATE TABLE IF NOT EXISTS zoznam " + "(ID INT UNSIGNED NOT NULL " + "AUTO_INCREMENT, " + "PRIMARY KEY (id), " + "meno VARCHAR (10), " + "priezvisko VARCHAR (10), " + "plat INTEGER)";
- String demoData = "INSERT INTO Zoznam (Meno,Priezvisko,Plat) VALUES ('Jano','Mrkva',550)";
- String avgPlat;
- String pocet;
- /**
- * Creates new form MyFrame
- */
- public MyFrame() {
- if (PripojenieKuMySQL()) {
- initComponents();
- if (NastavResultSet("Select * from zoznam")) {
- System.out.println("ok");
- }
- } else {
- System.out.println("error");
- }
- }
- public Boolean PripojenieKuMySQL() {
- try {
- Class.forName(driver);
- con = (Connection) DriverManager.getConnection(URL, userName, password);
- } catch (ClassNotFoundException | SQLException e) {
- System.out.println(e);
- return false; // nastala chyba
- }
- return true; // vsetko je ok
- }
- public Boolean NastavResultSet(String Prikaz) {
- try {
- stmt = (Statement) con.createStatement();
- rs = stmt.executeQuery(Prikaz);
- // skoc na koniec, vrat poradove cislo riadku
- rs.last();
- pocetRiadkov = rs.getRow();
- // nastav zase na zaciatok
- rs.beforeFirst();
- NacitajDalsiZaznam();
- } catch (SQLException e) {
- System.out.println(e);
- return false; // vynimka => chyba
- }
- return true;
- }
- public void NacitajDalsiZaznam() {
- try {
- if (!rs.isLast()) { // ak nie je koniec
- rs.next(); // posun sa
- NaplnPolia(); // zobraz aktualny
- }
- } catch (SQLException e) {
- System.out.println(e);
- }
- }
- public void NacitajPredoslyZaznam() {
- try {
- if (!rs.isFirst()) { // ak nie je prvý
- rs.previous(); // posun sa dozadu
- NaplnPolia(); // zobraz aktualny
- }
- } catch (SQLException e) {
- System.out.println(e);
- }
- }
- public void NaplnPolia() throws SQLException {
- // nacitanie z resultsetu do poli
- idLabel.setText(rs.getString("ID"));
- menoField.setText(rs.getString("meno"));
- priezviskoField.setText(rs.getString("priezvisko"));
- platField.setText(rs.getString("plat"));
- // aktualny zaznam
- jTextField.setText(Integer.toString(rs.getRow()));
- // zapamataby pocet zaznamov
- jLabel.setText("/" + pocetRiadkov);
- }
- public void VykonajDotaz(String prikazSQL) {
- try {
- stmt.executeUpdate(prikazSQL);
- } catch (SQLException e) {
- System.out.println(e);
- }
- }
- /**
- * 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() {
- jTextField3 = new javax.swing.JTextField();
- jLabel1 = new javax.swing.JLabel();
- jLabel2 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jLabel4 = new javax.swing.JLabel();
- priezviskoField = new javax.swing.JTextField();
- platField = new javax.swing.JTextField();
- menoField = new javax.swing.JTextField();
- idLabel = new javax.swing.JLabel();
- jTextField = new javax.swing.JTextField();
- jLabel = new javax.swing.JLabel();
- jButton1 = new javax.swing.JButton();
- jButton2 = new javax.swing.JButton();
- avgPlatLabel = new javax.swing.JLabel();
- jButton3 = new javax.swing.JButton();
- jButton4 = new javax.swing.JButton();
- jButton5 = new javax.swing.JButton();
- platVacsiField = new javax.swing.JTextField();
- jLabel5 = new javax.swing.JLabel();
- jButton6 = new javax.swing.JButton();
- pocetLabel = new javax.swing.JLabel();
- jButton7 = new javax.swing.JButton();
- jButton8 = new javax.swing.JButton();
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- jLabel1.setText("ID:");
- jLabel2.setText("meno:");
- jLabel3.setText("priezvisko:");
- jLabel4.setText("plat:");
- jLabel.setText("jLabel5");
- jButton1.setText("UPDATE");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- jButton2.setText("AVG");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- avgPlatLabel.setText("avg");
- jButton3.setText(">");
- jButton3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton3ActionPerformed(evt);
- }
- });
- jButton4.setText("<");
- jButton4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton4ActionPerformed(evt);
- }
- });
- jButton5.setText("NEW");
- jButton5.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton5ActionPerformed(evt);
- }
- });
- jLabel5.setText("Plat > ako");
- jButton6.setText("OK");
- jButton6.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton6ActionPerformed(evt);
- }
- });
- pocetLabel.setText("pocet");
- jButton7.setText("DELETE THIS");
- jButton7.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton7ActionPerformed(evt);
- }
- });
- jButton8.setText("HLADAT");
- jButton8.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton8ActionPerformed(evt);
- }
- });
- javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
- getContentPane().setLayout(layout);
- layout.setHorizontalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addContainerGap()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addComponent(jButton4)
- .addGap(14, 14, 14)
- .addComponent(jTextField, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(jLabel))
- .addGroup(layout.createSequentialGroup()
- .addComponent(jLabel1)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(idLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
- .addComponent(jButton3)
- .addGroup(layout.createSequentialGroup()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jLabel3)
- .addComponent(jLabel2))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED))
- .addGroup(layout.createSequentialGroup()
- .addComponent(jLabel4)
- .addGap(33, 33, 33)))
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
- .addComponent(menoField, javax.swing.GroupLayout.DEFAULT_SIZE, 127, Short.MAX_VALUE)
- .addComponent(priezviskoField)
- .addComponent(platField))))
- .addGroup(layout.createSequentialGroup()
- .addComponent(jButton1)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 71, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 71, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(avgPlatLabel))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jButton8)
- .addComponent(jButton7)))
- .addGroup(layout.createSequentialGroup()
- .addComponent(jLabel5)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(platVacsiField, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(pocetLabel)
- .addComponent(jButton6))))
- .addContainerGap(34, Short.MAX_VALUE))
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addContainerGap()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jTextField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(jLabel)
- .addComponent(jButton3)
- .addComponent(jButton4))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
- .addComponent(jLabel1)
- .addComponent(idLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 14, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel2)
- .addComponent(menoField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel3)
- .addComponent(priezviskoField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel4)
- .addComponent(platField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGap(18, 18, 18)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jButton1)
- .addComponent(jButton5)
- .addComponent(jButton2)
- .addComponent(jButton7))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(avgPlatLabel)
- .addComponent(jButton8))
- .addGap(4, 4, 4)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel5)
- .addComponent(platVacsiField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(jButton6))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(pocetLabel)
- .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
- );
- pack();
- }// </editor-fold>
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- String dotaz = "Update zoznam set "
- + "meno ='" + menoField.getText() + "', "
- + "priezvisko ='" + priezviskoField.getText() + "', "
- + "plat ='" + platField.getText() + "' "
- + "where ID = " + idLabel.getText();
- VykonajDotaz(dotaz);
- NastavResultSet("Select * from zoznam");
- System.out.println("UPDATED");
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- try {
- rs = stmt.executeQuery("SELECT AVG(plat) as plat FROM zoznam");
- rs.next();
- avgPlat = rs.getString("plat");
- avgPlatLabel.setText(avgPlat);
- NastavResultSet("Select * from zoznam");
- } catch (SQLException ex) {
- Logger.getLogger(MyFrame.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
- NacitajDalsiZaznam();
- }
- private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
- NacitajPredoslyZaznam();
- }
- private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
- String dotaz = "Insert into zoznam (meno,priezvisko,plat) values ("
- + "'" + menoField.getText() + "', "
- + "'" + priezviskoField.getText() + "', "
- + "'" + platField.getText() + "')";
- VykonajDotaz(dotaz);
- NastavResultSet("Select * from Zoznam");
- System.out.println("inserted");
- }
- private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
- try {
- rs = stmt.executeQuery("SELECT COUNT(ID) as pocet FROM zoznam WHERE plat > " + platVacsiField.getText());
- rs.next();
- pocet = rs.getString("pocet");
- pocetLabel.setText(pocet);
- NastavResultSet("Select * from zoznam");
- } catch (SQLException ex) {
- Logger.getLogger(MyFrame.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {
- String dotaz = "DELETE FROM zoznam WHERE id = " + idLabel.getText();
- VykonajDotaz(dotaz);
- NastavResultSet("Select * from Zoznam");
- System.out.println("deleted");
- }
- private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
- try {
- rs = stmt.executeQuery("SELECT * FROM zoznam WHERE meno = " + menoField.getText() + " OR priezvisko = " + priezviskoField.getText());
- rs.next();
- pocet = rs.getString("pocet");
- pocetLabel.setText(pocet);
- NastavResultSet("Select * from zoznam");
- } catch (SQLException ex) {
- Logger.getLogger(MyFrame.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- /**
- * @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 {
- UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
- } catch (ClassNotFoundException | InstantiationException | IllegalAccessException | javax.swing.UnsupportedLookAndFeelException ex) {
- java.util.logging.Logger.getLogger(MyFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- }
- //</editor-fold>
- //</editor-fold>
- /* Create and display the form */
- java.awt.EventQueue.invokeLater(() -> {
- new MyFrame().setVisible(true);
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JLabel avgPlatLabel;
- private javax.swing.JLabel idLabel;
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton2;
- private javax.swing.JButton jButton3;
- private javax.swing.JButton jButton4;
- private javax.swing.JButton jButton5;
- private javax.swing.JButton jButton6;
- private javax.swing.JButton jButton7;
- private javax.swing.JButton jButton8;
- private javax.swing.JLabel jLabel;
- 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.JTextField jTextField;
- private javax.swing.JTextField jTextField3;
- private javax.swing.JTextField menoField;
- private javax.swing.JTextField platField;
- private javax.swing.JTextField platVacsiField;
- private javax.swing.JLabel pocetLabel;
- private javax.swing.JTextField priezviskoField;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement