package?com.mes.dao;

import?java.sql.*;

public?class?ConnectionManager?{
	private?static?final?String?DRIVER_CLASS?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?static?final?String?DATAbase_URL?=?“jdbc:sqlserver://localhost:1433;DatabaseName=company“;
	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;
	}

	/**
	?*?關閉全部對象
	?*/
	public?static?void?closeAll（ResultSet?rs?PreparedStatement?pstmt
			Connection?conn）?{
		if?（rs?!=?null）?{
			try?{
				rs.close（）;
				rs?=?null;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if?（pstmt?!=?null）?{
			try?{
				pstmt.close（）;
				pstmt?=?null;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if?（conn?!=?null）?{
			try?{
				conn.close（）;
				conn?=?null;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}

	public?static?void?closeAll1（ResultSet?rs?Statement?stmt?Connection?conn）?{
		if?（rs?!=?null）?{
			try?{
				rs.close（）;
				rs?=?null;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if?（stmt?!=?null）?{
			try?{
				stmt.close（）;
				stmt?=?null;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if?（conn?!=?null）?{
			try?{
				conn.close（）;
				conn?=?null;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}

	/**
	?*?關閉連接
	?*?
	?*?@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（）;
		}
	}

}

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

?????文件????????410??2018-01-08?08:12??留言板\message\.classpath

?????文件????????294??2018-01-08?08:09??留言板\message\.mymetadata

?????文件???????1225??2017-09-27?11:21??留言板\message\.project

?????文件???????2591??2017-09-30?09:32??留言板\message\src\com\mes\dao\ConnectionManager.java

?????文件???????4348??2017-10-23?09:28??留言板\message\src\com\mes\dao\MessageDao.java

?????文件???????3548??2017-10-30?09:42??留言板\message\src\com\mes\dao\RevertDao.java

?????文件???????3669??2017-11-03?20:28??留言板\message\src\com\mes\dao\UserDao.java

?????文件???????1134??2017-09-27?11:09??留言板\message\src\com\mes\entity\Message.java

?????文件????????903??2017-09-25?08:46??留言板\message\src\com\mes\entity\Revert.java

?????文件????????634??2017-09-25?08:48??留言板\message\src\com\mes\entity\Users.java

?????文件???????1474??2017-11-03?20:52??留言板\message\WebRoot\admin\addManager.jsp

?????文件???????1315??2017-10-18?18:45??留言板\message\WebRoot\admin\addMessage.jsp

?????文件????????180??2017-11-03?20:38??留言板\message\WebRoot\admin\checkLogin.jsp

?????文件????????659??2017-10-17?19:38??留言板\message\WebRoot\admin\deleteUser.jsp

?????文件????????822??2017-11-03?20:54??留言板\message\WebRoot\admin\doAddManager.jsp

?????文件????????979??2017-10-18?18:33??留言板\message\WebRoot\admin\doAddMessage.jsp

?????文件????????800??2017-11-03?21:30??留言板\message\WebRoot\admin\doDelete.jsp

?????文件???????1235??2017-11-03?20:50??留言板\message\WebRoot\admin\index.htm

?????文件???????3684??2017-10-18?16:34??留言板\message\WebRoot\admin\left.htm

?????文件???????2275??2017-10-09?08:53??留言板\message\WebRoot\admin\login.jsp

?????文件????????802??2017-11-03?20:32??留言板\message\WebRoot\admin\login_conf.jsp

?????文件???????1984??2017-11-03?20:35??留言板\message\WebRoot\admin\manageMessage.jsp

?????文件????????216??2017-09-25?08:16??留言板\message\WebRoot\admin\right.htm

?????文件???????1538??2017-11-03?20:38??留言板\message\WebRoot\admin\showUserList.jsp

?????文件???????2128??2017-10-15?20:37??留言板\message\WebRoot\admin\updateMessage.jsp

?????文件????????148??2017-10-18?11:16??留言板\message\WebRoot\checkLogin.jsp

?????文件???????1183??2017-10-15?20:38??留言板\message\WebRoot\deleteRevert.jsp

?????文件????????745??2018-01-08?08:35??留言板\message\WebRoot\doDelete.jsp

?????文件????????554??2017-09-25?08:16??留言板\message\WebRoot\img\a.gif

?????文件????????146??2017-09-25?08:16??留言板\message\WebRoot\img\about.gif

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