vchengjibean.java

JSP开发的学生信息管理系统

// Decompiled by Jad v1.5.8e2. Copyright 2001 Pavel Kouznetsov.
// Jad home page: http://kpdus.tripod.com/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   VchengjiBean.java

package mypackage;

import java.sql.*;
import java.util.ArrayList;
import java.util.Collection;

// Referenced classes of package mypackage:
//			Vchengji, DataBaseConnection

public class VchengjiBean
{

	private Connection con;
	private Statement stmt;
	private ResultSet rst;

	public VchengjiBean()
	{
		con = null;
		stmt = null;
		rst = null;
		con = DataBaseConnection.getConnection();
	}

	public Collection getSingleChengji(String s, String s1, String s2)
		throws Exception
	{
		stmt = con.createStatement(1005, 1008);
		rst = stmt.executeQuery("select * from v_chengji where grade='" + s + "' and stuClass='" + s1 + "' and courseId='" + s2 + "'");
		ArrayList arraylist = new ArrayList();
		Vchengji vchengji;
		for (; rst.next(); arraylist.add(vchengji))
		{
			vchengji = new Vchengji();
			vchengji.setStudentId(rst.getString("studentId"));
			vchengji.setStuName(rst.getString("stuName"));
			vchengji.setStuSex(rst.getString("stuSex"));
			vchengji.setGrade(rst.getString("grade"));
			vchengji.setAcademe(rst.getString("academe"));
			vchengji.setSpeciality(rst.getString("speciality"));
			vchengji.setStuClass(rst.getString("stuClass"));
			vchengji.setCourseId(rst.getString("courseId"));
			vchengji.setCourseName(rst.getString("courseName"));
			vchengji.setXuefen(rst.getString("xuefen"));
			vchengji.setCourseType(rst.getString("courseType"));
			vchengji.setTeacher(rst.getString("teacher"));
			vchengji.setScore(rst.getString("score"));
			vchengji.setXueqi(rst.getString("xueqi"));
		}

		if (rst != null)
			rst.close();
		if (stmt != null)
			stmt.close();
		if (con != null)
			con.close();
		return arraylist;
	}

	public Collection getCourseName(String s, String s1, String s2)
		throws Exception
	{
		stmt = con.createStatement(1005, 1008);
		rst = stmt.executeQuery("select courseName from v_chengji where grade='" + s + "' and stuClass='" + s1 + "' and xueqi='" + s2 + "'");
		ArrayList arraylist = new ArrayList();
		Vchengji vchengji;
		for (; rst.next(); arraylist.add(vchengji))
		{
			vchengji = new Vchengji();
			vchengji.setCourseName(rst.getString("courseName"));
		}

		if (rst != null)
			rst.close();
		if (stmt != null)
			stmt.close();
		return arraylist;
	}

	public Collection getXuenianCourse(String s, String s1, String s2)
		throws Exception
	{
		stmt = con.createStatement(1005, 1008);
		rst = stmt.executeQuery("select courseName from v_chengji where grade='" + s + "' and stuClass='" + s1 + "' and xueqi like '%" + s2 + "%'");
		ArrayList arraylist = new ArrayList();
		Vchengji vchengji;
		for (; rst.next(); arraylist.add(vchengji))
		{
			vchengji = new Vchengji();
			vchengji.setCourseName(rst.getString("courseName"));
		}

		if (rst != null)
			rst.close();
		if (stmt != null)
			stmt.close();
		return arraylist;
	}

	public Collection executeQuery(String s)
		throws Exception
	{
		stmt = con.createStatement(1005, 1008);
		rst = stmt.executeQuery(s);
		ArrayList arraylist = new ArrayList();
		Vchengji vchengji;
		for (; rst.next(); arraylist.add(vchengji))
		{
			vchengji = new Vchengji();
			vchengji.setStudentId(rst.getString("studentId"));
			vchengji.setStuName(rst.getString("stuName"));
			vchengji.setStuSex(rst.getString("stuSex"));
			vchengji.setGrade(rst.getString("grade"));
			vchengji.setAcademe(rst.getString("academe"));
			vchengji.setSpeciality(rst.getString("speciality"));
			vchengji.setStuClass(rst.getString("stuClass"));
			vchengji.setCourseId(rst.getString("courseId"));
			vchengji.setCourseName(rst.getString("courseName"));
			vchengji.setXuefen(rst.getString("xuefen"));
			vchengji.setCourseType(rst.getString("courseType"));
			vchengji.setTeacher(rst.getString("teacher"));
			vchengji.setScore(rst.getString("score"));
			vchengji.setXueqi(rst.getString("xueqi"));
			vchengji.setFlag(rst.getString("flag"));
		}

		if (rst != null)
			rst.close();
		if (stmt != null)
			stmt.close();
		if (con != null)
			con.close();
		return arraylist;
	}

	public void close()
	{
		try
		{
			rst.close();
			stmt.close();
			con.close();
		}
		catch (SQLException sqlexception)
		{
			sqlexception.printStackTrace();
		}
	}
}