阅读背景:

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

来源:互联网 
					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);					Connection conn = getConn("mysql");
					P



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: