public List search(PetDiary item) {
Connection connection = super.dbHelp.getCon();
List list = new ArrayList();
String sql = "select * from PetDiary d where 1=1 ";
if (item != null) {
if (item.getDiaryId() != null && item.getDiaryId() > 0) {
sql += "and d.diary_id = " + item.getDiaryId() + " ";
}
if (item.getPetId() != null && item.getPetId() > 0) {
sql += "and d.diary_pet_id = " + item.getPetId() + " ";
}
}
sql += "order by d.diary_date asc";
System.out.println( sql);
super.sqlDAO.setConnection(connection);
super.sqlDAO.setSqlValue(sql);
super.sqlDAO.setValues(null);
try {
Result rs = super.sqlDAO.executeQuery();
for (int i = 0; i < rs.getRowCount(); i++) {
Map row = rs.getRows()[i];
PetDiary conDiary = new PetDiary();
conDiary.setDiaryId((Integer) row.get("diary_id"));
conDiary.setPetId((Integer) row.get("diary_pet_id"));
conDiary.setDiaryDate((Date) row.get("diary_date"));
conDiary.setDiaryTitle((String) row.get("diary_title"));
conDiary.setDiaryContext((String) row.get("diary_context"));
conDiary.setDiaryWeather((String) row.get("diary_weather"));
conDiary.setDiaryIsPublic((String) row.get("diary_is_public"));
conDiary.setDiaryAuthor((String) row.get("diary_author"));
conDiary.setDiaryAuthorEmail((String) row
.get("diary_author_email"));
list.add(item);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
super.dbHelp.closeCon(connection);
}
return list; } public static void main(String[] args) {
PetDiary item = new PetDiary();
item.setPetId(2);
List list = new PetDiaryDao().search(item);
for (int i = 0; i < list.size(); i++) {
System.out.println(item.getDiaryTitle());//怎么获取不出来 这个内容
//System.out.println(list.size()); //能获取3条 数据 sql 语句能查出来
}
}
Connection connection = super.dbHelp.getCon();
List list = new ArrayList();
String sql = "select * from PetDiary d where 1=1 ";
if (item != null) {
if (item.getDiaryId() != null && item.getDiaryId() > 0) {
sql += "and d.diary_id = " + item.getDiaryId() + " ";
}
if (item.getPetId() != null && item.getPetId() > 0) {
sql += "and d.diary_pet_id = " + item.getPetId() + " ";
}
}
sql += "order by d.diary_date asc";
System.out.println( sql);
super.sqlDAO.setConnection(connection);
super.sqlDAO.setSqlValue(sql);
super.sqlDAO.setValues(null);
try {
Result rs = super.sqlDAO.executeQuery();
for (int i = 0; i < rs.getRowCount(); i++) {
Map row = rs.getRows()[i];
PetDiary conDiary = new PetDiary();
conDiary.setDiaryId((Integer) row.get("diary_id"));
conDiary.setPetId((Integer) row.get("diary_pet_id"));
conDiary.setDiaryDate((Date) row.get("diary_date"));
conDiary.setDiaryTitle((String) row.get("diary_title"));
conDiary.setDiaryContext((String) row.get("diary_context"));
conDiary.setDiaryWeather((String) row.get("diary_weather"));
conDiary.setDiaryIsPublic((String) row.get("diary_is_public"));
conDiary.setDiaryAuthor((String) row.get("diary_author"));
conDiary.setDiaryAuthorEmail((String) row
.get("diary_author_email"));
list.add(item);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
super.dbHelp.closeCon(connection);
}
return list; } public static void main(String[] args) {
PetDiary item = new PetDiary();
item.setPetId(2);
List list = new PetDiaryDao().search(item);
for (int i = 0; i < list.size(); i++) {
System.out.println(item.getDiaryTitle());//怎么获取不出来 这个内容
//System.out.println(list.size()); //能获取3条 数据 sql 语句能查出来
}
}
System.out.println(item.getDiaryDate()); 这个能获取出来吗?
public static void main(String[] args) {
PetDiary item = new PetDiary();
item.setPetId(2);
List list = new PetDiaryDao().search(item);
for (int i = 0; i < list.size(); i++) {
item = (PetDiary)list.get(i);//增加这一句
System.out.println(item.getDiaryTitle());//怎么获取不出来 这个内容
//System.out.println(list.size()); //能获取3条 数据 sql 语句能查出来
}
}
是不是参数的问题 读取的时候 new 了对象
你这么做什么意思,你这么写。遍历list有什么意义?
list.add(conDiary);