！servlet调用数据库的内容在jsp页面显示
日期：2014-05-19 浏览次数：20643 次
十万火急 ！！！servlet调用数据库的内容在jsp页面显示
我用servlet，用jdbc调用数据库的内容在jsp页面上显示，可是最后jsp页面没用将数据显示出来，下面是我的部分有关代码，急用，希望高手帮下忙！！！
我用servlet，用jdbc调用数据库的内容在jsp页面上显示，可是最后jsp页面没用将数据显示出来，下面是我的部分有关代码，急用，希望高手帮下忙！！！
package com.org.vo;
public class AirLine {
private String airID;
private String startCity;
private String endCity;
private String startTime;
private String endTime;
private String price;
private String airType;
public String getAirID() {
return airID;
}
public void setAirID(String airID) {
this.airID = airID;
}
public String getStartCity() {
return startCity;
}
public void setStartCity(String startCity) {
this.startCity = startCity;
}
public String getEndCity() {
return endCity;
}
public void setEndCity(String endCity) {
this.endCity = endCity;
}
public String getStartTime() {
return startTime;
}
public void setStartTime(String startTime) {
this.startTime = startTime;
}
public String getEndTime() {
return endTime;
}
public void setEndTime(String endTime) {
this.endTime = endTime;
}
public String getPrice() {
return price;
}
public void setPrice(String price) {
this.price = price;
}
public String getAirType() {
return airType;
}
public void setAirType(String airType) {
this.airType = airType;
}
}
package com.org.dao;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import com.org.dbc.DatabaseConnection;
import com.org.vo.AirLine;
public class ShowLineDao {
private PreparedStatement pstmt = null;
private ResultSet rs = null;
public void airDelete(String sql) {
try {
new DatabaseConnection().getConnection();
} catch (Exception e) {
e.printStackTrace();
}
try {
int rows = pstmt.executeUpdate(sql);
if (rows >= 1) {
System.out.println("--成功删除--");
} else {
System.out.println("--删除失败--");
}
} catch (Exception e) {
e.printStackTrace();
}
}
public ArrayList<AirLine> getAirLineList(String sql) {
ArrayList<AirLine> list = new ArrayList<AirLine>();
try {
new DatabaseConnection().getConnection();
} catch (Exception e) {
e.printStackTrace();
}
try {
rs = pstmt.executeQuery(sql);
while (rs.next()) {
String airID = rs.getString(1);
String startCity = rs.getString(2);
String endCity = rs.getString(3);
String startTime = rs.getString(4);
String endTime = rs.getString(5);
String price = rs.getString(6);
String airType = rs.getString(7);
AirLine airLine = new AirLi
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
