package?database;

import?java.sql.*;

public?class?DBManager?{
	//?建立數(shù)據(jù)庫連接
	public?static?Connection?getConnection（）?{
		//?修改驅(qū)動，數(shù)據(jù)庫名，登錄用戶名，登錄密碼
		String?Drive_Class?=?“org.gjt.mm.mysql.Driver“;
		String?DB_Url?=?“jdbc:mysql://localhost:3306/gv“;
		String?DB_Name?=?“gv“;
		String?DB_Pwd?=?“123456“;
		Connection?con?=?null;

		try?{
			Class.forName（Drive_Class）;
			con?=?DriverManager.getConnection（DB_Url?DB_Name?DB_Pwd）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?con;
	}

	//?關(guān)閉數(shù)據(jù)連接
	public?static?void?closeConnection（Connection?conn）?{
		try?{
			if?（conn?!=?null?&&?（!conn.isClosed（）））?{
				conn.close（）;
			}
		}?catch?（SQLException?sqlEx）?{
			sqlEx.printStackTrace（）;
		}
	}

	//?關(guān)閉數(shù)據(jù)集
	public?static?void?closeResultSet（ResultSet?rs）?{
		try?{
			if?（rs?!=?null）?{
				rs.close（）;
				rs?=?null;
			}
		}?catch?（SQLException?sqlEx）?{
			sqlEx.printStackTrace（）;
		}
	}

	//?關(guān)閉命令
	public?static?void?closeStatement（PreparedStatement?pstmt）?{
		try?{
			if?（pstmt?!=?null）?{
				pstmt.close（）;
				pstmt?=?null;
			}
		}?catch?（SQLException?sqlEx）?{
			sqlEx.printStackTrace（）;
		}
	}
}

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

?????文件????????546??2010-06-29?18:42??mysql增刪改查\data\.classpath

?????文件????????285??2010-06-29?17:54??mysql增刪改查\data\.mymetadata

?????文件????????262??2010-06-29?18:42??mysql增刪改查\data\.mystrutsdata

?????文件???????1305??2010-06-29?18:42??mysql增刪改查\data\.project

?????文件?????????87??2010-06-29?18:42??mysql增刪改查\data\src\com\yourcompany\struts\ApplicationResources.properties

?????文件???????1368??2010-06-29?17:58??mysql增刪改查\data\src\database\DBManager.java

?????文件????????834??2009-05-22?12:53??mysql增刪改查\data\WebRoot\index.jsp

?????文件?????????39??2009-05-22?12:53??mysql增刪改查\data\WebRoot\meta-INF\MANIFEST.MF

?????文件????????746??2009-05-22?13:26??mysql增刪改查\data\WebRoot\query.jsp

?????文件???????2373??2009-05-22?13:37??mysql增刪改查\data\WebRoot\update.jsp

?????文件?????????48??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\.struts-config.mex

?????文件?????????87??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\classes\com\yourcompany\struts\ApplicationResources.properties

?????文件???????1786??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\classes\database\DBManager.class

?????文件?????709922??2009-05-22?12:53??mysql增刪改查\data\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.7-bin.jar

?????文件???????8860??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\struts-bean.tld

?????文件????????422??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\struts-config.xml

?????文件??????73617??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\struts-html.tld

?????文件??????14731??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\struts-logic.tld

?????文件??????71483??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\struts-nested.tld

?????文件???????7842??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\struts-tiles.tld

?????文件??????13781??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\validator-rules.xml

?????文件???????1033??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\web.xml

?????文件?????681901??2009-05-22?13:39??mysql增刪改查\data.rar

?????文件????????323??2009-05-22?13:45??mysql增刪改查\data.sql

?????文件????????341??2009-05-22?13:46??mysql增刪改查\說明.txt

?????目錄??????????0??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\classes\com\yourcompany\struts

?????目錄??????????0??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\classes\com\yourcompany

?????目錄??????????0??2010-06-29?18:42??mysql增刪改查\data\src\com\yourcompany\struts

?????目錄??????????0??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\classes\com

?????目錄??????????0??2010-06-29?18:42??mysql增刪改查\data\WebRoot\WEB-INF\classes\database

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