selectsomethingservice.java

基本分数查询功能,自己的毕业设计作品!希望能给大家一点帮助!

package org.xk.service.interfaces;

import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;

import org.xk.po.ClassUser;

public interface SelectSomethingService {
	/**
	 * 根据教师姓名查询班级信息
	 */  
   public List getClassInfo(int teacher_id)throws SQLException ;
   public HashMap getTeacherInfo(int teacher_id)throws SQLException;
   
	/**
	 * 获得年份信息
	 */  
   public List getYearsInfo();
   
	/**
	 * 获得学生信息
	 * @throws SQLException 
	 */ 
   public List getStudentInfo(int class_id) throws SQLException;
   public List getStudentInfo1(String stu_number) throws SQLException; 
 
   public List getSubjectInfo(int year_id,int class_id,int port_id) throws SQLException;
   
   public HashMap getScoreInfo(String score_number,int year_id,int class_id,int port_id) throws SQLException;
   
   public HashMap getStudentMessageInfo(int stu_id) throws SQLException;
   public HashMap getClass(int class_id) throws SQLException;
   public HashMap getPort(int port_id) throws SQLException;
   public List getScore(String score_number,int year_id,int class_id,int port_id ) throws SQLException;
   
   public List getPortInfo() throws SQLException;
   
   public List getTeacherByDp(int port_id) throws SQLException;
   
   public List getAdminInfo() throws SQLException;
   public HashMap getAdmin(int admin_id) throws SQLException;
   
   
   
   
   
}