restoobj.java

成绩查询系统（学校期末的作业） Struts+jdbc+mysql+tomcat 开发工具为BEA WORKSHOP 功能无非就是增删查改加用户权限判断

package sfs.connection;

import java.sql.ResultSet;
import java.sql.SQLException;

import sfs.entity.Score;
import sfs.entity.Student;
import sfs.entity.Teacher;

/**
 * @author nono
 * 将记录集转化为实体对象
 */
public class ResToObj{
	/**
	 * @param table
	 * @param res
	 * @return 实体对象
	 * @throws SQLException
	 */
	public static Object excute(String table,ResultSet res) throws SQLException{
		if (table=="user_teacher"){
			Teacher te=new Teacher();
			te.setAuthority(res.getString("authority"));
			te.setId(res.getInt("id"));
			te.setNumber(res.getString("number"));
			te.setPassword(res.getString("password"));
			te.setRealname(res.getString("realname"));
			
			return te;
		}
		
		if (table=="user_student"){
			Student st=new Student();
			st.setClassname(res.getString("classname"));
			st.setDepartment(res.getString("department"));
			st.setId(res.getInt("id"));
			st.setNumber(res.getString("number"));
			st.setPassword(res.getString("password"));
			st.setRealname(res.getString("realname"));
			st.setAuthority(res.getString("authority"));
			return st;
		}
		
		if (table=="st_score") {
			Score sc=new Score();
			sc.setChinese(res.getString("chinese"));
			sc.setComputer(res.getString("computer"));
			sc.setEnglish(res.getString("english"));
			sc.setGeography(res.getString("geography"));
			sc.setId(res.getInt("id"));
			sc.setMath(res.getString("math"));
			sc.setNumber(res.getString("number"));
			sc.setPolitics(res.getString("politics"));
			return sc;
		}
		return null;
	}
}