package?db;



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

public?class?DBUtil?{
	public?Connection?conn;
	public?DBUtil（）{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
			String?url=“jdbc:mysql://127.0.0.1:3306/bookstore“;
			String?user=“root“;
			String?password=“111“;
			conn?=?DriverManager.getConnection（url?user?password）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
	}
	
	//增刪改
	public?int?execute（String?sql）{
		int?n=0;
		try?{
			Statement?stmt?=?conn.createStatement（）;
			n?=?stmt.executeU

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

?????文件????????593??2010-09-27?08:21??Test\.classpath

?????文件????????285??2010-10-11?08:18??Test\.mymetadata

?????文件???????1410??2010-09-26?15:31??Test\.project

?????文件????????500??2010-09-26?15:05??Test\.settings\.jsdtscope

?????文件?????????49??2010-09-26?15:05??Test\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2010-09-26?15:05??Test\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1092??2010-10-08?08:27??Test\src\db\bookstore.sql

?????文件???????1414??2010-10-11?08:33??Test\src\db\DBUtil.java

?????文件????????836??2010-09-27?09:18??Test\src\db\GuestBook.java

?????文件???????1681??2010-10-08?08:26??Test\src\servlet\ListServlet.java

?????文件???????1632??2010-09-27?09:24??Test\src\servlet\LoginServlet.java

?????文件???????1168??2010-09-26?22:42??Test\src\servlet\RegisterServlet.java

?????文件???????1501??2010-09-27?08:26??Test\src\servlet\TestServlet.java

?????文件???????3219??2010-10-11?08:39??Test\WebRoot\list.jsp

?????文件????????720??2010-09-27?09:20??Test\WebRoot\login.jsp

?????文件?????????36??2010-09-26?15:05??Test\WebRoot\meta-INF\MANIFEST.MF

?????文件????????187??2010-09-28?22:54??Test\WebRoot\registDo.jsp

?????文件????????720??2010-09-26?22:39??Test\WebRoot\register.jsp

?????文件????????794??2010-09-26?15:26??Test\WebRoot\say.jsp

?????文件???????1115??2010-10-08?08:26??Test\WebRoot\show.jsp

?????文件???????1092??2010-10-08?08:27??Test\WebRoot\WEB-INF\classes\db\bookstore.sql

?????文件???????1906??2010-10-11?08:33??Test\WebRoot\WEB-INF\classes\db\DBUtil.class

?????文件???????1435??2010-10-11?08:18??Test\WebRoot\WEB-INF\classes\db\GuestBook.class

?????文件???????2807??2010-10-11?08:18??Test\WebRoot\WEB-INF\classes\servlet\ListServlet.class

?????文件???????2609??2010-10-11?08:18??Test\WebRoot\WEB-INF\classes\servlet\LoginServlet.class

?????文件???????2057??2010-10-11?08:18??Test\WebRoot\WEB-INF\classes\servlet\RegisterServlet.class

?????文件???????2344??2010-10-11?08:18??Test\WebRoot\WEB-INF\classes\servlet\TestServlet.class

?????文件??????20682??2010-09-27?08:21??Test\WebRoot\WEB-INF\lib\jstl.jar

?????文件?????709922??2010-09-26?15:39??Test\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.7-bin.jar

?????文件?????393259??2010-09-27?08:21??Test\WebRoot\WEB-INF\lib\standard.jar

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