import?java.sql.*;


public?class?DbConnect?{
	static?Connection?con?=?null;
	static?Statement?stmt?=null;
	static?ResultSet?rs?=?null;
	
	public?static?void?connect（String?dbPath）{
		try?{
			Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
			con?=?DriverManager.getConnection（“jdbc:odbc:driver={Microsoft?Access?}“）;
			stmt?=?con.createStatement（）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
	}
	
	public?static?void?query（String?sql）{
		try?{
			rs=stmt.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			System.out.println（sql）;
		}
		
	}
	
	public?static?boolean?update（String?sql）{
		try?{
			stmt.executeUpdate（sql）;
			return?true;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			return?false;
		}
		
	}
	
	public?static?void?showResult（）{
		out?:?try?{
			while（rs.next（））{
				for（int?i=1;;i++）{
					try?{
						System.out.println（rs.getString（i）+“\t“）;
					}?catch?（SQLException?e）?{
						//?TODO?Auto-generated?catch?block
						e.printStackTrace（）;
					}
				}
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	
	public?static?void?close（）{
		
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????301??2018-01-20?16:24??addressBook_1010\.classpath

?????文件????????392??2018-01-20?16:24??addressBook_1010\.project

?????文件????????629??2018-01-20?16:25??addressBook_1010\.settings\org.eclipse.jdt.core.prefs

?????文件????????510??2018-01-20?16:24??addressBook_1010\addressList.dtd

?????文件???????4374??2018-01-20?16:24??addressBook_1010\addressList.xml

?????文件???????2408??2018-01-20?16:25??addressBook_1010\bin\DbConnect.class

?????文件????????714??2018-01-20?16:25??addressBook_1010\bin\EditDialog$1.class

?????文件????????718??2018-01-20?16:25??addressBook_1010\bin\EditDialog$2.class

?????文件???????8188??2018-01-20?16:25??addressBook_1010\bin\EditDialog.class

?????文件????????709??2018-01-20?16:25??addressBook_1010\bin\Mainframe$1.class

?????文件????????685??2018-01-20?16:25??addressBook_1010\bin\Mainframe$10.class

?????文件????????685??2018-01-20?16:25??addressBook_1010\bin\Mainframe$11.class

?????文件????????686??2018-01-20?16:25??addressBook_1010\bin\Mainframe$12.class

?????文件????????686??2018-01-20?16:25??addressBook_1010\bin\Mainframe$13.class

?????文件????????686??2018-01-20?16:25??addressBook_1010\bin\Mainframe$14.class

?????文件????????933??2018-01-20?16:24??addressBook_1010\bin\Mainframe$15.class

?????文件????????720??2018-01-20?16:24??addressBook_1010\bin\Mainframe$2.class

?????文件????????683??2018-01-20?16:24??addressBook_1010\bin\Mainframe$3.class

?????文件????????683??2018-01-20?16:24??addressBook_1010\bin\Mainframe$4.class

?????文件????????683??2018-01-20?16:24??addressBook_1010\bin\Mainframe$5.class

?????文件????????683??2018-01-20?16:24??addressBook_1010\bin\Mainframe$6.class

?????文件????????683??2018-01-20?16:24??addressBook_1010\bin\Mainframe$7.class

?????文件????????683??2018-01-20?16:24??addressBook_1010\bin\Mainframe$8.class

?????文件????????683??2018-01-20?16:24??addressBook_1010\bin\Mainframe$9.class

?????文件??????15489??2018-01-20?16:24??addressBook_1010\bin\Mainframe.class

?????文件???????1452??2018-01-20?16:24??addressBook_1010\src\DbConnect.java

?????文件??????10048??2018-01-20?16:24??addressBook_1010\src\EditDialog.java

?????文件??????17038??2018-01-20?16:24??addressBook_1010\src\Mainframe.java

?????目錄??????????0??2018-01-20?16:25??addressBook_1010\.settings

?????目錄??????????0??2018-01-20?16:25??addressBook_1010\bin

............此處省略5個文件信息