package?dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

public?class?RootDao?{
	private??static?String?strurl;
	static{
		?strurl=“jdbc:odbc:driver={Microsoft?Access?Driver?（*.mdb）};DBQ=books.mdb“;
		try?{
			Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	public?List?select?（String?sql）{
		List?result=new?ArrayList（）;
		StringBuffer?str=new?StringBuffer（）;
		try?{
			Connection?conn=DriverManager.getConnection（strurl）?;
			Statement?stmt=conn.createStatement（）;
			ResultSet?rs=stmt.executeQuery（sql）;
			ResultSetmetaData?rsmd?=?rs.getmetaData（）;
			while（rs.next（））{
				for（int?i=1;i<=rsmd.getColumnCount（）;++i）
					str.append（rs.getobject（i）+“#“）;
				result.add（str.toString（））;
				str.delete（0?str.length（））;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?result.size（）==0?null:result;
	}
	public?String?execute（String?sql）{
		int?result=0;
		Connection?conn;
		try?{
			conn?=?DriverManager.getConnection（strurl）;
			Statement?stmt=conn.createStatement（）;
			result=stmt.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?result==0?“false“:“true“;
	}
}

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

?????文件????????340??2010-03-20?17:29??chart\.classpath

?????文件??????????0??2010-03-20?17:30??chart\.myeclipse\.svn\empty-file

?????文件????????294??2010-03-20?22:14??chart\.myeclipse\.svn\entries

?????文件??????????2??2010-03-20?17:30??chart\.myeclipse\.svn\format

?????文件????????120??2010-03-20?17:30??chart\.myeclipse\.svn\README.txt

?????文件????????288??2010-03-20?17:29??chart\.mymetadata

?????文件???????1223??2010-03-20?17:42??chart\.project

?????文件??????????0??2010-03-20?17:30??chart\.svn\empty-file

?????文件???????1147??2010-03-25?10:24??chart\.svn\entries

?????文件??????????2??2010-03-20?17:30??chart\.svn\format

?????文件????????120??2010-03-20?17:30??chart\.svn\README.txt

?????文件??????????0??2010-03-20?17:30??chart\src\.svn\empty-file

?????文件????????451??2010-03-25?10:23??chart\src\.svn\entries

?????文件??????????2??2010-03-20?17:30??chart\src\.svn\format

?????文件????????120??2010-03-20?17:30??chart\src\.svn\README.txt

?????文件??????????0??2010-03-20?22:14??chart\src\dao\.svn\empty-file

?????文件????????606??2010-03-25?10:23??chart\src\dao\.svn\entries

?????文件??????????2??2010-03-20?22:14??chart\src\dao\.svn\format

?????文件????????120??2010-03-20?22:14??chart\src\dao\.svn\README.txt

?????文件???????1579??2010-03-20?22:14??chart\src\dao\RootDao.java

?????文件??????????0??2010-03-20?22:14??chart\src\meta\.svn\empty-file

?????文件???????1185??2010-03-30?12:02??chart\src\meta\.svn\entries

?????文件??????????2??2010-03-20?22:14??chart\src\meta\.svn\format

?????文件????????120??2010-03-20?22:14??chart\src\meta\.svn\README.txt

?????文件????????335??2010-03-20?22:14??chart\src\meta\Context.java

?????文件????????237??2010-03-20?22:14??chart\src\meta\Person.java

?????文件????????319??2010-03-20?22:14??chart\src\meta\Role.java

?????文件??????????0??2010-03-20?22:14??chart\src\servlets\.svn\empty-file

?????文件????????692??2010-03-25?10:24??chart\src\servlets\.svn\entries

?????文件??????????2??2010-03-20?22:14??chart\src\servlets\.svn\format

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