code 17.3-2.txt

来自「开发web_xml」· 文本 代码 · 共 55 行

TXT
55
字号
<html> 
<head> package test; 
import java.sql.*; 
public class faq { 
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
String sConnStr = "jdbc:odbc:faq"; 
Connection conn = null; 
ResultSet rs = null; 

public faq() { 
try { 
Class.forName(sDBDriver); 
} 
catch(java.lang.ClassNotFoundException e) { 
System.err.println("faq(): " + e.getMessage()); 
} 

} 

public ResultSet executeQuery(String sql) { 
rs = null; 
try { 
conn = DriverManager.getConnection(sConnStr); 
Statement stmt = conn.createStatement(); 
rs = stmt.executeQuery(sql); 
} 

catch(SQLException ex) { 
System.err.println("aq.executeQuery: " + ex.getMessage()); 
} 

return rs; 
} 


<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
<title>MY FAQ !</title> 
</head> 

<body> 
<p><b>MY FAQ!</b></p> 
<%@ page language="java" import="java.sql.*" %> 
<jsp:useBean id="workM" scope="page" class="test.faq" /> 
<% 
ResultSet RS = workM.executeQuery("SELECT * FROM faqs"); 
String tt; 
while (RS.next()) { 
tt = RS.getString("Answer"); 
out.print("<LI>" + RS.getString("Subject") + "</LI>"); 
out.print("<pre>" + tt + "</pre>"); 
} 

RS.close(); 
%> 

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?