package?com.party.common;
import?java.sql.*;

public?class?Conn?{
	Connection?conn?=?null;
	Statement?stmt?=?null;
	ResultSet?rs?=?null;
	
	public?Conn（）?{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		}?catch?（java.lang.ClassNotFoundException?e）?{
			System.err.println（e.getMessage（））;
		}
	}
	
	public?ResultSet?executeQuery（String?sql）?{
		try?{
			conn?=?DriverManager
					.getConnection（
							“jdbc:mysql://localhost:3306/partydb?useUnicode=true&characterEncoding=UTF-8“
							“root“?“123456“）;
			stmt?=?conn.createStatement（）;
			rs?=?stmt.executeQuery（sql）;
		}?catch?（SQLException?ex）?{
			System.err.println（ex.getMessage（））;
		}
		return?rs;
	}
	
	public?int?executeUpdate（String?sql）?{
		int?result?=?0;
		try?{
			conn?=?DriverManager
					.getConnection（
							“jdbc:mysql://localhost:3306/partydb?useUnicode=true&characterEncoding=UTF-8“
							“root“?“123456“）;
			stmt?=?conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVE
					ResultSet.CONCUR_READ_ONLY）;
			result?=?stmt.executeUpdate（sql）;
		}?catch?（SQLException?ex）?{
			result?=?0;
		}
		return?result;
	}

	
	public?void?close（）?{
		try?{
			if?（rs?!=?null）
				rs.close（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（System.err）;
		}
		try?{
			if?（stmt?!=?null）
				stmt.close（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（System.err）;
		}
		try?{
			if?（conn?!=?null）?{
				conn.close（）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（System.err）;
		}
	}
}

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

?????文件????????478??2014-10-15?15:19??party_merber\.classpath

?????文件????????857??2014-05-13?16:38??party_merber\.project

?????文件????????105??2014-05-18?14:01??party_merber\.settings\org.eclipse.core.resources.prefs

?????文件????????629??2014-05-13?20:12??party_merber\.settings\org.eclipse.jdt.core.prefs

?????文件????????217??2014-05-13?16:38??party_merber\.settings\org.eclipse.jst.common.project.facet.core.prefs

?????文件????????452??2014-05-13?16:38??party_merber\.settings\org.eclipse.wst.common.component

?????文件????????229??2014-05-13?16:38??party_merber\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件???????1537??2014-05-16?21:04??party_merber\src\com\party\common\Conn.java

?????文件???????1294??2014-05-06?08:47??party_merber\src\com\party\common\DataConverter.java

?????文件???????2485??2014-05-06?08:47??party_merber\src\com\party\common\DataValidator.java

?????文件???????1822??2014-05-14?21:55??party_merber\src\com\party\common\Utility.java

?????文件???????2362??2014-05-08?10:30??party_merber\src\com\party\dal\Class.java

?????文件???????6324??2014-05-18?19:04??party_merber\src\com\party\dal\Partymerber.java

?????文件???????5714??2014-05-17?23:20??party_merber\src\com\party\dal\Users.java

?????文件???????1076??2014-05-07?09:38??party_merber\src\com\party\model\ClassInfo.java

?????文件???????3363??2014-05-18?16:19??party_merber\src\com\party\model\FeeInfo.java

?????文件???????2512??2014-05-18?18:42??party_merber\src\com\party\model\PartymerberInfo.java

?????文件???????1917??2014-05-18?20:01??party_merber\src\com\party\model\UsersInfo.java

?????文件????????740??2014-05-07?13:38??party_merber\src\com\party\model\ZhibuInfo.java

?????文件?????200797??2014-05-18?11:43??party_merber\WebContent\images\1400384624468.jpg

?????文件?????200797??2014-05-18?12:01??party_merber\WebContent\images\1400385700562.jpg

?????文件?????200797??2014-05-18?12:03??party_merber\WebContent\images\1400385808859.jpg

?????文件?????147707??2014-05-18?12:03??party_merber\WebContent\images\1400385839765.jpg

?????文件?????204311??2014-05-18?12:04??party_merber\WebContent\images\1400385872812.jpg

?????文件?????151169??2014-05-18?12:04??party_merber\WebContent\images\1400385881656.jpg

?????文件?????205744??2014-05-18?12:04??party_merber\WebContent\images\1400385892703.jpg

?????文件?????205744??2014-05-18?12:05??party_merber\WebContent\images\1400385900187.jpg

?????文件?????671747??2014-05-18?12:06??party_merber\WebContent\images\1400385982437.jpg

?????文件?????231227??2014-05-18?12:23??party_merber\WebContent\images\1400386996218.jpg

?????文件?????200797??2014-05-18?12:23??party_merber\WebContent\images\1400387025000.jpg

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