时间: 2021-07-31 作者:daque
底下引见怎样用sql server实行一个动静faq(罕见题目及谜底)网站。开始创造一个数据库faq,个中的表faqs有字段id(int,机动增量,并设为主要害字)、subject(varchar,200)、answers(text)。这个表中不妨寄存少许编制程序常识的罕见题目及谜底。而后,在control panel(遏制面板)的odbc datasource模块中介入system dsn,取名faq,并指向faq数据库。创造一个javabean,名为faq.java,并生存在c:\jbuilder4\tomcat\webapps\test目次下。faq.java 的实质如次: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;}}用上一节引见的本领编写翻译faq.java此后,在jc:\jbuilder4\tomcat\webapps\test目次下创造jsp文献faq.jsp,其实质如次:<html><head><meta http-equiv="content-type" content="text/html; charset=utf8"><title>我的faq !</title></head><body><p><b>这是我的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();%>在欣赏器的地方栏中键入http://localhost:8080/test/faq.jsp,faq.jsp挪用javabean,从数据库中读出实质并输入,获得截止如图5所示.