fork download
copy 
  1. package Employees;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.Statement;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import javax.swing.JOptionPane;
  9. import javax.swing.SwingUtilities;
  10.  
  11. public final class Workers extends javax.swing.JFrame {
  12.  
  13.     Connection con;
  14.     Statement stmt;
  15.     ResultSet rs;
  16.     private String id;
  17.     private String Fname;
  18.  
  19.     public Workers() {
  20.        // initComponents();
  21.         DoConnect();
  22.     }
  23.  
  24.     public void DoConnect()
  25.     {
  26.         try
  27.         {
  28.             String host = "jdbc:derby://localhost:1527/Employees";
  29.             String uName = "root";
  30.             String uPass = "root";
  31.  
  32.             con = DriverManager.getConnection(host,uName,uPass);
  33.             stmt = con.createStatement();
  34.             String sql = "select * from workers";
  35.             rs = stmt.executeQuery(sql);
  36.  
  37.             rs.next();
  38.             int id_col = rs.getInt("ID");
  39.             String id_1 = Integer.toString(id_col);
  40.             String Fnames = rs.getString("NAME");
  41.  
  42.             textID.setText(id_1);
  43.             textFirstName.setText(Fnames);
  44.  
  45.  
  46.  
  47.         }
  48.  
  49.         catch(SQLException err)
  50.         {
  51.             JOptionPane.showMessageDialog(Workers.this, err.getMessage());
  52.  
  53.         }
  54.     }
  55.  
  56.  
  57.  
  58.  
  59.    @SuppressWarnings("unchecked")
  60.     // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
  61.     private void initComponents() {
  62.  
  63.         textID = new javax.swing.JTextField();
  64.         textFirstName = new javax.swing.JTextField();
  65.  
  66.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  67.  
  68.         textID.addActionListener(new java.awt.event.ActionListener() {
  69.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  70.                 textIDActionPerformed(evt);
  71.             }
  72.         });
  73.  
  74.         textFirstName.addActionListener(new java.awt.event.ActionListener() {
  75.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  76.                 textFirstNameActionPerformed(evt);
  77.             }
  78.         });
  79.  
  80.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  81.         getContentPane().setLayout(layout);
  82.         layout.setHorizontalGroup(
  83.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  84.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  85.                 .addContainerGap(32, Short.MAX_VALUE)
  86.                 .addComponent(textID, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE)
  87.                 .addGap(30, 30, 30)
  88.                 .addComponent(textFirstName, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
  89.                 .addGap(155, 155, 155))
  90.         );
  91.         layout.setVerticalGroup(
  92.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  93.             .addGroup(layout.createSequentialGroup()
  94.                 .addGap(25, 25, 25)
  95.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  96.                     .addComponent(textID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  97.                     .addComponent(textFirstName, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  98.                 .addContainerGap(255, Short.MAX_VALUE))
  99.         );
  100.  
  101.         pack();
  102.     }// </editor-fold>                        
  103.  
  104.     private void textIDActionPerformed(java.awt.event.ActionEvent evt) {                                       
  105.  
  106.     }                                      
  107.  
  108.     private void textFirstNameActionPerformed(java.awt.event.ActionEvent evt) {                                              
  109.  
  110.     }                                             
  111.  
  112.     /**
  113.      * @param args the command line arguments
  114.      */
  115.  
  116.     // Variables declaration - do not modify                     
  117.     private javax.swing.JTextField textFirstName;
  118.     private javax.swing.JTextField textID;
  119.     // End of variables declaration                   
  120.  
  121.  
  122. public static void main(String args[]) {
  123.  
  124.         SwingUtilities.invokeLater(new Runnable() {
  125.  
  126.             @Override
  127.             public void run()
  128.             {
  129.                 new Workers().setVisible(true);
  130.  
  131.             }
  132.         });
  133. }
  134. }
Compilation error #stdin compilation error #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
compilation info 
Main.java:11: error: class Workers is public, should be declared in a file named Workers.java
public final class Workers extends javax.swing.JFrame {
             ^
1 error
stdout
copy 
Standard output is empty
https://ideone.com/RzLiJT
language:
Java (HotSpot 12)
created:
12 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!