package?Eshop.dbconn;

import?java.sql.*;

public?class?DbUtil?{

	private?PreparedStatement?pstmt?=?null;
	private?Connection?con?=?null;
????????private?String?url=“jdbc:mysql://127.0.0.1:3306/pdca?useUnicode=true&characterEncoding=UTF-8“;

	public?DbUtil（）?{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
			con?=?DriverManager.getConnection（url“root““123456“）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}

	public?Connection?getCon（）?{
		return?con;
	}

	public?void?close（）?{
		if?（pstmt?!=?null）?{
			try?{
				pstmt.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if?（con?!=?null）?{
			try?{
				con.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}
}

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

?????文件????????840??2015-08-27?06:43??Demon\Eshop\src\Eshop\dbconn\DbUtil.java

?????文件????????229??2015-08-27?06:43??Demon\Eshop\src\Eshop\exception\ErrLoginException.java

?????文件????????241??2015-08-27?06:43??Demon\Eshop\src\Eshop\exception\ErrNameException.java

?????文件????????224??2015-08-27?06:43??Demon\Eshop\src\Eshop\exception\ErrPwdException.java

?????文件????????245??2015-08-27?06:43??Demon\Eshop\src\Eshop\exception\NoMessageException.java

?????文件????????249??2015-08-27?06:43??Demon\Eshop\src\Eshop\exception\NoRelativeProductsException.java

?????文件????????227??2015-08-27?06:43??Demon\Eshop\src\Eshop\exception\UnLoginException.java

?????文件???????1187??2015-08-27?06:43??Demon\Eshop\src\Eshop\filter\AdminLoginFilter.java

?????文件???????1201??2015-08-27?06:43??Demon\Eshop\src\Eshop\filter\AdminServletFilter.java

?????文件???????4700??2015-08-27?06:43??Demon\Eshop\src\Eshop\implement\AdminInformDaoImpl.java

?????文件???????1862??2015-08-27?06:43??Demon\Eshop\src\Eshop\implement\AdminLoginDaoImpl.java

?????文件???????3151??2015-08-27?06:43??Demon\Eshop\src\Eshop\implement\AdminNoteDaoImpl.java

?????文件??????14068??2015-08-27?06:43??Demon\Eshop\src\Eshop\implement\AdminOrderDaoImpl.java

?????文件??????11536??2015-08-27?06:43??Demon\Eshop\src\Eshop\implement\AdminProductDaoImpl.java

?????文件???????2493??2015-08-27?06:43??Demon\Eshop\src\Eshop\implement\AdminSubTypeDaoImpl.java

?????文件???????2431??2015-08-27?06:43??Demon\Eshop\src\Eshop\implement\AdminSuperTypeDaoImpl.java

?????文件???????4648??2015-08-27?06:43??Demon\Eshop\src\Eshop\implement\AdminUserDaoImpl.java

?????文件???????3128??2015-08-27?06:44??Demon\Eshop\src\Eshop\implement\InformDaoImpl.java

?????文件???????8496??2015-08-27?06:44??Demon\Eshop\src\Eshop\implement\OrderDaoImpl.java

?????文件??????36942??2015-08-27?06:44??Demon\Eshop\src\Eshop\implement\ProductDaoImpl.java

?????文件???????9448??2015-08-27?06:44??Demon\Eshop\src\Eshop\implement\RecommendDaoImpl.java

?????文件???????2103??2015-08-27?06:44??Demon\Eshop\src\Eshop\implement\SubTypeDaoImpl.java

?????文件???????1019??2015-08-27?06:44??Demon\Eshop\src\Eshop\implement\SuperTypeDaoImpl.java

?????文件??????12147??2015-08-27?06:44??Demon\Eshop\src\Eshop\implement\UserDaoImpl.java

?????文件????????339??2015-08-27?06:44??Demon\Eshop\src\Eshop\interfaces\AdminInformDao.java

?????文件????????181??2015-08-27?06:44??Demon\Eshop\src\Eshop\interfaces\AdminLoginDao.java

?????文件????????255??2015-08-27?06:44??Demon\Eshop\src\Eshop\interfaces\AdminNoteDao.java

?????文件????????876??2015-08-27?06:44??Demon\Eshop\src\Eshop\interfaces\AdminOrderDao.java

?????文件?????????72??2015-08-27?06:44??Demon\Eshop\src\Eshop\interfaces\AdminOrderItemDao.java

?????文件????????588??2015-08-27?06:44??Demon\Eshop\src\Eshop\interfaces\AdminProductDao.java

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