Monday, February 10, 2014

jTable Clear All Rows


        clear(); // clear crm contacts
        DefaultTableModel dtm = (DefaultTableModel) jTable_Contact.getModel();
        dtm.setRowCount(0);

Java Oracle Get Generated Key

 ResultSet result = null;
                                   java.sql.Statement pst = conn.createStatement();
                           
                            pst.executeUpdate("INSERT INTO sales_cust_branch (branch_code,debtor_no, br_name, branch_ref, br_address, area, area_details, salesman, sales_man_details, contact_name, default_inventory_location, inv_loc_details, tax_group_id, tax_group_details, sales_account, sales_discount_account,receivables_account, payment_discount_account, sales_account_details, sales_discount_acc_details, receivables_account_details, payment_discount_acc_details, default_ship_via, default_ship_via_details, disable_trans,br_post_address, group_no, group_details, notes, inactive ,company_id, user_id, login_ip,insert_date,pc_user) VALUES "
                                               + "(SALES_DEBTORS_BRANCH.nextval,'"+ debator_no + "','"  + Branch_Name+ "','"  + Branch_Short_Name + "','"  + Billing_Add + "','"  + Sales_Area + "','"  + Sales_Area_Details + "','"  + Sales_Person + "','"  + Sales_Person_Details + "','"  + Contact_Person + "','"  + Def_Inv_Loc + "','"  + Def_Inv_Loc_Details + "','"  + Tax_Group + "','"  + Tax_Group_Details + "','"  + Sales_Ac_Id + "','"  + Sales_Dis_Id + "','"  + Sales_Rcv_Id + "','"  + Sales_Py_Dis_Id + "','"  + Sales_Account + "','"  + Sales_Discount_Account + "','"  + Accounts_Receiveable_Account + "','"  + Promot_Payment_Discount_Account + "','"  + Def_Ship_Com + "','"  +  Def_Ship_Com_Details+ "','"  + 0 + "','"  + Mailing_Add + "','"  +  Sales_Group_Id+ "','"  + Sales_Group_Details + "','"  + Br_General_Notes + "','"  + I_S_Br + "','"  + Dashboard.company_id + "','"  + Dashboard.user_id + "','"  + u.Get_Ip() + "',TO_DATE('"  + u.todays_datetime()+ "', 'yyyy-mm-dd hh24:mi:ss'),'"  + System.getProperty("user.name") + "')", new String [] {"branch_code"});

                            result = pst.getGeneratedKeys();
                            result.next();
                            branch_id = String.valueOf(result.getLong(1));
 System.out.println(branch_id );
Result: 25

Saturday, January 25, 2014

jTable Row Value Tool Tip

jTable_direct_delivery = new javax.swing.JTable()
{

    //JTable

    //Implement table cell tool tips.        
    public String getToolTipText(MouseEvent e) {
        String tip = null;
        java.awt.Point p = e.getPoint();
        int rowIndex = rowAtPoint(p);
        int colIndex = columnAtPoint(p);
        int realColumnIndex = convertColumnIndexToModel(colIndex);

        try {
            // if (realColumnIndex == 2 && rowIndex!=0) { //comment row, exclude heading
                //     tip = getValueAt(rowIndex, colIndex).toString();
                // }
            if (realColumnIndex == 9 ) { //comment row, exclude heading
                tip = "Dispatch";
            }
            if (realColumnIndex == 10 ) { //comment row, exclude heading
                tip = "Edit";
            }

            if (realColumnIndex == 2 && rowIndex >=0 ) { //comment row, exclude heading
                tip = getValueAt(rowIndex, colIndex).toString();
            }
        } catch (RuntimeException e1) {
            //catch null pointer exception if mouse is over an empty line
        }

        return tip;
    }

}
;

jTable Hand Cursor Mouse Hover

 private void jTable_direct_deliveryMouseMoved(java.awt.event.MouseEvent evt) {                                                
        if(jTable_direct_delivery.columnAtPoint(evt.getPoint())==7 ||  jTable_direct_delivery.columnAtPoint(evt.getPoint())==8 )
                    {
                        setCursor(Cursor.HAND_CURSOR);

                    }
                    else
                    {
                        setCursor(0);
                    }
    }   

jTable Row value with Image Symbol

 //get table model
            DefaultTableModel model = (DefaultTableModel) jTable_direct_delivery.getModel();
            model.addRow(new Object[]{
                item_code, item_description, quantity, unit, price,
                discount, line_total });
               jTable_direct_delivery.setAutoResizeMode(jTable_direct_delivery.AUTO_RESIZE_OFF);
              jTable_direct_delivery.getColumnModel().getColumn(0).setPreferredWidth(70);
              jTable_direct_delivery.getColumnModel().getColumn(1).setPreferredWidth(270);
              jTable_direct_delivery.getColumnModel().getColumn(2).setPreferredWidth(50);
              jTable_direct_delivery.getColumnModel().getColumn(3).setPreferredWidth(52);
              jTable_direct_delivery.getColumnModel().getColumn(4).setPreferredWidth(110);
              jTable_direct_delivery.getColumnModel().getColumn(5).setPreferredWidth(78);
              jTable_direct_delivery.getColumnModel().getColumn(6).setPreferredWidth(90);
   
               TableColumn someColumn = jTable_direct_delivery.getColumnModel().getColumn(7);
                someColumn.setCellRenderer(new IconifiedRenderer(new ImageIcon(getClass().getResource("/images/edit.gif"))) );
               TableColumn someColumn1 = jTable_direct_delivery.getColumnModel().getColumn(8);
                 someColumn1.setCellRenderer(new IconifiedRenderer(new ImageIcon(getClass().getResource("/images/remove.png"))) );

Get Return Key SQL Insert Auto ID

  pst.executeUpdate("INSERT INTO sales_dcl_order_details ("
                                        + "order_no, trans_type, stk_code, description, unit,"
                                        + "unit_price, quantity, discount_percent, insert_date ) VALUES "
                                        + "('"+ max_id + "','"  + 30+ "','"  + item_code + "','"  + item_desc + "','"  + item_unit + "'"
                                        + ",'"  + item_price + "','"  + item_quentity + "','"  + item_discount + "','"  + u.todays_datetime() + "')",Statement.RETURN_GENERATED_KEYS);
                                     
                                        generatedKeys = pst.getGeneratedKeys();
                                        if(generatedKeys.next()){
                                        src_id = generatedKeys.getString(1);
                                        }

Tuesday, December 24, 2013

Java JTable Set Column's Read Only / Editable

{
    boolean[] canEdit = new boolean [] {
        false, true, false, false, false, false, false
    };
    public boolean isCellEditable(int rowIndex, int columnIndex) {
        return canEdit [columnIndex];
    }
}