package?com.lovo.cq.shopping10_1.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/shoppingbook?user=root&password=123456&characterEncoding=GB2312“）;;
		}?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（）;
			}
		}
	}

public?static?void?main（String[]?args）?{
	DbUtil?dbaccess?=?new?DbUtil（）;
	dbaccess.close（）;
}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-05-26?11:34??ShoppingBook\
?????文件?????????646??2011-05-26?11:34??ShoppingBook\.classpath
?????目錄???????????0??2011-05-26?11:34??ShoppingBook\.myeclipse\
?????文件?????????310??2011-05-26?11:34??ShoppingBook\.mymetadata
?????文件????????1230??2011-05-26?11:34??ShoppingBook\.project
?????目錄???????????0??2011-05-26?11:34??ShoppingBook\.settings\
?????文件????????1040??2011-05-26?11:34??ShoppingBook\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????116??2011-05-26?11:34??ShoppingBook\.settings\org.eclipse.core.resources.prefs
?????文件?????????629??2011-05-26?11:34??ShoppingBook\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2011-05-26?11:34??ShoppingBook\src\
?????目錄???????????0??2011-05-26?11:34??ShoppingBook\src\com\
?????目錄???????????0??2011-05-26?11:34??ShoppingBook\src\com\lovo\
?????目錄???????????0??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\
?????目錄???????????0??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\
?????目錄???????????0??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\common\
?????文件?????????931??2011-05-28?17:26??ShoppingBook\src\com\lovo\cq\shopping10_1\common\DbUtil.java
?????目錄???????????0??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\dao\
?????目錄???????????0??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\
?????文件????????8552??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\AdminBookDaoImpl.java
?????文件????????4744??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\AdminInformDaoImpl.java
?????文件????????1926??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\AdminLoginDaoImpl.java
?????文件????????3318??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\AdminNoteDaoImpl.java
?????文件???????12656??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\AdminOrderDaoImpl.java
?????文件????????2505??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\AdminSubTypeDaoImpl.java
?????文件????????2439??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\AdminSuperTypeDaoImpl.java
?????文件????????4647??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\AdminUserDaoImpl.java
?????文件???????21431??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\BookDaoImpl.java
?????文件?????????170??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\ErrPwdException.java
?????文件????????1220??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\InformDaoImpl.java
?????文件?????????181??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\NameNotFoundException.java
?????文件?????????175??2011-05-26?11:34??ShoppingBook\src\com\lovo\cq\shopping10_1\daoimpl\NoMessageException.java
............此處省略652個(gè)文件信息