banjibean.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:   BanjiBean.java

package mypackage;

import java.io.PrintStream;
import java.sql.*;

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

public class BanjiBean
{

	private Connection con;

	public BanjiBean()
	{
		con = null;
		con = DataBaseConnection.getConnection();
	}

	public boolean existBanji(Banji banji)
	{
		ResultSet resultset;
		String s = banji.getClassId();
		PreparedStatement preparedstatement = con.prepareStatement("select classId from banji where classId='" + s + "'");
		resultset = preparedstatement.executeQuery();
		Exception exception;
		return resultset.next();
		exception;
		return false;
	}

	public String addBanji(Banji banji)
	{
		PreparedStatement preparedstatement;
		preparedstatement = null;
		String s = "";
		String s2;
		if (!existBanji(banji))
			break MISSING_BLOCK_LABEL_23;
		s2 = "exist";
		return s2;
		String s1;
		try
		{
			preparedstatement = con.prepareStatement("insert into Banji values(?,?,?,?,?,?,?,?,?)");
			preparedstatement.setString(1, banji.getClassId());
			preparedstatement.setString(2, banji.getGrade());
			preparedstatement.setString(3, banji.getAcademe());
			preparedstatement.setString(4, banji.getSpeciality());
			preparedstatement.setString(5, banji.getClassName());
			preparedstatement.setInt(6, banji.getClassNumber());
			preparedstatement.setString(7, banji.getClassHead());
			preparedstatement.setString(8, banji.getClassDiscript());
			preparedstatement.setString(9, "1");
			preparedstatement.execute();
			s1 = "sucess";
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
			s1 = "failer";
		}
		break MISSING_BLOCK_LABEL_211;
		local;
		try
		{
			preparedstatement.close();
			con.close();
		}
		catch (Exception exception1)
		{
			exception1.printStackTrace();
		}
		JVM INSTR ret 6;
		return s1;
	}

	public String updateBanji(Banji banji)
	{
		PreparedStatement preparedstatement = null;
		String s = "";
		try
		{
			preparedstatement = con.prepareStatement("update banji set grade=?,academe=?,speciality=?,className=?,classNumber=?,classHead=?,classDiscript=? where classId=?");
			preparedstatement.setString(1, banji.getGrade());
			preparedstatement.setString(2, banji.getAcademe());
			preparedstatement.setString(3, banji.getSpeciality());
			preparedstatement.setString(4, banji.getClassName());
			preparedstatement.setInt(5, banji.getClassNumber());
			preparedstatement.setString(6, banji.getClassHead());
			preparedstatement.setString(7, banji.getClassDiscript());
			preparedstatement.setString(8, banji.getClassId());
			preparedstatement.execute();
			s = "sucess";
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
			s = "failer";
		}
		finally
		{
			try
			{
				preparedstatement.close();
				con.close();
			}
			catch (Exception exception1)
			{
				exception1.printStackTrace();
			}
		}
		return s;
	}

	public String deleteBanji(String s)
	{
		PreparedStatement preparedstatement = null;
		String s1 = "";
		try
		{
			preparedstatement = con.prepareStatement("update banji set flag=? where classId=?");
			preparedstatement.setString(1, "2");
			preparedstatement.setString(2, s);
			preparedstatement.execute();
			deleteXuesheng(s);
			s1 = "sucess";
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
			s1 = "failer";
		}
		finally
		{
			try
			{
				preparedstatement.close();
				con.close();
			}
			catch (Exception exception1)
			{
				exception1.printStackTrace();
			}
		}
		return s1;
	}

	public String recoverBanji(String s)
	{
		PreparedStatement preparedstatement = null;
		String s1 = "";
		try
		{
			preparedstatement = con.prepareStatement("update banji set flag=? where classId=?");
			preparedstatement.setString(1, "1");
			preparedstatement.setString(2, s);
			preparedstatement.execute();
			recoverXuesheng(s);
			s1 = "sucess";
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
			s1 = "failer";
		}
		finally
		{
			try
			{
				preparedstatement.close();
				con.close();
			}
			catch (Exception exception1)
			{
				exception1.printStackTrace();
			}
		}
		return s1;
	}

	public void deleteXuesheng(String s)
	{
		Object obj = null;
		try
		{
			PreparedStatement preparedstatement = con.prepareStatement("update xuesheng set flag='4' where studentId in(select studentId from xuesheng a,banji b where a.grade=b.grade and a.stuClass=b.className and b.classId='" + s + "')");
			preparedstatement.execute();
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
	}

	public void recoverXuesheng(String s)
	{
		Object obj = null;
		try
		{
			PreparedStatement preparedstatement = con.prepareStatement("update xuesheng set flag='1' where studentId in(select studentId from xuesheng a,banji b where a.grade=b.grade and a.stuClass=b.className and b.classId='" + s + "')");
			preparedstatement.execute();
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
	}

	public ResultSet executeQuery(String s)
	{
		Object obj = null;
		ResultSet resultset = null;
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			resultset = statement.executeQuery(s);
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		return resultset;
	}

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

	public ResultSet banjiMessage(String s)
		throws Exception
	{
		Object obj = null;
		ResultSet resultset = null;
		Object obj1 = null;
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			resultset = statement.executeQuery("select * from banji where classId='" + s + "'");
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		return resultset;
	}

	public String getAllClass()
	{
		PreparedStatement preparedstatement;
		ResultSet resultset;
		StringBuffer stringbuffer;
		preparedstatement = null;
		resultset = null;
		stringbuffer = new StringBuffer();
		preparedstatement = con.prepareStatement("select distinct className from banji");
		String s;
		for (resultset = preparedstatement.executeQuery(); resultset.next(); stringbuffer.append("<option value='" + s + "'>" + s + "</option>\n"))
			s = resultset.getString("className");

		break MISSING_BLOCK_LABEL_174;
		SQLException sqlexception;
		sqlexception;
		String s1;
		sqlexception.printStackTrace();
		s1 = "";
		return s1;
		local;
		try
		{
			if (resultset != null)
				resultset.close();
			if (preparedstatement != null)
				preparedstatement.close();
			if (con != null)
				con.close();
		}
		catch (Exception exception1)
		{
			exception1.printStackTrace();
		}
		JVM INSTR ret 7;
		return stringbuffer.toString();
	}
}