grade_manager.java

来自「本系统实现的是一个信息发布平台」· Java 代码 · 共 113 行

/*
 * 创建日期 2005-8-31
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package cn.edu.bit.business;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import cn.edu.bit.DBQuery.DataProcess;
import cn.edu.bit.Object.Grade;

/**
 * @author ligang
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class Grade_Manager {
	
	public static Grade getGrade(int ID)
	{
		String query = "select * from grade where id="+ID;
//		System.out.println(query);
		Connection con = DataProcess.getConnection();
		
		Grade grade = Grade.getInstance();
		
		try{
			
			Statement stmt = con.createStatement();
			
			ResultSet rs = stmt.executeQuery(query);
			
			if(rs.next())
			{				
				String name = rs.getString("grade");
				
				grade.setId(ID);
				
				grade.setName(name);
			}
			
			rs.close();
			
			stmt.close();
			
			con.close();
			
			return grade;
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}
	}
	
	public static ArrayList getGradeList()
	{
		String query = "select * from grade";
		
		Connection con = DataProcess.getConnection();
		
		ArrayList gl = new ArrayList();
		
		try{
			
			Statement stmt = con.createStatement();
			
			ResultSet rs = stmt.executeQuery(query);
			
			while(rs.next())
			{				
				int ID = rs.getInt("id");
				
				String name = rs.getString("grade_name");
				
				Grade grade = Grade.getInstance();
				
				grade.setId(ID);
				
				grade.setName(name);
				
				gl.add(grade);
			}
			
			rs.close();
			
			stmt.close();
			
			con.close();
			
			return gl;
		
		}
		catch(Exception e)
		{
			e.printStackTrace();
			
			return null;
		}
		
	}	

}