dbsql.java

培训时做的学生管理系统.基于J2SE平台开发

			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ " where t.classnum=c.classnum and t.s_id=s.s_id ";

	// 根据学号查询
	public static final String SELECT_BY_S_ID = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and s.s_id = ? order by t.s_id";

	// 根据学号查询获得行数
	public static final String SELECT_BY_S_ID_COUNT = "select "
			+ " count(*)from studentexamchivement t,classtable c,studentinfotable s "
			+ " where t.classnum=c.classnum and t.s_id=s.s_id and s.s_id = ? ";

	// 根据组号查询
	public static final String SELECT_BY_G_ID = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and s.G_id = ? order by t.s_id";

	// 根据组号查询获得行数
	public static final String SELECT_BY_G_ID_COUNT = "select "
			+ " count(*)from studentexamchivement t,classtable c,studentinfotable s "
			+ " where t.classnum=c.classnum and t.s_id=s.s_id and s.G_id = ?  ";

	// 根据课程号号查询
	public static final String SELECT_BY_C_ID = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and c.classnum = ? order by t.s_id";

	// 根据课程号号查询获得行数
	public static final String SELECT_BY_C_ID_COUNT = "select "
			+ " count(*)from studentexamchivement t,classtable c,studentinfotable s "
			+ " where t.classnum=c.classnum and t.s_id=s.s_id and c.classnum = ?  ";

	// 根据姓名查询
	public static final String SELECT_BY_S_NAME = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and ( s.s_name like ? or "
			+ " s.s_name like ? or s.s_name like ? or s.s_name like ? )";

	// 根据姓名查询获得行数
	public static final String SELECT_BY_S_NAME_COUNT = "select "
			+ " count(s.s_id) from studentexamchivement t,classtable c,studentinfotable s "
			+ " where t.classnum=c.classnum and t.s_id=s.s_id and ( s.s_name like ? or "
			+ " s.s_name like ? or s.s_name like ? or s.s_name like ? ) ";

	// 根据课程名称查询
	public static final String SELECT_BY_CLASS_NAME = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and ( c.classname like ? or "
			+ " c.classname like ? or c.classname like ? or c.classname like ? )";

	// 根据课程名称获得行数
	public static final String SELECT_BY_CLASS_COUNT = "select "
			+ " count(s.s_id) from studentexamchivement t,classtable c,studentinfotable s "
			+ " where t.classnum=c.classnum and t.s_id=s.s_id and ( c.classname like ? or "
			+ " c.classname like ? or c.classname like ? or c.classname like ? ) ";

	// 修改选中学生所选的课程
	public static final String UPDATE_EXAM_BY_STUID = " update studentexamchivement set " +
			" exam = ? where s_id=? and classnum=? ";

	// 获得所有课程名
	public static final String SELECT_CLASS_NAME = " select classnum,CLASSNAME from classtable  ";

	// 获得所有课程名行数
	public static final String SELECT_CLASS_NAME_COUNT = " select count(*) from classtable  ";

	// 获得所学科目学生学号姓名分数
	public static final String SELECT_CLASS_STU_SNO_SNAME_EXAM = "select "
			+ " s.s_id,s.s_name,t.exam from  "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ " where t.classnum=c.classnum and t.s_id=s.s_id and c.classnum = ? "
			+ " order by s.s_id";

	// 获得所学科目学生学号姓名分数行数
	public static final String SELECT_CLASS_STU_SNO_SNAME_EXAM_COUNT = "select "
			+ " count(s.s_id) from  "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ " where t.classnum=c.classnum and t.s_id=s.s_id and c.classnum = ? "
			+ " order by s.s_id";

	// 根据科目修改学生成绩
	public static final String UPDATE_CHIVEMENT_BY_CLASS = "UPDATE "
			+ "studentexamchivement set   exam= ? where s_id = ? and classnum=? ";
	
	
	
	
	
	
	
	
	/**
	 * 学生考试成绩管理 高级查询语句 
	 * 
	 */
	public static final String SELECT_00011 = "select "
		+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
		+ " studentexamchivement t,classtable c,studentinfotable s "
		+ "where t.classnum=c.classnum and t.s_id=s.s_id " +
				" and s.s_id=?  and c.classnum = ? ";
	
	public static final String SELECT_00101 = "select "
		+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
		+ " studentexamchivement t,classtable c,studentinfotable s "
		+ "where t.classnum=c.classnum and t.s_id=s.s_id " +
				" and s.g_id=?  and c.classnum = ? ";
	
	public static final String SELECT_00110 = "select "
		+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
		+ " studentexamchivement t,classtable c,studentinfotable s "
		+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
				" s.g_id = ? and s.s_id=?";
	
		public static final String SELECT_00111 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  s.g_id = ? and s.s_id=? and c.classnum = ? ";
	
		public static final String SELECT_01001 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					" ( s.s_name like ? or "
			+ " s.s_name like ? or s.s_name like ? " +
					" or s.s_name like ? ) and c.classnum = ? ";
	
		public static final String SELECT_01010 =  "select "
		+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
		+ " studentexamchivement t,classtable c,studentinfotable s "
		+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
				" ( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.s_id = ? ";
	
		public static final String SELECT_01011 = "select "
		+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
		+ " studentexamchivement t,classtable c,studentinfotable s "
		+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
				" ( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.s_id = ? and c.classnum = ? ";
	
		public static final String SELECT_01100 = "select "
		+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
		+ " studentexamchivement t,classtable c,studentinfotable s "
		+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
				" ( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.g_id = ? ";
	
		public static final String SELECT_01101 = "select "
		+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
		+ " studentexamchivement t,classtable c,studentinfotable s "
		+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
				" ( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.g_id = ? and c.classnum = ? ";
	
		public static final String SELECT_01110 = "select "
		+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
		+ " studentexamchivement t,classtable c,studentinfotable s "
		+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
				" ( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.g_id = ? and s.s_id = ? ";
	
		public static final String SELECT_01111 = "select "
		+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
		+ " studentexamchivement t,classtable c,studentinfotable s "
		+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
				" ( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.g_id = ? and s.s_id = ? " +
				" and c.classnum = ? ";
	
	
		public static final String SELECT_10001 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  ( c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and c.classnum = ? ";
	
		public static final String SELECT_10010 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					" ( c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and s.s_id = ? ";
	
		public static final String SELECT_10011 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					" ( c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and s.s_id = ? " +
					"and c.classnum = ? ";
	
	
		public static final String SELECT_10100 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  ( c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and s.g_id = ? ";
	
		public static final String SELECT_10101 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  (c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and s.g_id = ? " +
					" and c.classnum = ?  ";
	
		public static final String SELECT_10110 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  (c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and s.g_id = ? " +
					" and s.s_id = ? = ?  ";
	
	
		public static final String SELECT_10111 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					" ( c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and s.g_id = ? " +
					"  and s.s_id = ?  and c.classnum = ?   ";
	
	
	
		public static final String SELECT_11000 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  (c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and " +
					"( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? )";
	
		public static final String SELECT_11001 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  (c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and " +
					"( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and c.classnum = ?  ";
	
		public static final String SELECT_11010 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  (c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and " +
					"( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.s_id = ?  ";
	
		public static final String SELECT_11011 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  (c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and " +
					"( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.s_id = ?  and c.classnum = ? ";
	
	
	
		public static final String SELECT_11100 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  (c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and " +
					"( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.g_id = ? ";
	
		public static final String SELECT_11101 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  (c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and " +
					"( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.g_id = ?  and c.classnum = ? ";
	
		public static final String SELECT_11110 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  (c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and " +
					"( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.g_id = ?  and s.s_id = ? ";
	
		public static final String SELECT_11111 = "select "
			+ " s.s_id,s.g_id,s.s_name,c.classnum,c.classname,t.exam from "
			+ " studentexamchivement t,classtable c,studentinfotable s "
			+ "where t.classnum=c.classnum and t.s_id=s.s_id and " +
					"  (c.classname like ? or "
			+ " c.classname like ? or c.classname " +
					" like  ? or c.classname like ? ) and " +
					"( s.s_name like ? or "
		+ " s.s_name like ? or s.s_name like ? " +
				" or s.s_name like ? ) and s.g_id = ?  and s.s_id = ? " +
				"and c.classnum = ? ";
}