package?com.Chenchao.mian;

import?java.sql.Connection?;
import?java.sql.DriverManager?;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement?;
import?java.util.Scanner;

public?class?StuAdd{

	@SuppressWarnings（“unused“）
	private?static?final?Scanner?In?=?null;

	@SuppressWarnings（{?“resource“?“unused“?}）
	public?static?void?Stuadd（）?throws?Exception?{	???????????														//?所有的異常拋出
		Class.forName（“com.mysql.jdbc.Driver“）;?????????????????????????????????????????????????????????????????????????//加載數據庫驅動
		Connection?conn?=?null?;																									//?數據庫連接
		?try?{
				conn?=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/mydb“?“root“?“123456“）;????//連接數據庫
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		Statement?stmt?=?null?;																										//?數據庫操作
		PreparedStatement?pstmt?=?null?;		
????????Scanner?scan=new?Scanner（System.in）;
?????
????????int?temp=0;????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????//正則表達式
????????String?KeyWord=null;
????????boolean?flag=true;
????????while（flag）{
????????	System.out.println（“請輸入編號：“）;
????????	KeyWord=new?Scanner（System.in）.next（）;
????????	
????????	if（KeyWord.matches（“^\\d+$“））{																					//判斷輸入的是否為數字
????????	temp=Integer.parseInt（KeyWord）;
????????	flag=false;
????????}
????????else{
????????	System.out.println（“出現錯誤請重新輸入!!!“）;
????????}
????????}
?		ResultSet?rs?=?null?;	???????????????????????????????????????????????????????????????????										?//?接收查詢結果
?		String?SQL?=?“SELECT?IDNameAgeSexMail?“?+
?				“?FROM?StudentTab?WHERE??ID?LIKE???“?;																	//使用模糊查詢，對比數據庫信息，判斷信息是否存在
		?		pstmt?=?conn.prepareStatement（SQL）?;																	//?實例化PreapredStatement對象
		?		pstmt.setString（1“%“+KeyWord+“%“）?;
?		rs?=?pstmt.executeQuery（）?;	
?		if（rs.next（））{
?			String?ID1?=?rs.getString（1）?;
?			String?Name1?=?rs.getString（2）?;
?			String?Age1?=?rs.getString（3）?;
?			String?Sex1?=?rs.getString（4）?;
?			String?Mail1=rs.getString（5）;
?			?System.out.println（“該編號已存在！！！：“）;
?			System.out.println（“編號：“?+?ID1+?“??“+“姓名：“+?Name1?+“??“+“年齡：“+Age1+“??“+“性別：“+?Sex1?+“??“+“郵箱地址：“+Mail1）;
?			System.out.println（“-------------------------------------------------------------------------------“）?;
?		}
?		else{
?	????????System.out.println（“請輸入姓名：“）;
?			String?Name?=?new?Scanner（System.in）.nextLine（）;	?????????????												
?			System.out.println（“請輸入年齡：“）;
?			String?Age?=?new?Scanner（System.in）.next（）;
?			System.out.println（“請輸入性別（male?or?famale）:“）;
?			String?Sex?=?new?Scanner（System.in）.next（）;
?			System.out.println（“請輸入郵箱：“）;
?			String?Mail?=?new?Scanner（System.in）.next（）;
?			String?sql?=?“INSERT?INTO?StudentTab?（IDNameAgeSexMail）?“+
?				“?VALUES?（‘“+KeyWord+“‘‘“+Name+“‘“+Age+“‘“+Sex+“‘‘“+Mail+“‘）“?;
?			?						
?			stmt

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

?????文件????????379??2017-05-15?18:37??201516010207-陳超\Student\.classpath

?????文件????????383??2017-05-15?17:13??201516010207-陳超\Student\.project

?????文件????????598??2017-05-15?17:13??201516010207-陳超\Student\.settings\org.eclipse.jdt.core.prefs

?????文件???????3778??2017-05-25?17:17??201516010207-陳超\Student\bin\com\Chenchao\mian\StuAdd.class

?????文件???????3147??2017-05-25?17:17??201516010207-陳超\Student\bin\com\Chenchao\mian\StuDelete.class

?????文件???????2675??2017-05-25?17:17??201516010207-陳超\Student\bin\com\Chenchao\mian\Student.class

?????文件???????2803??2017-05-25?17:17??201516010207-陳超\Student\bin\com\Chenchao\mian\StuFind.class

?????文件???????2310??2017-05-25?17:17??201516010207-陳超\Student\bin\com\Chenchao\mian\StuShow.class

?????文件???????4610??2017-05-25?17:17??201516010207-陳超\Student\bin\com\Chenchao\mian\StuUpdate.class

?????文件?????990927??2017-05-15?18:36??201516010207-陳超\Student\lib\mysql-connector-java-5.1.40-bin.jar

?????文件???????3508??2017-05-24?13:18??201516010207-陳超\Student\src\com\Chenchao\mian\StuAdd.java

?????文件???????2804??2017-05-25?10:27??201516010207-陳超\Student\src\com\Chenchao\mian\StuDelete.java

?????文件???????2256??2017-05-23?09:43??201516010207-陳超\Student\src\com\Chenchao\mian\Student.java

?????文件???????2393??2017-05-23?19:18??201516010207-陳超\Student\src\com\Chenchao\mian\StuFind.java

?????文件???????2029??2017-05-23?21:43??201516010207-陳超\Student\src\com\Chenchao\mian\StuShow.java

?????文件???????5282??2017-05-23?21:44??201516010207-陳超\Student\src\com\Chenchao\mian\StuUpdate.java

?????文件?????229888??2017-05-30?13:24??201516010207-陳超\大作業實驗報告.doc

?????文件???????3508??2017-05-24?13:18??201516010207-陳超\源碼\StuAdd.java

?????文件???????2804??2017-05-25?10:27??201516010207-陳超\源碼\StuDelete.java

?????文件???????2256??2017-05-23?09:43??201516010207-陳超\源碼\Student.java

?????文件???????2393??2017-05-23?19:18??201516010207-陳超\源碼\StuFind.java

?????文件???????2029??2017-05-23?21:43??201516010207-陳超\源碼\StuShow.java

?????文件???????5282??2017-05-23?21:44??201516010207-陳超\源碼\StuUpdate.java

?????目錄??????????0??2017-05-30?13:24??201516010207-陳超\Student\bin\com\Chenchao\mian

?????目錄??????????0??2017-05-30?13:24??201516010207-陳超\Student\src\com\Chenchao\mian

?????目錄??????????0??2017-05-30?13:24??201516010207-陳超\Student\bin\com\Chenchao

?????目錄??????????0??2017-05-30?13:24??201516010207-陳超\Student\src\com\Chenchao

?????目錄??????????0??2017-05-30?13:24??201516010207-陳超\Student\bin\com

?????目錄??????????0??2017-05-30?13:24??201516010207-陳超\Student\src\com

?????目錄??????????0??2017-05-30?13:24??201516010207-陳超\Student\.settings

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