Example usage for javax.swing.table DefaultTableModel addColumn

List of usage examples for javax.swing.table DefaultTableModel addColumn

  1. HOME
  2. Java
  3. javax
  4. javax.swing.table.*
  5. DefaultTableModel
  6. addColumn

Introduction

In this page you can find the example usage for javax.swing.table DefaultTableModel addColumn.

Prototype

public void addColumn(Object columnName)

Source Link

Document

Adds a column to the model.

Usage

From source file:hw.java

private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTable1MouseClicked
    //try {//  w  w w . j  av  a 2 s  .c o  m
    MongoCollection<Document> rcoll = db.getCollection("review");
    String business = jTable1.getValueAt(jTable1.getSelectedRow(), 0).toString();

    BasicDBObject businessid = new BasicDBObject("business_id", business);

    FindIterable<Document> cursor2;

    jTextField8.setText("db.review.find(" + businessid.toString() + ")");
    cursor2 = rcoll.find(businessid);

    //             ResultSet rs = stmt.executeQuery(qry);
    String Columnames[] = { "user_id", "business_id", "text" };
    DefaultTableModel dtm = (DefaultTableModel) jTable2.getModel();
    dtm.setColumnCount(0);
    dtm.setRowCount(0);
    int numberOfColumns = Columnames.length;

    for (int i = 0; i < numberOfColumns; i++) {
        String name = Columnames[i];
        dtm.addColumn(name);

    }

    cursor2.forEach(new Block<Document>() {
        @Override
        public void apply(final Document document) {

            Object rowData[] = new Object[numberOfColumns];

            rowData[0] = document.get("user_id");
            rowData[1] = document.get("business_id");
            rowData[2] = document.get("text");

            dtm.addRow(rowData);
            rowData = null;
        }
    });

}

