《JavaWeb编程技术》课后习题答案(12)

时间:2025-07-11

String sql="SELECT * FROM public.books";

Statement stmt = dbconn.createStatement();

ResultSet rst = stmt.executeQuery(sql);

ResultSetMetaData rstmd = rst.getMetaData();

out.println("结果集列数:"+rstmd.getColumnCount()+"</br>");

out.println("第3列标题:"+rstmd.getColumnLabel(3)+"</br>");

out.println("第3列名:"+rstmd.getColumnName(3)+"</br>");

out.println("第3列类型:"+rstmd.getColumnType(3)+"</br>");

out.println("第3列类型名:"+rstmd.getColumnTypeName(3)+"</br>"); }catch(ClassNotFoundException e1){

out.println(e1);

}catch(SQLException e2){

out.println(e2);

}

%>

</body></html>

9. 按教材7.7.2节建立局部或全局数据源sampleDS。创建程序7.9的CustomerBean.java程序和程序7.10的SampleDAO.java程序。

SelectCustomerServlet.java代码如下:

package com.control;

import java.io.*;

import java.sql.*;

import java.util.*;

import javax.servlet.*;

import javax.servlet.http.*;

import com.model.CustomerBean;

import com.model.SampleDAO;

public class SelectCustomerServlet extends HttpServlet{

public void doGet(HttpServletRequest request,

HttpServletResponse response)

throws ServletException,IOException{

SampleDAO dao = new SampleDAO();

ArrayList<CustomerBean> custs = dao.selectCustomer();

request.setAttribute("custs", custs);

RequestDispatcher view = getServletContext().

getRequestDispatcher("/displayCustomer.jsp");

view.forward (request,response);

}

}

displayCustomer.jsp页面代码如下:

<%@ page contentType="text/html; charset=gb2312" %>

<%@ page import="com.model.CustomerBean,java.util.*" %>

<html><head> <title>Display Customer</title></head>

<body>

<%

ArrayList<CustomerBean> custs =

《JavaWeb编程技术》课后习题答案(12).doc 将本文的Word文档下载到电脑

精彩图片

热门精选

大家正在看

× 游客快捷下载通道(下载后可以自由复制和排版)

限时特价:7 元/份 原价:20元

支付方式:

开通VIP包月会员 特价:29元/月

注:下载文档有可能“只有目录或者内容不全”等情况,请下载之前注意辨别,如果您已付费且无法下载或内容有问题,请联系我们协助你处理。
微信:fanwen365 QQ:370150219