String sReturnFormat = req.getParameter("returnFormat");
Connection conn = null;
PreparedStatement stat = null;
ResultSet rs = null;
List<Address> returnList = new ArrayList<Address>();
String sUserID = req.getParameter("User_ID");
try {

conn = dbManager.getConnection(); stat = conn.prepareStatement("SELECT Address_ID ,User_ID ,Province_ID ,City_ID ,Disturct_ID ,Detail_Address ,Alias ,Recevier ,Phone ,Email ,Zip_Code ,Default_Address ,Created_Time ,Updated_Time FROM address  where User_ID=?");
stat.setString(1, sUserID);
rs = stat.executeQuery();
while(rs.next()) {
Address address = new Address();
address.addressID = rs.getInt("Address_ID");
address.userID = rs.getString("User_ID");
address.provinceID = rs.getInt("Province_ID");
address.cityID = rs.getInt("City_ID");
address.disturctID = rs.getInt("Disturct_ID");
address.detailAddress = rs.getString("Detail_Address");
address.alias = rs.getString("Alias");
address.receiver = rs.getString("Recevier");
address.phone = rs.getString("Phone");
address.email = rs.getString("Email");
address.zip = rs.getString("Zip_Code");
address.defaultAddress = rs.getString("Default_Address");
address.createTime = rs.getString("Created_Time");
address.updateTime = rs.getString("Updated_Time");
Result.getReturnFormat(req, resp, 2, "address.id=");
returnList.add(address);
}我把sql语句在数据库查询了 有数据 为什么 我放在list后 list里面的数据为空呢?
对了数据库Address_ID,User_ID,Province_ID,City_ID,Disturct_ID 在MySQL 字段为int类型