zonghcpingbean.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:   ZonghcpingBean.java

package mypackage;

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

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

public class ZonghcpingBean
{

	private Connection con;

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

	public void addZonghcping(Zonghcping zonghcping)
	{
		PreparedStatement preparedstatement = null;
		try
		{
			preparedstatement = con.prepareStatement("insert into zonghcping values(?,?,?,?,?)");
			preparedstatement.setString(1, zonghcping.getStudentId());
			preparedstatement.setString(2, zonghcping.getXueqi());
			preparedstatement.setInt(3, zonghcping.getZonghpaim());
			preparedstatement.setString(4, zonghcping.getShehuiPractice());
			preparedstatement.setString(5, zonghcping.getXueqipyu());
			preparedstatement.execute();
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		finally
		{
			try
			{
				preparedstatement.close();
				con.close();
			}
			catch (Exception exception1)
			{
				exception1.printStackTrace();
			}
		}
	}

	public void updateZonghcping(Zonghcping zonghcping)
	{
		PreparedStatement preparedstatement = null;
		try
		{
			preparedstatement = con.prepareStatement("update zonghcping set zonghpaim=?,shehuiPractice=?,xueqipyu=? where studentId=? and xueqi=?");
			preparedstatement.setInt(1, zonghcping.getZonghpaim());
			preparedstatement.setString(2, zonghcping.getShehuiPractice());
			preparedstatement.setString(3, zonghcping.getXueqipyu());
			preparedstatement.setString(4, zonghcping.getStudentId());
			preparedstatement.setString(5, zonghcping.getXueqi());
			preparedstatement.execute();
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		finally
		{
			try
			{
				preparedstatement.close();
				con.close();
			}
			catch (Exception exception1)
			{
				exception1.printStackTrace();
			}
		}
	}

	public void deleteZonghcping(String s, String s1)
	{
		PreparedStatement preparedstatement = null;
		try
		{
			preparedstatement = con.prepareStatement("delete from zonghcping where studentId=? and xueqi=?");
			preparedstatement.setString(1, s);
			preparedstatement.setString(2, s1);
			preparedstatement.execute();
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		finally
		{
			try
			{
				preparedstatement.close();
				con.close();
			}
			catch (Exception exception1)
			{
				exception1.printStackTrace();
			}
		}
	}

	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 queryCourseName(String s, String s1, String s2)
	{
		ResultSet resultset = null;
		Object obj = null;
		String s3 = "select distinct courseName from v_chengji where grade='" + s + "' and stuClass='" + s1 + "' and xueqi like '%" + s2 + "%'";
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			resultset = statement.executeQuery(s3);
		}
		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 from v_chengji where grade='" + s + "' and stuClass='" + s1 + "' and xueqi like '%" + 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 like '%" + s1 + "%'");
		}
		catch (Exception exception)
		{
			exception.printStackTrace();
		}
		return resultset;
	}

	public ResultSet getZonghecping(String s, String s1, String s2)
	{
		ResultSet resultset = null;
		Object obj = null;
		String s3 = "{call pro_zonghecping(?,?,?)}";
		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 getStudentTotalScore(String s, String s1)
	{
		Object obj = null;
		ResultSet resultset = null;
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			resultset = statement.executeQuery("select total from v_grade where sno='" + s + "' and xueNian='" + s1 + "'");
		}
		catch (Exception exception)
		{
			exception.printStackTrace();
		}
		return resultset;
	}

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