package?com.nba.common;

import?java.sql.*;

public?class?DbUtil?{

	private?PreparedStatement?pstmt?=?null;

	private?Connection?con?=?null;

	public?DbUtil（）?{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
			con?=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/ShoppingBook10_1“
					“root“?“5346158“）;;
		}?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（）;
			}
		}
	}
}

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

?????文件????????646??2010-06-14?22:19??es_bookshop\.classpath

?????文件????????322??2010-06-14?22:19??es_bookshop\.mymetadata

?????文件???????1234??2010-06-14?22:19??es_bookshop\.project

?????文件???????1040??2010-06-14?22:19??es_bookshop\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件????????793??2010-06-18?19:00??es_bookshop\src\com\nba\common\DbUtil.java

?????文件????????496??2010-06-18?19:02??es_bookshop\src\com\nba\dao\AdminBookDao.java

?????文件????????365??2010-06-18?19:02??es_bookshop\src\com\nba\dao\AdminInformDao.java

?????文件????????174??2010-06-18?19:02??es_bookshop\src\com\nba\dao\AdminLoginDao.java

?????文件????????245??2010-06-18?19:02??es_bookshop\src\com\nba\dao\AdminNoteDao.java

?????文件????????804??2010-06-18?19:02??es_bookshop\src\com\nba\dao\AdminOrderDao.java

?????文件?????????64??2010-06-18?19:00??es_bookshop\src\com\nba\dao\AdminOrderItem.java

?????文件?????????67??2010-06-18?19:00??es_bookshop\src\com\nba\dao\AdminOrderItemDao.java

?????文件?????????62??2010-06-18?19:00??es_bookshop\src\com\nba\dao\AdminSubType.java

?????文件????????278??2010-06-18?19:02??es_bookshop\src\com\nba\dao\AdminSubTypeDao.java

?????文件?????????64??2010-06-18?19:00??es_bookshop\src\com\nba\dao\AdminSuperType.java

?????文件????????264??2010-06-18?19:02??es_bookshop\src\com\nba\dao\AdminSuperTypeDao.java

?????文件????????337??2010-06-18?19:02??es_bookshop\src\com\nba\dao\AdminUserDao.java

?????文件???????1781??2010-06-18?19:02??es_bookshop\src\com\nba\dao\BookDao.java

?????文件????????253??2010-06-18?19:02??es_bookshop\src\com\nba\dao\InformDao.java

?????文件????????339??2010-06-18?19:02??es_bookshop\src\com\nba\dao\OrderDao.java

?????文件????????165??2010-06-18?19:00??es_bookshop\src\com\nba\dao\SubTypeDao.java

?????文件????????137??2010-06-18?19:00??es_bookshop\src\com\nba\dao\SuperTypeDao.java

?????文件???????1249??2010-06-18?19:02??es_bookshop\src\com\nba\dao\UserDao.java

?????文件???????8433??2010-06-18?19:02??es_bookshop\src\com\nba\daoimpl\AdminBookDaoImpl.java

?????文件???????4625??2010-06-18?19:02??es_bookshop\src\com\nba\daoimpl\AdminInformDaoImpl.java

?????文件???????1824??2010-06-18?19:05??es_bookshop\src\com\nba\daoimpl\AdminLoginDaoImpl.java

?????文件???????3199??2010-06-18?19:02??es_bookshop\src\com\nba\daoimpl\AdminNoteDaoImpl.java

?????文件??????12109??2010-06-18?19:02??es_bookshop\src\com\nba\daoimpl\AdminOrderDaoImpl.java

?????文件???????2437??2010-06-18?19:02??es_bookshop\src\com\nba\daoimpl\AdminSubTypeDaoImpl.java

?????文件???????2371??2010-06-18?19:02??es_bookshop\src\com\nba\daoimpl\AdminSuperTypeDaoImpl.java

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