package?dao;

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

public?class?DatabaseDAO?{
	public?Connection?openConnection（）{
		Connection?conn=null;
		try?{
			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
			conn?=?DriverManager.getConnection（“jdbc:sqlserver://localhost:1433;databaseName=Power?Note“?“sa“?“sa“）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?conn;
	}
	
	public?void?closeAll（ResultSet?rsPreparedStatement?psstConnection?conn）{
		if（rs!=null）{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		if（psst!=null）{
			try?{
				psst.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		if（conn!=null）{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-09-11?18:26??Power?Note\
?????文件?????????401??2017-09-11?18:40??Power?Note\.classpath
?????文件?????????386??2017-09-10?13:31??Power?Note\.project
?????目錄???????????0??2017-09-11?18:26??Power?Note\.settings\
?????文件?????????598??2017-09-10?13:31??Power?Note\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2017-09-13?07:25??Power?Note\bin\
?????目錄???????????0??2017-09-13?07:25??Power?Note\bin\dao\
?????文件????????1583??2017-09-13?07:25??Power?Note\bin\dao\DatabaseDAO.class
?????文件????????7216??2017-09-13?08:07??Power?Note\bin\dao\NoteDAO.class
?????文件????????4097??2017-09-13?07:25??Power?Note\bin\dao\UsersDAO.class
?????目錄???????????0??2017-09-13?07:25??Power?Note\bin\entity\
?????文件????????3219??2017-09-13?07:25??Power?Note\bin\entity\Note.class
?????文件????????1522??2017-09-13?07:25??Power?Note\bin\entity\User.class
?????目錄???????????0??2017-09-13?07:25??Power?Note\bin\ui\
?????文件?????????712??2017-09-13?07:25??Power?Note\bin\ui\AddPop$1.class
?????文件????????2382??2017-09-13?07:25??Power?Note\bin\ui\AddPop$MouseClick.class
?????文件????????1117??2017-09-13?07:25??Power?Note\bin\ui\AddPop$MouseMove.class
?????文件????????3690??2017-09-13?07:25??Power?Note\bin\ui\AddPop.class
?????文件?????????749??2017-09-13?07:30??Power?Note\bin\ui\BackgroundPanel.class
?????文件?????????796??2017-09-13?07:25??Power?Note\bin\ui\ChangePop$1.class
?????文件????????2298??2017-09-13?07:25??Power?Note\bin\ui\ChangePop$MouseClick.class
?????文件????????1173??2017-09-13?07:25??Power?Note\bin\ui\ChangePop$MouseMove.class
?????文件????????4571??2017-09-13?07:25??Power?Note\bin\ui\ChangePop.class
?????文件?????????742??2017-09-13?07:25??Power?Note\bin\ui\FindPassword$1.class
?????文件????????2050??2017-09-13?07:25??Power?Note\bin\ui\FindPassword$MouseClick.class
?????文件????????1212??2017-09-13?07:25??Power?Note\bin\ui\FindPassword$MouseMove.class
?????文件????????3349??2017-09-13?07:25??Power?Note\bin\ui\FindPassword.class
?????文件?????????727??2017-09-13?07:25??Power?Note\bin\ui\LoginForm$1.class
?????文件????????2970??2017-09-13?07:25??Power?Note\bin\ui\LoginForm$MouseClick.class
?????文件????????1307??2017-09-13?07:25??Power?Note\bin\ui\LoginForm$MouseMove.class
?????文件????????3200??2017-09-13?07:25??Power?Note\bin\ui\LoginForm.class
............此處省略34個文件信息