import?javax.servlet.*;
import?javax.servlet.http.*;
import?java.sql.*;
import?java.io.*;

public?class?ServletDemo?extends?HttpServlet{	

	private?String?dbURL=“jdbc:odbc:example“;	//?數(shù)據(jù)庫(kù)標(biāo)識(shí)名
	private?String?user=“devon“;	//?數(shù)據(jù)庫(kù)用戶
	private?String?password=“book“;	//?數(shù)據(jù)庫(kù)用戶密碼
	private?Connection?con;
	
	public?void?init（）?{
		try{
			Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;??//裝載數(shù)據(jù)庫(kù)驅(qū)動(dòng)
	????????con=DriverManager.getConnection（dbURLuserpassword）;?//獲取連接
		}
		catch?（Exception?ex）{
			ex.printStackTrace（）;
		}
	}

	public?void?doGet（HttpServletRequest?reqHttpServletResponse?res）??{
		try{
	????	res.setContentType（“text/html“）;?//設(shè)置類型??????
	????????
	????????//連接并查詢數(shù)據(jù)庫(kù)

	????????String?sqlStr=“select?*?from?users“;?//SQL查詢語(yǔ)句
			Statement?st=con.createStatement（）;?//獲取PreparedStatement對(duì)象
			ResultSet?rs=st.executeQuery（sqlStr）;?//執(zhí)行查詢
			
			//在網(wǎng)頁(yè)中輸出查詢結(jié)果		
			PrintWriter?out?=?new?PrintWriter（res.getOutputStream（））;?//獲取輸出流
	????	out.println（“

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件??????378838??2004-06-11?01:01??86-1.bmp
?????文件???????80054??2004-07-21?18:16??servlet.jar
?????文件????????2589??2004-07-21?18:17??ServletDemo.class
?????文件????????2191??2004-06-11?23:13??ServletDemo.java