Главная страница | Контакты | Случайная страница Автомобили Астрономия Биология География Дом и сад Другие языки Другое Информатика История Культура Литература Логика Математика Медицина Металлургия Механика Образование Охрана труда Педагогика Политика Право Психология Религия Риторика Социология Спорт Строительство Технология Туризм Физика Философия Финансы Химия Черчение Экология Экономика Электроника

Додаток 1. Лістинг 3 страница

}

}

//**************************************************************//

// вивід інформації про програму

//**************************************************************//

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {

JOptionPane.showMessageDialog(null, "Програму створив студент групи КН-32, Феделеш В'ячислав", null, WIDTH, null);

}

//**************************************************************//

// пошук інформації

//**************************************************************//

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

if (cbDrugType.getSelectedItem().toString() == "Всі типи")

{

SearchData(txtSearch.getText(),"");

}

else

{

SearchData(txtSearch.getText(),cbDrugType.getSelectedItem().toString());

}

}

//**************************************************************//

// вивід всього списку препаратів

//**************************************************************//

private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {

SearchData("", "");

}

private void txtSearchActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:

}

private void jLabel4MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('А');

}

private void jLabel2MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Б');

}

private void jLabel3MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('В');

}

private void jLabel7MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Г');

}

private void jLabel5MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Ґ');

}

private void jLabel6MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Д');

}

private void jLabel10MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Е');

}

private void jLabel8MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Є');

}

private void jLabel9MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Ж');

}

private void jLabel13MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('З');

}

private void jLabel11MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('И');

}

private void jLabel12MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('І');

}

private void jLabel16MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Ї');

}

private void jLabel14MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Й');

}

private void jLabel15MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('К');

}

private void jLabel24MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Л');

}

private void jLabel25MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('М');

}

private void jLabel17MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Н');

}

private void jLabel26MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('О');

}

private void jLabel27MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('П');

}

private void jLabel20MouseClicked(java.awt.event.MouseEvent

evt) {

SearchAlphabetic('Р');

}

private void jLabel18MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('С');

}

private void jLabel19MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Т');

}

private void jLabel23MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('У');

}

private void jLabel21MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Ф');

}

private void jLabel22MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Х');

}

private void jLabel28MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Ц');

}

private void jLabel31MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Ч');

}

private void jLabel29MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Ш');

}

private void jLabel30MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Щ');

}

private void jLabel33MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Ю');

}

private void jLabel32MouseClicked(java.awt.event.MouseEvent evt) {

SearchAlphabetic('Я');

}

private void jTable1MousePressed(java.awt.event.MouseEvent evt) {

JTable table =(JTable) evt.getSource();

Point p = evt.getPoint();

int row = table.rowAtPoint(p);

if (evt.getClickCount() == 2) {

int fnd = jTable1.getSelectedRow();

String sName = (String)jTable1.getModel().getValueAt(fnd, 0);

jDrugInfo.strType = GetTypeByName(sName);

jDrugInfo.strInfo = GetInfoByDrugName(sName);

jDrugInfo.strForm = GetFormbyDrugName(sName);

jDrugInfo.strEffects = GetEffectbyDrugName(sName);

jDrugInfo.strSave = GetSaveDrugName(sName);

jDrugInfo.strName = sName;

jDrugInfo.iId = GetID(sName, jDrugInfo.strInfo);

jDrugInfo.main(null);

}

}

private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {

JSettings.main(null);

}

/**

* @param args the command line arguments

*/

