package?com.softi.dao;

import?java.io.IOException;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.Properties;

public?class?baseDao?{
	private?static?String?driver;
	private?static?String?url;
	private?static?String?username;
	private?static?String?password;
	
	static?{
		load（）;
	}
	
	public?static?void?load（）?{
		Properties?p?=?new?Properties（）;
		try?{			
			p.load（baseDao.class.getClassLoader（）.getResourceAsStream（“db.properties“））;
			driver?=?p.getProperty（“driver“）;
			url?=?p.getProperty（“url“）;
			username?=?p.getProperty（“username“）;
			password?=?p.getProperty（“password“）;
		}?catch?（IOException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	
	public?Connection?conn=null;
	
	private?Connection?getConnection（）?{
		try?{
			Class.forName（driver）;
			if（conn==null||conn.isClosed（））?{
				conn?=?DriverManager.getConnection（url?username?password）;
			}
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?conn;
	}
	
	public?int?executeUpdate（String?sqlobject[]?param）?{
		this.conn?=?this.getConnection（）;
		PreparedStatement?pst=null;
		try?{
			pst?=?this.conn.prepareStatement（sql）;
			if（param!=null）?{
				for?（int?i?=?0;?i?					pst.setobject（i+1?param[i]）;
				}
			}
			return?pst.executeUpdate（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			closeAll（nullpstthis.conn）;
		}
		return?-1;
	}
	
	public?ResultSet?executeQuery（String?sqlobject[]?param）?{
		this.conn?=?this.getConnection（）;
		PreparedStatement?pst;
		try?{
			pst?=?this.conn.prepareStatement（sql）;
			if（param!=null）?{
				for?（int?i?=?0;?i?					pst.setobject（i+1?param[i]）;
				}
			}
			return?pst.executeQuery（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?
		return?null;
	}
	
	public?void?closeAll（ResultSet?rsPreparedStatement?pstConnection?conn）?{
		if（rs!=null）?{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		if（pst!=null）?{
			try?{
				pst.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（）;
			}
		}
	}
}

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

?????文件????????840??2019-10-19?08:55??demo11\.classpath

?????文件????????906??2019-10-19?08:55??demo11\.project

?????文件????????567??2019-10-19?08:55??demo11\.settings\.jsdtscope

?????文件?????????91??2019-10-19?16:49??demo11\.settings\org.eclipse.core.resources.prefs

?????文件????????408??2019-10-19?08:55??demo11\.settings\org.eclipse.jdt.core.prefs

?????文件????????470??2019-10-19?08:55??demo11\.settings\org.eclipse.wst.common.component

?????文件????????344??2019-10-19?08:55??demo11\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2019-10-19?08:55??demo11\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2019-10-19?08:55??demo11\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3350??2019-10-19?10:39??demo11\build\classes\com\softi\dao\baseDao.class

?????文件????????529??2019-10-19?16:43??demo11\build\classes\com\softi\dao\UserDao.class

?????文件???????4155??2019-10-21?08:17??demo11\build\classes\com\softi\dao\UserDaoImpl.class

?????文件???????1492??2019-10-19?10:39??demo11\build\classes\com\softi\pojo\User.class

?????文件????????467??2019-10-19?16:56??demo11\build\classes\com\softi\service\UserService.class

?????文件???????1798??2019-10-19?16:56??demo11\build\classes\com\softi\service\UserServiceImpl.class

?????文件????????138??2019-10-17?13:52??demo11\build\classes\db.properties

?????文件???????2254??2019-10-19?10:38??demo11\build\classes\servlet\CookieServlet.class

?????文件???????2585??2019-10-19?16:04??demo11\build\classes\servlet\LoginServlet.class

?????文件???????2093??2019-10-19?10:38??demo11\build\classes\servlet\SessionServlet.class

?????文件???????3214??2019-10-19?17:41??demo11\build\classes\servlet\UserServlet.class

?????文件???????2781??2019-10-17?14:04??demo11\src\com\softi\dao\baseDao.java

?????文件????????358??2019-10-19?16:43??demo11\src\com\softi\dao\UserDao.java

?????文件???????3469??2019-10-21?08:17??demo11\src\com\softi\dao\UserDaoImpl.java

?????文件????????846??2019-10-18?14:42??demo11\src\com\softi\pojo\User.java

?????文件????????320??2019-10-19?16:56??demo11\src\com\softi\service\UserService.java

?????文件???????1394??2019-10-19?16:56??demo11\src\com\softi\service\UserServiceImpl.java

?????文件????????138??2019-10-17?13:52??demo11\src\db.properties

?????文件???????1871??2019-10-19?09:13??demo11\src\servlet\CookieServlet.java

?????文件???????2168??2019-10-19?16:04??demo11\src\servlet\LoginServlet.java

?????文件???????1762??2019-10-19?09:59??demo11\src\servlet\SessionServlet.java

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