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;
	}

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

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

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

	//?重載執(zhí)行查詢SQL語句----------------------------
	public?ResultSet?executeQuery（String?sql?object[]?obj）?throws?SQLException?{
		if?（getConn（）?==?null）?{
			System.out.println（“與數(shù)據(jù)庫連接失敗!“）;
			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;
	}

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

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

	//?關(guān)閉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（）;
			}
		}
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????509??2013-02-26?16:35??ch08\08?MySQL\JavaPrj_8\.classpath

?????文件????????300??2013-02-26?16:29??ch08\08?MySQL\JavaPrj_8\.mymetadata

?????文件???????1227??2009-11-29?14:37??ch08\08?MySQL\JavaPrj_8\.project

?????文件????????330??2009-11-29?14:33??ch08\08?MySQL\JavaPrj_8\.settings\org.eclipse.jdt.core.prefs

?????文件???????3012??2010-02-02?15:16??ch08\08?MySQL\JavaPrj_8\src\com\dao\baseDAO.java

?????文件???????1806??2009-11-29?14:56??ch08\08?MySQL\JavaPrj_8\src\com\dao\CommonDAO.java

?????文件??????19177??2009-11-30?15:28??ch08\08?MySQL\JavaPrj_8\src\com\dao\ManagerDAO.java

?????文件???????7924??2009-11-29?14:57??ch08\08?MySQL\JavaPrj_8\src\com\dao\ReplyInfoDAO.java

?????文件???????3892??2009-11-30?11:50??ch08\08?MySQL\JavaPrj_8\src\com\dao\SectionInfoDAO.java

?????文件???????8729??2009-11-29?14:57??ch08\08?MySQL\JavaPrj_8\src\com\dao\TopicInfoDAO.java

?????文件???????3752??2009-11-30?14:28??ch08\08?MySQL\JavaPrj_8\src\com\dao\UserInfoDAO.java

?????文件???????1422??2009-11-29?17:09??ch08\08?MySQL\JavaPrj_8\src\com\entity\ReplyInfo.java

?????文件????????930??2009-11-29?16:55??ch08\08?MySQL\JavaPrj_8\src\com\entity\SectionInfo.java

?????文件???????1688??2009-11-29?17:04??ch08\08?MySQL\JavaPrj_8\src\com\entity\TopicInfo.java

?????文件???????1187??2009-11-29?17:13??ch08\08?MySQL\JavaPrj_8\src\com\entity\UserInfo.java

?????文件???????1907??2009-11-30?10:08??ch08\08?MySQL\JavaPrj_8\src\com\match\CheckDAO.java

?????文件???????1789??2009-11-29?14:57??ch08\08?MySQL\JavaPrj_8\src\com\page\DetailPage.java

?????文件????????674??2009-11-29?14:57??ch08\08?MySQL\JavaPrj_8\src\com\page\IndexPage.java

?????文件????????652??2009-11-29?14:57??ch08\08?MySQL\JavaPrj_8\src\com\page\ListPage.java

?????文件????????500??2009-11-29?14:58??ch08\08?MySQL\JavaPrj_8\src\com\page\NavigationPage.java

?????文件??????10042??2009-12-01?10:45??ch08\08?MySQL\JavaPrj_8\src\com\servlet\servletDetailPage.java

?????文件???????1614??2009-11-30?17:12??ch08\08?MySQL\JavaPrj_8\src\com\servlet\servletListPage.java

?????文件???????1719??2009-11-29?14:58??ch08\08?MySQL\JavaPrj_8\src\com\servlet\ServletLogin.java

?????文件???????6266??2009-11-30?15:34??ch08\08?MySQL\JavaPrj_8\src\com\servlet\ServletManager.java

?????文件???????2739??2009-11-29?14:58??ch08\08?MySQL\JavaPrj_8\src\com\servlet\ServletReg.java

?????文件????????265??2009-11-30?16:48??ch08\08?MySQL\JavaPrj_8\WebRoot\checkLogin.jsp

?????文件??????11475??2009-12-01?09:56??ch08\08?MySQL\JavaPrj_8\WebRoot\detail.jsp

?????文件????????712??2009-11-29?14:33??ch08\08?MySQL\JavaPrj_8\WebRoot\image\board.gif

?????文件???????3728??2009-11-29?14:33??ch08\08?MySQL\JavaPrj_8\WebRoot\image\head\1.gif

?????文件???????3491??2009-11-29?14:33??ch08\08?MySQL\JavaPrj_8\WebRoot\image\head\10.gif

............此處省略419個(gè)文件信息