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

public?class?ServletDemo?extends?HttpServlet{	

	private?String?dbURL=“jdbc:odbc:example“;	//?數據庫標識名
	private?String?user=“devon“;	//?數據庫用戶
	private?String?password=“book“;	//?數據庫用戶密碼
	private?Connection?con;
	
	public?void?init（）?{
		try{
			Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;??//裝載數據庫驅動
	????????con=DriverManager.getConnection（dbURLuserpassword）;?//獲取連接
		}
		catch?（Exception?ex）{
			ex.printStackTrace（）;
		}
	}

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

	????????String?sqlStr=“select?*?from?users“;?//SQL查詢語句
			Statement?st=con.createStatement（）;?//獲取PreparedStatement對象
			ResultSet?rs=st.executeQuery（sqlStr）;?//執行查詢
			
			//在網頁中輸出查詢結果		
			PrintWriter?out?=?new?PrintWriter（res.getOutputStream（））;?//獲取輸出流
	????	out.println（“

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????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