《JavaWeb编程技术》课后习题答案(11)
时间:2025-07-10
时间: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);