chengjibean.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:   ChengjiBean.java

package mypackage;

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

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

public class ChengjiBean
{

	private Connection con;

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

	public boolean existXuesheng(Chengji chengji)
	{
		boolean flag = false;
		try
		{
			String s = chengji.getStudentId();
			PreparedStatement preparedstatement = con.prepareStatement("select studentId from xuesheng where studentId='" + s + "' and flag='" + 1 + "'");
			ResultSet resultset = preparedstatement.executeQuery();
			if (resultset.next())
				flag = true;
			if (resultset != null)
				resultset.close();
			if (preparedstatement != null)
				preparedstatement.close();
		}
		catch (Exception exception)
		{
			exception.printStackTrace();
		}
		return flag;
	}

	public boolean existChengji(Chengji chengji)
	{
		ResultSet resultset;
		String s = chengji.getStudentId();
		String s1 = chengji.getCourseId();
		PreparedStatement preparedstatement = con.prepareStatement("select * from chengji where studentId='" + s + "' and courseId='" + s1 + "'");
		resultset = preparedstatement.executeQuery();
		Exception exception;
		return resultset.next();
		exception;
		return false;
	}

	public String addChengji(Chengji chengji)
	{
		PreparedStatement preparedstatement;
		preparedstatement = null;
		String s = "";
		String s2;
		if (existXuesheng(chengji))
			break MISSING_BLOCK_LABEL_23;
		s2 = "notExist";
		return s2;
		if (!existChengji(chengji))
			break MISSING_BLOCK_LABEL_41;
		s2 = "exist";
		return s2;
		String s1;
		try
		{
			preparedstatement = con.prepareStatement("insert into chengji values(?,?,?,?,?)");
			preparedstatement.setString(1, chengji.getStudentId());
			preparedstatement.setString(2, chengji.getCourseId());
			preparedstatement.setString(3, chengji.getTeacher());
			preparedstatement.setInt(4, chengji.getGread());
			preparedstatement.setString(5, chengji.getXueqi());
			preparedstatement.execute();
			s1 = "sucess";
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
			s1 = "failer";
		}
		break MISSING_BLOCK_LABEL_183;
		local;
		try
		{
			preparedstatement.close();
			con.close();
		}
		catch (Exception exception1)
		{
			exception1.printStackTrace();
		}
		JVM INSTR ret 6;
		return s1;
	}

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

	public String updateChengji(Chengji chengji)
	{
		PreparedStatement preparedstatement = null;
		String s = "";
		try
		{
			preparedstatement = con.prepareStatement("update chengji set teacher=?,gread=?,xueqi=? where studentId=? and courseId=?");
			preparedstatement.setString(1, chengji.getTeacher());
			preparedstatement.setInt(2, chengji.getGread());
			preparedstatement.setString(3, chengji.getXueqi());
			preparedstatement.setString(4, chengji.getStudentId());
			preparedstatement.setString(5, chengji.getCourseId());
			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 deleteChengji(String s, String s1)
	{
		PreparedStatement preparedstatement = null;
		String s2 = "";
		try
		{
			preparedstatement = con.prepareStatement("delete from chengji where studentId=? and courseId=?");
			preparedstatement.setString(1, s);
			preparedstatement.setString(2, s1);
			preparedstatement.execute();
			s2 = "sucess";
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
			s2 = "failer";
		}
		finally
		{
			try
			{
				preparedstatement.close();
				con.close();
			}
			catch (Exception exception1)
			{
				exception1.printStackTrace();
			}
		}
		return s2;
	}

	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 ResultSet getCourseName(String s, String s1, String s2)
	{
		Object obj = null;
		ResultSet resultset = null;
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			resultset = statement.executeQuery("select distinct courseName from v_chengji where grade='" + s + "' and stuClass='" + s1 + "' and xueqi='" + s2 + "'");
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		return resultset;
	}

	public ResultSet getChengji(String s, String s1, String s2)
	{
		ResultSet resultset = null;
		Object obj = null;
		String s3 = "{call pro_chengji(?,?,?)}";
		try
		{
			CallableStatement callablestatement = con.prepareCall(s3);
			callablestatement.setString(1, s);
			callablestatement.setString(2, s1);
			callablestatement.setString(3, s2);
			resultset = callablestatement.executeQuery();
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		return resultset;
	}

	public ResultSet getStudent(String s, String s1, String s2)
	{
		Object obj = null;
		ResultSet resultset = null;
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			resultset = statement.executeQuery("select distinct studentId,stuName from v_chengji where grade='" + s + "' and stuClass='" + s1 + "' and xueqi='" + s2 + "'");
		}
		catch (Exception exception)
		{
			exception.printStackTrace();
		}
		return resultset;
	}

	public ResultSet getStudentScore(String s, String s1)
	{
		Object obj = null;
		ResultSet resultset = null;
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			resultset = statement.executeQuery("select score from v_chengji where studentId='" + s + "' and xueqi='" + s1 + "'");
		}
		catch (Exception exception)
		{
			exception.printStackTrace();
		}
		return resultset;
	}

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

	public String getAllClass()
	{
		Object obj = null;
		Object obj1 = null;
		StringBuffer stringbuffer = new StringBuffer();
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			String s;
			for (ResultSet resultset = statement.executeQuery("select distinct className from banji"); resultset.next(); stringbuffer.append("<option value='" + s + "'>" + s + "</option>\n"))
				s = resultset.getString("className");

		}
		catch (SQLException sqlexception)
		{
			return "";
		}
		return stringbuffer.toString();
	}

	public String getAllCourse()
	{
		Object obj = null;
		Object obj1 = null;
		StringBuffer stringbuffer = new StringBuffer();
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			String s;
			String s1;
			for (ResultSet resultset = statement.executeQuery("select courseId,courseName from kecheng"); resultset.next(); stringbuffer.append("<option value='" + s + "'>" + s1 + "</option>\n"))
			{
				s = resultset.getString("courseId");
				s1 = resultset.getString("courseName");
			}

		}
		catch (SQLException sqlexception)
		{
			sqlexception.printStackTrace();
			return "";
		}
		return stringbuffer.toString();
	}

	public String getAllCourseName()
	{
		Object obj = null;
		Object obj1 = null;
		StringBuffer stringbuffer = new StringBuffer();
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			String s;
			for (ResultSet resultset = statement.executeQuery("select courseName from kecheng"); resultset.next(); stringbuffer.append("<option value='" + s + "'>" + s + "</option>\n"))
				s = resultset.getString("courseName");

		}
		catch (SQLException sqlexception)
		{
			sqlexception.printStackTrace();
			return "";
		}
		return stringbuffer.toString();
	}
}