Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package TanuloNyilvantarto;
- import java.awt.Dimension;
- import java.awt.HeadlessException;
- import java.awt.Toolkit;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.ArrayList;
- import javax.swing.JOptionPane;
- import javax.swing.table.DefaultTableModel;
- import javax.swing.table.TableModel;
- /**
- *
- * @author Szabi
- */
- public class TanuloNyilvantarto extends javax.swing.JFrame {
- //Kereses getter, setter metódus
- public class User {
- private int id;
- private String fname;
- private String lname;
- private String genderclone;
- private int age;
- public User(int Id,String Fname,String Lname,String Genderclone,int Age)
- {
- this.id = Id;
- this.fname = Fname;
- this.lname = Lname;
- this.genderclone = Genderclone;
- this.age = Age;
- }
- public int getId()
- {
- return id;
- }
- public String getFname()
- {
- return fname;
- }
- public String getLname()
- {
- return lname;
- }
- public String getGenderclone()
- {
- return genderclone;
- }
- public int getAge()
- {
- return age;
- }
- }
- //*Kereses getter, setter metódus
- //Getter, Setter metódus
- private int azonosito;
- private String vnev;
- private String knev;
- private String gender;
- private int kor;
- public TanuloNyilvantarto(int Azonosito, String Vnev, String Knev, String Gender,int Kor )
- {
- this.azonosito = Azonosito;
- this.vnev = Vnev;
- this.knev = Knev;
- this.gender = Gender;
- this.kor = Kor;
- }
- public int getAzonosito()
- {
- return azonosito;
- }
- public String getVnev()
- {
- return vnev;
- }
- public String getKnev()
- {
- return knev;
- }
- public String getGender()
- {
- return gender;
- }
- public int getKor()
- {
- return kor;
- }
- //*Getter, Setter metódus
- public TanuloNyilvantarto() {
- initComponents();
- Show_tanulok_In_JTable();
- //keresés meghívás
- keresTanulo();
- //eddig
- //Center
- Dimension dim=Toolkit.getDefaultToolkit().getScreenSize();
- int framewidth=this.getSize().width;//get the width of the frame
- int frameheigth=this.getSize().height; //get the heigth of the frame
- int framelocationX=(dim.width-framewidth)/2;
- int framelocationY=(dim.height-frameheigth)/2;
- this.setLocation(framelocationX,framelocationY);
- //Üdv panel betöltés elsőnek
- fopanel.removeAll();
- fopanel.add(udv_panel);
- fopanel.repaint();
- fopanel.revalidate();
- //*Üdv panel betöltés elsőnek
- //*Center
- }
- public Connection getConnection()
- {
- Connection con;
- try {
- con = DriverManager.getConnection("jdbc:mysql://localhost/tanulonyilvantarto", "root","");
- return con;
- }
- catch (SQLException e) {
- return null;
- }
- }
- //köv:
- public ArrayList<TanuloNyilvantarto> gettanulokList()
- {
- ArrayList<TanuloNyilvantarto> tanulokList = new ArrayList<>();
- Connection connection = getConnection();
- String query = "SELECT * FROM `tanulok` ";
- Statement st;
- ResultSet rs;
- try {
- st = connection.createStatement();
- rs = st.executeQuery(query);
- TanuloNyilvantarto tanulok;
- while(rs.next())
- {
- tanulok = new TanuloNyilvantarto(rs.getInt("azonosito"),rs.getString("vnev"),rs.getString("knev"),rs.getString("gender"),rs.getInt("kor"));
- tanulokList.add(tanulok);
- }
- }
- catch (SQLException e) {
- }
- return tanulokList;
- }
- public void Show_tanulok_In_JTable()
- {
- ArrayList<TanuloNyilvantarto> list = gettanulokList();
- DefaultTableModel model = (DefaultTableModel)tanulok_tabla.getModel();
- Object[] row = new Object[5];
- for(int i = 0; i < list.size(); i++)
- {
- row[0] = list.get(i).getAzonosito();
- row[1] = list.get(i).getVnev();
- row[2] = list.get(i).getKnev();
- row[3] = list.get(i).getGender();
- row[4] = list.get(i).getKor();
- model.addRow(row);
- }
- }
- //keresés lekérése a táblába:
- // function to return users arraylist with particular data
- public ArrayList<User> ListUsers(String ValToSearch)
- {
- ArrayList<User> usersList = new ArrayList<User>();
- Statement st;
- ResultSet rs;
- try{
- Connection con = getConnection();
- st = con.createStatement();
- String searchQuery = "SELECT * FROM `tanulok` WHERE CONCAT(`azonosito`, `vnev`, `knev`, `gender`,`kor`) LIKE '%"+ValToSearch+"%'";
- rs = st.executeQuery(searchQuery);
- User user;
- while(rs.next())
- {
- user = new User(
- rs.getInt("azonosito"),
- rs.getString("vnev"),
- rs.getString("knev"),
- rs.getString("gender"),
- rs.getInt("kor")
- );
- usersList.add(user);
- }
- }catch(Exception ex){
- System.out.println(ex.getMessage());
- }
- return usersList;
- }
- // function to display data in jtable
- public void keresTanulo()
- {
- ArrayList<User> users = ListUsers(kereses_szoveg_hely.getText());
- DefaultTableModel model = new DefaultTableModel();
- model.setColumnIdentifiers(new Object[]{"Azonositó","Keresztnév","Vezetéknev","Nem","Kor"});
- Object[] row = new Object[5];
- for(int i = 0; i < users.size(); i++)
- {
- row[0] = users.get(i).getId();
- row[1] = users.get(i).getFname();
- row[2] = users.get(i).getLname();
- row[3] = users.get(i).getGenderclone();
- row[4] = users.get(i).getAge();
- model.addRow(row);
- }
- kereses_tabla.setModel(model);
- }
- //kereseseddig
- public void executeSQlQuery(String query, String message)
- {
- Connection con = getConnection();
- Statement st;
- try{
- st = con.createStatement();
- if((st.executeUpdate(query)) == 1)
- {
- // refresh jtable data
- DefaultTableModel model = (DefaultTableModel)tanulok_tabla.getModel();
- model.setRowCount(0);
- Show_tanulok_In_JTable();
- JOptionPane.showMessageDialog(null, "A tanulót sikerült "+message);
- }else{
- JOptionPane.showMessageDialog(null, "A tanulót nem sikerült "+message);
- }
- }catch(HeadlessException | SQLException ex){
- }
- }
- /**
- * 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() {
- fopanel = new javax.swing.JPanel();
- udv_panel = new javax.swing.JPanel();
- jLabel1 = new javax.swing.JLabel();
- termekadmin_panel = new javax.swing.JPanel();
- Gorgeto = new javax.swing.JScrollPane();
- tanulok_tabla = new javax.swing.JTable();
- azonosito_cimke = new javax.swing.JLabel();
- vezeteknev_cimke = new javax.swing.JLabel();
- azonosito_mezo = new javax.swing.JTextField();
- vezeteknev_mezo = new javax.swing.JTextField();
- keresztnev_cimke = new javax.swing.JLabel();
- kor_cimke = new javax.swing.JLabel();
- keresztnev_mezo = new javax.swing.JTextField();
- kor_mezo = new javax.swing.JTextField();
- hozzaad = new javax.swing.JButton();
- modosit = new javax.swing.JButton();
- torles = new javax.swing.JButton();
- gender_selector = new javax.swing.JComboBox<>();
- kereses_panel = new javax.swing.JPanel();
- Gorgeto2 = new javax.swing.JScrollPane();
- kereses_tabla = new javax.swing.JTable();
- kereses_szoveg_hely = new javax.swing.JTextField();
- kereses_gomb = new javax.swing.JButton();
- nevjegy_panel = new javax.swing.JPanel();
- nevjegy_cimke_1 = new javax.swing.JLabel();
- menubar = new javax.swing.JMenuBar();
- fomenu = new javax.swing.JMenu();
- termekadmin_menu_elem = new javax.swing.JMenuItem();
- kereses_menu_elem = new javax.swing.JMenuItem();
- nevjegy_menu_elem = new javax.swing.JMenuItem();
- kilepes_menu_elem = new javax.swing.JMenuItem();
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- fopanel.setOpaque(false);
- fopanel.setPreferredSize(new java.awt.Dimension(800, 600));
- udv_panel.setPreferredSize(new java.awt.Dimension(800, 600));
- jLabel1.setFont(new java.awt.Font("Arial Black", 1, 18)); // NOI18N
- jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
- jLabel1.setText("Üdvözlöm a Tanuló Nyilvántartó v1.0 programban!");
- javax.swing.GroupLayout udv_panelLayout = new javax.swing.GroupLayout(udv_panel);
- udv_panel.setLayout(udv_panelLayout);
- udv_panelLayout.setHorizontalGroup(
- udv_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(udv_panelLayout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, 790, Short.MAX_VALUE))
- );
- udv_panelLayout.setVerticalGroup(
- udv_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(udv_panelLayout.createSequentialGroup()
- .addGap(169, 169, 169)
- .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 200, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addContainerGap(212, Short.MAX_VALUE))
- );
- tanulok_tabla.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- },
- new String [] {
- "Azonosító", "Vezetéknév", "Keresztnév", "Nem", "Kor"
- }
- ));
- tanulok_tabla.addMouseListener(new java.awt.event.MouseAdapter() {
- public void mouseClicked(java.awt.event.MouseEvent evt) {
- tanulok_tablaMouseClicked(evt);
- }
- });
- Gorgeto.setViewportView(tanulok_tabla);
- azonosito_cimke.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
- azonosito_cimke.setText("Azonosító:");
- vezeteknev_cimke.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
- vezeteknev_cimke.setText("Vezetéknév:");
- keresztnev_cimke.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
- keresztnev_cimke.setText("Keresztnév:");
- kor_cimke.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
- kor_cimke.setText("Kor:");
- hozzaad.setText("Hozzáad");
- hozzaad.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- hozzaadActionPerformed(evt);
- }
- });
- modosit.setText("Módosít");
- modosit.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- modositActionPerformed(evt);
- }
- });
- torles.setText("Törlés");
- torles.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- torlesActionPerformed(evt);
- }
- });
- gender_selector.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Férfi", "Nő" }));
- gender_selector.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- gender_selectorActionPerformed(evt);
- }
- });
- javax.swing.GroupLayout termekadmin_panelLayout = new javax.swing.GroupLayout(termekadmin_panel);
- termekadmin_panel.setLayout(termekadmin_panelLayout);
- termekadmin_panelLayout.setHorizontalGroup(
- termekadmin_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, termekadmin_panelLayout.createSequentialGroup()
- .addContainerGap(432, Short.MAX_VALUE)
- .addGroup(termekadmin_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(gender_selector, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGroup(termekadmin_panelLayout.createSequentialGroup()
- .addComponent(hozzaad)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(modosit)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(torles)))
- .addGap(173, 173, 173))
- .addGroup(termekadmin_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(termekadmin_panelLayout.createSequentialGroup()
- .addContainerGap()
- .addComponent(Gorgeto, javax.swing.GroupLayout.PREFERRED_SIZE, 400, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(18, 18, 18)
- .addGroup(termekadmin_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(azonosito_mezo)
- .addComponent(vezeteknev_mezo)
- .addComponent(keresztnev_mezo)
- .addComponent(kor_mezo)
- .addGroup(termekadmin_panelLayout.createSequentialGroup()
- .addGroup(termekadmin_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(azonosito_cimke)
- .addComponent(vezeteknev_cimke)
- .addComponent(keresztnev_cimke)
- .addComponent(kor_cimke))
- .addGap(0, 287, Short.MAX_VALUE)))
- .addContainerGap()))
- );
- termekadmin_panelLayout.setVerticalGroup(
- termekadmin_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, termekadmin_panelLayout.createSequentialGroup()
- .addContainerGap(428, Short.MAX_VALUE)
- .addComponent(gender_selector, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(117, 117, 117)
- .addGroup(termekadmin_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(hozzaad)
- .addComponent(modosit)
- .addComponent(torles))
- .addGap(61, 61, 61))
- .addGroup(termekadmin_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(termekadmin_panelLayout.createSequentialGroup()
- .addGap(33, 33, 33)
- .addGroup(termekadmin_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(termekadmin_panelLayout.createSequentialGroup()
- .addComponent(azonosito_cimke)
- .addGap(39, 39, 39)
- .addComponent(azonosito_mezo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(18, 18, 18)
- .addComponent(vezeteknev_cimke)
- .addGap(30, 30, 30)
- .addComponent(vezeteknev_mezo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(29, 29, 29)
- .addComponent(keresztnev_cimke)
- .addGap(18, 18, 18)
- .addComponent(keresztnev_mezo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(18, 18, 18)
- .addComponent(kor_cimke)
- .addGap(18, 18, 18)
- .addComponent(kor_mezo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addComponent(Gorgeto, javax.swing.GroupLayout.PREFERRED_SIZE, 560, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addContainerGap(53, Short.MAX_VALUE)))
- );
- kereses_tabla.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- },
- new String [] {
- "Azonosító", "Vezetéknév", "Keresztnév", "", "Kor"
- }
- ));
- kereses_tabla.addMouseListener(new java.awt.event.MouseAdapter() {
- public void mouseClicked(java.awt.event.MouseEvent evt) {
- kereses_tablaMouseClicked(evt);
- }
- });
- Gorgeto2.setViewportView(kereses_tabla);
- kereses_gomb.setText("Keresés");
- kereses_gomb.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- kereses_gombActionPerformed(evt);
- }
- });
- javax.swing.GroupLayout kereses_panelLayout = new javax.swing.GroupLayout(kereses_panel);
- kereses_panel.setLayout(kereses_panelLayout);
- kereses_panelLayout.setHorizontalGroup(
- kereses_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(kereses_panelLayout.createSequentialGroup()
- .addContainerGap()
- .addComponent(Gorgeto2)
- .addContainerGap())
- .addGroup(kereses_panelLayout.createSequentialGroup()
- .addGap(206, 206, 206)
- .addComponent(kereses_szoveg_hely, javax.swing.GroupLayout.PREFERRED_SIZE, 305, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(kereses_gomb)
- .addContainerGap(168, Short.MAX_VALUE))
- );
- kereses_panelLayout.setVerticalGroup(
- kereses_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(kereses_panelLayout.createSequentialGroup()
- .addGap(55, 55, 55)
- .addGroup(kereses_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(kereses_szoveg_hely, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(kereses_gomb))
- .addGap(40, 40, 40)
- .addComponent(Gorgeto2, javax.swing.GroupLayout.PREFERRED_SIZE, 453, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addContainerGap(56, Short.MAX_VALUE))
- );
- nevjegy_cimke_1.setFont(new java.awt.Font("Arial", 0, 14)); // NOI18N
- nevjegy_cimke_1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
- nevjegy_cimke_1.setText("Ezt a programot Szikszai Szabolcs készítette a fehérgyarmati szoftverfejlesztő képzésre!");
- javax.swing.GroupLayout nevjegy_panelLayout = new javax.swing.GroupLayout(nevjegy_panel);
- nevjegy_panel.setLayout(nevjegy_panelLayout);
- nevjegy_panelLayout.setHorizontalGroup(
- nevjegy_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(nevjegy_panelLayout.createSequentialGroup()
- .addContainerGap()
- .addComponent(nevjegy_cimke_1, javax.swing.GroupLayout.DEFAULT_SIZE, 720, Short.MAX_VALUE)
- .addContainerGap())
- );
- nevjegy_panelLayout.setVerticalGroup(
- nevjegy_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(nevjegy_panelLayout.createSequentialGroup()
- .addContainerGap()
- .addComponent(nevjegy_cimke_1, javax.swing.GroupLayout.PREFERRED_SIZE, 292, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
- );
- javax.swing.GroupLayout fopanelLayout = new javax.swing.GroupLayout(fopanel);
- fopanel.setLayout(fopanelLayout);
- fopanelLayout.setHorizontalGroup(
- fopanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 800, Short.MAX_VALUE)
- .addGroup(fopanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(fopanelLayout.createSequentialGroup()
- .addContainerGap()
- .addComponent(termekadmin_panel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addContainerGap()))
- .addGroup(fopanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(fopanelLayout.createSequentialGroup()
- .addGap(20, 20, 20)
- .addComponent(kereses_panel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addGap(20, 20, 20)))
- .addGroup(fopanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(fopanelLayout.createSequentialGroup()
- .addGap(30, 30, 30)
- .addComponent(nevjegy_panel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addGap(30, 30, 30)))
- .addGroup(fopanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(fopanelLayout.createSequentialGroup()
- .addContainerGap()
- .addComponent(udv_panel, javax.swing.GroupLayout.DEFAULT_SIZE, 780, Short.MAX_VALUE)
- .addContainerGap()))
- );
- fopanelLayout.setVerticalGroup(
- fopanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 0, Short.MAX_VALUE)
- .addGroup(fopanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(fopanelLayout.createSequentialGroup()
- .addContainerGap()
- .addComponent(termekadmin_panel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addContainerGap()))
- .addGroup(fopanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(fopanelLayout.createSequentialGroup()
- .addGap(22, 22, 22)
- .addComponent(kereses_panel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addGap(22, 22, 22)))
- .addGroup(fopanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(fopanelLayout.createSequentialGroup()
- .addGap(22, 22, 22)
- .addComponent(nevjegy_panel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addGap(335, 335, 335)))
- .addGroup(fopanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(fopanelLayout.createSequentialGroup()
- .addGap(45, 45, 45)
- .addComponent(udv_panel, javax.swing.GroupLayout.DEFAULT_SIZE, 581, Short.MAX_VALUE)
- .addGap(45, 45, 45)))
- );
- fomenu.setText("Főmenü");
- termekadmin_menu_elem.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_T, java.awt.event.InputEvent.CTRL_MASK));
- termekadmin_menu_elem.setText("Termékadminisztráció");
- termekadmin_menu_elem.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- termekadmin_menu_elemActionPerformed(evt);
- }
- });
- fomenu.add(termekadmin_menu_elem);
- kereses_menu_elem.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_S, java.awt.event.InputEvent.CTRL_MASK));
- kereses_menu_elem.setText("Keresés");
- kereses_menu_elem.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- kereses_menu_elemActionPerformed(evt);
- }
- });
- fomenu.add(kereses_menu_elem);
- nevjegy_menu_elem.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_N, java.awt.event.InputEvent.CTRL_MASK));
- nevjegy_menu_elem.setText("Névjegy");
- nevjegy_menu_elem.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- nevjegy_menu_elemActionPerformed(evt);
- }
- });
- fomenu.add(nevjegy_menu_elem);
- kilepes_menu_elem.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_K, java.awt.event.InputEvent.CTRL_MASK));
- kilepes_menu_elem.setText("Kilépés");
- kilepes_menu_elem.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- kilepes_menu_elemActionPerformed(evt);
- }
- });
- fomenu.add(kilepes_menu_elem);
- menubar.add(fomenu);
- setJMenuBar(menubar);
- javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
- getContentPane().setLayout(layout);
- layout.setHorizontalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(fopanel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(fopanel, javax.swing.GroupLayout.DEFAULT_SIZE, 668, Short.MAX_VALUE)
- );
- pack();
- }// </editor-fold>
- private void tanulok_tablaMouseClicked(java.awt.event.MouseEvent evt) {
- int i = tanulok_tabla.getSelectedRow();
- TableModel model = tanulok_tabla.getModel();
- // Display Slected Row In JTexteFields
- azonosito_mezo.setText(model.getValueAt(i,0).toString());
- vezeteknev_mezo.setText(model.getValueAt(i,1).toString());
- keresztnev_mezo.setText(model.getValueAt(i,2).toString());
- gender_selector.setSelectedItem(model.getValueAt(i,3).toString());
- kor_mezo.setText(model.getValueAt(i,4).toString());
- }
- private void hozzaadActionPerformed(java.awt.event.ActionEvent evt) {
- String query = "INSERT INTO `tanulok`(`azonosito`,`knev`, `vnev`,`gender`, `kor`) VALUES ('"+azonosito_mezo.getText()+"','"+vezeteknev_mezo.getText()+"','"+keresztnev_mezo.getText()+"',"+(String)gender_selector.getSelectedItem()+","+kor_mezo.getText()+")";
- executeSQlQuery(query, "hozzáadni");
- }
- private void modositActionPerformed(java.awt.event.ActionEvent evt) {
- String query = "UPDATE `tanulok` SET `knev`='"+keresztnev_mezo.getText()+"',`vnev`='"+vezeteknev_mezo.getText()+"',`gender`="+(String)gender_selector.getSelectedItem()+",`kor`="+kor_mezo.getText()+" WHERE `azonosito` = "+azonosito_mezo.getText();
- executeSQlQuery(query, "módosítani");
- }
- private void torlesActionPerformed(java.awt.event.ActionEvent evt) {
- String query = "DELETE FROM `tanulok` WHERE azonosito = "+azonosito_mezo.getText();
- executeSQlQuery(query, "törölni");
- }
- private void kilepes_menu_elemActionPerformed(java.awt.event.ActionEvent evt) {
- System.exit(0);
- }
- private void nevjegy_menu_elemActionPerformed(java.awt.event.ActionEvent evt) {
- fopanel.removeAll();
- fopanel.add(nevjegy_panel);
- fopanel.repaint();
- fopanel.revalidate();
- }
- private void termekadmin_menu_elemActionPerformed(java.awt.event.ActionEvent evt) {
- fopanel.removeAll();
- fopanel.add(termekadmin_panel);
- fopanel.repaint();
- fopanel.revalidate();
- }
- private void kereses_tablaMouseClicked(java.awt.event.MouseEvent evt) {
- // TODO add your handling code here:
- }
- private void kereses_menu_elemActionPerformed(java.awt.event.ActionEvent evt) {
- fopanel.removeAll();
- fopanel.add(kereses_panel);
- fopanel.repaint();
- fopanel.revalidate();
- }
- private void kereses_gombActionPerformed(java.awt.event.ActionEvent evt) {
- keresTanulo();
- }
- private void gender_selectorActionPerformed(java.awt.event.ActionEvent evt) {
- String gender = gender_selector.getSelectedItem().toString();
- }
- /**
- * @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(TanuloNyilvantarto.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (InstantiationException ex) {
- java.util.logging.Logger.getLogger(TanuloNyilvantarto.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (IllegalAccessException ex) {
- java.util.logging.Logger.getLogger(TanuloNyilvantarto.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (javax.swing.UnsupportedLookAndFeelException ex) {
- java.util.logging.Logger.getLogger(TanuloNyilvantarto.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 TanuloNyilvantarto().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JScrollPane Gorgeto;
- private javax.swing.JScrollPane Gorgeto2;
- private javax.swing.JLabel azonosito_cimke;
- private javax.swing.JTextField azonosito_mezo;
- private javax.swing.JMenu fomenu;
- private javax.swing.JPanel fopanel;
- private javax.swing.JComboBox<String> gender_selector;
- private javax.swing.JButton hozzaad;
- private javax.swing.JLabel jLabel1;
- private javax.swing.JButton kereses_gomb;
- private javax.swing.JMenuItem kereses_menu_elem;
- private javax.swing.JPanel kereses_panel;
- private javax.swing.JTextField kereses_szoveg_hely;
- private javax.swing.JTable kereses_tabla;
- private javax.swing.JLabel keresztnev_cimke;
- private javax.swing.JTextField keresztnev_mezo;
- private javax.swing.JMenuItem kilepes_menu_elem;
- private javax.swing.JLabel kor_cimke;
- private javax.swing.JTextField kor_mezo;
- private javax.swing.JMenuBar menubar;
- private javax.swing.JButton modosit;
- private javax.swing.JLabel nevjegy_cimke_1;
- private javax.swing.JMenuItem nevjegy_menu_elem;
- private javax.swing.JPanel nevjegy_panel;
- private javax.swing.JTable tanulok_tabla;
- private javax.swing.JMenuItem termekadmin_menu_elem;
- private javax.swing.JPanel termekadmin_panel;
- private javax.swing.JButton torles;
- private javax.swing.JPanel udv_panel;
- private javax.swing.JLabel vezeteknev_cimke;
- private javax.swing.JTextField vezeteknev_mezo;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement