package?com.dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?baseDAO?{
	public?baseDAO（）?{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
	}

	//?屬性?--------------------------
	private?Connection?conn;
	private?Statement?stm;
	private?PreparedStatement?pstm;
	private?ResultSet?rs;

	//?獲得連接--------------------------
	public?Connection?getConn（）?{
		try?{
			if?（conn?==?null?||?conn.isClosed（））?{
				conn?=?DriverManager.getConnection（
						“jdbc:mysql://localhost:3306/bbs“
						“root“?“admin“）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			System.out.println（“getConnection（）錯誤“）;
		}
		return?conn;
	}

	//?執行增、刪、改SQL語句--------------------
	public?int?executeUpdate（String?sql）?throws?SQLException?{
		if?（getConn（）?==?null）?{
			System.out.println（“與數據庫連接失敗!“）;
			return?-1;
		}
		stm?=?conn.createStatement（）;
		return?stm.executeUpdate（sql）;
	}

	//?重載執行增、刪、改SQL語句--------------------
	public?int?executeUpdate（String?sql?object[]?obj）?throws?SQLException?{
		if?（getConn（）?==?null）?{
			System.out.println（“與數據庫連接失敗!“）;
			return?-1;
		}
		pstm?=?conn.prepareStatement（sql）;
		if?（obj?!=?null）?{
			for?（int?i?=?0;?i?				pstm.setobject（i?+?1?obj[i]）;
			}
		}
		return?pstm.executeUpdate（）;
	}

	//?執行查詢SQL語句----------------------------
	public?ResultSet?executeQuery（String?sql）?throws?SQLException?{
		if?（getConn（）?==?null）?{
			System.out.println（“與數據庫連接失敗!“）;
			return?null;
		}
		stm?=?conn.createStatement（）;
		rs?=?stm.executeQuery（sql）;
		return?rs;
	}

	//?重載執行查詢SQL語句----------------------------
	public?ResultSet?executeQuery（String?sql?object[]?obj）?throws?SQLException?{
		if?（getConn（）?==?null）?{
			System.out.println（“與數據庫連接失敗!“）;
			return?null;
		}
		pstm?=?conn.prepareStatement（sql）;
		if?（obj?!=?null）?{
			for?（int?i?=?0;?i?				pstm.setobject（i?+?1?obj[i]）;
			}
		}
		rs?=?pstm.executeQuery（）;
		return?rs;
	}

	//?關閉ResultSet
	public?void?closeResultSet（）?{
		if?（rs?!=?null）?{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
	}

	//?關閉Connection
	public?void?closeConnection（）?{
		if?（conn?!=?null）?{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}

	//?關閉Statement和PreparedStatement
	public?void?closeStatement（）?{
		if?（stm?!=?null）?{
			try?{
				stm.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}

		if?（pstm?!=?null）?{
			try?{
				pstm.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}
}

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

?????文件????????455??2009-12-15?15:16??ch14\14?MySQL\JavaPrj_14\.classpath

?????文件????????303??2010-01-31?10:40??ch14\14?MySQL\JavaPrj_14\.mymetadata

?????文件???????1228??2009-12-15?15:18??ch14\14?MySQL\JavaPrj_14\.project

?????文件????????223??2009-12-15?15:55??ch14\14?MySQL\JavaPrj_14\.settings\org.eclipse.core.resources.prefs

?????文件????????330??2009-12-15?14:54??ch14\14?MySQL\JavaPrj_14\.settings\org.eclipse.jdt.core.prefs

?????文件???????4078??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\abc.java

?????文件???????2211??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\common\CodeFilter.java

?????文件???????4017??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\common\Counter.java

?????文件???????1297??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\common\DateUtil.java

?????文件???????4187??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\common\Debug.java

?????文件???????2212??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\common\EnvironmentConfig.java

?????文件????????432??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\common\ISiteEnvironment.java

?????文件???????9627??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\common\MD5.java

?????文件???????3203??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\common\Pagination.java

?????文件???????5698??2009-12-15?17:16??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\common\SetCharacterEncodingFilter.java

?????文件????????803??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\database\DBOperator.java

?????文件???????4633??2009-12-15?17:26??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\database\SQLDBOperator.java

?????文件??????20580??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\linkNews.java

?????文件??????11359??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\manage\Column.java

?????文件???????6374??2009-12-16?10:05??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\manage\ISLogin.java

?????文件???????6373??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\manage\Kind.java

?????文件??????26103??2009-12-15?17:24??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\manage\News.java

?????文件??????16634??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\manage\Usr.java

?????文件??????22233??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\NewsShow.java

?????文件???????7193??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\note\Guest.java

?????文件???????5621??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\note\Manager.java

?????文件???????8314??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\Personal.java

?????文件???????4831??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\Reply.java

?????文件??????15254??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\SearchNews.java

?????文件???????1521??2009-12-15?15:30??ch14\14?MySQL\JavaPrj_14\src\com\sanqing\news\Test.java

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