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

import?javax.servlet.ServletContext;

import?org.slf4j.Logger;
import?org.slf4j.LoggerFactory;

/**
?*?數據庫管理對象
?*?
?*?@author?Administrator
?*
?*/
public?class?DBManager?{

	private?static?String?url?=?““;

	private?static?String?deUrl?=?“jdbc:sqlite:/“;

	private?static?Logger?logger?=?LoggerFactory.getLogger（DBManager.class）;

	/**
	?*?獲取數據庫連接對象
	?*?
	?*?@return
	?*/
	public?static?synchronized?Connection?getConnection（）?{
		Connection?connection?=?null;
		try?{
			connection?=?DriverManager.getConnection（url）;
		}?catch?（SQLException?e）?{
			logger.error（e.getMessage（）?e）;
		}
		return?connection;
	}

	/**
	?*?初始化數據庫連接
	?*?
	?*?@param?servletContext
	?*/
	public?static?void?init（ServletContext?servletContext）?{
		try?{

			Class.forName（“org.sqlite.JDBC“）;

			url?=?deUrl?+?servletContext.getRealPath（““）.replace（“\\“?“/“）?+?“/dt.sqlite3“;

		}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-10-25?13:59??dt\
?????文件????????1306??2017-10-23?14:14??dt\.classpath
?????文件????????1078??2017-10-23?14:14??dt\.project
?????目錄???????????0??2017-10-25?13:59??dt\.settings\
?????文件?????????639??2017-10-23?14:14??dt\.settings\.jsdtscope
?????文件??????????57??2017-10-23?15:21??dt\.settings\org.eclipse.core.resources.prefs
?????文件?????????430??2017-10-23?14:14??dt\.settings\org.eclipse.jdt.core.prefs
?????文件??????????90??2017-10-23?14:14??dt\.settings\org.eclipse.m2e.core.prefs
?????文件?????????647??2017-10-23?14:14??dt\.settings\org.eclipse.wst.common.component
?????文件?????????252??2017-10-23?14:14??dt\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-10-23?14:14??dt\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-10-23?14:14??dt\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????????50??2017-10-23?14:14??dt\.settings\org.eclipse.wst.validation.prefs
?????文件????????2067??2017-10-24?13:25??dt\pom.xml
?????目錄???????????0??2017-10-25?13:59??dt\src\
?????目錄???????????0??2017-10-25?13:59??dt\src\main\
?????目錄???????????0??2017-10-25?13:59??dt\src\main\java\
?????文件????????1136??2017-10-25?13:48??dt\src\main\java\DBManager.java
?????文件????????1495??2017-10-24?13:25??dt\src\main\java\JacksonobjectMapper.java
?????文件?????????602??2017-10-25?13:47??dt\src\main\java\StartInit.java
?????文件?????????989??2017-10-24?13:56??dt\src\main\java\User.java
?????文件????????1899??2017-10-25?13:49??dt\src\main\java\UserAddServlet.java
?????文件????????1411??2017-10-25?13:49??dt\src\main\java\UserDelServlet.java
?????文件????????1987??2017-10-25?13:49??dt\src\main\java\UserEditServlet.java
?????文件????????4615??2017-10-25?13:50??dt\src\main\java\UserListServlet.java
?????目錄???????????0??2017-10-25?13:59??dt\src\main\resources\
?????文件?????????584??2017-10-23?16:40??dt\src\main\resources\log4j.properties
?????目錄???????????0??2017-10-25?13:59??dt\src\main\webapp\
?????文件???????19456??2017-10-24?14:24??dt\src\main\webapp\dt.sqlite3
?????文件???????11443??2017-10-25?11:27??dt\src\main\webapp\index.html
?????文件???????13741??2017-10-23?15:21??dt\src\main\webapp\objects.txt
............此處省略77個文件信息