From source file:hw.java

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
    MongoCollection<Document> coll = db.getCollection("user");
    String member_value = jTextField2.getText();
    String review_value = jTextField4.getText();
    String fans_value = jTextField5.getText();
    String average_stars_value = jTextField6.getText();
    String friends_value = jTextField7.getText();
    String review_dropdown = jComboBox13.getSelectedItem().toString();
    String fans_dropdown = jComboBox14.getSelectedItem().toString();
    String stars_dropdown = jComboBox15.getSelectedItem().toString();
    String friends_dropdown = jComboBox16.getSelectedItem().toString();
    BasicDBObject qryUser = new BasicDBObject();
    BasicDBList UserList = new BasicDBList();
    FindIterable<Document> cursor;
    String select = jComboBox1.getSelectedItem().toString();
    if (member_value == null && review_value.equals("0") && fans_value.equals("0")
            && average_stars_value.equals("0") && friends_value.equals("0")) {

        qryUser = null;//w w w  . j  a  va  2  s . c  om

    }
    if (member_value == null || member_value.equals("")) {
        member_value = "1999-01";
    }
    //      if(review_value == null || review_value.equals(""))
    //      {
    //          review_value = "0";
    //      }
    //      if(fans_value == null || fans_value.equals(""))
    //      {
    //          fans_value = "0";
    //      }
    //      if(average_stars_value == null || average_stars_value.equals(""))
    //      {
    //          average_stars_value = "0";
    //      }
    //      if(friends_value == null || friends_value.equals(""))
    //      {
    //          friends_value = "0";
    //      }

    if (!friends_value.equals("0")) {
        BasicDBObject fv = new BasicDBObject("friends." + friends_value, new BasicDBObject("$exists", true));
        UserList.add(fv);
    }
    if (!member_value.equals("0")) {
        BasicDBObject mv = new BasicDBObject("yelping_since", new BasicDBObject("$gt", member_value));
        UserList.add(mv);
    }
    if (!review_value.equals("0")) {
        if (review_dropdown.equals(">")) {
            BasicDBObject rv = new BasicDBObject("review_count",
                    new BasicDBObject("$gt", Integer.parseInt(review_value)));
            UserList.add(rv);
        }
        if (review_dropdown.equals("<")) {
            BasicDBObject rv = new BasicDBObject("review_count",
                    new BasicDBObject("$lt", Integer.parseInt(review_value)));
            UserList.add(rv);
        }
        if (review_dropdown.equals("=")) {
            BasicDBObject rv = new BasicDBObject("review_count", Integer.parseInt(review_value));
            UserList.add(rv);
        }

    }
    if (!fans_value.equals("0")) {
        if (fans_dropdown.equals(">")) {
            BasicDBObject f = new BasicDBObject("fans", new BasicDBObject("$gt", Integer.parseInt(fans_value)));
            UserList.add(f);
        }
        if (review_dropdown.equals("<")) {
            BasicDBObject f = new BasicDBObject("fans", new BasicDBObject("$lt", Integer.parseInt(fans_value)));
            UserList.add(f);
        }
        if (review_dropdown.equals("=")) {
            BasicDBObject f = new BasicDBObject("fans", Integer.parseInt(fans_value));
            UserList.add(f);
        }
    }
    if (!average_stars_value.equals("0")) {
        if (stars_dropdown.equals(">")) {
            BasicDBObject as = new BasicDBObject("average_stars",
                    new BasicDBObject("$gt", Integer.parseInt(average_stars_value)));
            UserList.add(as);
        }
        if (review_dropdown.equals("<")) {
            BasicDBObject as = new BasicDBObject("average_stars",
                    new BasicDBObject("$lt", Integer.parseInt(average_stars_value)));
            UserList.add(as);
        }
        if (review_dropdown.equals("=")) {
            BasicDBObject as = new BasicDBObject("average_stars", Integer.parseInt(average_stars_value));
            UserList.add(as);
        }
    }

    if ("AND".equals(jComboBox1.getSelectedItem().toString())) {
        qryUser = new BasicDBObject("$and", UserList);
    }
    if ("OR".equals(jComboBox1.getSelectedItem().toString())) {
        qryUser = new BasicDBObject("$or", UserList);
    }
    if (qryUser == null) {
        jTextField8.setText("db.user.find()");
        cursor = coll.find();

    } else {

        jTextField8.setText("db.user.find(" + qryUser.toString() + ")");
        cursor = coll.find(qryUser);
    }
    String Columnames[] = { "yelping_since", "review_count", "name", "user_id", "average_stars" };
    DefaultTableModel dtm = (DefaultTableModel) jTable2.getModel();
    dtm.setColumnCount(0);
    dtm.setRowCount(0);
    int numberOfColumns = Columnames.length;

    for (int i = 0; i < numberOfColumns; i++) {
        String name = Columnames[i];
        dtm.addColumn(name);

    }

    cursor.forEach(new Block<Document>() {
        @Override
        public void apply(final Document document) {

            Object rowData[] = new Object[numberOfColumns];

            rowData[0] = document.get("yelping_since");
            rowData[1] = document.get("review_count");
            rowData[2] = document.get("name");
            rowData[3] = document.get("user_id");
            rowData[4] = document.get("average_stars");

            //                                System.out.print(document.get("yelping_since")+"\t");                                
            //                                System.out.print(document.get("review_count")+"\t");                                
            //                                System.out.print(document.get("name")+"\t");                                
            //                                System.out.print(document.get("user_id")+"\t");                                
            //                                System.out.print(document.get("average_stars")+"\t");                                
            //                                System.out.println();
            dtm.addRow(rowData);
            rowData = null;
        }
    });

    jTable2.setRowSelectionAllowed(true);
    jTable2.setModel(dtm);

    jTable2.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
    dtm.fireTableDataChanged();

    // mongoClient.close();

    //        
    //        
    //      

}

