سلام.
این کد button سرچ :
public static String query = null;
if (ch_forosh.isSelected()) {
query = "select * from foroshe_melk where lastname_malek like '%s' or tarikh_sabt like '%s' or address like '%s' or ghimat like '%s' or type like '%s' ";
query = String.format(query, txtlastname.getText(), txtdate1.getText(), txtaddress.getText(), txtprise.getText(), type);
frm_result fr_result = new frm_result();
fr_result.setVisible(rootPaneCheckingEnabled);
}
وقتی از frm_result نمونه سازی میشه :
public frm_result() {
try {
ResultSet Rs=DB_Model.Exequte_Query(frm_serach.query);
Rs.last();
int row = Rs.getRow();
if (row > 0) {
String[][] data = new String[row][9];
data[0][0] = Rs.getString("name_malek");
data[0][1] = Rs.getString("lastname_malek");
data[0][2] = Rs.getString("tarikh_forosh");
data[0][3] = Rs.getString("ghimat");
data[0][4] = Rs.getString("address");
data[0][5] = Rs.getString("type");
data[0][6] = Rs.getString("moshakhasat");
data[0][7] = Rs.getString("kharidar");
data[0][8] = Rs.getString("tozihat");
String[] columns = {"توضیحات", "خریدار", "مشخصات", "نوع ملک", "آدرس", "قیمت", "تاریخ فروش", "نام خانوادگی", "نام"};
JTable tbl_data = new JTable(data, columns);
jScrollPane1.setViewportView(tbl_data);
}
} catch (SQLException ex) {
Logger.getLogger(frm_result.class.getName()).log(L evel.SEVERE, null, ex);
}
initComponents();
}
اینم کلاس DB_Model البته این کلاس دو تا متد داره که من فقط یکیش رو اینجا میزارم :
public static ResultSet Exequte_Query(String query) {
try {
ResultSet Rs = null;
Connection cnn = null;
cnn = DriverManager.getConnection(url, "root", "root");
Statement St = cnn.createStatement();
Rs = St.executeQuery(query);
return Rs;
} catch (SQLException ex) {
Logger.getLogger(DB_Model.class.getName()).log(Lev el.SEVERE, null, ex);
return null;
}
}}