67,513
社区成员
发帖
与我相关
我的任务
分享
BaseReader br = new BaseReader();
String[][] hotelList = br.getHotelNameList();
for (int i = 0; i < hotelList.length; i++) {
out.print("<option value=\"" + hotelList[i][0] + "\">" + hotelList[i][0] + "</option>");
}
BaseReader br = new BaseReader();
String[][] hotelList = br.getHotelNameList();
for (int i = 0; i < hotelList.length; i++) {
System.out.println(hotelList[i][0]);
}
public String[][] getHotelNameList() {
String[][] hotelList = null;
try {
resultSet = statement.executeQuery("SELECT COUNT(id) FROM ticket_pro.hotel_base");
resultSet.next();
hotelList = new String[resultSet.getInt(1)][3];
resultSet = null;
resultSet = statement.executeQuery("SELECT name,telnumber,price FROM ticket_pro.hotel_base");
int i = 0;
while (resultSet.next()) {
hotelList[i][0] = resultSet.getString(1);
hotelList[i][1] = resultSet.getString(2);
hotelList[i][2] = resultSet.getString(3);
i++;
}
} catch (SQLException e) {
new LogOut().logOut("./log/baseLog.log", e.getMessage() + "\r\n");
} finally {
return hotelList;
}
}
这种情况需要用标签吗?
如果需要的话又该怎么写。
毕竟刚学不太会= =[/quote]
你把index.jsp代码全部贴出来[/quote]
index.jsp大部分都是界面。真正使用<%%>的就只有我之前发的那几行了public String[][] getHotelNameList() {
String[][] hotelList = null;
try {
resultSet = statement.executeQuery("SELECT COUNT(id) FROM ticket_pro.hotel_base");
resultSet.next();
hotelList = new String[resultSet.getInt(1)][3];
resultSet = null;
resultSet = statement.executeQuery("SELECT name,telnumber,price FROM ticket_pro.hotel_base");
int i = 0;
while (resultSet.next()) {
hotelList[i][0] = resultSet.getString(1);
hotelList[i][1] = resultSet.getString(2);
hotelList[i][2] = resultSet.getString(3);
i++;
}
} catch (SQLException e) {
new LogOut().logOut("./log/baseLog.log", e.getMessage() + "\r\n");
} finally {
return hotelList;
}
}
这种情况需要用标签吗?
如果需要的话又该怎么写。
毕竟刚学不太会= =[/quote]
你把index.jsp代码全部贴出来public String[][] getHotelNameList() {
String[][] hotelList = null;
try {
resultSet = statement.executeQuery("SELECT COUNT(id) FROM ticket_pro.hotel_base");
resultSet.next();
hotelList = new String[resultSet.getInt(1)][3];
resultSet = null;
resultSet = statement.executeQuery("SELECT name,telnumber,price FROM ticket_pro.hotel_base");
int i = 0;
while (resultSet.next()) {
hotelList[i][0] = resultSet.getString(1);
hotelList[i][1] = resultSet.getString(2);
hotelList[i][2] = resultSet.getString(3);
i++;
}
} catch (SQLException e) {
new LogOut().logOut("./log/baseLog.log", e.getMessage() + "\r\n");
} finally {
return hotelList;
}
}
这种情况需要用标签吗?
如果需要的话又该怎么写。
毕竟刚学不太会= =