From source file:hw.java

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed

    //        ResultSet rs1;
    //         /*from ww w.  ja va2 s  .  c om*/
    //        try {
    MongoCollection<Document> coll = db.getCollection("business");
    //MongoCollection<Document> catcollection = db.getCollection("catout");
    MongoCollection<Document> rcoll = db.getCollection("review");
    //final DBCollection collection = db.getCollection("review");
    MongoCollection<Document> ccoll = db.getCollection("checkin");
    String from_dropdown = jComboBox3.getSelectedItem().toString();
    String to_dropdown = jComboBox6.getSelectedItem().toString();

    String from_value = jTextField9.getText();
    String to_value = jTextField10.getText();
    String check_count_value = jTextField11.getText();

    String check_count_dropdown = jComboBox8.getSelectedItem().toString();
    String fromdate_value = jTextField1.getText();
    String todate_value = jTextField3.getText();
    String stars_value = jTextField12.getText();
    String votes_value = jTextField13.getText();
    String stars_dropdown = jComboBox4.getSelectedItem().toString();
    String votes_dropdown = jComboBox12.getSelectedItem().toString();
    String select = jComboBox1.getSelectedItem().toString();
    List<String> category_value = jList2.getSelectedValuesList();
    String poi = jComboBox5.getSelectedItem().toString();
    String proximity = jComboBox2.getSelectedItem().toString();
    BasicDBObject qryBusiness = new BasicDBObject();
    BasicDBObject qryReview = new BasicDBObject();
    BasicDBList BusinessList = new BasicDBList();
    BasicDBList ReviewList = new BasicDBList();
    FindIterable<Document> cursor;
    FindIterable<Document> cursor1;
    List<String> catout = new ArrayList<String>();
    List<String> proout = new ArrayList<String>();
    List<String> checkinout = new ArrayList<String>();
    List<String> reviewout = new ArrayList<String>();
    List<String> finalout = new ArrayList<String>();

    if (category_value.isEmpty())//&& poi == null && proximity == null && from_value == null && fromdate_value == null)
    {
        BasicDBObject nu = new BasicDBObject();
        FindIterable<Document> fi;
        fi = coll.find(nu);
        jTextField8.setText("db.business.find()");
        String Columnames[] = { "business_id", "state", "city", "stars" };
        DefaultTableModel dtm = (DefaultTableModel) jTable1.getModel();
        dtm.setColumnCount(0);
        dtm.setRowCount(0);
        int numberOfColumns = Columnames.length;

        for (int i = 0; i < numberOfColumns; i++) {
            String name = Columnames[i];
            dtm.addColumn(name);

        }

        fi.forEach(new Block<Document>() {
            @Override
            public void apply(final Document document) {

                Object rowData[] = new Object[numberOfColumns];

                rowData[0] = document.get("business_id");
                rowData[1] = document.get("state");
                rowData[2] = document.get("city");
                rowData[3] = document.get("stars");

                dtm.addRow(rowData);
                rowData = null;
            }
        });

        jTable1.setRowSelectionAllowed(true);
        jTable1.setModel(dtm);

        jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        dtm.fireTableDataChanged();

    } else {

        Object[] l = jList2.getSelectedValues();
        //BasicDBList subcat = new BasicDBList();
        BasicDBList clist = new BasicDBList();
        BasicDBObject qrycategory;
        if (l.length > 0) {
            for (int i = 0; i < l.length; i++) {
                BasicDBObject buinessop = new BasicDBObject("categories", l[i]);
                clist.add(buinessop);
            }
        }
        qrycategory = new BasicDBObject("$or", clist);
        //               subcatquery = new BasicDBObject("$out","subcat");
        //               subcat.add(qrycategory);
        //               subcat.add(subcatquery);
        //               System.out.println(subcat);
        cursor = coll.find(qrycategory);

        System.out.println(qrycategory);
        //BasicDBObject category = new BasicDBObject();
        cursor.forEach(new Block<Document>() {
            @Override
            public void apply(final Document document) {

                System.out.println(document.get("business_id"));
                //category.put((String)document.get("business_id"), db);

                catout.add((String) document.get("business_id"));
                //                                System.out.println(document.get("state"));
                //                                System.out.println(document.get("city"));
                //                                System.out.println(document.get("stars"));
                //                               

            }
        });

        MongoCollection<Document> collecttest = db.getCollection("test");
        String[] addresses5 = { "", "4840 E Indian School Rd\\nSte 101\\nPhoenix, AZ 85018",
                "631 S Main St\\nDe Forest, WI 53532", "5813 Main St\\nMc Farland, WI 53558",
                "2039 Allen Blvd\\nMiddleton, WI 53562", "6230 University Ave\\nMiddleton, WI 53562" };
        String[][] latLong = { { "33.499313000000001", "-111.98375799999999" },
                { "43.2408748", "-89.343721700000003" }, { "43.014164000000001", "-89.288567" },
                { "43.090642000000003", "-89.485168999999999" }, { "43.0910607", "-89.487486700000005" } };

        BasicDBObject queryBusiness = new BasicDBObject();
        BasicDBList businessinputlist = new BasicDBList();

        String selectedAddress = jComboBox5.getSelectedItem().toString();
        String selectedProximity = jComboBox2.getSelectedItem().toString();
        Double pro = Double.parseDouble(selectedProximity) / 3963.2;
        int index = Arrays.asList(addresses5).indexOf(selectedAddress);
        Double Latitude = Double.parseDouble(latLong[index][0]);
        Double Longitude = Double.parseDouble(latLong[index][1]);
        System.out.println("lat" + Latitude);
        System.out.println("longi" + Longitude);
        //BasicDBObject lat = new BasicDBObject(Latitude.toString(),Longitude);
        BasicDBList c1 = new BasicDBList();
        BasicDBList cs = new BasicDBList();
        cs.add(Latitude);
        cs.add(Longitude);
        c1.add(cs);
        c1.add(pro);
        BasicDBObject c = new BasicDBObject("$centerSphere", c1);
        BasicDBObject bq = new BasicDBObject("loc", new BasicDBObject("$geoWithin", c));
        FindIterable<Document> fi;
        fi = collecttest.find(bq);
        System.out.println(bq);
        jTextField8.setText("db.test.find(" + bq + ")");
        fi.forEach(new Block<Document>() {
            @Override
            public void apply(final Document document) {

                System.out.println(document.get("business_id"));

                proout.add((String) document.get("business_id"));

                //System.out.println(document.get("loc"));
            }
        });
        int checkinempty = 0;
        if (from_value == null || to_value == null || check_count_value.equals("0")) {
            checkinempty = 1;
            List<String> pr = new ArrayList<String>(catout);
            System.out.println(pr.size());
            pr.retainAll(proout);
            System.out.println(pr.size());
            String Columnames[] = { "Business_id", "state", "city", "stars" };
            DefaultTableModel dtm = (DefaultTableModel) jTable1.getModel();
            dtm.setColumnCount(0);
            dtm.setRowCount(0);
            int numberOfColumns = Columnames.length;
            Object rowData[] = new Object[numberOfColumns];

            for (int i = 0; i < numberOfColumns; i++) {
                String name = Columnames[i];
                dtm.addColumn(name);

            }
            for (int i = 0; i < pr.size(); i++) {

                rowData[0] = pr.get(i);
                BasicDBObject c11 = new BasicDBObject("business_id", pr.get(i));
                FindIterable<Document> f1;
                f1 = coll.find(c11);
                f1.forEach(new Block<Document>() {
                    @Override
                    public void apply(final Document document) {

                        Object rowData[] = new Object[numberOfColumns];
                        rowData[0] = document.get("business_id");
                        rowData[1] = document.get("state");
                        rowData[2] = document.get("city");
                        rowData[3] = document.get("stars");
                        dtm.addRow(rowData);
                        rowData = null;

                    }
                });

                //                                
                //                                
                //                              

            }

            jTable1.setRowSelectionAllowed(true);
            jTable1.setModel(dtm);

            jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
            dtm.fireTableDataChanged();

        }
        if (checkinempty != 1) {

            BasicDBList checkinputlist = new BasicDBList();
            //               
            ArrayList<String> list1;
            list1 = new ArrayList<String>();
            list1.add("0");
            list1.add("1");
            list1.add("2");
            list1.add("3");
            list1.add("4");
            list1.add("5");
            list1.add("6");

            int from = list1.indexOf(from_dropdown);
            int to = list1.indexOf(to_dropdown);
            int count = to - from;
            int hoursfrom1 = Integer.parseInt(from_value);
            int hoursto1 = Integer.parseInt(to_value);
            int count1 = hoursto1 - hoursfrom1;

            FindIterable<Document> iterable = ccoll.find();

            iterable.forEach(new Block<Document>() {
                @Override
                public void apply(final Document document) {
                    //System.out.println(document.get("checkin_info"));

                    String s = document.toJson();
                    s.replace("Document", "");
                    // System.out.println(s);
                    JSONParser parser = new JSONParser();
                    try {
                        Object obj = parser.parse(s);
                        JSONObject doc = (JSONObject) obj;

                        //System.out.println(doc.get("checkin_info"));
                        JSONObject cinfo = (JSONObject) doc.get("checkin_info");
                        if (count >= 0) {
                            long num_checkin = 0;
                            for (int i = from; i <= to; i++) {
                                if (count1 >= 0) {
                                    for (int j = hoursfrom1; j <= hoursto1; j++) {
                                        //System.out.println(cinfo.get(j+"-"+i));
                                        if (cinfo.containsKey(j + "-" + i)) {
                                            num_checkin = num_checkin + (long) cinfo.get(j + "-" + i);
                                            //                              System.out.println(document.get("checkin_info."+j+"-"+i));

                                        }

                                    }
                                }
                            }
                            if (num_checkin != 0) {
                                if (jComboBox8.getSelectedItem().equals(">")
                                        && num_checkin > Long.parseLong(check_count_value)) {
                                    System.out
                                            .println(num_checkin + " checkins into " + doc.get("business_id"));
                                    checkinout.add((String) document.get("business_id"));

                                }
                                if (jComboBox8.getSelectedItem().equals("<")
                                        && num_checkin < Long.parseLong(check_count_value)) {
                                    System.out
                                            .println(num_checkin + " checkins into  " + doc.get("business_id"));
                                    checkinout.add((String) document.get("business_id"));

                                }
                                if (jComboBox8.getSelectedItem().equals("=")
                                        && num_checkin == Long.parseLong(check_count_value)) {
                                    System.out
                                            .println(num_checkin + " checkins into  " + doc.get("business_id"));
                                    checkinout.add((String) document.get("business_id"));

                                }
                            }

                            num_checkin = 0;

                        }
                    } catch (Exception e) {
                        System.out.println(e);
                    }
                }
            });

            if (fromdate_value != null && todate_value != null) {
                BasicDBObject fdv = new BasicDBObject("date", new BasicDBObject("$gte", fromdate_value));
                ReviewList.add(fdv);
                BasicDBObject tdv = new BasicDBObject("date", new BasicDBObject("$lte", todate_value));
                ReviewList.add(tdv);
            }
            if (stars_value != null) {
                if (stars_dropdown == ">") {
                    BasicDBObject sv = new BasicDBObject("stars",
                            new BasicDBObject("$gt", Integer.parseInt(stars_value)));
                    ReviewList.add(sv);
                }
                if (stars_dropdown == "<") {
                    BasicDBObject sv = new BasicDBObject("stars",
                            new BasicDBObject("$lt", Integer.parseInt(stars_value)));
                    ReviewList.add(sv);
                }
                if (stars_dropdown == "=") {
                    BasicDBObject sv = new BasicDBObject("stars", Integer.parseInt(stars_value));
                    ReviewList.add(sv);
                }
            }

            if (votes_value != null) {
                if (votes_dropdown == ">") {
                    BasicDBObject vv = new BasicDBObject("votes",
                            new BasicDBObject("$gt", Integer.parseInt(votes_value)));
                    //ReviewList.add(vv);
                }
                if (votes_dropdown == "<") {
                    BasicDBObject vv = new BasicDBObject("votes",
                            new BasicDBObject("$lt", Integer.parseInt(votes_value)));
                    //ReviewList.add(vv);
                }
                if (votes_dropdown == "=") {
                    BasicDBObject vv = new BasicDBObject("votes", Integer.parseInt(votes_value));
                    //ReviewList.add(vv);
                }
            }
            qryReview = new BasicDBObject("$and", ReviewList);
            if (qryReview == null) {
                //jTextField8.setText("db.review.find()");
                cursor1 = rcoll.find();

            } else {

                //jTextField8.setText("db.review.find("+qryReview.toString()+")");
                cursor1 = rcoll.find(qryReview);
            }

            cursor1.forEach(new Block<Document>() {
                @Override
                public void apply(final Document document) {
                    System.out.println(document.get("business_id"));
                    reviewout.add((String) document.get("business_id"));

                }
            });
            if ("AND".equals(jComboBox1.getSelectedItem().toString())) {
                //jTextField8.setText("db.checkin.find("+"{}"+","+"{business_id"+":1}"+")");
                List<String> fin = new ArrayList<String>(catout);
                System.out.println(fin.size());
                fin.retainAll(proout);
                System.out.println(fin.size());

                fin.retainAll(checkinout);

                System.out.println(fin.size());

                fin.retainAll(reviewout);

                //
                System.out.println(fin.size());
                String Columnames[] = { "Business_id", "state", "city", "stars" };
                DefaultTableModel dtm = (DefaultTableModel) jTable1.getModel();
                dtm.setColumnCount(0);
                dtm.setRowCount(0);
                int numberOfColumns = Columnames.length;
                Object rowData[] = new Object[numberOfColumns];

                for (int i = 0; i < numberOfColumns; i++) {
                    String name = Columnames[i];
                    dtm.addColumn(name);

                }
                for (int i = 0; i < fin.size(); i++) {

                    rowData[0] = fin.get(i);
                    BasicDBObject c11 = new BasicDBObject("business_id", fin.get(i));
                    FindIterable<Document> f1;
                    f1 = coll.find(c11);
                    f1.forEach(new Block<Document>() {
                        @Override
                        public void apply(final Document document) {

                            Object rowData[] = new Object[numberOfColumns];
                            rowData[0] = document.get("business_id");
                            rowData[1] = document.get("state");
                            rowData[2] = document.get("city");
                            rowData[3] = document.get("stars");
                            dtm.addRow(rowData);
                            rowData = null;

                        }
                    });

                    //                                
                    //                                
                    //                              

                }

                jTable1.setRowSelectionAllowed(true);
                jTable1.setModel(dtm);

                jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
                dtm.fireTableDataChanged();

            }
            if ("OR".equals(jComboBox1.getSelectedItem().toString())) {
                //MongoCollection<Document> = db.getCollection("business");
                //jTextField8.setText("db.checkin.find("+"{}"+","+"{business_id"+":1}"+")");
                List<String> fin = new ArrayList<String>(catout); //create a Set with all the elements in a
                fin.addAll(proout);
                System.out.println(fin.size());
                fin.addAll(checkinout);
                System.out.println(fin.size());
                fin.addAll(reviewout);
                System.out.println(fin.size());

                String Columnames[] = { "Business_id", "state", "city", "stars" };
                DefaultTableModel dtm = (DefaultTableModel) jTable1.getModel();
                dtm.setColumnCount(0);
                dtm.setRowCount(0);
                int numberOfColumns = Columnames.length;
                //Object rowData[] = new Object[numberOfColumns];
                //Object rd1,rd2,rd3; 

                for (int i = 0; i < numberOfColumns; i++) {
                    String name = Columnames[i];
                    dtm.addColumn(name);

                }
                for (int i = 0; i < fin.size(); i++) {

                    Object rowData[] = new Object[numberOfColumns];

                    rowData[0] = fin.get(i);

                    BasicDBObject c11 = new BasicDBObject("business_id", fin.get(i));
                    FindIterable<Document> f1;
                    f1 = coll.find(c11);
                    f1.forEach(new Block<Document>() {
                        @Override
                        public void apply(final Document document) {

                            Object rowData[] = new Object[numberOfColumns];
                            rowData[0] = document.get("business_id");
                            rowData[1] = document.get("state");
                            rowData[2] = document.get("city");
                            rowData[3] = document.get("stars");
                            dtm.addRow(rowData);
                            rowData = null;
                        }
                    });

                }
                //                       });

                //Object rowData[] = new Object[numberOfColumns];

                //                                
                //                                
                //                              

                jTable1.setRowSelectionAllowed(true);
                jTable1.setModel(dtm);

                jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
                dtm.fireTableDataChanged();

            }
            if (qryBusiness == null) {
                //jTextField8.setText("db.business.find()");
                cursor = coll.find();

            } else {

                //jTextField8.setText("db.business.find("+qryBusiness.toString()+")");
                cursor = coll.find(qryBusiness);
            }

            //         } catch (SQLException ex) {
            //             Logger.getLogger(hw.class.getName()).log(Level.SEVERE, null, ex);
            //         }
            //             
            //             
            //         
            //     

        }

    }
}

From source file:gui.Trabajadores.java

public void cargaSalario() {
    try {//  w  w w  .j a v  a 2s  . c  om
        Database con = new Database();
        DefaultTableModel modelo = new DefaultTableModel();
        this.salario.setModel(modelo);
        Connection conn = con.conectar();
        String sentencia = "";
        PreparedStatement pst = conn.prepareStatement(sentencia);
        rs = pst.executeQuery();
        ResultSetMetaData rsMd = rs.getMetaData();
        //La cantidad de columnas que tiene la consulta
        int cantidadColumnas = rsMd.getColumnCount();
        //Establecer como cabezeras el nombre de las colimnas
        for (int i = 1; i <= cantidadColumnas; i++) {
            modelo.addColumn(rsMd.getColumnLabel(i));
        }
        //Creando las filas para el JTable
        while (rs.next()) {
            Object[] fila = new Object[cantidadColumnas];
            for (int i = 0; i < cantidadColumnas; i++) {
                fila[i] = rs.getObject(i + 1);
            }
            modelo.addRow(fila);
        }
        con.CerrarConexion();
    } catch (Exception ioe) {
        ioe.printStackTrace();
    }
}

From source file:gui.Trabajadores.java

public void cargaNoSin() {
    try {/*from ww w  .  j ava2 s.  co  m*/
        Database con = new Database();
        DefaultTableModel modelo = new DefaultTableModel();
        this.tablaNoSin.setModel(modelo);
        Connection conn = con.conectar();
        String sentencia = "SELECT d_sexo, count(d_sexo) from icave.fact_empleado where q_activo= 'SI' GROUP By d_sexo;";
        PreparedStatement pst = conn.prepareStatement(sentencia);
        rs = pst.executeQuery();
        ResultSetMetaData rsMd = rs.getMetaData();
        //La cantidad de columnas que tiene la consulta
        int cantidadColumnas = rsMd.getColumnCount();
        //Establecer como cabezeras el nombre de las colimnas
        for (int i = 1; i <= cantidadColumnas; i++) {
            modelo.addColumn(rsMd.getColumnLabel(i));
        }
        //Creando las filas para el JTable
        while (rs.next()) {
            Object[] fila = new Object[cantidadColumnas];
            for (int i = 0; i < cantidadColumnas; i++) {
                fila[i] = rs.getObject(i + 1);
            }
            modelo.addRow(fila);
        }
        con.CerrarConexion();
    } catch (Exception ioe) {
        ioe.printStackTrace();
    }
}