public static void main(String args[]) {

/* Set the Nimbus look and feel */

//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">

/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.

* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html

*/

try {

for (javax.swing.UIManager.LookAndFeelInfo info: javax.swing.UIManager.getInstalledLookAndFeels()) {

if ("Nimbus".equals(info.getName())) {

javax.swing.UIManager.setLookAndFeel(info.getClassName());

break;

}

}

} catch (ClassNotFoundException ex) {

java.util.logging.Logger.getLogger(JMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (InstantiationException ex) {

java.util.logging.Logger.getLogger(JMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (IllegalAccessException ex) {

java.util.logging.Logger.getLogger(JMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (javax.swing.UnsupportedLookAndFeelException ex)

{ java.util.logging.Logger.getLogger(JMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

}

//</editor-fold>

/* Create and display the form */

java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {

new JMain().setVisible(true);

}

});

}

// Variables declaration - do not modify

private javax.swing.ButtonGroup buttonGroup1;

private javax.swing.JComboBox cbDrugType;

private javax.swing.JButton jButton1;

private javax.swing.JButton jButton2;

private javax.swing.JButton jButton3;

private javax.swing.JButton jButton5;

private javax.swing.JButton jButton6;

private javax.swing.JButton jButton7;

private javax.swing.JLabel jLabel1;

private javax.swing.JLabel jLabel10;

private javax.swing.JLabel jLabel11;

private javax.swing.JLabel jLabel12;

private javax.swing.JLabel jLabel13;

private javax.swing.JLabel jLabel14;

private javax.swing.JLabel jLabel15;

private javax.swing.JLabel jLabel16;

private javax.swing.JLabel jLabel17;

private javax.swing.JLabel jLabel18;

private javax.swing.JLabel jLabel19;

private javax.swing.JLabel jLabel2;

private javax.swing.JLabel jLabel20;

private javax.swing.JLabel jLabel21;

private javax.swing.JLabel jLabel22;

private javax.swing.JLabel jLabel23;

private javax.swing.JLabel jLabel24;

private javax.swing.JLabel jLabel25;

private javax.swing.JLabel jLabel26;

private javax.swing.JLabel jLabel27;

private javax.swing.JLabel jLabel28;

private javax.swing.JLabel jLabel29;

private javax.swing.JLabel jLabel3;

private javax.swing.JLabel jLabel30;

private javax.swing.JLabel jLabel31;

private javax.swing.JLabel jLabel32;

private javax.swing.JLabel jLabel33;

private javax.swing.JLabel jLabel34;

private javax.swing.JLabel jLabel4;

private javax.swing.JLabel jLabel5;

private javax.swing.JLabel jLabel6;

private javax.swing.JLabel jLabel7;

private javax.swing.JLabel jLabel8;

private javax.swing.JLabel jLabel9;

private javax.swing.JScrollPane jScrollPane1;

private javax.swing.JTable jTable1;

private javax.swing.JTextField txtSearch;

// End of variables declaration

}

});

}

// Variables declaration - do not modify

private javax.swing.JButton btEnter;

private javax.swing.JButton btExit;

private javax.swing.JLabel jLabel1;

private javax.swing.JLabel jLabel2;

private javax.swing.JTextField txtLogin;

private javax.swing.JTextField txtPass;

// End of variables declaration

}

import java.awt.Color;

import java.awt.Dimension;

import java.awt.Toolkit;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;

public class JSettings extends javax.swing.JFrame {

/**

* Creates new form JSettings

*/

public JSettings() {

initComponents();

Dimension dim = Toolkit.getDefaultToolkit().getScreenSize();

this.setLocation(dim.width/2-this.getSize().width/2, dim.height/2-this.getSize().height/2);

this.getContentPane().setBackground(new Color(205,175,192));

this.setTitle("Налаштування");

}

/**

* This method is called from within the constructor to initialize the form.

* WARNING: Do NOT modify this code. The content of this method is always

* regenerated by the Form Editor.

*/

@SuppressWarnings("unchecked")

// <editor-fold defaultstate="collapsed" desc="Generated Code">

private void initComponents() {

jLabel1 = new javax.swing.JLabel();

jLabel2 = new javax.swing.JLabel();

txtLogin = new javax.swing.JTextField();

txtPass = new javax.swing.JTextField();

btExit = new javax.swing.JButton();

btEnter = new javax.swing.JButton();

setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);

setResizable(false);

jLabel1.setText("Логін");

jLabel2.setText("Пароль");

btExit.setText("Вихід");

btExit.addActionListener(new

java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

btExitActionPerformed(evt);

}

});

btEnter.setText("Зберегти");

btEnter.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

btEnterActionPerformed(evt);

}

});

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());

getContentPane().setLayout(layout);

layout.setHorizontalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addContainerGap()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addComponent(jLabel1)

.addGap(26, 26, 26)

.addComponent(txtLogin))

.addGroup(layout.createSequentialGroup()

.addComponent(jLabel2)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(txtPass, javax.swing.GroupLayout.DEFAULT_SIZE, 329, Short.MAX_VALUE))

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()

.addGap(0, 0, Short.MAX_VALUE)

.addComponent(btEnter)

.addGap(11, 11, 11)

.addComponent(btExit, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

layout.setVerticalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addGap(10, 10, 10)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel1)

.addComponent(txtLogin, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)).addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel2)

.addComponent(txtPass, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(btEnter)

.addComponent(btExit))

.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

);

pack();

}// </editor-fold>

private void btExitActionPerformed(java.awt.event.ActionEvent evt) {

this.dispose();

}

private void btEnterActionPerformed(java.awt.event.ActionEvent evt) {

String sql = "UPDATE tb_authorization SET login =?, password =? WHERE id = 1";

try {

PreparedStatement pst = JMain.con.prepareStatement(sql);

pst.setString(1, txtLogin.getText());

pst.setString(2, txtPass.getText());

pst.executeUpdate();

} catch(SQLException ex) {

JOptionPane.showMessageDialog(null, "Помилка: " + ex);

Logger.getLogger(JSettings.class.getName()).log(Level.SEVERE, null, ex);

}

this.dispose();

}

/**

* @param args the command line arguments

*/

