private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) throws SQLException {
createConnection();
System.out.println(conn);
System.out.println("Lol");
jList1.setModel(new DefaultListModel());
String name1 = jTextField1.getText();
String name2 = jTextField2.getText();
String phone = jTextField3.getText();
String brand = jTextField4.getText();
String model = jTextField5.getText();
Statement sta = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
final ResultSet res = sta.executeQuery("SELECT * FROM Orders3");
if (res.getConcurrency() == ResultSet.CONCUR_READ_ONLY) {
System.out.println("ResultSet non-updatable.");
} else {
System.out.println("ResultSet updatable.");
}
while (res.next()) {
String name1_ = res.getString("Name1");
String name2_ = res.getString("Name2");
String phone_ = res.getString("Telephone");
String brand_ = res.getString("Brand");
String model_ = res.getString("Model");
int result = name1.compareTo(name1_);
int result1 = name2.compareTo(name2_);
int result2 = phone.compareTo(phone_);
int result3 = brand.compareTo(brand_);
int result4 = model.compareTo(model_);
if (result == 0 || result1 == 0 || result2 == 0 || result3 == 0 || result4 == 0) {
jList1.setModel(
new javax.swing.AbstractListModel() {
{
String[] s = new String[Orders.length + 1];
for (int i = 0; i < Orders.length; i++) {
s[i] = Orders[i];
}
s[Orders.length] =
(" "
+ res.getInt("ID")
+ ", "
+ res.getString("Name1")
+ ", "
+ res.getString("Name2")
+ ", "
+ res.getString("Telephone")
+ ", "
+ res.getString("Brand")
+ ", "
+ res.getString("Model")
+ ", "
+ res.getString("Problem")
+ ", "
+ res.getString("Time")
+ ", "
+ res.getString("Price")
+ ", "
+ res.getString("Status"));
Orders = s;
}
public int getSize() {
return Orders.length;
}
public Object getElementAt(int i) {
return Orders[i];
}
});
}
}
res.close();
sta.close();
}
