package?com.databaseclass;

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

public?class?DBConnection?
{
	/**
	?*?創建與數據庫的連接
	?*?@param?databaseName???數據庫名字
	?*?@param?userName???????用戶名
	?*?@param?userPwd????????用戶密碼
	?*?@return
	?*/
	public?Connection?dataCon（String?databaseNameString?userNameString?userPwd）
	{
		Connection?con=null;
		try
		{
			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
			con=DriverManager.getConnection（“jdbc:sqlserver://localhost:1433;databasename=“+databaseName?userName?userPwd）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
		}
		return?con;
	}
	
	/**
	?*?關閉數據庫的連接
	?*?@param?con
	?*/
	public?void?dataClose（Connection?con）
	{
		try?
		{
			if（!con.isClosed（））
			{
				con.close（）;
			}
		}
		catch?（SQLException?e）
		{
			e.printStackTrace（）;
		}
	}
}

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

?????文件????????924??2018-05-18?20:50??Shop1\.classpath

?????文件???????1055??2018-04-15?22:24??Shop1\.project

?????文件????????564??2018-04-10?04:45??Shop1\.settings\.jsdtscope

?????文件?????????66??2018-04-15?15:14??Shop1\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2018-04-10?04:45??Shop1\.settings\org.eclipse.jdt.core.prefs

?????文件????????474??2018-04-15?22:24??Shop1\.settings\org.eclipse.wst.common.component

?????文件????????358??2018-04-30?11:54??Shop1\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-04-10?04:45??Shop1\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-04-10?04:45??Shop1\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????935??2018-04-15?11:03??Shop1\src\com\databaseclass\DBConnection.java

?????文件???????1219??2018-04-15?11:39??Shop1\src\com\databaseclass\UserHelp.java

?????文件???????1196??2018-04-15?13:56??Shop1\src\com\servlet\LoginCheck.java

?????文件???????2380??2018-04-15?14:15??Shop1\WebRoot\addCookies.js

?????文件??????10888??2018-04-15?12:26??Shop1\WebRoot\Image\0.jpg

?????文件??????26241??2018-04-15?12:26??Shop1\WebRoot\Image\1.jpg

?????文件??????12745??2018-04-15?12:26??Shop1\WebRoot\Image\2.jpg

?????文件???????2027??2018-04-15?15:17??Shop1\WebRoot\Login.jsp

?????文件???????2531??2018-04-15?16:30??Shop1\WebRoot\MainPage.jsp

?????文件?????????39??2018-04-10?04:45??Shop1\WebRoot\meta-INF\MANIFEST.MF

?????文件????????570??2018-04-15?15:14??Shop1\WebRoot\Result.jsp

?????文件????????531??2018-04-15?15:04??Shop1\WebRoot\thingsPackage.js

?????文件???????1528??2018-05-18?20:50??Shop1\WebRoot\WEB-INF\classes\com\databaseclass\DBConnection.class

?????文件???????1886??2018-05-18?20:50??Shop1\WebRoot\WEB-INF\classes\com\databaseclass\UserHelp.class

?????文件???????2126??2018-05-18?20:50??Shop1\WebRoot\WEB-INF\classes\com\servlet\LoginCheck.class

?????文件?????825265??2017-10-12?11:04??Shop1\WebRoot\WEB-INF\lib\JDBCforJRE1.7.jar

?????文件??????25880??2018-04-15?22:24??Shop1\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2018-05-18?20:50??Shop1\WebRoot\WEB-INF\classes\com\databaseclass

?????目錄??????????0??2018-05-18?20:50??Shop1\WebRoot\WEB-INF\classes\com\servlet

?????目錄??????????0??2018-05-18?20:50??Shop1\WebRoot\WEB-INF\classes\com

?????目錄??????????0??2018-05-18?20:44??Shop1\src\com\databaseclass

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