package?connection;

import?java.sql.*;

public?class?DBconnection?{
	public?Connection?conn=null;
//	public?Statement?stmt=null;
	public?ResultSet?rs=null;
	public?static?String?Driver?=?“com.mysql.jdbc.Driver“;
	public?static?String?Url?=?“jdbc:mysql://localhost:3306/test“;
	public?static?String?User?=?“root“;
	public?static?String?Pwd?=?“111“;
	//open?connection
	public?static?Connection?getConnection（）
	{
		Connection?conn=null;
		try?
		{
			Class.forName（Driver）;
			conn?=?DriverManager.getConnection（Url?User?Pwd）;
		}
		catch?（Exception?e）
		{
			e.printStackTrace（）;
		}
		return?conn;
	}
	//讀取結果集
	/*public?ResultSet?doQuery（String?sql）
	{
		try
		{
			conn=DBconnection.getConnection（）;
			stmt=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
			rs=stmt.executeQuery（sql）;
		}
		catch（SQLException?e）
		{
			e.printStackTrace（）;
		}
		return?rs;
	}*/
	//更新數據
	/*public?int?doupdate（String?sql）
	{
		int?result=0;
		try
		{
			conn=DBconnection.getConnection（）;
			stmt=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
			result=stmt.executeUpdate（sql）;
		}
		catch（SQLException?e）
		{
			result=0;
		}
		return?result;
	}*/
	//關閉Connection
	public?static?void?closeConnection（Connection?conn）
	{
		if（conn!=null）
		{
			try?
			{
				conn.close（）;
			}
			catch?（SQLException?e）
			{
				e.printStackTrace（）;
			}
		}
	}
	//關閉PreparedStatement
	public?static?void?closePstmt（PreparedStatement?pstmt）
	{
		if（pstmt!=null）
		{
			try?
			{
				pstmt.close（）;
			}?
			catch?（SQLException?e）?
			{
				e.printStackTrace（）;
			}
		}
	}
	//關閉ResultSet
	public?static?void?closeRs（ResultSet?rs）
	{
		if（rs!=null）
		{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}
}

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

?????文件????????455??2011-11-14?21:48??jsphomework\.classpath

?????文件????????306??2011-11-17?10:50??jsphomework\.mymetadata

?????文件???????1229??2011-11-01?22:45??jsphomework\.project

?????文件????????703??2011-11-14?22:24??jsphomework\WebRoot\Display.jsp

?????文件????????834??2011-11-01?22:44??jsphomework\WebRoot\index.jsp

?????文件???????1420??2011-11-14?22:07??jsphomework\WebRoot\register.html

?????文件????????831??2011-11-02?19:47??jsphomework\WebRoot\WEB-INF\web.xml

?????文件?????709922??2011-11-14?21:37??jsphomework\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.7-bin.jar

?????文件???????3985??2011-11-29?19:03??jsphomework\WebRoot\WEB-INF\classes\Myservlet\Myservlet.class

?????文件???????1808??2011-11-18?13:22??jsphomework\WebRoot\WEB-INF\classes\connection\DBconnection.class

?????文件???????1091??2011-11-18?13:22??jsphomework\WebRoot\WEB-INF\classes\connection\Information.class

?????文件????????649??2011-11-18?13:22??jsphomework\WebRoot\WEB-INF\classes\connection\Test.class

?????文件?????????39??2011-11-01?22:44??jsphomework\WebRoot\meta-INF\MANIFEST.MF

?????文件???????2497??2011-11-29?19:02??jsphomework\src\Myservlet\Myservlet.java

?????文件???????1910??2011-11-14?23:58??jsphomework\src\connection\DBconnection.java

?????文件????????621??2011-11-02?20:37??jsphomework\src\connection\Information.java

?????文件????????286??2011-11-02?20:56??jsphomework\src\connection\Test.java

?????目錄??????????0??2011-11-23?08:52??jsphomework\WebRoot\WEB-INF\classes\Myservlet

?????目錄??????????0??2011-11-23?08:52??jsphomework\WebRoot\WEB-INF\classes\connection

?????目錄??????????0??2011-11-23?08:52??jsphomework\WebRoot\WEB-INF\lib

?????目錄??????????0??2011-11-23?08:52??jsphomework\WebRoot\WEB-INF\classes

?????目錄??????????0??2011-11-23?08:52??jsphomework\WebRoot\WEB-INF

?????目錄??????????0??2011-11-23?08:52??jsphomework\WebRoot\meta-INF

?????目錄??????????0??2011-11-23?08:52??jsphomework\src\Myservlet

?????目錄??????????0??2011-11-23?08:52??jsphomework\src\connection

?????目錄??????????0??2011-11-23?08:52??jsphomework\WebRoot

?????目錄??????????0??2011-11-23?08:52??jsphomework\src

?????目錄??????????0??2011-11-23?08:52??jsphomework\.myeclipse

?????目錄??????????0??2011-11-23?08:52??jsphomework

-----------?---------??----------?-----??----

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