package?ljsql;

import?java.io.File;
import?java.util.InputMismatchException;
import?java.util.Scanner;

/*
?*?此類的函數用來實現選擇數據庫并進行操作
?*/
public?class?chooseAnddo?extends?sql?{
	//?全局變量用來傳數據庫的名字來給createtb的函數
	public?static?String?str?=?null;

	

	public?static?void?chooseANDdoroot（）?{
		System.out.println（“Please?select?the?database?as?follows：“）;
		System.out.println（“use?database-name;“）;
		Scanner?input4?=?new?Scanner（System.in）;
		String?sentence?=?input4.nextLine（）;

		while?（sentence.lastIndexOf（“;“）?!=?sentence.length（）?-?1）?{
			sentence?=?sentence?+?“?“?+?input4.nextLine（）;
		}
		sentence?=?sentence.substring（0?sentence.lastIndexOf（“;“））;
		String[]?ss?=?sentence.split（“\\s+“）;
		str=ss[1];
		?File?file?=?new?File（“mydatabase\\“+chooseAnddo.str）;
		?if（file.exists（））{
		if?（ss[0].equals（“use“））?{

			if?（ss[1].length（）?>?1）?{
				
				//System.out.println（sqlhelp.filedbname.toString（））;
				
				
					System.out.println（“You?have?chosen?the?database:“?+?“?“?+?ss[1]）;
					str?=?ss[1];

					System.out.println（“Please?select?your?operation?under?this?database：“）;
					System.out.println（“----------------------------“）;
					System.out.println（“1.create?table“）;
					System.out.println（“2.Show?the?tables?under?the?current?database“）;
					System.out.println（“3.delete?table“）;
					System.out.println（“4.Show?the?data?structure?in?the?data?table“）;
					System.out.println（“5.Insert?the?contents?into?the?data?table“）;
					System.out.println（“6.Query?the?contents?of?the?data?table“）;
					System.out.println（“7.update?the?table“）;
					System.out.println（“8.delete?some?contents?from?the?table“）;
					System.out.println（“9.exit?current?database“）;
					System.out.println（“----------------------------“）;
					System.out.println（“Please?enter?the?options：“）;
					while?（true）?{
						
						Scanner?input5?=?new?Scanner（System.in）;
						try{
						int?option?=?input5.nextInt（）;
						switch?（option）?{
						case?1:
							//?數據表的建立?--?識別sql的create?table?表名；
							createtb.createtb（）;
							break;
						case?2:
							//?查看當前數據庫下有哪些數據表
							sqlhelp.tbhelpcount（）;
							break;
						case?3:
							//?刪除某個數據表
							deletetb.deletb（）;
							break;
						case?4:
							//查看某個表的結構
							describetb.desctb（）;
							break;
						case?5:
							//插入數據到某個表中
							inserttb.iserttb（）;
							break;
						case?6:
							//查詢數據表的內容
							selectfromTb.sftb（）;
							break;
						case?7:
							//更新表
							updatatb.update（）;
							break;
						case?8:
							//刪除表中的某些內容
							deletefromTb.delfromtb（）;
							break;
						case?9:
							sql.sqldbroot（）;;
						}
						}catch（InputMismatchException?e）{??//撲捉異常
						??????System.out.println（“The?input?format?is?incorrect?!“）;
						}
					}
				
				
			}?else?{
				System.out.println（
						“Database?name?format?input?error?select?database?failed!?Please?re-select?your?operating?options：“）;
			}

		

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-07-06?21:16??LJsql\
?????文件?????????355??2017-07-03?08:20??LJsql\.classpath
?????文件?????????381??2017-06-27?13:14??LJsql\.project
?????目錄???????????0??2017-06-27?13:14??LJsql\.settings\
?????文件?????????598??2017-06-27?13:14??LJsql\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2017-07-03?08:20??LJsql\bin\
?????目錄???????????0??2017-07-06?16:49??LJsql\bin\ljsql\
?????文件????????4418??2017-07-06?10:41??LJsql\bin\ljsql\chooseAnddo.class
?????文件????????2095??2017-07-03?08:20??LJsql\bin\ljsql\createdb.class
?????文件????????3540??2017-07-04?20:50??LJsql\bin\ljsql\createtb.class
?????文件????????1930??2017-07-03?21:09??LJsql\bin\ljsql\deletedb.class
?????文件????????3838??2017-07-05?19:58??LJsql\bin\ljsql\deletefromTb.class
?????文件????????1769??2017-07-04?09:11??LJsql\bin\ljsql\deletetb.class
?????文件????????2952??2017-07-04?21:16??LJsql\bin\ljsql\describetb.class
?????文件????????4939??2017-07-06?18:26??LJsql\bin\ljsql\grant.class
?????文件????????4042??2017-07-05?08:26??LJsql\bin\ljsql\inserttb.class
?????文件????????5192??2017-07-06?18:26??LJsql\bin\ljsql\revoke.class
?????文件????????5908??2017-07-06?21:02??LJsql\bin\ljsql\selectfromTb.class
?????文件????????2681??2017-07-06?18:26??LJsql\bin\ljsql\showper.class
?????文件????????3085??2017-07-06?17:09??LJsql\bin\ljsql\sql.class
?????文件????????3132??2017-07-04?11:59??LJsql\bin\ljsql\sqlhelp.class
?????文件????????1472??2017-07-07?11:39??LJsql\bin\ljsql\sqllogin.class
?????文件????????4057??2017-07-05?19:25??LJsql\bin\ljsql\updatatb.class
?????文件???????????0??2017-07-02?20:35??LJsql\filenametep
?????目錄???????????0??2017-07-03?08:19??LJsql\jarneed\
?????文件??????611696??2009-06-11?18:36??LJsql\jarneed\jxl.jar
?????目錄???????????0??2017-07-06?20:43??LJsql\mydatabase\
?????目錄???????????0??2017-07-05?21:15??LJsql\mydatabase\jinge1\
?????文件???????18432??2017-07-05?21:15??LJsql\mydatabase\jinge1\student.xls
?????文件???????????0??2017-07-04?21:00??LJsql\mydatabase\jinge1\teacher.xls
?????目錄???????????0??2017-07-05?10:19??LJsql\mydatabase\jinge11\
............此處省略45個文件信息