From source file:gui.Trabajadores.java

public void cargaEdad() {
    try {/*  www .  j  av  a2 s . c  om*/
        Database con = new Database();
        DefaultTableModel modelo = new DefaultTableModel();
        this.edad.setModel(modelo);
        Connection conn = con.conectar();
        String sentencia = "select Num_Empleado,Fecha_Baja,Costo_Finiquito, Indemnizacion, Prima_Antiguedad, Gratificacion, Total_Pagado_Separacion, Motivo_Baja, Volver_Contratar, Pendiente from bajas_temp;";
        PreparedStatement pst = conn.prepareStatement(sentencia);
        rs = pst.executeQuery();
        ResultSetMetaData rsMd = rs.getMetaData();
        //La cantidad de columnas que tiene la consulta
        int cantidadColumnas = rsMd.getColumnCount();
        //Establecer como cabezeras el nombre de las colimnas
        for (int i = 1; i <= cantidadColumnas; i++) {
            modelo.addColumn(rsMd.getColumnLabel(i));
        }
        //Creando las filas para el JTable
        while (rs.next()) {
            Object[] fila = new Object[cantidadColumnas];
            for (int i = 0; i < cantidadColumnas; i++) {
                fila[i] = rs.getObject(i + 1);
            }
            modelo.addRow(fila);
        }
        con.CerrarConexion();
    } catch (Exception ioe) {
        ioe.printStackTrace();
    }
}

