package?com.my;

import?java.sql.*;

public?class?DBM?{
	public?static?Connection?con=null;
	public?static?Statement?st=null;
	public?static?ResultSet?rs=null;
	public?static?PreparedStatement?ps=null;
	
	public?static?void?con（）throws?Exception{
		Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
		con=DriverManager.getConnection（“jdbc:sqlserver://localhost:1433;databasename=bbs““sa““huanzi211weixin“）;
		st=con.createStatement（）;
	}
	//防止sql注入如果碰到參數不一樣多的情況用方法重載
	public?static?ResultSet?con1（String?parameter1String?parameter2String?sql）throws?Exception{
		Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
		con=DriverManager.getConnection（“jdbc:sqlserver://localhost:1433;databasename=bbs““sa““huanzi211weixin“）;
		ps=con.prepareStatement（sql）;
		ps.setString（1?parameter1）;
		ps.setString（2?parameter2）;
		rs=ps.executeQuery（）;
		return?rs;
	}
	
	public?static?int??exUpdate（String?sql）throws?Exception{
		int?i=st.executeUpdate（sql）;
		return?i;
	}
	
	public?static?ResultSet?exQuery（String?sql）throws?Exception{
		rs=st.executeQuery（sql）;
		return?rs;
	}
	
	public?static?void?close（）throws?Exception{
		if（rs!=null）rs.close（）;
		if（st!=null）st.close（）;
		if（ps!=null）ps.close（）;
		if（con!=null）con.close（）;
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-12-22?19:51??bbs\
?????文件?????????599??2011-12-20?09:22??bbs\.classpath
?????目錄???????????0??2011-12-22?19:51??bbs\.myeclipse\
?????文件?????????282??2011-12-22?19:52??bbs\.mymetadata
?????文件????????1613??2011-12-20?09:22??bbs\.project
?????目錄???????????0??2011-12-22?19:51??bbs\.settings\
?????文件?????????500??2011-12-20?09:23??bbs\.settings\.jsdtscope
?????文件?????????395??2011-12-20?09:22??bbs\.settings\org.eclipse.jdt.core.prefs
?????文件?????????447??2011-12-20?09:22??bbs\.settings\org.eclipse.wst.common.component
?????文件?????????252??2011-12-20?09:23??bbs\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2011-12-20?09:23??bbs\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2011-12-20?09:23??bbs\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2011-12-22?19:51??bbs\src\
?????目錄???????????0??2011-12-22?19:51??bbs\src\com\
?????目錄???????????0??2011-12-22?19:51??bbs\src\com\my\
?????文件????????1325??2011-12-25?15:49??bbs\src\com\my\DBM.java
?????目錄???????????0??2011-12-25?15:02??bbs\WebRoot\
?????文件????????6152??2011-12-25?21:44??bbs\WebRoot\detail.jsp
?????目錄???????????0??2011-12-26?14:51??bbs\WebRoot\image\
?????文件?????????712??2011-12-19?14:26??bbs\WebRoot\image\board.gif
?????目錄???????????0??2011-12-22?19:51??bbs\WebRoot\image\head\
?????文件????????3728??2011-12-19?14:26??bbs\WebRoot\image\head\1.gif
?????文件????????3491??2011-12-19?14:26??bbs\WebRoot\image\head\10.gif
?????文件????????3574??2011-12-19?14:26??bbs\WebRoot\image\head\11.gif
?????文件????????3624??2011-12-19?14:26??bbs\WebRoot\image\head\12.gif
?????文件????????3362??2011-12-19?14:26??bbs\WebRoot\image\head\13.gif
?????文件????????3472??2011-12-19?14:26??bbs\WebRoot\image\head\14.gif
?????文件????????3343??2011-12-19?14:26??bbs\WebRoot\image\head\15.gif
?????文件????????3945??2011-12-19?14:26??bbs\WebRoot\image\head\2.gif
?????文件????????3762??2011-12-19?14:26??bbs\WebRoot\image\head\3.gif
?????文件????????3560??2011-12-19?14:26??bbs\WebRoot\image\head\4.gif
............此處省略48個文件信息