/*
?*?功能：幼兒園管理系統數據庫處理
?*?作者：王洪麗
?*?時間：18.06.07
?*/
package?com.yey.db;

import?java.sql.*;

public?class?sqlHelper?{
	PreparedStatement?ps=null;
	Connection?ct=null;
	ResultSet?rs=null;
	String?dirver=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	String?url=“jdbc:sqlserver://127.0.0.1:1433;databaseName=yeysjk“;
	String?user=“sa“;
	String?passws=“wjjhlgdf0513“;
	
	public?sqlHelper（）{
			//初始化對象
			//1.加載驅動
			try?{
				Class.forName（dirver）;
				
				//2.得到連接
				ct=DriverManager.getConnection（urluserpassws）;
			}?catch?（ClassNotFoundException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
	}
	
	//關閉數據庫資源
	public?void?close（）{
		try?{
			if（ps!=null）
			ps.close（）;
			if（ct!=null）
			ct.close（）;
		}?catch?（SQLException?t）?{
			//?TODO?Auto-generated?catch?block
			t.printStackTrace（）;
		}
	}
	

	//查詢操作
	public?ResultSet?queryExectue（String?sqlString[]?paras?）{
		try?{
			//創建ps
			ps=ct.prepareStatement（sql）;

			//注入值
			for（int?i=0;i				ps.setString（i+1?paras[i]）;
			}
			//3.執行【如果是增添，刪除，修改?executeUpdate（）如果是查詢的話executeQuery（）】
			rs=ps.executeQuery（）;
			
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		finally?{
			//?TODO:?handle?finally?clause
			//this.close（）;
		}
		return?rs;
	}
	
	//把增刪改合在一起
	public?boolean?updExecute（String?sqlString[]?paras）{
		boolean?b=true;
		try?{

			//創建ps
			ps=ct.prepareStatement（sql）;

			//注入值
			for（int?i=0;i				ps.setString（i+1?paras[i]）;
			}
			//3.執行【如果是增添，刪除，修改?executeUpdate（）如果是查詢的話executeQuery（）】
			if（ps.executeUpdate（）!=1）{
				b=false;
			}
			
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
			b=false;
			e.printStackTrace（）;
		}
		finally?{
			//?TODO:?handle?finally?clause
			this.close（）;
		}
		return?b;
	}
}

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

?????文件????????416??2018-06-08?14:29??yeyglxt\.classpath

?????文件????????383??2018-06-07?23:09??yeyglxt\.project

?????文件????????598??2018-06-07?23:09??yeyglxt\.settings\org.eclipse.jdt.core.prefs

?????文件?????270932??2018-06-08?23:05??yeyglxt\bin\bjtp.jpg

?????文件???????2568??2018-06-08?20:54??yeyglxt\bin\com\yey\db\sqlHelper.class

?????文件???????1750??2018-06-08?21:29??yeyglxt\bin\com\yey\model\dlModel.class

?????文件???????3258??2018-06-09?00:21??yeyglxt\bin\com\yey\model\rcModel.class

?????文件???????2797??2018-06-08?20:26??yeyglxt\bin\com\yey\model\stuModel.class

?????文件????????603??2018-06-08?17:53??yeyglxt\bin\com\yey\tools\MyTool.class

?????文件???????1119??2018-06-09?00:20??yeyglxt\bin\com\yey\view\ParentsEnq$BackImage.class

?????文件???????3210??2018-06-09?00:20??yeyglxt\bin\com\yey\view\ParentsEnq.class

?????文件???????1117??2018-06-08?20:26??yeyglxt\bin\com\yey\view\TeacherEnq$BackImage.class

?????文件???????3002??2018-06-08?20:26??yeyglxt\bin\com\yey\view\TeacherEnq.class

?????文件???????1111??2018-06-08?21:32??yeyglxt\bin\com\yey\view\UserLogin$BackImage.class

?????文件???????3667??2018-06-08?21:32??yeyglxt\bin\com\yey\view\UserLogin.class

?????文件?????286649??2018-06-08?23:06??yeyglxt\bin\dljm.jpg

?????文件?????145386??2018-06-08?23:06??yeyglxt\bin\jzcxbj.jpg

?????文件?????270932??2018-06-08?23:05??yeyglxt\image\bjtp.jpg

?????文件?????286649??2018-06-08?23:06??yeyglxt\image\dljm.jpg

?????文件?????145386??2018-06-08?23:06??yeyglxt\image\jzcxbj.jpg

?????文件???????2085??2018-06-08?20:54??yeyglxt\src\com\yey\db\sqlHelper.java

?????文件???????1197??2018-06-08?21:29??yeyglxt\src\com\yey\model\dlModel.java

?????文件???????2665??2018-06-09?00:21??yeyglxt\src\com\yey\model\rcModel.java

?????文件???????2186??2018-06-08?20:26??yeyglxt\src\com\yey\model\stuModel.java

?????文件????????324??2018-06-08?17:53??yeyglxt\src\com\yey\tools\MyTool.java

?????文件???????3243??2018-06-09?00:20??yeyglxt\src\com\yey\view\ParentsEnq.java

?????文件???????2199??2018-06-08?20:26??yeyglxt\src\com\yey\view\TeacherEnq.java

?????文件???????2633??2018-06-08?21:32??yeyglxt\src\com\yey\view\UserLogin.java

?????目錄??????????0??2018-06-09?00:24??yeyglxt\bin\com\yey\db

?????目錄??????????0??2018-06-09?00:24??yeyglxt\bin\com\yey\model

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