From source file:gui.Trabajadores.java

public void cargaSin() {
    try {//  w ww . ja v a2s  .  c o m
        Database con = new Database();
        DefaultTableModel modelo = new DefaultTableModel();
        this.tablaSin.setModel(modelo);
        Connection conn = con.conectar();
        String sentencia = "select Num_Empleado,Fecha_Baja,Costo_Finiquito, Indemnizacion, Prima_Antiguedad, Gratificacion, Total_Pagado_Separacion, Motivo_Baja, Volver_Contratar, Pendiente from bajas_temp;";
        PreparedStatement pst = conn.prepareStatement(sentencia);
        rs = pst.executeQuery();
        ResultSetMetaData rsMd = rs.getMetaData();
        //La cantidad de columnas que tiene la consulta
        int cantidadColumnas = rsMd.getColumnCount();
        //Establecer como cabezeras el nombre de las colimnas
        for (int i = 1; i <= cantidadColumnas; i++) {
            modelo.addColumn(rsMd.getColumnLabel(i));
        }
        //Creando las filas para el JTable
        while (rs.next()) {
            Object[] fila = new Object[cantidadColumnas];
            for (int i = 0; i < cantidadColumnas; i++) {
                fila[i] = rs.getObject(i + 1);
            }
            modelo.addRow(fila);
        }
        con.CerrarConexion();
    } catch (Exception ioe) {
        ioe.printStackTrace();
    }
}

