xinwenbean.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:   XinwenBean.java

package mypackage;

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

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

public class XinwenBean
{

	private Connection con;

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

	public void addXinwen(Xinwen xinwen)
	{
		PreparedStatement preparedstatement = null;
		try
		{
			preparedstatement = con.prepareStatement("insert into xinwen(newsName,newsContent,flag) values(?,?,?)");
			preparedstatement.setString(1, xinwen.getNewsName());
			preparedstatement.setString(2, xinwen.getNewsContent());
			preparedstatement.setString(3, xinwen.getFlag());
			preparedstatement.execute();
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		finally
		{
			try
			{
				preparedstatement.close();
				con.close();
			}
			catch (Exception exception1)
			{
				exception1.printStackTrace();
			}
		}
	}

	public void updateXinwen(Xinwen xinwen)
	{
		PreparedStatement preparedstatement = null;
		try
		{
			preparedstatement = con.prepareStatement("update xinwen set newsName=?,newsContent=? where newsId=?");
			preparedstatement.setString(1, xinwen.getNewsName());
			preparedstatement.setString(2, xinwen.getNewsContent());
			preparedstatement.setInt(3, xinwen.getNewsId());
			preparedstatement.execute();
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		finally
		{
			try
			{
				preparedstatement.close();
				con.close();
			}
			catch (Exception exception1)
			{
				exception1.printStackTrace();
			}
		}
	}

	public void deleteXinwen(int i)
	{
		PreparedStatement preparedstatement = null;
		try
		{
			preparedstatement = con.prepareStatement("delete from xinwen where NewsId=?");
			preparedstatement.setInt(1, i);
			preparedstatement.execute();
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		finally
		{
			try
			{
				preparedstatement.close();
				con.close();
			}
			catch (Exception exception1)
			{
				exception1.printStackTrace();
			}
		}
	}

	public ResultSet campusNews()
	{
		Object obj = null;
		ResultSet resultset = null;
		String s = "select top 6 newsId,newsName,newsTime from xinwen where flag='校园动态新闻' order by newsTime desc ";
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			resultset = statement.executeQuery(s);
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		return resultset;
	}

	public ResultSet studyNews()
	{
		Object obj = null;
		ResultSet resultset = null;
		String s = "select top 7 newsId,newsName,newsTime from xinwen where flag='学习天地新闻' order by newsTime desc";
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			resultset = statement.executeQuery(s);
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		return resultset;
	}

	public ResultSet educationNews()
	{
		Object obj = null;
		ResultSet resultset = null;
		String s = "select top 7 newsId,newsName,newsTime from xinwen where flag='教育新闻' order by newsTime desc";
		try
		{
			Statement statement = con.createStatement(1005, 1008);
			resultset = statement.executeQuery(s);
		}
		catch (SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		return resultset;
	}

	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();
		}
	}
}