迭代显示查询结果集
对于查询结果集合,在JSP页面上用迭代输出标签进行显示,语句是:
名
当元素是由多字段组成时,语句是:
【例struts-iterator】
项目的程序结构:
一、数据库结构定义:
二、student表中的数据:
三、web.xml(主要部分):
四、struts.xml(主要部分):
value="false"/> 五、index.jsp(首页): <%@page language="java"contentType="text/html;charset=UTF-8"%> <%@taglib prefix="s"uri="/struts-tags"%>
学生信息查询
六、Action代码:
package com.action;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.business.*;
import com.opensymphony.xwork2.ActionSupport;
public class QueryAction extends ActionSupport
{
private String classes;
private DbQuery dbquery;
private List
public List
return studentList;
}
public void setStudentList(List
this.studentList = studentList;
}
public String getClasses() {
return classes;
}
public void setClasses(String classes) {
this.classes = classes;
}
public String execute() throws Exception
{
studentList = new ArrayList
try
{
dbquery =new DbQuery();
studentList = dbquery.queryStudent(getClasses());
return"success";
}catch(SQLException e)
{
return"input";
}
}
}
七、值JavaBean代码(对应数据库中的字段):
package com.business;
public class Student
{
private String number;
private String classes;
private String name;
private String sex;
private String telephone;
private String resume;
public String getNumber() {
return number;
}
public void setNumber(String number) {
this.number = number;
}
public String getClasses() {
return classes;
}
public void setClasses(String classes) { this.classes = classes;
}
public String getName() {
return name;
}
public void setName(String name) {
https://www.doczj.com/doc/e64262152.html, = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getTelephone() {
return telephone;
}
public void setTelephone(String telephone) { this.telephone = telephone;
}
public String getResume() {
return resume;
}
public void setResume(String resume) {
this.resume = resume;
}
}
八、查询业务代码:
package com.business;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import com.dbconn.DbConn2005;
public class DbQuery
{
private DbConn2005 dbconn;
private Connection conn;
private PreparedStatement prestmt;
private ResultSet result;
private Student stu;
private String pareStatement;
private List
public List
return queryList;
}
public void setQueryList(List
this.queryList = queryList;
}
public DbQuery() throws ClassNotFoundException, SQLException
{
if(conn==null)
{
try
{
dbconn = new DbConn2005();
conn = dbconn.dbconn("db_database08");
}catch(SQLException se)
{
se.printStackTrace();
}
}
}
@SuppressWarnings("unchecked")
public List
List
stu = new Student();
try
{
pareStatement= new String("select * from student where classes=?");
prestmt = conn.prepareStatement(pareStatement);
prestmt.setString(1,classname.trim());
result = prestmt.executeQuery();
while(result.next())
{
stu.setNumber(result.getString(1));
stu.setClasses(result.getString(2));
stu.setName(result.getString(3));
stu.setSex(result.getString(4));
stu.setTelephone(result.getString(5));
stu.setResume(result.getString(6));
queryList.add(stu);
}
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
result.close();
prestmt.close();
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
return queryList;
}
}
九、连接数据库代码:
package com.dbconn;
import java.sql.*;
public class DbConn2005
{
private String driverClass;
private String urlPath;
private String myUrl;
private String username;
private String password;
public String getDriverClass() {
return driverClass;
}
public void setDriverClass(String driverClass) {
this.driverClass = driverClass;
}
public String getUrlPath() {
return urlPath;
}
public void setUrlPath(String urlPath) {
this.urlPath = urlPath;
}
public String getMyUrl() {
return myUrl;
}
public void setMyUrl(String myUrl) {
this.myUrl = myUrl;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
https://www.doczj.com/doc/e64262152.html,ername = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public DbConn2005()
{
try{
setDriverClass("com.microsoft.sqlserver.jdbc.SQLServerDriver");
setUrlPath("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=");
setUsername("sa");
setPassword("sa");
}catch(Exception e)
{
System.out.print("加载数据库驱动程序时出现异常:");
e.printStackTrace();
}
}
public Connection dbconn(String dbname) throws ClassNotFoundException, SQLException
{
Connection conn = null;
setMyUrl(urlPath+dbname);
Class.forName(driverClass);
conn=DriverManager.getConnection(myUrl, username, password);
return conn;
}
}
十、QuerySuccess.jsp(查询成功结果页面):
<%@page language="java"contentType="text/html;charset=UTF-8"%>
<%@taglib prefix="s"uri="/struts-tags"%>
学号 | 班级 | 姓名 | 性别 | 电话号码 | 简介 |
十一、QueryError.jsp(查询不成功页面)
<%@page contentType="text/html;charset=UTF-8"language="java"%> <%@taglib prefix="s"uri="/struts-tags"%>