import?java.sql.*;

public?class?SearchDemo{
	private?String?dbURL=“jdbc:microsoft:sqlserver://202.115.26.181:1433“;	//?數據庫標識名
	private?String?user=“devon“;	//?數據庫用戶
	private?String?password=“book“;	//?數據庫用戶密碼
	
	public?SearchDemo（）{
		try	{
			Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;??//加載驅動器
			Connection?con=DriverManager.getConnection（dbURLuserpassword）;?//獲取連接
			String?sqlStr=“select?*?from?users?where?age>20“;?//SQL查詢語句
			Statement?st=con.createStatement（）;?//獲取Statement對象
			ResultSet?rs=st.executeQuery（sqlStr）;?//執行查詢
			String?namesexemail;?//查詢結果
			int?age;
			while?（rs.next（））{?//遍歷ResultSet
				name=rs.getString（“name“）;?//獲取數據
				age=rs.getInt（“age“）;
				sex=rs.getString（“sex“）;
				email=rs.getString（“email“）;
				System.out.println（“Name:?“+name+“\tAge:“+age+“\tSex:“+sex+“\tEmail:“+email）;?//在控制臺輸出數據
			}			

			con.close（）;?//關閉連接
		}
		catch（Exception?ex）{
			ex.printStackTrace（）;?//輸出出錯信息
		}
	}
	
	public?s

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????1823??2004-07-21?17:57??SearchDemo.class
?????文件????????1126??2004-06-14?19:01??SearchDemo.java