package?dao;

import?java.sql.*;
public?class?baseDao?{
	private?static?final?String?DRIVER_CLASS=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?static?final?String?DATAbase_URL=“jdbc:sqlserver://localhost:1433;DatabaseName=forum“;
	private?static?final?String?USER=“sa“;
	private?static?final?String?PASSWORD=“sa2005“;
	public?static?Connection?getConnection（）{
		Connection?con=null;
		try?{
			Class.forName（DRIVER_CLASS）;
			con=DriverManager.getConnection（DATAbase_URLUSERPASSWORD）;
			System.out.println（“連接成功！！“）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?自動生成?catch?塊
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?自動生成?catch?塊
			e.printStackTrace（）;
		}
		return?con;
	}
	public?static?void?closeAll（Connection?conStatement?stResultSet?rs）{
		if（rs!=null）{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?自動生成?catch?塊
				e.printStackTrace（）;
			}
		}
		if（st!=null）{
			try?{
				st.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?自動生成?catch?塊
				e.printStackTrace（）;
			}
		}
		if（rs!=null）{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?自動生成?catch?塊
				e.printStackTrace（）;
			}
		}
	}
}

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

?????文件????????432??2008-10-11?16:47??Forum\.classpath

?????文件????????288??2008-10-15?17:07??Forum\.mymetadata

?????文件???????1223??2008-10-09?17:54??Forum\.project

?????文件???????1686??2008-10-15?09:28??Forum\WebRoot\index.jsp

?????文件????????381??2008-10-09?16:15??Forum\WebRoot\WEB-INF\web.xml

?????文件?????253122??2008-10-11?16:47??Forum\WebRoot\WEB-INF\lib\sql2005.jar

?????文件???????1386??2008-10-16?08:58??Forum\WebRoot\WEB-INF\classes\impl\UserDaoImpl.class

?????文件???????3506??2008-10-16?08:58??Forum\WebRoot\WEB-INF\classes\impl\MessageDaoImpl.class

?????文件????????832??2008-10-16?08:58??Forum\WebRoot\WEB-INF\classes\entity\User.class

?????文件???????1760??2008-10-16?08:58??Forum\WebRoot\WEB-INF\classes\entity\Message.class

?????文件????????160??2008-10-16?08:58??Forum\WebRoot\WEB-INF\classes\dao\UserDao.class

?????文件????????295??2008-10-16?08:58??Forum\WebRoot\WEB-INF\classes\dao\MessageDao.class

?????文件???????1726??2008-10-16?08:58??Forum\WebRoot\WEB-INF\classes\dao\baseDao.class

?????文件?????????39??2008-10-09?16:15??Forum\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1591??2008-10-09?15:41??Forum\WebRoot\style\style.css

?????文件???????1201??2008-10-12?10:29??Forum\WebRoot\doLogin.jsp

?????文件???????1826??2008-10-16?10:54??Forum\WebRoot\listMsg.jsp

?????文件???????1999??2008-10-15?16:48??Forum\WebRoot\post.jsp

?????文件???????1703??2008-10-16?14:51??Forum\WebRoot\showMsg.jsp

?????文件???????1091??2008-10-13?14:43??Forum\WebRoot\doDelete.jsp

?????文件???????1439??2008-10-15?17:00??Forum\WebRoot\doPost.jsp

?????文件???????8954??2008-10-09?15:41??Forum\WebRoot\image\new.jpg

?????文件???????9043??2008-10-09?15:41??Forum\WebRoot\image\old.jpg

?????文件???????1198??2008-10-12?17:23??Forum\src\entity\Message.java

?????文件????????419??2008-10-12?10:45??Forum\src\entity\User.java

?????文件???????1268??2008-10-12?09:58??Forum\src\dao\baseDao.java

?????文件????????297??2008-10-12?11:19??Forum\src\dao\MessageDao.java

?????文件????????100??2008-10-12?10:13??Forum\src\dao\UserDao.java

?????文件???????2601??2008-10-15?16:11??Forum\src\impl\MessageDaoImpl.java

?????文件????????662??2008-10-12?09:58??Forum\src\impl\UserDaoImpl.java

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