From source file:gui.Trabajadores.java

public void cargaTurnoSin() {
    try {//from ww w.j a v a 2  s .co m
        Database con = new Database();
        DefaultTableModel modelo = new DefaultTableModel();
        this.turnosin.setModel(modelo);
        Connection conn = con.conectar();
        String sentencia = "select Num_Empleado,Fecha_Baja,Costo_Finiquito, Indemnizacion, Prima_Antiguedad, Gratificacion, Total_Pagado_Separacion, Motivo_Baja, Volver_Contratar, Pendiente from bajas_temp;";
        PreparedStatement pst = conn.prepareStatement(sentencia);
        rs = pst.executeQuery();
        ResultSetMetaData rsMd = rs.getMetaData();
        //La cantidad de columnas que tiene la consulta
        int cantidadColumnas = rsMd.getColumnCount();
        //Establecer como cabezeras el nombre de las colimnas
        for (int i = 1; i <= cantidadColumnas; i++) {
            modelo.addColumn(rsMd.getColumnLabel(i));
        }
        //Creando las filas para el JTable
        while (rs.next()) {
            Object[] fila = new Object[cantidadColumnas];
            for (int i = 0; i < cantidadColumnas; i++) {
                fila[i] = rs.getObject(i + 1);
            }
            modelo.addRow(fila);
        }
        con.CerrarConexion();
    } catch (Exception ioe) {
        ioe.printStackTrace();
    }
}

