package?com.means.sql;

/**
?*?集合調(diào)用到的數(shù)據(jù)庫語句
?*/
public?class?SqlCmd?{
	/**?登陸查詢用戶----列名----dbo.unpw*/
	public?static?final?String?LONGIN_un?=?“un“;
	public?static?final?String?LONGIN_pw?=?“pw“;
	public?static?final?String?LONGIN_qx?=?“qx“;
	/**?登陸查詢用戶----查?*/
	public?static?final?String?LOGINUSERSelect?=?“SELECT?*?FROM?[Sun].[dbo].[unpw]?WHERE?“?+?LONGIN_qx?+?“=?1“;
	public?static?final?String?LOGINUSERunpw?=?“SELECT?*?FROM?[Sun].[dbo].[unpw]?WHERE?“?+?LONGIN_qx?+?“=?‘“;
	public?static?final?String?LOGINUSERQx?=?“SELECT?*?FROM?[Sun].[dbo].[unpw]?WHERE?“?+?LONGIN_un?+?“=?‘“;

	/**?學生管理系統(tǒng)----列名----dbo.Student?*/
	public?static?final?String?STUDENT_Sno?=?“Sno“;
	public?static?final?String?STUDENT_Sname?=?“Sname“;
	public?static?final?String?STUDENT_Ssex?=?“Ssex“;
	public?static?final?String?STUDENT_Sbrithday?=?“Sbrithday“;
	public?static?final?String?STUDENT_Sdept?=?“Sdept“;
	/**?學生管理系統(tǒng)----增刪查?*/
	public?static?final?String?STUMANAGEInsertUser?=?“INSERT?INTO?[Sun].[dbo].[unpw]?values?（‘“;
	public?static?final?String?STUMANAGEDelete?=?“DELETE?FROM?[Sun].[dbo].[Student]?WHERE?“?+?STUDENT_Sno?+?“=?‘“;
	public?static?final?String?STUMANAGEDeleteUser?=?“DELETE?FROM?[Sun].[dbo].[unpw]?WHERE?“?+?LONGIN_un?+?“=?‘“;
	public?static?final?String?STUMANAGESelect?=?“SELECT?*?FROM?[Sun].[dbo].[Student]“;
	public?static?final?String?STUMANAGESelectSno?=?“SELECT?*?FROM?[Sun].[dbo].[Student]?WHERE?“?+?STUDENT_Sno?+?“?=?‘“;
	public?static?final?String?STUMANAGESelectorder?=?“SELECT?*?FROM?[Sun].[dbo].[Student]?ORDER?BY?“?+?“‘“?+?STUDENT_Sno?+?“‘“;

	/**?課程信息?----列名----dbo.Course*/
	public?static?final?String?COURSE_Sno?=?“Sno“;
	public?static?final?String?COURSE_Cno?=?“Cno“;
	public?static?final?String?COURSE_Kind?=?“Kind“;
	public?static?final?String?COURSE_Teacher?=?“Teacher“;
	public?static?final?String?COURSE_Credit?=?“Credit“;
	/**?課程信息?----查*/
	public?static?final?String?COURSESelect?=?“SELECT?*?FROM?[Sun].[dbo].[Course]“;

	/**?學生成績管理----列名----dbo.Grade*/
	public?static?final?String?GRADE_Cno?=?“Cno“;
	public?static?final?String?GRADE_Cname?=?“Cname“;
	public?static?final?String?GRADE_Crade?=?“Grade“;
	/**?學生成績管理----查?*/
	public?static?final?String?GRADESelect?=?“SELECT?*?FROM?[Sun].[dbo].[Grade][Sun].[dbo].[Course]?Where?Grade.Cno??=??Course.Cno?“;
	public?static?final?String?GRADESelectSno?=?“SELECT?*?FROM?[Sun].[dbo].[Grade][Sun].[dbo].[Course]?Where?Grade.Cno??=??Course.Cno?AND?Course.Sno?“+?“?=?‘“;
	public?static?final?String?GRADESelectCno?=?“SELECT?“+?GRADE_Cno?+“?FROM?[Sun].[dbo].[Grade]?Where?Grade.Cname?=?‘“;
	
}

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

????I.A....???3145728??2016-05-25?21:26??數(shù)據(jù)庫\sun.mdf

????I.A....???1048576??2016-05-25?21:26??數(shù)據(jù)庫\sun_log.ldf

????I.A....???????416??2016-05-24?19:51??ManageSystem\.classpath

????I.A....???????388??2016-05-24?19:50??ManageSystem\.project

????I.A....???????598??2016-05-24?19:50??ManageSystem\.settings\org.eclipse.jdt.core.prefs

????I.A....??????2137??2016-05-25?23:16??ManageSystem\bin\com\means\sql\SqlCmd.class

????I.A....??????1313??2016-05-25?23:16??ManageSystem\bin\com\means\sql\SqlCoon.class

????I.A....???????536??2016-05-25?23:16??ManageSystem\bin\com\means\sql\SqlKey.class

????I.A....??????2624??2016-05-26?00:41??ManageSystem\bin\com\operate\admin\AdminInterface.class

????I.A....??????3443??2016-05-26?00:49??ManageSystem\bin\com\operate\admin\AdminSelectGrade.class

????I.A....??????3450??2016-05-26?00:49??ManageSystem\bin\com\operate\admin\AdminSelectUser.class

????I.A....??????4679??2016-05-25?23:44??ManageSystem\bin\com\operate\admin\GradeUpdate.class

????I.A....??????4588??2016-05-26?00:45??ManageSystem\bin\com\operate\common\Course.class

????I.A....??????7212??2016-05-26?00:50??ManageSystem\bin\com\operate\common\GradeManage.class

????I.A....??????8916??2016-05-26?00:51??ManageSystem\bin\com\operate\common\StuManage.class

????I.A....??????6492??2016-05-26?00:11??ManageSystem\bin\com\operate\common\StuUpdate.class

????I.A....??????5178??2016-05-25?23:16??ManageSystem\bin\com\operate\main\Login.class

????I.A....??????1140??2016-05-25?23:16??ManageSystem\bin\com\operate\main\Main.class

????I.A....???????782??2016-05-26?00:39??ManageSystem\bin\com\operate\main\Mkey.class

????I.A....????534993??2015-02-02?01:42??ManageSystem\lib\beautyeye_lnf.jar

????I.A....????537303??2015-09-17?13:05??ManageSystem\lib\sqljdbc4.jar

????I.A....??????2673??2016-05-25?21:30??ManageSystem\src\com\means\sql\SqlCmd.java

????I.A....???????875??2016-05-25?21:31??ManageSystem\src\com\means\sql\SqlCoon.java

????I.A....???????323??2016-05-25?21:33??ManageSystem\src\com\means\sql\SqlKey.java

????I.A....??????2407??2016-05-26?00:41??ManageSystem\src\com\operate\admin\AdminInterface.java

????I.A....??????2502??2016-05-26?00:49??ManageSystem\src\com\operate\admin\AdminSelectGrade.java

????I.A....??????2521??2016-05-26?00:49??ManageSystem\src\com\operate\admin\AdminSelectUser.java

????I.A....??????3633??2016-05-25?23:44??ManageSystem\src\com\operate\admin\GradeUpdate.java

????I.A....??????3781??2016-05-26?00:45??ManageSystem\src\com\operate\common\Course.java

????I.A....??????6709??2016-05-26?00:50??ManageSystem\src\com\operate\common\GradeManage.java

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