1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133
| package com.pl.app;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
public class PanelConsult extends JPanel {
ArrayList t1=new ArrayList();
ArrayList t2=new ArrayList();
ArrayList t3=new ArrayList();
ArrayList t4=new ArrayList();
ArrayList t5=new ArrayList();
ArrayList t6=new ArrayList();
ArrayList t7=new ArrayList();
ArrayList t8=new ArrayList();
ArrayList t9=new ArrayList();
DefaultTableModel model;
JScrollPane scroll=new JScrollPane();
JTable tableau =null;
private JTextField jTextField1;
private JButton jButton1;
private JLabel jLabel1;
private JPanel panelc = new JPanel();
public PanelConsult() {
jTextField1 = new JTextField();
jLabel1 = new JLabel();
jButton1 = new JButton();
jLabel1.setText("Votre recherche");
jButton1.setText("Ok");
jTextField1.setText("Recherche");
GroupLayout layout = new GroupLayout(panelc);
panelc.setLayout(layout);
add(panelc);
layout.setAutoCreateGaps(true);
layout.setAutoCreateContainerGaps(true);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 121, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton1)
.addContainerGap(192, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1)
.addComponent(jButton1))
.addContainerGap(277, Short.MAX_VALUE))
);
jButton1.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
//Shows pnlFirst
ResultSet resultSet = null;
try {
//Variable contenant le titre/auteur/ean à rechercher
String rqt = jTextField1.getText();
//Préparation de l'objet statement
Statement statement = Connecteur.getInstance().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);;
//Création d'un objet Statement
ResultSet result = statement.executeQuery("select * from baseoca where Titre like '%" + rqt + "%' OR Auteur LIKE '%" + rqt + "%' OR EAN LIKE '%" + rqt + "%' ");
while(result.next())
{
t1.add(result.getString("Titre"));
t2.add(result.getString("Auteur"));
t3.add(result.getString("Editeur"));
t4.add(result.getString("EAN"));
t5.add(result.getString("Etat"));
t6.add(result.getString("Stock"));
t7.add(result.getString("Prix"));
t8.add(result.getString("Etagere"));
}
//resultat.getconn.close();
}catch(SQLException f) {
f.printStackTrace();
}
model=new DefaultTableModel(){
public boolean isCellEditable(int row, int col){
if (col==0) {return false;}
else {return true; }
}
};
model.addColumn(" titre ",t1.toArray());
model.addColumn(" auteur ",t2.toArray());
model.addColumn(" editeur ",t3.toArray());
model.addColumn(" EAN ",t4.toArray());
model.addColumn(" Etat ",t5.toArray());
model.addColumn(" Stock ",t6.toArray());
model.addColumn(" Prix ",t7.toArray());
model.addColumn(" Etagere ",t8.toArray());
tableau = new JTable(model);
scroll.setBounds(20,20,700,400);
scroll.setViewportView(tableau);
add(tableau);
validate();
}
});
}
} |
Partager