classassiimpl.java

学校期间做的实践项目

/**
 *  (c) Copyright 2007 computer01
 *
 *   FILENAME     :  ClassAssiImpl.java
 *   PACKAGE      :  com.computer01.entitysuport
 *   CREATE DATE  : 2007-11-21
 *   AUTHOR       :  huhp
 *   DESCRIPTION  :  TAB_CLASS实体的辅助类，完成实体的CRDU操作
 */
package com.computer01.entitysuport;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.computer01.common.Linkdb;
import com.computer01.entity.AllEntity;
import com.computer01.entity.TAB_CLASS;

public class ClassAssiImpl 
extends TAB_CLASS implements EntityAssiInterface{ /**
	 * 数据库操作类
	 */
	Linkdb linkdb = null;
	public void deleteEntity(AllEntity allentity) {
		// TODO Auto-generated method stub
		
	}

	public List getEntityList(AllEntity allentity) {
		// 学生实体信息列表
		List<AllEntity> claEntityList = 
			new ArrayList<AllEntity>();
		try{
			linkdb = new Linkdb();
			//sql Buffer
			StringBuffer buff = new StringBuffer();
			buff
			.append("select cla.CLASSNO ,cla.CLASSNAME ")
			.append("from tab_class cla;");
			
			//执行查询
			ResultSet rs =
				linkdb.executeQuery(buff.toString());
			
			while(rs.next()){
//				//封装
				//所有注册实体
				AllEntity claallentity
				= new AllEntity();
				//班级实体
				TAB_CLASS claentity = new TAB_CLASS();
				claentity.setCLASSNO(
						new Integer(rs.getShort(1)));
				claentity.setCLASSNAME(
						rs.getString(2));
				//把班级实体添加到allEntity
				claallentity.setTabclass(claentity);
				
				//将allEntity添加至list
				claEntityList.add(claallentity);
				
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		return claEntityList;
	}

	public void saveEntity(AllEntity allentity) {
		// TODO Auto-generated method stub
		
	}

	public int updateEntity(AllEntity allentity) {
		// TODO Auto-generated method stub
		return 0;
	}

}