Connection conn = getConn("mysql");
PreparedStatement prest = conn.prepareStatement(sql);
prest.setString(1, textField.getText().toString());
prest.setString(2, textField.getText().toString());
ResultSet rs = prest.executeQuery();
Vector row = new Vector();
Vector data = new Vector();
Vector names = new Vector();
for(int i = 0;i < 7;i++){
names.add(columnNames[i]);
}
while(rs.next()&&rs!=null){
rowData[count][0] = rs.getString("姓名");
row.add(rowData[count][0]);
rowData[count][1] = rs.getString("id");
row.add(rowData[count][1]);
rowData[count][2] = rs.getString("mid");
row.add(rowData[count][2]);
rowData[count][3] = rs.getString("内容");
row.add(rowData[count][3]);
rowData[count][4] = rs.getString("地点");
row.add(rowData[count][4]);
rowData[count][5] = rs.getString("时间");
row.add(rowData[count][5]);
rowData[count][6] = rs.getString("性别");
row.add(rowData[count][6]);
data.add(row);
count++;
}
model.setDataVector(data,names);