//數據庫連接類，方法：public?static?Connection?getConnction（）
//注意：檢查數據庫名、用戶名、密碼?需正確
package?bean;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

public?class?DBcon?{

	private?static?final?String?DRIVER_CLASS?=?“com.mysql.jdbc.Driver“;

	private?static?final?String?DATAbase_URL?=
		“jdbc:mysql://localhost:3306/liuyanban?useUnicode=true&characterEncoding=UTF-8“;

	private?static?final?String?DATAbase_USRE?=?“root“;

	private?static?final?String?DATAbase_PASSWORD?=?“root“;
	//?返回連接
	public?static?Connection?getConnction（）?{
		Connection?dbConnection?=?null;
		try?{
			Class.forName（DRIVER_CLASS）;
			dbConnection?=?DriverManager.getConnection（DATAbase_URL
					DATAbase_USRE?DATAbase_PASSWORD）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}

		return?dbConnection;
	}

	
	?//?關閉連接
	public?static?void?closeConnection（Connection?dbConnection）?{
		try?{
			if?（dbConnection?!=?null?&&?（!dbConnection.isClosed（）））?{
				dbConnection.close（）;
			}
		}?catch?（SQLException?sqlEx）?{
			sqlEx.printStackTrace（）;
		}

	}

	?//?關閉結果集
	public?static?void?closeResultSet（ResultSet?res）?{
		try?{
			if?（res?!=?null）?{
				res.close（）;
				res?=?null;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}

	public?static?void?closeStatement（PreparedStatement?pStatement）?{
		try?{
			if?（pStatement?!=?null）?{
				pStatement.close（）;
				pStatement?=?null;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
}

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

?????文件???????1169??2018-03-19?20:01??jsp_liuyanban\jsp_xinxi\.classpath

?????文件???????1334??2018-03-25?10:02??jsp_liuyanban\jsp_xinxi\.project

?????文件????????522??2017-12-19?09:47??jsp_liuyanban\jsp_xinxi\.settings\.jsdtscope

?????文件?????????65??2018-03-26?13:39??jsp_liuyanban\jsp_xinxi\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2017-12-19?09:47??jsp_liuyanban\jsp_xinxi\.settings\org.eclipse.jdt.core.prefs

?????文件????????486??2018-03-25?10:02??jsp_liuyanban\jsp_xinxi\.settings\org.eclipse.wst.common.component

?????文件????????414??2017-12-19?09:47??jsp_liuyanban\jsp_xinxi\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-12-19?09:47??jsp_liuyanban\jsp_xinxi\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-12-19?09:47??jsp_liuyanban\jsp_xinxi\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????27052??2018-03-28?10:04??jsp_liuyanban\jsp_xinxi\img\beijing1.jpg

?????文件??????23498??2018-03-28?10:04??jsp_liuyanban\jsp_xinxi\img\beijing2.jpg

?????文件???????1648??2018-03-25?10:11??jsp_liuyanban\jsp_xinxi\src\bean\DBcon.java

?????文件????????933??2018-03-27?10:52??jsp_liuyanban\jsp_xinxi\src\bean\title.java

?????文件????????502??2018-03-27?19:05??jsp_liuyanban\jsp_xinxi\src\bean\titleDao.java

?????文件???????8640??2018-03-29?16:26??jsp_liuyanban\jsp_xinxi\src\bean\titleDaoImpl.java

?????文件???????1098??2018-03-28?12:34??jsp_liuyanban\jsp_xinxi\src\filter\SetCharacterEncoding.java

?????文件???????1558??2018-03-27?19:36??jsp_liuyanban\jsp_xinxi\src\servlet\DoAddtitle.java

?????文件???????1077??2018-03-27?20:20??jsp_liuyanban\jsp_xinxi\src\servlet\DoDeletetitle.java

?????文件???????1705??2018-03-27?20:21??jsp_liuyanban\jsp_xinxi\src\servlet\DoSaveEdittitle.java

?????文件???????1449??2018-03-27?21:06??jsp_liuyanban\jsp_xinxi\src\servlet\DoXiangxi.java

?????文件???????1195??2018-03-27?19:54??jsp_liuyanban\jsp_xinxi\src\servlet\ExitLogin.java

?????文件???????2011??2018-03-26?09:21??jsp_liuyanban\jsp_xinxi\src\servlet\ImageServlet.java

?????文件???????1761??2018-03-28?09:28??jsp_liuyanban\jsp_xinxi\src\servlet\LoginServlet.java

?????文件???????1700??2018-03-29?10:30??jsp_liuyanban\jsp_xinxi\src\servlet\PageServletgl.java

?????文件???????1631??2018-03-29?10:27??jsp_liuyanban\jsp_xinxi\src\servlet\PageServletpt.java

?????文件???????1472??2018-03-25?21:56??jsp_liuyanban\jsp_xinxi\src\servlet\SearchServlet.java

?????文件???????1102??2018-03-26?11:14??jsp_liuyanban\jsp_xinxi\src\servlet\ToEdittitle.java

?????文件???????1300??2018-03-27?08:44??jsp_liuyanban\jsp_xinxi\src\servlet\Xiuliuyan.java

?????文件???????1257??2018-03-28?09:09??jsp_liuyanban\jsp_xinxi\WebRoot\addtitle.jsp

?????文件??????27052??2018-03-28?10:04??jsp_liuyanban\jsp_xinxi\WebRoot\beijing1.jpg

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