package?dvd.db;
	
	import?java.sql.Connection;
	import?java.sql.DriverManager;
	import?java.sql.ResultSet;
	import?java.sql.SQLException;
	import?java.sql.Statement;
	
	public?class?DbUtil?{
		Connection?conn;
		Statement?stmt;
		ResultSet?rs;
		String?url=“jdbc:mysql://localhost:3306/dvd?user=root&password=912286&charactorEncoding=gbk“;
		public?DbUtil（）{
			try?{
				Class.forName（“com.mysql.jdbc.Driver“）;
			}?catch?（ClassNotFoundException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		private?void?getConn（）{
			
			try?{if（this.conn==null）
				this.conn=DriverManager.getConnection（url）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
			//return?this.conn;
			
		}
		
		/*public?Statement?getStmt（Connection?conn）{
			try?{
				this.stmt=conn.createStatement（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
			//return?this.stmt;
			
		}*/
		public?ResultSet?query（String?sql）{
			try?{
				this.getConn（）;
				stmt=conn.createStatement（）;
			????rs=stmt.executeQuery（sql）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
			return?rs;
		}
		
		public?int?update（String?sql）{
			int?flag=?0;
			this.getConn（）;
			//conn.setAutoCommit（false）;
			try?{
				stmt?=?conn.createStatement（）;
				flag?=?stmt.executeUpdate（sql）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
			return?flag;
		}
		
		/*public?void?openTransaction（）?throws?SQLException{
			conn.setAutoCommit（false）;
		}
		
		public?void?commit（）?throws?SQLException{
			conn.commit（）;
		}
		public?void?rollBack（）?throws?SQLException{
			conn.rollback（）;
		}*/
		
		
		public?void?closeAll（）{
			try?{
				if（rs!=null||stmt!=null||conn!=null）{
				rs.close（）;
				stmt.close（）;
			????conn.close（）;
				}
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
			
		}
		
	
	}

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

?????文件????????390??2012-06-01?14:52??dvdproject\dvdproject\.classpath

?????文件????????386??2012-05-31?15:03??dvdproject\dvdproject\.project

?????文件????????598??2012-06-01?09:10??dvdproject\dvdproject\.settings\org.eclipse.jdt.core.prefs

?????文件???????2002??2012-06-15?09:09??dvdproject\dvdproject\bin\dvd\db\DbUtil.class

?????文件??????10445??2012-06-16?18:12??dvdproject\dvdproject\bin\dvd\db\FilmDao.class

?????文件???????3261??2012-06-17?11:33??dvdproject\dvdproject\bin\dvd\db\ManagerDao.class

?????文件???????4897??2012-06-16?16:34??dvdproject\dvdproject\bin\dvd\db\UserDao.class

?????文件???????2134??2012-06-14?17:26??dvdproject\dvdproject\bin\dvd\entity\Film.class

?????文件???????2087??2012-06-16?14:31??dvdproject\dvdproject\bin\dvd\entity\HireRecord.class

?????文件???????1338??2012-06-16?10:09??dvdproject\dvdproject\bin\dvd\entity\Manager.class

?????文件???????1713??2012-06-15?09:03??dvdproject\dvdproject\bin\dvd\entity\User.class

?????文件??????90545??2012-06-18?12:06??dvdproject\dvdproject\bin\dvd\image\%5Bwallcoo_com%5D_LOMO_lomography_Mullaghmore%20Grass.jpg

?????文件??????25238??2012-06-18?11:44??dvdproject\dvdproject\bin\dvd\image\215-121.jpg

?????文件?????260254??2012-06-18?11:58??dvdproject\dvdproject\bin\dvd\image\3488035_104057013097_2_副本.jpg

?????文件???????3263??2012-06-16?18:09??dvdproject\dvdproject\bin\dvd\model\FilmService.class

?????文件???????1119??2012-06-17?11:16??dvdproject\dvdproject\bin\dvd\model\ManagerService.class

?????文件???????1664??2012-06-16?09:48??dvdproject\dvdproject\bin\dvd\model\UserService.class

?????文件????????329??2012-06-17?10:45??dvdproject\dvdproject\bin\dvd\util\GlobalManager.class

?????文件????????716??2012-06-18?11:46??dvdproject\dvdproject\bin\dvd\window\About$1.class

?????文件????????715??2012-06-18?11:46??dvdproject\dvdproject\bin\dvd\window\About$2.class

?????文件???????2369??2012-06-18?11:46??dvdproject\dvdproject\bin\dvd\window\About.class

?????文件????????726??2012-06-17?21:29??dvdproject\dvdproject\bin\dvd\window\FilmAdd$1.class

?????文件???????1988??2012-06-17?21:29??dvdproject\dvdproject\bin\dvd\window\FilmAdd$2.class

?????文件????????727??2012-06-17?21:29??dvdproject\dvdproject\bin\dvd\window\FilmAdd$3.class

?????文件???????3924??2012-06-17?21:29??dvdproject\dvdproject\bin\dvd\window\FilmAdd.class

?????文件????????761??2012-06-17?21:29??dvdproject\dvdproject\bin\dvd\window\FilmByDirector$1.class

?????文件???????2310??2012-06-17?21:29??dvdproject\dvdproject\bin\dvd\window\FilmByDirector$2.class

?????文件????????869??2012-06-17?21:29??dvdproject\dvdproject\bin\dvd\window\FilmByDirector$3.class

?????文件???????3163??2012-06-17?21:29??dvdproject\dvdproject\bin\dvd\window\FilmByDirector.class

?????文件????????741??2012-06-17?21:29??dvdproject\dvdproject\bin\dvd\window\FilmByLead$1.class

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