package?com.bookshop.dbconn;

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

public?class?DBConn?{
	String?DriverName=“com.mysql.jdbc.Driver“;
	String?URL=“jdbc:mysql://localhost:3306/bookshop?characterEncoding=UTF-8“;
	String?user=“root“;
	String?Password=“sa“;
	Connection?conn=null;
	Statement?stmt=null;
	public?DBConn（）
	{
		try?{
			Class.forName（DriverName）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		try?{
			conn=DriverManager.getConnection（URL?user?Password）;
			stmt=conn.createStatement（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	public?ResultSet?query（String?sql）
	{
		ResultSet?rst=null;
		try?{
			rst=stmt.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?rst;
	}
	public?void?update（String?sql）
	{
		try?{
			stmt.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	public?void?closeDB（）
	{
		try?{
			if（stmt!=null&&!stmt.isClosed（））
			{
				stmt.close（）;
			}
			if（conn!=null&&!conn.isClosed（））
			{
				conn.close（）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
}

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

?????文件????????510??2011-07-02?10:22??bookshop\.classpath

?????文件????????297??2011-07-02?10:22??bookshop\.mymetadata

?????文件???????1281??2011-06-28?23:02??bookshop\.project

?????文件????????500??2011-06-29?22:34??bookshop\.settings\.jsdtscope

?????文件????????629??2011-07-02?10:22??bookshop\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2011-07-02?10:22??bookshop\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-07-02?10:22??bookshop\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1475??2011-07-02?11:29??bookshop\src\com\bookshop\dbconn\DBConn.java

?????文件???????6730??2011-07-05?15:14??bookshop\src\com\bookshop\domain\BookDomain.java

?????文件???????1275??2011-06-28?23:02??bookshop\src\com\bookshop\domain\UserDomain.java

?????文件????????651??2011-07-06?14:34??bookshop\src\com\bookshop\entity\Admin.java

?????文件???????1812??2011-07-02?11:13??bookshop\src\com\bookshop\entity\Book.java

?????文件????????440??2011-06-29?12:49??bookshop\src\com\bookshop\entity\Car.java

?????文件??????11078??2011-07-06?09:39??bookshop\src\com\bookshop\entity\keyBean.java

?????文件???????2075??2011-06-28?23:02??bookshop\src\com\bookshop\entity\User.java

?????文件????????694??2011-07-06?09:56??bookshop\src\com\bookshop\managerBean\CheckManagerInDB.java

?????文件???????1143??2011-07-06?14:59??bookshop\src\com\bookshop\managerBean\ManagerAdmin.java

?????文件???????1524??2011-07-06?14:23??bookshop\src\com\bookshop\managerBean\ManagerUser.java

?????文件???????3488??2011-07-06?15:02??bookshop\src\com\bookshop\managerServlet\GuanLiServlet.java

?????文件???????2817??2011-07-06?09:52??bookshop\src\com\bookshop\managerServlet\ManagerControlServlet.java

?????文件???????6379??2011-07-05?22:49??bookshop\src\com\bookshop\servlet\BookServlet.java

?????文件???????2946??2011-06-29?15:15??bookshop\src\com\bookshop\servlet\CarServlet.java

?????文件???????9624??2011-07-05?14:31??bookshop\src\com\bookshop\servlet\ChaxunServlet.java

?????文件???????3438??2011-07-03?11:28??bookshop\src\com\bookshop\servlet\UserManager.java

?????文件???????3622??2011-07-06?09:31??bookshop\WebRoot\admin\index.jsp

?????文件???????2869??2011-07-06?09:36??bookshop\WebRoot\admin\managerLogin.jsp

?????文件???????3044??2011-07-06?15:05??bookshop\WebRoot\admin\managerMain.jsp

?????文件???????2052??2011-07-06?09:36??bookshop\WebRoot\admin\managerMain2.jsp

?????文件???????3360??2011-07-06?09:36??bookshop\WebRoot\admin\managertop.jsp

?????文件???????2322??2011-07-06?15:00??bookshop\WebRoot\admin\showadmin.jsp

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