package?s2jsp.sg.ch03;

import?java.sql.*;

public?class?ConnectionManager?{

	private?static?final?String?DRIVER_CLASS?=?“com.microsoft.jdbc.sqlserver.SQLServerDriver“;
	private?static?final?String?DATAbase_URL?=?“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=news“;
	private?static?final?String?DATAbase_USRE?=?“sa“;
	private?static?final?String?DATAbase_PASSWORD?=?“sa“;

	/**
	?*?返回連接
	?*?
	?*?@return?Connection
	?*/
	public?static?Connection?getConnection（）?{
		Connection?dbConnection?=?null;
		try?{
			Class.forName（DRIVER_CLASS）;
			dbConnection?=?DriverManager.getConnection（DATAbase_URL
					DATAbase_USRE?DATAbase_PASSWORD）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}

		return?dbConnection;
	}

	/**
	?*?關閉連接
	?*?
	?*?@param?dbConnection
	?*????????????Connection
	?*/
	public?static?void?closeConnection（Connection?dbConnection）?{
		try?{
			if?（dbConnection?!=?null?&&?（!dbConnection.isClosed（）））?{
				dbConnection.close（）;
			}
		}?catch?（SQLException?sqlEx）?{
			sqlEx.printStackTrace（）;
		}

	}

	/**
	?*?關閉結果集
	?*/
	public?static?void?closeResultSet（ResultSet?res）?{
		try?{
			if?（res?!=?null）?{
				res.close（）;
				res?=?null;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}

	/**
	?*?關閉語句
	?*/

	public?static?void?closeStatement（PreparedStatement?pStatement）?{
		try?{
			if?（pStatement?!=?null）?{
				pStatement.close（）;
				pStatement?=?null;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	
}

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

?????文件????3239424??2008-01-04?17:29??Chapter7\上機部分\教學幻燈片\LG7V1.0.ppt

?????文件???????2939??2007-09-30?10:58??Chapter7\上機部分\教學幻燈片\上機課答案\階段1\index.jsp

?????文件???????3618??2007-09-27?14:40??Chapter7\上機部分\教學幻燈片\上機課答案\階段1\list.jsp

?????文件???????4936??2007-12-04?13:38??Chapter7\上機部分\教學幻燈片\上機課答案\階段2\detail.jsp

?????文件???????2997??2007-09-30?10:59??Chapter7\上機部分\教學幻燈片\上機課答案\階段2\index.jsp

?????文件???????3680??2007-09-27?14:49??Chapter7\上機部分\教學幻燈片\上機課答案\階段2\list.jsp

?????文件????????838??2007-08-06?10:57??Chapter7\上機部分\教學幻燈片\上機課答案\階段3\doLogin.jsp

?????文件????????177??2007-07-27?17:34??Chapter7\上機部分\教學幻燈片\上機課答案\階段3\doLogout.jsp

?????文件???????3256??2007-09-30?10:59??Chapter7\上機部分\教學幻燈片\上機課答案\階段3\index.jsp

?????文件???????1987??2007-09-27?15:34??Chapter7\上機部分\教學幻燈片\上機課答案\階段3\login.jsp

?????文件???????5002??2007-12-04?13:40??Chapter7\上機部分\教學幻燈片\上機課答案\階段4\detail.jsp

?????文件???????1148??2007-08-06?11:06??Chapter7\上機部分\教學幻燈片\上機課答案\階段4\doPost.jsp

?????文件???????1241??2007-12-07?10:13??Chapter7\上機部分\教學幻燈片\上機課答案\階段4\doReply.jsp

?????文件???????3702??2007-09-27?14:56??Chapter7\上機部分\教學幻燈片\上機課答案\階段4\list.jsp

?????文件???????3348??2007-09-27?16:11??Chapter7\上機部分\教學幻燈片\上機課答案\階段4\post.jsp

?????文件???????3509??2007-09-27?16:24??Chapter7\上機部分\教學幻燈片\上機課答案\階段4\reply.jsp

?????文件???????5405??2007-12-07?13:45??Chapter7\教學指導\上機課作業(yè)答案\作業(yè)1\detail.jsp

?????文件????????972??2007-07-27?18:03??Chapter7\教學指導\上機課作業(yè)答案\作業(yè)1\doDeleteReply.jsp

?????文件???????5482??2007-12-07?13:45??Chapter7\教學指導\上機課作業(yè)答案\作業(yè)2\detail.jsp

?????文件???????1310??2007-07-27?18:04??Chapter7\教學指導\上機課作業(yè)答案\作業(yè)2\doUpdateReply.jsp

?????文件???????3794??2007-08-02?10:58??Chapter7\教學指導\上機課作業(yè)答案\作業(yè)2\update.jsp

?????文件????????696??2007-08-08?17:25??Chapter7\教學指導\上機課作業(yè)答案\作業(yè)3\index.jsp

?????文件????????689??2007-08-08?17:26??Chapter7\教學指導\上機課作業(yè)答案\作業(yè)3\welcome.jsp

?????文件???????2274??2007-09-19?13:35??Chapter7\教學指導\理論課作業(yè)答案\answer.txt

?????文件???????1086??2007-09-26?13:58??Chapter7\教學指導\補充案例\案例1\count.jsp

?????文件????????689??2007-08-08?15:36??Chapter7\教學指導\附加題答案\附加題1\stat.jsp

?????文件????????428??2007-08-08?15:30??Chapter7\教學指導\附加題答案\附加題1\vote.html

?????文件???????1141??2007-09-21?15:48??Chapter7\教學指導\附加題答案\附加題2\bag.jsp

?????文件????????876??2007-09-21?15:49??Chapter7\教學指導\附加題答案\附加題2\buy.jsp

?????文件???????1024??2007-09-21?13:27??Chapter7\教學指導\附加題答案\附加題2\listCD.html

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