From source file:gui.Trabajadores.java

public void cargaBaja() {
    try {//from ww  w.  ja v a 2 s . c o m
        Database con = new Database();
        DefaultTableModel modelo = new DefaultTableModel();
        this.tablaBajas.setModel(modelo);
        Connection conn = con.conectar();
        String sentencia = "select Num_Empleado,Fecha_Baja,Costo_Finiquito, Indemnizacion, Prima_Antiguedad, Gratificacion, Total_Pagado_Separacion, Motivo_Baja, Volver_Contratar, Pendiente from bajas_temp;";
        PreparedStatement pst = conn.prepareStatement(sentencia);
        rs = pst.executeQuery();
        ResultSetMetaData rsMd = rs.getMetaData();
        //La cantidad de columnas que tiene la consulta
        int cantidadColumnas = rsMd.getColumnCount();
        //Establecer como cabezeras el nombre de las colimnas
        for (int i = 1; i <= cantidadColumnas; i++) {
            modelo.addColumn(rsMd.getColumnLabel(i));
        }
        //Creando las filas para el JTable
        while (rs.next()) {
            Object[] fila = new Object[cantidadColumnas];
            for (int i = 0; i < cantidadColumnas; i++) {
                fila[i] = rs.getObject(i + 1);
            }
            modelo.addRow(fila);
        }
        con.CerrarConexion();
    } catch (Exception ioe) {
        ioe.printStackTrace();
    }
}

From source file:gui.Trabajadores.java

public void cargaAntiguedad() {
    try {// w w  w. ja  va2  s .  c  o m
        Database con = new Database();
        DefaultTableModel modelo = new DefaultTableModel();
        this.antiguedad.setModel(modelo);
        Connection conn = con.conectar();
        String sentencia = "select Num_Empleado,Fecha_Baja,Costo_Finiquito, Indemnizacion, Prima_Antiguedad, Gratificacion, Total_Pagado_Separacion, Motivo_Baja, Volver_Contratar, Pendiente from bajas_temp;";
        PreparedStatement pst = conn.prepareStatement(sentencia);
        rs = pst.executeQuery();
        ResultSetMetaData rsMd = rs.getMetaData();
        //La cantidad de columnas que tiene la consulta
        int cantidadColumnas = rsMd.getColumnCount();
        //Establecer como cabezeras el nombre de las colimnas
        for (int i = 1; i <= cantidadColumnas; i++) {
            modelo.addColumn(rsMd.getColumnLabel(i));
        }
        //Creando las filas para el JTable
        while (rs.next()) {
            Object[] fila = new Object[cantidadColumnas];
            for (int i = 0; i < cantidadColumnas; i++) {
                fila[i] = rs.getObject(i + 1);
            }
            modelo.addRow(fila);
        }
        con.CerrarConexion();
    } catch (Exception ioe) {
        ioe.printStackTrace();
    }
}