public static void main(String args[]) {

/* Set the Nimbus look and feel */

//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">

/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.

* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html

*/

try {

for (javax.swing.UIManager.LookAndFeelInfo info: javax.swing.UIManager.getInstalledLookAndFeels()) {

if ("Nimbus".equals(info.getName())) {

javax.swing.UIManager.setLookAndFeel(info.getClassName());

break;

}

}

} catch (ClassNotFoundException ex) {

java.util.logging.Logger.getLogger(JSettings.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (InstantiationException ex) {

java.util.logging.Logger.getLogger(JSettings.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (IllegalAccessException ex) {

java.util.logging.Logger.getLogger(JSettings.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

} catch (javax.swing.UnsupportedLookAndFeelException ex) {

java.util.logging.Logger.getLogger(JSettings.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

}

//</editor-fold>

/* Create and display the form */

java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {

new JSettings().setVisible(true);

}

});

}

// Variables declaration - do not modify

private javax.swing.JButton btEnter;

private javax.swing.JButton btExit;

private javax.swing.JLabel jLabel1;

private javax.swing.JLabel jLabel2;

private javax.swing.JTextField txtLogin;

private javax.swing.JTextField txtPass;

// End of variables declaration

}

import java.awt.Dimension;

import java.awt.Toolkit;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;

import javax.swing.JTable;

/*

* To change this license header, choose License Headers in Project Properties.

* To change this template file, choose Tools | Templates

* and open the template in the editor.

*/

/**

*

* @author 1

*/

public class jAdd extends javax.swing.JFrame {

public static JTable tblList;

/**

* Creates new form jAdd

*/

public jAdd() {

initComponents();

// відцентровуємо форму

Dimension dim = Toolkit.getDefaultToolkit().getScreenSize();

this.setLocation(dim.width/2-this.getSize().width/2, dim.height/2-this.getSize().height/2);

this.setTitle("Введіть інформацію про препарат");

}

/**

* This method is called from within the constructor to initialize the form.

* WARNING: Do NOT modify this code. The content of this method is always

* regenerated by the Form Editor.

*/

@SuppressWarnings("unchecked")

// <editor-fold defaultstate="collapsed" desc="Generated Code">

private void initComponents() {

jButton3 = new javax.swing.JButton();

jButton4 = new javax.swing.JButton();

txtName = new javax.swing.JTextField();

jLabel1 = new javax.swing.JLabel();

jLabel2 = new javax.swing.JLabel();

jScrollPane1 = new javax.swing.JScrollPane();

txtTooltips = new javax.swing.JTextArea();

cbDrugType = new javax.swing.JComboBox();

jLabel3 = new javax.swing.JLabel();

jLabel4 = new javax.swing.JLabel();

jLabel5 = new javax.swing.JLabel();

jScrollPane2 = new javax.swing.JScrollPane();

txtSave = new javax.swing.JTextArea();

jLabel6 = new javax.swing.JLabel();

jScrollPane3 = new javax.swing.JScrollPane();

txtEffects = new javax.swing.JTextArea();

jScrollPane4 = new javax.swing.JScrollPane();

txtForm = new javax.swing.JTextArea();

setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);

setResizable(false);

jButton3.setText("Вихід");

jButton3.addActionListener(new java.awt.ev

ent.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

jButton3ActionPerformed(evt);

}

});

jButton4.setText("Створити");

jButton4.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

jButton4ActionPerformed(evt);

}

});

txtName.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

txtNameActionPerformed(evt);

}

});

jLabel1.setText("Назва препарату");

jLabel2.setText("Опис препарату:");

txtTooltips.setColumns(20);

txtTooltips.setRows(5);

jScrollPane1.setViewportView(txtTooltips);

cbDrugType.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Антибіотики", "Анальгетики", "Антисептики", "Імуностимулятори", "Лікарські рослини", "Наркотики", " " }));

jLabel3.setText("Тип препарату:");

jLabel4.setText("Склад і форма випуску ліки:");

jLabel5.setText("Побічні явища:");

txtSave.setColumns(20);

txtSave.setRows(5);

jScrollPane2.setViewportView(txtSave);

jLabel6.setText("Умови зберігання лікарських засобів:");

txtEffects.setColumns(20);

txtEffects.setRows(5);

jScrollPane3.setViewportView(txtEffects);

txtForm.setColumns(20);

txtForm.setRows(5);

jScrollPane4.setViewportView(txtForm);

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());

getContentPane().setLayout(layout);

layout.setHorizontalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addContainerGap()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel1)

.addComponent(jLabel3))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(cbDrugType, 0, 481, Short.MAX_VALUE)

.addComponent(txtName)))

.addComponent(jScrollPane4,

javax.swing.GroupLayout.Alignment.TRAILING)

.addComponent(jScrollPane2)

.addComponent(jScrollPane1)

.addComponent(jScrollPane3,

javax.swing.GroupLayout.Alignment.TRAILING)

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()

.addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 116, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 116, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGroup(layout.createSequentialGroup()

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addComponent(jLabel4)

.addComponent(jLabel6)

.addComponent(jLabel2)

.addComponent(jLabel5))

.addGap(0, 0, Short.MAX_VALUE)))

.addContainerGap())

);

layout.setVerticalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()

.addGap(10, 10, 10)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(txtName, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel1))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel3)

.addComponent(cbDrugType, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jLabel4)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(jLabel5)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)