package?com.test;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;


public?class?DBUtil?{
	public?String?DBDRIVER=“com.mysql.jdbc.Driver“;
	public?String?DBURL=“jdbc:mysql://127.0.0.1:3306/ContactDB?characterEncoding=GB2312“;
	public?String?DBUSER=“root“;
	public?String?DBPASS=“root“;
	
	private?Connection?conn=null;
	private?Statement?stmt=null;
	private?ResultSet?rs=null;
	
	public?DBUtil（）{
		try?{
			Class.forName（DBDRIVER）;//加載驅(qū)動
		}?catch?（ClassNotFoundException?e）?{
			
			e.printStackTrace（）;
			System.out.println（“驅(qū)動加載失敗“）;
		}
	}

	public?Connection?getConnection（）{
		try?{
			conn=DriverManager.getConnection（DBURLDBUSERDBPASS）;//獲取數(shù)據(jù)庫連接
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			System.out.println（“數(shù)據(jù)庫連接失敗“）;
		}
		return?conn;
	}
	
	public?ResultSet?executeQuery（String?sql）{
		if（conn==null）
			conn=getConnection（）;
		try?{
			stmt=conn.createStatement（）;
			rs=stmt.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?rs;
		
	}
	
	/**
	?*?修改，刪除，更新記錄操作
	?*?@param?sql
	?*?@return
	?*/
	public?int?executeUpdate（String?sql）{
		int?result?=?0;
		if（conn==null）
			conn=getConnection（）;
		try?{
			stmt?=?conn.createStatement（）;
			result?=?stmt.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			System.out.println（“執(zhí)行失敗！“）;
			result?=?0;
		}
		return?result;//執(zhí)行影響的行數(shù)
	}
	
	
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????623??2014-03-28?22:46??ContactMng\.classpath

?????文件????????304??2014-03-31?14:40??ContactMng\.mymetadata

?????文件???????1620??2014-03-28?22:46??ContactMng\.project

?????文件????????500??2014-03-28?22:46??ContactMng\.settings\.jsdtscope

?????文件???????1040??2014-03-25?20:32??ContactMng\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件????????133??2014-03-25?21:01??ContactMng\.settings\org.eclipse.core.resources.prefs

?????文件????????395??2014-03-28?22:46??ContactMng\.settings\org.eclipse.jdt.core.prefs

?????文件????????468??2014-03-28?22:46??ContactMng\.settings\org.eclipse.wst.common.component

?????文件????????252??2014-03-28?22:46??ContactMng\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-03-28?22:46??ContactMng\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-03-28?22:46??ContactMng\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1160??2014-03-28?22:51??ContactMng\contactdb.sql

?????文件???????1629??2014-03-31?14:57??ContactMng\src\com\test\DBUtil.java

?????文件???????1314??2014-03-29?01:54??ContactMng\WebRoot\doupdate.jsp

?????文件???????2225??2014-03-29?01:36??ContactMng\WebRoot\edit.jsp

?????文件???????1893??2014-03-29?01:24??ContactMng\WebRoot\index.jsp

?????文件?????????36??2014-03-25?19:53??ContactMng\WebRoot\meta-INF\MANIFEST.MF

?????文件???????2110??2014-03-31?14:57??ContactMng\WebRoot\WEB-INF\classes\com\test\DBUtil.class

?????文件?????785998??2014-03-25?19:53??ContactMng\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.15-bin.jar

?????文件????????371??2014-03-25?19:53??ContactMng\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2014-03-31?15:19??ContactMng\WebRoot\WEB-INF\classes\com\test

?????目錄??????????0??2014-03-31?15:19??ContactMng\WebRoot\WEB-INF\classes\com

?????目錄??????????0??2014-03-31?15:19??ContactMng\src\com\test

?????目錄??????????0??2014-03-31?15:19??ContactMng\WebRoot\WEB-INF\classes

?????目錄??????????0??2014-03-31?15:19??ContactMng\WebRoot\WEB-INF\lib

?????目錄??????????0??2014-03-31?15:19??ContactMng\src\com

?????目錄??????????0??2014-03-31?15:19??ContactMng\WebRoot\meta-INF

?????目錄??????????0??2014-03-31?15:19??ContactMng\WebRoot\WEB-INF

?????目錄??????????0??2014-03-31?15:19??ContactMng\.myeclipse

?????目錄??????????0??2014-03-31?15:19??ContactMng\.settings

............此處省略6個(gè)文件信息