fork download 
  1.     package sakila.ui;
  2.  
  3. import java.util.List;
  4. import java.util.Vector;
  5. import javax.swing.table.DefaultTableModel;
  6. import org.hibernate.HibernateException;
  7. import org.hibernate.Session;
  8. import sakila.entity.Produs;
  9. import sakila.util.HibernateUtil;
  10.  
  11.  
  12. public class CautComenzi extends javax.swing.JFrame {
  13.  
  14.     public CautComenzi() {
  15.         initComponents();
  16.     }
  17.  
  18.     @SuppressWarnings("unchecked")
  19.     // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
  20.     private void initComponents() {
  21.  
  22.         jPanel1 = new javax.swing.JPanel();
  23.         jLabel1 = new javax.swing.JLabel();
  24.         jLabel2 = new javax.swing.JLabel();
  25.         idFurnizorTextField = new javax.swing.JTextField();
  26.         queryButton1 = new javax.swing.JButton();
  27.         jScrollPane1 = new javax.swing.JScrollPane();
  28.         resultTable1 = new javax.swing.JTable();
  29.  
  30.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  31.  
  32.         jLabel1.setText("Cauta Comenzile de la un furnizor");
  33.  
  34.         jLabel2.setText("Id-ul furnizorului");
  35.  
  36.         queryButton1.setText("Query");
  37.         queryButton1.addActionListener(new java.awt.event.ActionListener() {
  38.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  39.                 queryButton1ActionPerformed(evt);
  40.             }
  41.         });
  42.  
  43.         resultTable1.setModel(new javax.swing.table.DefaultTableModel(
  44.             new Object [][] {
  45.                 {null, null, null, null},
  46.                 {null, null, null, null},
  47.                 {null, null, null, null},
  48.                 {null, null, null, null}
  49.             },
  50.             new String [] {
  51.                 "Title 1", "Title 2", "Title 3", "Title 4"
  52.             }
  53.         ));
  54.         jScrollPane1.setViewportView(resultTable1);
  55.  
  56.         javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  57.         jPanel1.setLayout(jPanel1Layout);
  58.         jPanel1Layout.setHorizontalGroup(
  59.             jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  60.             .addGroup(jPanel1Layout.createSequentialGroup()
  61.                 .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  62.                     .addGroup(jPanel1Layout.createSequentialGroup()
  63.                         .addGap(76, 76, 76)
  64.                         .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE)
  65.                         .addGap(40, 40, 40)
  66.                         .addComponent(idFurnizorTextField, javax.swing.GroupLayout.PREFERRED_SIZE, 95, javax.swing.GroupLayout.PREFERRED_SIZE))
  67.                     .addGroup(jPanel1Layout.createSequentialGroup()
  68.                         .addGap(102, 102, 102)
  69.                         .addComponent(jLabel1))
  70.                     .addGroup(jPanel1Layout.createSequentialGroup()
  71.                         .addGap(65, 65, 65)
  72.                         .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 269, javax.swing.GroupLayout.PREFERRED_SIZE))
  73.                     .addGroup(jPanel1Layout.createSequentialGroup()
  74.                         .addGap(137, 137, 137)
  75.                         .addComponent(queryButton1)))
  76.                 .addContainerGap(39, Short.MAX_VALUE))
  77.         );
  78.         jPanel1Layout.setVerticalGroup(
  79.             jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  80.             .addGroup(jPanel1Layout.createSequentialGroup()
  81.                 .addGap(22, 22, 22)
  82.                 .addComponent(jLabel1)
  83.                 .addGap(34, 34, 34)
  84.                 .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  85.                     .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
  86.                     .addComponent(idFurnizorTextField, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE))
  87.                 .addGap(18, 18, 18)
  88.                 .addComponent(queryButton1)
  89.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 27, Short.MAX_VALUE)
  90.                 .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 210, javax.swing.GroupLayout.PREFERRED_SIZE)
  91.                 .addContainerGap())
  92.         );
  93.  
  94.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  95.         getContentPane().setLayout(layout);
  96.         layout.setHorizontalGroup(
  97.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  98.             .addGroup(layout.createSequentialGroup()
  99.                 .addGap(24, 24, 24)
  100.                 .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  101.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  102.         );
  103.         layout.setVerticalGroup(
  104.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  105.             .addGroup(layout.createSequentialGroup()
  106.                 .addContainerGap()
  107.                 .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  108.                 .addContainerGap(46, Short.MAX_VALUE))
  109.         );
  110.  
  111.         pack();
  112.     }// </editor-fold>                        
  113.  
  114.     private void queryButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                             
  115.         if (!idFurnizorTextField.getText().trim().equals(""))
  116.                 runQueryBasedOnIdFurnizor();
  117.     }                                            
  118.  
  119.     private void runQueryBasedOnIdFurnizor(){
  120.         executeHQLQuery("from Comanda c where c.idfurn like '" + idFurnizorTextField.getText() + "%'" );
  121.  
  122.     }
  123.  
  124.      private void executeHQLQuery(String hql){
  125.         try{
  126.         Session session = HibernateUtil.getSessionFactory().openSession();
  127.         session.beginTransaction();
  128.         org.hibernate.Query q = session.createQuery(hql);
  129.         List resultList = q.list();
  130.         displayResult(resultList);
  131.         session.getTransaction().commit();
  132.         }catch (HibernateException he){
  133.             he.printStackTrace();
  134.         }
  135.     }
  136.  
  137.      private void displayResult(List resultList){
  138.         Vector<String> tableHeaders = new Vector<String>();
  139.         Vector tableData = new Vector();
  140.         tableHeaders.add("IdFurn");
  141.         //tableHeaders.add("IdDepozit");
  142.         //tableHeaders.add("IdComanda");
  143.         //tableHeaders.add("IdFurnizor");
  144.         //tableHeaders.add("IdCategorie");
  145.  
  146.         for (Object o : resultList){
  147.             Produs p = (Produs) o;
  148.             Vector <Object> oneRow = new Vector <Object>();
  149.             oneRow.add(p.getFurnizor());
  150.             //oneRow.add(p.getDepozit());
  151.             //oneRow.add(p.getIdcomanda());
  152.             //oneRow.add(p.getFurnizor());
  153.             //oneRow.add(p.getCategorie());
  154.             tableData.add(oneRow);
  155.         }
  156.        resultTable1.setModel(new DefaultTableModel(tableData, tableHeaders)); 
  157.     }
  158.  
  159.  
  160.     public static void main(String args[]) {
  161.         /*
  162.          * Set the Nimbus look and feel
  163.          */
  164.         //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  165.         /*
  166.          * If Nimbus (introduced in Java SE 6) is not available, stay with the
  167.          * default look and feel. For details see
  168.          * http://d...content-available-to-author-only...e.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  169.          */
  170.         try {
  171.             for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  172.                 if ("Nimbus".equals(info.getName())) {
  173.                     javax.swing.UIManager.setLookAndFeel(info.getClassName());
  174.                     break;
  175.                 }
  176.             }
  177.         } catch (ClassNotFoundException ex) {
  178.             java.util.logging.Logger.getLogger(CautComenzi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  179.         } catch (InstantiationException ex) {
  180.             java.util.logging.Logger.getLogger(CautComenzi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  181.         } catch (IllegalAccessException ex) {
  182.             java.util.logging.Logger.getLogger(CautComenzi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  183.         } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  184.             java.util.logging.Logger.getLogger(CautComenzi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  185.         }
  186.         //</editor-fold>
  187.  
  188.         /*
  189.          * Create and display the form
  190.          */
  191.         java.awt.EventQueue.invokeLater(new Runnable() {
  192.  
  193.             public void run() {
  194.                 new CautComenzi().setVisible(true);
  195.             }
  196.         });
  197.     }
  198.     // Variables declaration - do not modify                     
  199.     private javax.swing.JTextField idFurnizorTextField;
  200.     private javax.swing.JLabel jLabel1;
  201.     private javax.swing.JLabel jLabel2;
  202.     private javax.swing.JPanel jPanel1;
  203.     private javax.swing.JScrollPane jScrollPane1;
  204.     private javax.swing.JButton queryButton1;
  205.     private javax.swing.JTable resultTable1;
  206.     // End of variables declaration                   
  207.  
  208.  
  209. } 
  210.  
  211. <?xml version="1.0"?>
  212. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
  213. "http://h...content-available-to-author-only...e.net/hibernate-mapping-3.0.dtd">
  214. <!-- Generated Apr 9, 2012 10:19:42 PM by Hibernate Tools 3.2.1.GA -->
  215. <hibernate-mapping>
  216.     <class name="sakila.entity.Comanda" table="comanda" catalog="sakila">
  217.         <id name="idcomanda" type="int">
  218.             <column name="IDCOMANDA" />
  219.             <generator class="assigned" />
  220.         </id>
  221.         <many-to-one name="client" class="sakila.entity.Client" fetch="select">
  222.             <column name="IDCLIENT" />
  223.         </many-to-one>
  224.         <many-to-one name="depozit" class="sakila.entity.Depozit" fetch="select">
  225.             <column name="IDDEPOZIT" />
  226.         </many-to-one>
  227.         <many-to-one name="furnizor" class="sakila.entity.Furnizor" fetch="select">
  228.             <column name="IDFURN" />
  229.         </many-to-one>
  230.         <property name="idprodus" type="java.lang.Integer">
  231.             <column name="IDPRODUS" />
  232.         </property>
  233.         <property name="unitmas" type="java.lang.Integer">
  234.             <column name="UNITMAS" />
  235.         </property>
  236.         <property name="cantitate" type="java.lang.Integer">
  237.             <column name="CANTITATE" />
  238.         </property>
  239.         <set name="comdetals" inverse="true">
  240.             <key>
  241.                 <column name="IDCOMANDA" />
  242.             </key>
  243.             <one-to-many class="sakila.entity.Comdetal" />
  244.         </set>
  245.         <set name="facturas" inverse="true">
  246.             <key>
  247.                 <column name="IDCOMANDA" />
  248.             </key>
  249.             <one-to-many class="sakila.entity.Factura" />
  250.         </set>
  251.     </class>
  252. </hibernate-mapping>
  253.  
Compilation error #stdin compilation error #stdout 0s 0KB
comments (?)
stdin 
Standard input is empty
compilation info 
Main.java:211: class, interface, or enum expected
<?xml version="1.0"?>
^
Main.java:216: '{' expected
    <class name="sakila.entity.Comanda" table="comanda" catalog="sakila">
               ^
Main.java:217: > expected
        <id name="idcomanda" type="int">
           ^
Main.java:217: <identifier> expected
        <id name="idcomanda" type="int">
                ^
Main.java:217: illegal start of type
        <id name="idcomanda" type="int">
                 ^
Main.java:218: > expected
            <column name="IDCOMANDA" />
                   ^
Main.java:218: illegal start of expression
            <column name="IDCOMANDA" />
                    ^
Main.java:218: illegal start of expression
            <column name="IDCOMANDA" />
                                      ^
Main.java:219: > expected
            <generator class="assigned" />
                      ^
Main.java:219: illegal start of expression
            <generator class="assigned" />
                       ^
Main.java:219: illegal start of expression
            <generator class="assigned" />
                                         ^
Main.java:220: illegal start of type
        </id>
         ^
Main.java:220: illegal start of expression
        </id>
          ^
Main.java:221: > expected
        <many-to-one name="client" class="sakila.entity.Client" fetch="select">
             ^
Main.java:221: ';' expected
        <many-to-one name="client" class="sakila.entity.Client" fetch="select">
              ^
Main.java:221: illegal start of type
        <many-to-one name="client" class="sakila.entity.Client" fetch="select">
                ^
Main.java:221: ';' expected
        <many-to-one name="client" class="sakila.entity.Client" fetch="select">
                    ^
Main.java:221: <identifier> expected
        <many-to-one name="client" class="sakila.entity.Client" fetch="select">
                         ^
Main.java:221: ';' expected
        <many-to-one name="client" class="sakila.entity.Client" fetch="select">
                                  ^
Main.java:221: <identifier> expected
        <many-to-one name="client" class="sakila.entity.Client" fetch="select">
                                        ^
Main.java:221: illegal start of type
        <many-to-one name="client" class="sakila.entity.Client" fetch="select">
                                         ^
Main.java:222: > expected
            <column name="IDCLIENT" />
                   ^
Main.java:222: illegal start of expression
            <column name="IDCLIENT" />
                    ^
Main.java:222: illegal start of expression
            <column name="IDCLIENT" />
                                     ^
Main.java:223: illegal start of type
        </many-to-one>
         ^
Main.java:223: illegal start of expression
        </many-to-one>
          ^
Main.java:224: > expected
        <many-to-one name="depozit" class="sakila.entity.Depozit" fetch="select">
             ^
Main.java:224: ';' expected
        <many-to-one name="depozit" class="sakila.entity.Depozit" fetch="select">
              ^
Main.java:224: illegal start of type
        <many-to-one name="depozit" class="sakila.entity.Depozit" fetch="select">
                ^
Main.java:224: ';' expected
        <many-to-one name="depozit" class="sakila.entity.Depozit" fetch="select">
                    ^
Main.java:224: <identifier> expected
        <many-to-one name="depozit" class="sakila.entity.Depozit" fetch="select">
                         ^
Main.java:224: ';' expected
        <many-to-one name="depozit" class="sakila.entity.Depozit" fetch="select">
                                   ^
Main.java:224: <identifier> expected
        <many-to-one name="depozit" class="sakila.entity.Depozit" fetch="select">
                                         ^
Main.java:224: illegal start of type
        <many-to-one name="depozit" class="sakila.entity.Depozit" fetch="select">
                                          ^
Main.java:225: > expected
            <column name="IDDEPOZIT" />
                   ^
Main.java:225: illegal start of expression
            <column name="IDDEPOZIT" />
                    ^
Main.java:225: illegal start of expression
            <column name="IDDEPOZIT" />
                                      ^
Main.java:226: illegal start of type
        </many-to-one>
         ^
Main.java:226: illegal start of expression
        </many-to-one>
          ^
Main.java:227: > expected
        <many-to-one name="furnizor" class="sakila.entity.Furnizor" fetch="select">
             ^
Main.java:227: ';' expected
        <many-to-one name="furnizor" class="sakila.entity.Furnizor" fetch="select">
              ^
Main.java:227: illegal start of type
        <many-to-one name="furnizor" class="sakila.entity.Furnizor" fetch="select">
                ^
Main.java:227: ';' expected
        <many-to-one name="furnizor" class="sakila.entity.Furnizor" fetch="select">
                    ^
Main.java:227: <identifier> expected
        <many-to-one name="furnizor" class="sakila.entity.Furnizor" fetch="select">
                         ^
Main.java:227: ';' expected
        <many-to-one name="furnizor" class="sakila.entity.Furnizor" fetch="select">
                                    ^
Main.java:227: <identifier> expected
        <many-to-one name="furnizor" class="sakila.entity.Furnizor" fetch="select">
                                          ^
Main.java:227: illegal start of type
        <many-to-one name="furnizor" class="sakila.entity.Furnizor" fetch="select">
                                           ^
Main.java:228: > expected
            <column name="IDFURN" />
                   ^
Main.java:228: illegal start of expression
            <column name="IDFURN" />
                    ^
Main.java:228: illegal start of expression
            <column name="IDFURN" />
                                   ^
Main.java:229: illegal start of type
        </many-to-one>
         ^
Main.java:229: illegal start of expression
        </many-to-one>
          ^
Main.java:230: > expected
        <property name="idprodus" type="java.lang.Integer">
                 ^
Main.java:230: illegal start of expression
        <property name="idprodus" type="java.lang.Integer">
                  ^
Main.java:230: ';' expected
        <property name="idprodus" type="java.lang.Integer">
                                 ^
Main.java:230: <identifier> expected
        <property name="idprodus" type="java.lang.Integer">
                                      ^
Main.java:231: > expected
            <column name="IDPRODUS" />
                   ^
Main.java:231: illegal start of expression
            <column name="IDPRODUS" />
                    ^
Main.java:231: illegal start of expression
            <column name="IDPRODUS" />
                                     ^
Main.java:232: illegal start of type
        </property>
         ^
Main.java:232: illegal start of expression
        </property>
          ^
Main.java:233: > expected
        <property name="unitmas" type="java.lang.Integer">
                 ^
Main.java:233: illegal start of expression
        <property name="unitmas" type="java.lang.Integer">
                  ^
Main.java:233: ';' expected
        <property name="unitmas" type="java.lang.Integer">
                                ^
Main.java:233: <identifier> expected
        <property name="unitmas" type="java.lang.Integer">
                                     ^
Main.java:234: > expected
            <column name="UNITMAS" />
                   ^
Main.java:234: illegal start of expression
            <column name="UNITMAS" />
                    ^
Main.java:234: illegal start of expression
            <column name="UNITMAS" />
                                    ^
Main.java:235: illegal start of type
        </property>
         ^
Main.java:235: illegal start of expression
        </property>
          ^
Main.java:236: > expected
        <property name="cantitate" type="java.lang.Integer">
                 ^
Main.java:236: illegal start of expression
        <property name="cantitate" type="java.lang.Integer">
                  ^
Main.java:236: ';' expected
        <property name="cantitate" type="java.lang.Integer">
                                  ^
Main.java:236: <identifier> expected
        <property name="cantitate" type="java.lang.Integer">
                                       ^
Main.java:237: > expected
            <column name="CANTITATE" />
                   ^
Main.java:237: illegal start of expression
            <column name="CANTITATE" />
                    ^
Main.java:237: illegal start of expression
            <column name="CANTITATE" />
                                      ^
Main.java:238: illegal start of type
        </property>
         ^
Main.java:238: illegal start of expression
        </property>
          ^
Main.java:239: > expected
        <set name="comdetals" inverse="true">
            ^
Main.java:239: illegal start of expression
        <set name="comdetals" inverse="true">
             ^
Main.java:239: ';' expected
        <set name="comdetals" inverse="true">
                             ^
Main.java:239: <identifier> expected
        <set name="comdetals" inverse="true">
                                     ^
Main.java:241: illegal start of expression
                <column name="IDCOMANDA" />
                ^
Main.java:241: ';' expected
                <column name="IDCOMANDA" />
                       ^
Main.java:241: <identifier> expected
                <column name="IDCOMANDA" />
                            ^
Main.java:241: illegal start of expression
                <column name="IDCOMANDA" />
                                          ^
Main.java:242: illegal start of type
            </key>
             ^
Main.java:242: illegal start of expression
            </key>
              ^
Main.java:243: > expected
            <one-to-many class="sakila.entity.Comdetal" />
                ^
Main.java:243: ';' expected
            <one-to-many class="sakila.entity.Comdetal" />
                 ^
Main.java:243: illegal start of type
            <one-to-many class="sakila.entity.Comdetal" />
                   ^
Main.java:243: ';' expected
            <one-to-many class="sakila.entity.Comdetal" />
                        ^
Main.java:243: <identifier> expected
            <one-to-many class="sakila.entity.Comdetal" />
                              ^
Main.java:243: illegal start of type
            <one-to-many class="sakila.entity.Comdetal" />
                               ^
Main.java:243: <identifier> expected
            <one-to-many class="sakila.entity.Comdetal" />
                                                       ^
Main.java:243: ';' expected
            <one-to-many class="sakila.entity.Comdetal" />
                                                         ^
Main.java:244: <identifier> expected
        </set>
         ^
Main.java:244: <identifier> expected
        </set>
             ^
Main.java:245: > expected
        <set name="facturas" inverse="true">
            ^
100 errors
stdout 
Standard output is empty
https://ideone.com/gC3IV
language:
Java (HotSpot 12)
created:
13 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!