public void actionPerformed(ActionEvent ev) { try { // stok String query = "DELETE FROM stok_produk WHERE id_produk=" + idProduk; int hasil1 = stm.executeUpdate(query); // pemasukkan query = "DELETE FROM pemasukan WHERE id_produk=" + idProduk; int hasil2 = stm.executeUpdate(query); // pengeluaran query = "DELETE FROM pengeluaran WHERE id_produk=" + idProduk; int hasil3 = stm.executeUpdate(query); // produk query = "DELETE FROM produk WHERE id_produk=" + idProduk; int hasil4 = stm.executeUpdate(query); if (hasil1 == 1 || hasil2 == 1 || hasil3 == 1 && hasil4 == 1) { setDataTabel(); JOptionPane.showMessageDialog(null, "berhasil hapus"); } else { JOptionPane.showMessageDialog(null, "gagal"); } } catch (SQLException SQLerr) { SQLerr.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } }
@Override public void actionPerformed(ActionEvent axnEve) { Object obj = axnEve.getSource(); if (obj == replyBut) { try { if (Home.composeDial != null && Home.composeDial.isShowing()) { } else { Home.composeDial = new ComposeMailDialog( msgID, workingSet.getString("mail_addresses"), workingSet.getString("subject")); } } catch (SQLException sqlExc) { sqlExc.printStackTrace(); } } else if (obj == forwardBut) { try { if (Home.composeDial != null && Home.composeDial.isShowing()) { } else { Home.composeDial = new ComposeMailDialog( msgID, workingSet.getString("subject") + "\n\n" + workingSet.getString("content")); } } catch (SQLException sqlExc) { sqlExc.printStackTrace(); } } }
public void display(ResultSet rs) { try { boolean recordNumber = rs.next(); if (recordNumber) { payNo = rs.getString(1); pasNo = rs.getString(2); pasName = rs.getString(3); mode = rs.getString(4); dt = rs.getString(5); amount = rs.getString(6); rev = rs.getString(7); text1.setText(payNo); combo1.setSelectedItem(pasNo); combo2.setSelectedItem(pasName); combo4.setSelectedItem(mode); p_date.setText(dt); combo8.setSelectedItem(amount); combo3.setSelectedItem(rev); } else { JOptionPane.showMessageDialog( null, "Record Not found", "ERROR", JOptionPane.DEFAULT_OPTION); } } catch (SQLException sqlex) { sqlex.printStackTrace(); } }
/** * verifica si hay productos asociados * * @param table table */ private boolean verify() { String sql = "SELECT XX_VMR_ReferenceMatrix_ID " + "FROM XX_VMR_ReferenceMatrix " + "WHERE XX_VMR_PO_LINEREFPROV_ID=" + (Integer) LineRefProv.getXX_VMR_PO_LineRefProv_ID(); PreparedStatement pstmt = null; ResultSet rs = null; try { pstmt = DB.prepareStatement(sql, null); rs = pstmt.executeQuery(); while (rs.next()) { associatedReference_ID = rs.getInt("XX_VMR_ReferenceMatrix_ID"); rs.close(); pstmt.close(); return true; } } catch (SQLException e) { log.log(Level.SEVERE, sql, e); } finally { try { rs.close(); } catch (SQLException e1) { e1.printStackTrace(); } try { pstmt.close(); } catch (SQLException e) { e.printStackTrace(); } } return false; } // tableLoad
private void prosesEdit(String query) { try { int hasil = stm.executeUpdate(query); if (hasil == 1) { setDataTabel(); JOptionPane.showMessageDialog(null, "edit berhasil"); } else { JOptionPane.showMessageDialog(null, "gagal"); } } catch (SQLException SQLerr) { SQLerr.printStackTrace(); } }
private boolean isInMatrix() { String SQL = "Select * " + "from XX_VMR_REFERENCEMATRIX " + "where XX_VMR_PO_LINEREFPROV_ID=" + LineRefProv.get_ID(); PreparedStatement pstmt = null; ResultSet rs = null; try { pstmt = DB.prepareStatement(SQL, null); rs = pstmt.executeQuery(); while (rs.next()) { return true; } } catch (Exception a) { log.log(Level.SEVERE, SQL, a); } finally { try { rs.close(); } catch (SQLException e1) { e1.printStackTrace(); } try { pstmt.close(); } catch (SQLException e) { e.printStackTrace(); } } return false; }
public void setJenis() { dataJenis = new ArrayList<Jenis>(); try { String qry = "SELECT * from jenis"; ResultSet rs = stm.executeQuery(qry); while (rs.next()) { Jenis j = new Jenis(); j.setIdJenis(rs.getInt("id_jenis")); j.setNamaJenis(rs.getString("nama_jenis")); dataJenis.add(j); } } catch (SQLException SQLerr) { SQLerr.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } }
/** Method declaration */ void insertTestData() { try { DatabaseManagerCommon.createTestTables(sStatement); refreshTree(); txtCommand.setText(DatabaseManagerCommon.createTestData(sStatement)); refreshTree(); for (int i = 0; i < DatabaseManagerCommon.testDataSql.length; i++) { addToRecent(DatabaseManagerCommon.testDataSql[i]); } execute(); } catch (SQLException e) { e.printStackTrace(); } }
public static void updateKvalification() { try { DBClass db2 = new DBClass(); ArrayList<Kvalification> k = db2.kvalificationFromDB(); comboBox_kvalification.removeAllItems(); for (int i = 0; i < k.size(); i++) { comboBox_kvalification.addItem(k.get(i)); } } catch (ClassNotFoundException e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, e.getMessage()); } catch (SQLException ee) { ee.printStackTrace(); JOptionPane.showMessageDialog(null, ee.getMessage()); } }
public static void updateDoljnost() { try { DBClass db = new DBClass(); ArrayList<Doljnost> d = db.doljnostFromDB(); comboBox_doljnost.removeAllItems(); for (int i = 0; i < d.size(); i++) { comboBox_doljnost.addItem(d.get(i)); } } catch (ClassNotFoundException e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, e.getMessage()); } catch (SQLException ee) { ee.printStackTrace(); JOptionPane.showMessageDialog(null, ee.getMessage()); } }
// Вид формы при изменении сотрудника public void sotrDiaUpdate(Sotrudnik s) { label_id_hidden.setText(Integer.toString(s.getId_sotrudnika())); textField_familiya.setText(s.getFamiliya()); textField_imya.setText(s.getImya()); textField_otchestvo.setText(s.getOtchestvo()); textField_phone.setText(s.getPhone()); textField_date.setText(s.getData_priema().toString()); comboBox_doljnost.removeAllItems(); comboBox_kvalification.removeAllItems(); try { DBClass db = new DBClass(); ArrayList<Doljnost> d = db.doljnostFromDB(); DBClass db2 = new DBClass(); Doljnost dd = db2.doljnostFromDB(s); for (int i = 0; i < d.size(); i++) { comboBox_doljnost.addItem(d.get(i)); Doljnost ddd = (Doljnost) comboBox_doljnost.getItemAt(i); if (dd.getNazvanie_doljnosti().equals(ddd.getNazvanie_doljnosti())) dd = ddd; } comboBox_doljnost.setSelectedItem(dd); DBClass db3 = new DBClass(); ArrayList<Kvalification> k = db3.kvalificationFromDB(); DBClass db4 = new DBClass(); Kvalification kk = db4.kvalificationFromDB(s); for (int i = 0; i < k.size(); i++) { comboBox_kvalification.addItem(k.get(i)); Kvalification kkk = (Kvalification) comboBox_kvalification.getItemAt(i); if (kk.getNazvanie_kvalification().equals(kkk.getNazvanie_kvalification())) kk = kkk; } comboBox_kvalification.setSelectedItem(kk); } catch (ClassNotFoundException e) { e.printStackTrace(); JOptionPane.showMessageDialog(panelException, e.getMessage()); } catch (SQLException ee) { ee.printStackTrace(); JOptionPane.showMessageDialog(panelException, ee.getMessage()); } }
// Вид формы при добавлении нового сотрудника public void sotrDiaInsert() { label_id_hidden.setText("Новый сотрудник"); textField_familiya.setText(""); textField_imya.setText(""); textField_otchestvo.setText(""); textField_phone.setText(""); comboBox_doljnost.removeAllItems(); comboBox_kvalification.removeAllItems(); Calendar calend = Calendar.getInstance(); if (calend.get(Calendar.MONTH) <= 9) { textField_date.setText( String.valueOf( (calend.get(Calendar.YEAR) + "-" + ("0" + (1 + calend.get(Calendar.MONTH))) + "-") + (calend.get(Calendar.DATE)))); } else textField_date.setText( String.valueOf( ((calend.get(Calendar.YEAR)) + "-" + (1 + calend.get(Calendar.MONTH)) + "-") + (calend.get(Calendar.DATE)))); textField_date.setEnabled(false); try { DBClass db = new DBClass(); ArrayList<Doljnost> d = db.doljnostFromDB(); for (int i = 0; i < d.size(); i++) { comboBox_doljnost.addItem(d.get(i)); } DBClass db2 = new DBClass(); ArrayList<Kvalification> k = db2.kvalificationFromDB(); for (int i = 0; i < k.size(); i++) { comboBox_kvalification.addItem(k.get(i)); } } catch (ClassNotFoundException e) { e.printStackTrace(); JOptionPane.showMessageDialog(panelException, e.getMessage()); } catch (SQLException ee) { ee.printStackTrace(); JOptionPane.showMessageDialog(panelException, ee.getMessage()); } }
/** * Method declaration * * @param c */ void connect(Connection c) { if (c == null) { return; } if (cConn != null) { try { cConn.close(); } catch (SQLException e) { } } cConn = c; try { dMeta = cConn.getMetaData(); sStatement = cConn.createStatement(); refreshTree(); } catch (SQLException e) { e.printStackTrace(); } }
public void setContent(String cat) { cat = cat.trim(); selectAllCB.setVisible(false); selectAllCB.setSelected(false); deleteBut.setVisible(false); restoreBut.setVisible(false); refreshBut.setVisible(true); Object columns[] = null; int count = 0; switch (cat) { case "Inbox": columns = new Object[] {"", "From", "Date", "Subject", "Content"}; count = Database.getCount("Inbox"); workingSet = db.getData("SELECT * FROM messages WHERE tag='inbox' ORDER BY msg_id desc"); ; break; case "SentMail": columns = new Object[] {"", "To", "Date", "Subject", "Content"}; count = Database.getCount("Sentmail"); workingSet = db.getData("SELECT * FROM messages WHERE tag='sentmail' ORDER BY msg_id desc"); break; case "Draft": columns = new Object[] {"", "To", "Date", "Subject", "Content"}; count = Database.getCount("Draft"); workingSet = db.getData("SELECT * FROM messages WHERE tag='draft' ORDER BY msg_id desc"); break; case "Outbox": columns = new Object[] {"", "To", "Date", "Subject", "Content"}; count = Database.getCount("Outbox"); workingSet = db.getData("SELECT * FROM messages WHERE tag='outbox' ORDER BY msg_id desc"); break; case "Trash": // restoreBut.setVisible(true); columns = new Object[] {"", "To/From", "Date", "Subject", "Content"}; count = Database.getCount("Trash"); workingSet = db.getData( "SELECT * FROM messages,trash WHERE messages.tag='trash' and messages.msg_id=trash.msg_id ORDER BY deleted_at desc"); break; default: System.out.println("in default case"); } if (count > 0) { selectAllCB.setVisible(true); rows = new Object[count][]; msgID = new int[count]; try { workingSet.beforeFirst(); for (int i = 0; i < count && workingSet.next(); i++) { msgID[i] = workingSet.getInt(1); rows[i] = new Object[] { false, workingSet.getString(2), workingSet.getDate(3), workingSet.getString(4), workingSet.getString(5) }; } } catch (SQLException sqlExc) { JOptionPane.showMessageDialog(null, sqlExc, "EXCEPTION", JOptionPane.ERROR_MESSAGE); sqlExc.printStackTrace(); } tableModel = new MyDefaultTableModel(rows, columns); table = new JTable(tableModel); table.getSelectionModel().addListSelectionListener(this); table.addMouseListener(this); table.getTableHeader().setOpaque(true); table.getTableHeader().setReorderingAllowed(false); // table.getTableHeader().setBackground(Color.blue); table.getTableHeader().setForeground(Color.blue); // table.setRowSelectionAllowed(false); // table.setColumnSelectionAllowed(false); table.setFont(new Font(Font.SANS_SERIF, Font.PLAIN, 14)); table.setRowHeight(20); table.setFillsViewportHeight(true); TableColumn column = null; for (int i = 0; i < 5; i++) { column = table.getColumnModel().getColumn(i); if (i == 0) { column.setPreferredWidth(6); } else if (i == 3) { column.setPreferredWidth(250); } else if (i == 4) { column.setPreferredWidth(450); } else { column.setPreferredWidth(40); } } table.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS); remove(contentPan); contentPan = new JScrollPane(table); contentPan.setBackground(Color.orange); contentPan.setOpaque(true); contentPan.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0)); add(contentPan, "Center"); Home.home.homeFrame.setVisible(true); } else { JPanel centPan = new JPanel(new GridBagLayout()); centPan.setBackground(new Color(52, 86, 70)); JLabel label = new JLabel("No Messages In This Category"); label.setFont(new Font(Font.SANS_SERIF, Font.BOLD, 22)); label.setForeground(Color.orange); centPan.add(label); remove(contentPan); contentPan = new JScrollPane(centPan); contentPan.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0)); add(contentPan, "Center"); contentPan.repaint(); } }
public void tableChanged(TableModelEvent tme) { int baris = tme.getFirstRow(); int kolom = tme.getColumn(); TableModel model = (TableModel) tme.getSource(); int id = (Integer) model.getValueAt(baris, 0); String query = ""; switch (kolom) { case 1: String nama = (String) model.getValueAt(baris, kolom); query = "UPDATE produk SET nama_produk='" + nama + "' WHERE id_produk=" + id; prosesEdit(query); break; case 2: String jenis = (String) model.getValueAt(baris, kolom); try { query = "select * from jenis where nama_jenis='" + jenis + "'"; ResultSet rs = stm.executeQuery(query); if (rs.next()) { int idJenis = rs.getInt("id_jenis"); query = "UPDATE produk SET id_jenis=" + idJenis + " WHERE id_produk=" + id; prosesEdit(query); } else { setDataTabel(); JOptionPane.showMessageDialog(null, "gagal,jenis tidak ada"); } } catch (SQLException SQLerr) { SQLerr.printStackTrace(); } break; case 3: int stok = (Integer) model.getValueAt(baris, kolom); query = "UPDATE `stok_produk` SET stok=" + stok + " WHERE id_produk=" + id; prosesEdit(query); break; case 4: int harga = (Integer) model.getValueAt(baris, kolom); query = "UPDATE produk SET harga=" + harga + " WHERE id_produk=" + id; prosesEdit(query); break; case 5: String suplier = (String) model.getValueAt(baris, kolom); try { query = "SELECT * FROM suplier WHERE nama_suplier='" + suplier + "'"; ResultSet rs = stm.executeQuery(query); if (rs.next()) { int idSuplier = rs.getInt("id_suplier"); query = "UPDATE produk SET id_suplier=" + idSuplier + " WHERE id_produk=" + id; prosesEdit(query); } else { setDataTabel(); JOptionPane.showMessageDialog(null, "gagal,suplier belum terdaftar"); } } catch (SQLException SQLerr) { SQLerr.printStackTrace(); } break; default: break; } }
public General_Info() { pic.setIcon(userPic); String url = "jdbc:odbc:lib"; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connection = DriverManager.getConnection(url); } catch (ClassNotFoundException cnfex) { System.err.println("Failed to load driver"); cnfex.printStackTrace(); System.exit(1); } catch (SQLException sqlex) { System.err.println("unable to connect"); sqlex.printStackTrace(); } // validation for telephone tel_text.addKeyListener( new KeyAdapter() { public void keyTyped(KeyEvent e) { char c = e.getKeyChar(); if (!((Character.isDigit(c) || (c == KeyEvent.VK_BACK_SPACE) || (c == KeyEvent.VK_DELETE)))) { getToolkit().beep(); e.consume(); } } }); // validation for fax fax_text.addKeyListener( new KeyAdapter() { public void keyTyped(KeyEvent e) { char c = e.getKeyChar(); if (!((Character.isDigit(c) || (c == KeyEvent.VK_BACK_SPACE) || (c == KeyEvent.VK_DELETE)))) { getToolkit().beep(); e.consume(); } } }); patron_text.setText("P-"); patron_text.addFocusListener( new MyActionListener() { public void focusLost(FocusEvent e) { try { Statement statement = connection.createStatement(); String query2 = "SELECT * FROM patronmaster " + "WHERE id = '" + patron_text.getText() + "'"; ResultSet rs2 = statement.executeQuery(query2); int cnt = 0; while (rs2.next()) { cnt++; } if (cnt != 0) { try { userPic = new ImageIcon(patron_text.getText() + ".gif"); pic.setIcon(userPic); } catch (Exception ex) { ex.printStackTrace(); pic.setIcon(userPic); } String query1 = "SELECT * FROM patronmaster " + "WHERE id = '" + patron_text.getText() + "'"; ResultSet rs1 = statement.executeQuery(query1); try { rs1.next(); int confirm = JOptionPane.showConfirmDialog( null, "This record Exists, would you like to update it?", "CONFIRM", JOptionPane.YES_NO_OPTION); if (confirm == JOptionPane.NO_OPTION) { patron_text.setEditable(false); name_text.setEditable(false); passport_text.setEditable(false); expiry_date_text.setEditable(false); reg_by_text.setEditable(false); reg_date_text.setEditable(false); textArea.setEditable(false); tel_text.setEditable(false); fax_text.setEditable(false); email_text.setEditable(false); } else { } name_text.setText(rs1.getString(2)); passport_text.setText(rs1.getString(3)); expiry_date_text.setText(rs1.getString(6)); reg_by_text.setText(rs1.getString(7)); reg_date_text.setText(rs1.getString(8)); textArea.setText(rs1.getString(9)); tel_text.setText(rs1.getString(10)); fax_text.setText(rs1.getString(11)); email_text.setText(rs1.getString(12)); status_combo.setSelectedItem(rs1.getString(4)); salute_combo.setSelectedItem(rs1.getString(5)); group_combo.setSelectedItem(rs1.getString(13)); statement.close(); } catch (SQLException sqlex) { pic.setIcon(userPic); } } } catch (SQLException sqlex) { pic.setIcon(userPic); } } }); scroll.add(address); scroll.add(scrollPane); text.setLayout(new GridBagLayout()); GridBagConstraints gbc = new GridBagConstraints(); gbc.gridy = 0; gbc.gridx = 0; text.add(tel, gbc); gbc.gridy = 1; text.add(fax, gbc); gbc.gridy = 2; text.add(email, gbc); gbc.gridy = 0; gbc.gridx = 2; text.add(tel_text, gbc); gbc.gridy = 1; text.add(fax_text, gbc); gbc.gridy = 2; text.add(email_text, gbc); pic.setSize(50, 50); pane1.add(scroll, BorderLayout.CENTER); pane1.add(pic, BorderLayout.EAST); pane1.add(text, BorderLayout.WEST); add(pane1); }
public void actionPerformed(ActionEvent event) { // if clear button is pressed, clear all fields if (event.getSource() == clear_button) { // erase all fields taskname_field.setText(""); taskdesc_field.setText(""); priority_checkbox.setSelected(false); numberofdays_field.setText(""); // isallocatedcheckbox.setSelected(false); duedate_field.setText(""); } // if submit button is pressed, save all data onto database if (event.getSource() == submit_button) { try { { Calendar calendar = Calendar.getInstance(); calendar.setTime(new Date()); // set to current date calendar.add( Calendar.DAY_OF_MONTH, Integer.parseInt(this.numberofdays_field.getText()) - 1); // add days required... then: // ^ subtract one day, because if task is created today and allocated tomorrow for one // day, // then it should be done by end of day tomorrow Date date = calendar.getTime(); // (see next *1) use this date to be the earliest // because of expected task duration /*This is a constraint * the date and the length of days that user expected to take * if not feasible then the program will say so * */ // method compares the current date and the date that was entered by the user if (this.task_idfield.getText().length() != 7 // check chars || this.taskname_field.getText().length() > 50 // check chars || this.taskdesc_field.getText().length() > 50 || ((Date) this.duedate_field.getValue()).compareTo(date) < 0 // check that the date is possible (see last *1) || this.numberofdays_field.getText().length() > 2 || this.numberofdays_field.getText().length() == 0 // check number of digits || Integer.parseInt(this.numberofdays_field.getText()) < 1) // check number of days required for task { JOptionPane.showMessageDialog( this, "Task ID has to be 7 chars; " + "\n" + "Description <= 50 chars; " + "\n" + "Because the expected duration of the task is " + Integer.parseInt(this.numberofdays_field.getText()) + " days, the due date cannot be earlier than: " + new StringBuffer(new SimpleDateFormat("dd/MM/yyyy").format(date)).toString() + "; " + "\n" + "Task duration must be 2 digit number maximum and must be an integer greater than 0"); } else // check if taskid_field is equals to any of the fields on the database if (task_idfield.equals("")) { JOptionPane.showMessageDialog( this, "Please insert an identification number for a task"); } else // add constraint and tell customer to enter 7 values if (taskname_field.equals("")) { JOptionPane.showMessageDialog(this, "Please insert a name to identity the task"); } else { // get all inputs from user inputs and store in variables taskid_input = task_idfield.getText(); taskname_input = taskname_field.getText(); taskdesc_input = taskdesc_field.getText(); if (priority_checkbox.isSelected()) { priority_input = 1; } else { priority_input = 0; } // create and store date from user input date = (Date) duedate_field.getValue(); // store number of days input from user numberofdays_input = Integer.parseInt(numberofdays_field.getText()); // String[] column_names = { "Task ID", "Task Name", "Task Description", "Task // Priority", "Due Date", "Number of Days", "Is Allocated" , "Unallocateable" }; task = new Object[8]; task[0] = taskid_input; task[1] = taskname_input; task[2] = taskdesc_input; task[3] = priority_input; task[4] = date; task[5] = numberofdays_input; task[6] = 0; task[7] = 0; try { // SqlConnection.connect(); SqlConnection.ps = SqlConnection.connection.prepareStatement( "INSERT INTO TASK VALUES (?,?,?,?,?,?,?,?)"); SqlConnection.ps.setString(1, taskid_input); SqlConnection.ps.setString(2, taskname_input); SqlConnection.ps.setString(3, taskdesc_input); SqlConnection.ps.setInt(4, priority_input); SqlConnection.ps.setDate(5, new java.sql.Date(date.getTime())); SqlConnection.ps.setInt(6, numberofdays_input); SqlConnection.ps.setInt(7, 0); SqlConnection.ps.setInt(8, 0); SqlConnection.ps.executeUpdate(); // now enter skills into TASK SKILL database for (int i = 0; i < skill_list.size(); i++) { if (skill_list.get(i).isSelected()) { String skillid = skill_list.get(i).getText(); SqlConnection.statement.executeUpdate( "INSERT INTO TASKSKILL VALUES ('" + taskid_input + "', '" + skillid + "')"); } } SqlConnection.ps.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } // SqlConnection.ps.close(); SqlConnection.closeConnection(); this.setVisible(false); } } } catch (Exception exc) { JOptionPane.showMessageDialog( this, "Check your inputs:" + "\n" + "Priority has to be a 1-digit number;" + "\n" + "Date has to be in the format dd/MM/yyyy;" + "\n" + "Task length has to be 2-digit number"); System.out.println(exc); } } // display dialog box asking task manager if they want to quit, // if task manager does not want to quit, go back to adding more tasks // if customer quits, close the dialog box and the frame // now close the window after saving }
/** Process Button Pressed - Process Matching */ private void cmd_newProduct() { // Selecciono el departamento int depart = 0; String SQL = "Select XX_VMR_DEPARTMENT_ID " + "from XX_VMR_VENDORPRODREF " + "where XX_VMR_VENDORPRODREF_ID=" + LineRefProv.getXX_VMR_VendorProdRef_ID(); try { PreparedStatement pstmt = DB.prepareStatement(SQL, null); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { depart = rs.getInt("XX_VMR_DEPARTMENT_ID"); } rs.close(); pstmt.close(); } catch (Exception a) { log.log(Level.SEVERE, SQL, a); } MVMRVendorProdRef vendorProdRef = new MVMRVendorProdRef(Env.getCtx(), LineRefProv.getXX_VMR_VendorProdRef_ID(), null); if (vendorProdRef.getXX_VMR_ProductClass_ID() > 0 && vendorProdRef.getXX_VMR_TypeLabel_ID() > 0) { MOrder order = new MOrder(Env.getCtx(), LineRefProv.getC_Order_ID(), null); // Selecciono el departamento X_XX_VMR_Department dept = new X_XX_VMR_Department(Env.getCtx(), vendorProdRef.getXX_VMR_Department_ID(), null); int category = dept.getXX_VMR_Category_ID(); // Selecciono la línea X_XX_VMR_Line line = new X_XX_VMR_Line(Env.getCtx(), vendorProdRef.getXX_VMR_Line_ID(), null); int typeInventory = line.getXX_VMR_TypeInventory_ID(); MProduct newProduct = new MProduct( Env.getCtx(), vendorProdRef.getXX_VMR_Department_ID(), vendorProdRef.getXX_VMR_Line_ID(), vendorProdRef.getXX_VMR_Section_ID(), vendorProdRef.get_ID(), vendorProdRef.getC_TaxCategory_ID(), vendorProdRef.getXX_VME_ConceptValue_ID(), typeInventory, null); // Se buscará si por la referencia para producto ya existe para asignarle el Tipo de // Exhibición String sql = "select * from M_Product where XX_VMR_DEPARTMENT_ID = " + vendorProdRef.getXX_VMR_Department_ID() + " and " + "XX_VMR_LINE_ID = " + vendorProdRef.getXX_VMR_Line_ID() + " and XX_VMR_SECTION_ID = " + vendorProdRef.getXX_VMR_Section_ID() + " and " + "XX_VMR_VendorProdRef_id = " + vendorProdRef.getXX_VMR_VendorProdRef_ID() + " order by M_Product_ID desc"; PreparedStatement pstmt = DB.prepareStatement(sql, null); ResultSet rs = null; try { rs = pstmt.executeQuery(); if (rs.next()) newProduct.setXX_VMR_TypeExhibition_ID(rs.getInt("XX_VMR_TypeExhibition_ID")); } catch (SQLException e) { e.printStackTrace(); } finally { DB.closeResultSet(rs); DB.closeStatement(pstmt); } if (vendorProdRef.getXX_VMR_Section_ID() > 0) { X_XX_VMR_Section section = new X_XX_VMR_Section(Env.getCtx(), vendorProdRef.getXX_VMR_Section_ID(), null); newProduct.setName(section.getName()); } else { newProduct.setName(vendorProdRef.getName()); } newProduct.setXX_VMR_Category_ID(category); newProduct.setXX_VMR_LongCharacteristic_ID(vendorProdRef.getXX_VMR_LongCharacteristic_ID()); newProduct.setXX_VMR_Brand_ID(vendorProdRef.getXX_VMR_Brand_ID()); newProduct.setXX_VMR_UnitConversion_ID(vendorProdRef.getXX_VMR_UnitConversion_ID()); newProduct.setXX_PiecesBySale_ID(vendorProdRef.getXX_PiecesBySale_ID()); newProduct.setXX_VMR_UnitPurchase_ID(vendorProdRef.getXX_VMR_UnitPurchase_ID()); newProduct.setXX_SaleUnit_ID(vendorProdRef.getXX_SaleUnit_ID()); newProduct.setC_Country_ID(order.getC_Country_ID()); newProduct.setIsActive(true); newProduct.setC_BPartner_ID(vendorProdRef.getC_BPartner_ID()); newProduct.setXX_VMR_TypeLabel_ID(vendorProdRef.getXX_VMR_TypeLabel_ID()); newProduct.setXX_VMR_ProductClass_ID(vendorProdRef.getXX_VMR_ProductClass_ID()); newProduct.setM_AttributeSet_ID(Env.getCtx().getContextAsInt("#XX_L_P_ATTRIBUTESETST_ID")); newProduct.setProductType(X_Ref_M_Product_ProductType.ITEM.getValue()); newProduct.save(); } else { // Creo variables de sesion para atraparlas en la ventana producto Env.getCtx().setContext("#Depart_Aux", depart); Env.getCtx().setContext("#Section_Aux", LineRefProv.getXX_VMR_Section_ID()); Env.getCtx().setContext("#Line_Aux", LineRefProv.getXX_VMR_Line_ID()); Env.getCtx().setContext("#VendorRef_Aux", LineRefProv.getXX_VMR_VendorProdRef_ID()); Env.getCtx().setContext("#FromProcess_Aux", "Y"); AWindow window_product = new AWindow(); Query query = Query.getNoRecordQuery("M_Product", true); window_product.initWindow(140, query); AEnv.showCenterScreen(window_product); // Obtenemos el GridController para setear la variable m_changed=true JRootPane jRootPane = ((JRootPane) window_product.getComponent(0)); JLayeredPane jLayeredPane = (JLayeredPane) jRootPane.getComponent(1); JPanel jPanel = (JPanel) jLayeredPane.getComponent(0); APanel aPanel = (APanel) jPanel.getComponent(0); VTabbedPane vTabbedPane = (VTabbedPane) aPanel.getComponent(0); GridController gridController = (GridController) vTabbedPane.getComponent(0); GridTable mTable = gridController.getMTab().getTableModel(); mTable.setChanged(true); MProduct.loadLineRefProv(LineRefProv, Env.getCtx()); // Borro las variables de sesion creadas Env.getCtx().remove("#Depart_Aux"); Env.getCtx().remove("#FromProcess_Aux"); Env.getCtx().remove("#Line_Aux"); Env.getCtx().remove("#Section_Aux"); Env.getCtx().remove("#VendorRef_Aux"); } } // cmd_newProduct
public Summary(int patient_id) { this.patient_id = patient_id; setTitle("Summary"); setSize( (int) (Toolkit.getDefaultToolkit().getScreenSize().getWidth()), (int) (Toolkit.getDefaultToolkit().getScreenSize().getHeight()) - 40); setResizable(false); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); head = new JLabel("MEDI_SCAN DIAGNOSTIC LAB SERVICES", SwingConstants.CENTER); head.setForeground(Color.WHITE); Font f2 = new Font("Papyrus", Font.BOLD, 36); head.setFont(f2); res = new JLabel("RESULT SUMMARY", SwingConstants.CENTER); res.setForeground(Color.WHITE); Font f3 = new Font("Papyrus", Font.BOLD, 28); res.setFont(f3); Font f1 = new Font("Goudy Old Style", Font.BOLD, 16); hello = new JLabel("Hello Mr./Miss "); hello.setForeground(new Color(54, 34, 174)); hello.setFont(f1); fin = new JLabel("Your Medical Test Is Finished"); fin.setFont(f1); fin.setForeground(new Color(54, 34, 174)); pname = new JLabel("Patient Name"); pname.setForeground(new Color(54, 34, 174)); pname.setFont(f1); ldate = new JLabel("Test Date"); ldate.setForeground(new Color(54, 34, 174)); ldate.setFont(f1); age = new JLabel("Age"); age.setForeground(new Color(54, 34, 174)); age.setFont(f1); sex = new JLabel("Sex"); sex.setForeground(new Color(54, 34, 174)); sex.setFont(f1); tname = new JLabel("Test Name"); tname.setForeground(new Color(54, 34, 174)); tname.setFont(f1); nvalue = new JLabel("Normal Value"); nvalue.setForeground(new Color(54, 34, 174)); nvalue.setFont(f1); trate = new JLabel("Test Rate"); trate.setForeground(new Color(54, 34, 174)); trate.setFont(f1); tresult = new JLabel("Test Result"); tresult.setForeground(new Color(54, 34, 174)); tresult.setFont(f1); tamt = new JLabel("Total Amout"); tamt.setForeground(new Color(54, 34, 174)); tamt.setFont(f1); exit = new JButton("EXIT"); exit.setFont(f1); pHead = new JPanel(new GridLayout(2, 1)); pHead.setBackground(new Color(134, 134, 234)); pCenter = new JPanel(new GridBagLayout()); pCenter.setBackground(new Color(211, 248, 253)); pCom = new JPanel(new BorderLayout()); pCom.setBackground(new Color(211, 248, 253)); pSouth = new JPanel(new FlowLayout(FlowLayout.RIGHT)); pSouth.setBackground(new Color(211, 248, 253)); // Adding Icon on top-left. ImageIcon img = new ImageIcon("pics/logo.jpg"); this.setIconImage(img.getImage()); try { Connection con = JDBCConnection.getConnection(); PreparedStatement pstmt = con.prepareStatement( "Select first_name,last_name,age,sex,test_id,tdate from patientreg where patient_id=?"); pstmt.setInt(1, this.patient_id); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { first_name = rs.getString("first_name"); lname = rs.getString("last_name"); name = new JLabel(first_name + " " + lname); name1 = new JLabel(first_name + " " + lname); p_age = rs.getInt("age"); pAge = new JLabel(p_age + ""); p_sex = rs.getString("sex"); psex = new JLabel(p_sex); t_id = rs.getInt("test_id"); t_date = rs.getString("tdate"); date1 = new JLabel(t_date); } } catch (SQLException s) { s.printStackTrace(); } try { Connection con = JDBCConnection.getConnection(); PreparedStatement pstmt = con.prepareStatement("Select test_result from reportbydoctor where patient_id=?"); pstmt.setInt(1, this.patient_id); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { te_res = rs.getString("test_result"); result = new JLabel(te_res); } } catch (SQLException s) { s.printStackTrace(); } try { Connection con = JDBCConnection.getConnection(); PreparedStatement pstmt = con.prepareStatement("select normal_val,rate,test_name from addtest where test_id=?"); pstmt.setInt(1, t_id); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { n_value = rs.getInt("normal_val"); normal_value1 = new JLabel(n_value + ""); te_rate = rs.getInt("rate"); rate1 = new JLabel(te_rate + ""); rate2 = new JLabel(te_rate + ""); te_name = rs.getString("test_name"); testname = new JLabel(te_name); } } catch (SQLException a) { a.printStackTrace(); } content = getContentPane(); // for label hello GridBagConstraints gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 1; gc.gridwidth = 1; gc.gridy = 1; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 50, 20, 0); pCenter.add(hello, gc); // for label name1 gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 2; gc.gridwidth = 1; gc.gridy = 1; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 0); pCenter.add(name1, gc); // for label fin gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 3; gc.gridwidth = 2; gc.gridy = 1; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(fin, gc); // for label pname gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 1; gc.gridwidth = 1; gc.gridy = 2; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(pname, gc); // for label name gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 2; gc.gridwidth = 1; gc.gridy = 2; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(name, gc); // for label ldate gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 1; gc.gridwidth = 1; gc.gridy = 3; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(ldate, gc); // for label date1 gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 2; gc.gridwidth = 1; gc.gridy = 3; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(date1, gc); // for label age gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 1; gc.gridwidth = 1; gc.gridy = 4; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(age, gc); // for label pAge gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 2; gc.gridwidth = 1; gc.gridy = 4; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(pAge, gc); // for label sex gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 1; gc.gridwidth = 1; gc.gridy = 5; gc.ipadx = 125; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(sex, gc); // for label psex gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 2; gc.gridwidth = 1; gc.gridy = 5; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(psex, gc); // for label tname gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 1; gc.gridwidth = 1; gc.gridy = 6; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(tname, gc); // for label nvalue gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 2; gc.gridwidth = 1; gc.gridy = 6; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(nvalue, gc); // for label trate gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 3; gc.gridwidth = 1; gc.gridy = 6; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(trate, gc); // for label tresult gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 4; gc.gridwidth = 1; gc.gridy = 6; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(tresult, gc); // for label testname gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 1; gc.gridwidth = 1; gc.gridy = 7; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(testname, gc); // for label normal_value1 gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 2; gc.gridwidth = 1; gc.gridy = 7; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(normal_value1, gc); // for label rate1 gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 3; gc.gridwidth = 1; gc.gridy = 7; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(rate1, gc); // for label result gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 4; gc.gridwidth = 1; gc.gridy = 7; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(result, gc); // for label tamt gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 3; gc.gridwidth = 1; gc.gridy = 8; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(tamt, gc); // for label rate2 gc = new GridBagConstraints(); gc.fill = GridBagConstraints.NONE; gc.gridx = 4; gc.gridwidth = 1; gc.gridy = 8; gc.ipadx = 0; gc.ipady = 10; gc.weightx = 0; gc.weighty = 0; gc.anchor = GridBagConstraints.WEST; gc.insets = new Insets(0, 0, 20, 20); pCenter.add(rate2, gc); exit.addActionListener(this); pSouth.add(exit); content.add(pSouth, BorderLayout.SOUTH); pHead.add(head); pHead.add(res); content.add(pHead, BorderLayout.NORTH); content.add(pCenter, BorderLayout.CENTER); setVisible(true); }