package?com.javen.db;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

public?class?DBhepler?{
	/*String?driver?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	String?url?=?“jdbc:sqlserver://127.0.0.1;DatabaseName=Mobile“;*/
	
	String?driver?=?“com.mysql.jdbc.Driver“;
	String?url?=?“jdbc:mysql://127.0.0.1:3306/javenforexcel“;
	
	
	Connection?con?=?null;
	ResultSet?res?=?null;

	public?void?Database（）?{
			try?{
				Class.forName（driver）;
				con?=?DriverManager.getConnection（url?“root“?“root“）;
			}?catch?（ClassNotFoundException?e）?{
				//?TODO?Auto-generated?catch?block
				??System.err.println（“裝載?JDBC/ODBC?驅動程序失敗。“?）;??
				e.printStackTrace（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				System.err.println（“無法連接數據庫“?）;?
				e.printStackTrace（）;
			}
	}

	//?查詢
	public?ResultSet??Search（String?sql?String?str[]）?{
		Database（）;
		try?{
			PreparedStatement?pst?=con.prepareStatement（sql）;
			if?（str?!=?null）?{
				for?（int?i?=?0;?i?					pst.setString（i?+?1?str[i]）;
				}
			}
			res?=?pst.executeQuery（）;

		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?res;
	}

	//?增刪修改
	public?int?AddU（String?sql?String?str[]）?{
		int?a?=?0;
		Database（）;
		try?{
			PreparedStatement?pst?=?con.prepareStatement（sql）;
			if?（str?!=?null）?{
				for?（int?i?=?0;?i?					pst.setString（i?+?1?str[i]）;
				}
			}
			a?=?pst.executeUpdate（）;
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?a;
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\
?????文件?????????431??2014-05-29?11:25??JavaForExcel\.classpath
?????文件?????????388??2014-05-21?14:15??JavaForExcel\.project
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\.settings\
?????文件?????????598??2014-05-21?14:15??JavaForExcel\.settings\org.eclipse.jdt.core.prefs
?????文件????????5131??2014-05-29?11:00??JavaForExcel\.settings\org.eclipse.jdt.ui.prefs
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\bin\
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\bin\com\
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\bin\com\javen\
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\bin\com\javen\db\
?????文件????????2472??2014-05-29?11:25??JavaForExcel\bin\com\javen\db\DBhepler.class
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\bin\com\javen\entity\
?????文件????????1634??2014-05-29?11:25??JavaForExcel\bin\com\javen\entity\StuEntity.class
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\bin\com\javen\excel\
?????文件????????2572??2014-05-29?16:27??JavaForExcel\bin\com\javen\excel\TestDbToExcel.class
?????文件????????4200??2014-05-29?11:25??JavaForExcel\bin\com\javen\excel\TestExcel.class
?????文件????????1838??2014-05-29?16:06??JavaForExcel\bin\com\javen\excel\TestExcelToDb.class
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\bin\com\javen\service\
?????文件????????3605??2014-05-29?16:27??JavaForExcel\bin\com\javen\service\StuService.class
?????文件????????1023??2014-05-29?16:32??JavaForExcel\javenforexcel.sql
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\lib\
?????文件??????725735??2014-05-21?16:49??JavaForExcel\lib\jxl.jar
?????文件??????709922??2014-02-19?11:55??JavaForExcel\lib\mysql-connector-java-5[1].1.7-bin.jar
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\src\
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\src\com\
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\src\com\javen\
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\src\com\javen\db\
?????文件????????1780??2014-05-29?10:57??JavaForExcel\src\com\javen\db\DBhepler.java
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\src\com\javen\entity\
?????文件?????????941??2014-05-29?11:24??JavaForExcel\src\com\javen\entity\StuEntity.java
?????目錄???????????0??2014-05-29?16:33??JavaForExcel\src\com\javen\excel\
............此處省略5個文件信息