public List<Project> findAllProject() {
// TODO Auto-generated method stub
Connection conn = DBConnection.getConnection();
String findAllProject = "select * from project"; //SQL语句
PreparedStatement pstmt = null; //声明预处理对象
ResultSet rs = null;
Project project = null;
List<Project> Projects = new ArrayList<Project>();
try {
if(conn==null){
System.out.println("conn is null");
}else{
pstmt = conn.prepareStatement(findAllProject);
rs = pstmt.executeQuery(); //执行查询
while(rs.next()) {
project = new Project();
project.setProjectID(rs.getString(1));
project.setProjectName(rs.getString(2));
project.setApplyDate(rs.getString(3));
project.setClientDepart(rs.getString(4));
project.setClient(rs.getString(5));
project.setProjectDes(rs.getString(6));
project.setStartDate(rs.getString(7));
project.setEndDate(rs.getString(8));
project.setScheme(rs.getString(9));
project.setProjectState(rs.getString(10));
project.setApplicant(rs.getString(11));
project.setTestDepart(rs.getString(12));
Projects.add(project);
}
...
return Projects;
}
JSP
<a:forEach items="${requestScope.proAllList}" var="project" >
<tr>
<td>${project.projectID}</td>
<td>${project.clientDepart}</td>
<td>${project.projectDes}</td>
<td>${project.testDepart}</td>
<td>${project.startDate}</td>
<td>${project.endDate}</td>
<td>${project.projectState}</td>
<td><a href="#" class="btn btn-default">查看详情</a></td>
</tr>
</a:forEach>
list有数据 size>1
心有法竹
白板的微信
随时随地看视频慕课网APP
相关分类