java数据库查询显示结果显示在JTable

来源：互联网发布：淘宝9888 编辑：程序博客网时间：2024/06/05 10:50

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);

0 0