package?com.mhl.db;
import?java.sql.*;

public?class?sqlHelper?{
	Connection?con;
	PreparedStatement?ps;
	ResultSet?rs;
	
	public?void?Driver（）?{
		try?{
			Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;
			con?=?DriverManager.getConnection（“jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=restaurant““sa““sa“）;
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
	}
	
	public?ResultSet?Query（String?sqlString[]?paras）?{
		this.Driver（）;
		try?{
			ps?=?con.prepareStatement（sql）;
			for（int?i=0;i				ps.setString（i+1?paras[i]）;
			}
			rs?=?ps.executeQuery（）;
			
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?rs;
	}
	
	public?void?close（）?{
		try?{
			if（rs?!=?null）?{
				rs.close（）;
			}
			if（ps?!=?null）?{
				ps.close（）;
			}
			if（con?!=?null）?{
				con.close（）;
			}
			
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
}

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

?????文件????????564??2010-05-12?15:56??Restaurant\.classpath

?????文件????????386??2010-05-12?15:56??Restaurant\.project

?????文件????????629??2010-05-12?15:56??Restaurant\.settings\org.eclipse.jdt.core.prefs

?????文件???????1938??2010-05-12?15:56??Restaurant\bin\com\mhl\db\sqlHelper.class

?????文件???????2038??2010-05-12?15:56??Restaurant\bin\com\mhl\model\EmpModel.class

?????文件???????1264??2010-05-12?15:56??Restaurant\bin\com\mhl\model\UserModel.class

?????文件????????546??2010-05-12?15:56??Restaurant\bin\com\mhl\tools\ToolFont.class

?????文件????????974??2010-05-12?15:56??Restaurant\bin\com\mhl\tools\ToolImage.class

?????文件???????2715??2010-05-12?15:56??Restaurant\bin\com\mhl\view\EmpInfo.class

?????文件???????1101??2010-05-12?15:56??Restaurant\bin\com\mhl\view\UserLogin$BackImage.class

?????文件???????3964??2010-05-12?15:56??Restaurant\bin\com\mhl\view\UserLogin.class

?????文件??????10062??2010-05-12?15:56??Restaurant\bin\com\mhl\view\Windows1.class

?????文件????????900??2010-05-12?15:56??Restaurant\image\bj.jpg

?????文件???????1150??2010-05-12?15:56??Restaurant\image\exit.jpg

?????文件????????946??2010-05-12?15:56??Restaurant\image\jb.jpg

?????文件???????1180??2010-05-12?15:56??Restaurant\image\jt1.jpg

?????文件???????1015??2010-05-12?15:56??Restaurant\image\jt10.jpg

?????文件???????1186??2010-05-12?15:56??Restaurant\image\jt2.jpg

?????文件????????918??2010-05-12?15:56??Restaurant\image\jt3.jpg

?????文件???????1018??2010-05-12?15:56??Restaurant\image\jt4.jpg

?????文件????????999??2010-05-12?15:56??Restaurant\image\jt5.jpg

?????文件????????942??2010-05-12?15:56??Restaurant\image\jt6.jpg

?????文件???????1047??2010-05-12?15:56??Restaurant\image\jt7.jpg

?????文件???????1021??2010-05-12?15:56??Restaurant\image\jt8.jpg

?????文件???????1113??2010-05-12?15:56??Restaurant\image\jt9.jpg

?????文件???????1029??2010-05-12?15:56??Restaurant\image\login.jpg

?????文件???????1441??2010-05-12?15:56??Restaurant\image\p1.jpg

?????文件???????1198??2010-05-12?15:56??Restaurant\image\p1_bbtj.jpg

?????文件??????19510??2010-05-12?15:56??Restaurant\image\p1_bbtj_h.jpg

?????文件???????1055??2010-05-12?15:56??Restaurant\image\p1_cb.jpg

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