《JavaWeb编程技术》课后习题答案(11)
时间：2025-07-10
public void destroy(){
try {
dbconn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
7. JSP页面如下：
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,java.io.*"%>
<html><body>
<%
String driver = "org.postgresql.Driver";
String dburl = "jdbc:postgresql://127.0.0.1:5432/bookstore";
String username = "bookstore";
String password = "bookstore";
try{
Class.forName(driver);
Connection dbconn = DriverManager.getConnection(
dburl,username,password);
DatabaseMetaData dbmd = dbconn.getMetaData();
out.println("数据库名："+dbmd.getDatabaseProductName()+"</br>");
out.println("数据库版本："+dbmd.getDatabaseProductVersion()+"</br>"); out.println("连接的用户："+dbmd.getUserName()+"</br>");
out.println("数据库URL："+dbmd.getURL()+"</br>");
out.println("驱动程序名："+dbmd.getDriverName()+"</br>");
out.println("驱动程序版本："+dbmd.getDriverVersion()+"</br>");
}catch(ClassNotFoundException e1){
out.println(e1);
}catch(SQLException e2){
out.println(e2);
}
%>
</body></html>
8. JSP页面如下：
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,java.io.*"%>
<html><body>
<%
String driver = "org.postgresql.Driver";
String dburl = "jdbc:postgresql://127.0.0.1:5432/bookstore";
String username = "bookstore";
String password = "bookstore";
try{
Class.forName(driver);
Connection dbconn = DriverManager.getConnection(
dburl,username,password);
《JavaWeb编程技术》课后习题答案(11).doc
将本文的Word文档下载到电脑
